• 【数仓】元数据和数据字典的区别


    原文:What's the Difference Between Metadata and Data Dictionary? (reference.com)


    Metadata is also known as the System Catalog. It describes how, when and by whom certain data was collected as well as the format and context of the data. A data dictionary is a centralized collection of data information.

    Metadata is used by developers to create programs, procedures, controls and queries to manipulate and manage the data in a database. It is connected with the database management system software and is accessed by the software’s data definition language and data manipulation language compilers. There are two types of metadata: structural metadata, which conveys how the data is set up and stored, and descriptive metadata, which describes the data itself.

    A data dictionary is a structure that stores metadata. It is used to control database operations, integrity and accuracy. It also holds the number of files available in a database, the number of records of every file and information about the fields.

    There are two types of data dictionaries: passive data dictionaries and active data dictionaries. A passive or non-integrated data dictionary is utilized by users, administrators and designers but not by the database management system software. An active or integrated data dictionary is managed automatically by the database management system software.

  • 相关阅读:
    匈牙利算法-二分图的最大匹配
    UOJ 407(IOI2018 D1T3)
    UOJ 460
    UOJ 405(IOI2018 D1T1)
    Codeforces 1110E
    2.文件结构
    1.常用快捷键
    Python3.x和Python2.x的差异
    javascript 常用内置对象
    94. Binary Tree Inorder Traversal(非递归实现二叉树的中序遍历)
  • 原文地址:https://www.cnblogs.com/144823836yj/p/16454096.html
Copyright © 2020-2023  润新知