If you are new to Data Models, this page of my new Tutorial will help you understand the Data Model.
This diagram shows the two important Data Layers of Business Intelligence and Operational Data.
Another diagram shows the Data Layers and some representative Entities in the Operational Data Layer.
Here’s the Apex specs the POC Conceptual Model BI on the Beach for Retail Customers and an End-2-End View
Apex Specs
This table shows how the Entities in the Canonical Data Model map onto the Canonical Model for Retail Customers.
Note that we have combined Roles with Organisations and People for simplicity.
This follows the design of our POC Cloud Reference Data Architecture.
Nr. | Canonical Data Model | Retail Customers |
1 | Assets | Stores |
2 | Documents | Invoices, Sales Receipts |
3 | Events | Customer Purchase, Print Sales Receipt |
4 | Locations | Stores |
5 | Organisations | Suppliers |
6 | People | Customers, Staff |
7 | Products / Services | Products |
8 | Suppliers | Suppliers |
Retail Sales XML Demo for Notre Dame
IBM offers a Retail Data Warehouse.
Oracle also offers a Generic Retail Model, which is compliant with the US Association for Retail technology Standards (‘ARTS’) Industry-standard Model.
Leave a comment