CS 755 Distributed Database Systems

Note: The following provides a suggested course description, objectives, and an outline. These may be modified pending discussion with the Faculty Chairs, proposing faculty, and other curriculum reviewers.

Course Description: Architecture of distributed database management systems; data fragmentation, replication, and allocation; query optimization and transaction management; distributed concurrency control.

Course Objectives: The major objective of this course is to introduce the student to the theory, algorithms, and methods that underlie distributed database management systems. The student should also acquire insights into distributed DBMS architecture, query decomposition and data localization, transaction management, and distributed concurrency control.

Course Outline by Topical Areas:

  • Distributed data processing. Review of Relational DBMS. Review of Computer Networks.
  • Distributed DBMS architecture. Client/Server systems, peer-to-peer distributed systems, and multi-database systems.
  • Semantic data control. View management. Data security. Semantic integrity control.
  • Query processing. Query decomposition. Localization of distributed data.
  • Transaction management. Properties and types of transactions.
  • Concurrency control mechanisms and algorithms. Deadlock management .