Data Warehousing and Data Mining

Details of the course ↓

Unit No.

CONTENT

1

Unit 1 ⇗:

  • Introduction to Data Warehousing, Concept of Data Warehouse, DBMS verses data warehouse, Data Marts, Metadata, Multidimensional data model, Multidimensional database,  Data warehouse Measures, their categorization and computation, Multi-dimensional database hierarchies.

2

Unit 2 ⇗:

  • Data Warehouse Architecture, Operations in OLAP,Advantages of OLAP over OLTP,Three-Tier Data Warehouse architecture, OLAP Guidelines, Multidimensional versus Multirelational OLAP , Categories of Tools, OLAP Tools and the Internet.