IT6001 ADVANCED DATABASE TECHNOLOGY|syllabus

IT6001 ADVANCED DATABASE TECHNOLOGY L T P C 3 0 0 3

OBJECTIVES: 
The student should be made to:

•  Be familiar with a commercial relational database system (Oracle) by writing SQL using the system.
•  Be familiar with the relational database theory, and be able to write relational algebra expressions for queries.

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 features in SQL / Oracle – Case Studies.

 UNIT III XML DATABASES (9)
 XML Databases: XML Data 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 INTELLIGENT DATABASES (9)
 Active databases – Deductive Databases – Knowledge bases – Multimedia Databases- Multidimensional Data Structures – Image Databases – Text/Document Databases- Video Databases – Audio Databases – Multimedia Database Design.

                                                                                                             TOTAL: 45 PERIODS

REFERENCES:
1. Henry F Korth, Abraham Silberschatz and S. Sudharshan, “Database System Concepts”, Sixth Edition, McGraw Hill, 2011.
2. C.J.Date, A.Kannan and S.Swamynathan,”An Introduction to Database Systems”, Eighth Edition, Pearson Education, 2006.
3. R. Elmasri, S.B. Navathe, “Fundamentals of Database Systems”, Fifth Edition, Pearson Education/Addison Wesley, 2007.
4. Thomas Cannolly and Carolyn Begg, “Database Systems, A Practical Approach to Design, Implementation and Management”, Third Edition, Pearson Education, 2007.
5. Subramaniam, “ Multimedia Databases”, Morgan Kauffman Publishers, 2008.

Click here to download full syllabus                           AULibrary.com