Data integrity in a database environment through background synchronization
First Claim
Patent Images
1. A method for ensuring data integrity in a database environment, the method comprising:
- maintaining metadata indicating a row condition state of each respective row of remote data from a remote database system prior to initiating a process for synchronization of the remote data from the remote database system with consolidated data of a consolidated database, wherein the remote data comprises a subset of the consolidated data, the row condition state indicating whether said each row is included in the synchronization;
upon initiating the process for synchronization, creating a snapshot including the remote data to be uploaded to the consolidated database as determined based on the row condition state of each row as maintained prior to the initiating the process for synchronization; and
wherein the synchronization is based on the snapshot and allows transactional access and updates to the remote data included in the synchronization to occur while the synchronization occurs, wherein the updates are not included in the snapshot, and wherein the consolidated database includes the consolidated data synchronized with the remote data of the snapshot upon a completion of the synchronization.
2 Assignments
0 Petitions
Accused Products
Abstract
Systems, methods and computer program products for maintaining data integrity in a database environment are described. In operation, a synchronization process is initiated in a remote database system for synchronization of remote data from the remote database system with consolidated data of a consolidated database. Metadata for each row of the remote data is utilized to allow transactional access to the remote data while the synchronization process occurs.
21 Citations
21 Claims
-
1. A method for ensuring data integrity in a database environment, the method comprising:
-
maintaining metadata indicating a row condition state of each respective row of remote data from a remote database system prior to initiating a process for synchronization of the remote data from the remote database system with consolidated data of a consolidated database, wherein the remote data comprises a subset of the consolidated data, the row condition state indicating whether said each row is included in the synchronization; upon initiating the process for synchronization, creating a snapshot including the remote data to be uploaded to the consolidated database as determined based on the row condition state of each row as maintained prior to the initiating the process for synchronization; and wherein the synchronization is based on the snapshot and allows transactional access and updates to the remote data included in the synchronization to occur while the synchronization occurs, wherein the updates are not included in the snapshot, and wherein the consolidated database includes the consolidated data synchronized with the remote data of the snapshot upon a completion of the synchronization. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9)
-
-
10. A system for ensuring data integrity in a database environment, the system comprising:
-
a database manager coupled to a communication network and including a consolidated database, wherein the database manager is configured to perform a data synchronization process and maintain metadata indicating a row condition state of each respective row of remote data from at least one remote database system coupled to the communication network prior to initiating a process for synchronization of the remote data from the at least one remote database with consolidated data of the consolidated database, the row condition state indicating whether said each row is included in a synchronization, and the process comprising; upon initiating the process for synchronization, creating a snapshot including the remote data to be uploaded to the consolidated database as determined based on the row condition state of each row as maintained prior to the initiating the process for synchronization, and wherein the synchronization is based on the snapshot and allows transactional access and updates to the remote data included in the synchronization to occur while the synchronization occurs, wherein the updates are not included in the snapshot, and wherein the consolidated database includes the consolidated data synchronized with the remote data of the snapshot upon a completion of the synchronization. - View Dependent Claims (11, 12, 13, 14, 15)
-
-
16. A computer program product comprising a non-transitory computer useable medium having computer program logic recorded thereon for enabling a processor to perform instructions to determine data integrity in a database environment, the instructions comprising:
-
instructions for enabling a processor to maintain metadata indicating a row condition state of each respective row of remote data from a remote database prior to initiating a process for synchronization of the remote data with consolidated data of a consolidated database, the row condition state indicating whether said each row is included in the synchronization; instructions for enabling a processor to, upon initiating the process for synchronization, create a snapshot including the remote data to be uploaded to the consolidated database as determined based on the row condition state of each row as maintained prior to the initiating the process for synchronization; and instructions for enabling a processor to perform the synchronization of the consolidated database with the remote data based on the snapshot, wherein the synchronization allows transactional access and updates to the remote data included in the synchronization to occur while the synchronization occurs, wherein the updates are not included in the snapshot, and wherein the consolidated database includes the consolidated data synchronized with the remote data of the snapshot upon a completion of the synchronization. - View Dependent Claims (17, 18, 19, 20, 21)
-
Specification