| Course Name | Advanced DBMS |
| Course Code | 26CSA504 |
| Program | M. C. A. |
| Semester | 1 |
| Credits | 3 |
| Campuses | Amritapuri, Mysuru |
Advanced SQL – Sub queries, Joins, Set Operations, EXISTS, views, With clause – Recursion in SQL PL-SQL, Transaction serializability, Locking.
DB Architecture- Transaction model and properties, Transaction structure, Transaction serialization- Concurrency Control and Recovery.
Introduction to Parallel database and I/O Parallelism, Interquery Parallelism, Intraquery Parallelism. Intraoperation Parallelism, Interoperation Parallelism – Introduction to Distributed Databases.
Introduction to object-relational database – Complex Data Types, Structured Types and Inheritance in SQL, Table Inheritance, Array. Query planning, Evaluation and Optimization Techniques
JSON – syntax, datatypes, stringify, objects, schema
XML Databases: XML Data Model – DTD – XML Schema – XML Querying
Comparison of JSON with XML
Intelligent Databases-Active Databases- Taxonomy- Applications- Design Principles for Active Rules- Temporal Databases: Overview of Temporal Databases – Spatial Databases – Deductive Databases.
Course Description
The course gives theoretical knowledge and practical skills in the various aspects of databases including architecture, advanced queries, query processing, optimization, and the diverse types of databases including object-based databases which will help students to pursue a career in this field. The students will become more proficient in writing queries as well as in doing database design for a distributed database-oriented application.
Course Objectives
Course Outcomes
| Cos | Description |
| CO1 | Gain confidence in writing SQL and PL/SQL |
| CO2 | Understand the relevance of transactions and recovery, parallel and distributed databases including for large real-time applications |
| CO3 | Learn the Object-relational Database concepts, and advanced Queries based on these concepts. |
| CO4 | Understand JSON usage and compare it with XML |
| CO5 | Gain knowledge in different other types of databases for handling diverse data and purposes. |
CO-PO Mapping
| PO/PSO | PO1 | PO2 | PO3 | PO4 | PO5 | PO6 | PO7 | PO8 |
| CO | ||||||||
| CO1 | 3 | 3 | 2 | – | – | – | – | 1 |
| CO2 | 3 | 3 | 2 | – | – | – | – | 2 |
| CO3 | 3 | 3 | 2 | – | 1 | – | – | 2 |
| CO4 | 3 | 3 | 2 | – | 1 | – | – | 2 |
| CO5 | 3 | 3 | 2 | – | 1 | – | – | 2 |
Prerequisites
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.
