Database Design and Relational Theory: Normal Forms and All That Jazz (Paperback)

C. J. Date

買這商品的人也買了...

商品描述

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.

商品描述(中文翻譯)

這本書與其他關於資料庫設計的書籍有何不同?許多關於設計實踐的資源很少解釋其基礎理論,而關於設計理論的書籍主要針對理論家。在這本書中,知名專家Chris Date通過以往四十年的經驗教訓,以實踐者能理解的方式介紹設計理論,彌補了這一差距,並展示了為什麼正確的資料庫設計首要重要。

每一章節都包含一系列的練習,展示如何將理論應用於實踐中,提供額外的資訊,或要求您證明一些簡單的理論結果。如果您是一位熟悉關聯模型並對資料庫設計有著更多興趣的資料庫專業人士,這本書適合您。

這本書回答的問題包括:

- Heath's Theorem為什麼如此重要?
- 什麼是正交設計原則?
- 什麼使一些JD可簡化而其他JD不可簡化?
- 為什麼依賴性保留很重要?
- 是否應該始終避免資料冗餘?是否可能?

資料庫通常在生產環境中運行數十年,仔細的設計對於避免隱藏的錯誤和處理問題至關重要。如果設計不良,負面影響可能非常廣泛。這本溫和的介紹向您展示如何使用重要的理論結果來創建良好的資料庫設計。