DATAWAREHOUSE ARCHITECTURE

DATAWAREHOUSE ARCHITECTURE

1. METADATA

   • QUERY TOOLS
   • DATA LOAD FUNCTION
   • APPLICATION
   • EXTRACTION TOOLS
   • OLAP TOOLS
   • REPOSITORY
     • BUISNESS METADATA
       • DATA OWNERSHIP INFORMATION
       • BUISNESS DEFINITION
       • CHANGING POLICIES
     • OPERATIONAL METADATA
       • DATA LINEAGE
       • CURRENCY OF DATA
     • ALGORITHM FOR SUMMARIZATION

2. DATA SOURCE LAYER

   • RELATIONAL DATABASE
   • LEGACY DATA
   • PURCHASED DATA
   • ERP SYSTEMS

3. DATA EXTRACTION LAYER

   • DATA CLEANSING
   • STAGING AREA

4. ETL LAYER

   • EXTRACT
   • TRANSFORM
   • LOAD

5. DATA STORAGE LAYER

   • OPERATIONAL DATA STORE
   • DATA WAREHOUSE
   • DATA MART

6. DATA LOGIC LAYER

   • BUISNESS RULES

7. DATA PRESENTATION LAYER

   • DATA
   • FORMAT
     • TABULAR
     • GRAPHICAL REPORT
     • EMAILED REPORT