Advertisement

Database Under Pressure – Testing Performance of Database Systems Using Universal Multi-Agent Platform

  • Dariusz Mrozek
  • Bożena Małysiak-Mrozek
  • Jakub Mikołajczyk
  • Stanisław Kozielski
Part of the Advances in Intelligent Systems and Computing book series (AISC, volume 242)

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.

Keywords

databases performance stress testing database workload simulation database workload replay multi-agent system 

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. 1.
    Date, C.: An Introduction to Database Systems, 8th edn. Addison-Wesley (2003)Google Scholar
  2. 2.
    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)Google Scholar
  3. 3.
    Ferber, J.: Multi-Agent System: An Introduction to Distributed Artificial Intelligence, 1st edn. Addison-Wesley Professional (1999)Google Scholar
  4. 4.
    Foundation for Intelligent Physical Agents : FIPA Abstract Architecture Specification, FIPA Standard, http://www.fipa.org/specs/fipa00001/ (accessed April 02, 2013)
  5. 5.
    Foundation for Intelligent Physical Agents : FIPA Agent Management Specification, FIPA Standard, http://www.fipa.org/specs/fipa00023/ (accessed April 02, 2013)
  6. 6.
    Foundation for Intelligent Physical Agents : FIPA Communicative Act Library Specification, FIPA Standard, http://www.fipa.org/specs/fipa00037/ (accessed April 02, 2013)
  7. 7.
    Foundation for Intelligent Physical Agents: FIPA Message Structure Specification, FIPA Standard, http://www.fipa.org/specs/fipa00061/ (accessed April 02, 2013)
  8. 8.
    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)Google Scholar
  9. 9.
    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)Google Scholar
  10. 10.
    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)Google Scholar
  11. 11.
    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)Google Scholar
  12. 12.
    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)Google Scholar
  13. 13.
    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)
  14. 14.
    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)Google Scholar
  15. 15.
    Transaction Processing Performance Council: TPC-C/App/E BENCHMARKTM Standard Specification, http://www.tpc.org (accessed June 07, 2013)
  16. 16.
    Waligóra, I., Małysiak-Mrozek, B., Mrozek, D.: UMAP Universal Multi-Agent Platform. Studia Informatica 31(2A(89)), 85–100 (2010)Google Scholar
  17. 17.
    Wooldridge, M.: An Introduction to Multiagent Systems, 2nd edn. John Wiley & Sons (2009)Google Scholar

Copyright information

© Springer International Publishing Switzerland 2014

Authors and Affiliations

  • Dariusz Mrozek
    • 1
  • Bożena Małysiak-Mrozek
    • 1
  • Jakub Mikołajczyk
    • 1
  • Stanisław Kozielski
    • 1
  1. 1.Institute of InformaticsSilesian University of TechnologyGliwicePoland

Personalised recommendations