CS 246

Database Management Systems Laboratory

0-0-4-4

 

Pre-requisites : CS203, CS204

 

Using a relational DBMS: Writing SQL queries, accessing a DBMS from an external application. Implementing of parts of DBMS such as various file organizations, indexing methods (Tree/ Hash/ Bitmap), external sorting algorithms, concurrency control schemes, and crash recovery schemes. Non-relational DBMS; performance comparison of a non-relational DBMS with a relational DBMS for an application.

Text Book:

1.     H. Garcia-Molina, J. Ullman, J. Widom, Database System Implementation, 2nd Edition, Pearson, 2002.

2.     J. Groff and P. Weinberg, SQL Complete Reference, McGraw Hill, 3rd Edition, 2017.

3.     P. Sadalage and M. Fowler, NoSQL Distilled: A Brief Guide to the Emerging World of Polyglot Persistence, Addison Wesley, 2012.