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

doi:10.1007/978-3-319-02309-0_68

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

Silesian University of Technology

Research output: Chapter in Book/Report/Conference proceeding › Conference contribution › peer-review

3 Citations (Scopus)

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 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.

Original language	English
Title of host publication	Man-Machine Interactions 3
Editors	Aleksandra Gruca, Tadeusz Czachórski, Stanisław Kozielski, Tadeusz Czachórski
Publisher	Springer Verlag
Pages	631-641
Number of pages	11
ISBN (Electronic)	9783319023083
DOIs	https://doi.org/10.1007/978-3-319-02309-0_68
Publication status	Published - 2014
Event	3rd International Conference on Man-Machine Interactions, ICMMI 2013 - Brenna, Poland Duration: 22 Oct 2013 → 25 Oct 2013

Publication series

Name	Advances in Intelligent Systems and Computing
Volume	242
ISSN (Print)	2194-5357

Conference

Conference	3rd International Conference on Man-Machine Interactions, ICMMI 2013
Country/Territory	Poland
City	Brenna
Period	22/10/13 → 25/10/13

Keywords

Database workload replay
Database workload simulation
Databases
Multi-agent system
Performance
Stress testing

ASJC Scopus subject areas

Control and Systems Engineering
General Computer Science

Access to Document

10.1007/978-3-319-02309-0_68

Cite this

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 A. Gruca, T. Czachórski, S. Kozielski, & T. Czachórski (Eds.), Man-Machine Interactions 3 (pp. 631-641). (Advances in Intelligent Systems and Computing; Vol. 242). Springer Verlag. https://doi.org/10.1007/978-3-319-02309-0_68

Mrozek, Dariusz ; Małysiak-Mrozek, Bożena ; Mikołajczyk, Jakub et al. / Database under pressure – testing performance of database systems using universal multi-agent platform. Man-Machine Interactions 3. editor / Aleksandra Gruca ; Tadeusz Czachórski ; Stanisław Kozielski ; Tadeusz Czachórski. Springer Verlag, 2014. pp. 631-641 (Advances in Intelligent Systems and Computing).

@inproceedings{62c0291c17d14d2fb85d99896b82c8c5,

title = "Database under pressure {\textendash} testing performance of database systems using universal multi-agent platform",

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 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.",

keywords = "Database workload replay, Database workload simulation, Databases, Multi-agent system, Performance, Stress testing",

author = "Dariusz Mrozek and Bo{\.z}ena Ma{\l}ysiak-Mrozek and Jakub Miko{\l}ajczyk and Stanis{\l}aw Kozielski",

note = "Publisher Copyright: {\textcopyright} Springer International Publishing Switzerland 2014.; 3rd International Conference on Man-Machine Interactions, ICMMI 2013 ; Conference date: 22-10-2013 Through 25-10-2013",

year = "2014",

doi = "10.1007/978-3-319-02309-0\_68",

language = "English",

series = "Advances in Intelligent Systems and Computing",

publisher = "Springer Verlag",

pages = "631--641",

editor = "Aleksandra Gruca and Tadeusz Czach{\'o}rski and Stanis{\l}aw Kozielski and Tadeusz Czach{\'o}rski",

booktitle = "Man-Machine Interactions 3",

address = "Germany",

}

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 A Gruca, T Czachórski, S Kozielski & T Czachórski (eds), Man-Machine Interactions 3. Advances in Intelligent Systems and Computing, vol. 242, Springer Verlag, pp. 631-641, 3rd International Conference on Man-Machine Interactions, ICMMI 2013, Brenna, Poland, 22/10/13. https://doi.org/10.1007/978-3-319-02309-0_68

Database under pressure – testing performance of database systems using universal multi-agent platform. / Mrozek, Dariusz ; Małysiak-Mrozek, Bożena; Mikołajczyk, Jakub et al.
Man-Machine Interactions 3. ed. / Aleksandra Gruca; Tadeusz Czachórski; Stanisław Kozielski; Tadeusz Czachórski. Springer Verlag, 2014. p. 631-641 (Advances in Intelligent Systems and Computing; Vol. 242).

Research output: Chapter in Book/Report/Conference proceeding › Conference contribution › peer-review

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 -

Mrozek D , Małysiak-Mrozek B, Mikołajczyk J, Kozielski S. Database under pressure – testing performance of database systems using universal multi-agent platform. In Gruca A, Czachórski T, Kozielski S, Czachórski T, editors, Man-Machine Interactions 3. Springer Verlag. 2014. p. 631-641. (Advances in Intelligent Systems and Computing). doi: 10.1007/978-3-319-02309-0_68

Database under pressure – testing performance of database systems using universal multi-agent platform

Abstract

Publication series

Conference

Keywords

ASJC Scopus subject areas

Access to Document

Other files and links

Fingerprint

Cite this