DATABASE MANAGEMENT SYSTEMS, SECOND EDITION

Name: DATABASE MANAGEMENT SYSTEMS, SECOND EDITION
Rating: 4.75 (4 reviews)

NARANG, RAJESH

Feb 2018 · PHI Learning Pvt. Ltd.

4 reviews

Ebook

480

Pages

About this ebook

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

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

Discover more

Ratings and reviews

4 reviews

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.

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

Rate this ebook

Tell us what you think.

Reading information

Smartphones and tablets

Install the Google Play Books app for Android and iPad/iPhone. It syncs automatically with your account and allows you to read online or offline wherever you are.

Laptops and computers

You can listen to audiobooks purchased on Google Play using your computer's web browser.

eReaders and other devices

To read on e-ink devices like Kobo eReaders, you'll need to download a file and transfer it to your device. Follow the detailed Help Center instructions to transfer the files to supported eReaders.

Flag as inappropriate