ADVANCED DATABASES SEMESTER VIII

ANNA UNIVERSITY TIRUCHIRAPPALLI
Tiruchirappalli - 620 024 Regulations 2007
Syllabus
B.E. COMPUTER SCIENCE AND ENGINEERING
SEMESTER VIII (Common to CSE 8th Semester and IT 7th Semester)
ADVANCED DATABASES
(Common to CSE and IT)

UNIT I DISTRIBUTED DATABASES 9
Distributed DBMS concepts and design − Introduction − Functions and architecture of DDBMS −
Distributed relational database design − Transparency in DDBMS − Distributed transaction
management − Concurrency control − Deadlock management − Database recovery − The X/Open
distributed transaction processing model − Replication servers − Distributed query optimization −
Distribution and replication in oracle.

UNIT II OBJECT ORIENTED DATABASES 9
Object oriented databases − Introduction − Weakness of RDBMS − Object oriented concepts storing
objects in relational databases − Next generation database systems − Object oriented data models −
OODBMS perspectives − Persistence − Issues in OODBMS − Object oriented database management
System manifesto − Advantages and disadvantages of OODBMS − Object oriented database design −
OODBMS standards and systems − Object management group − Object database standard ODMG −
Object relational DBMS − Postgres − Comparison of ORDBMS and OODBMS.

UNIT III WEB DATABASES 9
Web technology and DBMS − Introduction − The web − The web as a database application platform −
Scripting languages − Common gateway interface − HTTP cookies − Extending the web server − Java
– Microsoft’s web solution platform − Oracle internet platform − Semi structured data and XML −
XML related technologies − XML query languages.

UNIT IV INTELLIGENT DATABASES 9
Enhanced data models for advanced applications − Active database concepts and triggers − Temporal
database concepts − Deductive databases − Knowledge databases.

UNIT V CURRENT TRENDS 9
Mobile database − Geographic information systems − Genome data management − Multimedia
database − Parallel database − Spatial databases − Database administration − Data warehousing and
data mining.
Total: 45
TEXT BOOKS
1. Connolly, T.M., and Begg, C.E., “Database Systems −A Practical Approach to Design,
Implementation and Management”, 3rd Edition, Pearson Education, 2003.
2. Ramez Elmasri and Navathe, S.B., “Fundamentals of Database Systems”, 4th Edition, Pearson
Education, 2004.

REFERENCES
1. Tamer Ozsu, M. and Patrick Ualduriel, “Principles of Distributed Database Systems”, 2nd
Edition, Pearson Education, 2003.
2. Prabhu, C.S.R., “Object Oriented Database Systems”, PHI, 2003.
3. Peter Rob and Corlos Coronel, “Database Systems Design Implementation and Management”,
5th Edition, Thompson Learning Course Technology, 2003.

FEEL USEFUL PLEASE GIVE +1