Note: This unit version is currently being edited and is subject to change!

COMP5338: Advanced Data Models (2019 - Semester 2)

Download UoS Outline

Unit: COMP5338: Advanced Data Models (6 CP)
Mode: Normal-Day
On Offer: Yes
Level: Postgraduate
Faculty/School: School of Computer Science
Unit Coordinator/s: Dr Zhou, Ying
Session options: Semester 2
Versions for this Unit:
Site(s) for this Unit: http://www.it.usyd.edu.au/~comp5338/
Campus: Camperdown/Darlington
Pre-Requisites: None.
Brief Handbook Description: This unit of study gives a comprehensive overview of post-relational data models and of latest developments in data storage technology.

Particular emphasis is put on spatial, temporal, and NoSQL data storage. This unit extensively covers the advanced features of SQL:2003, as well as a few dominant NoSQL storage technologies. Besides in lectures, the advanced topics will be also studied with prescribed readings of database research publications.
Assumed Knowledge: This unit of study assumes foundational knowledge of relational database systems as taught in COMP5138/COMP9120 (Database Management Systems) or INFO2120/INFO2820/ISYS2120 (Database Systems 1).
Lecturer/s: Dr Zhou, Ying
Timetable: COMP5338 Timetable
Time Commitment:
# Activity Name Hours per Week Sessions per Week Weeks per Semester
1 Tutorial 1.00 1 13
2 Independent Study 1 13
3 Lecture (typically 6pm-8pm) 2.00 1 13
T&L Activities:
  • Students are expected to attend all scheduled lectures, and laboratory classes. You should expect to spend a minimum of six hours per week including scheduled lectures and laboratory times.
  • Students are expected to undertake prescribed reading, to carry out exercises and laboratory tasks and to submit selected work for assessment as directed. It should be realised that laboratory exercises are expected to take longer than just the time scheduled for classes.
  • Students are expected to self-dependently prepare the prescribed research paper readings and conduct additional literature and system research as necessary.
  • Students are expected to be able to work independently and to make effective use of a range of resources including the library, the Internet and relevant on-line help facilities.
  • Students are expected to check their progressive results regularly. Results will be published through USYD eLearning. Any errors or omissions must be reported to the unit coordinator, with appropriate evidence, as soon as possible. Please note: Marks are considered to have been confirmed ten days after being published and will not subsequently be altered.

Learning outcomes are the key abilities and knowledge that will be assessed in this unit. They are listed according to the course goal supported by each. See Assessment Tab for details how each outcome is assessed.

Unassigned Outcomes
1. Ability to use APIs provided by several NoSQL storage systems to develop client side program.
2. Understanding of object-relational, spatial-temporal, as well as key value data models, and their storage and processing.
3. Understanding of the basic concepts of advanced data management topics such as big data storage and processing, as well as distributed data management architecture
4. Ability to create, update/modify, and query (1) object-relational databases using SQL:2003 (independent of the database vendor), (2) spatial-temporal databases using SQL, and (3) key value data store using APIs and command line tools.
Assessment Methods:
# Name Group Weight Due Week Outcomes
1 Quiz 1 No 10.00 Week 6 2, 4,
2 Project* Yes 20.00 Week 10 1, 2, 4,
3 Quiz 2 No 10.00 Week 12 2, 3,
4 Final Exam No 60.00 Exam Period 2, 3, 4,
Assessment Description: Project: Team Project: High-level client for NoSQL systems

In this practical assignment, students are asked to design and implement high-level client for a few NoSQL systems. Currently all NoSQL systems provides their own low level APIs to support client interaction. Students are asked to design and implement an uniform high level client to be able to communicate with various systems. The high level client should support basic CRUD functions.

Late penalty for project work is 10% per day.

Quiz 1&2 : Exam-Preparation Quiz

Both quizzes are closed book and paper based. They are held during tutorial time. Students are required to attempt them individually. Quizzes test the conceptual knowledge covered in the lectures.

Final Exam: Final written examination

You must get 45% in the final exam to pass the unit, regardless of the sum of your individual marks.

