Patent ID: 8380663

Claim:
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.