The Information Resource

Description

Provides students with theoretical knowledge and practical skills in advanced topics in database system, big data and modern data-intensive systems. The specific topics include indexing methods, query processing and optimization strategies for relational database systems, Object Relational Mapping and Object Database design, distributed database systems, data mining on large databases.

Availability

UoN Singapore

  • Trimester 1 - 2017 (Singapore)
  • Trimester 2 - 2017 (Singapore)

Ourimbah

  • Semester 1 - 2017

Callaghan

  • Semester 1 - 2017

Learning Outcomes

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

1. Design, develop and implement a mid-scale relational databases for an 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 BigData, NoSQL, On-Line Analytical Processing (OLAP) and Data Warehouses.

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

Content

1. DBMS Internals   a. Storage and Indexing    b. Query Processing and Optimization    c. Concurrency Control    d. Crash Recovery

2. Physical Database Design and imlementation issues3. Object Relational Mapping (ORM), Object Database and Object-Oriented Database and Object-Oriented Database Management Systems (OODBMS)4. BigData and Paralle and Distributed database (e.g. role of NoSQL, Map-reduce, Hadoop platform etc.)5. Comtemporary issues and emerging technologies such as On-line Analytical Processing (OLAP), Data Warehouses, database-as-a-service (DB clouds), data mining on large databases. 

 

Assumed Knowledge

INFT1040 (Databases & Information Management) and SENG1110 (Object Oriented Programming) or INFT2012 (Applications Programming)

Assessment Items

Written Assignment: Assignment 1

Formal Examination: Final exam *

Written Assignment: Assignment 2

Written Assignment: Assignment 3

* 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. - A mark of at least 40% in the Final Examination is required.

Contact Hours

Callaghan, Ourimbah and UoN Singapore

Computer Lab

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

24 hours of Lectures and 24 hours of Computer Laboratories will be delivered in Block mode for part-time students at UoN Singapore.

Lecture

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