Data processing: database and file management or data structures – Database design – Data structure types
Reexamination Certificate
2006-12-12
2006-12-12
Corrielus, Jean M. (Department: 2162)
Data processing: database and file management or data structures
Database design
Data structure types
C707S793000, C707S793000, C707S793000
Reexamination Certificate
active
07149759
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.
REFERENCES:
patent: 4432057 (1984-02-01), Daniell et al.
patent: 4631673 (1986-12-01), Haas et al.
patent: 5261094 (1993-11-01), Everson et al.
patent: 5333265 (1994-07-01), Orimo et al.
patent: 5737601 (1998-04-01), Jain et al.
patent: 5790117 (1998-08-01), Halviatti et al.
patent: 5806074 (1998-09-01), Souder et al.
patent: 5806075 (1998-09-01), Jain et al.
patent: 6002871 (1999-12-01), Duggan et al.
patent: 6058401 (2000-05-01), Stamos et al.
patent: 6088706 (2000-07-01), Hild
patent: 6122630 (2000-09-01), Strickler et al.
patent: 6167534 (2000-12-01), Straathof et al.
patent: 6233623 (2001-05-01), Jeffords et al.
patent: 6484109 (2002-11-01), Lofall
patent: 2002/0124006 (2002-09-01), Parnell et al.
patent: 0716385 (1996-06-01), None
patent: 09244933 (1997-09-01), None
patent: 2000047919 (2000-02-01), None
patent: 9735270 (1997-09-01), None
Brietbart, Yuri et al., “Replication and Consistency: Being Lazy Helps Sometimes,” PODS, 1997, pp. 173-184. (Note: To Correct Typographical Error. Applicant Previously Enclosed Copy on Mar. 25, 2002).
Bernstein, Philip A. et al., “Concurrency Control in Distributed Database Systems,” Computing Surveys, vol. 13, No. 2, Jun. 1981, pp. 185-221.
Breithart, Yuri et al., “Replication and Consistency: Being Lazy Helps Sometimes,” PODS, 1997, pp. 173-184.
Carey, Michael J. et al., Conflict Detection Tradeoffs for Replicated Data, ACM Transactions on Database Systems, vol. 16, No. 4, Dec. 1991, pp. 703-746.
Cowan, Crispin, “Optimistic Replication in HOPE,” Computer Science Department, Middlesex College, University of Western Ohio, London, Ontario, pp. 1-22.
Gray, Jim et al, “The Dangers of Replicaiton and a Solution,” SIGMOD, Jun. 1996, pp. 173-182.
Helal, Abdelsalam A. et al., “Replication Techniques in Distributed Systems,” Kluwer Academic Publishers, 1996, pp. 53-58.
Howard, John et al., “Reconciliations,” PODC, Aug. 1994, pp. 14-21.
Corrielus Jean M.
International Business Machines - Corporation
Sawyer Law Group LLP
LandOfFree
Method and system for detecting conflicts in replicated data... does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with Method and system for detecting conflicts in replicated data..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Method and system for detecting conflicts in replicated data... will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-3705515