Paper Info
Title
Managing dynamic mixed workloads for operational business intelligence
Abstract
As data warehousing technology gains a ubiquitous presence in business today, companies are becoming increasingly reliant upon the information contained in their data warehouses to inform their operational decisions. This information, known as business intelligence (BI), traditionally has taken the form of nightly or monthly reports and batched analytical queries that are run at specific times of day. However, as the time needed for data to migrate into data warehouses has decreased, and as the amount of data stored has increased, business intelligence has come to include metrics, streaming analysis, and reports with expected delivery times that are measured in hours, minutes, or seconds. The challenge is that in order to meet the necessary response times for these operational business intelligence queries, a given warehouse must be able to support at any given time multiple types of queries, possibly with different sets of performance objectives for each type. In this paper, we discuss why these dynamic mixed workloads make workload management for operational business intelligence (BI) databases so challenging, review current and proposed attempts to address these challenges, and describe our own approach. We have carried out an extensive set of experiments, and report on a few of our results.
Year
DOI
Venue
2010
10.1007/978-3-642-12038-1_2
DNIS
Keywords
Field
DocType
difference set,data warehousing,business intelligence,data warehouse
Data warehouse,Query optimization,Data mining,Business analytics,Admission control,Computer science,Business intelligence,Workload management,Database,Query plan,Business activity monitoring
Conference
Volume
ISSN
ISBN
5999
0302-9743
3-642-12037-7
Citations 
PageRank 
References 
7
0.47
27
Authors
6
Name
Order
Citations
PageRank
Harumi Kuno129721.62
Umeshwar Dayal284522538.92
Janet L. Wiener33813600.46
Kevin Wilkinson470.47
Archana Ganapathi586054.96
Stefan Krompass618413.15