Towards workflow-driven database system workload modeling

Transaction relationships are usually ignored in current OLTP workload modeling and benchmark test system implementation. In this paper, two workflow driven models for real system workloads are proposed, one using Markov process, and the other Petri-net. Algorithms are also provided to keep the consistence between high-level semantic (workflow) and low level transaction mixing ratio in OLTP performance benchmarks. The experimental results have validated our approach.

[1]  Bin Li,et al.  A Configurable Web Service Performance Testing Framework , 2008, 2008 10th IEEE International Conference on High Performance Computing and Communications.

[2]  Jianmin Wang,et al.  Mining Invisible Tasks from Event Logs , 2007, APWeb/WAIM.

[3]  Boudewijn F. van Dongen,et al.  Workflow mining: A survey of issues and approaches , 2003, Data Knowl. Eng..

[4]  Jianmin Wang,et al.  An Automatic and Scalable Testing Tool for Workflow Systems , 2008, 2008 The 3rd International Conference on Grid and Pervasive Computing - Workshops.

[5]  Graham Wood,et al.  Oracle real application testing , 2008, DBTest '08.

[6]  Lizy K. John,et al.  Workload characterization: motivation, goals and methodology , 1998, Workload Characterization: Methodology and Case Studies. Based on the First Workshop on Workload Characterization.

[7]  Virgílio A. F. Almeida,et al.  A methodology for workload characterization of E-commerce sites , 1999, EC '99.

[8]  Christopher Stewart,et al.  Exploiting nonstationarity for performance prediction , 2007, EuroSys '07.

[9]  van der Wmp Wil Aalst,et al.  Workflow control-flow patterns : a revised view , 2006 .

[10]  Xiangji Huang,et al.  Mining and Modeling Database User Access Patterns , 2006, ISMIS.

[11]  Rilson O. do Nascimento,et al.  DBT-5: A Fair Usage Open-Source TPC-E Implementation for Performance Evaluation of Computer Systems , 2007 .