Change search
CiteExportLink to record
Permanent link

Direct link
Cite
Citation style
  • apa
  • ieee
  • modern-language-association-8th-edition
  • vancouver
  • Other style
More styles
Language
  • de-DE
  • en-GB
  • en-US
  • fi-FI
  • nn-NO
  • nn-NB
  • sv-SE
  • Other locale
More languages
Output format
  • html
  • text
  • asciidoc
  • rtf
Response time analysis on indexing inrelational databases and their impact
Blekinge Institute of Technology, Faculty of Computing, Department of Software Engineering.
Blekinge Institute of Technology, Faculty of Computing, Department of Software Engineering.
2020 (English)Independent thesis Basic level (degree of Bachelor), 10 credits / 15 HE creditsStudent 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
Available from: 2020-06-26 Created: 2020-05-28 Last updated: 2020-06-26Bibliographically approved

Open Access in DiVA

Response time analysis on indexing inrelational databases and their impact(1396 kB)868 downloads
File information
File name FULLTEXT01.pdfFile size 1396 kBChecksum SHA-512
8f47f54f826016f59830a3392f8e2ee4f50479e7f32fea4843ab46a248b8aa512e58e8d471406ef42f28c8df7838c94a8903315ce1916ed0fbd5ef12f45d2fe4
Type fulltextMimetype application/pdf

By organisation
Department of Software Engineering
Software Engineering

Search outside of DiVA

GoogleGoogle Scholar
Total: 868 downloads
The number of downloads is the sum of all downloads of full texts. It may include eg previous versions that are now no longer available

urn-nbn

Altmetric score

urn-nbn
Total: 587 hits
CiteExportLink to record
Permanent link

Direct link
Cite
Citation style
  • apa
  • ieee
  • modern-language-association-8th-edition
  • vancouver
  • Other style
More styles
Language
  • de-DE
  • en-GB
  • en-US
  • fi-FI
  • nn-NO
  • nn-NB
  • sv-SE
  • Other locale
More languages
Output format
  • html
  • text
  • asciidoc
  • rtf