Introduction to Data Lineage, Data Governance and Data Dictionary Use Cases and Application

Whats' data governance?

Simply put, data management is the management of the life cycle of data, and managers need to ensure that the data remains high quality (i.e. accurate and complete) throughout the life cycle.

What is data lineage?

The relationship of data to databases and applications is called data lineage.

Introduction to Data Lineage, Data Governance and Data Dictionary Use Cases and Application
  1. Link Biz Terms (business friendly set of terms) to IT metadata;
  2. Example: Linking Business Glossary (a dictionary with different terms) to Technical Metadata (a dictionary describing the schema of the data).
Introduction to Data Lineage, Data Governance and Data Dictionary Use Cases and Application
  1. Connect Data Fields to Source DB/ App Column;
  2. Examples include the Schema that connects the Reporting Dashboard’s Data Field to the Database.
Introduction to Data Lineage, Data Governance and Data Dictionary Use Cases and Application
  1. Link Biz Terms (Business Friendly Set of Terms) to Reporting Fields;
  2. Examples include reporting fields, which link the Business Glossary (a dictionary containing different terms) to BI Dashboard.

Data Dictionary Application and Use Case

Data dictionary is a platform that stores these data lineages, and presents vertical lineage, horizontal lineage and business lineage to facilitate data governance.

Introduction to Data Lineage, Data Governance and Data Dictionary

Conclusion

Thank you for reading my ariticle and I hope you’ve enjoyed it. If you want to know more about data lineage, data governance and data dictionary, you can visit Gudu SQLFlow for more information. As a data lineage analysis tool, Gudu SQLFlow, can not only analyze SQL script files, obtain data lineage, and perform visual display, but also allow users to provide data lineage in CSV format and perform visual display.

--

--

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store