Purpose
A Data Dictionary is used to standardize a definition of a data element and enable a common interpretation of data elements.
Business Analysis Body of Knowledge® (BABOK®)
The term data dictionary is defined as the centralized repository of information about data such as meaning, relationship with other data, usage, and format. It indicate the general software utility than a catalogue. It provides the information stored regarding the data and allow the software to access the various modules of data. The software package of a stand alone data dictionary interact with the software modules and it is used by the designers, users, and administrators of the computer system for information resource management. It will maintain the information of data on system hardware and software configuration, documentation, application, and users as well as other information relevant to system administration. The data dictionary is updated first and as a result the changes are updated automatically.
Data dictionary are sometimes referred to as a meta data repositories and are used to manage the data within the context of the solution. It is used to document standard definition of data elements, their meanings, and allowable values. As many organizations adopt data mining and more advanced analytic, a data dictionary provide the meta data required in the complex scenarios of the business. The data dictionary contains the definition of each data element and indicate how those elements combine into composite data elements. It is often used in conjunction with an entity relationship diagram and the data are extracted from the data model. It is used to standardize the data elements and their meanings between the solutions and the stakeholders.
Some of the articles related to Data Dictionary techniques are as follows,
- Data Dictionary -
https://db.grussell.org/resources/pdf/Data%20Dictionary.pdf
- Oracle Data Dictionary - http://www.baskent.edu.tr/~tkaracay/etudio/ders/dbase/sql/pdfSQL/DataDictionary.pdf
- Overview of Data Dictionary - https://www.sciencedirect.com/topics/computer-science/data-dictionary
- Types of Data Dictionary - https://www.tutorialcup.com/dbms/data-dictionary.htm
- Management of Data Dictionary - https://www.usgs.gov/products/data-and-tools/data-management/data-dictionaries
- Survey in Data Dictionary - https://yourexperience.ie/wp-content/uploads/2019/07/NPE_Survey_DataDictionary.pdf
- ABAP Data Dictionary - https://s3-eu-west-1.amazonaws.com/gxmedia.galileo-press.de/leseproben/2540/sappress_abap_data_dictionary.pdf
- CRF Data Dictionary - https://www.cdc.gov/coronavirus/2019-ncov/downloads/data-dictionary.pdf
- SAP in Data Dictionary - https://www.tutorialkart.com/sap-abap/sap-abap-data-dictionary/
- Difference between Data Dictionary and Repository - https://www.stechies.com/difference-bw-data-dictionary-data-repository/
- Data Dictionary Standards - https://health.wyo.gov/wp-content/uploads/2019/01/NTDS_Data_Dictionary_2019.pdf
- Terminology in Data Dictionary - https://dataedo.com/kb/data-glossary/what-is-data-dictionary
- Uses of Data Dictionary - https://searchapparchitecture.techtarget.com/definition/data-dictionary
- Knowledge in Data Dictionary - https://www.ukmed.ac.uk/documents/UKMED_data_dictionary.pdf
The data dictionary can be manually created by using the data element and the information are provided. The template contains the name of the data, alias name of data, value of elements, and the detailed description of the data element. The main elements of data dictionary are primitive data and composite data elements. It will describe the data element characteristics including the description of data element in the form of definition that will be used by the stakeholders. The composite data elements consists of the sequences, repetitions, and optional elements.
Advantages of using Data Dictionary are,
- It will provide all the stakeholders with the shared understanding of the format and the content of relevant information.
- A single repository of corporate meta data promotes the use of data throughout the organization in a consistent manner.
Some of the books for Data Dictionary techniques,
- Dictionary of Data Management | Dama | https://www.amazon.com/DAMA-Dictionary-Data-Management-Professionals/dp/1935504126/ref=sr_1_1?dchild=1&keywords=data+dictionary+books&qid=1591781655&sr=8-1
- The Data Dictionary Book | Sydney E. Berger | https://www.amazon.com/Dictionary-Book-Collectors-Booksellers-Librarians-ebook/dp/B01M0G9LQ4/ref=sr_1_3?dchild=1&keywords=data+dictionary+books&qid=1591781763&sr=8-3
- Codes and Modular Form of Data Dictionary | Minijia Shi | https://www.amazon.com/Minjia-Shi/dp/9811212910/ref=sr_1_11?dchild=1&keywords=data+dictionary+books&qid=1591781763&sr=8-11
- Architecture of Data Dictionary | Cyril Harris | https://www.amazon.com/Dictionary-Architecture-Construction/dp/0071452370/ref=sr_1_25?dchild=1&keywords=data+dictionary+books&qid=1591781763&sr=8-25
- Data Dictionary for Library and Information Science | Joan Reitz | https://www.amazon.com/Dictionary-Library-Information-Science-Reitz/dp/1591580757/ref=sr_1_35?dchild=1&keywords=data+dictionary+books&qid=1591782047&sr=8-35
- An Illustrated Data Dictionary of Information Systems | Tasha Wade | https://www.amazon.com/GIS-Illustrated-Dictionary-Geographic-Information/dp/1589481402/ref=sr_1_49?dchild=1&keywords=data+dictionary+books&qid=1591782147&sr=8-49
- Best Research Methods for Data Dictionary | Ronald R. Powell | https://www.amazon.com/Research-Methods-Librarians-Library-Information/dp/1591588650/ref=sr_1_54?dchild=1&keywords=data+dictionary+books&qid=1591782147&sr=8-54
- Frequency in Data Dictionary | Sabine Fielder | https://www.amazon.com/Frequency-Dictionary-Vietnamese/dp/3960231857/ref=sr_1_56?dchild=1&keywords=data+dictionary+books&qid=1591782147&sr=8-56
