ABSTRACT
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.
- W. M. P. van der Aalst et al, Workflow Control-flow Patterns A Revised View, Technical Report BPM-06-22, BPM Center Report, 2006, www.workflowpatterns.com.Google Scholar
- W. M. P. van der Aalst et al, Workflow mining: A survey of issues and approaches, Data & Knowledge Engineering, 47, 2 (November 2003), 237--267. Google ScholarDigital Library
- P. Belknap et al, Oracle Real Application Testing, in Proceedings of the 1st international workshop on Testing database systems (DBTest2008) (Vancouver, British Columbia, Canada, Jun. 2008) ACM Press, New York, NY, 2008, 1--6. Google ScholarDigital Library
- L. Galanis et al, Oracle Database Replay, in Proceedings of the 2008 ACM SIGMOD international conference Management of data. (SIGMOD'08), (Vancouver, BC, Canada June 9--12, 2008). ACM Press, New York, NY, 2008, 1159--1170. Google ScholarDigital Library
- L. K. John, P. Vasudevan and J. Sabarinathan, Workload characterization: motivation, goals and methodology, in Proceedings of Workload Characterization: Methodology and Case Studies (Dallas, TX, USA 29, Nov., 1998), 3--14 Google ScholarDigital Library
- D. A. Menasce et al, A methodology for workload characterization of e-commerce sites, in Proceedings of the 1st ACM conference Electronic commerce,(EC99) (Denver, CO, USA, November 3--5, 1999). ACM Press, New York, NY, 1999, 119--128. Google ScholarDigital Library
- R. O. do Nascimento, M. Wong, and P. R. M. Maciel: DBT-5: A Fair Usage Open-Source TPC-E Implementation for Performance Evaluation of Computer Systems. In XXVII Brazilian Computer Society Conference, 2007.Google Scholar
- L. Quan, X. Z. Lin, and J. M. Wang An Automatic and Scalable Testing Tool for Workflow Systems, in Proceedings of The 3rd International Conference on Grid and Pervasive Computing Workshops (WaGe08) (Kunming, China, May 25--28, 2008) IEEE Computer Society Press, NW Washington, DC USA, 75--80. Google ScholarDigital Library
- C. Stewart, T. Kelly, and A. Zhang, Exploiting Nonstationarity for Performance Prediction, in ACM SIGOPS Operating Systems Review (EuroSys'07), (Lisboa, Portugal, March 21--23, 2007). ACM Press, New York, NY, 2007, 31--44. Google ScholarDigital Library
- L. J. Wen, J. M. Wang, and J. G. Sun, Mining Invisible Tasks from Event Logs, Advances in Data and Web Management, Volume 4505/2007, Springer Berlin/Heidelberg Press 2007, 358--365. Google ScholarDigital Library
- J. M. Xie et al, A Configurable Web Service Performance Testing Framework, in the 10th International Conferences on High Performance Computing and Communications. (HPCC'08), (Dalian, China, Sep. 2008) IEEE Computer Society Press, NW Washington, DC USA, 312--319. Google ScholarDigital Library
- Q. S. Yao, A. An, and X. J. Huang, Mining and Modeling Database User Access Patterns, in Foundations of Intelligent Systems, (ISMIS 2006, LNAI 4203) (Bari, September 27--29) Springer Berlin / Heidelberg Press 2006, 493--503. Google ScholarDigital Library
- Transaction Process Council, TPC BENCHMARK SUITE, http://www.tpc.org/.Google Scholar
Index Terms
- Towards workflow-driven database system workload modeling
Recommendations
Towards a universal construction for transaction-based multiprocess programs
The aim of a Software Transactional Memory (STM) system is to discharge the programmer from the explicit management of synchronization issues. The programmer's job resides in the design of multiprocess programs in which processes are made up of ...
The Grid Resource Broker workflow engine
2nd International Workshop on Workflow Management and Applications in Grid Environments (WaGe2007)Increasingly, complex scientific applications are structured in terms of workflows. These applications are usually computationally and-or data intensive and thus are well suited for execution in grid environments. Distributed, geographically spread ...
A Dependence-Based Transaction Model in Workflow
IIS '09: Proceedings of the 2009 International Conference on Industrial and Information SystemsTransaction management is introduced into the web service-based workflow of dynamic virtual enterprise. Based on the research of the present status and characteristic of long transaction model in workflow system, we find the Sagas model does not support ...
Comments