Data Dictionary in DBMS

DBMS for GATE Exams

178 Lectures 14.5 hours

Arnab Chakraborty

More Detail

DBMS in Simple Steps

194 Lectures 16 hours

Arnab Chakraborty

More Detail

Data Dictionary consists of database metadata. It has records about objects in the database.

What Data Dictionary consists of

Data Dictionary consists of the following information −

• Name of the tables in the database
• Constraints of a table i.e. keys, relationships, etc.
• Columns of the tables that related to each other
• Owner of the table
• Last accessed information of the object
• Last updated information of the object

An example of Data Dictionary can be personal details of a student −

Example

<StudentPersonalDetails>

The following is the data dictionary for the above fields −

Types of Data Dictionary

Here are the two types of data dictionary −

Active Data Dictionary

The DBMS software manages the active data dictionary automatically. The modification is an automatic task and most RDBMS has active data dictionary. It is also known as integrated data dictionary.

Passive Data Dictionary

Managed by the users and is modified manually when the database structure change. Also known as non-integrated data dictionary.

Alex Onsman

Updated on 15-Jun-2020 13:13:49

• Related Questions & Answers
• What is the data Dictionary or metadata in DBMS?
• Data Independence in DBMS
• Data Definition Commands in DBMS
• Data Manipulation Commands in DBMS
• Dictionary Data Structure in Javascript
• Dictionary Operations in Data Structure
• Dictionary Data Type in Python
• What is Data Dictionary
• What is Data Independence in DBMS?
• What is data Abstraction in DBMS?
• What is a Data Model in DBMS?
• Explain the object oriented data model in DBMS?
• How to generate a data model from data dictionary tables in Oracle?
• What is the difference between data and information in DBMS?
• Add new column in Pandas Data Frame Using a Dictionary