Data Warehousing & Data Mining

This book, Data Warehousing and Mining, is a one-time reference that covers all aspects of data warehousing and mining in an easy-tounderstand manner. It covers a variety of topics, such as data warehousing and its benefits; architecture of data warehouse; data mart, data warehousing design strategies, dimensional modeling and features of a good dimensional model; different types of schemas such as star schema, snowflake schema; fact tables and dimension tables; concept of primary key, surrogate keys and foreign keys; ETL process; different types of data extraction such as immediate data extraction and deferred data extraction; Online Analytical Processing (OLAP) and need for online analytical processing etc