Article Per Year (5 Year)
p-Index From 2021 - 2026
0.23
P-Index
This Author published in this journals
All Journal Journal of Information Systems and Business Technology
Dinnar Rizky
Universitas Pamulang
Computer Science & IT Library & Information Science

Published : 1 Documents Claim Missing Document
Claim Missing Document
Check
Articles

Found 1 Documents
Search

 1 
Pengembangan Sistem E-Commerce Berbasis Web dengan Optimalisasi Database untuk Penjualan Produk UMKM Dinnar Rizky; Fiqih Zulfikar
Journal of Information Systems and Business Technology Vol 1 No 4 (2025): Journal of Information Systems and Business Technology
Publisher : PT Jurnal Cendekia Indonesia

Show Abstract | Download Original | Original Source | Check in Google Scholar

Abstract

MSMEs are a crucial sector for maintaining economic growth, but they still face challenges in online marketing and inefficient transaction data management. Previous research has shown that e-commerce can increase MSME revenue and competitiveness, but system performance is often hampered by suboptimal database design. This research aims to create a web-based e-commerce system by applying database optimization techniques to make transaction processes and data management more efficient. The Waterfall method was used in developing this system, encompassing requirements analysis, design, implementation, and testing. The database optimization process was carried out by creating indexing, improving query structures, and normalizing tables based on previous research on database optimization in MySQL and other DBMSs. Test results showed that the implementation of indexing and query optimization significantly reduced execution time for product searches and transactions compared to the initial design. The successfully created e-commerce system was able to support MSME sales processes more quickly, structured, and efficiently. Thus, this research contributes to the implementation of a system that not only focuses on e-commerce functions but also improves database performance as a crucial part of MSME digital transformation.
Co-Authors Fiqih Zulfikar