Patent US5799321A successfully refreshed from Google Patents.
← Back to Patent Explorer
US5799321A Expired / Lapsed US ⏱️ 0.0 years remaining

Replicating deletion information using sets of deleted record IDs

Assignee: Microsoft Technology Licensing LLC
•
Filing: 1996-07-12
•
Granted: 1998-08-25
•
Expires: 2016-07-12
📄 Original PDF 🌐 Google Patents 🔄 Sync Now

Abstract

Abstract Deleted database records are identified not by the use of tombstones (pairs of record IDs and change numbers) but by storing for each database replica a set of deleted record IDs without associated change numbers (DRID data). The DRID data can include not only IDs of deleted records but also IDs that were never assigned to the database by the server (e.g., IDs assigned to records of other databases). The DRID data can be compactly stored as a list of intervals, with each interval describing a range of IDs across which records have either been deleted or never assigned to the database. Replication is accomplished by periodically sending the DRID data, or incremental versions thereof, to other replicas, which delete records identified by the received DRID data, and update their existing DRID data by combining it with received DRID data.

Inventors

  • 👤 Max L. Benson

Bibliographic Details

Application Number —
Jurisdiction US
Data Source google_patents
Last Synchronized 2026-11-04 23:05
CPC Classifications
G; G06; G06F; G06F16/00; G06F16/20; G06F16/27; Y; Y10; Y10S; Y10S707/00; Y10S707/99951; Y10S707/99952; Y10S707/99953

Claims Analysis

