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
Accepted answer
  1. AshokPeddakotla-MSFT 35,971 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.

    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

    0 comments

Your answer

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