METHODS FOR VERIFYING DATABASE QUERY RESULTS AND DEVICES THEREOF
Methods, non-transitory computer readable media, and verifier and/or prover devices or query verification apparatuses are disclosed that generate a first commitment from received data and send the received data to a prover device for insertion into a table of a database. A query result and an overall proof are received from the prover device in response to a received query forwarded to the prover device and associated with the database table. The overall proof is generated from one or more partial proofs comprising one or more commitments generated from one or more intermediate values. The query result and an indication the query result was verified are returned in response to the received query after verifying the query result based on a second commitment to the query result generated using the first commitment and the overall proof.
1 . A non-transitory computer readable medium having stored thereon instructions comprising executable code that, when executed by one or more processors, causes the one or more processors to:
update a first commitment to a portion of a database to generate a second commitment in response to new data to be inserted into the portion of the database;
obtain the second commitment, a query result, and a proof associated with the portion of the database after receipt of a query; and
return the query result in response to the query after the query result is verified against the proof based on the second commitment.
2 . The non-transitory computer readable medium of claim 1 , wherein the executable code, when executed by the one or more processors, further causes the one or more processors to:
obtain one or more of the query result or the proof from one or more of a plurality of prover nodes of a decentralized network.
3 . The non-transitory computer readable medium of claim 1 , wherein the executable code, when executed by the one or more processors, further causes the one or more processors to:
generate the first commitment based on original data ingested into the portion of the database before the new data;
store the first commitment in a local memory; and
retrieve the first commitment from the local memory before the first commitment is updated.
4 . The non-transitory computer readable medium of claim 3 , wherein the executable code, when executed by the one or more processors, further causes the one or more processors to
update the first commitment without accessing the original data.
5 . The non-transitory computer readable medium of claim 1 , wherein the database comprises a blockchain database and the one or more processors are hosted by one or more members of a blockchain network.
6 . The non-transitory computer readable medium of claim 1 , wherein the executable code, when executed by the one or more processors, further causes the one or more processors to:
receive a request to store the new data in the portion of the database; and
send the new data to one or more provers hosting the portion of the database for ingestion.
7 . A system, comprising:
memory having instructions stored thereon; and
one or more processors coupled to the memory and configured to execute the instructions to:
update a first commitment to a portion of a database to generate a second commitment in response to new data to be inserted into the portion of the database;
obtain the second commitment, a query result, and a proof associated with the portion of the database after receipt of a query; and
return the query result in response to the query after the query result is verified against the proof based on the second commitment.
8 . The system of claim 7 , wherein the one or more processors are further configured to execute the instructions to:
obtain one or more of the query result or the proof from one or more of a plurality of prover nodes of a decentralized network.
9 . The system of claim 7 , wherein the one or more processors are further configured to execute the instructions to:
generate the first commitment based on original data ingested into the portion of the database before the new data;
store the first commitment in the memory; and
retrieve the first commitment from the memory before the first commitment is updated.
10 . The system of claim 9 , wherein the one or more processors are further configured to execute the instructions to:
update the first commitment without accessing the original data.
11 . The system of claim 7 , wherein the database comprises a blockchain database and the system comprises one or more members of a blockchain network.
12 . The system of claim 7 , further comprising one or more verifiers or one or more provers, wherein the memory and the one or more processors are hosted by one of the verifiers and the portion of the database is hosted by the one or more provers.
13 . The system of claim 7 , wherein the one or more processors are further configured to execute the instructions to:
receive a request to store the new data in the portion of the database; and
send the new data to one or more provers hosting the portion of the database for ingestion.
14 . A method implemented by one or more computing devices and comprising:
updating a first commitment to a portion of a database to generate a second commitment in response to new data to be inserted into the portion of the database;
obtaining the second commitment, a query result, and a proof associated with the portion of the database after receipt of a query; and
returning the query result in response to the query after the query result is verified against the proof based on the second commitment.
15 . The method of claim 14 , further comprising obtaining one or more of the query result or the proof from one or more of a plurality of prover nodes of a decentralized network.
16 . The method of claim 14 , further comprising
generating the first commitment based on original data ingested into the portion of the database before the new data;
storing the first commitment in a local memory of one of the one or more computing devices; and
retrieving the first commitment from the local memory before the first commitment is updated.
17 . The method of claim 16 , further comprising updating the first commitment without accessing the original data.
18 . The method of claim 14 , wherein the database comprises a blockchain database and the one or more computing devices comprise one or more members of a blockchain network.
19 . The method of claim 14 , wherein the one or more computing devices comprises one or more verifiers and the portion of the database is hosted by one or more provers.
20 . The method of claim 14 , further comprising:
receiving a request to store the new data in the portion of the database; and
sending the new data to one or more provers hosting the portion of the database for ingestion.