Database Management Systems, 2/e
View Larger

Database Management Systems, 2/e

Author : P S Gill
© Year : 2011
ISBN : 9789381141212
Pages : 310
Binding : Paperback
Weight : 0.57   kg
Discount : 20.00  %
Price :   31.00      24.80

Request a Specimen Copy

Buy online using : Credit Card / Debit Card / Internet Banking



  • About the Book
  • Salient Features
  • Table of Contents
  • About the Author

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

Salient Features:

  • This second edition provides a new chapter on data warehousing and data mining.
  • Gives a complete account of running a DBMS including creation, maintenance, updating and accessing.
  • Has detailed coverage of Relational DBMS, including SQL, ORACLE and so on.
  • Flowcharts, program codes and tables have been included to illustrate solutions to problems and to explain concepts.
  • Provides “points to remember” and end-of-the-chapter exercises.

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

P S Gill :- Prof. P.S. Gill (ME Computer Science & Automation) from IISc Bangalore has 35 years experience in the field of Defence R&D and academics. He has the distinction of having worked at the centres of excellence like Bhabha Atomic Research Centre (BARC), Tata Institute of Fundamental Research (TIFR), Mumbai and LRDE, Bangalore. He has a hands-on experience on the development of embedded systems for air-defence applications that are currently operational in the defence of the nation. Presently, he is working as Head, Computer Science and Engineering at JSS ATE Noida. His research interests include Concurrency Control, Database Normalization, Query Optimization, Real-Time Databases, Cryptographic Algorithms and Issues related to Distributed Systems and Embedded Systems.
 

Your Browsing History

Database Management Systems

By : P S Gill

Discount : 20.00 %

Price :   31.00      24.80


Coming Soon

 

Top Sellers

Civil Engineering Objective Type Questions

Civil Engineering Objective ...

By : S.S Bhavikatti

Discount : 20.00 %

Price :   45.00    
 36.00

A Textbook of Finite Element Analysis

A Textbook of Finite Element ...

By : D.K. Maharaj

Discount : 20.00 %

Price :   90.00    
 72.00

Becoming an Architect

Becoming an Architect

By : Lee W. Waldrep

Discount : 20.00 %

Price :  

Total Quality Management

Total Quality Management

By : R Kesavan

Discount : 20.00 %

Price :   22.00    
 17.60

Customers who saw this book also saw

Object-Oriented Programming Using C++

Object-Oriented Programming ...

By : Kavita Pabreja

Discount : 20.00 %

Price :   50.00      40.00

Cracking the C Programming Skills

Cracking the C Programming ...

By : Shriram K. Vasudevan

Discount : 20.00 %

Price :   45.00      36.00

Plant Biotechnology

Plant Biotechnology

By : C.C. Giri

Discount : 20.00 %

Price :   13.00      10.40

Recent Trends in Water Research

Recent Trends in Water ...

By : S. Chidambaram

Discount : 20.00 %

Price :   138.00      110.40

Understanding Aerospace Chemical Propulsion

Understanding Aerospace ...

By : H S Mukunda

Discount : 20.00 %

Price :   55.00      44.00