Synchronization-replication concurrency using non-shared snapshot query on a history table at read-uncommitted isolation level
First Claim
1. A method for synchronization-replication concurrency, comprising:
- maintaining a history table for a data table;
performing replication between a source of the data table and a mirror for a current version of the data table; and
performing synchronization substantially simultaneously to the replication between the mirror and a client for an earlier version of the data table using the history table.
1 Assignment
0 Petitions
Accused Products
Abstract
An improved method and system for synchronization-replication concurrency maintain a history table for a data table in a mirror, where the history table can include redundant version values that indicate a period in which data values corresponding to the version values are valid. Replication can thus be performed between a source and a mirror for a current version of the data table, while synchronization is simultaneously performed between the mirror and a client for an earlier version of the data table using the history table. Simultaneous reads, writes, and read-writes are possible while maintaining data reliability. The replication and synchronization processes can be performed at the read-uncommitted isolation level to increase efficiency. The method and system thus increase overall data throughput, reduce client response time, and dramatically enhance end-user satisfaction.
-
Citations
8 Claims
-
1. A method for synchronization-replication concurrency, comprising:
-
maintaining a history table for a data table;
performing replication between a source of the data table and a mirror for a current version of the data table; and
performing synchronization substantially simultaneously to the replication between the mirror and a client for an earlier version of the data table using the history table. - View Dependent Claims (2, 3)
-
-
4. A system, comprising:
-
a source comprising a data table;
a mirror, wherein a subset of the data table and a history table are stored at the mirror, wherein replication can occur between the source and the mirror for a current version of the data table, wherein synchronization between the mirror and a client can be performed substantially simultaneously to the replication for an earlier version of the data table using the history table. - View Dependent Claims (5)
-
-
6. A computer readable medium with program instructions for synchronization-replication concurrency, comprising:
-
maintaining a history table for a data table;
performing replication between a source of the data table and a mirror for a current version of the data table; and
performing synchronization substantially simultaneously to the replication between the mirror and a client for an earlier version of the data table using the history table. - View Dependent Claims (7, 8)
-
Specification