Share via

How to detect changes between blockchain data and off-chain SQL DB database data.

Alejandro Benítez Aragón 21 Reputation points
2020-06-23T19:50:50.267+00:00

Hi guys, I am currently developing a small project on blockchain workbench.

The objective in addition to building the contract, the API and the frontend is to detect when an authorized (example: dba) or not authorized user does make changes to the data of the off-chain database respect to the same data on the blockchain.

Imagine this scenario, the DBA of the off-chain database alters a data using an UPDATE.

What mechanisms can be used to detect that this data is not the same stored in the block?

Pd. sorry for my english.

Thank you. I attach images of the example.

10573-askbc01.png

10601-askbc02.png

10574-askbc03.png

Community Center | Not monitored

Answer accepted by question author

AshokPeddakotla-MSFT 36,021 Reputation points Moderator
2020-06-24T12:51:06.603+00:00

@Alejandro Benítez Aragón

Request you to please take a look into the Baseline Protocol: https://github.com/ethereum-oasis/baseline. Specifically the use of ZKP to ensure consistency of off-chain data.

Kindly go through all the information and see if that helps to address your question. Feel free to respond if you have any follow up questions.

Was this answer helpful?

1 person found this answer helpful.

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Alejandro Benítez Aragón 21 Reputation points
    2020-06-25T14:32:38.27+00:00

    Hi, today i will try the apply this. I will let you know how it is going. Thanks

    Was this answer helpful?

    0 comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.