Description
Wiley India Database Management Systems, 2Ed by P S Gill
This book on Database Management Systems has been designed to provide an insight into the database concepts. A sincere effort has been made to present the concepts of database normalization, concurrency control, deadlock handling and recovery, etc., in a simple easy-to-understand manner. Since understanding of the query languages is vital for accessing of databases, a large number of queries have been provided to explain the equivalence between SQL, Relational Algebra, Tuple Relational Calculus and Domain Relational Calculus.
About the Author
P.S. Gill, ME (Computer Science & Automation) from IISc, Bengaluru has got more than 38 years of experience in the field of Defence R&D and academics. He has the distinction of having worked at Bhabha Atomic Research Centre (BARC), Tata Institute of Fundamental Research (TIFR), Mumbai and LRDE, Bengaluru. He has hands-on experience on the development of embedded systems for air defence applications, which are currently in operational use for the defence of the nation. Presently, he is working as Head, Computer Science and Engineering with the reputed Krishna Group. His research interests include Concurrency Control, Database Normalization, Query Optimization, Real-Time Databases, Cryptographic Algorithms and issues related to Distributed Systems and Embedded Systems.
TABLE OF CONTENTS
BOOK REVIEW
DBMS overview
Entity-Relationship (ER) Modeling
Relational Data Model
Relational Algebra
Tuple Relational Calculus
Domain Relational Calculus
Structured Query Language
Query Optimization Normalization of Relational Schemas
Transaction Processing Concepts
Concurrency Control
Deadlock Handling in Transaction Processing
Recovery
Distributed Database Systems
Brief Introduction to Data Warehousing and Data Mining
Index.