CART

(0) items

Data Warehousing Fundamentals for IT Professionals,9780470462072
This item qualifies for
FREE SHIPPING!

FREE SHIPPING OVER $59!

Your order must be $59 or more, you must select US Postal Service Shipping as your shipping preference, and the "Group my items into as few shipments as possible" option when you place your order.

Bulk sales, PO's, Marketplace Items, eBooks, Apparel, and DVDs not included.

Data Warehousing Fundamentals for IT Professionals

by
Edition:
2nd
ISBN13:

9780470462072

ISBN10:
0470462078
Format:
Hardcover
Pub. Date:
5/24/2010
Publisher(s):
Wiley
List Price: $146.13

Rent Textbook

(Recommended)
 
Term
Due
Price
$87.68

Buy New Textbook

Currently Available, Usually Ships in 24-48 Hours
N9780470462072
$139.82

eTextbook


 
Duration
Price
$91.80

Used Textbook

We're Sorry
Sold Out

More New and Used
from Private Sellers
Starting at $22.98
See Prices

Questions About This Book?

Why should I rent this book?
Renting is easy, fast, and cheap! Renting from eCampus.com can save you hundreds of dollars compared to the cost of new or used books each semester. At the end of the semester, simply ship the book back to us with a free UPS shipping label! No need to worry about selling it back.
How do rental returns work?
Returning books is as easy as possible. As your rental due date approaches, we will email you several courtesy reminders. When you are ready to return, you can print a free UPS shipping label from our website at any time. Then, just return the book to your UPS driver or any staffed UPS location. You can even use the same box we shipped it in!
What version or edition is this?
This is the 2nd edition with a publication date of 5/24/2010.
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 CDs, lab manuals, study guides, etc.
  • The Rental copy of this book is not guaranteed to include any supplemental materials. You may receive a brand new copy, but typically, only the book itself.

Related Products


  • Data Warehousing Fundamentals : A Comprehensive Guide for IT Professionals
    Data Warehousing Fundamentals : A Comprehensive Guide for IT Professionals




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.


Please wait while the item is added to your cart...