Database Design and Relational Theory: Normal Forms and All That Jazz

Date, Chris J.

  • 出版商: Apress
  • 出版日期: 2019-12-16
  • 售價: $1,500
  • 貴賓價: 9.5$1,425
  • 語言: 英文
  • 頁數: 451
  • 裝訂: Quality Paper - also called trade paper
  • ISBN: 1484255399
  • ISBN-13: 9781484255391
  • 相關分類: 資料庫SQL
  • 立即出貨 (庫存=1)

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

商品描述

Create database designs that scale, meet business requirements, and inherently work toward keeping your data structured and usable in the face of changing business models and software systems.
This book is about database design theory. Design theory is the scientific foundation for database design, just as the relational model is the scientific foundation for database technology in general. Databases lie at the heart of so much of what we do in the computing world that negative impacts of poor design can be extraordinarily widespread.

This second edition includes greatly expanded coverage of exotic and little understood normal forms such as: essential tuple normal form (ETNF), redundancy free normal form (RFNF), superkey normal form (SKNF), sixth normal form (6NF), and domain key normal form (DKNF). Also included are new appendixes, including one that provides an in-depth look into the crucial notion of data consistency. Sequencing of topics has been improved, and many explanations and examples have been rewritten and clarified based upon the author's teaching of the content in instructor-led courses.
This book aims to be different from other books on design by bridging the gap between the theory of design and the practice of design. The book explains theory in a way that practitioners should be able to understand, and it explains why that theory is of considerable practical importance. Reading this book provides you with an important theoretical grounding on which to do the practical work of database design. Reading the book also helps you in going to and understanding the more academic texts as you build your base of knowledge and expertise. Anyone with a professional interest in database design can benefit from using this book as a stepping-stone toward a more rigorous design approach and more lasting database models.


What You Will Learn

  • Understand what design theory is and is not
  • Be aware of the two different goals of normalization
  • Know which normal forms are truly significant
  • Apply design theory in practice
  • Be familiar with techniques for dealing with redundancy
  • Understand what consistency is and why it is crucially important

Who This Book Is For
Those having a professional interest in database design, including data and database administrators; educators and students specializing in database matters; information modelers and database designers; DBMS designers, implementers, and other database vendor personnel; and database consultants. The book is product independent.

商品描述(中文翻譯)

創建能夠擴展、滿足業務需求並在不斷變化的業務模型和軟體系統中保持數據結構和可用性的數據庫設計。這本書是關於數據庫設計理論的。設計理論是數據庫設計的科學基礎,就像關聯模型是數據庫技術的科學基礎一樣。數據庫在我們在計算機世界中所做的許多事情中起著核心作用,因此糟糕設計的負面影響可能非常廣泛。

第二版大大擴展了對於異常和不太理解的正規化形式的涵蓋,例如:基本元組正規化形式(ETNF)、無冗餘正規化形式(RFNF)、超鍵正規化形式(SKNF)、第六正規化形式(6NF)和域鍵正規化形式(DKNF)。還包括新的附錄,其中一個深入探討了數據一致性的重要概念。改進了主題的排序,並根據作者在教授課程中的教學內容重新編寫和澄清了許多解釋和示例。

這本書旨在通過填補設計理論和設計實踐之間的差距來與其他設計書有所不同。本書以實踐者能夠理解的方式解釋理論,並解釋為什麼該理論具有相當重要的實踐價值。閱讀本書可以為您提供重要的理論基礎,以便進行實際的數據庫設計工作。閱讀本書還有助於您在建立知識和專業知識基礎時閱讀和理解更多學術文獻。任何對數據庫設計有興趣的專業人士都可以從使用本書作為更嚴謹的設計方法和更持久的數據庫模型的跳板中受益。

您將學到什麼

- 理解設計理論的內涵和外延
- 了解正規化的兩個不同目標
- 知道哪些正規化形式真正重要
- 在實踐中應用設計理論
- 熟悉處理冗餘的技術
- 理解一致性的重要性及其原因

本書適合對象

對數據庫設計有專業興趣的人,包括數據和數據庫管理員;專攻數據庫事務的教育工作者和學生;信息建模師和數據庫設計師;DBMS設計師、實施者和其他數據庫供應商人員;以及數據庫顧問。本書與產品無關。

作者簡介

CJ Date is an independent author, lecturer, researcher, and consultant, specializing in relational database technology, a field he helped pioneer. Prior to leaving IBM in 1983, he was involved in technical planning and externals design for the IBM products SQL/DS and DB2. His book An Introduction to Database Systems (8th edition) is the standard text on the subject and has sold 900,000 copies, not counting translations. It is used by several hundred colleges and universities worldwide. Mr. Date has delivered live lectures and seminars on database matters at locations throughout the world. He holds an honors degree in mathematics from Cambridge University and has made a number of original contributions to database theory. He enjoys a reputation that is second to none for his ability to explain complex technical issues in a clear and understandable fashion.

作者簡介(中文翻譯)

CJ Date是一位獨立的作者、講師、研究員和顧問,專門從事關聯式數據庫技術的領域,這是他幫助開拓的領域。在1983年離開IBM之前,他參與了IBM產品SQL/DS和DB2的技術規劃和外部設計。他的書《An Introduction to Database Systems》(第8版)是該領域的標準教材,已售出90萬冊,不包括翻譯版。它被全球數百所大學和學院使用。Date先生在世界各地的地點進行了現場講座和研討會,探討數據庫相關問題。他擁有劍橋大學的數學榮譽學位,並對數據庫理論做出了多項原創貢獻。他以能夠以清晰易懂的方式解釋複雜技術問題而享有無與倫比的聲譽。