How do you go about creating an enterprise data dictionary?
The purpose of an enterprise data dictionary is to capture metadata about the data used within the enterprise. The best place to start is with some type of metadata management system (dictionary, repository, etc) that allows you to capture information about your data. This system should allow you to import metadata from numerous sources, including DBMS system tables, schemas, documents, etc. The system should also give you tools that enable you to analyze and compare the metadata you've captured and to document affinities and semantic relationships.
Be aware -- it's a lot of hard work. These steps are similar to the ones required to define master data or to implement a good data integration strategy.
Dig Deeper on Topics Archive
Related Q&A from Anne Thomas Manes
Anne Thomas Manes explains the differences between open source clients and open source implementations. Continue Reading
Anne Thomas Manes explains the difference between 'hard' real time and 'live' real time systems. Continue Reading
Anne Thomas Manes provides a list of open source UDDI implementations and open source UDDI client projects, but explains why there aren't any good ... Continue Reading