Description
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 and 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. The concepts of normalization
have been elaborated very systematically, bringing out the necessity of
normalization and fully covering the underlying concepts of functional
dependencies, multi-valued dependencies, join dependencies, loss-less-join
decomposition, dependency-preservation, etc. The author sincerely hopes that the
book will enable its readers to design databases with ease and without flaws. Also,
the concepts of concurrency control, deadlock handling and log-based recovery
have been covered in full detail. A brief introduction has been provided to the issues
related to distributed-databases, data warehousing and data mining.
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.
