ADVANCED DBMS

Paper Code: 
24DCAI 801B
Credits: 
03
Periods/week: 
03
Max. Marks: 
100.00
Objective: 

Course Objectives:

The course will enable the students to explore theoretical knowledge and practical skills in advanced topics of database systems, transaction processing and recovery management. They will be able to compare relational and NoSQL datastores.

 

Course Outcomes: 

Course

Learning outcome

(at course level)

Learning and teaching strategies

Assessment Strategies

Course Code

Course

title

 

24DCAI 801B

 

ADVANCED DBMS

(Theory)

CO151. Analyse transaction processing and concurrency control techniques.

CO152. Compare recovery techniques and its role in maintaining the database’s integrity and security.

CO153. Apply NoSQL development tools on different types of NoSQL Databases.

CO154. Contrast RDBMS with different NoSQL databases based on different concepts.

CO155. Elaborate column oriented NoSql Database, Column-Family Data Store Features and Summarize Event Logging, Content Management Systems.

CO156. Contribute effectively in course-specific interaction

 

Approach in teaching:

Interactive Lectures, Discussion, PowerPoint Presentations, Informative videos

 

Learning activities for the students: 

Self-learning assignments, Effective questions, presentations.

 

 

 

Assessment tasks will include Class Test on the topics, Semester end examinations, Quiz, Student presentations and assignments.

 

9.00
Unit I: 
Transaction Processing:

Introduction to Transaction Processing, Transaction and System concepts, Desirable properties of Transactions. Characterizing Schedules Based on Recoverability, Characterizing Schedules Based on Serializability.

Concurrency control techniques: Locking techniques for concurrency control, Concurrency control based on Timestamp ordering.

 

9.00
Unit II: 
Database recovery concepts:

Recovery outline, Caching of Disk blocks, Write ahead logging, Steal/No Steal and Force/No Force, Checkpoints in the System Log and Fuzzy Check pointing, Transaction Rollback. Recovery Techniques Based on Deferred Update and on Immediate Update.

Database Integrity and Security: Domain constraints, Referential Integrity, Introduction to Assertions, Security violation and Authorization.

 

9.00
Unit III: 
Overview and History of NoSQL Databases:

Definition of the Four Types of NoSQL Databases, Value of Relational Databases, Getting at Persistent Data, Concurrency, Integration, Impedance Mismatch, Application and Integration Databases, Attack of the Clusters, Emergence of NoSQL, Key Points. Aggregate Data Models:  Aggregates, Example of Relations and Aggregates, Consequences of Aggregate Orientation, Summarizing Aggregate-Oriented Databases.

 

9.00
Unit IV: 
Comparison of relational databases to new NoSQL stores:

MongoDB, Cassandra, HBASE, Neo4j use and deployment, Application, RDBMS approach, Challenges NoSQL approach, Key-Value and Document Data Models, Column-Family Stores. Replication and sharding, MapReduce on databases. Distribution Models, Single Server, Sharding, Master-Slave Replication, Peer-to-Peer Replication, Combining Sharding and Replication.

 

9.00
Unit V: 
Column- oriented NoSQL databases:

Column- oriented NoSQL databases using Apache HBASE, Column-oriented NoSQL databases using Apache Cassandra, Architecture of HBASE, Column-Family Data Store Features, Consistency, Transactions, Availability, Query Features, Scaling, Suitable Use Cases, Event Logging, Content Management Systems, Blogging Platforms, Counters, Expiring Usage.

 

ESSENTIAL READINGS: 

Essential Readings:

  1. R. Elmasri and S. B. Navathe, “Fundamentals of Database Systems”, Addison       Wesley, 7th Edition, 2015
  2. Shashank Tiwari, “Professional NoSQL”, John Wiley & Sons, Inc., 2011

 

REFERENCES: 

Suggested Readings:

  1. Abraham Silberschatz, Henry Korth, S. Sudarshan, “Database Systems Concepts”, 7th Edition,McGraw Hill International Edition, 2019 R.
  2. Redmond, E. & Wilson, J. (2012). Seven Databases in Seven Weeks: A Guide to Modern Databases and the NoSQL Movement (1st Ed.). Raleigh, NC: The Pragmatic Programmers, LLC. ISBN-13: 978-1934356920 ISBN-10:1934356921.
  3. Sadalage, P. & Fowler, M. (2012). NoSQL Distilled: A Brief Guide to the Emerging World of Polyglot Persistence. (1st Ed.). Upper Saddle River, NJ: Pearson Education, Inc. ISBN-13:978-0321826626      ISBN-10:0321826620.

 

Reference Journals:

  1. Journal of the Brazilian Computer Society, Springer Open
  2. Journal of Internet Services and Applications, Springer Open

 

e- Resources including links:

1. https://www.slideshare.net/

2. https://pll.harvard.edu/subject/computer-science

3. https://onlinecourses.nptel.ac.in/

 

Academic Year: 
2024-25
  • Printer-friendly version