Data warehouses are used in a wide range of applications for Business executives to perform data analysis and make strategic
In many firms, data warehouses are used as an integral part of a plan-execute-assess “closed-loop” feedback system for enterprise management.
Data warehouses are used extensively in banking and financial services, consumer goods and retail distribution sectors, and controlled manufacturing, such as demand based
Business users need to have the means to know what exists in the data warehouse (through metadata), how to access the contents of the data warehouse, how to examine the contents using analysis tools, and how to present the results of such
There are three kinds of data warehouse applications:
1. Information processing
It supports querying, basic statistical analysis, and reporting using crosstabs, tables, charts, or
A current trend in data warehouse information processing is to construct low-cost Web-based accessing tools that are then integrated with Web browsers
Information processing, based on queries, can find useful However, answers to such queries reflect the information directly stored in databases or computable by aggregate functions.
They do not reflect sophisticated patterns or regularities buried in the Therefore, information processing is not data mining.
2. Analytical processing
It supports basic OLAP operations, including slice-and-dice, drill-down, roll-up, and
It generally operates on historical data in both summarized and detailed
The major strength of on-line analytical processing over information processing is the multidimensional data analysis of data warehouse
It can derive information summarized at multiple granularities from user-specified subsets of a data
3. Data mining
It supports knowledge discovery by finding hidden patterns and associations, constructing analytical models, performing classification and prediction, and presenting the mining results using visualization
It may analyze data existing at more detailed granularities than the summarized data provided in a data warehouse.
It may also analyze transactional, spatial, textual, and multimedia data that are difficult to model with current multidimensional database