Blockchain and API Development to Improve Relational Database Integrity and System Interoperability

Abstract

Technological developments have resulted in a trend of cryptocurrencies that use a technology called blockchain to create and record all transactions made into a digital ledger. Along with the emergence of the trend of cryptocurrencies, this development has also resulted in crimes that hit the digital world, such as data leakage and cyber espionage. This threat can be prevented by applying blockchain technology to the database that has been used. Therefore, we need a system that can facilitate the use of blockchain technology and can process data from an existing relational database into a blockchain-based database. The system developed in this study was built with the FastAPI framework that uses the Python programming language and the React framework that uses the Javascript programming language. This system was tested using Katalon and Wireshark software to perform throughput testing and man-in-the-middle attacks. Evaluation of this system is assessed based on the average throughput time and also the results of Wireshark packet capture. The system designed in this research is expected to help overcome interoperability problems when using blockchain and improve relational database integrity. The results of the test show that the system is safe from man-in-the-middle attacks while sending data through API and has a faster throughput time than BigchainDB system by 4.151 seconds.