COMP207

Database Development

Aims

  1. To introduce students to the problems arising from concurrency in databases, information security considerations and how they are solved
  2. To introduce students to the problems arising from the integration of heterogeneous sources of information and the use of semi-structured data;
  3. To introduce students to non-relational databases and the economic factors involved in their selection
  4. To introduce students to techniques for analyzing large amounts of data, the security issues and commercial factors involved with them

Syllabus

  • Advanced SQL topics (2 lectures): Triggers, indexes and materialised view
  • Query optimisation (3 lectures): Relational Algebra
  • Transaction management (9 lectures): Transaction management, recoverability and security
  • Object relational databases (3 lectures): Structure and economic factors in their deployment
  • Distributed databases (3 lectures): Models and security issues
  • Web technologies and DBMS (6 lectures): Semistructured databases and connectivity
  • Data warehousing and data mining (4 lectures): Platforms, security and commercial aspects

Recommended Texts

The main textbooks are:

  • R. Elmasri, and S.B. Navathe: Fundamentals of Database Systems. (Addison-Wesley most recent edition)
  • H. Garcia-Molina, J. D. Ullman, and J. Widom: Database Systems: The Complete Book (Prentice Hall most recent edition)
  • T. Connolly and C. Begg: Database Systems (Addison-Wesley most recent edition)

Learning Outcomes

At the end of this module the student will be able to:

  1. Identify and apply the principles underpinning transaction management within DBMS and the main security issues involved in securing transactions
  2. Demonstrate an understanding of advanced SQL topics;
  3. Illustrate the issues related to Web technologies as a semi-structured data representation formalism;
  4. Identify the principles underlying object relational models and the economic factors in their uptake and development
  5. Interpret the main concepts and security aspects in data warehousing, and the concepts of data mining and commercial considerations involved in adopting the paradigm

Learning Strategy

Formal Lectures: In a typical week, students will be expected to attend three hours of formal lectures. Formal lectures will be used to introduce students to the concepts and methods covered by the module.

Practicals and Tutorias: In a typical week, students will be expected to attend one hour of tutorials or computer lab practicals. Computer lab practicals are intended to allow students to undertake practical exercises with the possibility of immediate feedback. The lab exercises will focus on the design and implementation of applications that exploit and utilise the approaches discussed in the lectures.

Private study: In a typical week students will be expected to devote about 6 hours of unsupervised time to private study. Private study will provide time for reflection and consideration of lecture material, background reading and completion of the assessment tasks.

Assessment: Continuous assessment will be used to test to what extent practical skills have been learnt. A final examination at the end of the module will assess the academic achievement of students.