Star Schema The Complete Reference (Paperback)

Christopher Adamson

  • 出版商: McGraw-Hill Education
  • 出版日期: 2010-07-28
  • 售價: $1,300
  • 貴賓價: 9.5$1,235
  • 語言: 英文
  • 頁數: 510
  • 裝訂: Paperback
  • ISBN: 0071744320
  • ISBN-13: 9780071744324
  • 相關分類: 資料庫Data Science
  • 立即出貨 (庫存=1)

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

商品描述

The definitive guide to dimensional design for your data warehouse

Learn the best practices of dimensional design. Star Schema: The Complete Reference offers in-depth coverage of design principles and their underlying rationales. Organized around design concepts and illustrated with detailed examples, this is a step-by-step guidebook for beginners and a comprehensive resource for experts.

This all-inclusive volume begins with dimensional design fundamentals and shows how they fit into diverse data warehouse architectures, including those of W.H. Inmon and Ralph Kimball. The book progresses through a series of advanced techniques that help you address real-world complexity, maximize performance, and adapt to the requirements of BI and ETL software products. You are furnished with design tasks and deliverables that can be incorporated into any project, regardless of architecture or methodology.

  • Master the fundamentals of star schema design and slow change processing
  • Identify situations that call for multiple stars or cubes
  • Ensure compatibility across subject areas as your data warehouse grows
  • Accommodate repeating attributes, recursive hierarchies, and poor data quality
  • Support conflicting requirements for historic data
  • Handle variation within a business process and correlation of disparate activities
  • Boost performance using derived schemas and aggregates
  • Learn when it's appropriate to adjust designs for BI and ETL tools

商品描述(中文翻譯)

《星型模式:完整參考指南》是一本關於資料倉儲維度設計的權威指南。

本書深入探討了設計原則及其基本原理,並以詳細的實例進行說明。它以設計概念為組織架構,適合初學者使用的逐步指南,同時也是專家的綜合資源。

這本全面的書籍從維度設計基礎知識開始,並展示了它們如何適應不同的資料倉儲架構,包括W.H. Inmon和Ralph Kimball的架構。書中介紹了一系列高級技術,幫助您應對現實世界的複雜性,最大限度地提高性能,並適應商業智能和ETL軟體產品的需求。無論架構或方法論如何,您都可以將書中提供的設計任務和成果應用於任何項目中。

本書的內容包括:

- 掌握星型模式設計和慢變更處理的基礎知識
- 確定需要多個星型模式或立方體的情況
- 在資料倉儲擴展時確保不同主題領域的兼容性
- 處理重複屬性、遞迴層次結構和資料品質差的情況
- 支援對歷史資料的衝突需求
- 處理業務流程中的變異和不同活動的相關性
- 使用衍生模式和聚合來提高性能
- 學習在何時適應商業智能和ETL工具的設計調整。

這本書將幫助您深入了解維度設計的最佳實踐,並提供實用的指導,讓您在資料倉儲項目中取得成功。