IF5191 ADVANCED DATABASES SYLLABUS - ANNA UNIVERSITY PG REGULATION 2017 - Anna University Internal marks 2018

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.

No comments:

Post a Comment