Back to results
US 11,106,695 B2Granted
Database data modification request processing
AssigneeAnt Financial (Hang Zhou) Network Technology Co., Ltd.
InventorsZhenkun Yang, Fusheng Han
Life of this patent
Estimating the term…
Abstract
A data modification request for modifying data in a primary database is received at the primary database. Based on the data modification request, second data in the primary database is modified to first data. Based on the data modification request, a first log and a second log are generated, where the first log is a simplified log including the first data and the second log is a complete log including the second data. Persistence processing is performed on the first log. A modification result that corresponds to the data modification request is returned.
Claims14
A computer-implemented method, comprising:
- receiving, from a user and at a primary database, a data modification request for modifying data in the primary database, wherein the data modification request specifies one or more updated values of one or more respective first database records in first columns;
- modifying, in response to the data modification request, one or more previous values of the one or more respective first database records in the first columns to have the one or more updated values;
- generating, based on the data modification request, a first log and a second log, wherein the second log comprises a) the one or more updated values and the one or more previous values of the one or more respective first database records in the first columns that are being modified and b) previous values of second database records in second columns that are not being modified, and wherein the first log comprises only the one or more updated values of the one or more respective first database records in the first columns for use in database recovery or synchronization;
- performing persistence processing including storing first columns being modified in the first log in persistent storage before returning a modification result to the user and storing second columns not being modified in the second log only after returning the modification result to the user;
- and
- returning the modification result to the user that is indicative of having successfully modified the data in the primary database in response to receiving the data modification request.
3 more elements
A non-transitory, computer-readable medium storing one or more instructions executable by a computer system to perform operations comprising:
- receiving, from a user and at a primary database, a data modification request for modifying data in the primary database, wherein the data modification request specifies one or more updated values of one or more respective first database records in first columns;
- modifying, in response to the data modification request, one or more previous values of the one or more respective first database records in the first columns to have the one or more updated values;
- generating, in a memory and based on the data modification request, a first log and a second log, wherein the second log comprises a) the one or more updated values and the one or more previous values of the one or more respective first database records in the first columns that are being modified and b) previous values of second database records in second columns that are not being modified, and wherein the first log comprises only the one or more updated values of the one or more respective first database records in the first columns for use in database recovery or synchronization;
- performing persistence processing including storing first columns being modified in the first log in persistent storage before returning a modification result to the user and storing second columns not being modified in the second log only after returning the modification result to the user;
- and
- returning the modification result to the user that is indicative of having successfully modified the data in the primary database in response to receiving the data modification request.
3 more elements
A computer-implemented system, comprising:
- one or more computers;
- and
- one or more computer memory devices interoperably coupled with the one or more computers and having tangible, non-transitory, machine-readable media storing one or more instructions that, when executed by the one or more computers, perform operations comprising:
- receiving, from a user and at a primary database, a data modification request for modifying data in the primary database, wherein the data modification request specifies one or more updated values of one or more respective first database records in first columns;
- modifying, in response to the data modification request, one or more previous values of the one or more respective first database records in the first columns to have the one or more updated values;
- generating, in a memory and based on the data modification request, a first log and a second log, wherein the second log comprises a) the one or more updated values and the one or more previous values of the one or more respective first database records in the first columns that are being modified and b) previous values of second database records in second columns that are not being modified, and wherein the first log comprises only the one or more updated values of the one or more respective first database records in the first columns for use in database recovery or synchronization;
- performing persistence processing including storing first columns being modified in the first log in persistent storage before returning a modification result to the user and storing second columns not being modified in the second log only after returning the modification result to the user;
- and
- returning the modification result to the user that is indicative of having successfully modified the data in the primary database in response to receiving the data modification request.
6 more elements
Dependencies are inferred from the claim text.