CP3020 - Advanced Data Management

[Offered in 2012 only]

Credit points:	03
Year:	2012
Student Contribution Band:	Band 2
Administered by:	School of Business

This subject provides student's with an understanding of the issues involved in the design of database management systems. Topics covered include transaction management, recovery and concurrency, security and authorisation, distributed database systems and an examination of advanced database technologies.

Learning Outcomes

• Understand how to perform query optimisation and database tuning;
• Understand the issues involved in the operation of a DBMS including transaction management, concurrency control, and recovery;
• Understand database security and different DBMS architectures including distributed databases, client/server systems and deductive databases;
• Be familiar with knowledge of new database developments including data warehouses and data mining.

Graduate Qualities

• The ability to adapt knowledge to new situations;
• The ability to define and to solve problems in at least one discipline area;
• The ability to think critically, to analyse and evaluate claims, evidence and arguments, and to reason and deploy evidence clearly and logically;
• The ability to select and organise information and to communicate it accurately, cogently, coherently, creatively and ethically;
• The ability to generate, calculate, interpret and communicate numerical information in ways appropriate to a given discipline or discourse.

Prerequisites:	CO3811 OR CP1500
Inadmissible Subject Combinations:	CP5520

Availabilities
Beijing UT, Internal, Study Period 69
Census Date 13-Dec-2012
Coordinator:	Dr Hossein Ghodosi
Lecturer:	Dr Kim Ku.
Contact hours:	26 hours lectures 12 hours tutorials
Assessment:	end of semester exam (50% - 60%); quizzes or tests (10% - 20%); assignments (20% - 40%).
Beijing UT, Internal, Study Period 68
Census Date 28-Jun-2012
Coordinator:	Dr Hossein Ghodosi
Contact hours:	26 hours lectures 12 hours tutorials
Assessment:	end of semester exam (50% - 60%); quizzes or tests (10% - 20%); assignments (20% - 40%).

Note: Minor variations might occur due to the continuous Subject quality improvement process, and in case of minor variation(s) in assessment details, the Subject Outline represents the latest official information.