相關主題
商品描述
Description:
Database design is one of the most contentious issues in computer science. There is always a delicate balance to be struck between the strict academic rules that govern the design of relational databases and the real-world techniques that programmers apply to get the job done in a certain time frame. This book's goal is to cover—from a "real-world" point of view—all of the essential elements in designing, modeling, and building efficient relational databases, while avoiding a dry, theoretical approach.
Author Louis Davidson explains the process of implementing a database—from generating tables and allowing access to these tables using Microsoft SQL Server 2000. This includes tackling data modeling (focusing on the IDEF1X notation), requirements gathering, normalization (beyond the Third Normal Form), and implementing tables, constraints, triggers, procedures, user-defined functions, and so on. Davidson provides a full and realistic case study that clearly illustrates the entire process, from the initial discussions of a client's needs, through development of a logical model, to a complete implementation of the system.
商品描述(中文翻譯)
描述:
資料庫設計是 computer science 中最具爭議的議題之一。在支配關聯式資料庫設計的嚴謹學術規則,以及程式設計師為了在特定時限內完成工作而採用的實務技術之間,始終必須取得微妙的平衡。本書的目標是從「真實世界」的觀點出發,涵蓋設計、建模與建置高效率關聯式資料庫所需的所有基本要素,同時避免枯燥乏味的理論探討。
作者 Louis Davidson 說明如何使用 Microsoft SQL Server 2000 實作資料庫,包括建立資料表,以及讓使用者存取這些資料表。內容涵蓋資料建模(著重於 IDEF1X 標記法)、需求蒐集、正規化(超越第三正規化)、以及實作資料表、條件約束、觸發程序、程序、使用者自訂函式等。Davidson 提供了一個完整且貼近實務的案例研究,清楚呈現整個流程:從最初討論客戶需求開始,經過邏輯模型的開發,直到系統的完整實作。
