Data Warehouse Applications

Three types of DW application.

DW is the basis of these applications.

1.Information processing

The information can be processed by means of Querying,basic statiscal analysis,reporting using crosstabs,charts or graphs.

2.OLAP

The data can be analysed by means of basic OLAP operations,including Slice,dice,drill down/upn and pivoting.

Need to is compared with OLTP.

3.DM (Data Mining)

By finding the hidden patterns and associations,constructing analytical models,performing Classification and prediction.

DM can is furthur and deeper use of DW and OLAP can ' t replace the DM.

Data Warehouse Applications