買這商品的人也買了...
-
C++ Primer, 3/e 中文版$980$774 -
LPI Linux 資格檢定 (LPI Linux Certification in a Nutshell)$880$695 -
Visual C#.NET 程式設計經典$650$429 -
ASP.NET 程式設計徹底研究$590$466 -
鳥哥的 Linux 私房菜─基礎學習篇增訂版$560$476 -
最新 JavaScript 完整語法參考辭典 第三版$490$382 -
ASP.NET 徹底研究進階技巧─高階技巧與控制項實作$650$507 -
UML 精華第三版 : 標準物件模型語言 (UML Distilled, 3/e)$460$363 -
Sniffer Pro 網路最佳化與故障排除手冊$580$452 -
Linux iptables 技術實務─防火牆、頻寬管理、連線管制$620$527 -
Web CSS 網頁樣式設計學 (Cascading Style Sheets Standard Design Guide)$580$452 -
Java 2 全方位學習(J2SE 5.0 增修版)$750$593 -
Head First Servlets & JSP：SCWCD 專業認證指南 (Head First Servlets & JSP)$880$748 -
敏捷軟體開發：原則、樣式及實務 (Agile Software Development: Principles, Patterns, and Practices)$780$616 -
打造個性化 XOOPS2 網站─佈景設計、模組開發$580$493 -
CCNA 認證教戰手冊 (CCNA: Cisco Certified Network Associate Study Guide, 5/e)(Exam 640-801)$820$697 -
計算機組織與設計 (Computer Organization and Design: The Hardware/Software Interface, 3/e)$680$646 -
最新詳解 Javascript & HTML & CSS 語法辭典(增訂新版)$490$382 -
簡報王-圖解式簡報展現企劃提案$450$351 -
深入淺出 Java 程式設計, 2/e (Head First Java, 2/e)$880$695 -
SQL Server 2005 資料庫開發聖經$890$757 -
鳥哥的 Linux 私房菜基礎學習篇, 2/e$780$663 -
ASP.NET 2.0 深度剖析範例集$650$507 -
SQL and Relational Theory: How to Write Accurate SQL Code (Paperback)$1,570$1,492 -
Oracle 管理之道$890$703
相關主題
商品描述
Description:
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.
Table of Contents:
Foreword
Preface
A Remark on Terminology
Principles, Not Products
A Review of the Original Model
Model Versus Implementation
Properties of Relations
Relations Versus Relvars
Values Versus Variables
Summary
Exercises
Domain-Constrained Comparisons
Data Value Atomicity
So What's a Type?
Scalar Versus Nonscalar Types
Summary
Exercises
What's a Tuple?
Some Important Consequences
What's a Relation?
Further Important Consequences
Why Duplicate Tuples Are Prohibited
Why Nulls Are Prohibited
TABLE_DUM and TABLE_DEE
Summary
Exercises
Updating Is Set-at-a-Time
More on Candidate Keys
More on Foreign Keys
More on Views
Relvars and Predicates
More on Relations Versus Types
Summary
Exercises
More on Closure
The Original Operators
Evaluating SQL Expressions
Extend and Summarize
Group and Ungroup
Expression Transformation
Relational Comparisons
More on Relational Assignment
The ORDER BY Operator
Summary
Exercises
Type Constraints
Database Constraints
Transactions
Why Database Constraint Checking Must Be Immediate
But Doesn't Some Checking Have to Be Deferred?
Constraints and Predicates
Miscellaneous Issues
Summary
Exercises
The Place of Design Theory
Functional Dependencies and Boyce/Codd Normal Form
Join Dependencies and Fifth Normal Form
Two Cheers for Normalization
Orthogonality
Some Remarks on Physical Design
Summary
Exercises
The Relational Model Defined
Objectives of the Relational Model
Some Database Principles
The Relational Model Versus Others
What Remains to Be Done?
Summary
Exercises
index
商品描述(中文翻譯)
**描述：**
本書闡明了關於關聯模型的原則，這是所有以資料庫為支撐的應用程式的基礎，因此也是當今計算世界中大多數工作的基礎。《深入資料庫：實務者的關聯模型》超越了炒作，深入探討關聯資料庫實際運作的核心。
本書非常適合經驗豐富的資料庫開發者和設計師，這本簡明的指南讓您清楚了解這項技術，這種觀點不受任何供應商或產品的影響。書中包含大量練習，將幫助您：
- 理解為什麼以及如何關聯模型仍然與現代資料庫技術直接相關（並且在可預見的未來將保持如此）
- 了解為什麼以及如何SQL標準存在嚴重缺陷
- 在設計資料庫及資料庫應用程式時，使用當前最佳的理論知識
- 在日常資料庫專業活動中做出明智的決策
《深入資料庫》不僅吸引資料庫開發者和設計師，還吸引了包括資料庫管理員（DBA）、資訊建模師、資料庫顧問等多元專業人士和學者。幾乎所有與關聯資料庫打交道的人都應該對關聯模型的基本原則有至少一個初步的理解。
作者C.J. Date自關聯模型的早期階段就參與其中。Date是一位思路清晰的作家，以易於理解的方式闡述原則和理論。很少有人能像Date一樣權威地談論關聯資料庫的主題。
**目錄：**
- 前言
- 序言
- 關於術語的說明
- 原則，而非產品
- 原始模型的回顧
- 模型與實作
- 關聯的特性
- 關聯與關聯變數
- 值與變數
- 總結
- 練習
- 領域約束比較
- 資料值的原子性
- 那麼什麼是類型？
- 標量類型與非標量類型
- 總結
- 練習
- 什麼是元組？
- 一些重要的後果
- 什麼是關聯？
- 進一步的重要後果
- 為什麼禁止重複元組
- 為什麼禁止空值
- TABLE_DUM和TABLE_DEE
- 總結
- 練習
- 更新是一次性操作
- 關於候選鍵的更多內容
- 關於外鍵的更多內容
- 關於視圖的更多內容
- 關聯變數與謂詞
- 關於關聯與類型的更多內容
- 總結
- 練習
- 關於閉包的更多內容
- 原始運算子
- 評估SQL表達式
- 擴展與總結
- 分組與取消分組
- 表達式轉換
- 關聯比較
- 關於關聯賦值的更多內容
- ORDER BY運算子
- 總結
- 練習
- 類型約束
- 資料庫約束
- 交易
- 為什麼資料庫約束檢查必須立即進行
- 但某些檢查不必延遲嗎？
- 約束與謂詞
- 其他問題
- 總結
- 練習
- 設計理論的位置
- 功能依賴與Boyce/Codd正規形式
- 連接依賴與第五正規形式
- 正規化的兩次喝彩
- 正交性
- 關於物理設計的一些說明
- 總結
- 練習
- 關聯模型的定義
- 關聯模型的目標
- 一些資料庫原則
- 關聯模型與其他模型的比較
- 還有什麼需要做的？
- 總結
- 練習
- 索引
