I would like to provide a data architecture summary briefly. Additionally, it reflects my long-term working practices in this area.
Data Architecture and Governance:
- Data governance involves strategies, policies, processes and procedures, collaboration, tools, audit and metrics, etc. For detail info, please refer to Seven Steps to Effective Data Governance.
- Data quality includes data validation, foreign keys, constraints and data cleansing. Please refer to 10 Best Practices in Database Schema Design.
- Metadata management involves schema design, data linage, API contracts, etc. Building a Database-driven Application Framework includes good references.
- Toolbox: MS Purview, Ataccama, Denodo
Data Modeling:
- UML: describe the relationship among objects, no emphasize o...