For Business Process & Applications Professionals

Primary Analyst Photo	Document Information	Rate this Document
	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	Average: 10  (2 ratings)

This is an excerpt

Executive Summary

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.

TABLE OF CONTENTS

• Information Tsunami: Putting Pressure On The Enterprise Data Warehouse
• Best Practices: EDW Scaling, Acceleration, And Performance Optimization
• EDW Scaling Best Practice No. 1: Scale Your EDW Through Parallelism
• EDW Scaling Best Practice No. 2: Accelerate Your EDW With Appliances
• EDW Scaling Best Practice No. 3: Optimize Your EDW's Distributed Storage Layer
• EDW Scaling Best Practice No. 4: Retune And Rebalance Workloads
• Forrester's EDW Scaling Next Practices
• Case Studies
• Supplemental Material
• Related Research Documents

This is an excerpt