8.14 Data Warehouse Day31

---note---

Database Warehouse:

1. Theme-oriented

2. Data integration (cleanup)

3. Time-variant of the database

4. The non-volatile nature of data

5. Support decision-making system

Data Warehouse using parallel structure

Adopt a new query optimization strategy and index structure

Database warehouse conceptual model (data warehouse is stored as metadata)

1. Conceptual Data Model

Logical model (intermediate type)

Performance issues:

1. Merging tables

2. Set up data series

3. Introduction of redundancy

4. Physical partitioning of tables

5. Generate Export Data

6. Establishing Generalized indexes

Four types of metadata

Metadata for the data source

Metadata about the data model

About metadata for Data Warehouse mappings

About metadata used by the Data Warehouse

The role of Meta data

Improved interaction with the system

Improve data quality

Support System Integration

Support system analysis, design and maintenance

Increased flexibility

---note---

8.14 Data Warehouse Day31