MNIT Jaipur Syllabus IT Advanced Topics in Data Bases
Advanced Topics in Data Bases
Transaction Management – Transaction Processing, Concurrency Control, Recovery Management.
Advanced SQL – Complex queries, Nested Subqueries, Views, Materialized Views, Triggers, Referential
Integrity, Security and Authorization.
Query Processing and Query Optimizations.
Database System Architectures, Distributed Databases, Distributed Transactions, Distributed Query
1. Silberschatz A, Korth HF, Sudarshan S, Database System Concepts, McGrall Hill.
2. Elmasri R and Navathe SB, Fundamentals of Database Systems, 3rd Edition, Addison
Wesley,2000. This book covers most of the material on the course.
3. Date CJ, An Introduction to Database Systems, 7th Edition, Addison Wesley.