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

Institutions

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
Controls
|||
ALL TIME
JAN
FEB
MAR
APR
MAY
JUN
JUL
AUG
SEP
OCT
preprint

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

Muhammad Anas
Zenodo (CERN European Organization for Nuclear Research)
Blockchain Technology Applications and Security
preprint

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

Muhammad Anas
preprint en

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.

Zenodo (CERN European Organization for Nuclear Research)
University of Engineering and Technology Taxila (PK)
Blockchain Technology Applications and Security
AI Navigator

Ask Laika to Summarize, Analyze, and Connect papers live on the map.

Summarize Papers & Methodologies

Extract key findings, datasets, and comparative methods across publications.

Benchmark Rankings & Visual Analytics

Rank top research institutions, authors, funders, topics, and journals by Field-Weighted Citation Impact (FWCI) and paper volume with instant charts.

Connect Distant Disciplines

Bridge topological clusters on the map to find hidden collaborative intersections.