2.4 -RELATIONAL DATA BASE MANAGEMENT SYSTEMS


UNIT - I

Database Concepts: Introduction & Overview, Client/Server technology, 2/3 tier architecture, data modeling - Relational, Hierarchial and Network, Object oriented, Distributed databases.

UNIT - II

SQL and other Relational Languages: Elementary operations, set operations, aggregate functions, Null values nested sub-queries, derived relations, views, joined relations DDL, embedded SQL, QBE, QUEL.

UNIT - III

Transaction processing: Transaction concepts, states, Atomicity, durability, serializability, recoverability, Isolation, Transaction definition in SQL. Concurrency control, locking, deadlock handling, recovery systems, log based shadow paging.

UNIT - IV

Distributed databases: Distributed data storage, Network transparency, distributed query processing, commit protocols, concurrency control, deadlock handling.

Introduction to special Databases: Data Analysis, Data Mining, Data Ware-housing, Spatial and Geographical Databases, Multimedia database, Mobility and Personal Database. Distributed Information Systems.

UNIT - V

Oracle Introduction: SQL - SQL commands for DDL and DML, Views, Procedures, Indexing. PL_SQL and Visual Basic as Front and tool.

Suggested Readings:

1.Database systems concepts - Korth.

2.AN Introduction to database systems - C.J.Date.