Extract

Extract

1. Data Mart

   • • Interactive Reports
     • Ad-hoc Reports
     • Static Reports

2. Data Mart

   • Reporting Analysis/Mining Tools
   • Analytic Application

3. ETL Mode

   • Transaction Databases
     • Operational Systems
   • External Data

4. Meta Data

5. Roll-up

6. Dicing

7. Drill Down

8. Temporal

   • Rollback Database
   • Bitomporal Dtabase
   • Historical Database

9. Spatial

   • GIS
   • Design
     • Physical
     • Logical
     • Conceptual

10. Mobile

    • Application
      • Health
      • Business
      • Sales

11. Pessimistic

    • Hybrid
    • Locking
      • Centralized
        • Primary Copy
          • Distributed
    • Timestamp
      • Basic
        • Multiversion
          • Conservative

12. Optimistic

    • Locking
    • Timestamp

13. Stage

    • • Warehouse
        • • Data Mart

14. Transform

    • Load

15. SQL server

16. DB2

17. Oracle

18. Flat File

Images and files in the map