A method and system for detecting conflicts in replicated data in a
database network that includes a plurality of computer systems, each
having a table which includes replicated data includes providing a column
to the table in each system which indicates whether replicated data in
the table is current for the system. The method further includes
determining whether replicated data in the table in the system is current
based on a value in the column when a request to access the replicated
data in the table is received.Through aspects of the method and system of
the present invention, conflict detection is delayed until a request to
access the replicated data in the system is submitted. Thus, no conflict
detection is required during the replication cycle, nor is any conflict
resolution required during the replication cycle. In an environment with
many thousands or millions of rows being replicated, but with few actual
conflicts, delaying the detection and resolution until the system
actually accesses the replicated data greatly improves the overall
performance of the replication environment.