Lost write detection and repair

Details Lost write detection and repair Lost write detection and repair

2005-03-03

2009-12-01

Jalil, Neveen Abel (Department: 2165)

Data processing: database and file management or data structures

Database design

Data structure types

Reexamination Certificate

active

07627614

ABSTRACT:
Techniques are provided for detecting lost writes so that data corruption can be avoided. According to one technique, lost writes are detected by comparing version numbers that are indicated in redo log entries with version numbers that are indicated in corresponding blocks in a standby database. According to one technique, which may be used in conjunction with the above technique, lost writes are detected by logging read operations that occur relative to a primary database, and comparing version numbers that are indicated in read log entries with version numbers that are indicated in corresponding blocks in a standby database. According to one technique, lost writes are detected by comparing, in response to read operations, (a) version numbers that are stored in a persistent in-memory cache with (b) version numbers that are indicated in corresponding blocks that are read from a primary database.

REFERENCES:
patent: 4507751 (1985-03-01), Gawlick et al.
patent: 4710926 (1987-12-01), Brown et al.
patent: 4945474 (1990-07-01), Elliott et al.
patent: 5146571 (1992-09-01), Logan
patent: 5182752 (1993-01-01), DeRoo et al.
patent: 5233618 (1993-08-01), Glider et al.
patent: 5327556 (1994-07-01), Mohan et al.
patent: 5329628 (1994-07-01), Yamamoto et al.
patent: 5418940 (1995-05-01), Mohan
patent: 5581754 (1996-12-01), Terry et al.
patent: 5588012 (1996-12-01), Oizumi
patent: 5696775 (1997-12-01), Nemazie et al.
patent: 5717893 (1998-02-01), Mattson
patent: 5734898 (1998-03-01), He
patent: 5805799 (1998-09-01), Fredrickson et al.
patent: 5870763 (1999-02-01), Lomet
patent: 5893930 (1999-04-01), Song
patent: 5960436 (1999-09-01), Chang et al.
patent: 6009542 (1999-12-01), Koller et al.
patent: 6067550 (2000-05-01), Lomet
patent: 6094708 (2000-07-01), Hilla et al.
patent: 6098190 (2000-08-01), Rust et al.
patent: 6151607 (2000-11-01), Lomet
patent: 6272500 (2001-08-01), Sugita
patent: 6298425 (2001-10-01), Whitaker et al.
patent: 6324661 (2001-11-01), Gerbault et al.
patent: 6438724 (2002-08-01), Cox et al.
patent: 6446234 (2002-09-01), Cox et al.
patent: 6449623 (2002-09-01), Bohannon et al.
patent: 6535869 (2003-03-01), Housel, III
patent: 6560743 (2003-05-01), Plants
patent: 6728879 (2004-04-01), Atkinson
patent: 6732125 (2004-05-01), Autrey et al.
patent: 7149858 (2006-12-01), Kiselev
patent: 7246275 (2007-07-01), Therrien et al.
patent: 7257689 (2007-08-01), Baird
patent: 2002/0049950 (2002-04-01), Loaiza et al.
patent: 2002/0091718 (2002-07-01), Bohannon et al.
patent: 2003/0061537 (2003-03-01), Cha et al.
patent: 2003/0140288 (2003-07-01), Loaiza et al.
patent: 2006/0242513 (2006-10-01), Loaiza et al.
patent: 0 503 417 (1992-09-01), None
patent: 59-081940 (1984-05-01), None
patent: 02-189663 (1990-07-01), None
patent: 08-235032 (1996-09-01), None
patent: 10-040122 (1998-02-01), None
patent: 10-240575 (1998-09-01), None
Written Opinion from PCT for foreign patent application No. PCT/US03/09063, dated May 24, 2004 (11 pgs.)—attached.
Current Claims in PCT patent application No. PCT/US03/09063 (10 pgs.)—attached.
Antoni Cau, et al., “Specifying Fault Tolerance within Stark's Formalism,” 1993, IEEE, pp. 392-401.
IBM Corp., “IBM OS/2 Extended Edition Configuration,” Feb. 1990, IBM Technical Disclosure Bulletin, vol. 32, No. 9B, pp. 446-451.
International Searching Authority, “Notification of Transmittal of the International Search Report or the Declaration,” Jun. 10, 2004, 9 pages.
Current claims in PCT patent application, International Application No. PCT/US01/49760, 13 pages.
Japanese Patent Office, “Notice of Grounds of Rejection”, Patent Application No. 558135-2002, received Apr. 4, 2008, 2 pages.
Claims, Patent Application No. 558135-2002, 9 pages.
Canadian Intellectual Property Office, Office Action, foreign application No. 2,482,891, received May 16, 2008, 8 pages.
Claims, foreign application No. 2,482,891, 6 pages.
Japanese Patent Office, “Office Action”, Foreign application No. PCT/US03/09063, dated Aug. 4, 2008, 12 pages.
Claims, Foreign application No. PCT/US03/09063, 11 pages.
India Patent Office, “Office Action”, foreign application No. 1574/KOLNP/04, received Sep. 2, 2008, 1 page.
Claims, foreign application No. 1574/K0LNP/04, 12 pages.

Affiliated with

Also associated with

Rating

Lost write detection and repair does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Lost write detection and repair, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Lost write detection and repair will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-4135583