There may be statistically defensible moderation when combining the marks from each component to ensure consistency of marking between markers, and alignment of final grades with unit outcomes.
Grading:
Grade Type Description
Standards Based Assessment Final grades in this unit are awarded at levels of HD for High Distinction, DI (previously D) for Distinction, CR for Credit, PS (previously P) for Pass and FA (previously F) for Fail as defined by University of Sydney Assessment Policy. Details of the Assessment Policy are available on the Policies website at http://sydney.edu.au/policies . Standards for grades in individual assessment tasks and the summative method for obtaining a final mark in the unit will be set out in a marking guide supplied by the unit coordinator.
Special Conditions to Pass UoS It is a policy of the School of Information Technologies that in order to pass this unit, a student must achieve at least 40% in the written examination. A student must also achieve an overall final mark of 50 or more. Any student not meeting these requirements may be given a maximum final mark of no more than 45 regardless of their average.
Policies & Procedures: IMPORTANT: School policy relating to Academic Dishonesty and Plagiarism.

In assessing a piece of submitted work, the School of Computer Science may reproduce it entirely, may provide a copy to another member of faculty, and/or to an external plagiarism checking service or in-house computer program and may also maintain a copy of the assignment for future checking purposes and/or allow an external service to do so.

Other policies

See the policies page of the faculty website at http://sydney.edu.au/engineering/student-policies/ for information regarding university policies and local provisions and procedures within the Faculty of Engineering and Information Technologies.
Online Course Content: USyd e-Learning (WebCT) and course website at: http://www.it.usyd.edu.au/~comp5338/
Note on Resources: Note that there is no single textbook used in COMP5338.

Recommended Textbooks are available on http://www.cs.usyd.edu.au/~comp5338/literature.shtml

Note that the "Weeks" referred to in this Schedule are those of the official university semester calendar https://web.timetable.usyd.edu.au/calendar.jsp

Week Description
Week 1 Introduction to Polyglot Persistence
Introduction and Organisation
Week 2 Document Stores: Data Model and Queries
Week 3 Document Stores: Internal and Performance Tunning
Week 4 Column Based Storage: Data Model and Queries
Week 5 Column Based Storage: Architecture
Week 6 Graph Database: Data Model and Queries
Assessment Due: Quiz 1
Week 7 Graph Database: Storage and Processing
Week 8 Key-Value Storage
Week 9 Object Relational DBMS
Week 10 Spatial Model, Queries and indexing
Assessment Due: Project*
Week 11 Temporal Model and Queries
Week 12 Stream Data
Assessment Due: Quiz 2
Week 13 Unit of Study Review
Exam Period Assessment Due: Final Exam

Course Relations

The following is a list of courses which have added this Unit to their structure.

