COMP3350
10 units
3000 level
Course handbook
Description
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.
Availability2024 Course Timetables
Callaghan
- Semester 1 - 2024
Singapore PSB
- Trimester 2 - 2024 (Singapore)
Learning outcomes
On successful completion of the course students will be able to:
1. Design, develop and implement a mid-scale relational database for an application domain using a commercial-grade RDBMS
2. Identify and resolve physical database design and implementation issues
3. Use the persistence framework of chosen language to perform Object Relational Mapping
4. Research, analyse and use emerging technologies such as Big Data, NoSQL, On-Line Analytical Processing (OLAP) and Data Warehouses
5. Have hands-on experience with a number of contemporary information management systems
Content
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)
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)
Requisite
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
Compulsory Requirement: Pass requirement 40% - Must obtain 40% in this assessment item to pass the course.
Contact hours
Semester 1 - 2024 - Callaghan
Lecture-1
- Face to Face On Campus 2 hour(s) per week(s) for 13 week(s) starting in week 1
Workshop-1
- Face to Face On Campus 2 hour(s) per week(s) for 13 week(s) starting in week 1
Trimester 2 - 2024 (Singapore) - Singapore PSB
Lecture-1
- Face to Face On Campus 2 hour(s) per week(s) for 13 week(s) starting in week 1
Workshop-1
- Face to Face On Campus 2 hour(s) per week(s) for 13 week(s) starting in week 1
Course outline
- COMP3350 - Semester 1, 2024 (Callaghan) (PDF, 320.6 KB)
- COMP3350 - Trimester 2, 2024 (Psb) (PDF, 265.7 KB)
The University of Newcastle acknowledges the traditional custodians of the lands within our footprint areas: Awabakal, Darkinjung, Biripai, Worimi, Wonnarua, and Eora Nations. We also pay respect to the wisdom of our Elders past and present.