Database Management Systems - Softcover
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
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
"synopsis" may belong to another edition of this title.
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.
- PublisherPhi Learning Pvt. Ltd
- Publication date2011
- ISBN 10 8120343131
- ISBN 13 9788120343139
- BindingPaperback
- Edition number2
Buy New
Learn more about this copy
US$ 25.47
Shipping:
FREE
Within U.S.A.
Top Search Results from the AbeBooks Marketplace
Stock Image
Database Management Systems
Seller:
Rating
Book Description PAP. Condition: New. New Book. Shipped from UK. Established seller since 2000. Seller Inventory # CA-9788120343139
Buy New
US$ 25.47
Convert currency
Stock Image
Database Management Systems
Published by
Prentice-Hall of India Pvt.Ltd
(2011)
ISBN 10: 8120343131
ISBN 13: 9788120343139
New
Paperback
Quantity: 1
Seller:
Rating
Book Description Paperback. Condition: Brand New. 2nd edition edition. 480 pages. 9.21x6.93x1.02 inches. In Stock. Seller Inventory # __8120343131
Buy New
US$ 21.35
Convert currency
Stock Image
Database Management Systems
Published by
PHI Learning
(2011)
ISBN 10: 8120343131
ISBN 13: 9788120343139
New
Soft cover
Quantity: 1
Seller:
Rating
Book Description Soft cover. Condition: New. 2nd Edition. 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 PLSQL 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 IndexThe 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 SybaseRealizing 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 themSeveral 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 PLSQL SQL of both Sybase and MS SQL Server known as T-SQL have been coveredKey Features Gives wide coverage to topics of network hierarchical and relational data models of both traditional and generic modern databasesDiscusses the concepts and methods of Data Partitioning Data Mirroring and Replication required to build the centralized architecture of very large databasesProvides several examples listings exercises and solutions to selected exercises to stimulate and accelerate the learning process of the readersCovers the concept of database mirroring and log shipping to demonstrate how to build disaster recovery solution through the use of database technology 480 pp. Seller Inventory # 93706
Buy New
US$ 15.00
Convert currency
Stock Image
Database Management Systems
Seller:
Rating
Book Description PAP. Condition: New. New Book. Shipped from UK. Established seller since 2000. Seller Inventory # CA-9788120343139
Buy New
US$ 21.83
Convert currency