Developing a Characterization of Business Intelligence Workloads for Sizing New Database Systems

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.