Population, and especially maintenance, can be a nightmareĭata Dictionary in Excel spreadsheet 2.But the maintenance is the hard part - making sure it's up to date with the source can be a laborious task. Those are generic tools for creating and collaborating on documents that most people are familiar with.Ĭreating a data dictionary can be as easy as extracting a list of columns from a database using a query and pasting the results into a spreadsheet for people to fill in the details. I think the most obvious tool, perhaps good for a proof of concept, is a spreadsheet software or word processor (preferably the former). In this article, I will present you with different types of tools that you can use to build and share such an inventory. A data dictionary is a definition of tables/files and columns/fields in a data set (database, data warehouse or data lake). Now, when accessing company data held in databases is becoming critical, organizations are looking for tools that will allow them to build and share data dictionary of their data sources.
0 Comments
Leave a Reply. |