Partial database update based on lightweight join

    公开(公告)号:US12222947B1

    公开(公告)日:2025-02-11

    申请号:US18587388

    申请日:2024-02-26

    Applicant: Twilio Inc.

    Inventor: Gil Omer

    Abstract: A machine is configured to access an authoritative database of data fields, where each data field has a corresponding authoritative value and a corresponding update time. The machine accesses a propagation time that was last updated in response to a most recent propagation of updated authoritative values from the authoritative database to a recipient database. The machine performs a database join that joins only any unpropagated authoritative values having update times that exceed the propagation time to corresponding reference checksums of corresponding data fields. The machine generates candidate checksums of only the corresponding data fields whose unpropagated authoritative values have update times that exceed the propagation time. The machine propagates, from the authoritative database to the recipient database, the unpropagated authoritative values, and the machine replaces the reference checksums with the generated candidate checksums.

Patent Agency Ranking