DATABASE MANAGEMENT SYSTEMS is designed for use in a course in databases. This book is distinctive in its emphasis on the practical side of databases. This means that it has unique coverage of database design, uses SQL throughout the book to demonstrate different concepts, and has an emphasis on query evaluation and optimization. In this revision the author has moved coverage of the ER model earlier in the book. Additionally, he has added chapters on Internet Databases, Decision Support, Data Mining, Object-Relational Databases, Spatial Databases and Deductive and Active Databases. DATABASE MANAGEMENT SYSTEMS is accompanied by a website that includes solutions, presentation materials, practical SQL assignments, the minibase software and helpful lecture tips.
I never thought I'd enjoy learned about databases so much, let alone from a 900-page book. My only criticism is that the acronyms and abbreviations Ramakrishnan uses often usually hurt more than they help. BCNF, FD, IC? Sure, whatever. But expecting me to decrypt "SNLRWH" into the schema "sailor_id, name, ..."--actually I can't remember what "LNRWH" were supposed to be. Nor can I find where it was originally defined. Definitely made it hard to read.
This book is top notch. I read this book line by line with full pleasure and as someone who has skimmed through several books in this field, I'd recommend it to anyone who wants to learn design databases of various software projects through a self-paced, well-explained, non-boring, full-of-useful-examples and precise approach (from the requirements, on to the conceptual design, to the logical design, to the refinement, the physical implementation and the security of your data), this book should definitely be a serious one on your go-to list. Specially the second chapter which goes through drawing Entity Relationship (ER) diagrams, that are part of the conceptual design step -the most important step in modeling your data- is written amazingly. A 5 star undoubtedly.
This book is aimed to be a companion to undergraduate courses teachers the fundamentals of relational database management. It is dry, very complete and explicit. It offers tons of examples to practice on and its explanations are concrete and clear. I would not recommend this book to someone simply aiming to learn about databases and how to use them properly, the book delves into relational algebra a lot, which is a concept that I believe has more of an academic use than any real world use in industry. It does teach quite a lot about database and query optimization, although again, you could probably learn about it somewhere else on the internet for free.
As a theoretical book it is good to understand how an SGBD works and how to think in the relational model paradigm. However it does not teach how to work with a DBMS in specific not being a recommended book to learn how to work with postgres or mysql.
It fails on the fact that it does not teach the ER model.
Tough one for me. My professor in a graduate course made this optional as a supplement to class lecture. We didn't often connect the topics and he often used different techniques to teach logical operations concept. I did work through many of the exercises in Chapter 5 diligently to practice lots of SQL - database content on supporting website was very useful.
A very standard textbook for classes in DBMS. A very typical one. But it's a very good book for people who wants to know about database in general with some details in it, of course.
The book corresponds to a bible, essentials and depth of how old and cores of modern RDBMS are designed. Most suitable as a textbook with any relational databases related course.