Database Answers We Love our Customers
Printer Printer-friendly version

Home Ask a Question Best Practice Careers Contact Us Data Models Search Site Map
Data Model for Customer Journey Mapping to a Retail Template 
 
An Access Database is available on demand.
I decided on a different approach in early July, 2016


Events in an Agile Customer Journey



Our Canonical Data Model
Logically we want to show a second relationship between Locations and Events but
it doesn't show at the conceptual level so we do not need to change the Model.

Retail Platform Architecture

Logical Canonical Data Model

Physical Canonical Data Model
This is being created using Oracle's Apex Cloud-based Data-as-a-Service

Data Loaded
  • Max Workspace
    Workspace is A13674, user baryw@dba.org, with m123.
  • Transaction Data - Documents, Events, Payments.
  • Master Data - Customers, Locations, Products and Services.
  • Reference Data - Channels, Document Types, Payment Methods.


  • Barry Williams
    Principal Consultant
    Database Answers Ltd.
    London, England
    July 10th. 2016


    © DataBase Answers Ltd. 2016
    Home Ask a Question Best Practice Careers Contact Us Data Models Search Site Map