Response time analysis on indexing inrelational databases and their impact
2020 (English)Independent thesis Basic level (degree of Bachelor), 10 credits / 15 HE credits
Student thesis
Abstract [en]
This is a bachelor thesis concerning the response time and CPU effects of indexing in relational databases. Analyzing two popular databases, PostgreSQL and MariaDB with a real-world database structure using randomized entries. The experiment was conducted over Docker and its command-line interface without cached values to ensure fair outcomes. The procedure was done throughout seven different CRUD queries with multiple volumes of database entries to discover their strengths and weaknesses when utilizing indexes. The result chapter shows indicators that indexing has an overall enhancing effect on almost all of the queries. It is found that join, update and delete operations benefits the most from non-clustered indexing. PostgreSQL gains the most from indexes while MariaDB has a minuscule improvement in the response time reduction. A greater usage of CPU resources does not seem to correlate with quicker response times.
Place, publisher, year, edition, pages
2020. , p. 65
Keywords [en]
Database index, MariaDB, PostgreSQL, response time
National Category
Software Engineering
Identifiers
URN: urn:nbn:se:bth-19520OAI: oai:DiVA.org:bth-19520DiVA, id: diva2:1432817
Subject / course
PA1445 Kandidatkurs i Programvaruteknik
Educational program
PAGWE Web Programming
Presentation
2020-05-27, 09:15 (English)
Supervisors
Examiners
2020-06-262020-05-282020-06-26Bibliographically approved