Recent developments in Data Warehousing

Question 1

data warehousing=

Answer 1

collection of data created to support decision making and analysing data

Question 2

4 data warehouse characteristics

Answer 2

1. subject oriented (specific subjects: customers, sales, products)
2. Integrated (collected from multiple systems)
3. time variant (maintains historical data)
4. Nonvolatile (users cannot change data)

Question 3

Enterprise Data Warehouse Approach (top-down)

Answer 3

• Centralized, company-wide data storage
  ○Ensures high data consistency but longer implementation time
• for large firms with complex data

Question 4

Data mart strategy (bottom-up)

Answer 4

Smaller, department-specific data stores
- Faster implementation, but risks data inconsistency
- smaller firms, that require quick implementation

Question 5

challenges in Data Warehousing

Answer 5

ETL (extraction, transformation, loading) complexity - costly and difficult
Data quality issues

Question 6

case study Harrahs

Answer 6

used data warehousing (WINET)
for collecting data to: personalise marketing and customer loyalty