Course Details

Course Information Package

Course Unit TitleADVANCED DATABASE SYSTEMS
Course Unit CodeACSC384
Course Unit DetailsBSc Computer Science (Required Courses) -
Number of ECTS credits allocated6
Learning Outcomes of the course unitBy the end of the course, the students should be able to:
  1. To describe in details the functions and role of DBMS as an interface between end users and database. To define transactions and supporting mechanisms embedded in DBMS for working with them in concurrent computing environment, including recovery and security of databases.
  2. To show both in theory and practice the programmatic use of databases on the example of connecting applications to database system.
  3. To show the nature of object-oriented databases and their practical use. The students to have the ability to analyze the problem domain and make selection of respective relational or object-oriented database.
  4. To describe and compare the basic models and mechanisms for development and use of distributed databases for supporting distributed applications, including Internet/Web applications.
  5. To build ability of students to apply XML databases, based on the characteristics of XML as a machine-readable tool for exchanging data.
Mode of DeliveryFace-to-face
PrerequisitesACSC223Co-requisitesNONE
Recommended optional program components

Course Contents

Preview: Preview of data models. Relational Database Systems – Architecture and implementation models.  Design of database systems.

Programmatic Use of Database Systems:  Connecting databases to applications. Mechanisms of using MySQL database system from Java, C/C and C# applications.

DBMS Functionalities: Transactions, Concurrency, Recovery and Security.

Database Systems Administration:  Data Administration and Database Administration.

Introduction to Object-Oriented Database Systems: The Object Data Model. Object-Oriented DBMS and Object-Relational DBMS.

Introduction to Distributed Database Systems: Concepts, Architecture and Functions. Database Pooling and Replication. Mobile Databases.

Introduction to XML Database Systems: Semistructured Data and XML. Development of XML - based Applications using Native XML Databases and Relational Databases. 

Recommended and/or required reading:
Textbooks
  • Thomas M. Connolly, Carolyn E. Begg, Database Systems: A Practical Approach to Design, Implementation, and Management, 5th Edition, Addison-Wesley Publishing, 2010.
References
  • Ramez A. Elmasri, Shamkant B. Navathe, Fundamentals of Database Systems, 6th Edition, Addison-Wesley Publishing, 2011.
  • Raghu Ramakrishnan, Johannes Gehrke, Database Management Systems, 3rd Edition McGraw-Hill Higher Education, 2002.
  • Stefan Edlich , Henrik Hörning , Reidar Hörning , Jim Paterson, The Definitive Guide to db4o, Apress, 2006.
  • Db4o Database Documentation
  • Java, C/C++ and C# documentation for connecting relational databases
Planned learning activities and teaching methodsFor the delivery of the class material, power point presentations are primarily used, along with the whiteboard. The lecture notes, consisting of slides presented in class, and additional material, are made available to the students through the course website. The students have intensive work in the lab on programmatic use of relational databases and related assignments.
Assessment methods and criteria
Assignments15%
Lab and assignments 25%
Final Exam60%
Language of instructionEnglish
Work placement(s)NO

 Εκτύπωση  Ηλεκτρονικό ταχυδρομείο