Data Warehouse—Integrated
Constructed by integrating multiple, heterogeneous data sources
- relational databases, flat files, on-line transaction records
Data cleaning and data integration techniques are applied.
- Ensure consistency in naming conventions, encoding structures, attribute measures, etc. among different data sources
- E.g., Hotel price: currency, tax, breakfast covered, etc.
- When data is moved to the warehouse, it is converted.