oracle database - How to build a Change Data Capture application using Merkle Trees - Stack Overflow

admin管理员组

文章数量:1349729

I have a remote database and a local database that I want to keep in sync. I can't implement an event-driven functionality because I have no access other than read of that database. Can't add another application like GoldenGate(Oracle CDC application). Decided to build this API engine where it would maintain a hash tree structure(merkle tree) for each fetch. The tree would help me figure out the changes that occurred in the remote database tables. Then I can synchronize things easily with the changes. Expecting low amount of changes hence thought of this(atleast better than iterating over the whole table).

Using OracleDB for my purpose. My main problem is when I build this tree how can I build this relation between rows so I can compare that ok Row 1 belongs to the left subtree of Row 0, and Row 2 belongs to right subtree of the Row 0. Is there any vectorized comparison I can make or some kind of heuristic function(again maybe I'm way over my head). All the rows are not going to be the leaf nodes of the tree rather the table row(node) can be a parent to the other row(node). In the diagram I mean 0th node can be Row A, similarly rest of the nodes could be a row from the table.

本文标签： oracle databaseHow to build a Change Data Capture application using Merkle TreesStack Overflow