cse3dms database management systems
DATABASE MANAGEMENT SYSTEMS
CSE3DMS
2016
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(Writing)
- Creative Problem-solving(Creative Problem-solving)
- Inquiry/ Research(Inquiry/ Research)
- Critical Thinking(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(Discipline-specific GCs)
- Creative Problem-solving(Creative Problem-solving)
- Quantitative Literacy/ Numeracy(Quantitative Literacy/ Numeracy)
- Critical Thinking(Critical Thinking)
- Ethical Awareness(Ethical Awareness)
- Inquiry/ Research(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(Creative Problem-solving)
- Writing(Writing)
- Critical Thinking(Critical Thinking)
- Inquiry/ Research(Inquiry/ Research)
- Discipline-specific GCs(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(Writing)
- Discipline-specific GCs(Discipline-specific GCs)
- Creative Problem-solving(Creative Problem-solving)
- Critical Thinking(Critical Thinking)
- Quantitative Literacy/ Numeracy(Quantitative Literacy/ Numeracy)
- Inquiry/ Research(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(Quantitative Literacy/ Numeracy)
- Inquiry/ Research(Inquiry/ Research)
- Discipline-specific GCs(Discipline-specific GCs)
- Critical Thinking(Critical Thinking)
- Creative Problem-solving(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(Critical Thinking)
- Teamwork(Teamwork)
- Inquiry/ Research(Inquiry/ Research)
- Writing(Writing)
- Discipline-specific GCs(Discipline-specific GCs)
- Quantitative Literacy/ Numeracy(Quantitative Literacy/ Numeracy)
- Creative Problem-solving(Creative Problem-solving)
Subject options
Select to view your study options…
Dandenong, 2016, Semester 1, Day
Overview
Online enrolmentYes
Maximum enrolment sizeN/A
Enrolment information
Subject Instance Co-ordinatorJinli Cao
Class requirements
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.
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.
Assessments
| Assessment element | Comments | % | ILO* |
|---|---|---|---|
| one 2-hour examination (1900 words ) | In order to pass the subject students must attend at least 70% of the laboratory classes and must obtain an overall pass grade, pass 45% of examination and pass 50% of the overall non-examination components. | 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, 2016, Semester 1, Day
Overview
Online enrolmentYes
Maximum enrolment sizeN/A
Enrolment information
Subject Instance Co-ordinatorJinli Cao
Class requirements
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.
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.
Assessments
| Assessment element | Comments | % | ILO* |
|---|---|---|---|
| one 2-hour examination (1900 words ) | In order to pass the subject students must attend at least 70% of the laboratory classes and must obtain an overall pass grade, pass 45% of examination and pass 50% of the overall non-examination components. | 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 |