TY - GEN
T1 - Database under pressure – testing performance of database systems using universal multi-agent platform
AU - Mrozek, Dariusz
AU - Małysiak-Mrozek, Bożena
AU - Mikołajczyk, Jakub
AU - Kozielski, Stanisław
N1 - Publisher Copyright:
© Springer International Publishing Switzerland 2014.
PY - 2014
Y1 - 2014
N2 - 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 frommanyworkstations. 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 UMAPmulti-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.
AB - 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 frommanyworkstations. 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 UMAPmulti-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.
KW - Database workload replay
KW - Database workload simulation
KW - Databases
KW - Multi-agent system
KW - Performance
KW - Stress testing
UR - https://www.scopus.com/pages/publications/84903489189
U2 - 10.1007/978-3-319-02309-0_68
DO - 10.1007/978-3-319-02309-0_68
M3 - Conference contribution
AN - SCOPUS:84903489189
T3 - Advances in Intelligent Systems and Computing
SP - 631
EP - 641
BT - Man-Machine Interactions 3
A2 - Gruca, Aleksandra
A2 - Czachórski, Tadeusz
A2 - Kozielski, Stanisław
A2 - Czachórski, Tadeusz
PB - Springer Verlag
T2 - 3rd International Conference on Man-Machine Interactions, ICMMI 2013
Y2 - 22 October 2013 through 25 October 2013
ER -