Course Code: PEC-CSE-310G
Course Title: Advanced Database Management System
Category: Professional Elective Course
Scheme and Credits
| L | T | P | Credits | |
|---|---|---|---|---|
| Semester 6 | 3 | 0 | 0 | 3 |
| Marks | |
|---|---|
| Class work | 25 |
| Exam | 75 |
| Total | 100 |
| Duration of Exam | 03 Hours |
Objective of the course:
- To understand DBMS Components, Advantages and Disadvantages.
- Understanding Data modeling: ER, EER, Network, Hierarchical and Relational data models.
- Understanding normalization, general strategies for query processing, query processor, syntax analyzer, Query decomposition, Heuristic Query optimization.
- To understand transaction concept, schedules, serializability, locking and concurrency control protocols.
Note: Examiner will set nine questions in total. Question one will be compulsory. Question one will have 6 parts of 2.5 marks each from all units and remaining eight questions of 15 marks each to be set by taking two questions from each unit. The students have to attempt five questions in total, first being compulsory and selecting one from each unit.
UNIT 1
Introduction
Architecture, Advantages, Disadvantages, Data models, relational algebra, SQL, Normal forms.
Query Processing
General strategies for query processing, transformations, expected size, statistics in estimation, query improvement. Query evaluation, view processing, query processor.
UNIT 2
Recovery
Reliability, Transactions, recovery in centralized DBMS, reflecting updates, Buffer management logging schemes, disaster recovery.
Concurrency
Introduction, Serializability, Concurrency control, Locking schemes, Timestamp based ordering, Optimistic, Scheduling, Multiversion techniques, Deadlocks.
UNIT 3
Parallel and Distributed Databases
Distributed Data Storage – Fragmentation & Replication, Location and Fragment.
Transparency Distributed Query Processing and Optimization, Distributed Transaction Modeling and concurrency Control, Distributed Deadlock, Commit Protocols, Design of Parallel Databases, Parallel Query Evaluation.
UNIT 4
Objected Oriented and Object Relational Databases
Modeling Complex Data Semantics, Specialization, Generalization, Aggregation and Association, Objects, Object Identity, Equality and Object Reference, Architecture of Object Oriented and Object Relational Databases
Suggested Text Books
- Elmarsi, Navathe, Somayajulu, Gupta, "Fundamentals of Database Systems", 4th Edition, Pearson Education, 2007
- Garcia, Ullman, Widom, "Database Systems, The complete book", Pearson Education, 2007
- R. Ramakrishnan, "Database Management Systems", McGraw Hill International Editions, 1998
Suggested Reference Books
- Date, Kannan, Swaminathan, "An Introduction to Database Systems", 8th Edition Pearson Education, 2007
- Singh S.K., "Database System Concepts, design and application", Pearson Education, 2006
- Silberscatz, Korth, Sudarshan, "Database System Concepts", Mcgraw Hill, 6th Edition, 2006
- W. Kim, "Modern Database Systems", 1995, ACM Press, Addision Wesley
Course Outcomes
- Students will get understanding of DBMS Components, Its advantages and disadvantages.
- Understanding about various types of Data modeling: ER, EER, Network, Hierarchical and Relational data models.
- Understanding normalization, general strategies for query processing, query processor, syntax analyzer, Query decomposition, Heuristic Query optimization.
- Understanding transaction concept, schedules, serializability, locking and concurrency control protocols.