MT-CSE-18-14(ii): Distributed Systems Maximum marks: 150 (External: 100, Internal: 50) Time: 3 hours Credits: 4 Note: Examiner will be required to set NINE questions in all. Question Number 1 will consist of objective type/short-answer type questions covering the entire syllabus. In addition to question no. 1, the examiner is required to set eight more questions selecting two from each unit. Student will be required to attempt FIVE questions in all. Question Number 1 will be compulsory. In addition to compulsory question, student will have to attempt four more questions selecting one question from each Unit. All questions will carry equal marks. Objectives: To introduce the fundamental concepts and issues of managing large volume of shared data in a parallel and distributed environment, and to provide insight into related research problems. Learning Outcomes: At the end of this course students should be able to: Design trends in distributed systems. It will help in applying network virtualization, remote method invocation and objects. Unit 1 Introduction to distributed data processing and distributed database system; Advantages and disadvantages of DDBS; Types of DDBS, Promises and Complications in a distributed DBMS; Distributed DBMS architecture. Unit 2 Distributed Database Design: Top-down design process, Designing Process and Issues, Fragmentation, Allocation, Database Integration: Schema Matching, schema integration, schema mapping. Data and access control: view management, data security, semantic integrity control. Unit 3 Objectives of query processing; Characterization of query processors; Layers of query processing; Query decomposition; Localization of distributed data, Optimization of Distributed Queries: Centralized query optimization; Distributed Query optimization. Unit 4 Concurrency control in centralized database systems; Concurrency control in DDBSs; Distributed concurrency control algorithms; Deadlock management, Reliability issues in DDBSs; Types of failures; Reliability techniques; Commit protocols; Recovery protocols. Introduction and implementation to SQL and Python. References Principles of Distributed Database Systems, M.T. Ozsu and P. Valduriez, Prentice-Hall, 1991. Distributed Database Systems, D. Bell and J. Grimson, Addison-Wesley, 1992.
MT-CSE-18-14(ii): Distributed Systems Maximum marks: 150 (External: 100, Internal: 50) Time: 3 hours Credits: 4 Note: Examiner will be required to set NINE questions in all. Question Number 1 will consist of objective type/short-answer type questions covering the entire syllabus. In addition to question no. 1, the examiner is required to set eight more questions selecting two from each unit. Student will be required to attempt FIVE questions in all. Question Number 1 will be compulsory. In addition to compulsory question, student will have to attempt four more questions selecting one question from each Unit. All questions will carry equal marks. Objectives: To introduce the fundamental concepts and issues of managing large volume of shared data in a parallel and distributed environment, and to provide insight into related research problems. Learning Outcomes: At the end of this course students should be able to: Design trends in distributed systems. It will help in applying network virtualization, remote method invocation and objects. Unit 1 Introduction to distributed data processing and distributed database system; Advantages and disadvantages of DDBS; Types of DDBS, Promises and Complications in a distributed DBMS; Distributed DBMS architecture. Unit 2 Distributed Database Design: Top-down design process, Designing Process and Issues, Fragmentation, Allocation, Database Integration: Schema Matching, schema integration, schema mapping. Data and access control: view management, data security, semantic integrity control. Unit 3 Objectives of query processing; Characterization of query processors; Layers of query processing; Query decomposition; Localization of distributed data, Optimization of Distributed Queries: Centralized query optimization; Distributed Query optimization. Unit 4 Concurrency control in centralized database systems; Concurrency control in DDBSs; Distributed concurrency control algorithms; Deadlock management, Reliability issues in DDBSs; Types of failures; Reliability techniques; Commit protocols; Recovery protocols. Introduction and implementation to SQL and Python. References Principles of Distributed Database Systems, M.T. Ozsu and P. Valduriez, Prentice-Hall, 1991. Distributed Database Systems, D. Bell and J. Grimson, Addison-Wesley, 1992.
Final%20SCHEME%20OF%20M_Tech_%20CSE%20%202018-19.docx