Building a Data Warehouse: With Examples in SQL Server
暫譯: 建立資料倉儲：以 SQL Server 為例

Vincent Rainardi

Building a Data Warehouse: With Examples in SQL Server
  • 出版商: Apress
  • 出版日期: 2008-01-07
  • 售價: $4,210
  • 貴賓價: 9.5 折 $4,000
  • 語言: 英文
  • 頁數: 523
  • 裝訂: Hardcover
  • ISBN: 1590599314
  • ISBN-13: 9781590599310
  • 相關分類: MSSQL、SQL

    • 海外代購書籍(需單獨結帳)

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

商品描述

Description 

Building a Data Warehouse: With Examples in SQL Server describes how to build a data warehouse completely from scratch and shows practical examples on how to do it. Author Vincent Rainardi also describes some practical issues he has experienced that developers are likely to encounter in their first data warehousing project, along with solutions and advice. The RDBMS used in the examples is SQL Server; the version will not be an issue as long as the user has SQL Server 2005 or later.

The book is organized as follows. In the beginning of this book (Chapters 1 through 6), you learn how to build a data warehouse, for example, defining the architecture, understanding the methodology, gathering the requirements, designing the data models, and creating the databases. Then in Chapters 7 through 10, you learn how to populate the data warehouse, for example, extracting from source systems, loading the data stores, maintaining data quality, and utilizing the metadata. After you populate the data warehouse, in Chapters 11 through 15, you explore how to present data to users using reports and multidimensional databases and how to use the data in the data warehouse for business intelligence, customer relationship management, and other purposes. Chapters 16 and 17 wrap up the book: After you have built your data warehouse, before it can be released to production, you need to test it thoroughly. After your application is in production, you need to understand how to administer data warehouse operation.

What you’ll learn

  • A detailed understanding of what it takes to build a data warehouse
  • The implementation code in SQL Server to build the data warehouse
  • Dimensional modeling, data extraction methods, data warehouse loading, populating dimension and fact tables, data quality, data warehouse architecture, and database design
  • Practical data warehousing applications such as business intelligence reports, analytics applications, and customer relationship management

商品描述(中文翻譯)

**描述**

《建立資料倉儲：以 SQL Server 為例》描述了如何從零開始建立資料倉儲，並展示了實際的範例。作者 **Vincent Rainardi** 也描述了一些他在首次資料倉儲專案中可能遇到的實際問題，以及解決方案和建議。範例中使用的關聯式資料庫管理系統是 SQL Server；只要使用者擁有 SQL Server 2005 或更高版本，版本問題就不會成為障礙。

本書的組織結構如下。在本書的開頭（第 1 章至第 6 章），您將學習如何建立資料倉儲，例如定義架構、理解方法論、收集需求、設計資料模型和創建資料庫。接著在第 7 章至第 10 章中，您將學習如何填充資料倉儲，例如從來源系統提取資料、加載資料存儲、維護資料品質和利用元資料。在填充資料倉儲之後，在第 11 章至第 15 章中，您將探索如何使用報告和多維資料庫向使用者呈現資料，以及如何將資料倉儲中的資料用於商業智慧、客戶關係管理和其他用途。第 16 章和第 17 章總結了本書：在您建立資料倉儲之後，在其可以投入生產之前，您需要徹底測試它。在您的應用程式投入生產後，您需要了解如何管理資料倉儲的運作。

**您將學到的內容**

- 對建立資料倉儲所需的詳細理解
- 在 SQL Server 中建立資料倉儲的實作程式碼
- 維度建模、資料提取方法、資料倉儲加載、填充維度和事實表、資料品質、資料倉儲架構和資料庫設計
- 實用的資料倉儲應用，例如商業智慧報告、分析應用和客戶關係管理

類似商品