METHOD FOR HIGH PERFORMANCE OPTIMISTIC ITEM LEVEL REPLICATION

A method, article, and system for rapidly replicating a data record change in a database while minimizing the need for the database servers to negotiate what data will be replicated, by allowing the source server to independently decide what changes the destination server requires. The minimization of the required negotiations between servers results in a reduction in Central Processor Unit (CPU) utilization and provides improved CPU availability, improved network bandwidth, and a lower end-to-end replication delay. For replication to detect what items have changed, each data record must be associated with a sequence number to identify the number of changes that have occurred to the data record since it was created.