This unit reviews database technologies essential for understanding data warehousing, online analytical processing (OLAP) and data mining. Logical and physical design of data warehouses is presented including star schema, snowflake schema, data marts, partitioning and materialised views. Practical issues related to data warehouse construction, such as data extraction from operational databases, data transformation and cleansing and data warehouse support in modern DBMS is covered. The use of data warehouses is illustrated through a study of the OLAP technology including the multidimensional OLAP (MOLAP) and relational OLAP (ROLAP) architecture, OLAP operations and structured query... -- Course Website
Prerequisites: CITS2232 Databases
