Questions
Syllabus
Qns. By Syllabus

Semester

Subject

Bachelors Level/Fourth Year/Eighth Semester/Science csit/eighth semester/distributed and object oriented database/syllabus

B.Sc Computer Science and Information Technology

Institute of Science and Technology, TU

Nature of the course: (Theory+Lab)

F.M: 60+20+20 P.M: 24+8+8

Credit Hrs: 3Hrs

Distributed and Object Oriented Database [CSC480]
Course Objective
i.
Discuss basic concepts related to distribute DBMS.
ii.
Exemplify design of distributed database.
iii.
Describe distributed query processing and concurrency control.
iv.
Discuss basic concepts of OODBMS.
v.
Demonstrate language and design for distributed database.
Course Description

This course aims to discuss concepts of distributed and object oriented database management systems. Main focus is given to basic concepts of DDBMS, distributed database design, distributed query processing, distributed concurrency control, concepts of OODBMS, and language and design of object oriented database.

S1:Introduction to Distributed Database[4]
1
Distributed Data Processing, Distributed Database Systems, Promises of DDBS, Complicating Factors, Design Issues of DDBMS, and Distributed DBMS Architectures: Autonomy, Distribution, Heterogeneity DDBMS Architecture – Client/Server, Peer to peer, MDBS.
S2:Distributed Database Design and Access Control[4]
1
Top-Down Design Process, Distribution Design Issues, Fragmentation, Allocation, Data Directory, View Management, Data Security, Semantic Integrity Control.
S3:Query Processing, Decomposition, and Localization[6]
1
Query Processing Problem, Objectives of Query processing, Complexity of RA Operations, Characterization of Query Processors, Layers of Query Processing, Query Decomposition, Localization of Distributed Data.
S4:Distributed Concurrency Control[8]
1
Serializability Theory, Taxonomy of Concurrency Control Mechanisms, Lock Based Concurrency Control Algorithms, Time-Stamp Based Concurrency Control Algorithms, Optimistic Concurrency Control Algorithms, Deadlock management.
S5:Object Oriented Database Concepts[6]
1
Overview of Object-Oriented Concepts, Object Identity, Object Structure, and Type Constructors, Encapsulation of Operations, Methods, and Persistence, Type Hierarchies and Inheritance, Complex Objects, Other Objected-Oriented Concepts
S6:OODBMS Languages and Design[6]
1
Object Model, Object Definition Language, Object Query Language, Object Database Conceptual Design, Examples of ODBMSs
References
1.
M. Tamer Özsu and Patrick Valduriez, Principles of Distributed Database Systems, Fourth Edition, Springer, 2019
2.
ElmasriRamez and NavatheShamkant, Fundamentals of Database System, Seventh Edition, Pearson Education, 2017
Labrotary Work
Students should implement all the concepts of object oriented and distributed databases mentioned in the course.