CS712 Distributed DBMS

CS712 Distributed DBMS


Introduction to Databases and Distributed Database Systems, Background (Relational Data Model, Computer Networks), Distributed Database Architectures, Distributed Database Design, Horizontal Fragmentation, Vertical Fragmentation, Replication, Introduction to Transaction Management, Distributed Concurrency Control, Introduction to Query Processing, Query Processing in Distributed Databases, Query Optimization, Introduction to Parallel Processing, Parallel DBMSs Issues, Distributed Object Database Management Systems, Database Interoperability.

Course Synopsis

Use of distributed systems has become a common practice in today’s computing environment especially with the easy access of the internet. Distributed Database Systems (DDBSs), however, are generally implemented in relatively large organizations and need better understanding of the database and networking concepts. The same two concepts provide the foundation of this course. The emphasis in this course is on the design and management issues of a DDBS and at the same time on the implementation issues. The course starts with the basic definitions of DDBS and related concepts. Then the background concepts of database systems and networking are discussed. After that the major architectures of the DDBSs are discussed followed by design issues of a DDBS. This part of DDBS design concentrates on the fragmentation and its different types. In order to give a better and clearer understanding of the fragmentation, different examples using leading DDBMSs are presented. The second alternative for the implementation of DDBSs is replication, which is discussed with examples. After that, the issues related to DDBS administration are discussed, like, Failure recovery, transaction management and concurrency control. Advanced topics like Parallel Databases, Object Distributed Databases, and Multidatabases are discussed for the interested students something to think and work on. The environment used for demonstration will be Windows-based and Microsoft SQL Server and Oracle will be used as tools.

Course Learning Outcomes

Upon successful completion of this course, students should be able to:

  • Understand major architectures of the DDBSs.
  • Understand design issues of a DDBS.
  • Understand fragmentation and its different types.
  • Understand the concepts of replication.
  • Understand administration issues of DDBS, like failure recovery, transaction management and concurrency control.
  • Develope basic concepts of parallel databases, object distributed databases, and multidatabases.

Download Section

CS712 Handouts (1-22)

CS712 Handouts (23-45)

CS712 PPT Slides

CS712 Video Lectures

CS712 Midterm

CS712 Final Term

CS712 Viva