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.
|