Database Answers

Home Ask a Question Careers Contact us Data Models First Timers Search Site Map

  Steps in the Base Data Layer
 
These are draft Steps in the Base Data Layer - Data Sources, ERL and Consolidation.
These include specification of the Generic Consolidated Data Model.


STEP
DESCRIPTION
TEMPLATES
1 Identify the Data Sources.  
2 Identify the Owners of the Data Sources.  
3
Choose a Data Feed and create a Schema using Schema Logic,

(to be confirmed with Carole and Andrei).
3.1 Sample Schema for Hotel Bookings
	
4
Choose the Generic Consolidated Data Model,(GCDM).
4.1 DBA Generic Customer Data Model
4.2 Parties and Products Data Model
4.3 IBM Financial Services Data Model
4.4 FTI StreetModel
5
Map the Data Sources to the GCDM.
5.1 Schema Logic
5.2 ToBeDetermined
5.3 ToBeDetermined
6
Choose the Data Warehouse Model.
6.1 DBA Financial Star DW
6.2 DBA Financial Snowflake DW
6.3 DBA Visits Data Warehouse
6.4 IBM Banking Data Warehouse
7
Map the GCDM to the DW.
7.1 Schema Logic
7.2 ToBeDetermined
7.3 ToBeDetermined
8
Choose the Data Marts Model.
8.1 IBM Banking Data Marts/Templates
8.2 Business Objects
9
Map the DW to the Data Marts.
9.1 Schema Logic
9.2 ToBeDetermined
9.3 ToBeDetermined

 

Home Ask a Question Careers Contact us Data Models First Timers Search Site Map