When documenting a database as part of a data governance initiative, it is important to browse the business glossary and classify data modeling assets against it. Here are the steps to follow:
- Understand the business glossary: Start by understanding the business glossary, which is a set of terms and definitions used in the organization. This glossary often includes definitions of data entities, attributes, and relationships.
- Browse the business glossary: Browse the business glossary to identify relevant terms and definitions that apply to the database being documented. This will help to ensure that one aligns the database with the organization’s definitions and standards.
- Classify data modeling assets: Classify the data modeling assets against the business glossary by identifying the entities, attributes, and relationships that correspond to the terms and definitions in the glossary. This will help to ensure that one structures the database in a way that aligns with the organization’s standards.
- Document the classification: Document how one classified the data modeling assets against the business glossary to ensure that it is understandable. This documentation should include all relevant terms and definitions, as well as any specific information about the data model.
- Validate the classification: Validate the classification to ensure that it represents the relationship between the data modeling assets and the business glossary. This will help to ensure that the data governance initiative is effective in ensuring that one aligned the database with the standards of the organization.
This will help to ensure that the data governance initiative is effective in achieving its goals.
Watch this video to discover how to document a database as part of a data governance initiative, including browsing the business glossary within ER/Studio and classifying data modeling assets against the business glossary.
Learn how to reverse engineer a database then document the physical model with business friendly metadata using IDERA’s ER/Studio in this video series:
Part 1: Documenting a Database with ER/Studio – Overview
Part 2: Document a Database As Part of a Localized Initiative with ER/Studio
Part 3: Document a Database As Part of a Broader Data Modeling Initiative with ER/Studio
Part 4: Document a Database As Part of a Data Governance Initiative with ER/Studio
