CS1006 ADVANCED DATABASES SYLLABUS B.E. COMPUTER SCIENCE AND ENGINEERING – ANNA UNIVERSITY CHENNAI REGULATIONS – 2004

ANNA UNIVERSITY CHENNAI: CHENNAI – 600 025
B.E DEGREE PROGRAMME COMPUTER SCIENCE AND ENGINEERING
(Offered in Colleges affiliated to Anna University)
CURRICULUM AND SYLLABUS – REGULATIONS – 2004
B.E. COMPUTER SCIENCE AND ENGINEERING
LIST OF ELECTIVES CS1006 ADVANCED DATABASES

AIM
Advanced database aims at developing computer application with different kinds of data models. It is also deals with the Transaction management of these different databases.

OBJECTIVES
• To study the needs of different databases.
• To understand about different data models that can be used for these databases.
• To make the students to get familiarized with transaction management of the database
• To develop in-depth knowledge about web and intelligent database.
• To provide an introductory concept about the way in which data can be stored in geographical information systems etc.,

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 Optimisation - 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 BOOK
1. Thomas M. Connolly, Carolyn E. Begg, “Database Systems - A Practical Approach to Design , Implementation , and Management”, Third Edition , Pearson Education, 2003

REFERENCES
1. Ramez Elmasri & Shamkant B.Navathe, “Fundamentals of Database Systems”, Fourth Edition , Pearson Education , 2004.
2. M.Tamer Ozsu , Patrick Ualduriel, “Principles of Distributed Database Systems”, Second Edition, Pearso nEducation, 2003.
3. C.S.R.Prabhu, “Object Oriented Database Systems”, PHI, 2003.
4. Peter Rob and Corlos Coronel, “Database Systems – Design, Implementation and Management”, Thompson Learning, Course Technology, 5th Edition, 2003.