CS7L03. ADVANCED DATABASE SYSTEMS

Section - I

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: Object And Object Relational Databases
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 – Case Studies.

Unit III : Advanced SQL
PL SQL- A Basic introduction, Functions and Procedure, Packages, Synonyms, Database Links, Embedded SQL and Dynamic SQL. Database Design: systems development life cycle, database life cycle, DBMS Software Selection, top-down versus bottom-up design, centralized versus decentralized design.

Section - II

Unit IV: Database Security and Authorization
Discretionary Access Control, Mandatory Access Control, Audit Trails in Databases,
Statistical Databases

Unit V: Databases on the Web and Semi-structured data
Overview of XML, structure of XML data, document schema, querying XML data, storage of XML data, XML applications, the semi-structure data model, implementation issues, indexes for text data.

Unit VI: Business Intelligence and Data Warehouses
The Need for Data Analysis, Business Intelligence, Business Intelligence Architecture, Decision Support Data, Online Analytical Processing, Star Schemas, Implementing a Warehouse, Data Mining, SQL Extension for OLAP.

Text Books:
1. Database System Concepts – Silberschatz, Korth, Sudarshan – 5th Edi (MGH International edition). (Unit No.1,Unit No.5,Unit No.2)
2. Fundamentals of Database Systems - Elmasri and Navathe [4e], Pearson Education ( Unit No.2)
3. Database Systems, Design, Implementation and Management - Coronel-Morris- Rob ( Unit No.3,4,6)

References:
1. Database Management System – Raghu Ramkrishnan, Johannes Gehrke, Database Management Systems[3e], (MGH).
2. Advanced Database Management System – Rini Chakrabarti -Shilbhadra Dasgupta.