Data Mining : Data Warehousing and Online Analytical Processing ch4

Data warehouses generalize and consolidate data in multidimensional space. The construction of data warehouses involves data cleaning, data integration, and data transformation, and can be viewed as an important preprocessing step for data mining. In this chapter, we study definition of the data warehouse and see why more and more organizations are building data warehouses for the analysis of their data. In particular, we study the data cube, a multidimensional data model for data warehouses and OLAP, as well as OLAP operations such as roll-up, drilldown, slicing, and dicing.