Unit code: HIT3428
|Credit points||12.5 Credit Points|
|Duration||1 Semester or equivalent|
|Contact hours||36 Hours|
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 .
Aims and 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.
Reading materialsHoffer, 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.