Data Warehousing Fundamentals for IT Professionals 2/e (絕)
- 20本以上,享 8.5折
售價
$
洽詢
- 一般書籍
- ISBN:9780470462072
- 作者:Paulraj Ponniah
- 版次:2
- 年份:2010
- 出版商:John Wiley
- 頁數/規格:571頁/精裝單色
書籍介紹
本書特色
目錄
作者介紹
Description
Data warehousing has revolutionized the way businesses in a wide variety of industries perform analysis and make strategic decisions. Since the first edition of Data Warehousing Fundamentals, numerous enterprises have implemented data warehouse systems and reaped enormous benefits. Many more are in the process of doing so. Now, this new, revised edition covers the essential fundamentals of data warehousing and business intelligence as well as significant recent trends in the field.
The author provides an enhanced, comprehensive overview of data warehousing together with in-depth explanations of critical issues in planning, design, deployment, and ongoing maintenance. IT professionals eager to get into the field will gain a clear understanding of techniques for data extraction from source systems, data cleansing, data transformations, data warehouse architecture and infrastructure, and the various methods for information delivery.
This practical Second Edition highlights the areas of data warehousing and business intelligence where high-impact technological progress has been made. Discussions on developments include data marts, real-time information delivery, data visualization, requirements gathering methods, multi-tier architecture, OLAP applications, Web clickstream analysis, data warehouse appliances, and data mining techniques. The book also contains review questions and exercises for each chapter, appropriate for self-study or classroom work, industry examples of real-world situations, and several appendices with valuable information.
Data warehousing has revolutionized the way businesses in a wide variety of industries perform analysis and make strategic decisions. Since the first edition of Data Warehousing Fundamentals, numerous enterprises have implemented data warehouse systems and reaped enormous benefits. Many more are in the process of doing so. Now, this new, revised edition covers the essential fundamentals of data warehousing and business intelligence as well as significant recent trends in the field.
The author provides an enhanced, comprehensive overview of data warehousing together with in-depth explanations of critical issues in planning, design, deployment, and ongoing maintenance. IT professionals eager to get into the field will gain a clear understanding of techniques for data extraction from source systems, data cleansing, data transformations, data warehouse architecture and infrastructure, and the various methods for information delivery.
This practical Second Edition highlights the areas of data warehousing and business intelligence where high-impact technological progress has been made. Discussions on developments include data marts, real-time information delivery, data visualization, requirements gathering methods, multi-tier architecture, OLAP applications, Web clickstream analysis, data warehouse appliances, and data mining techniques. The book also contains review questions and exercises for each chapter, appropriate for self-study or classroom work, industry examples of real-world situations, and several appendices with valuable information.
Features
New to This Edition
This second edition builds on areas in which significant technology progress has been made since the first edition. Developments are tracked in data marts, real-time information delivery, requirements gathering techniques, multi-tier architecture, OLAP models, clickstream data Webhouse, data mining techniques and applications, and data warehouse testing. Errors are corrected, and an answers section is added.
- Combines recent trends and data warehousing basics
- Cutting edge and field-savvy content/advice from expert
- Includes review questions and exercises
New to This Edition
This second edition builds on areas in which significant technology progress has been made since the first edition. Developments are tracked in data marts, real-time information delivery, requirements gathering techniques, multi-tier architecture, OLAP models, clickstream data Webhouse, data mining techniques and applications, and data warehouse testing. Errors are corrected, and an answers section is added.
Table of Contents
Part 1 OVERVIEW AND CONCEPTS
1 The Compelling Need for Data Warehousing
2 Data Warehouse: The Building Blocks
3 Trends in Data Warehousing
Part 2 PLANNING AND REQUIREMENTS
4 Planning and Project Management
5 Defining the Business Requirements
6 Requirements as the Driving Force for Data Warehousing
Part 3 ARCHITECTURE AND INFRASTRUCTURE
7 The Architectural Components
8 Infrastructure as the Foundation for Data Warehousing
9 The Significant Role of Metadata
Part 4 DATA DESIGN AND DATA PREPARATION
10 Principles of Dimensional Modeling
11 Dimensional Modeling: Advanced Topics
12 Data Extraction, Transformation, and Loading
13 Data Quality: A Key to Success
Part 5 INFORMATION ACCESS AND DELIVERY
14 Matching Information to the Classes of Users
15 OLAP in the Data Warehouse
16 Data Warehousing and the Web
17 Data Mining Basics
Part 6 IMPLEMENTATION AND MAINTENANCE
18 The Physical Design Process
19 Data Warehouse Deployment
20 Growth and Maintenance
Part 1 OVERVIEW AND CONCEPTS
1 The Compelling Need for Data Warehousing
2 Data Warehouse: The Building Blocks
3 Trends in Data Warehousing
Part 2 PLANNING AND REQUIREMENTS
4 Planning and Project Management
5 Defining the Business Requirements
6 Requirements as the Driving Force for Data Warehousing
Part 3 ARCHITECTURE AND INFRASTRUCTURE
7 The Architectural Components
8 Infrastructure as the Foundation for Data Warehousing
9 The Significant Role of Metadata
Part 4 DATA DESIGN AND DATA PREPARATION
10 Principles of Dimensional Modeling
11 Dimensional Modeling: Advanced Topics
12 Data Extraction, Transformation, and Loading
13 Data Quality: A Key to Success
Part 5 INFORMATION ACCESS AND DELIVERY
14 Matching Information to the Classes of Users
15 OLAP in the Data Warehouse
16 Data Warehousing and the Web
17 Data Mining Basics
Part 6 IMPLEMENTATION AND MAINTENANCE
18 The Physical Design Process
19 Data Warehouse Deployment
20 Growth and Maintenance
Paulraj Ponnian, PhD, with over thirty years of experience as an IT consultant, has worked with such organizations as Texaco, Sotheby’s Blue Cross/Blue Shield, NA Philips, New York-Presbyterian Hospital, Panasonic, and Bantam Doubleday Dell. He specializes in the design and Implementation of data warehouse and database systems. Dr. Ponniah has published three successful books and, as Adjunct Professor, continues to teach college courses in data warehousing and database design.