Subject Descriptions - Subject Information


Calendar: 2017 Postgraduate
Faculty: Faculty of Engineering and Information Sciences
Department: School of Computing and Information Technology


Subject Information
Subject Code CSCI835
Subject Name Database Systems
Credit Points 6
Pre-Requisites Nil
Co-Requisites None.
Restrictions ITCS904, CSCI235, MCS9235
Equivalence None.
Assessment Assignments 10%; Laboratory Tasks 30%; Final examination 60%.
General Subject Yes.
EFTSL (Non Weighted) 0.125
Non Weighted Student Contribution Amounts
Commonwealth Supported (HECS) Students Only
Pre-1997 Pre-2005 Post-2005 Post-2008 Post-2009 Post-2010
$ 1131  $ 1131  $ 1131  $ 1131  $ 1131  $ 1131 
Weighted Student Contribution Amounts  
Work Experience No
Tutorial Enrolment Information Students should use the SMP OnLine Tutorial System (via SOLS) to enrol in Tutorial/laboratory groups for this subject. Once enrolments are open a link to the subject will appear in Tutorial Enrolments.

Subject Availability
Session Autumn  (27-02-2017 to 22-06-2017)
Campus Wollongong
Delivery Method On Campus
Instance Name Class 1
Course Restrictions No restrictions
Contact Hours 3 hrs Lecture & 2 hrs Computer Lab per week
Lecturer(s) and
Cons. times
Tianbing Xia
Coordinator(s) and
Cons. times
Tianbing Xia
Instance Comment  
Census Date 31-03-2017

Subject Availability
Session Spring  (24-07-2017 to 16-11-2017)
Campus Wollongong
Delivery Method On Campus
Instance Name Class 1
Course Restrictions No restrictions
Contact Hours 3 hrs Lecture & 2 hrs Computer Lab per week
Lecturer(s) and
Cons. times
Janusz Getta
Tianbing Xia
Coordinator(s) and
Cons. times
Janusz Getta
Tianbing Xia
Instance Comment  
Census Date 31-08-2017

Subject Availability
Session CCNU Session 1 2017/2018  (18-09-2017 to 07-01-2018)
Campus Central China Normal University Wuhan
Delivery Method On Campus
Instance Name Class 1
Course Restrictions No restrictions
Contact Hours  
Lecturer(s) and
Cons. times
Guangyou Zhou
Coordinator(s) and
Cons. times
Fenghui Ren
Janusz Getta
Luping Zhou
Instance Comment  
Census Date 10-10-2017

Subject Description
The subject presents more advanced topics in the modern relational database technology and it introduces the new non-relational (NoSQL) database technologies. The relational database technology component of the subject includes database design with meta modelling and spatio-temporal modelling, database normalization, advanced programming in SQL and programming of database server with stored PL/SQL procedures, functions, and triggers, concurrency control and database recovery techniques, design and programming of distributed database systems. The non-relational (NoSQL) database technology component of the subject includes the key-value data model, document-oriented model, column-family stores, graph data model, and new approaches to data distribution, consistency preserving, and transaction processing.


Subject Learning Outcomes
On successful completion of this subject, students will be able to:
1. Design and create extendable and spatio-temporal relational databases using advanced conceptual modelling techniques .
2. Adapt a theory of relational database normalization to prove the correctness of relational database designs.
3. Design and create stored procedures, stored functions and database triggers in advanced SQL and in PL/SQL.
4. Design and create effective database transaction based on the principles of transaction processing and theory of concurrency in database systems.
5. Summarise the principles of distributed database systems, design and create distributed relational databases.
6. Summarise the principles of modern non-relational (NoSQL) database technologies, design and create key-value and document oriented database systems.
7. Adapt the principles of distributed and clustered computing systems to design and to create more effective database applications.


Textbook Information

Text book information is available via the UniShop website:



Search Criteria [Click here for help]
Subject Code / Name
Level
Department
Session
Campus
Delivery Method
General Subjects