A Hybrid Blockchain Architecture for Transaction Traceability and Integrity Monitoring in Organizational Information Systems
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.
Authors
- Muhammad Anas (ORCID: https://orcid.org/0000-0001-5313-6647)
Institutions
- University of Engineering and Technology Taxila (PK)
Publication Details
- Journal
- Zenodo (CERN European Organization for Nuclear Research)
- Published
- 2026-08-25
- DOI
- https://doi.org/10.5281/zenodo.22094306
- Primary Topic
- Blockchain Technology Applications and Security
- Type
- preprint