Patent ID: 8620862

Claim:
A computer-implemented method of processing base level data of a change queue in which an order of the data is not serialized at a logical level due to multi-threading in one or more extractors, communication channels or appliers, the base level change queue data being transaction data previously posted to a source database, the method comprising: (a) providing a logical replication engine which uses multi-threading in the one or more extractors, communication channels or appliers to replicate and post the base level change queue data to a target database in the order that the transaction data is stored in the change queue; and (b) upon detection in the logical replication engine of base level change queue data in which the order of the base level change queue data is not serialized at the logical level due to the multi-threading in the one or more extractors, communication channels or appliers, serializing the order of the base level change queue data at the logical level before the logical replication engine applies the base level change queue data to the target database, which ensures referential integrity, including resolving required foreign keys, and preserving required intra- and inter-transaction dependencies, in the target database.