Tag: Advanced Database Management System Books

DBMS Raghu Ramakrishnan | Best DBMS Books

Database Management Systems By Raghu Ramakrishnan

 

This article reviews the book “Database Management Systems” by Raghu Ramakrishnan and Johannes Gehrke.

The article covers-

  • Special features of book
  • Analysis of Content
  • Analysis of Exercises
  • Necessary Instructions
  • Conclusion

 

Why Should Be Read?

 

Special Features of Book-

 

The special features of this book are-

  • It is one of the most detailed books for this subject.
  • It covers all the GATE topics.
  • The topics of Transaction Management are covered in great depth especially.
  • It deals with the content in a simple and crystal clear way which makes the subject beginner friendly.
  • Its exercise questions are of high quality and at par with the level of questions asked in the GATE exam.

 

Analysis of Content-

 

The following table analyzes sections of the book that are relevant for GATE-

 

Chapter No.GATE Relevant SectionsGATE Topics Covered
1All SectionsOverview (Optional Read)
22.1 to 2.5Basics of ER Model
33.1 to 3.4Relational Model
3.5ER to Relational Model
44.2Relational Algebra
4.3Relational Calculus
55.1 to 5.6SQL Queries
88.1 to 8.3Indexing
8.4File Organization
8.5Performance Tuning
1616.1Transactions and ACID Properties
16.2
16.3Concurrent Execution and Lock-based Concurrency Control
16.4
1717.1View Serializability
17.2 to 17.6Lock Management and Deadlocks
1818.2Crash Recovery and Check-pointing
18.5
18.6
19All SectionsNormalization

Covering Only These Sections Is Enough

 

Analysis of Exercises-

 

The following table analyzes exercises of the book that are relevant for GATE-

 

Chapter No.Question No.
22.2, 2.3, 2.4, 2.7, 2.8
33.2, 3.5, 3.7, 3.8, 3.9
44.2, 4.3, 4.4, 4.5
55.1 to 5.5, 5.7, 5.10
88.4, 8.7, 8.10, 8.11
1616.2, 16.3, 16.5, 16.8, 16.9
1717.2, 17.3, 17.4, 17.6, 17.7
1919.2, 19.3, 19.5, 19.7, 19.8, 19.10, 19.12, 19.13, 19.18, 19.24, 19.26

Practicing Only These Exercises Is Enough

 

Necessary Instructions-

 

Keep the following instructions in mind while reading the book-

  • The book has nearly 1100 pages.
  • Read only selective topics which are part of a GATE syllabus.
  • Competitive exams mainly focus on numerical questions from this subject.
  • So, practice all the questions mentioned in the Analysis of Exercises section.
  • Theoretical questions may be asked but less frequently asked.
  • So, keep making short notes while reading the book to solve theoretical questions.
  • Focus on the topics of Normalization and Transaction Management.
  • Questions from these topics are asked every year in the GATE exam.

 

Conclusion-

 

  • This textbook covers the entire GATE syllabus in a clear and detailed manner.
  • The exercise questions provide good practice to solve GATE questions.
  • Overall, this book is a good read while preparing this subject for GATE exam.

 

THIS BOOK IS SELF-SUFFICIENT FOR GATE EXAM.

 

 

Amazon Rating

 

Student’s Reviews-

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Other Recommended Books-

 

Fundamentals of Database System By Navathe-

 

 

Database System Concepts By Abraham Silberschatz & Korth-