Database Design and Relational Theory

Normal Forms and All That Jazz

Nonfiction, Computers, Database Management
Cover of the book Database Design and Relational Theory by C.J. Date, O'Reilly Media
View on Amazon View on AbeBooks View on Kobo View on B.Depository View on eBay View on Walmart
Author: C.J. Date ISBN: 9781449330200
Publisher: O'Reilly Media Publication: April 19, 2012
Imprint: O'Reilly Media Language: English
Author: C.J. Date
ISBN: 9781449330200
Publisher: O'Reilly Media
Publication: April 19, 2012
Imprint: O'Reilly Media
Language: English

What makes this book different from others on database design? Many resources on design practice do little to explain the underlying theory, and books on design theory are aimed primarily at theoreticians. In this book, renowned expert Chris Date bridges the gap by introducing design theory in ways practitioners can understand—drawing on lessons learned over four decades of experience to demonstrate why proper database design is so critical in the first place.

Every chapter includes a set of exercises that show how to apply the theoretical ideas in practice, provide additional information, or ask you to prove some simple theoretical result. If you’re a database professional familiar with the relational model, and have more than a passing interest in database design, this book is for you.

Questions this book answers include:

  • Why is Heath’s Theorem so important?
  • What is The Principle of Orthogonal Design?
  • What makes some JDs reducible and others irreducible?
  • Why does dependency preservation matter?
  • Should data redundancy always be avoided? Can it be?

Databases often stay in production for decades, and careful design is critical for avoiding subtle errors and processing problems over time. If they’re badly designed, the negative impacts can be incredibly widespread. This gentle introduction shows you how to use important theoretical results to create good database designs.

View on Amazon View on AbeBooks View on Kobo View on B.Depository View on eBay View on Walmart

What makes this book different from others on database design? Many resources on design practice do little to explain the underlying theory, and books on design theory are aimed primarily at theoreticians. In this book, renowned expert Chris Date bridges the gap by introducing design theory in ways practitioners can understand—drawing on lessons learned over four decades of experience to demonstrate why proper database design is so critical in the first place.

Every chapter includes a set of exercises that show how to apply the theoretical ideas in practice, provide additional information, or ask you to prove some simple theoretical result. If you’re a database professional familiar with the relational model, and have more than a passing interest in database design, this book is for you.

Questions this book answers include:

Databases often stay in production for decades, and careful design is critical for avoiding subtle errors and processing problems over time. If they’re badly designed, the negative impacts can be incredibly widespread. This gentle introduction shows you how to use important theoretical results to create good database designs.

More books from O'Reilly Media

Cover of the book Running Lean by C.J. Date
Cover of the book Ambient Findability by C.J. Date
Cover of the book iPhone: The Missing Manual by C.J. Date
Cover of the book Infrastructure as Code by C.J. Date
Cover of the book The Computer User's Survival Guide by C.J. Date
Cover of the book Elegant SciPy by C.J. Date
Cover of the book Mathematica Cookbook by C.J. Date
Cover of the book The Data Journalism Handbook by C.J. Date
Cover of the book ASP.NET 2.0 Cookbook by C.J. Date
Cover of the book Data Science for Business by C.J. Date
Cover of the book Machine Learning with Python Cookbook by C.J. Date
Cover of the book Excel 2010: The Missing Manual by C.J. Date
Cover of the book Linux Security Cookbook by C.J. Date
Cover of the book Head First Algebra by C.J. Date
Cover of the book The New Relational Database Dictionary by C.J. Date
We use our own "cookies" and third party cookies to improve services and to see statistical information. By using this website, you agree to our Privacy Policy