CSVTU BE VII Semester IT OODBMS Syllabus

CHHATTISGARH SWAMI VIVEKANAND TECHNICAL UNIVERSITY, BHILAI (C.G.)

Semester: VII Branch: Information Technology.

Subject: OODBMS

Total Theory Periods: 50 Total Tutorial Periods: Nil

Total Marks in End Semester Exam: 80.

Minimum number of class tests to be conducted: 02

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

:

 

Architectures 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 architecture

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 systems.

 

 

Text Books:

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

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

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 Management, Thomson

Learning.

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

Leave a Comment