Back close

Course Detail

Course Name Advanced Databases
Course Code 18CA302
Program M. C. A., M. C. A. ( Offered at Mysuru Campus )
Semester Three
Credits Three
Year Taught 2018
Degree Postgraduate (PG)
School School of Arts and Sciences, School of Engineering
Campus Kochi, Mysuru, 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

Text Books

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

DISCLAIMER: The appearance of external links on this web site does not constitute endorsement by the School of Biotechnology/Amrita Vishwa Vidyapeetham or the information, products or services contained therein. For other than authorized activities, the Amrita Vishwa Vidyapeetham does not exercise any editorial control over the information you may find at these locations. These links are provided consistent with the stated purpose of this web site.

Admissions Apply Now