A data dictionary contains metadata i.e data about the database. The data dictionary is very important as it contains information such as what is in the database, who is allowed to access it, where is the database physically stored etc. The users of the database normally don't interact with the data dictionary, it is only handled by the database administrators.
The data dictionary in general contains information about the following −
This is a data dictionary describing a table that contains employee details.
|Field Name||Data Type||Field Size for display||Description||Example|
|Integer||10||Unique ID of each employee||1645000001|
|Name||Text||20||Name of the employee||David Heston|
|Date of Birth||Date/Time||10||DOB of Employee||08/03/1995|
|Phone Number||Integer||10||Phone number of employee||6583648648|
The different types of data dictionary are −
If the structure of the database or its specifications change at any point of time, it should be reflected in the data dictionary. This is the responsibility of the database management system in which the data dictionary resides.
So, the data dictionary is automatically updated by the database management system when any changes are made in the database. This is known as an active data dictionary as it is self updating.
This is not as useful or easy to handle as an active data dictionary. A passive data dictionary is maintained separately to the database whose contents are stored in the dictionary. That means that if the database is modified the database dictionary is not automatically updated as in the case of Active Data Dictionary.
So, the passive data dictionary has to be manually updated to match the database. This needs careful handling or else the database and data dictionary are out of sync.