mca Syllabus

Advanced Database Management Systems
Code: PGCS203
Weekly Contact Hour: 3L
Credit: 3

Course Contents
Physical storage and indexing structures, Query processing algorithms, Query optimization, Transaction processing and serializability, Concurrency Control, Recovery, Parallel and distributed databases, XQuery and XML query evaluation, Emerging database trends, data mining, data warehousing, distributed database, object oriented database, spatial and temporal database.

Books
1. Silberschatz, Korth & Sudarshan , “Database System Concepts, 5th Ed”, McGraw-Hill 2005.
2. Ceri, Pelagatti, “Distributed Databases Principles & Systems”, McGraw Hill
3. Hansen & Hansen, “Database Management and Design 2nd ed”, PHI
4. Shah, “Database Systems using Oracle:A simplified guide to SQL and PL/SQL 2nd ed”, PHI