This page contains Syllabus of Distributed and Object Oriented Database of CSIT.
|Title||Distributed and Object Oriented Database|
|Nature of course||Theory + Lab|
|Full marks||60 + 20 + 20|
|Pass marks||24 + 8 + 8|
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.
• Discuss basic concepts related to distribute DBMS.
• Exemplify design of distributed database.
• Describe distributed query processing and concurrency control.
• Discuss basic concepts of OODBMS.
• Demonstrate language and design for distributed database.
Units and Unit Content
- 1. Introduction to Distributed Database,Distributed Database Architectures,Distributed Database Design
- teaching hours: 12 hrs
1.1 Introduction to Distributed Database: Distributed Data Processing, Concept of
Distributed Database. Distributed vs Centralized Database System; advantages
and Application. Transparency, performance and reliability. Problem areas of
Distributed Database. Integrity Constraints in Distributed Databases.
1.2 Distributed Database Architectures: DBMS standardization. Architectural
models for Distributed DBMS – autonomy, distribution and heterogeneity.
Distributed Database architecture – Client/Server, Peer-to-Peer distributed
systems, MDBS Architecture. Distributed Catalog management.
1.3 Distributed Database Design: Design strategies and issues. Data Replication.
Data Fragmentation – Horizontal, Vertical and Mixed. Resource allocation.
Semantic Data Control in Distributed DBMS.
- 2. Distributed Query Processing,Distributed Transaction Management, Distributed Concurrency Control,Reliability of Distributed DBMS and Recovery
- teaching hours: 17 hrs
2.1 Distributed Query Processing: Query Decomposition and Data localization for
distributed data, join ordering, semi-join strategy, Distributed Query optimization
2.2 Distributed Transaction Management: The concept and role of transaction.
Properties of transactions-Atomicity, Consistency, Isolation and Durability.
Architectural aspects of Distributed Transaction, Transaction Serialization.
2.3 DistributedConcurrency Control: Lock-based and Timestamp-based
Concurrency Control methods. Optimistic method for Concurrency Control.
Deadlock management- prevention, avoidance detection, and resolution. Non-
serializable schedule and nested distributed transaction.
2.4 Reliability of Distributed DBMS and Recovery: Concept and measures of
reliability, Failure analysis, types of failures. Distributed Reliability Protocols.
Recovery techniques. Two Phase Commit , Presumed abort, Presumed commit.
Three phase commit, Partitions, Scalability of Replication.
- 3. Object Oriented Database Concept, OODBMS Architecture Approach,The Object Oriented DBMS Architecture
- teaching hours: 16 hrs
3.1 Object Oriented Database Concept: Data types and Object, Evolution of Object
Oriented Concepts, Characteristics of Object Oriented Data Model. Object
Hierarchies - Generalization, Specialization, Aggregation. Object Schema. Inter-
object Relationships, Similarities and difference between Object Oriented
Database model and Other Data models.
3.2 OODBMS Architecture Approach: The Extended Relational Model Approach.
Semantic Database Approach, Object Oriented Programming Language Extension
Approach, DBMS Generator Approach, the Object Definition Language and the
Object Query Language.
3.3 The Object Oriented DBMS Architecture, Performance Issue in Object Oriented
DBMS, Application Selection for Object Oriented DBMS, the Database Design
for an Object Relational DBMS. The Structured Typed and ADTs, Object
identity, Extending the ER Model ,Storage and Access Methods, Query
Processing Query Optimization, Data Access API(ODBC,DB Library,
DAO,ADO,JDBC,OLEDB), Distributed Computing Concept in COM, COBRA.
Lab and Practical works
Students should implement all the concepts of object oriented and distributed databases mentioned
in the course.