International Business Machines Corporation
SQL processing engine for blockchain ledger

Abstract:

An example operation may include one or more of receiving a structured query language (SQL) request which applies to a subset of blocks from among blocks stored on a blockchain ledger, storing, in a cache, a portion of the blocks from among the blocks stored on the blockchain ledger, identifying one or more blocks which the SQL request applies to, which are not stored in the cache, and retrieving the identified one or more blocks not stored in the cache from the blockchain ledger, performing an SQL operation to merge one or more blocks from the cache which the SQL request applies to and the one or more blocks retrieved from the blockchain ledger, and transmitting the merged blocks to a computing system that is associated with the received SQL request.