MC9276 ADVANCED DATABASES Syllabus for 5th Sem MCA - Fifth semester - Regulation 2009 - Anna University

MC9276 ADVANCED DATABASES Syllabus for 5th Sem MCA - Fifth semester - Regulation 2009 - Anna University

MC9276                                 ADVANCED DATABASES                                       LT P C
3 0 0 3

UNIT I             PARALLEL AND DISTRIBUTED DATABASES                                       9
Database System Architectures: Centralized and Client-Server Architectures Server System Architectures Parallel Systems- Distributed Systems Parallel Databases: I/O Parallelism Inter and Intra Query Parallelism Inter and Intra operation Parallelism Distributed Database Concepts - Distributed Data Storage Distributed Transactions – Commit Protocols Concurrency Control – Distributed Query Processing Three Tier Client Server Architecture- Case Studies

UNIT II            OBJECT AND OBJECT RELATIONAL DATABASES                             9
Concepts for Object Databases: Object Identity Object structure Type Constructors Encapsulation of Operations Methods Persistence Type and Class Hierarchies Inheritance Complex Objects Object Database Standards, Languages  and Design: ODMG Model ODL OQL Object Relational and Extended Relational Systems : Object Relational feature sin SQL/Oracle Case Studies.

UNIT III           XML DATABASES                                                                                    9
XML Databases: XMData Model DTD - XML Schema - XML Querying Web
Databases JDBC Information Retrieval – Data Warehousing Data Mining

UNIT IV          MOBILE DATABASES                                                                              9
Mobile Databases: Location and Handoff Management - Effect of Mobility on Data Management -  Location Dependent Data Distribution - Mobile Transaction Models - Concurrency Control - Transaction Commit Protocols- Mobile Database Recovery Schemes

UNIT V           MULTIMEDIA DATABASES                                                                     9
Multidimensional  Data  Structures  Image  Databases   Text/Document  Databases- Video Databases Audio Databases Multimedia Database Design.



1.  R.  Elmasri,  S.B.  Navathe,  Fundamentals  of  Database  Systems,  Fifth  Edition, Pearson Education/Addison Wesley, 2007.
2.  Thomas Cannolly and Carolyn Begg, Database Systems, A Practical Approach to
Design, Implementation and Management, Third Edition, Pearson Education, 2007.
3.  Henry F Korth, Abraham Silberschatz, S. Sudharshan, “Database System Concepts, Fifth Edition, McGraw Hill, 2006.
4.  C.J.Date, A.Kannan and S.Swamynathan,An Introduction to Database Systems, Eighth Edition, Pearson Education, 2006.
5.  V.S.Subramanian, Principles of Multimedia Database Systems, Harcourt India Pvt
Ltd., 2001.
6.  Vijay Kumar, Mobile Database Systems, John Wiley & Sons, 2006.
Next Post »