JAWAHARLAL NEHRU TECHNOLOGICAL UNIVERSITY HYDERABAD

Course Objectives

Knowledge on concepts of Distributed Databases, Object-Based Databases,

advanced database models

Course Outcomes:

• 1. Understand Database system Architectures and parallel databases.
• 2. Analyze transactions, Concurrency Control in Distributed Databases.
• 3. Understand the importance of Data Warehousing and Mining.
• 4. Illustrate concepts of object-based databases.

UNIT - I

Database System Architectures: Centralized and Client –Server Architectures, Server System Architectures, Parallel Systems, Distributed Systems, Network Types. Parallel Databases: Introduction, I/O Parallelism, Interquery Parallelism, Intra Query Parallelism, Intraoperation Parallelism, Interoperation Parallelism, Query Optimization, Design of Parallel Systems, Parallelism on Multicore Processors.

UNIT - II

Distributed Databases: Homogeneous and Heterogeneous Databases, Distributed Data Storage, Distributed Transactions, Commit Protocols, Concurrency Control in Distributed Databases, Availability, Distributed Query Processing, Heterogeneous Distributed Databases, Cloud-Based Databases, Directory Systems.

UNIT - III

Data Warehousing and Mining: Decision-Support Systems, Data Warehousing, Data Mining, Classification, Association Rules, Other Types of Associations, Clustering, Other Forms of Data Mining

UNIT - IV

Object-Based Databases: Introduction, 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-Relational Mapping, Object- Oriented versus Object-Relational

UNIT - V

XML: Motivation, Structure of XML Data, XML Document Schema, Querying and Transformation, Application Program Interfaces to XML, Storage of XML Data, XML Applications Advanced database models and applications: Active Database Concepts and Triggers, Temporal database concepts, Spatial database concepts, Multimedia database concepts, Deductive databases

TEXT BOOKS:

• 1. Abraham Silberschatz, Henry F. Korth, S. Sudarshan Database System Concepts, Sixth Edition
• 2. Ramez Elmasri, Shamkant B. Navathe, Database systems- Models, Languages, Design and Application Programming