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 2020 is available in the Archives.
Credit points: 6 cp
Subject level:
Postgraduate
Result type: Grade and marksRequisite(s): 31271 Database Fundamentals OR 31061 Database Principles OR 32606 Database
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. | Identify corporate data resources and their value for modern businesses |
|---|---|
| 2. | Explain database technologies for managing and supporting corporate data resources |
| 3. | Evaluate advantages and disadvantages of database technologies and their applicability in different business situations |
| 4. | Distinguish data exploration methods and tools and their role in discovering knowledge locked in historical corporate data; |
| 5. | Explain corporate data resources design and management issues |
| 6. | Communicate in the form of technical reports and presentations |
| 7. | Work in a group to achieve a common objective |
| 8. | Collect and evaluate relevant information from many sources and use it in supporting claims about the advantages and disadvantages of corporate data management tools and techniques. |
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)
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 UTSOnline. 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)
- Corporate data resources model and its components
- Data resources integration
- Transaction processing support
- Data warehousing
- Data Marts
- Exploration and data mining of data warehouses
- Applications of Data Ware housing applications.
- 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): 1, 3 and 5 This assessment task contributes to the development of the following Course Intended Learning Outcomes (CILOs): B.1 and C.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): 2 and 6 This assessment task contributes to the development of the following Course Intended Learning Outcomes (CILOs): B.1 and C.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): D.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