System and method for supporting sql-based rich queries in hyperledger fabric blockchains
AssigneeOracle International Corporation
InventorCARLO INNOCENTI
Life of this patent
Estimating the term…
Abstract
Described herein are systems and methods for supporting SQL-based rich queries in a blockchain fabric. In accordance with an embodiment, the systems and methods provided herein provide the ability to execute SQL queries to allow for the creation of complex smart contracts much easier and more maintainable manner. Also, performance is improved both by pushing the data filtering back to the storage engine (rather than happening at the smart contract level), and by being able to rely on relational engines which support concurrent read and write data access. As well, the state of the world database can also provide for concurrent read/write access.
Claims20
A system for supporting SQL-based rich queries in a blockchain fabric comprising:
- one or more computers, each comprising a microprocessor;
- a blockchain fabric running on the one or more computers;
- and
- a transaction manager, the transaction manager controlling access to a database associated with the blockchain fabric;
- wherein a smart contract comprising a query is run against the blockchain fabric;
- wherein the query accesses the database via a relational interface;
- wherein the query comprises a comparison of a plurality of values written in at least two blocks of the blockchain fabric.
A method for supporting SQL-based rich queries in a blockchain fabric comprising:
- providing one or more computers, each comprising a microprocessor;
- running a blockchain fabric on the one or more computers;
- and
- providing a transaction manager, the transaction manager controlling access to a database associated with the blockchain fabric;
- running a smart contract comprising a query against the blockchain fabric;
- and
- accessing, by the query, the database via a relational interface;
- wherein the query comprises a comparison of a plurality of values written in at least two blocks of the blockchain fabric.
A non-transitory computer readable storage medium having instructions thereon for for supporting SQL-based rich queries in a blockchain fabric, which when read and executer cause a computer to perform steps comprising:
- running a blockchain fabric on the computer;
- and
- providing a transaction manager, the transaction manager controlling access to a database associated with the blockchain fabric;
- running a smart contract comprising a query against the blockchain fabric;
- and
- accessing, by the query, the database via a relational interface;
- wherein the query comprises a comparison of a plurality of values written in at least two blocks of the blockchain fabric.
Dependencies are inferred from the claim text.