Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.


This book sheds light on the principles behind the relational model, which is fundamental to all database-backed applications--and, consequently, most of the work that goes on in the computing world today. Database in Depth: The Relational Model for Practitioners goes beyond the hype and gets to the heart of how relational databases actually work. Ideal for experienced database developers and designers, this concise guide gives you a clear view of the technology--a view that's not influenced by any vendor or product. Featuring an extensive set of exercises, it will help you:

  • understand why and how the relational model is still directly relevant to modern database technology (and will remain so for the foreseeable future)

  • see why and how the SQL standard is seriously deficient

  • use the best current theoretical knowledge in the design of their databases and database applications

  • make informed decisions in their daily database professional activities

Database in Depth will appeal not only to database developers and designers, but also to a diverse field of professionals and academics, including database administrators (DBAs), information modelers, database consultants, and more. Virtually everyone who deals with relational databases should have at least a passing understanding of the fundamentals of working with relational models. Author C.J. Date has been involved with the relational model from its earliest days. An exceptionally clear-thinking writer, Date lays out principle and theory in a manner that is easily understood. Few others can speak as authoritatively the topic of relational databases as Date can.

Subscriber Reviews

Average Rating: 3 out of 5 rating Based on 2 Ratings

"This book is really good" - by softwarevisualization on 06-JUN-2012
Reviewer Rating: 1 star rating2 star rating3 star rating4 star rating5 star rating
This is an excellent book for anyone interested in being able to THINK about databases and data modeling at a higher level than just DDLs and SQL.

The value proposition  of this book, like all Date's books and writings,  is that by understanding the underlying relational model, you'll be saved from making  horrible mistakes, mistakes  that you can't later back out of.

I own this book and also  read it  again concurrently while refreshing my SQL DDL chops for a project. It's completely fresh and  frank and revealing.   It's a hard case to make to some people , that theoretical knowledge offers the  most practical value out there. I myself feel like I'm elevated above the morass of endless implementation details  and am able to get a bird's eye view of WHY things are the way they are and just as importantly  why things could never be some way I was unconsciously trying to make them be.

So there, there's a part of the value in a book like this. It prevents you from making  an infinite number of seemingly different mistakes which are all nevertheless rooted in the same misunderstanding of theory. Worse,  database products will LET you make those mistakes and worse yet is that such mistakes are offered in lots of books and perhaps by the DB guru where you work as "good advice" and are standard operation procedure  throughout the industry.

Date neither spares nor minces words. Either you like that style or you don't I myself like the clear, conversational tone he takes. He's at your house Sunday morning, with nowhere to go and the two of you are talking about databases and relational theory, and you're doing most of the listening. If you form that image in your mind,  this book is really rather enjoyable.

If you want something that more directly compares and contrasts relational  theory with the everyday practice of writing SQL, then you might look at SQL and Relational Theory by the same author.

Quite honestly, I  would prefer not to work for, with or hire anyone doing data modeling who hasn't read at least one of  Date's books.  That pretty well sums it up.

Report as Inappropriate

Table of Contents



The publisher has provided additional content related to this title.


Visit the catalog page for Database in Depth

  • Catalog Page

Visit the errata page for Database in Depth

  • Errata

Download the supplemental electronic content for Database in Depth

  • Supplemental Content