Data Dictionary

Posted in Information Technology & Systems, Total Reads: 1186

Definition: Data Dictionary

A centralized repository of information about the basic organization of a database and data such as meaning, origin, usage, relationship with other data, and format is called a data dictionary. Basically, a data dictionary defines the structure of the database itself. It also refers to other description about databases or a collection of databases.  It does not contain any of the actual data from the database, but only data necessary for managing it.

Data dictionary essentially stores metadata - something that stores data about data.

A data dictionary is essentially of two types – active and passive

  • Active Data Dictionary is essentially that which updates itself in real time as changes are made to the database.
  • Passive Data Dictionary is a data dictionary which does not update itself with the changes. It is generally used by designers or administrators.

Some of the data stored by the data dictionary includes:

-  Name

-  Description

-  Frequency of use

-  Characteristics

-  Access rights

Search & Explore : Management Dictionary

Browse the definition and meaning of more terms similar to Data Dictionary. The Management Dictionary covers over 7000 business concepts from 6 categories.


Share this Page on: