For Business Process & Applications Professionals (Length: 28 pages)

June 3, 2009

Massive But Agile: Best Practices For Scaling The Next-Generation Enterprise Data Warehouse

by James G. Kobielus

with Boris Evelson, Noel Yuhanna, Charles Coit


Executive Summary (This is a document excerpt)

Information and knowledge management (I&KM) professionals continue to expand the scale, scope, and deployment roles for their enterprise data warehouse (EDW) investments. Today's most demanding EDW environments support petabytes of aggregated data, trillions of records, thousands of concurrent users and queries, complex mixed-query workloads, subsecond latencies, and continuous, high-volume data loading. Information managers are adopting EDW best practices that push the scalability and performance envelope without sacrificing the agility to optimize this critical infrastructure to ever-changing analytic workloads. Some key best practices involve deploying 64-bit multicore EDW processing nodes, scaling out through shared-nothing massively parallel processing (MPP), pushing query processing to grid-enabled intelligent storage layers, applying efficient compression in the storage layer, and deploying preconfigured high-end EDW appliances.

Buy Risk-Free

Download and print PDF immediately. Price: US $499

Our Money-Back Guarantee: If you are not completely satisfied, return it for a full refund within three weeks of your online purchase.

Already a Forrester Client?
Log in to read this document.

Add to cart

TABLE OF CONTENTS

NOTES & RESOURCES

itemInformation Tsunami: Putting Pressure On The Enterprise Data Warehouse

itemBest Practices: EDW Scaling, Acceleration, And Performance Optimization

itemEDW Scaling Best Practice No. 1: Scale Your EDW Through Parallelism

itemEDW Scaling Best Practice No. 2: Accelerate Your EDW With Appliances

itemEDW Scaling Best Practice No. 3: Optimize Your EDW's Distributed Storage Layer

itemEDW Scaling Best Practice No. 4: Retune And Rebalance Workloads

itemForrester's EDW Scaling Next Practices

itemCase Studies

itemSupplemental Material

Forrester interviewed the following vendor companies for this report: Aster Data Systems, Greenplum, IBM, Infobright, Kognitio, Microsoft, Netezza, Oracle, ParAccel, SAP, Sybase, and Teradata. To create case studies, Forrester interviewed the following user companies in several verticals: CVS Caremark (retailing/prescription benefits management), LGR Telecommunications (hosted telecommunications analytics processing), Merkle (hosted database marketing service provider), MySpace (Web 2.0 social networking), and NYSE Euronext (securities trading exchanges).

Related Research Documents

itemThe Forrester Wave™: Enterprise Data Warehousing Platforms, Q1 2009

February 6, 2009

itemForrester's Business Intelligence Data Architecture Decision Tool

January 12, 2009

Find Documents In Related Categories

This document falls under the following categories. Click on a link below to find similar documents.

Analyst: James G. Kobielus
Technology: Data Warehousing, Information & Knowledge Management, Telecommunications Services
Industry: Financial Services, Healthcare & Life Sciences, Pharmaceuticals & Biotechnology, Professional Services, Retail
Geography: Global, North America

Archived Teleconference:
corner border corner
Ratings and Comments
Rating: 10 out of 10
based on 2 ratings across all roles.
corner border corner