IF5191 ADVANCED DATABASES SYLLABUS - ANNA UNIVERSITY PG REGULATION 2017

IF5191 ADVANCED DATABASES SYLLABUS

REGULATION 2017

ME CSE - SEMESTER 2

OBJECTIVES:

• To understand the design of databases.
• To acquire knowledge on parallel and distributed databases and its applications.
• To study the usage and applications of Object Oriented and Intelligent databases.
• To understand the emerging databases like Mobile, XML, Cloud and Big Data

UNIT I PARALLEL AND DISTRIBUTED DATABASES
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 – Design of Parallel Systems Distributed Database Concepts - Distributed Data Storage – Distributed Transactions – Commit Protocols – Concurrency Control – Distributed Query Processing – Case Studies

UNIT II INTELLIGENT DATABASES
Active Databases: Syntax and Semantics (Starburst, Oracle, DB2)- Taxonomy- Applications- Design Principles for Active Rules- Temporal Databases: Overview of Temporal Databases TSQL2- Deductive Databases-Recursive Queries in SQL- Spatial Databases- Spatial Data Types - Spatial Relationships- Spatial Data Structures-Spatial Access Methods- Spatial DB Implementation.

UNIT III XML DATABASES
XML Databases: XML Data Model – DTD – XML Schema – XML Querying – Web Databases – Open Database Connectivity.

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

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

TOTAL : 45 PERIODS

OUTCOMES:
Upon completion of this course, a students should be able:

• To develop skills on databases to optimize their performance in practice.
• To analyze each type of databases and its necessity
• To design faster algorithms in solving practical database problems

REFERENCES:

1. C.J.Date, A.Kannan, S.Swamynathan, ―An Introduction to Database Systems‖, Eighth Edition, Pearson Education, 2006.
2. Carlo Zaniolo, Stefano Ceri, Christos Faloutsos, Richard T.Snodgrass, V.S.Subrahmanian, Roberto Zicari, ―Advanced Database Systems‖, Morgan Kaufmann publishers,2006.
3. Henry F Korth, Abraham Silberschatz, S. Sudharshan, ―Database System Concepts‖, Sixth Edition, McGraw Hill, 2011.
4. R. Elmasri, S.B. Navathe, ―Fundamentals of Database Systems‖, Sixth Edition, Pearson Education/Addison Wesley, 2010.
5. Vijay Kumar, ―Mobile Database Systems‖, John Wiley & Sons, 2006.