Invention Grant
US07149759B2 Method and system for detecting conflicts in replicated data in a database network 失效
用于检测数据库网络中复制数据中的冲突的方法和系统

Method and system for detecting conflicts in replicated data in a database network
Abstract:
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.
Information query
Patent Agency Ranking
0/0