CS 5018 – ADVANCED DATABASES SYLLABUS M.E. COMPUTER SCIENCE AND ENGINEERING ANNA UNIVERSITY TIRUCHIRAPPALLI/TRICHY

Anna University Tiruchirappalli - 620 024
Regulations 2007 Sylllabus
M.E. COMPUTER SCIENCE AND ENGINEERING
ELECTIVES Cs 5018 – ADVANCED DATABASES


UNIT I DATABASE MANAGEMENT 9
Relational Data Model – SQL – Database Design – Entity Relationship Model – Relational
Normalization – Embedded SQL – Dynamic SQL – JDBC – ODBC.

UNIT II ADVANCED DATABASES 10
Object Databases – Conceptual Object Data Model – XML and Web Data – XML Schema –
Distributed Data bases – OLAP and Data Mining – ROLAP and MOLAP

UNIT III QUERY AND TRANSACTION PROCESSING 8
Query Processing Basics – Heuristic Optimization – Cost Size Estimation – Models of Transactions
– Architecture – Transaction Processing in a Centralized and Distributed System – TP Monitor.

UNIT IV IMPLEMENTING AND ISOLATION 9
Schedules – Concurrency Control – Objects and Semantic Commutativity – Locking – Crash –
Abort and Media Failure – Recovery – Atomic Termination – Distributed Deadlock – Global
Serialization – Replicated Databases – Distributed Transactions in Real World.

UNIT V DATABASE DESIGN ISSUES 9
Security – Encryption – Digital Signatures – Authorization – Authenticated RPC – Integrity –
Consistency – Database Tuning – Optimization and Research Issues.

Total: 45

TEXT BOOK
1. Philip M. Lewis, Arthur Bernstein, Michael Kifer, “Databases and Transaction
2. Processing An Application Oriented Approach”, Addison, Wesley, 2002.

REFERENCES
1. R.Elmasri and S.B. Navathe, “Fundamentals of Database Systems”, 3rd Edition,Addison
Wesley, 2004.
2. Abraham Silberschatz, Henry F. Korth, S. Sudharsan, “Database System Concepts”, 4th
Edition., Tata McGraw Hill, 2004.
3. Raghu Ramakrishnan & Johannes Gehrke, “Database Management Systems”, 3rd Edition,
TMH, 2003.

FEEL USEFUL PLEASE GIVE +1