DATABASE MANAGEMENT SYSTEMS

CSE3DMS

2018

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.

SchoolSchool Engineering&Mathematical Sciences

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

Graduate capabilities & intended learning outcomes

01. Explain the steps for developing database applications and Advance SQL programming under Oracle DB environment.

Activities:
Learning from lectures 1 & 2 and practice in labs weekly
Related graduate capabilities and elements:
Writing
Creative Problem-solving
Inquiry/ Research
Critical Thinking

02. Explain database management systems, file organisations and Index techniques

Activities:
Learning from lectures 3-5 for concepts and examples of Indexes of B+tree & hashing. Practising in labs by drawing the structures of various indexes such as static multilevel indexes, dynamic B+tree indexes, internal & external Hashing for Disk Files storage and indexes.
Related graduate capabilities and elements:
Discipline-specific GCs
Creative Problem-solving
Quantitative Literacy/ Numeracy
Critical Thinking
Ethical Awareness
Inquiry/ Research

03. Improve database performance through database design tuning and the database queries tuning

Activities:
Learning the theory in lectures and practising on modifications of existing database design, indexes and queries to improve database performance.
Related graduate capabilities and elements:
Creative Problem-solving
Writing
Critical Thinking
Inquiry/ Research
Discipline-specific GCs

04. Perform the analysis of optimisation on database queries

Activities:
Learning the theory in lectures and practising in Labs by calculating the costs for different SQL queries for selection, projection and join operations Practising the SQL queries using different algorithms and indexes techniques under Oracle database systems to compare the performance
Related graduate capabilities and elements:
Writing
Discipline-specific GCs
Creative Problem-solving
Critical Thinking
Quantitative Literacy/ Numeracy
Inquiry/ Research

05. Explain the principle of transaction management design for concurrency control and recovery algorithms

Activities:
Learning the theory in lectures and doing practice on problems in Labs Students are given various transaction schedules to identify the correctness by different techniques and algorithms
Related graduate capabilities and elements:
Quantitative Literacy/ Numeracy
Inquiry/ Research
Discipline-specific GCs
Critical Thinking
Creative Problem-solving

06. Develop effective high quality database queries using knowledge and skills learned in this unit

Activities:
Students will be assigned a large assignment for design, analysis and implementation database queries
Related graduate capabilities and elements:
Critical Thinking
Teamwork
Inquiry/ Research
Writing
Discipline-specific GCs
Quantitative Literacy/ Numeracy
Creative Problem-solving

Subject options

Select to view your study options…

Start date between: and    Key dates

Dandenong, 2018, Semester 1, Day

Overview

Online enrolmentYes

Maximum enrolment sizeN/A

Enrolment information

Subject Instance Co-ordinatorJinli Cao

Class requirements

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.

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

Assessments

Assessment elementComments% ILO*
one 2-hour examinationHurdle requirement: To pass the subject, a pass in the examination is mandatory.50 01, 02, 03, 04, 05, 06
one assignment - database query performance analysis (1100 words)30 01, 02, 03, 04, 05, 06
Weekly Quiz (800 words)20 01, 02, 03, 04, 05, 06

Melbourne, 2018, Semester 1, Day

Overview

Online enrolmentYes

Maximum enrolment sizeN/A

Enrolment information

Subject Instance Co-ordinatorJinli Cao

Class requirements

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.

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

Assessments

Assessment elementComments% ILO*
one 2-hour examinationHurdle requirement: To pass the subject, a pass in the examination is mandatory.50 01, 02, 03, 04, 05, 06
one assignment - database query performance analysis (1100 words)30 01, 02, 03, 04, 05, 06
Weekly Quiz (800 words)20 01, 02, 03, 04, 05, 06