CSVTU B.E. VII Semester Computer Science Engineering OODBMS Syllabus


Semester: VII Branch: Computer Science & Engg.

Subject: OODBMS

Unit I The Extended Entity Relationship Model and Object Model:

 The ER model

revisited, Motivation for complex data types, User defined abstract data types and structured


types, Subclasses, Super classes, Inheritance, Specialization and Generalization, Constraints


and characteristics of specialization and Generalization, Relationship types of degree higher


than two.


Unit II. Object-Oriented Databases:


Overview of Object-Oriented concepts, Object identity,

Object structure, and type constructors, Encapsulation of operations, Methods, and


Persistence, Type hierarchies and Inheritance, Type extents and queries, Complex objects;


Database schema design for OODBMS; OQL, Persistent programming languages; OODBMS


architecture and storage issues; Transactions and Concurrency control, Example of ODBMS


Unit III. Object Relational and Extended Relational Databases:


Database design for an

ORDBMS – Nested relations and collections; Storage and access methods, Query processing


and Optimization; An overview of SQL3, Implementation issues for extended type; Systems


comparison of RDBMS, OODBMS, ORDBMS


Unit IV. Parallel and Distributed Databases and Client-Server Architecture:



for parallel databases, Parallel query evaluation; Parallelizing individual operations, Sorting,


Joins; Distributed database concepts, Data fragmentation, Replication, and allocation


techniques for distributed database design; Query processing in distributed databases;


Concurrency control and Recovery in distributed databases. An overview of Client-Server




Unit V. Databases on the Web and Semi Structured Data:


Web interfaces to the Web,

Overview of XML; Structure of XML data, Document schema, Querying XML data; Storage of


XML data, XML applications; The semi structured data model, Implementation issues, Indexes


for text data.


Enhanced Data Models for Advanced Applications:

Active database

concepts. Temporal database concepts.; Spatial databases, Concepts and architecture;


Deductive databases and Query processing; Mobile databases, Geographic information





Name of Text Books:

1. Rajesh Narang, Object Oriented Interfaces and Databases,Prentice Hall of India

2. Raghu Ramakrishnan, Johannes Gehrke, Database Management Systems [3e],


Name of Reference books:

1 Elmasri and Navathe, Fundamentals of Database Systems [4e], Pearson Education

2. Korth, Silberchatz, Sudarshan , Database System Concepts, McGraw-Hill.

3. Peter Rob and Coronel, Database Systems, Design, Implementation and


4. C.J.Date, Longman, Introduction To Database Systems, Pearson Education

Leave a Comment