Databases Reference
In-Depth Information
3
Metadata Management
and Data Go vernance
Michael Schrader
CONTENTS
What Is Governance? ...................................................................................... 44
Why Governance? ........................................................................................... 44
Fit for Purpose versus Single Version of the Truth ......................................45
Governance Board ............................................................................................47
Program versus Project Governance .............................................................47
Metadata Framework Defined ........................................................................47
Metadata Types ................................................................................................ 48
Business Metadata ...................................................................................... 48
Searchable ................................................................................................49
Easy to Access and Integrated ...............................................................50
Exposed ....................................................................................................50
Technical Metadata......................................................................................50
Process Metadata .........................................................................................51
Data Lineage ............................................................................................52
Impact Analysis .......................................................................................52
Operational Metadata .................................................................................53
Case Study of Metadata Use for Data Governance ......................................53
Master Data Management .............................................................................. 54
Metadata Repository Types .............................................................................55
Data Profiling: Investigation and Enforcement ........................................... 56
Data Life Cycle ..................................................................................................58
Data Retention Techniques .............................................................................59
Data Versioning ............................................................................................... 60
Data Versioning Techniques ..................................................................... 60
Star Dimensional Model Data Versioning .......................................... 60
Third Normal Form Data Versioning ..................................................63
43
Search WWH ::




Custom Search