Course Title: 
Advanced Databases
Course Code: 
Year Taught: 
Postgraduate (PG)
School of Engineering

'Advanced Databases' is a course offered in third semester of M. C. A. (Master of Computer Applications) program at School of Engineering, Amrita Vishwa Vidyapeetham, Amritapuri.

Introduction to Object Oriented Database: Abstraction, encapsulation, and information hiding, Classes, Inheritance Overloading Polymorphism and dynamic binding - Object-Oriented Data Model. Complex Data Types – Structured Types and Inheritance in SQL – Table Inheritance – Array and Multiset Types in SQL – Object-Identity and Reference Types in SQL
Distributed Databases - Introduction to distributed architectures–Distributed and parallel databases concepts – Client/server, parallel and distributed architectures –Design strategies:Horizontal, vertical and hybrid fragmentation- Resource allocation.
Parallel Databases: I/O Parallelism – Interquery Parallelism – Intraquery Parallelism –Intraoperation Parallelism – Interoperation Parallelism.
Introduction to Transaction Management and Concurrency Control: Transaction model and properties–Transaction serialization and recovery–Lock based concurrency control–Multi-phase locking protocols–Timestamp ordering
Concurrency Control: Optimistic concurrency control–Deadlock management – Distributed deadlock – Distributed Query Processing
Recovery and Commit Protocols: Failure analysis– Reliability and availability– Sources of failure–Recovery techniques: shadow paging and write-ahead logging–Memory and storage management (Undo/redo and steal/force) –Two Phase Commit, Three phase commit. Spatial and Temporal Data and Mobility: Time in Databases – Spatial and Geographic Data –Multimedia Databases – Mobility and Personal Databases. MySQL - MongoDB - Redis–Memcached

  • Silberschatz, Abraham, Henry F. Korth, and S.Sudarshan, Database Systems Concepts, sixth edition, McGraw-Hill Education, 2010
  • Ozsu, M. Tamer and Patrick Valduriez, Principles of Distributed Database Systems; Springer, 3rd Edition, 2011
  • C. S. R. Prabhu, “Object Oriented Database Systems : Approaches and Architectures”, Third Edition, PHI Learning Pvt. Ltd.,2010
  • RamezElmasri and ShamkantNavathe, “Fundamentals of Database Systems”, Seventh Edition, Addison Wesley, 2010