Andmebaasi juhtimissüsteemi võimekuse mõõtmine
Date
2019
Authors
Journal Title
Journal ISSN
Volume Title
Publisher
Abstract
Käesolevas töös võrreldakse PostgreSQLi ja MariaDBi juhtimissüsteeme. Võrreldakse järgmiseid parameetreid: andmemaht, platvormi tugi ja turvalisus. Töö käigus mõõdeti jõudlust järgmistel andmebaasi juhtimissüsteemidel: PostgreSQL, MariaDB ja MariaDB, mille lähtekoodi oli muudetud. Jõudluse mõõtmiseks kasutati tööriista nimega HammerDB. Töö käigus kirjeldatakse andmebaasi juhtimissüsteemi seadistamist, jõudluse mõõtmise protsessi ja ette tulnud probleeme, nende lahendusi ja võimalikke põhjuseid.
In this thesis PostgreSQL and MariaDB management systems are compared. The following parameters are compared: data volume, platform support and security. During the work, performance was measured for the following database management systems: PostgreSQL, MariaDB and MariaDB with the source code of which was changed. A tool called HammerDB was used to measure performance. This thesis describes how to set up a database management system, performance measurement process, encountered problems with their solutions and possible causes.
In this thesis PostgreSQL and MariaDB management systems are compared. The following parameters are compared: data volume, platform support and security. During the work, performance was measured for the following database management systems: PostgreSQL, MariaDB and MariaDB with the source code of which was changed. A tool called HammerDB was used to measure performance. This thesis describes how to set up a database management system, performance measurement process, encountered problems with their solutions and possible causes.