US6029178A
Expired / Lapsed
US
⏱️ 0.0 years remaining
Enterprise data movement system and method which maintains and compares edition levels for consistency of replicated data
Assignee: Informatica LLC
•
Filing: 1998-03-31
•
Granted: 2000-02-22
•
Expires: 2018-03-31
Abstract
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.
Inventors
- 👤 James L. Martin
- 👤 Abolfazl Sirjani
- 👤 Kevin D. Seppi
- 👤 Lisa S. Keeler
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-11-08 14:52
CPC Classifications
G; G06; G06F; G06F16/00; G06F16/20; G06F16/27; G06F16/278; Y; Y10; Y10S; Y10S707/00; Y10S707/99931; Y10S707/99933; Y10S707/99951; Y10S707/99952; Y10S707/99953
Claims Analysis
Total Claims: 42
Claim 1
Independent Claim
201 words
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.
Claim 2
Independent Claim
201 words
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.
Claim 3
Dependent Claim
20 words
The method of claim 1, wherein said propagating the change record comprises: applying the change record to the target database.
Claim 4
Dependent Claim
33 words
The method of claim 1, wherein said propagating the change record comprises: moving said change record to the target computer system; and applying the change record to the target database after said moving.
Claim 5
Dependent Claim
43 words
The method of claim 1, wherein said propagating the change record comprises: transforming said changed data comprised in the change record from a source database format to a target database format; and applying the change record to the target database after said moving.
Claim 6
Dependent Claim
52 words
The method of claim 1, wherein said propagating the change record comprises: transforming said changed data comprised in the change record from a source database format to a target database format; moving said change record to the target computer system; and applying the change record to the target database after said moving.
Claim 7
Dependent Claim
57 words
The method of claim 1, wherein the edition level value which identifies an edition level of the source database comprises an edition level value of a source database object; wherein, for one or more of the target computer systems, the edition level of the target computer system comprises an edition level value of a target database object.
Claim 8
Dependent Claim
37 words
The method of claim 1, wherein said obtaining an edition level value of each of the one or more target computer systems is performed prior to the transformation and move components of said propagating the change record.
Claim 9
Dependent Claim
35 words
The method of claim 1, wherein said obtaining an edition level value of each of the one or more target computer systems is performed after the transformation and move components of propagating the change record.
Claim 10
Dependent Claim
33 words
The method of claim 1, wherein, for each target computer system, said obtaining the edition level value of the target computer systems comprises: retrieving the edition level value of the target computer system.
Claim 11
Dependent Claim
29 words
The method of claim 1, wherein, said obtaining the edition level value of the source database comprises: retrieving the edition level value of the source database from a repository.
Claim 12
Dependent Claim
34 words
The method of claim 10, further comprising: performing a recovery operation on the source database; changing the edition level of the source database in the repository in response to said performing said recovery operation.
Claim 13
Dependent Claim
46 words
The method of claim 10, further comprising: changing the edition level of the source database in the repository, wherein said changing is performed in response to one or more of: performing a recovery operation on the source database; and changing the schema in the source database.
Claim 14
Dependent Claim
39 words
The method of claim 1, further comprising: changing the edition level value of the target database in the repository, wherein said changing is performed in response to a bulk data move from a source database to a target database.
Claim 15
Dependent Claim
42 words
The method of claim 1, wherein said comparing the edition level value comprised in the change record with the edition level value of the target computer system determines whether the source database edition level is prior to the target database edition level.
Claim 16
Independent Claim
199 words
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.
Claim 17
Independent Claim
199 words
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.
Claim 18
Dependent Claim
35 words
The method of claim 15, wherein said assigning an initial edition level of the source data object is performed in response to creating a data resource profile for the source data object in a repository.
Claim 19
Dependent Claim
41 words
The method of claim 15, wherein said updating of the edition level of the source data object is performed in response to the following source database changes: changing a schema of the source database; recovering a source data object from backup.
Claim 20
Dependent Claim
37 words
The method of claim 15, wherein said updating of the edition level of the target data object is performed in response to a bulk move of data from the source data object to the target data object.
Claim 21
Dependent Claim
49 words
The method of claim 15, wherein said updating the edition level of the source data object is configurable to automatically trigger a bulk move of information to the target data object(s), wherein the bulk move is configurable to automatically update the edition levels of the related target data objects.
Claim 22
Dependent Claim
212 words
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.
Claim 23
Dependent Claim
212 words
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.
Claim 24
Dependent Claim
21 words
The memory media of claim 20, wherein said propagating the change record comprises: applying the change record to the target database.
Claim 25
Dependent Claim
34 words
The memory media of claim 20, wherein said propagating the change record comprises: moving said change record to the target computer system; and applying the change record to the target database after said moving.
Claim 26
Dependent Claim
44 words
The memory media of claim 20, wherein said propagating the change record comprises: transforming said changed data comprised in the change record from a source database format to a target database format; and applying the change record to the target database after said moving.
Claim 27
Dependent Claim
53 words
The memory media of claim 20, wherein said propagating the change record comprises: transforming said changed data comprised in the change record from a source database format to a target database format; moving said change record to the target computer system; and applying the change record to the target database after said moving.
Claim 28
Dependent Claim
58 words
The memory media of claim 20, wherein the edition level value which identifies an edition level of the source database comprises an edition level value of a source database object; wherein, for one or more of the target computer systems, the edition level of the target computer system comprises an edition level value of a target database object.
Claim 29
Dependent Claim
38 words
The memory media of claim 20, wherein said obtaining an edition level value of each of the one or more target computer systems is performed prior to the transformation and move components of said propagating the change record.
Claim 30
Dependent Claim
36 words
The memory media of claim 20, wherein said obtaining an edition level value of each of the one or more target computer systems is performed after the transformation and move components of propagating the change record.
Claim 31
Dependent Claim
34 words
The memory media of claim 20, wherein, for each target computer system, said obtaining the edition level value of the target computer systems comprises: retrieving the edition level value of the target computer system.
Claim 32
Dependent Claim
34 words
The memory media of claim 20, wherein, said obtaining the edition level value of the source database includes program instructions that implement: retrieving the edition level value of the source database from a repository.
Claim 33
Dependent Claim
39 words
The memory media of claim 29, wherein the program instructions further implement: performing a recovery operation on the source database; changing the edition level of the source database in the repository in response to said performing said recovery operation.
Claim 34
Dependent Claim
51 words
The memory media of claim 29, wherein the program instructions further implement: changing the edition level of the source database in the repository, wherein said changing is performed in response to one or more of: performing a recovery operation on the source database; and changing the schema in the source database.
Claim 35
Dependent Claim
44 words
The memory media of claim 20, wherein the program instructions further implement: changing the edition level value of the target database in the repository, wherein said changing is performed in response to a bulk data move from a source database to a target database.
Claim 36
Dependent Claim
43 words
The memory media of claim 20, wherein said comparing the edition level value comprised in the change record with the edition level value of the target computer system determines whether the source database edition level is prior to the target database edition level.
Claim 37
Dependent Claim
206 words
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.
Claim 38
Dependent Claim
206 words
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.
Claim 39
Dependent Claim
36 words
The memory media of claim 34, wherein said assigning an initial edition level of the source data object is performed in response to creating a data resource profile for the source data object in a repository.
Claim 40
Dependent Claim
42 words
The memory media of claim 34, wherein said updating of the edition level of the source data object is performed in response to the following source database changes: changing a schema of the source database; recovering a source data object from backup.
Claim 41
Dependent Claim
38 words
The memory media of claim 34, wherein said updating of the edition level of the target data object is performed in response to a bulk move of data from the source data object to the target data object.
Claim 42
Dependent Claim
50 words
The memory media of claim 34, wherein said updating the edition level of the source data object is configurable to automatically trigger a bulk move of information to the target data object(s), wherein the bulk move is configurable to automatically update the edition levels of the related target data objects.
References Cited (Backward Citations)
US5274801A
Cited
US5170480A
Cited
US5566332A
Cited
US5287496A
Cited
US5261094A
Cited
US5640561A
Cited
US5627961A
Cited
US5671350A
Cited
US5515502A
Cited
US5613113A
Cited
US5603024A
Cited
US5553279A
Cited
US5440735A
Cited
US5603026A
Cited
US5581754A
Cited
US5577240A
Cited
US5832508A
Cited
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 2003-02-21 | 2003-08-23 | 2004-02-22 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2007-02-21 | 2007-08-23 | 2008-02-22 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2011-02-21 | 2011-08-23 | 2012-02-22 | $7700.00 | Window Closed / Lapsed |