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

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. Categories and Subject Descriptors H.2.8 [Database Management]: Database Applications – Data mining H.2.0 [Database Management]: General General Terms Design, Experimentation, Performance Keywords Workl...

• Type: Conference
• Year: 2004
• Where: DOLAP
• Authors: Ted J. Wasserman, Patrick Martin, David B. Skillicorn, Haider Rizvi
• Keywords: Database Management, DOLAP 2004, Information Management, Sizing, Workload