Implementation of Heuristic Principles for Index Recommendations using Java in the MariaDB Database

Radityo P. Wibowo, Risa Perdana Sujanawati, Faizal Mahananto, Prasasti Karunia Farista Ananto

2019

Abstract

Almost all fields in life today use database and demanding the most optimal performance from a database. Therefore, a database must have the ability to optimize performance that can be obtained one of them by choosing an optimal index because the index plays an important role in determining the performance of queries that are executed against the system. The right index can increase speed in data processing. According to previous research, Index can improve database performance, namely the number of transactions per minute which increases three times and the cost is reduced by about 50% to 90%. That way index selection is a dilemma for database users. The output of the following research is a Java-based software that can be used in the MariaDB Database to obtain recommended indexes based on heuristic principles that have been used by previous researchers. The following software can evaluate database performance based on response time and Queries per Second or QPS. The recommendations from the following research can improve the performance of the Monitordom database by 43.65% and the Adventureworks 2012 database to 2.77%.

Paper Citation

in Harvard Style

Wibowo R., Sujanawati R., Mahananto F. and Ananto P. (2019). Implementation of Heuristic Principles for Index Recommendations using Java in the MariaDB Database.In Proceedings of the International Conferences on Information System and Technology - Volume 1: CONRIST, ISBN 978-989-758-453-4, pages 92-97. DOI: 10.5220/0009906200920097

in Bibtex Style

@conference{conrist19,
author={Radityo P. Wibowo and Risa Perdana Sujanawati and Faizal Mahananto and Prasasti Karunia Farista Ananto},
title={Implementation of Heuristic Principles for Index Recommendations using Java in the MariaDB Database},
booktitle={Proceedings of the International Conferences on Information System and Technology - Volume 1: CONRIST,},
year={2019},
pages={92-97},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0009906200920097},
isbn={978-989-758-453-4},
}

in EndNote Style

TY - CONF

JO - Proceedings of the International Conferences on Information System and Technology - Volume 1: CONRIST,
TI - Implementation of Heuristic Principles for Index Recommendations using Java in the MariaDB Database
SN - 978-989-758-453-4
AU - Wibowo R.
AU - Sujanawati R.
AU - Mahananto F.
AU - Ananto P.
PY - 2019
SP - 92
EP - 97
DO - 10.5220/0009906200920097