Data Warehousing Fundamentals for IT Professionals

ISBN-10: 0470462078
ISBN-13: 9780470462072
Edition: 2nd 2010
Authors: Paulraj Ponniah
List price: $94.95 Buy it from $21.05 Rent it from $22.60
eBook available
This item qualifies for FREE shipping

*A minimum purchase of $35 is required. Shipping is provided via FedEx SmartPost® and FedEx Express Saver®. Average delivery time is 1 – 5 business days, but is not guaranteed in that timeframe. Also allow 1 - 2 days for processing. Free shipping is eligible only in the continental United States and excludes Hawaii, Alaska and Puerto Rico. FedEx service marks used by permission."Marketplace" orders are not eligible for free or discounted shipping.

30 day, 100% satisfaction guarantee

If an item you ordered from TextbookRush does not meet your expectations due to an error on our part, simply fill out a return request and then return it by mail within 30 days of ordering it for a full refund of item cost.

Learn more about our returns policy

Description: 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,  More...

Used Starting from $88.53
New Starting from $58.30
Rent Starting from $22.60
eBooks Starting from $76.50
Rent
Buy
what's this?
Rush Rewards U
Members Receive:
coins
coins
You have reached 400 XP and carrot coins. That is the daily max!
You could win $10,000

Get an entry for every item you buy, rent, or sell.

Study Briefs

Limited time offer: Get the first one free! (?)

All the information you need in one place! Each Study Brief is a summary of one specific subject; facts, figures, and explanations to help you learn faster.

Add to cart
Study Briefs
Periodic Table Online content $4.95 $1.99
Add to cart
Study Briefs
SQL Online content $4.95 $1.99
Add to cart
Study Briefs
MS Excel® 2010 Online content $4.95 $1.99
Add to cart
Study Briefs
MS Word® 2010 Online content $4.95 $1.99

Customers also bought

Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading

Book details

List price: $94.95
Edition: 2nd
Copyright year: 2010
Publisher: John Wiley & Sons, Limited
Publication date: 6/11/2010
Binding: Hardcover
Pages: 600
Size: 7.25" wide x 10.25" long x 1.00" tall
Weight: 2.904
Language: English

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.

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

×
Free shipping on orders over $35*

*A minimum purchase of $35 is required. Shipping is provided via FedEx SmartPost® and FedEx Express Saver®. Average delivery time is 1 – 5 business days, but is not guaranteed in that timeframe. Also allow 1 - 2 days for processing. Free shipping is eligible only in the continental United States and excludes Hawaii, Alaska and Puerto Rico. FedEx service marks used by permission."Marketplace" orders are not eligible for free or discounted shipping.

Learn more about the TextbookRush Marketplace.

×