Syllabus

Course Code: MT-CSE-20-14    Course Name: Elective- II - (i) Distributed Systems

MODULE NO / UNIT COURSE SYLLABUS CONTENTS OF MODULE NOTES
1 Introduction to Distributed Data Processing and Distributed Database System; Features of Distributed Databases, An Example of Distributed DBMS, Types of DDBS, Promises and Complications in a Distributed DBMS; Functions and Objectives of Distributed DBMS, Distributed DBMS Architecture: Client/Server System, Peer-to-Peer Distributed System, Multi Database System (MDBS).
2 Distributed Database Design: Top-down Design Process, Designing Process and Issues, Data Fragmentation: Benefits, Correctness Rules and Types of Fragmentation, Allocation: Measures of Cost and Benefits for Fragment Allocation, Database Integration: Schema Matching, Schema Integration, Schema Mapping. Data and Access Control: View Management, Data Security, Semantic Integrity Control.
3 Distributed Query Processing: Concept and Objectives of Query Processing; Phases/ Layers of Query Processing: Query Decomposition, Query Fragmentation; Global Query Optimization; Local Query Optimization, Join Strategies in Fragmented Relations, Global Query Optimization Algorithms. Distributed Database Security and Catalog Management.
4 Concurrency Control In Centralized Database Systems; Concurrency Control In DDBMS; Distributed Concurrency Control Algorithms; Deadlock Management, Reliability Issues In DDBMS; Types of Failures; Reliability Techniques; Commit Protocols; Recovery Protocols.
Copyright © 2020 Kurukshetra University, Kurukshetra. All Rights Reserved.