What do you think?
Rate this book
Database Design and Relational Theory: Normal Forms and All That Jazz (Theory in Practice) by C. J. Date
Because databases often stay in production for decades, careful design is critical to making the database serve the needs of your users over years, and to avoid subtle errors or performance problems. In this book, CJ Date, a leading exponent of relational databases, lays out the principles of good database design.
Database Design and Relational Theory investigates denormalization, implicit dependencies, redundancy, and many other topics. DBAs will produce better designs and keep their data centers running better through the ideas conveyed in this book.
Questions that this book answers include:
What is Heath's Theorem, and why is it important?
What is The Principle of Orthogonal Design?
What makes some JDs reducible and others irreducible?
What is dependency preservation, and why is it important?
Should data redundancy always be avoided? Can it be?
Database Design and Relational Theory investigates denormalization, implicit dependencies, redundancy, and many other topics. DBAs will produce better designs and keep their data centers running better through the ideas conveyed in this book.
Questions that this book answers include:
What is Heath's Theorem, and why is it important?
What is The Principle of Orthogonal Design?
What makes some JDs reducible and others irreducible?
What is dependency preservation, and why is it important?
Should data redundancy always be avoided? Can it be?
294 pages, Paperback
First published January 1, 2012
41 people are currently reading
173 people want to read
Ratings & Reviews
Friends & Following
Create a free account to discover what your friends think of this book!
Community Reviews
Displaying 1 - 3 of 3 reviews
June 5, 2023
It's not a dry database textbook. it's not beginner friendly though. It assumes you know about the basics like the NFs and the redundancies. The approach is mathematical and very much grounded on author's experience. I like how I can consider this a foundational read in developing apps even in the age of cloud.
May 8, 2015
This book presents enough theory for a formal discussion, and also ilustrates with examples.
It seems to be as close to practical a theoretical book can be.
It seems to be as close to practical a theoretical book can be.
June 25, 2024
A bit heavy but a great read that helps to both sharpen current skills in database planning and development as well as getting a broader perspective on current perspectives of relational theory
Displaying 1 - 3 of 3 reviews