Abstract
While testing suspicious transactions that cause performance problems in a production database it is helpful to use a specialized tool that can simulate an increased workload. In the paper, we show the model and architecture of the DBPerfTester@UMAP stress testing application that allows the controlled execution of various SQL scripts from many workstations. It thus provides the possibility to test how the specified database behaves under a large pressure from concurrent transactions.DBPerfTester@UMAP is based on the UMAP multi-agent system, which allows the dynamic scalability and extensibility of the testing system. As an addition, we present sample tests of the chosen database management system while running a long transaction.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
References
Date, C.: An Introduction to Database Systems, 8th edn. Addison-Wesley (2003)
Delaney, K., Agarwal, S., Freedman, C., Talmage, R., Machanic, A.: Inside Microsoft SQL Server(TM) 2005: Query Tuning and Optimization, 1st edn. Microsoft Press (2007)
Ferber, J.: Multi-Agent System: An Introduction to Distributed Artificial Intelligence, 1st edn. Addison-Wesley Professional (1999)
Foundation for Intelligent Physical Agents : FIPA Abstract Architecture Specification, FIPA Standard, http://www.fipa.org/specs/fipa00001/ (accessed April 02, 2013)
Foundation for Intelligent Physical Agents : FIPA Agent Management Specification, FIPA Standard, http://www.fipa.org/specs/fipa00023/ (accessed April 02, 2013)
Foundation for Intelligent Physical Agents : FIPA Communicative Act Library Specification, FIPA Standard, http://www.fipa.org/specs/fipa00037/ (accessed April 02, 2013)
Foundation for Intelligent Physical Agents: FIPA Message Structure Specification, FIPA Standard, http://www.fipa.org/specs/fipa00061/ (accessed April 02, 2013)
Franklin, S., Graesser, A.: Is it an agent, or just a program?: A taxonomy for autonomous agents. In: Jennings, N.R., Wooldridge, M.J., Müller, J.P. (eds.) ECAI-WS 1996 and ATAL 1996. LNCS, vol. 1193, pp. 21–35. Springer, Heidelberg (1997)
Galanis, L., Buranawatanachoke, S., Colle, R., Dageville, B., Dias, K., Klein, J., Papadomanolakis, S., Tan, L.L., Venkataramani, V., Wang, Y., Wood, G.: Oracle Database Replay. In: Proceedings of the ACM SIGMOD International Conference on Management of Data (SIGMOD 2008), pp. 1159–1170. ACM (2008)
Gardikiotis, S.K., Lazarou, V.S., Malevris, N.: An agent-based approach for the maintenance of database applications. In: Proceedings of the 5th ACIS International Conference on Software Engineering Research, Management & Applications (SERA 2007), pp. 558–568. IEEE (2007)
Gardikiotis, S.K., Lazarou, V.S., Malevris, N.: Employing agents towards database applications testing. In: Proceedings of the 19th IEEE International Conference on Tools with Artificial Intelligence (ICTAI 2007), vol. 1, pp. 173–180. IEEE (2007)
Kumova, B.Y.: Dynamic re-configurable transaction management in agentteam. In: Proceedings of the 9th Euromicro Workshop on Parallel and Distributed Processing, pp. 258–264. IEEE (2001)
Microsoft: SQL Server Distributed Replay, SQL Server 2012 Books Online, Quick Reference (2012), http://msdn.microsoft.com/en-us/library/ff878183.aspx (accessed June 07, 2013)
Nambiar, R., Poess, M., Masland, A., Taheri, H.R., Emmerton, M., Carman, F., Majdalany, M.: TPC benchmark roadmap 2012. In: Nambiar, R., Poess, M. (eds.) TPCTC 2012. LNCS, vol. 7755, pp. 1–20. Springer, Heidelberg (2013)
Transaction Processing Performance Council: TPC-C/App/E BENCHMARKTM Standard Specification, http://www.tpc.org (accessed June 07, 2013)
Waligóra, I., Małysiak-Mrozek, B., Mrozek, D.: UMAP Universal Multi-Agent Platform. Studia Informatica 31(2A(89)), 85–100 (2010)
Wooldridge, M.: An Introduction to Multiagent Systems, 2nd edn. John Wiley & Sons (2009)
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2014 Springer International Publishing Switzerland
About this paper
Cite this paper
Mrozek, D., Małysiak-Mrozek, B., Mikołajczyk, J., Kozielski, S. (2014). Database Under Pressure – Testing Performance of Database Systems Using Universal Multi-Agent Platform. In: Gruca, D., Czachórski, T., Kozielski, S. (eds) Man-Machine Interactions 3. Advances in Intelligent Systems and Computing, vol 242. Springer, Cham. https://doi.org/10.1007/978-3-319-02309-0_68
Download citation
DOI: https://doi.org/10.1007/978-3-319-02309-0_68
Publisher Name: Springer, Cham
Print ISBN: 978-3-319-02308-3
Online ISBN: 978-3-319-02309-0
eBook Packages: EngineeringEngineering (R0)