Extensible handling of new or modified data within an independent distributed database system
First Claim
1. A computer readable storage medium comprising instructions that, when executed by a processor, cause the processor to perform a method comprising:
- indicating user data in a local database is candidate data in response to that user data being created, deleted, or modified, wherein the local database is in a distributed database system and the distributed database system also comprises a candidate data resolving site;
detecting the candidate data and transmitting the candidate data to the candidate data resolving site;
receiving, at the local database from the candidate data resolving site, a sequence of operations in a resolution script, wherein the sequence of operations is determined by the candidate data resolving site, and the determined sequence of operations are for promoting the candidate data to approved for replication status;
processing the candidate data within the local database pursuant to the resolution script to modify the local database by executing the resolution script to make changes required to approve the candidate data for replication; and
replicating approved candidate data to another database in the distributed database system, and not replicating rejected candidate data.
5 Assignments
0 Petitions
Accused Products
Abstract
Newly added, deleted, or changed data of a local storage in a distributed database system is prevented from being replicated until it has been approved via a specific process. Any new, deleted, or changed records are initially marked as being candidate data. The normal replication processing within the distributed database system ignores such data. In this way, the candidate data is not allowed to leave its source site, and potentially contaminate the rest of the replication network, until that data has been approved. The approval process is provided by a candidate data scanner that detects the candidate data and provides it to a candidate data resolver for processing. The candidate data resolver is architected to provide for per installation extensibility.
-
Citations
23 Claims
-
1. A computer readable storage medium comprising instructions that, when executed by a processor, cause the processor to perform a method comprising:
-
indicating user data in a local database is candidate data in response to that user data being created, deleted, or modified, wherein the local database is in a distributed database system and the distributed database system also comprises a candidate data resolving site; detecting the candidate data and transmitting the candidate data to the candidate data resolving site; receiving, at the local database from the candidate data resolving site, a sequence of operations in a resolution script, wherein the sequence of operations is determined by the candidate data resolving site, and the determined sequence of operations are for promoting the candidate data to approved for replication status; processing the candidate data within the local database pursuant to the resolution script to modify the local database by executing the resolution script to make changes required to approve the candidate data for replication; and replicating approved candidate data to another database in the distributed database system, and not replicating rejected candidate data. - View Dependent Claims (2, 3, 4, 5, 6, 7, 19)
-
-
8. A method for processing candidate data in a distributed database system, comprising:
-
indicating user data in a local database is candidate data in response to that user data being created, deleted, or modified; detecting the candidate data at a candidate data scanner module; transmitting the candidate data to a candidate data resolver module; at the candidate data resolver module, determining a sequence of operations in a resolution script, wherein the determined sequence of operations are for promoting the candidate data to approved for replication status; processing the candidate data within the local database pursuant to the resolution script, thereby modifying the local database by executing the resolution script to make changes required to approve the candidate data for replication; and replicating approved candidate data to another database in the distributed database system, and not replicating rejected candidate data. - View Dependent Claims (9, 10, 11, 12, 13, 14)
-
-
15. A system including a processor and a memory for processing candidate data in a distributed database system comprising a local database and a candidate data resolving site, the system, comprising:
-
a change capture mechanism indicating user data in a local database is candidate data in response to that user data being created, deleted, or modified; a candidate data scanner for receiving, at the local database from the candidate data resolving site, a sequence of operations in a resolution script, wherein the sequence of operations is determined by the candidate data resolving site and the determined sequence of operations are for promoting the candidate data to approved for replication status, and processing the candidate data within the local database pursuant to the resolution script by executing the resolution script to make changes required to approve the candidate data for replication; and a replication engine for replicating approved candidate data to another database in the distributed database system, and not replicating rejected candidate data. - View Dependent Claims (16, 17, 18, 20, 21, 22, 23)
-
Specification