# US 10,503,752 B2 · Delta replication > Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt - Number: US 10,503,752 B2 - Document ID: US10503752B2 - Status: Granted - Kind: B2 - Application number: 15/373,246 - Filed: 2016-12-08 - Published: 2018-06-14 - Granted: 2019-12-10 - Earliest claimed: 2016-12-08 - Assignees: Sap SE - Applicants: Sap SE - Inventors: Daniel Goldmann; Mario Andy Mueller; Esther Landes; Matthias Klauer; Joachim Pfeifer; Oleg Loewen; Qendrim Kuqi; Qian Chen - Web page: https://patentgrep.com/patent/US10503752B2 ## CPC - G06F 16/27: Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor - G06F 16/245: Query processing - G06F 11/1451: {by selection of backup contents} - G06F 16/178: Techniques for file synchronisation in file systems - G06F 16/24: Querying - G06F 16/273: {Asynchronous replication or reconciliation} - G06F 2201/84: Using snapshots, i.e. a logical point-in-time copy of the data - G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N) ## Abstract A system, a method, and a computer program product for replication of data changes are disclosed. Based on a received data query, at least one attribute of stored data is identified for replication. The attribute corresponds to at least one parameter of the received query. Data stored at a first time and data stored at a second time are retrieved. The second time is subsequent to the first time. Data stored at the first time is compared to the data stored at the second time to determine a delta difference between the data stored at the first and second times. The computed delta difference is selected for the identified attribute. The selected computed delta difference is replicated in response to the received query. ## Claims ### Claim 1 A computer-implemented method, comprising: identifying, based on a received data query, at least one attribute of stored data for replication in response to the received data query, the at least one attribute corresponding to at least one parameter of the received data query, wherein the at least one attribute corresponds to a field attribute in a segment of stored data, the field attribute including at least one of the following: a delta irrelevant field attribute for excluding at least one field in a segment for determining a delta difference, an exclusion field attribute for excluding all fields in a segment for determining the delta difference, and a mandatory field attribute for requiring replication of all fields of a segment regardless of the determination of the delta difference; retrieving data stored at a first time and data stored at a second time, the second time being subsequent to the first time; comparing the data stored at the first time and the data stored at the second time to determine the delta difference between the data stored at the first and second times; selecting the determined delta difference for the at least one identified attribute; and replicating the selected computed delta difference in response to the received query; wherein at least one of the identifying, the retrieving, the comparing, the selecting, and the replicating is performed on at least one processor of at least one computing system. ### Claim 2 (depends on 1) The method according to claim 1, wherein the at least one attribute corresponds to a segment of stored data. ### Claim 3 (depends on 2) The method according to claim 2, wherein the segment attribute includes at least one of the following: a complete segment attribute for replicating all fields of a segment, a time-based segment attribute for replicating at least one field of a segment valid at a predetermined time, a delta irrelevant segment attribute for excluding a segment for determining the delta difference, and a mandatory segment attribute for requiring replication all fields of a segment regardless of the determination of the delta difference. ### Claim 4 (depends on 1) The method according to claim 1, further comprising excluding data from determination of the delta difference upon determination that data does not correspond to at least one identified attribute. ### Claim 5 (depends on 1) The method according to claim 1, wherein the second time corresponds to a snapshot of stored data at a current time and the first time corresponds to a snapshot of stored at a predetermined time prior to the current time. ### Claim 6 (depends on 1) The method according to claim 1, further comprising validating the at least one parameter of the received data query, wherein the identifying of the at least one attribute is performed based on determination of validity of the at least one parameter. ### Claim 7 A system comprising: at least one programmable processor; and a machine-readable medium storing instructions that, when executed by the at least one programmable processor, cause the at least one programmable processor to perform operations comprising: identifying, based on a received data query, at least one attribute of stored data for replication in response to the received data query, the at least one attribute corresponding to at least one parameter of the received data query, wherein the at least one attribute corresponds to a field attribute in a segment of stored data, the field attribute including at least one of the following: a delta irrelevant field attribute for excluding at least one field in a segment for determining a delta difference, an exclusion field attribute for excluding all fields in a segment for determining the delta difference, and a mandatory field attribute for requiring replication of all fields of a segment regardless of the determination of the delta difference; retrieving data stored at a first time and data stored at a second time, the second time being subsequent to the first time; comparing the data stored at the first time and the data stored at the second time to determine the delta difference between the data stored at the first and second times; selecting the determined delta difference for the at least one identified attribute; and replicating the selected computed delta difference in response to the received query. ### Claim 8 (depends on 7) The system according to claim 7, wherein the at least one attribute corresponds to a segment of stored data. ### Claim 9 (depends on 8) The system according to claim 8, wherein the segment attribute includes at least one of the following: a complete segment attribute for replicating all fields of a segment, a time-based segment attribute for replicating at least one field of a segment valid at a predetermined time, a delta irrelevant segment attribute for excluding a segment for determining the delta difference, and a mandatory segment attribute for requiring replication all fields of a segment regardless of the determination of the delta difference. ### Claim 10 (depends on 7) The system according to claim 7, wherein the operations further comprise excluding data from determination of the delta difference upon determination that data does not correspond to at least one identified attribute. ### Claim 11 (depends on 7) The system according to claim 7, wherein the second time corresponds to a snapshot of stored data at a current time and the first time corresponds to a snapshot of stored at a predetermined time prior to the current time. ### Claim 12 (depends on 7) The system according to claim 7, wherein the operations further comprise validating the at least one parameter of the received data query, wherein the identifying of the at least one attribute is performed based on determination of validity of the at least one parameter. ### Claim 13 A computer program product comprising a non-transitory machine-readable medium storing instructions that, when executed by at least one programmable processor, cause the at least one programmable processor to perform operations comprising: identifying, based on a received data query, at least one attribute of stored data for replication in response to the received data query, the at least one attribute corresponding to at least one parameter of the received data query, wherein the at least one attribute corresponds to a field attribute in a segment of stored data, the field attribute including at least one of the following: a delta irrelevant field attribute for excluding at least one field in a segment for determining a delta difference, an exclusion field attribute for excluding all fields in a segment for determining the delta difference, and a mandatory field attribute for requiring replication of all fields of a segment regardless of the determination of the delta difference; retrieving data stored at a first time and data stored at a second time, the second time being subsequent to the first time; comparing the data stored at the first time and the data stored at the second time to determine the delta difference between the data stored at the first and second times; selecting the determined delta difference for the at least one identified attribute; and replicating the selected computed delta difference in response to the received query. ### Claim 14 (depends on 13) The computer program product according to claim 13, wherein the at least one attribute corresponds to a segment of stored. ### Claim 15 (depends on 14) The computer program product according to claim 14, wherein the segment attribute includes at least one of the following: a complete segment attribute for replicating all fields of a segment, a time-based segment attribute for replicating at least one field of a segment valid at a predetermined time, a delta irrelevant segment attribute for excluding a segment for determining the delta difference, and a mandatory segment attribute for requiring replication all fields of a segment regardless of the determination of the delta difference. ### Claim 16 (depends on 13) The computer program product according to claim 13, wherein the operations further comprise excluding data from determination of the delta difference upon determination that data does not correspond to at least one identified attribute. ### Claim 17 (depends on 13) The computer program product according to claim 13, wherein the second time corresponds to a snapshot of stored data at a current time and the first time corresponds to a snapshot of stored at a predetermined time prior to the current time. ### Claim 18 (depends on 13) The computer program product according to claim 13, wherein the operations further comprise validating the at least one parameter of the received data query, wherein the identifying of the at least one attribute is performed based on determination of validity of the at least one parameter.