UNIT-I
Introduction to Data Warehousing: Evolution of Data Warehousing, Data Warehousing concepts, Benefits of Data Warehousing, Comparison of OLTP and Data Warehousing, Problems of Data Warehousing. Architecture: Operational Data and Datastore, Load Manager, Warehouse Manager, Query Manager, Detailed Data, Lightly and Highly summarised Data, Archive/Backup Data, Meta-Data, architecture model, 2-tier, 3-tier and 4tier data warehouse, end user Access tools.
UNIT-II
Tools and Technologies: Extraction, cleaning and Transformation tools, Data Warehouse DBMS, Data Warehouse Meta-Data, Administration and management tools, operational vs. information systems.OLAP & DSS support in data warehouse.
UNIT-III
Types of Distributed Data Warehouses, Nature of development Efforts, Distributed Data Warehouse Development, Building the Warehouse on multiple levels. Knowledge discovery through statistical techniques, Knowledge discovery through neural networks, Fuzzy technology & genetic algorithms.
UNIT-IV
Host based, single stage, LAN based, Multistage, stationary distributed & virtual datawarehouses. Data warehousing Design: Designing Data warehouse Database, Database Design Methodology for Data Warehouses, Data Warehousing design Using Oracle, OLAP and data mining: Online Analytical processing, Data mining.