Home                                                                                                                                                     Back

B.E. Semester - VI (CE)

CE-603 : Advance DBMS

    v  OBJECTIVES :--

To study the further database techniques beyond which covered in the second year, and thus to acquaint the students with some relatively advanced issues. At the end of the course students should be able to : gain an awareness of the basic issues in objected oriented data models, learn about the Web-DBMS integration technology and XML for Internet database applications, familiarize with the data-warehousing and data-mining techniques and other advanced topics, apply the knowledge acquired to solve simple problems.

v     Pre – requisites : -- Database Syatem, OOAD.

 DETAILED SYLLABUS

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

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

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

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

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

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

v     BOOKS :--

     1.      Elmasri and Navathe, “fundamentals of Database Systems”, Pearson Education.

    2.      Raghu Ramakrishnan, Johannes Gehrke, “Database Management Systems”, McGraw-Hill.

v     References :--

     1.      Korth, Silberchatz, Sudarshan, “Database System Concepts”, McGraw-Hill.

    2.      Peter Rob and Coronel, “Database Systems, Design, Implementation and Management”, Thomson Learning.

    3.      C.J.Date, Longman, “Introduction To Database Systems”, Pearson Education.