Data Warehousing (2 Units; L = 15; P = 45)
Course Content
Introduction to data warehousing- Data warehousing components. Building a data warehouse. Difference between database system and data warehouse. Data warehouse architecture-3 Tier architecture. Warehouse schema design. Data extraction. Cleanup & transformation tools. Multi-dimensional data model. Data cubes- Stars. Snowflakes, Fact constellations. Concept hierarchy. Online analytical processing. Typical OLAP operations. Data Pre-processing: Data Pre-processing, Data cleaning, Data integration and transformation, Data reduction. Discretization and concept hierarchy generation. Data mining primitives. Languages and system architectures. Concept description: Characterization and comparison, Analytical characterization, Mining class comparison.
- Teacher: LMS Admin