Enterprise data movement system and method which maintains and compares edition levels for consistency of replicated data
First Claim
1. A method for enabling movement of information in an enterprise computing system, the enterprise computing system comprising a plurality of computer systems, the method comprising:
- capturing changed data, wherein the changed data comprises changes being made to a source database;
obtaining an edition level value of the source database;
creating and storing a change record comprising the captured changed data in a log, wherein the change record includes an edition level value which identifies the edition level of the source database to which the changes are being made;
initiating a data propagation operation to one or more target computer systems;
obtaining an edition level value of each of the one or more target computer systems;
wherein, for each target computer system, the method further comprises;
comparing the edition level value comprised in the change record with the edition level value of the target computer system, wherein said comparing determines whether the target and source database edition level values match;
propagating the change record to the target database in response to determining that the target and source database edition levels match;
wherein the change record is not propagated in response to determining that the target and source database edition levels are different.
16 Assignments
0 Petitions
Accused Products
Abstract
A system and method for providing consistency of replicated data in a distributed enterprise computing system by maintaining and using edition level values for data objects in both source and target database systems. When the EDM method captures changes made to a source database, the EDM method operates to obtain an edition level value of the source database. The EDM method then creates and stores a change record comprising the captured changed data in a log, wherein the change record includes the edition level value of the source database to which the changes are being made. When a data propagation operation is initiated to one or more target computer systems, the EDM method operates to obtain an edition level value of each of the target computer systems. For each target computer system, the method operates to compare the edition level value comprised in the change record with the edition level value of the target computer system. This comparison determines whether the target and source database edition level values match. If the target and source database edition levels match, the change record is propagated to the target database. If the source database edition level is prior to the target edition level, the change record is not propagated to the target database.
211 Citations
38 Claims
-
1. A method for enabling movement of information in an enterprise computing system, the enterprise computing system comprising a plurality of computer systems, the method comprising:
-
capturing changed data, wherein the changed data comprises changes being made to a source database; obtaining an edition level value of the source database; creating and storing a change record comprising the captured changed data in a log, wherein the change record includes an edition level value which identifies the edition level of the source database to which the changes are being made; initiating a data propagation operation to one or more target computer systems; obtaining an edition level value of each of the one or more target computer systems; wherein, for each target computer system, the method further comprises; comparing the edition level value comprised in the change record with the edition level value of the target computer system, wherein said comparing determines whether the target and source database edition level values match; propagating the change record to the target database in response to determining that the target and source database edition levels match; wherein the change record is not propagated in response to determining that the target and source database edition levels are different. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14)
-
-
15. A method for providing consistency of replicated data in a distributed enterprise computing system, the distributed enterprise computing system comprising a plurality of distributed computer systems and including at least one source database and at least one target database, the source database comprising one or more source data objects, and the target database comprising one or more target data objects, the method comprising:
-
assigning an initial edition level to each source data object; storing the edition level of the source data object in a data resource profile of the source data object; updating the edition level of the source data object in response to changes to the source data object; transferring the edition level of each source data object to each related target data object in response to a bulk move of data from the source data object to the related target data objects, wherein said transferring includes storing the edition level of the target data object in a data resource profile of the target data object; wherein the edition level of the source data object and the edition level of the target data object are used to provide consistency of replicated data in the distributed enterprise computing system. - View Dependent Claims (16, 17, 18, 19)
-
-
20. A memory media which stores program instructions for enabling movement of information in a distributed enterprise computing system, the distributed enterprise computing system comprising a plurality of distributed computer systems, wherein the program instructions implement:
-
capturing changed data, wherein the changed data comprises changes being made to a source database; obtaining an edition level value of the source database; creating and storing a change record comprising the captured changed data in a log, wherein the change record includes an edition level value which identifies the edition level of the source database to which the changes are being made; initiating a data propagation operation to one or more target computer systems; obtaining an edition level value of each of the one or more target computer systems; wherein, for each target computer system, the program instructions further implement; comparing the edition level value comprised in the change record with the edition level value of the target computer system, wherein said comparing determines whether the target and source database edition level values match; propagating the change record to the target database in response to determining that the target and source database edition levels match; wherein the change record is not propagated in response to determining that the target and source database edition levels are different. - View Dependent Claims (21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33)
-
-
34. A memory media which stores program instructions for providing consistency of replicated data in a distributed enterprise computing system, the distributed enterprise computing system comprising a plurality of distributed computer systems and including at least one source database and at least one target database, the source database comprising one or more source data objects, and the target database comprising one or more target data objects, wherein the program instructions implement:
-
assigning an initial edition level to each source data object; storing the edition level of the source data object in a data resource profile of the source data object; updating the edition level of the source data object in response to changes to the source data object; transferring the edition level of each source data object to each related target data object in response to a bulk move of data from the source data object to the related target data objects, wherein said transferring includes storing the edition level of the target data object in a data resource profile of the target data object; wherein the edition level of the source data object and the edition level of the target data object are used to provide consistency of replicated data in the distributed enterprise computing system. - View Dependent Claims (35, 36, 37, 38)
-
Specification