COMPARATIVE IMPACT ANALYSIS OF INDEX TECHNIQUES ON QUERY EXECUTION PERFORMANCE IN DIFFERENT RELATIONAL DATABASE MANAGEMENT SYSTEMS
DOI:
https://doi.org/10.24867/06OI02SpasojevicKeywords:
Database, optimization, indexes, performancesAbstract
In this paper we give an insight into the basic issues of tuning performance and query optimization within a database. The basic types of index structures that can be used in the query optimization process are explained. The database management systems and the relational DBMSs used in this paper are presented. Use cases were specified to perform performance testing in three different DBMSs. Finally, the results obtained are shown and compared.
References
[1] Bal Gupta, S., & Mittal, A. (2017). Introduction to Database Management System Second Edition, Kindle Edition. Laxmi Publications Pvt Ltd.
[2] Cioloca, C., & Georgescu, M. (2011). Increasing Database Performance using Indexes. Database Systems Journal , 13-22.
[3] Crnko, N. (2018, march 01). Korištenje hash-indeksa kod pretraživanja mysql baze podataka. Retrieved september 22, 2019 from sistemac.srce.hr: https://sistemac.srce.hr/koristenje-hash-indeksa-kod-pretrazivanja-mysql-baze-podataka-123
[4] Lazarević, B., Marjanović, Z., & Aničić, N. (2008). Baze podataka. Beograd: Fakultet organizacionih nauka.
[5] Mogin, P. (2008). Strukture podataka i organizacija datoteka. Beograd: Računarski fakultet & CET.
[6] Mogin, P., Luković, I., & Govedarica, M. (2004). Principi projektovanja baza podataka. Novi Sad: Fakultet tehničkih nauka.
[7] Mukherjee, S. (2019). Indexes in Microsoft SQL Server. University of the Cumberlands.
[2] Cioloca, C., & Georgescu, M. (2011). Increasing Database Performance using Indexes. Database Systems Journal , 13-22.
[3] Crnko, N. (2018, march 01). Korištenje hash-indeksa kod pretraživanja mysql baze podataka. Retrieved september 22, 2019 from sistemac.srce.hr: https://sistemac.srce.hr/koristenje-hash-indeksa-kod-pretrazivanja-mysql-baze-podataka-123
[4] Lazarević, B., Marjanović, Z., & Aničić, N. (2008). Baze podataka. Beograd: Fakultet organizacionih nauka.
[5] Mogin, P. (2008). Strukture podataka i organizacija datoteka. Beograd: Računarski fakultet & CET.
[6] Mogin, P., Luković, I., & Govedarica, M. (2004). Principi projektovanja baza podataka. Novi Sad: Fakultet tehničkih nauka.
[7] Mukherjee, S. (2019). Indexes in Microsoft SQL Server. University of the Cumberlands.
Downloads
Published
2020-01-30
Issue
Section
Information Systems Engineering
