Data warehousing

Data warehousing

1. Characteristics

   • Subject oriented
     • Organized by detailed subject
   • Integrated
     • Data from diferent sources into a consistent format
   • Time variant
     • A warehouse maintains historical data
   • Nonvolatile
     • User cannot change or update the data
   • Additional characteristics
     • Web based
       • Designed for web-based applications
     • Relational/multidimensional
       • Relational or multidimensional sctructure
     • Client/Server
       • Used to provide easy access for EU
     • Real time
       • Provide real-time data access
     • Include metadata
       • Contains data about how the data are organized
       • Metadata
         • Describe the structure of and some meaning about data, thereby contributing to their effective or ineffective use

2. Data mart

   • Smaller than a data warehouse and focuses on a particular subject or department
     • Dependent
       • Subset that is created directly from the Data Warehouse
     • Independent
       • It´s source is not an EDW

3. Operational Data Store

   • Provides recent form of customer information file

4. Enterprise Data Warehouses

   • Large-scale data warehouse that is used across the enterprise for decision support

5. Key Benefits

   • Reduced Infrastructure Expense
     • 2/3 cost reduction through data mart consolidation
   • Reduced Warranty Expense
     • Improved rembursement accuracy through improved claim data quality
   • Improved Cost of Quality
     • Faster identification, priorization and resolution of quality issues
   • Accurate Environmental Performance
   • IT Arquitecture Standarization
     • One strategic platform for BI and compliance reporting

6. Process

   • Data sources
     • Mutiple independent operational systems
   • Extraction and transformation
     • Data integration
       • ETL
       • EAI
       • SOA
       • EII
   • Loading
     • Loaded into a staging area, where they are transformed
   • Comprensive database
     • EDW to support all decision analysis
   • Metadata
   • Middleware tootls
     • Enable access to the data warehouse

7. Architecture

   • Independent Data Marts
   • Data Mart Bus
   • Hub-and.spoke
   • Centralized
   • Federated

8. Analysis

   • OLAP
     • Slice
     • Dice
     • Drill Down/Up
     • Roll-up
     • Pivot
   • OLTP