Database Answers   Road Map for Windsor Park near London, England
Home Ask a Question Best Practice Careers Clients Data Models myDBA Search Site Map Contact Us
Data Architecture for Best Practice Reference Data Architecture

  Road Map

This is a draft version of the new Database Answers Road Map, which is also available in in Arabic, Chinese and French.

  Stages in the Road Map

There are five Stages and the Information Catalogue in the Road Map
Stage 1 Data Sources and Database Design
Stage 2 Data Integration
Stage 3 Data Marts
Stage 4 BI and Performance Reporting
Stage 5 Data Governance
Stage 6 Information Catalogue

  Self-Assessment Snapshots to determine your Stage and Maturity Level in the Road Map

These Snapshots will help identify the Stage and Maturity you are at
1) Data Sources
Knowledge in the heads of individuals Top 20 Applications known, with list of Data Sources and Owners Agile development with refactoring techniques
  No Data Models and poor documentation of links between code and databases Basic Data Dictionary in place Data Models and sign-off by DBA on all changes
      User access and sign-off for Information Catalogue
2) Data Integration
Ad-hoc integration using bespoke SQL Scripts Some Templates established and comemrcial Tools in use MDM approved, data owner sign-off, Data Quality is an Enterprise Issue
    Software Tools linked to the Information Catalogue Clear and reconciled top-down and bottom-up views of data
      Data Architectures and Data Models for Sources and Targets
  Nobody understands Master Data Management (MDM) MDM is planned MDM is in place
2) Data Quality
   DQ Level -
Could be improved Sufficient Accurate, valid and relevant
   DQ Policy -
Under consideration Under implementation Established as an Enterprise Issue
3) Data Marts
No understanding of Data Marts One Data Mart in place for a limited range of Reports Generic and Specific Data Marts designed and in place
4) BI+Perf Rpts
One-off, often independent Reports, with Departmental spreadsheets Independent Maps, KPIs and rill-down to detailed Reports Integrated Maps, KPIs and drill-down for senior management
4b) Internet Mashups
None Isolated developed Users aware
5) Data Governance
None No End-to-End agreeement Procedures published, Roles and Responsibilities agreed and Sign-off in place
Information Catalogue
None Records major Applications, Databases,Tables, Attributes and so on. Online Catalogue used to control and track all changes.
Home Ask a Question Best Practice Careers Clients Data Models myDBA Search Site Map Contact Us