Database Management Systems-II
Subject Overview
Database Management Systems-II builds on DBMS-I with transaction management and concurrency control, storage/indexing and database security, NoSQL databases and Big Data (document/key-value/column-family/graph models, CAP theorem, MongoDB, Hadoop, Cassandra), and an introduction to data warehousing, OLAP and data mining (association rule mining, decision trees). A 3-credit core theory paper.
Unit-wise Syllabus
4 units — click WhatsApp below to get the full notes for each
Unit 1: Transaction management
ACID properties, transactions and schedules, concurrent execution, lock-based concurrency control, performance of locking, transaction support in SQL, crash recovery, 2PL, serializability and recoverability, lock management, deadlock handling
Unit 2: Storage, indexing and security
Data on external storage, file organizations and indexing, index data structures, comparison of file organizations, index selection guidelines, database security introduction, access control, discretionary access control
Unit 3: NoSQL and Big Data
Introduction to NoSQL, document/key-value/column-family/graph data models, features of NoSQL document databases, CAP theorem, BASE vs ACID, CRUD operations, overview of Hadoop/MongoDB/Cassandra, MongoDB operator implementation
Unit 4: Data warehousing and mining
Introduction to data warehousing, OLAP, data mining types, data pre-processing, attribute-oriented induction, association rule mining, frequent itemset mining, the Apriori algorithm, classification process, decision tree induction, attribute selection measures