2K6CS 705(A) ADVANCED DATABASE SYSTEMS

Module I (13 hours)
Object-Based Databases – Complex Data Types – Structured Types and Inheritance in SQL – Table Inheritance – Array and Multiset Types in SQL – Object-Identity and Reference Types in SQL -Implementing O-R Features – Persistent Programming Languages – Object-Oriented versus Object-Relational models
Module II (13 hours)
Data Analysis and Mining – Decision-Support Systems – Data Analysis and OLAP – Data Warehousing -Data Mining. Information Retrieval – Relevance Ranking Using Terms – Relevance Using Hyperlinks -Synonyms, Homonyms and Ontologies – Indexing of Documents – Measuring Retrieval Effectiveness -Web Search Engines – Information Retrieval and Structured Data.
Module III (13 hours)
Database-System Architectures – Centralized, Client–Server and Server System Architectures – Parallel and Distributed Systems. Parallel Databases – I/O Parallelism – Interquery, Intraquery, Intraoperation andInteroperation Parallelism – Design of Parallel Systems. Distributed Databases – Homogeneous and Heterogeneous Databases – Distributed Data Storage – Distributed Transactions – Commit Protocols -Concurrency Control in Distributed Databases – Distributed Query Processing – Heterogeneous DistributedDatabases.
Module IV (13 hours)
Advanced Data Types and New Applications – Time in Databases – Spatial and Geographic Data -Multimedia Databases – Mobility and Personal Databases. Advanced Transaction Processing – Transaction-Processing Monitors – Transactional Workflows – E-Commerce – Main-Memory Databases – Real-TimeTransaction Systems – Long-Duration Transactions – Transaction Management in Multidatabases.

Text books
1.Database System Concepts, 5/E, A. Silberschatz, H. F. Korth and S. Sudarshan, Mc-Graw Hill
Reference books
1. R. Elmasri and S. B. Navathe: Fundamentals of Database Systems, 5th Edition, Addison-Wesley
2. Database Management Systems, 3/E, Raghu Ramakrishnan and J. Gehrke, Mc-Graw Hill