Total Claims: 16
Claim 1
Independent Claim 145 words
A method of reducing storage requirements when replicating information regarding deleted records in a distributed network of replicas, wherein records in the replicas have unique record identification numbers, the method comprising the steps of: storing at a first replica a first set of deleted record identification (DRID) numbers that identify records deleted from the first replica, the first set of DRID numbers being stored without associated change numbers; modifying the first set of DRID numbers by adding new record identification numbers to the first set of DRID numbers to identify additional records, without associated change numbers, for newly deleted records from the first replica; and replicating information regarding deleted records to other replicas by sending to said other replicas information corresponding to the modified first set of DRID numbers stored in the first replica in order to thereby reduce storage requirements for representing deleted records.
Claim 2
Independent Claim 145 words
A method of reducing storage requirements when replicating information regarding deleted records in a distributed network of replicas, wherein records in the replicas have unique record identification numbers, the method comprising the steps of: storing at a first replica a first set of deleted record identification (DRID) numbers that identify records deleted from the first replica, the first set of DRID numbers being stored without associated change numbers; modifying the first set of DRID numbers by adding new record identification numbers to the first set of DRID numbers to identify additional records, without associated change numbers, for newly deleted records from the first replica; and replicating information regarding deleted records to other replicas by sending to said other replicas information corresponding to the modified first set of DRID numbers stored in the first replica in order to thereby reduce storage requirements for representing deleted records.
Claim 3
Dependent Claim 38 words
The method of claim 1 wherein the first set of DRID numbers is represented by a list of intervals, each interval describing a range of record identification numbers that have been deleted from a replica of the database.
Claim 4
Dependent Claim 36 words
The method of claim 2 wherein the first set of DRID numbers includes not only numbers of records deleted from the database but also numbers assigned for purposes other than to identify records in the database.
Claim 5
Dependent Claim 94 words
The method of claim 1 wherein a second set of DRID numbers is stored in conjunction with the first set of DRID numbers, wherein the second set of DRID numbers represents the record identification numbers appearing in the first set of DRID numbers that have previously been sent to other replicas, and wherein the information sent to other replicas corresponding to the modified first set of DRID numbers comprises incremental sets of DRID numbers each incremental set representing the difference between the first set of DRID numbers and the second set of DRID numbers.
Claim 6
Dependent Claim 62 words
The method of claim 1 wherein a third set of record identification numbers is stored for each replica, the third set containing record identification numbers for records contained in the replica, and wherein during a replication the information corresponding to DRID numbers received from other replicas are compared to the third set to determine whether records in the replica should be deleted.
Claim 7
Dependent Claim 55 words
The method of claim 3 wherein the record identification numbers comprise a computer identification number and a unique serial number assigned by the computer on which the record was created, wherein at least some of the serial numbers assigned by the computer are assigned for purposes other than to identify records created in the database.
Claim 8
Dependent Claim 37 words
The method of claim 6 wherein a block of the serial numbers are assigned to the database to permit contiguous serial numbers to be assigned to a plurality of records created in the database by that computer.
Claim 9
Dependent Claim 195 words
A computer program product for use in a computer system that employs a method for replicating information regarding deleted records in a distributed network of replicas, wherein records in the replicas have unique record identification numbers, the computer program product comprising: a computer-readable medium for carrying computer program code means used for operating said computer system to employ said method for replicating information regarding deleted records, and computer program code means comprising: program code means for storing at a first replica a first set of deleted record identification (DRID) numbers that identify records deleted from the first replica, the first set of DRID numbers being stored without associated change numbers; program code means for modifying the first set of DRID numbers by adding new record identification numbers to the first set of DRID numbers to identify additional records, without associated change numbers, for newly deleted records from the first replica; and program code means for replicating information regarding deleted records to other replicas by sending to said other replicas information corresponding to the modified first set of DRID numbers stored in the first replica in order to thereby reduce storage requirements for representing deleted records.
Claim 10
Dependent Claim 195 words
A computer program product for use in a computer system that employs a method for replicating information regarding deleted records in a distributed network of replicas, wherein records in the replicas have unique record identification numbers, the computer program product comprising: a computer-readable medium for carrying computer program code means used for operating said computer system to employ said method for replicating information regarding deleted records, and computer program code means comprising: program code means for storing at a first replica a first set of deleted record identification (DRID) numbers that identify records deleted from the first replica, the first set of DRID numbers being stored without associated change numbers; program code means for modifying the first set of DRID numbers by adding new record identification numbers to the first set of DRID numbers to identify additional records, without associated change numbers, for newly deleted records from the first replica; and program code means for replicating information regarding deleted records to other replicas by sending to said other replicas information corresponding to the modified first set of DRID numbers stored in the first replica in order to thereby reduce storage requirements for representing deleted records.
Claim 11
Dependent Claim 40 words
The computer program product of claim 8 wherein the first set of DRID numbers is represented by a list of intervals, each interval describing a range of record identification numbers that have been deleted from a replica of the database.
Claim 12
Dependent Claim 38 words
The computer program product of claim 9 wherein the first set of DRID numbers includes not only numbers of records deleted from the database but also numbers assigned for purposes other than to identify records in the database.
Claim 13
Dependent Claim 96 words
The computer program product of claim 8 wherein a second set of DRID numbers is stored in conjunction with the first set of DRID numbers, wherein the second set of DRID numbers represents the record identification numbers appearing in the first set of DRID numbers that have previously been sent to other replicas, and wherein the information sent to other replicas corresponding to the modified first set of DRID numbers comprises incremental sets of DRID numbers each incremental set representing the difference between the first set of DRID numbers and the second set of DRID numbers.
Claim 14
Dependent Claim 64 words
The computer program product of claim 8 wherein a third set of record identification numbers is stored for each replica, the third set containing record identification numbers for records contained in the replica, and wherein during a replication the information corresponding to DRID numbers received from other replicas are compared to the third set to determine whether records in the replica should be deleted.
Claim 15
Dependent Claim 55 words
The computer program of claim 10 wherein the record identification numbers comprise a computer identification number and a unique serial number assigned by the computer on which the record was created, wherein at least some of the serial numbers assigned by the computer are assigned for purposes other than identifying records created in the database.
Claim 16
Dependent Claim 38 words
The computer program of claim 13 wherein a block of the serial numbers are assigned to the database to permit contiguous serial numbers to be assigned to a plurality of records created in the database by that computer.

References Cited (Backward Citations)

US4714995A Cited
US4714992A Cited
US4714996A Cited
US5247676A Cited
US5218699A Cited
US5261094A Cited
US5283856A Cited
US5577240A Cited
US5649195A Cited

USPTO Annuity & Maintenance Windows

Annuity Stage Window Opens Payment Deadline Surcharge Period Until Estimated Fee Status
3.5 Years (Year 4) 2001-08-24 2002-02-23 2002-08-25 $2000.00 Window Closed / Lapsed
7.5 Years (Year 8) 2005-08-24 2006-02-23 2006-08-25 $3760.00 Window Closed / Lapsed
11.5 Years (Year 12) 2009-08-24 2010-02-23 2010-08-25 $7700.00 Window Closed / Lapsed

Assigned Categories & Tags

No categories assigned to this patent yet.

Assign Category Tag