Database Management Systems (CSE2004)
Credits : 4
Two of the best playlists:
Jenny’s Tutorials (for only module 3): https://www.youtube.com/watch?v=T7AxM7Vqvaw&list=PLdo5W4Nhv31b33kF46f9aFjoJPOkdlsRc
Module:1 DATABASE SYSTEMS CONCEPTS AND ARCHITECTURE
History and motivation for database systems -characteristics of database approach - Actors on the
scene - Workers behind the scene - Advantages of using DBMS approach– Data Models, Schemas, and Instances– Three-Schema Architecture and Data Independence– The Database
System Environment– Centralized and Client/Server Architectures for DBMSs– Classification of database management systems.
Module:4 QUERY PROCESSING ANDTRANSACTION PROCESSING
Translating SQL Queries into Relational Algebra - heuristic query optimization - Introduction to
Transaction Processing - Transaction and System concepts – Desirable properties of Transactions
- Characterizing schedules based on recoverability - Characterizing schedules based on
Module:5 CONCURRENCY CONTROL AND RECOVERY TECHNIQUES
Two-Phase Locking Techniques for Concurrency Control – Concurrency Control based on
timestamp – Recovery Concepts – Recovery based on deferred update – Recovery techniques
based on immediate update - Shadow Paging.
Module:7 RECENT TRENDS - NOSQL DATABASE MANAGEMENT
Introduction, Need of NoSQL, CAP Theorem, different NoSQL data models: Key-value stores, Column families, Document databases, Graph databases
Slides from the faculty are enough.