Subject Descriptions - Subject Information


Calendar: 2017 Undergraduate
Faculty: Faculty of Engineering and Information Sciences
Department: School of Computing and Information Technology


Subject Information
Subject Code CSCI317
Subject Name Database Performance Tuning
Credit Points 6
Pre-Requisites CSCI235
Co-Requisites None.
Restrictions None.
Equivalence None.
Assessment Assignments 20% Tests 20% Final examination 60%
General Subject Yes.
EFTSL (Non Weighted) 0.125
Non Weighted Student Contribution Amounts
Commonwealth Supported (HECS) Students Only
Pre-1997 Pre-2005 Post-2005 Post-2008 Post-2009 Post-2010
$ 1131  $ 1131  $ 1131  $ 1131  $ 1131  $ 1131 
Weighted Student Contribution Amounts
Commonwealth Supported (HECS) Students Only
Course
1771-Bachelor of Laws (Honours) (Direct Entry)
1777-Bachelor of Laws (Direct Entry)
1827-Bachelor of International Studies - Bachelor of Laws
1845-Bachelor of Information Technology - Bachelor of Laws
1852-Bachelor of Business Information Systems - Bachelor of Laws
351-Bachelor of Laws (Honours)
760-Bachelor of Communication and Media Studies - Bachelor of Laws
770-Bachelor of Laws (Graduate Entry)
771-Bachelor of Arts - Bachelor of Laws
771H-Bachelor of Arts - Bachelor of Laws
772-Bachelor of Creative Arts - Bachelor of Laws
773-Bachelor of Commerce - Bachelor of Laws
774-Bachelor of Mathematics - Bachelor of Laws
775-Bachelor of Science - Bachelor of Laws
775H-Bachelor of Science - Bachelor of Laws
775M-Course information not Found
779-Bachelor of Engineering - Bachelor of Laws
858-Bachelor of Journalism - Bachelor of Laws
Work Experience No
Tutorial Enrolment Information Students should use the SMP OnLine Tutorial System (via SOLS) to enrol in Tutorial/laboratory groups for this subject. Once enrolments are open a link to the subject will appear in Tutorial Enrolments.

Subject Availability
Session Spring  (24-07-2017 to 16-11-2017)
Campus Wollongong
Delivery Method On Campus
Instance Name Class 1
Course Restrictions No restrictions
Contact Hours 3 hrs Lecture, 2hr lab
Lecturer(s) and
Cons. times
Janusz Getta
Coordinator(s) and
Cons. times
Janusz Getta
Instance Comment  
Census Date 31-08-2017

Subject Description
The subject addresses the problems related to performance of relational database systems. In its introductory part, the subject presents an internal architecture of relational database servers and typically available performance measurement and performance tuning software tools. Two groups of solutions are investigated: structural and operational. The structural solutions presented in the subject include denormalization of relational tables, indexing, clustering, partitioning, and creation of materialized views. The operational solutions presented in the subject include application of specialized SQL to performance tuning, optimization of SQL and PL/SQL, application of cost-based optimizations, and performance tuning through modification of parameters of relational database server.


Subject Learning Outcomes
On successful completion of this subject, students will be able to:
1. Combine performance measurement and performance tuning software tools to identify and to solve the performance problems in relational database systems.
2. Create denormalized relational tables, indexes, clusters, partitioned relational tables, and materialized views to improve performance of database systems.
3. Create advanced SQL statements to improve the performance of database systems.
4. Compare and create different implementations of SQL statements to improve the performance of database systems.
5. Summarise an internal architecture of relational database server and the roles of its components.
6. Estimate an impact on the appropriate configuration of system initialization parameters on the performance of relational database systems.
7. Summarise the principles of benchmarking in relational database management systems.

Extra Information
Generic Extra Information:
Assumed knowledge:Relational database model, SQL,Embedded SQL, JDBC,the basics of PL/SQL.

Textbook Information

Text book information is available via the UniShop website:



Search Criteria [Click here for help]
Subject Code / Name
Level
Department
Session
Campus
Delivery Method
General Subjects