Introduction: Data Warehouse Fundamentals: Introduction to Data Warehouse, OLTP Systems; Differences between OLTP Systems and Data Warehouse, Characteristics of Data Warehouse; Functionality of Data Warehouse, Data Warehouse Architecture: Introductions, Components of Data warehouse Architecture; Advantages and Applications of Data Warehouse
Planning and Designing: Data Warehouse Planning and Requirements: Planning Data Warehouse and Key Issues, Data Warehouse development Life Cycle, Dimensional Modeling: Data Warehouse Schemas; Star Schema, Inside Dimensional Table, Inside Fact Table, Snowflake Schema.
Data Warehouse & OLAP: Introduction to OLAP, Characteristics of OLAP, Steps in the OLAP Creation Process, OLAP Architectures; Types of OLAP: MOLAP, ROLAP, HOLAP; Advantages of OLAP; Metadata.
IV Introduction to Data Mining: Scope of Data Mining, Predictive Modeling, Architecture for Data Mining, Data Mining Tools. 07 V Data Mining Techniques: Data Mining Versus Database Management System, Data Mining Techniques:- Association rules, Classification, Regression, Clustering.
- Teacher: Mamta Tiwari