Developing a characterization of business intelligence workloads for sizing new database systems

Authors:
Ted J. Wasserman;Patrick Martin;David B. Skillicorn;Haider Rizvi
Affiliations:
Queen's University, Kingston, Ontario, Canada;Queen's University, Kingston, Ontario, Canada;Queen's University, Kingston, Ontario, Canada;IBM Toronto Laboratory, Markham, Ontario, Canada
Venue:
Proceedings of the 7th ACM international workshop on Data warehousing and OLAP
Year:
2004

Citing 8
Cited 4

Computer capacity planning: theory and practice

Computer capacity planning: theory and practice
Capacity planning and performance modeling: from mainframes to client-server systems

Capacity planning and performance modeling: from mainframes to client-server systems
Construction and use of multiclass workload models

Performance Evaluation
Query clustering using user logs

ACM Transactions on Information Systems (TOIS)
Supporting capacity planning for DB2 UDB

CASCON '02 Proceedings of the 2002 conference of the Centre for Advanced Studies on Collaborative research
The workload you have, the workload you would like

DOLAP '03 Proceedings of the 6th ACM international workshop on Data warehousing and OLAP
Sizing DB2 UDB® servers for business intelligence workloads

CASCON '04 Proceedings of the 2004 conference of the Centre for Advanced Studies on Collaborative research
Plan selection based on query clustering

VLDB '02 Proceedings of the 28th international conference on Very Large Data Bases

Storage workload estimation for database management systems

Proceedings of the 2007 ACM SIGMOD international conference on Management of data
Application-aware cross-layer virtual machine resource management

Proceedings of the 9th international conference on Autonomic computing
Surveying the landscape: an in-depth analysis of spatial database workloads

Proceedings of the 20th International Conference on Advances in Geographic Information Systems
Towards predicting query execution time for concurrent and dynamic database workloads

Proceedings of the VLDB Endowment

Quantified Score

Hi-index	0.00

Visualization

Abstract

Computer system sizing involves estimating the amount of hardware resources needed to support a new workload not yet deployed in a production environment. In order to determine the type and quantity of resources required, a methodology is required for describing the new workload. In this paper, we discuss the sizing process for database management systems and describe an analysis for characterizing business intelligence (BI) workloads, using the TPC-H benchmark as our workload basis. The characterization yields four general classes of queries, each with different characteristics. Our approach for sizing a BI application's database tier quantifies a new BI workload in terms of the response time goals and mix of the different query classes obtained from the characterization analysis.