Advanced Database Systems

Instructor(s):Dr Christos Tjortjis

Instructor(s): Prof. C. Tjortjis
Teaching Hours and Credit Allocation: 30 Hours, 6 Credits
Course Assessment: Exam & Coursework

 

Aims

The course aims to familiarise students with contemporary database systems, as well as emerging database technologies. It discusses basic aspects of advanced database techniques and exposes tools and technologies that can be used along with “core” database systems. Students are expected to engage in practical database system design through a series of assignments and coursework. The emphasis in the lectures will be on general concepts and theoretical foundations. In addition to the theoretical concepts, the course will require students to use commercial database systems and develop a class project.

 

Learning Outcomes

  • On completing the course, students will be able to:
  • Develop the logical model of a relational database.
  • Use essential SQL tools to program DB systems.
  • Understand advanced concepts of DM management and architecture.
  • Organize, store and process data efficiently, using contemporary technologies such as Data Warehouses.
  • Understand and apply various emerging technologies, including Data Mining, OLAP, Information Retrieval, and Search engines.
  • Understand and utilise knowledge extracted from large volumes of data.

 

Content

  • ER model, relational model.
  • SQL.
  • Indexing.
  • Query processing and optimization.
  • Data warehousing and OLAP.
  • Data Mining and Business Intelligence.
  • Information Retrieval.
  • Web Search.

 

Reading

  • Elmasri R., Navathe S. B., (2010), Fundamentals of Database Systems: Global Edition, 6th Edition, Pearson.
  • Garcia-Molina H., Ullman J., and Widom J., (2009), Database Systems: The Complete Book, 2nd edition, Pearson.
  • Silberschatz A., Korth H., and Sudarshan S., (2010), Database System Concepts, 6th Edition, McGraw-Hill.
  • Ramakrishnan R, Gehrke J. (2002), Database Management Systems, 3rd edition, McGraw-Hill Science/Engineering/Math.