Optimization of MySQL Database in the Development of Solo Batik Mall
DOI:
https://doi.org/10.47701/kjy3qe33Keywords:
database, MySQL, online batik mallAbstract
This study aims to design and optimize a MySQL database for an online batik mall system to support the digitalization of batik micro, small, and medium enterprises (MSMEs). The research employed three stages: analysis, design, and implementation. The analysis phase identified actors (sellers, buyers, and administrators) and business process needs. The design stage focused on database structures and optimization strategies, including indexing, query optimization, caching, normalization, and denormalization. The implementation involved building the database, applying optimization techniques, and evaluating performance. The optimization of MySQL significantly improved query execution speed, reduced system response time, and enhanced resource efficiency. The system was able to manage transactions, product searches, and reporting more effectively, supporting both operational and strategic needs of the online batik mall. The MySQL-based online batik mall system provides an efficient solution for data management, thereby enhancing the competitiveness of batik MSMEs in the digital era.
References
Abidin, Z., Kurniawan, J., Abiyyu, D., Suntoro, P., & Yuliastuti, G. E. (2024). Rancang Bangun Website Profil Ikatan Mahasiswa Arosbaya Menggunakan Laravel dan Bootstrap 5 Dengan Metode Waterfall. Prosiding Seminar Implementasi Teknologi Informasi Dan Komunikasi, 3(2), 257–268. https://doi.org/10.31284/p.semtik.2024-2.6222
Amin, F., Soelistijadi, R., & Priambodo, A. (2012). Sentra Batik di Kota Semarang Sebagai Salah Satu Upaya Media Promosi dan Transaksi Secara. Jurnal Teknologi Informasi DINAMIK, 17(1), 67–74.
Arief, S. F., & Sugiarti, Y. (2022). Literature Review: Analisis Metode Perancangan Sistem Informasi Akademik Berbasis Web. Jurnal Ilmiah Ilmu Komputer, 8(2), 87–93. https://doi.org/10.35329/jiik.v8i2.229
Aziiz, D. W., Nastiti, F. E., & Srirahayu, A. (2024). Sistem Informasi Penjulan berbasis Website Pada Galrei Mutiara Batik Solo. Journal Computer Science and Information Systems : J-Cosys, 4(2). https://doi.org/10.53514/jco.v4i2.532
Dariz Radyananda Barus, Handika Natanael Simamora, Michael Glora Surya Sihombing, Josua Panjaitan, & Lenti Susana Saragih. (2023). Tantangan dan Strategi Pemasaran UMKM di Era Teknologi dan Digitalisasi. Journal of Creative Student Research, 1(6), 357–365. https://doi.org/10.55606/jcsrpolitama.v1i6.3031
Kalsum Siregar, U., Arbaim Sitakar, T., Haramain, S., Nur Salamah Lubis, Z., Nadhirah, U., & Sains dan Teknologi, F. (2024). Pengembangan database Management system menggunakan My SQL. SAINTEK: Jurnal Sains, Teknologi & Komputer, 1(1), 8–12.
Kencana Dewi, N. K. I. P., Dewi, P. J. A., & Agustino, D. P. (2024). Perancangan Sistem Informasi Penjualan Pada Buckscorner Berbasis Web. Jurnal Teknik Informatika Dan Sistem Informasi, 11(2), 123–140.
Kismo, H., & Lahindah, L. (2024). Designing a Promotion Strategy to Increase Online Sales. Jurnal Manajemen Bisnis, 11(2), 1962–1975. https://doi.org/10.33096/jmb.v11i2.975
Lamb, C., Landis, G., Orenstein, J., & Weinreb, D. (1991). The ObjectStore database system. Communications of the ACM, 34(10), 50–63. https://doi.org/10.1145/125223.125244
Suhartini, S., Mahbubah, N. A., & Basjir, M. (2021). Marketing Strategy Design Based on Information Technology in Batik Small and Medium-Sized Enterprises in Indonesia. Eastern-European Journal of Enterprise Technologies, 6(13–114), 39–48. https://doi.org/10.15587/1729-4061.2021.244137
Yanuar, R., & Informaika, T. (2025). Implementasi E-commerce Penjualan Kaos Distro Berbasis Website pada Toko Art n Soul Purbalingga. 4(3), 379–394. https://doi.org/10.55123/insologi.v4i3.5286
Zulkifli, A. (2023). Accelerating Database Efficiency in Complex IT Infrastructures: Advanced Techniques for Optimizing Performance, Scalability, and Data Management in Distributed Systems International Journal of Information and Cybersecurity Accelerating Database Efficiency in Complex IT Infrastructures: Advanced Techniques for Optimizing Performance, Scalability, and Data Management in Distributed Systems. Article in International Journal on Information, December 2023. https://www.researchgate.net/publication/386218911