Database Management Systems (Reprint)

P S Gill

ISBN 10: 8189866834 / ISBN 13: 9788189866839

Published by I.K. International, 2009

About this Item

Contents: 1. Introduction. 2. Entity-Relationship Modeling. 3. Relational Data Model. 4. Relational Algebra. 5. Tuple Relational Calculus. 6. Domain Relational Calculus. 7. Structured Query Language. 8. Normalization of Relational Schema. 9. Transaction Processing Concepts. 10. Concurrency Control. 11. Deadlock Handling in Transaction Processing. 12. Recovery. 13. Distributed Database Systems. Index. The book is intended to provide an insight into the DBMS concepts. An effort has been made to familiarize the readers with the concepts of database normalization, concurrency control, deadlock handling and recovery etc., which are extremely vital for a clear understanding of DBMS. To familiarize the readers with the equivalence amongst Relational Algebra, Tuple Relational Calculus, and SQL, a large number of equivalent queries have been provided. The concepts of normalization have been elaborated very systematically by fully covering the underlying concepts of functional dependencies, multi-valued dependencies, join dependencies, loss-less-join decomposition, dependency-preserving decomposition etc. It is hoped that with the help of the information provided in the text, a reader will be able to design a flawless database. Also, the concepts of serializabilty, concurrency control, deadlock handling and log-based recovery have been covered in full detail. An overview has also been provided of the issues related to distributed-databases.

Seller Inventory # 82607

Bibliographic Details

• Title: Database Management Systems (Reprint)
• Publisher: I.K. International
• Publication Date: 2009
• Language: English
• ISBN 10: 8189866834
• ISBN 13: 9788189866839
• Binding: Soft cover
• Edition: 2nd Edition
• Condition: New

About this title

Synopsis

The book is intended to provide an insight into the DBMS concepts. An effort has been made to familiarize the readers with the concepts of database normalization, concurrency control, deadlock handling and recovery etc., which are extremely vital for a clear understanding of DBMS. To familiarize the readers with the equivalence amongst Relational Algebra, Tuple Relational Calculus, and SQL, a large number of equivalent queries have been provided. The concepts of normalization have been elaborated very systematically by fully covering the underlying concepts of functional dependencies, multi-valued dependencies, join dependencies, loss-less-join decomposition, dependency-preserving decomposition etc. It is hoped that with the help of the information provided in the text, a reader will be able to design a flawless database. Also, the concepts of serializabilty, concurrency control, deadlock handling and log-based recovery have been covered in full detail. An overview has also been provided of the issues related to distributed-databases.