did-you-know? rent-now

Amazon no longer offers textbook rentals. We do!

did-you-know? rent-now

Amazon no longer offers textbook rentals. We do!

We're the #1 textbook rental company. Let us show you why.

9780470462072

Data Warehousing Fundamentals for IT Professionals

by
  • ISBN13:

    9780470462072

  • ISBN10:

    0470462078

  • Edition: 2nd
  • Format: Hardcover
  • Copyright: 2010-05-24
  • Publisher: Wiley

Note: Supplemental materials are not guaranteed with Rental or Used book purchases.

Purchase Benefits

  • Free Shipping Icon Free Shipping On Orders Over $35!
    Your order must be $35 or more to qualify for free economy shipping. Bulk sales, PO's, Marketplace items, eBooks and apparel do not qualify for this offer.
  • eCampus.com Logo Get Rewarded for Ordering Your Textbooks! Enroll Now
  • Write a Review Icon Write a Review
List Price: $157.95 Save up to $55.28
  • Rent Book $102.67
    Add to Cart Free Shipping Icon Free Shipping

    TERM
    PRICE
    DUE
    USUALLY SHIPS IN 24-48 HOURS
    *This item is part of an exclusive publisher rental program and requires an additional convenience fee. This fee will be reflected in the shopping cart.

Supplemental Materials

What is included with this book?

Summary

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. Data Warehousing Fundamentals not only explores important topics, like planning requirements, architecture, infrastructure, data preparation, and information delivery, but also the most up-to-date research on areas of technological improvements since the first edition. Additionally, Information Technologists will find expert advice, review questions, exercises, as well as an answer section are all included in this revised text.

Author Biography

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.

Table of Contents

Preface
Overview And Concepts
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
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
Trends in Data Warehousing
Chapter Objectives
Continued Growth in Data Warehousing
Data Warehousing has Become Mainstream
Data Warehouse Expansion
Vendor Solutions and Products
Significant Trends
Real-Time Data Warehousing
Multiple Data Types
Data Visualization
Emergence of Standards
Web-Enabled Data Warehouse
Chapter Summary
Review Questions
Exercises
Planning And Requirements
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
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
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
Architecture And Infrastructure
The Architectural Components
Chapter Objectives
Understanding Data Warehouse Architecture
Distinguishing Characteristics
Architectural Framework
Technical Architecture
Architectural Types
Chapter Summary
Review Questions
Exercises
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
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
Data Design And Data Preparation
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
Dimensional Modeling: Advanced Topics
Chapter Objectives
Updates to the Dimension Tables
Miscellaneous Dimensions
The Snowflake Schema
Aggregate Fact Tables
Families of STARS
Chapter Summary
Review Questions
Exercises
Data Extraction, Transformation, and Loading
Chapter Objectives
ETL Overview
Data Extraction
Data Transformation
Data Loading
ETL Summary
Other Integration Approaches
Chapter Summary
Review Questions
Exercises
Data Quality: A key to Success
Chapter Objectives
Why is Data Quality Critical?
Data Quality Challenges
Data Quality Tools
Data Quality Initiative
Master Data Management
Chapter Summary
Review Questions
Exercises
Information Access And Delivery
Matching Information to the Classes of Users
Chapter Objectives
Information from the Data Warehouse
Who Will Use the Information?
Information Delivery
Information Delivery Tools
Information Delivery: Special Topics
Chapter Summary
Review Questions
Exercises
OLAP in the Data Warehouse
Chapter Objectives
Demand for Online Analytical Processing
Major Features and Functions
OLAP Models
OLAP Implementation Considerations
Chapter Summary
Review Questions
Exercises
Data Warehousing and the Web
Chapter Objectives
Web-Enabled Data Warehouse
Web-Based Information Delivery
OLAP and the Web
Building a Web-Enabled Data Warehouse
Chapter Summary
Review Questions
Exercises
Data Mining Basics
Chapter Objectives
What is Data Mining?
Major Data Mining Techniques
Data Mining Applications
Chapter Summary
Review Questions
Exercises
Implementation And Maintenance
The Physical Design Process
Chapter Objectives
Physical Design Steps
Physical Design Considerations
Physical Storage
Indexing the Data Warehouse
Performance Enhancement Techniques
Chapter Summary
Review Questions
Exercises
Data Warehouse Deployment
Chapter Objectives
Data Warehouse Testing
Major Deployment Activities
Considerations for a Pilot
Security
Backup and Recovery
Chapter Summary
Review Questions
Exercises
Growth and Maintenance
Chapter Objectives
Monitoring the Data Warehouse
User Training and Support
Managing the Data Warehouse
Chapter Summary
Review Questions
Exercises
Answers to Selected Exercises
Project Life Cycle Steps and Checklists
Critical Factors for Success
Guidelines for Evaluating Vendor Solutions
Highlights of Vendors and Products
Real-World Examples of Best Practices
References
Glossary
Index
Table of Contents provided by Publisher. All Rights Reserved.

Supplemental Materials

What is included with this book?

The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any access cards, study guides, lab manuals, CDs, etc.

The Used, Rental and eBook copies of this book are not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.

Rewards Program