ECTS credits: 5
Lectures: 2
Exercises: 1

Course objective:

To inform the students about the architecture and principles of work of distributed databases.

Course contents:

Definition of distributed system for database management. DDBMS classification. Architecture of distributed system. Data fragmentation and allocation. Chris Dates rules. Distributed processing of queries and distributed updating. Catalogs. Distributed transactions (coherency, two phases’ situation, time indication, recuperation). Transaction protocols. Data synchronization. Heterogeneous distributed systems. Decomposition and query processing. Optimizing distributed queries. Competitiveness check. Reliability and security of distributed databases system.

Competences:

Student shall learn the architecture, protocols and issues related to distributed system for database management. Acquisition of skills for decomposition and processing queries in distributed databases.

Learning outcomes:

Having passed the exam, the student will be able to: 1. Explain the architecture of a system based on distributed databases. 2. Develop a system to support distributed transactions in such databases. 3. Provide for competitive access to data in systems using distributed databases. 4. Propose solutions for increasing reliability and security of distributed database system. 5. Compare different systems for managing distributed databases (DDBMS). Mentioned learning outcomes contribute to learning outcomes of the study programmes: - Present the use of information systems (3). - Propose solutions to engineering problems in the profession (4). - Present one's own or team work (11). - Use professional literature and search accessible information bases and knowledge bases (12).