Claim Missing Document
Check
Articles

Found 2 Documents
Search

Perbandingan Performa Pencarian Data Berbasis Teks dengan Dan Tanpa Full-text Index pada Basis Data MySQL Imam Thoib; Beda Puspita Candra; Nafis Sururi; Danang Satya Nugraha
INSOLOGI: Jurnal Sains dan Teknologi Vol. 3 No. 6 (2024): Desember 2024
Publisher : Yayasan Literasi Sains Indonesia

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.55123/insologi.v3i6.4596

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.
Digitalisasi Sistem Informasi Perpustakaan pada MI Hidayatul Ulum Nafis Sururi; Fendy Bayu Firmansyah; Danang Satya Nugraha; Zamilu Toniatul Mina; Muh Fahrizal A
Kesejahteraan Bersama : Jurnal Pengabdian dan Keberlanjutan Masyarakat Vol. 2 No. 3 (2025): Juli : Kesejahteraan Bersama : Jurnal Pengabdian dan Keberlanjutan Masyarakat
Publisher : Lembaga Pengembangan Kinerja Dosen

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.62383/bersama.v2i3.2006

Abstract

This community service activity was motivated by the need for an efficient and structured library management system at MI Hidayatul Ulum. Previously, book recording, borrowing, and reporting were done manually, creating administrative challenges and limiting access to information for students and teachers. To address these challenges, the community service team implemented a web-based library information system designed to simplify collection management, facilitate book searches, and expedite the borrowing and return process. The implementation method included partner needs analysis, system design and installation, training for staff and teachers, and evaluation of implementation results. The system was designed to be accessible through the school's local network with a simple and user-friendly interface. Training was provided to ensure the school was able to utilize and manage the system independently. The results showed that the implementation of this information system improved library management efficiency and expanded user access to information. Teachers could more easily monitor book collections, while students found it easier to search for and borrow books. Furthermore, the system accelerated administrative processes and reduced the risk of recording errors. Another positive impact was the growth of a technology-based literacy culture within the madrasah. With the availability of faster book search and borrowing services, students' interest in reading increased. A participatory approach involving schools from the planning stage through evaluation ensures that the resulting solutions meet needs and can be implemented sustainably. This community service activity is expected to serve as a model for implementing simple technology that has a real impact on improving the quality of basic education services.