Database Answers Beautiful Design Pattern from the Asia-Pacific Islander American Studies (Click for Web Site)
Printer Printer-friendly version

Home Ask a Question Best Practice Careers Contact Us Data Models Search Site Map
Design Patterns in Data Modelling   
An Access Database is available on demand.
We might draft a background to this page and here is a Data Warehouse which is an excellent start for answering queries.

You can download our short Paper on Design Patterns in Data Modelling

If you have any comments we would be glad to hear from you.

This page shows three Design Patterns.
The first starts with the Operational Data Store (ODS).
This means that we can apply a simple test to determine whether Data Models exist for all
important Data Sources.
If they do, then we can say that the work has been done to the established standards of Best Practice.

Semantic Building Blocks
The second shows how Semantic Building Blocks provide a 'User Friendly' front-end.
This helps Users to request KPIs, Reports and analyses using words and terminology that they normally use.
For example, talking about Customers, rather than Parties.

Data Mapping Specifications

Finally, we show the complete End-to-End scope of Data Models.
The Common Data Model is used to standardise data that is loaded into the Data Warehouse (DWH).
We can also be sure that we have a 'Single View of the Truth' at any point in time.
It helps us to build the design of the DWH in a step-by-step fashion.

End-to-End Data Model Foundation

Barry Williams
Principal Consultant
Database Answers Ltd.
London, England
March 4th. 2012



© DataBase Answers Ltd. 2011
About Us Contact Us