UNIT-1 Data Warehousing: Overview, Definition, Data Warehousing Components Building a Data Warehouse, Warehouse Database Mapping the Data Warehouse to a Multiprocessor Architecture Difference between Database System and Data Warehouse Multi Dimensional Data Model Data Cubes, Stars, Snow Flakes, Fact Constellations, Concept. UNIT-2 Warehousing Strategy, Warehouse /management and Support Processes Warehouse Planning and Implementation Hardware and Operating Systems for Data Warehousing Client/Server Computing Model & Data Warehousing Parallel Processors & Cluster Systems, Distributed DBMS implementations Warehousing Software, Warehouse Schema Design UNIT-3 Overview, Motivation, Definition & Functionalities Data Processing, Form of Data Pre-processing Data Cleaning: Missing Values, Noisy Data (Binning, Clustering, Regression, Computer and Human inspection) Inconsistent Data, Data Integration and Transformation Data Reduction:-Data Cube Aggregation, Dimensionality reduction Data Compression, Numerosity Reduction Discretization and Concept hierarchy generation, Decision Tree UNIT-4 Definition, Data Generalization, Analytical Characterization Analysis of attribute relevance, Mining Class comparisons Statistical measures in large Databases, Statistical-Based Algorithms Distance-Based Algorithms, Decision Tree-Based Algorithms. Clustering: Introduction, Similarity and Distance Measures Hierarchical and Partitional Algorithms. Hierarchical Clustering- CURE and Chameleon Density Based Methods DBSCAN, OPTICS. Grid Based Methods- STING CLIQUE. Model Based Method – Statistical Approach Association rules: Introduction, Large Item sets, Basic Algorithms Parallel and Distributed Algorithms, Neural Network approach UNIT-5 Aggregation, Historical information, Query Facility OLAP function and Tools. OLAP Servers, ROLAP, MOLAP, HOLAP Data Mining interface, Security, Backup and Recovery Tuning Data Warehouse, Testing Data Warehouse Warehousing applications and Recent Trends: Types of Warehousing Applications Web Mining, Spatial Mining and Temporal Mining