Course Year(s) Offered
Bachelor of Advanced Computing/Bachelor of Commerce 2018, 2019, 2020
Bachelor of Advanced Computing/Bachelor of Science 2018, 2019, 2020
Bachelor of Advanced Computing/Bachelor of Science (Health) 2018, 2019, 2020
Bachelor of Advanced Computing/Bachelor of Science (Medical Science) 2018, 2019, 2020
Bachelor of Advanced Computing (Computational Data Science) 2018, 2019, 2020
Bachelor of Advanced Computing (Computer Science Major) 2018, 2019, 2020
Bachelor of Advanced Computing (Information Systems Major) 2018, 2019, 2020
Bachelor of Advanced Computing (Software Development) 2018, 2019, 2020
Bachelor of Computer Science and Technology (Honours) 2015, 2016, 2017
Bachelor of Computer Science and Technology (Honours) 2014 2013, 2014
Software Mid-Year 2016, 2017, 2018, 2019, 2020
Software/ Project Management 2019, 2020
Software 2015, 2016, 2017, 2018, 2019, 2020
Software / Arts 2016, 2017, 2018, 2019, 2020
Software / Commerce 2016, 2017, 2018, 2019, 2020
Software / Medical Science 2016, 2017
Software / Music Studies 2016, 2017
Software / Project Management 2016, 2017, 2018
Software / Science 2016, 2017, 2018, 2019, 2020
Software/Science (Health) 2018, 2019, 2020
Software / Law 2016, 2017, 2018, 2019, 2020
Software Engineering (till 2014) 2010, 2011, 2012, 2013, 2014
Software Engineering / Arts 2011, 2012, 2013, 2014
Software Engineering / Commerce 2010, 2011, 2012, 2013, 2014
Software Engineering / Medical Science 2011, 2012, 2013, 2014
Software Engineering / Project Management 2012, 2013, 2014
Software Engineering / Science 2011, 2012, 2013, 2014
Bachelor of Information Technology 2015, 2016, 2017
Bachelor of Information Technology/Bachelor of Arts 2015, 2016, 2017
Bachelor of Information Technology/Bachelor of Commerce 2015, 2016, 2017
Bachelor of Information Technology/Bachelor of Medical Science 2015, 2016, 2017
Bachelor of Information Technology/Bachelor of Science 2015, 2016, 2017
Bachelor of Information Technology (Computer Science) 2014 and earlier 2009, 2010, 2011, 2012, 2013, 2014
Information Technology (Computer Science)/Arts 2012, 2013, 2014
Information Technology (Computer Science) / Commerce 2012, 2013, 2014
Information Technology (Computer Science) / Medical Science 2012, 2013, 2014
Information Technology (Computer Science) / Science 2012, 2013, 2014
Information Technology (Computer Science) / Law 2012, 2013, 2014
Bachelor of Information Technology (Information Systems) 2014 and earlier 2010, 2011, 2012, 2013, 2014
Information Technology (Information Systems)/Arts 2012, 2013, 2014
Information Technology (Information Systems) / Commerce 2012, 2013, 2014
Information Technology (Information Systems) / Medical Science 2012, 2013, 2014
Information Technology (Information Systems) / Science 2012, 2013, 2014
Information Technology (Information Systems) / Law 2012, 2013, 2014
Bachelor of Information Technology/Bachelor of Laws 2015, 2016, 2017
Graduate Certificate in Information Technology 2015, 2016, 2017, 2018, 2019, 2020
Graduate Certificate in Information Technology Management 2015, 2016, 2017, 2018, 2019, 2020
Graduate Diploma in Computing 2015, 2016, 2017, 2018, 2019, 2020
Graduate Diploma in Information Technology 2015, 2016, 2017, 2018, 2019, 2020
Graduate Diploma in Information Technology Management 2015, 2016, 2017, 2018, 2019, 2020
Graduate Certificate in Information Technology (till 2014) 2012, 2013, 2014
Graduate Diploma in Information Technology (till 2014) 2012, 2013, 2014
Master of Data Science 2016, 2017, 2018, 2019, 2020
Master of Information Technology 2015, 2016, 2017, 2018, 2019, 2020
Master of Information Technology Management 2015, 2016, 2017, 2018, 2019, 2020
Master of IT/Master of IT Management 2015, 2016, 2017, 2018, 2019, 2020
Master of Information Technology (till 2014) 2014
Master of Professional Engineering (Accelerated) (Software) 2019, 2020
Master of Professional Engineering (Software) 2010, 2011, 2012, 2013, 2014, 2015, 2016, 2017, 2018, 2019, 2020
Software/Science (Medical Science Stream) 2018, 2019, 2020

Course Goals

This unit contributes to the achievement of the following course goals:

Attribute Practiced Assessed
(6) Communication and Inquiry/ Research (Level 4) No 0%
(7) Project and Team Skills (Level 3) No 0%
(8) Professional Effectiveness and Ethical Conduct (Level 3) No 0%
(5) Interdisciplinary, Inclusiveness, Influence (Level 4) No 0%
(4) Design (Level 4) No 0%
(2) Engineering/ IT Specialisation (Level 5) No 0%
(3) Problem Solving and Inventiveness (Level 4) No 0%
(1) Maths/ Science Methods and Tools (Level 4) No 0%

These goals are selected from Engineering & IT Graduate Outcomes Table 2018 which defines overall goals for courses where this unit is primarily offered. See Engineering & IT Graduate Outcomes Table 2018 for details of the attributes and levels to be developed in the course as a whole. Percentage figures alongside each course goal provide a rough indication of their relative weighting in assessment for this unit. Note that not all goals are necessarily part of assessment. Some may be more about practice activity. See Learning outcomes for details of what is assessed in relation to each goal and Assessment for details of how the outcome is assessed. See Attributes for details of practice provided for each goal.