University of Technology Sydney

32113 Advanced Database

Warning: The information on this page is indicative. The subject outline for a particular session, location and mode of offering is the authoritative source of all information about the subject for that offering. Required texts, recommended texts and references in particular are likely to change. Students will be provided with a subject outline once they enrol in the subject.

Subject handbook information prior to 2025 is available in the Archives.

UTS: Information Technology: Computer Science
Credit points: 6 cp

Subject level:

Postgraduate

Result type: Grade and marks

Requisite(s): 31271 Database Fundamentals OR 31061 Database Principles OR 32606 Database OR 94692 Data Science Practice
These requisites may not apply to students in certain courses.
There are course requisites for this subject. See access conditions.

Recommended studies: a clear understanding of basic database techniques including relational database technology

Description

This subject reviews material on relational databases and covers advanced topics such as distributed databases. Data warehousing and mining techniques, implementation and management are covered in detail.

Subject learning objectives (SLOs)

Upon successful completion of this subject students should be able to:

1. Evaluate data warehouse design and management and its value in relation to supporting corporate stakeholder data resource. (B.1)
2. Design data warehouse models to support complex corporate stakeholder requirements. (C.1).
3. Create database warehouses to support a range of data types and structures to support complex queries and results. (D.1)
4. Collaborate effectively in a group to address a practical business problem. (E.1)

Course intended learning outcomes (CILOs)

This subject also contributes specifically to the development of the following Course Intended Learning Outcomes (CILOs):

  • Socially Responsible: FEIT graduates identify, engage, and influence stakeholders, and apply expert judgment establishing and managing constraints, conflicts and uncertainties within a hazards and risk framework to define system requirements and interactivity. (B.1)
  • Design Oriented: FEIT graduates apply problem solving, design thinking and decision-making methodologies in new contexts or to novel problems, to explore, test, analyse and synthesise complex ideas, theories or concepts. (C.1)
  • Technically Proficient: FEIT graduates apply theoretical, conceptual, software and physical tools and advanced discipline knowledge to research, evaluate and predict future performance of systems characterised by complexity. (D.1)
  • Collaborative and Communicative: FEIT graduates work as an effective member or leader of diverse teams, communicating effectively and operating autonomously within cross-disciplinary and cross-cultural contexts in the workplace. (E.1)

Teaching and learning strategies

The subject is comprised of lectures and group discussions and presentations (2 hours). The lectures will introduce theoretical aspects of advanced databases and data warehouses. Lecture notes for each week will be made available on Canvas. Preparations including reading the lecture notes before the class will help the students participate in-class activities. The group discussions and presentations will consist of collaborative teamwork and will give students opportunities to work on real-world database problems. Students will engage with their peers and present to the whole class their group-based research findings on a topic related to Data Warehousing technology.

Content (topics)

  1. Corporate data resources model and its components
  2. Data resources integration
  3. Transaction processing support
  4. Data warehousing
  5. Data Marts
  6. Exploration and data mining of data warehouses
  7. Applications of Data Ware housing applications.
  8. Managing corporate data resources

Assessment

Assessment task 1: Design Assignment

Intent:

To do a design assignment to develop a Data warehouse.
Objective(s):

This assessment task addresses the following subject learning objectives (SLOs):

2 and 3

This assessment task contributes to the development of the following Course Intended Learning Outcomes (CILOs):

C.1 and D.1

Type: Design/drawing/plan/sketch
Groupwork: Individual
Weight: 30%

Assessment task 2: Group presentation/report

Intent:

To do a field study about a topic of students choice and apply the study in developing a Data warehouse model.
Objective(s):

This assessment task addresses the following subject learning objectives (SLOs):

1, 2, 3 and 4

This assessment task contributes to the development of the following Course Intended Learning Outcomes (CILOs):

B.1, C.1, D.1 and E.1

Type: Demonstration
Groupwork: Group, group assessed
Weight: 30%
Criteria:

Group presentation/ Report

Assessment task 3: Quiz/Class test

Intent:

To undertake a quiz.
Objective(s):

This assessment task addresses the following subject learning objectives (SLOs):

1

This assessment task contributes to the development of the following Course Intended Learning Outcomes (CILOs):

B.1

Type: Quiz/test
Groupwork: Individual
Weight: 40%

Minimum requirements

In order to pass the subject, a student must achieve an overall mark of 50% or more.

Required texts

W.h.Inmom, C.Inhoff and R.Sousa. Corporate Information Factory. John Wiley& Sons.

R Kimball. The data warehouse toolkit: practical techniques for building dimensional data warehouses. John Wiley & Sons New York

References

Additional reading materials:
http://www-db.stanford.edu/warehousing
http://www.intelligententerprise.com
http://www.dmreview.com
http://www.datawarehousingonline.com
http://www.dwinfocenter.org
http://www.billinmon.com
http://www.rkimball.com
http://www.datawarehouse.com
http://www.datamation.com
http://www.cio.com
http://www.informationweek.com
http://www.kenorrinst.com