Database Answers Cars in Rows (Click for Renaissance Innovator Website)
Printer Printer-friendly version

Home Ask a Question Best Practice Careers Contact Us Data Models Search Site Map
Data Model for Master-Data-in-the-Clouds 
An Access Database is available.

If you are new to Data Models, this page of my new Tutorial will help you understand the Data Model.
There might also be a design for a Data Mart, which is very useful for providng data for Reports and Business Intelligence.



1) Overview - Validate Ref Data


2) Detail - User Login, Governance and Reference Data


Phase 3) Getting Started (Yellow)




Phase 4) Additional Features (Green)




Phase 5) Final Features (Blue)




Below here we show some background Thinking.


1) User Test Scenario
Here we show the process of adding 'Smartphone' as a new 
Payment Methods Reference Data.  


2) Test Data
This table is for the Proof of Concept.





1) User Test Scenario
Here we show the process of adding 'Smartphone' as a new 
Payment Methods Reference Data.

2) Test Data
This table is for the Proof of Concept.


3) Governance and Reference Data






Overview - User Login, Governance and Reference Data


Phase 1) Getting Started (Yellow)




Phase 2) Additional Features (Green)




Phase 3) Final Features (Blue)






Here we show some background Thinking.


1) User Test Scenario
Here we show the process of adding 'Smartphone' as a new 
Payment Methods Reference Data.  


2) Test Data
This table is for the Proof of Concept.



4) Reference Data Flow Chart
This shows how Users can create their own sets of Reference Data.


Getting Started :-
  • Step 1 : Appoint Data steward(s)
  • Step 2 : Define Data Quality Criteria
  • Step 3 : Check Data Quality
  • Step 4 : Define minimum standards
  • Step 5 : Establish a Timetable to achieve minimum standards
  • Step 6 : Setup an agreed Plan to achieve the Timetable
    Here we have Templates for :-
  • Org Charts from Tutor2U
  • Product Catalog
  • Wine Lists from XLTemplates.

  • 5) Here is a Framework for Digital Initiatives
    It provides a vehicle for communication between Business Users and the Data Community.


    Potential vendors of Data Governance Solutions
    include (alphabetically):-
  • Attacama
  • Collibra
  • Oracle (Master Data Governance)
  • Orion

  • 6) Getting Started
    3.1 Establish a Steering Group
    3.2 Review the Framework for Digital Initiatives
    3.3 Agree the scope of the Conceptual Model
  • Master Data
  • Data Sources
    6. Determine the Priorities -
  • Data Dictionary
  • Data Governance
  • Data Stewards
  • Barry Williams Principal Consultant Database Answers Ltd. London, England December 17th. 2017
    © Database Answers Ltd. 2017