Related Course/s:

A unit of study in the Bachelor of Business Information Systems, Bachelor of Business Information Systems/ Bachelor of Commerce, Bachelor of Information Technology and Bachelor of Science (Professional Software Development).

Aims & Objectives:

Students who complete this unit of study should be able to:

• Analyse performance requirements and define appropriate database structures for a given database system.
• Explain the various options for database performance tuning.
• Explain how a given query plan executes and be able to evaluate its effectiveness and take action to improve it.
• Apply physical design principles to a range of database systems including distributed, data warehouse and non-relational database systems.

Teaching Methods:

Lecture (24 hrs), Tutorial (Lab) (12 hrs)

Assessment:

Assignments, Examination

Content:

• Database structures.
• Database definition and creation.
• Physical design issues.
• Query optimisation.
• Performance tuning.
• Performance in distributed systems.
• Performance in data warehouse systems.
• Performance in non-relational database systems.

Reading Materials:

Hoffer, JA, Prescott, MB, McFadden, FR, Modern Database Management, 7th edn, Uppeer Saddle River, N.J., Prentice-Hall, 2005.

Kroenke, DM, Database Processing: Fundamentals Design and Implementation, Intl. edn, Upper Saddle River, N.J., Prentice-Hall, 2006

Rob, P, Coronel, C, Database Systems: Design, Implementation and Management, 6th edn, Boston, Thomson, 2004.

Simsion, GC, Witt, GC, Data Modeling Essentials, 3rd edn, San Franscisco, Morgan Kaufmann, 2005.

Watson, RT, Data Management: Databases and Organizations, New York, Wiley, 2004.