Index Best Practice DBA Road Map

Road Map for Windsor Park near London, England

Home

Ask a Question

Best Practice

Careers

Clients

Data Models

myDBA

Site Map

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

STAGE	BASIC	AVERAGE	IDEAL
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.