Data Warehousing

Data Warehousing is designed to serve as a textbook for students of Computer Science & Engineering (BE/Btech), computer applications (BCA/MCA) and computer science (B.Sc) for an introductory course on Data Warehousing. It provides a thorough understanding of the fundamentals of Data Warehousing and aims to impart a sound knowledge to users for creating and managing a Data Warehouse. The book introduces the various features and architecture of a Data Warehouse followed by a detailed study of the Business Requirements and Dimensional Modelling. It goes on to discuss the components of a Data Warehouse and thereby leads up to the core area of the subject by providing a thorough understanding of the building and maintenance of a Data Warehouse. This is then followed up by an overview of planning and project management, testing and growth and then finishing with Data Warehouse solutions and the latest trends in this field. The book is finally rounded off with a broad overview of its related field of study, Data Mining. The text is ably supported by plenty of examples to illustrate cocepts and contains several review questions and other end-chapter exercises to test the understanding of students. The book also carries a running case study that aims to bring out the practical aspects of the subject. This will be useful for students to master the basics and apply them to real-life scenario.

1 - The Compelling Need for Data Warehousing
2 - Data Warehouse: Defining Features
3 - Physical Architecture of a Data Warehouse and Data Mart Issues
4 - Gathering the Business Requirements
5 - Planning and Project Management In A Data Warehouse
6 - Data Warehouse Schema
7 - Fact Tables and Dimension Tables: Miscellaneous Issues
8 - THE ETL PROCESS
9 - Testing, Growth and Maintenance Of Data Warehouse
10 - OLAP in the Data Warehouse
11 - Overview of Building and Maintaining A Data Warehouse
12 - Data Mining Basics
13 - Moving into Data Mining
14 - Trends In Data Warehousing

Reema Thareja was until recently working as an IT Lecturer at the Institute of Information and Technology, an affiliate of GGS Indraprastha University, New Delhi. She has completed her MCA from the same University and specializes in Programming Languages, OS, DBMS, Multimedia and Web Technologies.