Data Warehousing
Data Warehouse: Data warehouse is a subject-oriented, integrated, time-variant, and nonvolatile collection of data in support of management’s decision-making process. [ Bill W. H. Inmon ]. Data warehousing : Data warehousing is a collection of decision support technologies, aimed at enabling the knowledge worker to make better decisions. Requirements of a Data Warehouse system Efficient cube computation, Better access methods, Efficient query processing. In this tutorial, we will learn about the following concepts. DATA WAREHOUSING Data Warehouse, Operational Database Systems versus Data Warehouses, A Multi tired Architecture, A Multidimensional Data Model, Stars, Snowflakes and Fact Constellations: Schemas, Role of Concept hierarchies, Measures, OLAP Operations, From online Analytical processing to Multidimensional Data Mining, Indexing OLAP Data. DATA MINING Introduction ...