Relational Database Management Systems
COMP5138
This unit of study provides a conceptual and practical introduction to the use of common platforms that manage large relational databases. Students will understand the foundations of database management and enhance their theoretical and practical knowledge of the widespread relational database systems, as these are used for both operational (OLTP) and decision-support (OLAP) purposes. The unit covers the main aspects of SQL, the industry-standard database query language. Students will further develop the ability to create robust relational database designs by studying conceptual modelling, relational design and normalization theory. This unit also covers aspects of relational database management systems which are important for database administration. Topics covered include storage structures, indexing and its impact on query plans, transaction management and data warehousing.Objectives: In this unit students will develop the ability to:- Understand the foundations of database management;- Strengthen their theoretical knowledge of database systems in general and relational data model and systems in particular;- Create robust relational database designs;- Understand the theory and applications of relational query processing and optimization;- Study the critical issues in data and database administration;- Explore the key emerging topics in database management. Note: The lectures of this semester 1 version of COMP5138 is co-taught with INFO2120, the undergraduate database lecture.
Unit of study details
Unit of study level: Postgraduate
Credit points: 6
Commencing semesters: 1, 2
Further unit of study information
Unit of study handbook: COMP5138
Costs and scholarships information: Costs and Scholarships
Final dates to withdraw from units of study: Census Dates
Available for study abroad and exchange: No