Advanced Database Systems

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

Upon successful completion of this course students will be able to:

  • Develop the logical model of a relational database
  • Use essential SQL tools to program commercial database systems
  • Understand advanced concepts of database management and architecture
  • Organize, store and process data efficiently, using contemporary methods.
  • Understand and apply emerging technologies, including Data Mining, Information Retrieval and XML.
  • Undertake a practical database management project.

 

Content

  • ER model, relational model, mapping ER to relational model and basic SQL
  • Indexing, query processing and optimization
  • Parallel, Distributed and Spatial databases and spatial query processing
  • Hadoop ecosystem and mapreduce
  • Data Warehousing and OLAP
  • Data Mining and Business Intelligence
  • Information Retrieval, Web Search and XML

 

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.