Physical Database Design: The Database Professional's Guide to Exploiting Indexes, Views, Storage, and More

Sam S. Lightstone, Toby J. Teorey, Tom Nadeau

  • 出版商: Morgan Kaufmann
  • 出版日期: 2007-03-21
  • 售價: $1,045
  • 語言: 英文
  • 頁數: 448
  • 裝訂: Paperback
  • ISBN: 0123693896
  • ISBN-13: 9780123693891
  • 相關分類: 資料庫
  • 下單後立即進貨 (約5~7天)

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

商品描述

Description

I highly recommend Physical Database Design by Lightstone, Teorey, and Nadeau. The book covers fine aspects of physical design -- issues such as the effects of different approaches to indexes, tradeoffs in materializing views, and details of physical data layout. Unlike other books, it does not focus on a particular product, but instead covers the deep principles that cut across products. The book addresses both transaction intensive applications (OLTP) as well as data warehouses (OLAP). Their new book is a welcome addition to the literature.
--Michael Blaha, OMT Associates, Inc.

This is an excellent book on physical database design, giving pragmatic models and advice. It has a wealth of information for both the student and for the practitioner -- presenting analytic models and practical tips that are demonstrated with examples using Oracle, DB2, and Microsoft SQL Server.
--Jim Gray, Microsoft Research

The rapidly increasing volume of information contained in relational databases places a strain on databases, performance, and maintainability: DBAs are under greater pressure than ever to optimize database structure for system performance and administration.

Physical Database Design discusses the concept of how physical structures of databases affect performance, including specific examples, guidelines, and best and worst practices for a variety of DBMSs and configurations. Something as simple as improving the table index design has a profound impact on performance. Every form of relational database, such as Online Transaction Processing (OLTP), Enterprise Resource Management (ERP), Data Mining (DM), or Management Resource Planning (MRP), can be improved using the methods provided in the book.

Features
• The first complete treatment on physical database design, written by the authors of the seminal, Database Modeling and Design: Logical Design, 4th edition.
• Includes an introduction to the major concepts of physical database design as well as detailed examples, using methodologies and tools most popular for relational databases today: Oracle, DB2 (IBM), and SQL Server (Microsoft).
• Focuses on physical database design for exploiting B+tree indexing, clustered indexes, multidimensional clustering (MDC), range partitioning, shared nothing partitioning, shared disk data placement, materialized views, bitmap indexes, automated design tools, and more!

Table of Contents 

1: Introduction to physical database design
2: Basic indexing methods
3: Query optimization and plan selection
4: Selecting indexes
5: Selecting materialized views
6: Shared nothing partitioning
7: Range partitioning
8: Multidimensional clustering
9: The interdependence problem (i.e. design choices)
10: Data sampling in design exploration
11: Access plan selection and physical design
12: Automated physical database design
13: Down to the metal
14: Physical design for Decision Support, Warehousing and OLAP
15: Denormalization
16: Distributed Data Allocation
Appendix A: A Simple Performance Model for Database

商品描述(中文翻譯)

描述



我強烈推薦Lightstone、Teorey和Nadeau的《物理資料庫設計》。這本書涵蓋了物理設計的細節,例如不同索引方法的影響、視圖實體化的權衡以及物理資料佈局的細節。與其他書籍不同,它不專注於特定產品,而是涵蓋了跨產品的深層原則。該書既涵蓋了交易密集型應用(OLTP),也涵蓋了數據倉庫(OLAP)。這本新書是文獻中的一個受歡迎的補充。
--Michael Blaha, OMT Associates, Inc.

這是一本關於物理資料庫設計的優秀書籍,提供了實用的模型和建議。它包含了豐富的信息,適合學生和從業人員使用,並使用Oracle、DB2和Microsoft SQL Server等示例演示了分析模型和實用技巧。
--Jim Gray, Microsoft Research

關聯式資料庫中所包含的信息量迅速增加,對資料庫、性能和可維護性造成了壓力:資料庫管理員(DBA)比以往更加需要優化資料庫結構以提高系統性能和管理能力。

《物理資料庫設計》討論了資料庫的物理結構如何影響性能的概念,包括具體的示例、指南以及各種DBMS和配置的最佳和最差實踐。即使是改進表索引設計這樣簡單的事情也會對性能產生深遠的影響。每種形式的關聯式資料庫,例如在線事務處理(OLTP)、企業資源管理(ERP)、數據挖掘(DM)或管理資源計劃(MRP)中,都可以使用本書提供的方法進行改進。

特點
• 這是第一本完整介紹物理資料庫設計的書籍,由《資料庫建模與設計:邏輯設計》第四版的作者撰寫。
• 包括對物理資料庫設計主要概念的介紹,以及使用當今最流行的方法和工具(如Oracle、DB2(IBM)和SQL Server(Microsoft))進行詳細示例。
• 專注於利用B+樹索引、聚集索引、多維聚集(MDC)、範圍分區、共享無分區、共享磁碟資料佈局、實體化視圖、位圖索引、自動設計工具等進行物理資料庫設計!


目錄 



1: 物理資料庫設計簡介
2: 基本索引方法
3: 查詢優化和計劃選擇
4: 選擇索引
5:
選擇實體化視圖
6: 共享無分區
7: 範圍分區
8: 多維聚集
9: 相互依賴問題(即設計選擇)
10:
設計探索中的數據抽樣
11: 存取計劃選擇和物理設計
12: 自動物理資料庫設計
13: 深入細節
14:
面向決策支持、資料倉庫和OLAP的物理設計
15: 反規範化
16: 分散式資料分配
附錄A:資料庫的簡單性能模型