• PHI Learning Database Management Systems PHI Learning Database Management Systems

PHI Learning Database Management Systems

Product Code : 9788120343139

Availability: In stock

Regular Price: Rs. 325

Special Price: Rs. 309

Quick Overview

PHI Learning Database Management Systems

The contents of this second edition have been appropriately enhanced to serve the growing needs of the students pursuing undergraduate engineering courses in Computer Science, Information Technology, as well as postgraduate programmes in Computer Applications (MCA), MSc (IT) and MSc (Computer Science). The book covers the fundamental and theoretical concepts in an elaborate manner using SQL of leading RDBMS—Oracle, MS SQL Server and Sybase.

This book is recommended in Guwahati University, Assam.

Realizing the importance of RDBMS in all types of architectures and applications, both traditional and modern topics are included for the benefit of IT-savvy readers. A strong understanding of the relational database design is provided in chapters on Entity-Relationship, Relational, Hierarchical and Network Data Models, Normalization, Relational Algebra and Relational Calculus. The architecture of the legacy relational database R system, the hierarchical database IMS of IBM and the network data model DBTG are also given due importance to bring completeness and to show thematic interrelationships among them.

Several chapters have been devoted to the latest database features and technologies such as Data Partitioning, Data Mirroring, Replication, High Availability, Security and Auditing. The architecture of Oracle, SQL of Oracle known as PL/SQL, SQL of both Sybase and MS SQL Server known as T-SQL have been covered.


Gives wide coverage to topics of network, hierarchical and relational data models of both traditional and generic modern databases.

Discusses the concepts and methods of Data Partitioning, Data Mirroring and Replication required to build the centralized architecture of very large databases.

Provides several examples, listings, exercises and solutions to selected exercises to stimulate and accelerate the learning process of the readers.

Covers the concept of database mirroring and log shipping to demonstrate how to build disaster recovery solution through the use of database technology.


1. Introduction
2. The Entity-Relationship Model
3. Data Models
4. Storage Structure
5. Relational Data Structure
6. Architecture of System R and Oracle
7. Normalization
8. Structured Query Language
9. T-SQL—Triggers and Dynamic Execution
10. Procedure Language—SQL
11. Cursor Management and Advanced PL/SQL
12. Relational Algebra and Relational Calculus
13. Concurrency Control and Automatic Recovery
14. Distributed Database and Replication
15. High Availability and RAID Technology
16. Security Features Built in RDBMS
17. Queries Optimization
18. Architecture of a Hierarchical DBMS
19. The Architecture of Network based DBTG System
20. Comparison between Different Data Models
21. Performance Improvement and Partitioning
22. Database Mirroring and Log Shipping for Disaster Recovery
      Answers to Selected Exercises

Read more See more product details


Brand / Publisher PHI Learning
Return Policy 30 Days
Book Type Reference Books
Edition 2nd
ISBN 9788120343139
Author Prof : Narang
Language English
Study Stream Engineering
Specialization Computer Science
Subject Computer Science
Pages 480
Binding Paperback


Brand Description

Established in 1963, PHI Learning is a leading academic publisher of the country. Under the imprint of Eastern Economy Editions, PHI Learning has been the pioneer of low-cost high quality affordable texts. PHI titles encompass a wide range of subjects including engineering, sciences, humanities, management, computer science & information technology, social sciences and books for working professionals. With more than 3000 titles on its list today, PHI has often played a pivotal role in redesigning and reorienting university syllabi based on its valuable books.
  1. Be the first to review this product

Write Your Own Review

Only registered users can write reviews. Please, log in or register