Partial database update based on lightweight join

A non-transitory machine-readable medium comprising instructions that, when executed by one or more processors of a machine, cause the machine to perform operations comprising:

• accessing an authoritative database of data fields, each data field having a corresponding authoritative value and a corresponding update time;
• accessing a propagation time that was last updated in response to a most recent propagation of one or more updated authoritative values from the authoritative database to a recipient database;
• performing a database join that joins only unpropagated authoritative values having update times that exceed the propagation time to corresponding reference checksums of their corresponding data fields;
• generating candidate checksums of only the corresponding data fields with unpropagated authoritative values having update times that exceed the propagation time;
• propagating, from the authoritative database to the recipient database, the unpropagated authoritative values having update times that exceed the propagation time;
• and
• replacing the reference checksums with the generated candidate checksums for only the corresponding data fields with propagated authoritative values having update times that exceed the propagation time.

A system comprising:

• one or more processors;
• and
• a memory storing instructions that, when executed by at least one processor among the one or more processors, cause the system to perform operations comprising:
• accessing an authoritative database of data fields, each data field having a corresponding authoritative value and a corresponding update time;
• accessing a propagation time that was last updated in response to a most recent propagation of one or more updated authoritative values from the authoritative database to a recipient database;
• performing a database join that joins only unpropagated authoritative values having update times that exceed the propagation time to corresponding reference checksums of their corresponding data fields;
• generating candidate checksums of only the corresponding data fields with unpropagated authoritative values having update times that exceed the propagation time;
• propagating, from the authoritative database to the recipient database, the unpropagated authoritative values having update times that exceed the propagation time;
• and
• replacing the reference checksums with the generated candidate checksums for only the corresponding data fields with propagated authoritative values having update times that exceed the propagation time.