Data Dictionary
From the book I Am Datapedia!, published here free by the author.
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.
With 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.
Relationships between tables, schema(s) and databases etc.
- Number of records in each table
There are 2 types of Data Dictionaries.
- Active Data Dictionary: It's managed within the same database itself so whenever there is a change in the database it is captured automatically.
Passive 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.
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.