Skip to content
Curtin University
Courses Handbook 2011

This handbook contains information for courses and units at Curtin in 2011.
Information for current year courses and units is available at Courses Handbook 2010.

311507 (v.1) Advanced Databases CITS4243 (UWA)

Note

Tutition Patterns

The tuition pattern below provides details of the types of classes and their duration. This is to be used as a guide only. For more precise information please check your unit outline.

Unit references, texts and outcomes

To ensure that the most up-to-date information about unit references, texts and outcomes appears, they will be provided in your unit outline prior to commencement.

Area: Cross Institutional Enrolments Office (Student Services)
Credits: 25.0
Contact Hours: 3.0
Prerequisite(s): 311505 (v.1) Databases CITS2232 (UWA) or any previous version
Syllabus: Review of database technologies essential for understanding data warehousing, online analytical processing (OLAP) and data mining. Theis will be followed by a detailed study of logical and physical design of data warehouses including star schema, snowflake schema, data marts, partitioning and materialised views. Practical issues related to data warehouse construction like data extraction from operational databases, data transformation and cleansing and data warehouse support in modern DBMS will be covered next. The use of data warehouses will be illustrated through a study of the OLAP technology, including OLAP like MOLAP and ROLAP, OLAP operations and SQL support for OLAP. The unit will conclude with a study of modern data mining methods including clustering, association rule mining and machine learning techniques.