Devices, system and method for synchronizing changes, deletions or additions to fields at databases

A computing node for synchronization of data across databases to save network bandwidth, the computing node comprising:

• a processor configured to:
• determine that a stored data-set at a primary database has changed, the stored data-set comprising a plurality of data fields arranged in a predetermined layout defined according to a data-set representation (DSR) structure that defines for a given data-set, a structure of data fields which are associated with respective keys of the DSR structure, a change to the stored data-set comprising a deletion of an existing data field or an addition of a new data field;
• determine a change indication bit-vector indicating one or more of a position of the change at the stored data-set and a respective key position defined by the DSR structure, wherein the change indication bit-vector comprises a plurality of bits arranged serially, each of the plurality of bits corresponding to a respective key position of the DSR structure;
• when the change comprises the deletion of the existing data field, provide, to a replication node managing a replica database storing a replica of the stored data-set, an indication of the change indication bit-vector, such that the replication node updates the replica and a respective DSR structure to show deletion of the existing data field at the position indicated by the change indication bit-vector;
• and
• when the change comprises the addition of the new data field, provide, to the replication node, the indication of the change indication bit-vector and a record of a key value of the new data field and a data value of the new data field, such that the replication node updates the replica and the respective DSR structure to show the addition of the new data field at the position indicated by the change indication bit-vector.

A non-transitory computer program product comprising computer-readable program code which, when executed by a computer, causes the computer to perform a method for synchronization of data across databases to save network bandwidth, the method comprising:

• determining, at a computing node, that a stored data-set at a primary database has changed, the stored data-set comprising a plurality of data fields arranged in a predetermined layout defined according to a data-set representation (DSR) structure that defines for a given data-set, a structure of data fields which are associated with respective keys of the DSR structure, a change to the stored data-set comprising a deletion of an existing data field or an addition of a new data field;
• determining, at the computing node, a change indication bit-vector indicating one or more of a position of the change at the stored data-set and a respective key position defined by the DSR structure, wherein the change indication bit-vector comprises a plurality of bits arranged serially, each of the plurality of bits corresponding to a respective key position of the DSR structure;
• when the change comprises the deletion of the existing data field, providing, to a replication node managing a replica database storing a replica of the stored data-set, an indication of the change indication bit-vector, such that the replication node updates the replica and a respective DSR structure to show deletion of the existing data field at the position indicated by the change indication bit-vector;
• and
• when the change comprises the addition of the new data field, providing, to the replication node the indication of the change indication bit-vector and a record of a key value of the new data field and a data value of the new data field, such that the replication node updates the replica and the respective DSR structure to show the addition of the new data field at the position indicated by the change indication bit-vector.