DATABASE MANAGEMENT SYSTEMS

CSE3DMS

2014

Credit points: 15

Subject outline

This subject covers the important knowledge and concepts of database management systems. The techniques of various indexes including B+Trees, Bitmap, static and dynamic hashing indexes used for database organisations are studied. The algorithms for query processing and optimisation to improve performance of the database systems are detailed. Principles and theories of database management such as transaction management, serializability, recoverability, concurrency control algorithms and recovery techniques are covered. This subject is also including the advanced database programming SQL such as advanced procedures, functions, transactions, Oracle optimizer, execution plans for query optimization, hint, auto-trace and indexes etc. Physical database design issues and tuning techniques are extensively studied and discussed.

FacultyFaculty of Science, Tech & Engineering

Credit points15

Subject Co-ordinatorJinli Cao

Available to Study Abroad StudentsYes

Subject year levelYear Level 3 - UG

Exchange StudentsYes

Subject particulars

Subject rules

Prerequisites CSE2DBF

Co-requisitesN/A

Incompatible subjects CSE3DBP

Equivalent subjectsN/A

Special conditionsN/A

Subject options

Select to view your study options…

Start date between: and    Key dates

Dandenong, 2014, Semester 1, Day

Overview

Online enrolmentYes

Maximum enrolment sizeN/A

Enrolment information

Subject Instance Co-ordinatorJinli Cao

Class requirements

Computer Laboratory Week: 10 - 22
One 2.0 hours computer laboratory per week on weekdays during the day from week 10 to week 22 and delivered via face-to-face.

Lecture Week: 10 - 22
One 2.0 hours lecture per week on weekdays during the day from week 10 to week 22 and delivered via face-to-face.

Assessments

Assessment elementComments%
one 3-hour examinationIn order to pass the subject students must attend at least 70% of the laboratory classes and must obtain an overall pass grade, pass the examination and pass the overall non-examination components.70
one assignment - database query performance analysis30

Melbourne, 2014, Semester 1, Day

Overview

Online enrolmentYes

Maximum enrolment sizeN/A

Enrolment information

Subject Instance Co-ordinatorJinli Cao

Class requirements

Computer Laboratory Week: 10 - 22
One 2.0 hours computer laboratory per week on weekdays during the day from week 10 to week 22 and delivered via face-to-face.

Lecture Week: 10 - 22
One 2.0 hours lecture per week on weekdays during the day from week 10 to week 22 and delivered via face-to-face.

Assessments

Assessment elementComments%
one 3-hour examinationIn order to pass the subject students must attend at least 70% of the laboratory classes and must obtain an overall pass grade, pass the examination and pass the overall non-examination components.70
one assignment - database query performance analysis30