Stock Image

Database Management Systems, (Second Edition)

Rajesh Narang

ISBN 10: 8120343131 / ISBN 13: 9788120343139
Published by PHI Learning, 2011
New Condition: New Soft cover
From BookVistas (New Delhi, DELHI, India)

AbeBooks Seller Since November 24, 2010

Quantity Available: > 20

Buy New
List Price: US$ 34.75
Price: US$ 8.13 Convert Currency
Shipping: US$ 4.99 From India to U.S.A. Destination, Rates & Speeds
Add to basket

30 Day Return Policy

About this Item

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. 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. KEY FEATURES : 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. Contents Preface 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 Bibliography Answers to Selected Exercises Index Printed Pages: 480. Bookseller Inventory # 20265

Ask Seller a Question

Bibliographic Details

Title: Database Management Systems, (Second Edition...

Publisher: PHI Learning

Publication Date: 2011

Binding: Softcover

Book Condition:New

Edition: 2nd edition.

About this title

Synopsis:

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.

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.
Key Feature:

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.
Table of Contents:

Preface 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 Bibliography Answers to Selected Exercises Index

About the Author:

RAJESH NARANG PhD, is Chief Technology Officer, National Institute of Smart Government, New Delhi. He has designed online transaction processing (OLTP) applications, Interactive Voice Response System, Smart Card Ticketing, e-Commerce, data warehousing and disaster-tolerant solutions for Indian Railways. He is a recipient of the Computer World Honor Program Medal for using IT for the benefit of society.

"About this title" may belong to another edition of this title.

Store Description

Visit Seller's Storefront

Terms of Sale:

All books are new. We accept payments by the following methods:

  1. Credit Card: Visa, MasterCard, or American Express.
  2. PayPal: sales@bookvistas.com
  3. Bank Draft or Banker's Cheque.
  4. Bank/Wire Transfer.

Cheques may be made payable to BookVistas.

Books are shipped by DHL, FedEx, Aramex, Registered Air Mail, or Registered SAL (Surface Air
Lifted).


Shipping Terms:

Shipping costs are based on books weighing 2.2 LB, or 1 KG. If your book order is heavy or oversized, we may contact you to let you know extra shipping is required.

List this Seller's Books

Payment Methods
accepted by seller

Visa Mastercard American Express

PayPal Bank Draft Bank/Wire Transfer