Database Management Systems

Designed as a textbook for students offering courses in computer science engineering, master of computer applications (MCA) and for IT courses, this comprehensive and up-to-date study gives a clear analysis of the applications of both Oracle and Sybase-the enterprise class of relational databases.

Realizing the importance of modern topics for the IT-savvy readers, the author has devoted separate chapters to the latest features of the database such as dynamic hashing, replication, distributed databases, query optimization, auditing and high availability subsystem. These are strategically and tactically very important from the viewpoint of database performance, recovery, availability and database adminis-tration. Besides, legacy databases, for example, hierarchical IMS of IBM and network data model DBTG, are given due importance. Oracle and Sybase systems, their architecture, SQL, PL/SQL and T-SQL, have also been discussed with focus on their thematic interrelationships.

A highlight of the text is the inclusion of a chapter on the concepts of symmetrical and asymmetrical configurations related to high-availability subsystem and basic copy model of Replication Technology along with two-phase commit protocol used in distributed databases. This takes the students beyond the average discussion of this technology.