- مبلغ: ۸۶,۰۰۰ تومان
- مبلغ: ۹۱,۰۰۰ تومان
A blockchain is a decentralised linked data structure that is characterised by its inherent resistance to data modification, but it is deficient in search queries primarily due to its inferior data formatting. A distributed database is also a decentralised data structure which features quick query processing and well-designed data formatting but suffers from data reliability. In this work, we showcase ChainSQL, an open-source system developed by integrating the blockchain with the database, i.e. we present a blockchain database application platform that has the decentralised, distributed and audibility features of the blockchain and quick query processing and well-designed data structure of the distributed databases. ChainSQL features a tamper-resistant and consistent multi-active database, a reliable and cost effective data-level disaster recovery backup and an auditable transaction log mechanism. The system is presented as an operational multi-active database along with the data-level disaster recovery backup and audibility features. A comprehensive experimental evaluation is performed to demonstrate the effectiveness of the system.
Conclusion and Future Work
In this paper, we presented ChainSQL and its novel applications through three usecases that are implemented as a middleware between the user application and the database. The first usecase is a tamper-resistant multi-active database, the second usecase is a data-level disaster recovery backup and the third is an audit middleware. The effectiveness of the system is demonstrated with the help of a detailed experimental study. ChainSQL is the first system of its kind that features the tamper-resistance of the blockchain and the fast query processing of the distributed databases. The utility of the ChainSQL is evident from its business usecases in domains including finance and supplychain, therefore, it offers promising application scenarios for future. A number of considerations from system implementation point of view are also in the pipeline. For instance, the support for big data analytics in ChainSQL, and the implementation of complex indexes for query optimisation.