Jurnal Ilmiah Teknik Informatika dan Komunikasi
Vol. 5 No. 3 (2025): November: Jurnal Ilmiah Teknik Informatika dan Komunikasi 

Inventory Management System Framework Based on Python and MySQL Database with Blockchain Technology Implementation

Zainur Romadhon (Unknown)



Article Info

Publish Date
24 Sep 2025

Abstract

Efficient and transparent inventory control is increasingly crucial for sustaining supply chain performance in the digital age. Conventional systems often face challenges such as poor visibility, vulnerability to data manipulation, and inefficiencies in stock monitoring. To address these issues, this research proposes a novel inventory management framework integrating Python, MySQL, and blockchain technology, following a Research and Development (R&D) methodology involving need assessment, system design, implementation, testing, and validation. The framework utilizes Python as the core programming language, MySQL for structured data management, and blockchain as a decentralized security layer to ensure data integrity and traceability. The system architecture consists of six main modules: inbound stock management, outbound stock management, blockchain-based storage, validation mechanisms, a user-friendly interface, and reporting tools. Black-box testing confirmed that all modules met their specifications, while security evaluations showed that the blockchain layer, with the SHA-256 hashing algorithm, effectively detected simulated data manipulation attempts. Performance testing revealed a linear increase in processing time relative to transaction volume, with the framework maintaining stability under medium-scale operational loads. This study contributes to the literature on blockchain-enabled inventory systems by introducing a structured, integrative model, and provides a practical framework that enhances efficiency, transparency, and accountability in inventory management. Future research is encouraged to explore scalability challenges and optimize consensus mechanisms for large-scale applications.

Copyrights © 2025






Journal Info

Abbrev

juitik

Publisher

Subject

Computer Science & IT Electrical & Electronics Engineering

Description

Bidang Teknik Elektro yang meliputi keahlian teknik tenaga listrik, teknik telekomunikasi dan informasi, serta kendali dan instrumentasi. Bidang Teknik Informatika yang meliputi keahlian di bidang teknik Komputer, Sistem Komputer, Ilmu ...