FIT4038 - Database management and implementation

Leader(s): David Taniar

Offered

Caulfield Second semester 2009 (Day)

Synopsis

This unit is a second unit in databases, and looks at the design and implementation issues of database management systems. Record, file and index structures are dealt with at the basic level. Higher level details of consistency, atomicity and durability are introduced along with modern trends in databases

Objectives

At the completion of this unit students will:

1. be aware of how data is stored and indexed on disks given the architecture of disks and processing requirements
2. understand how a RDBMS processes a query
3. be able to explain how query processing can be done efficiently
4. understand how the requirements of transaction processing are met be an RDBMS
5. be aware of issues related to failure recovery
6. have an appreciation for the complexities involved in high performance databases

Assessment

Assignment: 30%, Class Test: 10%, Exam (3 hours): 60%

Contact hours

2 hours of lectures/week, 2 hours of tutorials/week

Prerequisites

FIT9019 or FIT9003
Knowledge of relational database principles, including SQL

Prohibitions

FIT3118, CSE3000

Additional information on this unit is available from the faculty at:

http://www.infotech.monash.edu.au/units/fit4038/