Data Warehousing

Data Warehousing

1. Data produced to support decision making

2. Conduct business processes

3. Characteristics

   • Subject oriented
   • Integrated
   • Time variant
   • Nonvolatile
   • Web based
   • Relational/multidimensional
   • Client/server
   • Real time
   • Include metadata

4. Discipline that results in applications

   • provide
   • decision support capability
   • allows
     • access to business information
   • creates
     • business insight

5. main types

   • Data marts
     • Focuses on particular subject or department
   • Operational Data Stores
     • Used on short term decisions
   • Enterprise data warehouses
     • Used across the enterprise for decision support

6. Application Cases

   • A Better Data Plan: Well-Established TELCOs Leverage Data Warehousing and Analytics to Stay on Top in a Competitive Industry
   • Data Warehousing Helps MultiCare Save More Lives
   • BP Lubricants Achieves BIGS Success
   • Things Go Better with Coke’s Data Warehouse
   • Starwood Hotels & Resorts Manages Hotel Profitability with Data Warehousing
   • EDW Helps Connect State Agencies in Michigan
   • Egg Plc Fries the Competition in Near Real Time

7. main concerns

   • Privacy
   • Security

8. Subjects that will play a significant role in the future

   • Web, social media, and Big Data
   • Open source software
   • SaaS
   • Cloud computing