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.
Faculty: Faculty of Science, Tech & Engineering
Credit points: 15
Subject Co-ordinator: Jinli Cao
Available to Study Abroad Students: Yes
Subject year level: Year Level 3 - UG
Exchange Students: Yes
Subject particulars
Subject rules
Prerequisites: CSE2DBF
Co-requisites: N/A
Incompatible subjects: CSE3DBP
Equivalent subjects: N/A
Special conditions: N/A
Dandenong, 2014, Semester 1, Day
Overview
Online enrolment: Yes
Maximum enrolment size: N/A
Enrolment information:
Subject Instance Co-ordinator: Jinli Cao
Class requirements
Computer LaboratoryWeek: 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.
LectureWeek: 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 element | Comments | % |
|---|---|---|
| one 3-hour examination | In 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 analysis | 30 |
Melbourne, 2014, Semester 1, Day
Overview
Online enrolment: Yes
Maximum enrolment size: N/A
Enrolment information:
Subject Instance Co-ordinator: Jinli Cao
Class requirements
Computer LaboratoryWeek: 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.
LectureWeek: 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 element | Comments | % |
|---|---|---|
| one 3-hour examination | In 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 analysis | 30 |