Managing Data-Historical Perspective - File Systems versus DBMS-Advantages of a DBMS- Describing and Storing Data in DBMS-Queries in a DBMS-Transaction Management-Structure of a DBMS-People Who Work with Databases. Parallel Database: Introduction-Architectures for Parallel Databases- Parallel Query evaluation-Parallelizing Individual Operations-Parallel Query Optimization
Introduction-Distributed DBMS Architectures- Storing Data in a Distributed DBMS - Distributed Catalog Management – Distributes Query Processing-Updating Distributed Data – Distributed Transactions – Distributed Concurrency Control- Distributed Recovery.
Structured Data types-Operations on Structured Data- Encapsulation and ADTS-Inheritance-Objects, OIDS and Reference Types-Database Design for an ORDBMS-ORDBMS Implementation Challenges-OODBMS-Comparing RDBMS, OODBMS and ORDBMS.
Types of Spatial Data and Queries-Applications Involving Spatial Data-Introduction to Spatial indexes-Indexing Based on Space-Filling Curves- Grid Files-R Trees: Point and Region Data-Queries-Insert and delete Operations- Concurrency Control-Generalized search Trees-Issues in High-Dimensional Indexing
Databases on the World Wide Web- Multimedia Databases-Mobile Databases-Geographic Information Systems-Genome Data Management-Digital Libraries.
Reference Book:
1. Conolly and Begg: Database Systems,4th Edition, Pearson Education,2002. 2. Abraham Silberchatz, Henry F. Korth, and S.Sudarsan, ―Database System Concepts‖,5th Edition, McGraw-Hill, 2006.
Text Book:
1. Raghu Ramakrishnan and Johannes Gehrke: Database Management Systems, Third Edition, McGraw-Hill,2003. (UNIT 1,2,3, & 4) 2. Elmasri and Navathe: Fundamentals of Database Systems,5th Edition, Pearson Education, 2007. (UNIT 5)
