Graduate Study - Faculty of Engineering and Natural Sciences
PhD Information Technology

Code Name Level Year Semester
CEN 633 Advanced Database Systems Graduate 1 Spring
Status Number of ECTS Credits Class Hours Per Week Total Hours Per Semester Language
6 145 English

Instructor Assistant Coordinator
Jasmin Azemović, Assoc. Prof. Dr. Jasmin Azemovic Jasmin Azemović, Assoc. Prof. Dr.
[email protected] [email protected] no email

This course covers following: serializability theory; locking, timestamp-ordering, optimistic schedulers; multiversion and distributed concurrency control; distributed atomic commitment protocols; multidatabase systems; active database systems; real-time database systems; object-oriented database systems.

Objective of this course is to introduce students to basic issues in object–oriented data models, learn about the Web–DBMS integration technology and XML for internet database applications, familiarize with the data–warehousing and data mining techniques and other advanced topics, and apply the knowledge acquired to solve simple problems.

  1. The Extended Entity Relationship Model and Object Model
  2. Object–Oriented databases and Object–Oriented concepts
  3. Object structure and type constructors
  4. OODBMS architecture and storage issues
  5. Transactions and concurrency control
  6. Object Relational and Extended Relational Databases
  7. Architectures for parallel databases
  8. Midterm Exam
  9. Distributed database concepts; data fragmentation
  10. Replication and allocation techniques for distributed database design
  11. Query processing in distributed databases
  12. Concurrency control and recovery in distributed databases
  13. An overview of client–server architecture
  14. Databases on the Web and Semi–Structured Data
  15. Enhanced Data Models for Advanced Applications


    • Interactive Lectures
    • Discussions and group work
    Description (%)
    Method Quantity Percentage (%)
    +Research Paper1100
    Total: 100
    Learning outcomes
    • Explain and evaluate the fundamental theories and requirements that influence the design of modern database systems.
    • Assess and apply database functions and packages suitable for enterprise database development and database management.
    • Critically evaluate alternative designs and architectures for databases and data warehouses.
    • Discuss and evaluate methods of storing, managing and interrogating complex data.
    • Explain and critically evaluate database solutions for data exchange.
    • Analyze the background processes involved in queries and transactions, and explain how these impact on database operation and design.
    • Elmasri and Navathe, Fundamentals of Database Systems

    ECTS (Allocated based on student) WORKLOAD
    Activities Quantity Duration (Hour) Total Work Load
    Lecture (14 weeks x Lecture hours per week)15345
    Laboratory / Practice (14 weeks x Laboratory/Practice hours per week) 0
    Midterm Examination (1 week) 0
    Final Examination(1 week) 0
    Preparation for Midterm Examination 0
    Preparation for Final Examination 0
    Assignment / Homework/ Project1100100
    Seminar / Presentation 0
    Total Workload: 145
    ECTS Credit (Total workload/25): 6