22PCSCC13: ADVANCED DATABASE MANAGEMENT SYSTEM
UNIT
I
Formal review of relational database and FDs Implication –
Closure – its correctness
UNIT
II
3NF and BCNF -Decomposition and synthesis approaches - Review of
SQL99 - Basics of query processing - external sorting -file scans
UNIT
III
Processing of joins -materialized vs. pipelined processing –query
transformation rules -DB transactions -ACID properties -interleaved executions
– schedules -serialisability
UNIT
IV
Correctness of interleaved execution -Locking and management of
locks -2PL –deadlocks -multiple level granularity -CC on B+ trees -Optimistic
CC
UNIT
V
T/O based techniques -Multi version approaches -Comparison of CC
methods - dynamic databases -Failure classification - recovery algorithm -XML
and relational databases.
Text Books
1. R. Ramakrishnan, J.
Gehrke, Database Management Systems, McGraw Hill, 2004
2. Silberschatz, H. Korth,
S. Sudarshan, Database system concepts, 5/e, McGraw Hill, 2008
CLICK HERE TO DOWNLOAD THE SYLLABUS IN PDF
.jpg)
No comments:
Post a Comment