DATA WAREHOUSING FUNDAMENTALS FOR - COMPREHENSIVE GUIDE FOR IT PROFESS

Zusatztext ".......clearly the author is a long-time practitioner and expert in this area. And if this were not enough! the language is clear and precise! and the associated content is easily internalised." (BCS! August 2010) Informationen zum Autor PAULRAJ PONNIAH, 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. Klappentext Cutting-edge content and guidance from a data warehousing expert--now expanded to reflect field trendsData 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.Specifically written for professionals responsible for designing, implementing, or maintaining data warehousing systems, Data Warehousing Fundamentals presents agile, thorough, and systematic development principles for the IT professional and anyone working or researching in information management. Zusammenfassung Since the first edition of Data Warehousing Fundamentals, there has been an increase in enterprises either already having or in the process of obtaining the data warehousing programs. Inhaltsverzeichnis Preface xxv Part 1 Overview and Concepts 1 1 The Compelling Need For Data Warehousing 3 Chapter Objectives 3 Escalating Need For Strategic Information 4 Failures of Past Decision-Support Systems 9 Operational Versus Decision-Support Systems 11 Data Warehousing-The Only Viable Solution 13 A Simple Concept For Information Delivery 15 The Data Warehousing Movement 17 Evolution of Business Intelligence 18 Chapter Summary 20 Review Questions 20 Exercises 21 2 Data Warehouse: The Building Blocks 23 Chapter Objectives 23 Defining Features 24 Data Warehouses and Data Marts 29 Architectural Types 32 Overview of The Components 34 Metadata in The Data Warehouse 41 Chapter Summary 42 Review Questions 43 Exercises 43 3 Trends in Data Warehousing 45 Chapter Objectives 45 Continued Grow...

Sommario

Preface.
 
Part 1 OVERVIEW AND CONCEPTS.
 
1 The Compelling Need for Data Warehousing.
 
Chapter Objectives.
 
Escalating Need for Strategic Information.
 
Failures of Past Decision Support Systems.
 
Operational Versus Decision-Support Systems.
 
Data Warehousing--The Only Viable Solution.
 
Data Warehouse Defined.
 
The Data Warehousing Movement.
 
Evolution of Business Intelligence.
 
Chapter Summary.
 
Review Questions.
 
Exercises.
 
2 Data Warehouse: The Building Blocks.
 
Chapter Objectives.
 
Defining Features.
 
Data Warehouses and Data Marts.
 
Architectural Types.
 
Overview of Components.
 
Metadata in the Data Warehouse.
 
Chapter Summary.
 
Review Questions.
 
Exercises.
 
3 Trends in Data Warehousing.
 
Chapter Objectives.
 
Continued Growth in Data Warehousing.
 
Vendor Solutions and Products.
 
Significant Trends.
 
Emergence of Standards.
 
Web-Enabled Data Warehouse.
 
Chapter Summary.
 
Review Questions.
 
Exercises.
 
Part 2 PLANNING AND REQUIREMENTS.
 
4 Planning and Project Management.
 
Chapter Objectives.
 
Planning Your Data Warehouse.
 
The Data Warehouse Project.
 
The Project Team.
 
Project Management Considerations.
 
Chapter Summary.
 
Review Questions.
 
Exercises.
 
5 Defining the Business Requirements.
 
Chapter Objectives.
 
Dimensional Analysis.
 
Information Packages--A Useful Concept.
 
Requirements Gathering Methods.
 
Requirements Definition: Scope and Content.
 
Chapter Summary.
 
Review Questions.
 
Exercises.
 
6 Requirements as the Driving Force for Data Warehousing.
 
Chapter Objectives.
 
Data Design.
 
The Architectural Plan.
 
Data Storage Specifications.
 
Information Delivery Strategy.
 
Chapter Summary.
 
Review Questions.
 
Exercises.
 
Part 3 ARCHITECTURE AND INFRASTRUCTURE.
 
7 The Architectural Components.
 
Chapter Objectives.
 
Understanding Data Warehouse Architecture.
 
Distinguishing Characteristics.
 
Architectural Framework.
 
Technical Architecture.
 
Architectural Types.
 
Chapter Summary.
 
Review Questions.
 
Exercises.
 
8 Infrastructure as the Foundation for Data Warehousing.
 
Chapter Objectives.
 
Infrastructure Supporting Architecture.
 
Hardware and Operating Systems.
 
Database Software.
 
Collection of Tools.
 
Data Warehouse Appliances.
 
Chapter Summary.
 
Review Questions.
 
Exercises.
 
9 The Significant Role of Metadata.
 
Chapter Objectives.
 
Why Metadata is Important.
 
Metadata Types by Functional Areas.
 
Business Metadata.
 
Technical Metadata.
 
How to Provide Metadata.
 
Chapter Summary.
 
Review Questions.
 
Exercises.
 
Part 4 DATA DESIGN AND DATA PREPARATION.
 
10 Principles of Dimensional Modeling.
 
Chapter Objectives.
 
From Requirements to Data Design.
 
The STAR Schema.
 
STAR Schema Keys.
 
Advantages of the STAR Schema.
 
STAR Schema: Examples.
 
Chapter Summary.
 
Review Questions.
 
Exercises.
 
11 Dimensio

Relazione

".......clearly the author is a long-time practitioner and expert in this area. And if this were not enough, the language is clear and precise, and the associated content is easily internalised." (BCS, August 2010)

Dettagli sul prodotto

• Autori: Ponniah, P Ponniah, Paulraj Ponniah, Paulraj (Consultant) Ponniah, Ponniah Paulraj
• Editore: Wiley, John and Sons Ltd
• Lingue: Inglese
• Formato: Copertina rigida
• Pubblicazione: 11.06.2010
• EAN: 9780470462072
• ISBN: 978-0-470-46207-2
• Pagine: 600
• Serie: Fundamentals for IT Professionals; Fundamentals for IT Professionals
• Categorie: Guide e manuali; Scienze naturali, medicina, informatica, tecnica > Informatica, EDP > Informatica; Informatik, Data Warehouse, computer science, Database & Data Warehousing Technologies, Datenbanken u. Data Warehousing