Building a Data Warehouse: With Examples in SQL Server (Paperback)

Vincent Rainardi

  • 出版商: Apress
  • 出版日期: 2011-12-23
  • 售價: $2,550
  • 貴賓價: 9.5$2,423
  • 語言: 英文
  • 頁數: 540
  • 裝訂: Paperback
  • ISBN: 143024299X
  • ISBN-13: 9781430242994
  • 相關分類: MSSQLSQL
  • 無法訂購

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

商品描述

Now available in paperback—

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 relational database management system (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

Who this book is for

There are three audiences for the book. The first are the people who implement the data warehouse. This could be considered a field guide for them. The second is database users/admins who want to get a good understanding of what it would take to build a data warehouse. Finally, the third audience is managers who must make decisions about aspects of the data warehousing task before them and use the book to learn about these issues.

商品描述(中文翻譯)

現已推出平裝版《使用 SQL Server 建立資料倉儲:附帶實例》。本書詳細介紹了如何從頭開始建立資料倉儲,並提供實用的範例。作者 Vincent Rainardi 還描述了他在第一個資料倉儲專案中遇到的一些實際問題,並提供解決方案和建議。本書的範例使用的關聯式資料庫管理系統 (RDBMS) 是 SQL Server,只要使用者擁有 SQL Server 2005 或更新版本,版本問題不會成為問題。

本書的組織架構如下。在本書的開頭部分(第 1 至 6 章),您將學習如何建立資料倉儲,例如定義架構、了解方法論、收集需求、設計資料模型和建立資料庫。然後在第 7 至 10 章,您將學習如何填充資料倉儲,例如從來源系統中提取資料、載入資料存儲、維護資料品質和利用元數據。在填充資料倉儲後,在第 11 至 15 章,您將探索如何使用報表和多維數據庫向用戶呈現資料,以及如何在商業智能、客戶關係管理和其他用途中使用資料倉儲中的資料。第 16 和 17 章總結了本書:在建立資料倉儲之後,在將其投入生產之前,您需要進行全面的測試。在應用程式投入生產後,您需要了解如何管理資料倉儲的運作。

您將學到什麼:
- 了解建立資料倉儲所需的詳細知識
- 使用 SQL Server 實現建立資料倉儲的程式碼
- 維度建模、資料提取方法、資料倉儲載入、填充維度和事實表、資料品質、資料倉儲架構和資料庫設計
- 實用的資料倉儲應用,如商業智能報表、分析應用和客戶關係管理

本書的讀者:
本書的讀者可以分為三個群體。第一群是實施資料倉儲的人員,本書對他們來說可以視為一本實戰指南。第二群是希望深入了解建立資料倉儲所需的知識的資料庫使用者/管理員。最後,第三群是在面對資料倉儲任務的各個方面需要做出決策的管理人員,他們可以通過本書了解這些問題。