The University of Newcastle, Australia

Course handbook


This course provides students with theoretical knowledge and practical skills in advanced topics in database systems, big data and modern data-intensive systems. Specific topics include indexing methods, query processing and optimisation strategies for relational database systems, Object Relational Mapping and Object Database design, distributed database systems, and data mining on large databases.

Availability2020 Course Timetables

PSB Singapore

  • Trimester 2 - 2020 (Singapore)


  • Semester 1 - 2020


  • Semester 1 - 2020

Learning outcomes

On successful completion of the course students will be able to:

1. application domain using a commercial-grade RDBMS

2. Understand physical database design and implementation issues

3. Understand and be able to use the persistence framework of chosen language to perform Object Relational Mapping.

4. Understand the concept of object oriented database and have experience with object oriented modelling, design and implementation

5. Understand contemporary issues and emerging technologies such as Big Data, NoSQL, On-Line Analytical Processing (OLAP) and Data Warehouses.

6. Have hands-on experience with a number of contemporary information management systems


1. DBMS Internals 

  • Storage and Indexing
  • Query Processing and Optimization 
  • Concurrency Control
  • Crash Recovery 

2. Physical Database Design and implementation issues

3. Object Relational Mapping (ORM), Object Database and Object-Oriented Database Management Systems (OODBMS)

4. Big Data and Parallel and Distributed databases (topics such as role of NoSQL, Map-reduce, Hadoop platform etc.) 

5. Contemporary issues and emerging technologies such as On-Line Analytical Processing (OLAP), Data Warehouses, database-as-a-service (DB clouds), data mining on large databases  


You cannot enrol in this course if you have successfully completed INFT3007.

Assumed knowledge

COMP1140 Database & Information Management and either INFT1004 Introduction to Programming or SENG1110 Object Oriented Programming

Assessment items

Written Assignment: Written Assignment 1

Written Assignment: Written Assignment 2

Written Assignment: Written Assignment 3

Formal Examination: Final exam *

* This assessment has a compulsory requirement.

Compulsory Requirements

In order to pass this course, each student must complete ALL of the following compulsory requirements:

Course Assessment Requirements:

  • Formal Examination: Minimum Grade / Mark Requirement - Students must obtain a specified minimum grade / mark in this assessment item to pass the course. - Students whose overall mark in the course is 50% or more, but who score less than 40% in the compulsory item and thus fail to demonstrate the required proficiency, will be awarded a Criterion Fail grade, which will show as FF on their formal transcript. However, students in this position who have scored at least 25% in the compulsory item will be allowed to undertake a supplementary 'capped' assessment in which they can score at most 50% of the possible mark for that item.

Contact hours

Callaghan, Ourimbah and PSB Singapore


Face to Face On Campus 2 hour(s) per Week for Full Term


Face to Face On Campus 2 hour(s) per Week for Full Term