Scribd
Upload
484 views2 pages

ADBMS Syllabus

This document provides information about an Advanced DBMS course. The course objective is to expose students to database implementation techniques. The course covers topics like relational databases, query processing and optimization, parallel and distributed databases, advanced transaction processing, and multimedia databases. The course contents are divided into four modules covering these topics. Student performance will be evaluated through class tests, home assignments, seminars/vivas/quizzes, and an end semester examination. Several textbooks and references are provided.

Uploaded by

Deep Saini
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
484 views2 pages

ADBMS Syllabus

This document provides information about an Advanced DBMS course. The course objective is to expose students to database implementation techniques. The course covers topics like relational databases, query processing and optimization, parallel and distributed databases, advanced transaction processing, and multimedia databases. The course contents are divided into four modules covering these topics. Student performance will be evaluated through class tests, home assignments, seminars/vivas/quizzes, and an end semester examination. Several textbooks and references are provided.

Uploaded by

Deep Saini
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 2

ADVANCED DBMS

Course Code: MTC 208 Credit Units: 04



Course Objective:
The objective of this course is to expose the students to the implementation techniques of database system. This
course explains techniques for query processing and optimization with transaction and concurrency control
techniques

Course Contents:

Module I: Relational Databases
Integrity Constraints revisited, Extended ER diagram, Relational Algebra & Calculus, Functional, Muiltivalued and
Join Dependency, Normal Forms, Rules about functional dependencies.

Module II: Query Processing and Optimization
Valuation of Relational Operations, Transformation of Relational Expressions, Indexing and Query Optimization,
Limitations of Relational Data Model, Null Values and Partial Information.
Objected Oriented and Object Relational Databases
Modeling Complex Data Semantics, Specialization, Generalization, Aggregation and Association, Objects, Object
Identity, Equality and Object Reference, Architecture of Object Oriented and Object Relational Databases

Module III: Parallel and Distributed Databases
Distributed Data Storage Fragmentation & Replication, Location and Fragment
Transparency Distributed Query Processing and Optimization, Distributed Transaction Modeling and concurrency
Control, Distributed Deadlock, Commit Protocols, Design of Parallel Databases, Parallel Query Evaluation.
Advanced Transaction Processing
Nested and Multilevel Transactions, Compensating Transactions and Saga, Long Duration Transactions, Weak
Levels of Consistency, Transaction Work Flows, Transaction Processing Monitors.

Module IV
Multimedia databases, Databases on the Web and SemiStructured Data
Case Study: Oracle Xi

Examination Scheme:

Components A CT S/V/Q HA EE
Weightage (%) 5 10 8 7 70
CT: Class Test, HA: Home Assignment, S/V/Q: Seminar/Viva/Quiz, EE: End Semester Examination; Att:
Attendance

Text & References:

Text:
Elmarsi, Navathe, Somayajulu, Gupta, Fundamentals of Database Systems, 4
th
Edition, Pearson Education,
2007
Garcia, Ullman, Widom, Database Systems, The complete book, Pearson Education, 2007
R. Ramakrishnan, Database Management Systems, McGraw Hill International Editions, 1998

References:
Date, Kannan, Swaminathan, An Introduction to Database Systems, 8th Edition Pearson Education, 2007
Singh S.K., Database System Concepts, design and application, Pearson Education, 2006.
Silberscatz, Korth, Sudarshan, Database System Concepts, Mcgraw Hill, 6
th
Edition, 2006
W. Kim, Modern Database Systems, 1995, ACM Press, Addision Wesley,
D. Maier, The Theory of Relational Databases, 1993, Computer Science Press, Rokville, Maryland
Ullman, J. D., Principals of database systems, Galgotia publications, 1999
Oracle Xi Reference Manual
Dietrich, and Urban, An Advanced Course in Database Systems, Pearson, 2008.

You might also like