Developing a characterization of business intelligence workloads for sizing new database systems
TJ Wasserman, P Martin, DB Skillicorn… - Proceedings of the 7th …, 2004 - dl.acm.org
TJ Wasserman, P Martin, DB Skillicorn, H Rizvi
Proceedings of the 7th ACM International Workshop on Data Warehousing and OLAP, 2004•dl.acm.orgComputer 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 …
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 …
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.
ACM Digital Library