Database Answers A Semantic Common Data Model
Printer Printer-friendly version

Home Ask a Question Best Practice Careers Contact Us Data Models Search Site Map
Semantic Bulding Blocks   

You can check out the background to this page.
A Semantic Data Model shows how a business user is likely to think about the data and the 'Things of Interest'.

For example, a Data Modeller will typically think about a Party whereas a User will think about a Customer.
In a similar way, an Address might be a user-friendly way of thinking about a Geographic Area and a Payment might correspond to a Financial Transaction.

The concept of Building Blocks also applies to Plug-and-Play Generic Components, such as a Data Warehouse, and the Data Model on the right shows a classic example.
The idea of Generic Components started us thinking about Generic Data Models that can provide us with Design Patterns.

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

This Semantic Data Model includes Customers, Addresses and Payments :-

Semantic Data Model for Customer, Addresses and Payments
This is a 'traditional' Data Warehouse for Customer Purchases :-

Customers and Purchases Data Warehouse

Barry Williams
Principal Consultant
Database Answers Ltd.
London, England
February 5th. 2012 (Superbowl Sunday !!!)

© DataBase Answers Ltd. 2011
About Us Contact Us