A Hybrid Blockchain Architecture for Transaction Traceability and Integrity Monitoring in Organizational Information Systems

Abstract

This paper presents and evaluates a hybrid blockchain architecture for organizational information systems in which PostgreSQL remains the operational database while Ethereum Sepolia is used as an externally verifiable transaction-recording layer. The implemented proof-of-concept is a university wallet system combining a React and TypeScript frontend, an Express.js backend, PostgreSQL with Drizzle ORM, and an OpenZeppelin-based ERC-20 smart contract deployed on Ethereum Sepolia. The system associates successful application transactions with corresponding Ethereum transaction hashes stored in a dedicated relational table. The experimental evaluation uses sequential workloads of 10, 50, and 100 transactions, comprising 160 measured application transactions in total, together with a separate 30-transaction database-mutation experiment. The performance evaluation measures database insertion time, blockchain transaction time, end-to-end execution time, success rate, and gas consumption. All 160 performance-test transactions completed successfully. Mean database insertion time remained below 32 ms, while blockchain transaction time ranged from approximately 15.26 to 21.93 seconds and dominated end-to-end execution time. Mean gas consumption was approximately 40,324 gas per successful transfer. The database-mutation experiment modified the amount field of 7 of 30 successfully recorded transactions after their blockchain references had been established. All seven modified records retained their corresponding blockchain transaction references. However, the experiment did not perform field-level comparison between the modified database records and blockchain event contents and therefore is not presented as a complete cryptographic tamper-detection validation. The implementation and experimental artifacts are publicly available through the associated project repository. The paper presents the work as a proof-of-concept implementation and empirical evaluation of a hybrid database-to-blockchain transaction architecture.