Data Warehouse Usage
Three kinds of data warehouse applications
- Information processing
- supports querying, basic statistical analysis, and reporting using crosstabs, tables, charts and graphs
- Analytical processing
- multidimensional analysis of data warehouse data
- supports basic OLAP operations, slice-dice, drilling, pivoting
- Data mining
- knowledge discovery from hidden patterns
- supports associations, constructing analytical models, performing classification and prediction, and presenting the mining results using visualization tools.
Differences among the three tasks