IT6001 Advanced Database Technology Syllabus Semester VI Elective IT BTECH Anna University-Regulation-2013

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.



OUTCOMES:
Upon completion of the course, the student should be able to:

• Apply query evaluation techniques and query optimization techniques.
• Develop transaction processing systems with concurrency control.
• Design and develop a database application system as part of a team.

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.