| Course Name | Advanced Database Management Systems |
| Course Code | 24CSE431 |
| Program | B.Tech. in Artificial Intelligence (AI) and Data Science (Medical Engineering) |
| Semester | VII |
| Credits | 3 |
| Campus | Coimbatore |
Distribution Models; Single Server, Sharding, Master-Slave Replication, Peer-to-Peer Replication, Combining Sharding and Replication – Availability and Fault Tolerance – Data Consistency Models-ACID, BASE models, CAP theorem, Concurrency Control– NoSQL databases-types of NoSQL databases, NoSQL system ways to handle big data problems: Moving Queries to data, not data to the query,
Key-value databases
From array to key –value databases, Essential features of key – value Databases, Properties of keys, Characteristics of Values, Key-Value Database Data Modeling Terms, Key-Value
Architecture and implementation Terms, Designing Structured Values, Limitations of KeyValue Databases, Design Patterns for Key-Value Databases, Case Study: Redis database
Document Oriented Databases
Document, Collection, Naming, CRUD operation, querying, indexing, Replication, Sharding,
Consistency Implementation: Distributed consistency, Eventual Consistency, Capped Collection,
Case studies: document oriented database: MongoDB
Graph Databases
What Is a Graph Database? Comparison with relational modeling,Graph Databases, Consistency, Transactions, Availability, Query Features, Scaling, Use Case : Neo4J
Student should have done basic database management systems
Learning Objectives
The course envisages to create
Course Outcomes
At the end of the course the student should be able to:
CO1 : Compare different NoSQL databases
CO2 : Identify the suitable NoSQL database for a specific application
CO3 : Design key-value, document oriented and graph databases in distributed manner
CO4 : Explain the theoretical motivation behind NoSQL databases
CO & PO mapping
| PO/PSO | PO1 | PO2 | PO3 | PO4 | PO5 | PO6 | PO7 | PO8 | PO9 | PO10 | PO11 | PO12 | PSO1 | PSO2 | PSO3 |
| CO | |||||||||||||||
| CO1 | 3 | – | – | – | 3 | – | – | – | 2 | 2 | – | 2 | 2 | 1 | – |
| CO2 | 3 | 2 | 2 | – | 3 | – | – | – | 2 | 2 | – | 2 | 2 | 1 | – |
| CO3 | 3 | 2 | 2 | – | 3 | – | – | – | 2 | 2 | – | 2 | 2 | 1 | – |
| CO4 | 3 | 3 | 3 | – | – | – | – | – | 2 | 2 | – | 2 | 1 | 1 | – |
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.
