Data Dictionary

Share this topic

Data Dictionary

From the book I Am Datapedia!, published here free by the author.

Part of I Am Datapedia!

A Data Dictionary is the next step towards mitigating the Risk of a potential Data Swamp.

‘Data Dictionary comes under Metadata Management.’

In the IT World, we all know that new products and solutions keep coming year by year, so it's very important to capture what has been implemented. A Data Dictionary is one of the most important items for a system's impact analysis as it gives a clear picture of all the elements in the database.

A screen shot of a computer

Description automatically generatedWith the introduction of Big Data where semi and unstructured datasets have come onto surfaces like video, audio, logs, emails, pdf & social media etc., so if one doesn't have a Data Dictionary in place then all future implementations will take 2x-3x more time.

Data Dictionary stores metadata information about databases like.

  • List of all the objects and when each was created or updated.
  • Details like field name, description, data type, length, indexes, primary & foreign keys etc.
  • A picture containing text

Description automatically generatedRelationships between tables, schema(s) and databases etc.
  • Number of records in each table

There are 2 types of Data Dictionaries.

  1. Active Data Dictionary: It's managed within the same database itself so whenever there is a change in the database it is captured automatically.
  2. A screenshot of a computer

Description automatically generatedPassive Data Dictionary: It’s maintained in a separate database or is a manually maintained file with all the above-mentioned information.

‘Normally, technical folks interact with Data Dictionaries.’

Express your reaction

Your Take on This Insight?

Share how this content resonates with you.

Comment
Useful0
Insightful0
Actionable0
Thought-provoking0
Inspiring0

0 reactionsSign in to react or comment

Comments (0)

No comments yet.

    Free account

    You can read every topic without one. A free account lets you react to this topic, comment under it and search the Knowledge Hub. Reacting and commenting need a confirmed e-mail address.