Perbandingan Performa Pencarian Data Berbasis Teks dengan Dan Tanpa Full-text Index pada Basis Data MySQL

Authors

  • Imam Thoib Institut Teknologi Mojosari
  • Beda Puspita Candra Institut Teknologi Mojosari
  • Nafis Sururi Institut Teknologi Mojosari
  • Danang Satya Nugraha Institut Teknologi Mojosari

DOI:

https://doi.org/10.55123/insologi.v3i6.4596

Keywords:

Database, Mysql, Data Search, Full-text Search, Full-text Index

Abstract

The amount of text-based data generated today is increasing drastically, especially with the development of digital technology and the internet. With the rapid growth of data, one of the main challenges faced is how to store and search large amounts of text-based data efficiently. This study analyzes the effect of using Full-text index in MySQL on the performance of text-based data searches, especially on large datasets. The study was conducted using a marketplace product dataset containing 2.3 million data. Testing includes searching using one, two, and three-word keywords in tables with and without full-text index. The test results show that tables with full-text index have faster search times than tables without Full-text index. Statistical analysis using the t-test produces a p value <0.05, indicating a significant effect of using Full-text index on data search efficiency. These findings confirm that full-text index is an effective solution to improve the performance of large-scale text data searches.

Downloads

Download data is not yet available.

References

Asyhari, I., Subchan Mauludin, M., & Tengah, J. M. (2019). IMPLEMENTASI FULL TEXT SEARCH PADA SISTEM INFORMASI PERPUSTAKAAN MENGGUNAKAN LARAVEL, 1(1), 1–9. Retrieved from www.elastic.co

Chatziparaskevas, M. (2023). Full-text indexing in open source DBMS. University of Macedonia.

Dirgantara, U., & Suryadarma, M. (2014). Revolusi Industri 4.0: Big Data, Implementasi Pada Berbagai Sektor Industri (Bagian 2). Jurnal Sistem Informasi Universitas Suryadarma, 10(1). https://doi.org/10.35968/jsi.v10i1.991

Ferdian, S., Hermawan, A., & Edy, E. (2023). Designing a Chatbot Based on Full-Text Search and 3D Modelling as a Promotional Media. JUITA : Jurnal Informatika, 11(1), 19. https://doi.org/10.30595/juita.v11i1.15237

Fotopoulos, G. (2022). Comparison of full-text search performance in relational and non-relational database systems. UNIVERSITY OF THE PELOPONNESE & NCSR “DEMOCRITOS.”

Grivin Mokodaser, W., & Dwijayanti, M. (n.d.). Implementasi Metode Indexing dan Penggunaan Subquery untuk Optimalisasi Database Rawat Jalan Rumah Sakit Menggunakan Mysql. Cogito Smart Journal |, 8(2).

Hajar, A., Utami, E., & Al Fatta, H. (2022). Penggunaan Fulltext Indexing Untuk Meningkatkan Efisiensi Pencarian Data Pada Basis Data MYSQL Use of Fulltext Indexing to Improve Data Search Efficiency in MYSQL Databases, 12(2). https://doi.org/10.30700/jst.v12i2.1264

Homepage, J., Putry Avrylya, T., & Susetyo, Y. A. (2024). Perbandingan Response Time Pencarian Menggunakan Text Indexing pada MongoDB dan ArangoDB Berbasis Web, 4(3), 777–785.

Madavi, C., Patel, C., Jain, V., & Kate, P. V. (2023). MySQL Select Query Optimization Using Self-Join. International Journal of Research Publication and Reviews, 4(4), 2564–2571. https://doi.org/10.55248/gengpi.234.4.36035

Maesaroh, S., Gunawan, H., Lestari, A., Tsaurie, M. S. A., & Fauji, M. (2022). Query Optimization In MySQL Database Using Index. International Journal of Cyber and IT Service Management, 2(2), 104–110. https://doi.org/10.34306/ijcitsm.v2i2.84

Salunke, S. V., & Ouda, A. (2024). A Performance Benchmark for the PostgreSQL and MySQL Databases. Future Internet, 16(10). https://doi.org/10.3390/fi16100382

Šušter, I., & Ranisavljević, T. (2023). Optimization of MySQL database. Journal of Process Management and New Technologies, 11(1–2), 141–151. https://doi.org/10.5937/jouproman2301141q

Yudistira, N. (2021). Peran Big Data dan Deep Learning untuk Menyelesaikan Permasalahan Secara Komprehensif. EXPERT: Jurnal Manajemen Sistem Informasi Dan Teknologi, 11(2), 78. https://doi.org/10.36448/expert.v11i2.2063

Downloads

Published

2024-12-25

How to Cite

Imam Thoib, Beda Puspita Candra, Nafis Sururi, & Danang Satya Nugraha. (2024). Perbandingan Performa Pencarian Data Berbasis Teks dengan Dan Tanpa Full-text Index pada Basis Data MySQL. INSOLOGI: Jurnal Sains Dan Teknologi, 3(6), 663–673. https://doi.org/10.55123/insologi.v3i6.4596

Issue

Vol. 3 No. 6 (2024): Desember 2024

Section

Articles

License

Copyright (c) 2024 Imam Thoib, Beda Puspita Candra, Nafis Sururi, Danang Satya Nugraha

Creative Commons License

This work is licensed under a Creative Commons Attribution 4.0 International License.

Hak cipta pada setiap artikel adalah milik penulis.
Penulis mengakui bahwa INSOLOGI (Jurnal Sains dan Teknologi) sebagai publisher yang mempublikasikan pertama kali dengan lisensi Creative Commons Attribution 4.0 International License.
Penulis dapat memasukan tulisan secara terpisah, mengatur distribusi non-ekskulif dari naskah yang telah terbit di jurnal ini kedalam versi yang lain, seperti: dikirim ke respository institusi penulis, publikasi kedalam buku, dan lain-lain. Dengan mengakui bahwa naskah telah terbit pertama kali pada INSOLOGI (Jurnal Sains dan Teknologi).