Wiley - The Datawarehouse Toolkit Olap Solutions, 2Nd Ed v2
更新日期: 2005年12月04日
文件大小: 2.937MB
图书格式: Adobe/PDF
图书语言: 英语
内容简介
the first edition of The Data Warehouse Toolkit (Wiley) in 1996. Although large corporate early adopters paved the way, since then, data warehousing has been embraced by organizations of all sizes. The industry has constructed thousands of data warehouses. The volume of data continues to grow as we populate our warehouses with increasingly atomic data and update them with greater frequency. Vendors continue to blanket the market with an everexpanding
set of tools to help us with data warehouse design, development, and usage. Most important, armed with access to our data warehouses, business
professionals are making better decisions and generating payback on their data warehouse investments.
Since the first edition of The Data Warehouse Toolkit was published, dimensional
modeling has been broadly accepted as the dominant technique for data warehouse presentation. Data warehouse practitioners and pundits alike have recognized that the data warehouse presentation must be grounded in simplicity
if it stands any chance of success. Simplicity is the fundamental key that allows users to understand databases easily and software to navigate data-bases efficiently. In many ways, dimensional modeling amounts to holding the fort against assaults on simplicity. By consistently returning to a businessdriven
perspective and by refusing to compromise on the goals of user understandability
and query performance, we establish a coherent design that serves the organization’s analytic needs. Based on our experience and the overwhelming feedback from numerous practitioners from companies like your own, we believe that dimensional modeling is absolutely critical to a successful
data warehousing initiative.
Dimensional modeling also has emerged as the only coherent architecture for building distributed data warehouse systems. When we use the conformed dimensions and conformed facts of a set of dimensional models, we have a practical and predictable framework for incrementally building complex data warehouse systems that have no center.
For all that has changed in our industry, the core dimensional modeling techniques
that Ralph Kimball published six years ago have withstood the test of time. Concepts such as slowly changing dimensions, heterogeneous products,
Introduction
factless fact tables, and architected data marts continue to be discussed in data warehouse design workshops around the globe. The original concepts have been embellished and enhanced by new and complementary techniques. We decided to publish a second edition of Kimball’s seminal work because we felt that it would be useful to pull together our collective thoughts on dimensional modeling under a single cover. We have each focused exclusively on decision support and data warehousing for over two decades. We hope to share the dimensional modeling patterns that have emerged repeatedly during the course of our data warehousing careers. This book is loaded with specific, practical design recommendations based on real-world scenarios.
The goal of this book is to provide a one-stop shop for dimensional modeling techniques. True to its title, it is a toolkit of dimensional design principles and techniques. We will address the needs of those just getting started in dimensional
data warehousing, and we will describe advanced concepts for those of you who have been at this a while. We believe that this book stands alone in its depth of coverage on the topic of dimensional modeling.