Implementation of Query Optimization Methods in a Web-Based Point of Sale System at Toko Eci Dolok
Article Sidebar
Main Article Content
Abstract
This study examines the implementation of query optimization in a web-based Point of Sale (POS) system at Toko Eci Dolok. The primary challenge addressed is the inefficiency of manual transaction recording, which complicates the generation of reports. The objective of this research is to design a faster and more efficient POS system through query optimization, utilizing selection, projection, and join skeleton operations. The dataset includes 772 items, along with transaction, cashier, and supplier records. Testing results demonstrate that query optimization reduces the total execution cost from 60,036 pages to 20,012 pages—an improvement of approximately 66.7%—and increases processing speed threefold. In conclusion, this method is effective for enhancing data processing efficiency within a POS system and holds potential for application on a larger scale, such as in e-commerce or management information systems.
Article Details
This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.
References
Suendri, A. M. Harahap, A. B. Nasution, dan S. Kartika, “ANALISIS SISTEM PENDUKUNG KEPUTUSAN PENENTUAN LULUSAN TERBAIK MENGGUNAKAN LIMA ALGORITMA PADA PROGRAM STUDI SISTEM INFORMASI UIN SUMATERA UTARA MEDAN,” Al Ulum Sains dan Teknologi, vol. 7, no. 1, hlm. 38–43, Nov 2021.
Triase, R. Al Ikhsan, dan P. I. J. Hasibuan, “E-COMMERCE UNTUK MENINGKATKAN PENJUALAN PADA UMKM SOLO FRIED CHICKEN BERBASIS WEBSITE PHP NATIVE,” JUTECH (Journal Education and Technology), vol. 5, no. 1, hlm. 20–34, 2024.
N. A. R. Rais, T. F. Efendi, dan M. B. Pakarti, “Rancang Bangun Sistem Informasi dan Bisnis (Study Kasus : Ngemil Snacking),” Jurnal Informatika, Komputer dan Bisnis (JIKOBIS), vol. 3, no. 1, hlm. 12–23, 2023, [Daring]. Tersedia pada: https://jurnal.itbaas.ac.id/index.php/jikobis
V. Widiyanti dan R. Tisnawati, “Perancangan Sistem Informasi Point of Sale di PT. Abercode Software Berbasis Web,” Jurnal Sosial dan Teknologi (SOSTECH), vol. 4, no. 10, hlm. 838–850, Okt 2024.
M. Aidil, “Implementasi Point Of Sale pada UMKM Poci Nayla di Tembilahan,” Jurnal Pengabdian Masyarakat (ABDIMAS), vol. 2, no. 2, hlm. 71–76, Feb 2024.
S. P. R. Tambunan, M. A. Hasan, R. H. Tambunan, M. S. Siahaan, M. J. Sirait, dan F. Mahmud, “IMPLEMENTASI TEKNIK QUERY OPTIMIZATION UNTUK MENINGKATKAN PERFORMA SQL SERVER PADA SISTEM INFORMASI AKADEMIK,” Jurnal Mahasiswa Teknik Informatika), vol. 9, no. 2, hlm. 2437–2442, Apr 2025.
M. Erkamim, F. Fitriyadi, dan I. B. Sumafta, “Optimasi Query Hash Join Dan Inner Join Pada Sistem Pencarian Data Tracer Study (Optimization Of Query Hash Join And Inner Join In Tracer Study Data Search System),” JOURNAL OF SMART SYSTEM (JSS), vol. 1, no. 1, hlm. 18–25, Jul 2021.
R. Alamsyah dan D. Sundari, “Sistem Penjualan Point of Sale Berbasis Web Pada Toko Bangunan,” Journal of Computing and Informatics Research, vol. 2, no. 2, hlm. 49–54, Mar 2023, doi: 10.47065/comforch.v2i2.502.
A. H. Safitri, A. T. W. Almais, A. Syauqi, dan R. I. Melani, “Pengujian Optimization dan Non-Optimization Query Metode Topsis untuk Menentukan Tingkat Kerusakan Sektor Bencana Alam,” Jurnal ELTIKOM, vol. 6, no. 1, hlm. 89–99, Jun 2022, doi: 10.31961/eltikom.v6i1.532.
Y. Tu, M. Eslami, Z. Xu, dan H. Charkhgard, “Multi-Query Optimization Revisited: A Full-Query Algebraic Method,” Proceedings - 2022 IEEE International Conference on Big Data, Big Data 2022, hlm. 252–261, Des 2022, doi: 10.1109/BigData55660.2022.10020338.
D. Rezaldy, R. K. Niswatin, dan A. Sanjaya, “Simulasi dan Perancangan Sistem Penjualan Toko Buku Online,” Seminar Nasional Inovasi Teknologi UN PGRI Kediri, hlm. 161–166, Jul 2022.
V. S. Ramdoss, “Optimizing database queries: Cost and performance analysis,” International Journal of Science and Research Archive, vol. 2, no. 2, hlm. 293–297, Mei 2021, doi: 10.30574/ijsra.2021.2.2.0025.