Database Management Systems (PCC-CS601)
6 units: Database system architecture, Relational query languages, Storage strategies, Transaction processing, Database Security · L-T-P 3L/week.
Detailed syllabus
Unit 1: Database system architecture (9 hours)
Database system architecture: Data Abstraction, Data Independence,Data Definition Language(DDL),Data Manipulation Language(DML). Data models: Entity- relationship model, network model, relational and object oriented data models, integrity constraints, data manipulation operations.
Unit 2: Relational query languages (13 hours)
Relational query languages: Relational algebra, Tuple and domain relational calculus, SQL3, DDL and DML constructs, Open source and Commercial DBMS - MYSQL, ORACLE, DB2, SQLserver. Relational database design: Domain and data dependency, Armstrong’s axioms, Normal forms, Dependency preservation, Losslessdesign. Query processing and optimization: Evaluation of relational algebra expressions, Query equivalence, Join strategies, Query optimization algorithms.
Unit 3: Storage strategies (3 hours)
Storage strategies: Indices, B-trees, hashing.
Unit 4: Transaction processing (5 hours)
Transaction processing: Concurrency control, ACID property, Serializability of scheduling, Locking and timestamp based schedulers, Multiversion and optimistic Concurrency Control schemes, Database recovery.
Unit 5: Database Security (3 hours)
Database Security: Authentication, Authorization and access control, DAC, MAC and RBAC models, Intrusion detection, SQL injection.
Unit 6: Advanced topics (3 hours)
Advanced topics: Object oriented and object relational databases, Logical databases, Web databases, Distributed databases, Data warehousing and data mining.
Source: official document