There are now 3 possible online modes for units:
Units with modes Online timetabled and Online flexible are available for any student to self-enrol and study online.
Units available in Online Restricted mode have been adapted for online study only for those students who require the unit to complete their studies and who are unable to attend campus due to COVID border closures. To be enrolled in a unit in Online Restricted mode, students should contact their Student Advising Office through askUWA and include which of the below criteria applies:
- You are a student who is currently offshore and unable to enter Australia.
- You are a student in Australia who is impacted by state or regional border closures.
Click on an offering mode for more details.
Face to face
Predominantly face-to-face. On campus attendance required to complete this unit. May have accompanying resources online.
100% Online Unit. NO campus face-to-face attendance is required to complete this unit. All study requirements are online only. Unit is asynchronous delivery, with NO requirement for students to participate online at specific times.
100% Online Unit. NO campus face-to-face attendance is required to complete this unit. All study requirements are online only. Unit includes some synchronous components, with a requirement for students to participate online at specific times.
Not available for self-enrolment. Restricted to enrolment by students unable to attend campus due to COVID border closures. Students access this mode by contacting their student office through AskUWA. 100% Online Unit.
NO campus face-to-face attendance. All study and assessment requirements are online only. Unit includes some timetabled activities, with a requirement for students to participate online at specific times. In exceptional cases (noted in the Handbook) students may be required to participate in face-to-face laboratory classes when a return to UWA’s Crawley campus becomes possible in order to be awarded a final grade.
No attendance or regular contact is required, and all study requirements are completed either via correspondence and/or online submission.
Regular attendance is not required, but student attends the institution face to face on an agreed schedule for purposes of supervision and/or instruction.
Multiple modes of delivery. Unit includes a mix of online and on-campus study requirements. On campus attendance for some activities is required to complete this unit.
CITS5504 Data Warehousing
- 6 points
Availability Location Mode Semester 1 UWA (Perth) Face to face Semester 1 Online Online timetabled
- Relational databases are the backbones of modern businesses in processing transactions and storing customer data. Most organisations usually deploy several relational databases for operational convenience. It is quite often necessary to integrate the information existing in different relational databases for planning and decision making. Data warehouses are built to facilitate planning and decision making in businesses integrating data from different relational databases. Online analytical processing (OLAP) is a technology that uses a data warehouse for answering aggregation queries often used in planning. While relational databases hold important transactional information of a business, the success of a business quite often depends on advanced planning and development of strategies based on customer behaviour. Data mining technologies are used for discovering such patterns and trends in data stored in relational databases. This unit introduces the key mechanisms in data warehousing and OLAP. It discusses logical and physical design of data warehouses including star schema, snowflake schema, data marts, partitioning and materialised views. Students study the use of data warehouses through a study of the OLAP technology including the multidimensional OLAP (MOLAP) and relational OLAP (ROLAP) architectures, OLAP operations and structured query language (SQL) support for OLAP.
- Students are able to (1) understand that discovering and extracting knowledge from a massive amount of data is a key problem in many scientific and business disciplines; (2) demonstrate a thorough understanding of key data warehousing and online analytical processing technologies; and (3) apply key data warehousing concepts in designing solutions for business data analytics.
- Indicative assessments in this unit are as follows: (1) two project assignments and (2) final examination. Further information is available in the unit outline.
Supplementary assessment is only available in this unit in the case of a student who has obtained a mark of 45 to 49 and is currently enrolled in this unit, and it is the only remaining unit that the student must pass in order to complete their course.
- Unit Coordinator(s)
- Dr Zeyi Wen
- Unit rules
- enrolment in: (Master of Information Technology or Master of Data Science or Master of Business Analytics) and (CITS1402 Relational Database Management Systems or BUSN5101 Programming for Busines or BUSN5002 Fundamentals of Business Analytics).
- CITS3401 Data Warehousing
- Contact hours
- lectures: 2 hours per week; labs: 2 hours per week
To be advised by the Department of Computer Science and Software Engineering.
- The availability of units in Semester 1, 2, etc. was correct at the time of publication but may be subject to change.
- All students are responsible for identifying when they need assistance to improve their academic learning, research, English language and numeracy skills; seeking out the services and resources available to help them; and applying what they learn. Students are encouraged to register for free online support through GETSmart; to help themselves to the extensive range of resources on UWA's STUDYSmarter website; and to participate in WRITESmart and (ma+hs)Smart drop-ins and workshops.
- Unit readings, including any essential textbooks, are listed in the unit outline for each unit, one week prior the commencement of study. The unit outline will be available via the LMS and the UWA Handbook one week prior the commencement of study. Reading lists and essential textbooks are subject to change each semester. Information on essential textbooks will also be made available on the Essential Textbooks. This website is updated regularly in the lead up to semester so content may change. It is recommended that students purchase essential textbooks for convenience due to the frequency with which they will be required during the unit. A limited number of textbooks will be made available from the Library in print and will also be made available online wherever possible. Essential textbooks can be purchased from the commercial vendors to secure the best deal. The Student Guild can provide assistance on where to purchase books if required. Books can be purchased second hand at the Guild Secondhand bookshop (second floor, Guild Village), which is located on campus.