Data Management

Managing Operational Business Intelligence Workloads

Download Now Free registration required

Executive Summary

As data warehouses grow in size to petabytes and complex analytic queries play a greater role in day-to-day business operations, factors such as inaccurate cardinality estimates, data skew, and resource contention all make it notoriously difficult to predict how such queries will behave before they start executing. However, traditional workload management assumes that accurate expectations for the resource requirements and performance characteristics of a workload are available at compile-time, and relies on such information in order to make critical workload management decisions. This paper describes approach to dealing with inaccurate predictions.

  • Format: PDF
  • Size: 138.2 KB