311507 (v.1) Advanced Databases CITS4243 (UWA)
| Area: | Cross Institutional Enrolments Office (Student Services) |
|---|---|
| Credits: | 25.0 |
| Contact Hours: | 3.0 |
| Tuition Patterns: | The tuition pattern provides details of the types of classes and their duration. This is to be used as a guide only. Precise information is included in the unit outline. |
| 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. |
| Unit references, texts, outcomes and assessment details | The most up-to-date information about unit references, texts and outcomes, will be provided in the unit outline. |
Handbook Disclaimer
The online handbook is the repository of Curtin University of Technology (“Curtin”) course information. While Curtin makes all reasonable endeavors to keep its online courses handbook up-to-date, information within this website is subject to change from time to time. Curtin reserves the right to change the contents and/or the method of assessment, to change or alter tuition fees of any unit of study, to withdraw/any unit of study or program which it offers, to impose limitations on enrolment in any unit or program, and/or to vary arrangements for any program without notification via the website.
For course overviews and enrolment information please visit our future students website.
