CHHATTISGARH SWAMI VIVEKANAND TECHNICAL UNIVERSITY, BHILAI (C.G.)
Semester: VII Branch: Information Technology.
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
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
Active database concepts. Temporal database concepts.;
Spatial databases, Concepts and architecture; Deductive databases and Query
processing; Mobile databases, Geographic information systems.
1. Rajesh Narang, Object Oriented Interfaces and Databases,Prentice Hall of India
2. Raghu Ramakrishnan, Johannes Gehrke, Database Management Systems [3e], McGraw-Hill
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
4. C.J.Date, Longman, Introduction To Database Systems, Pearson Education