IP Library Granted Patent US 11,615,068
Granted Patent B2
US 11,615,068 · App. 15/618,117 · Granted Mar 28, 2023

Methods and systems of managing deletes in a database node of a NoSQL database

Inventors: Brian J. Bulkowski (Menlo Park, CA); Andrew Gooding (Mountain View, CA); Venkatachary Srinivasan (Sunnyvale, CA)
G06F16/2365G06F11/14
View Patent ↗
Loading inventors, assignments & file history…
Monitor This Case
Get email alerts when status or documents change.
Order Certified Copies
Most orders are placed with the USPTO same day — all within 24 business hours.
Order via The Patent Place →
Pre-filled with this patent's details
Quick Facts
Patent No.
US 11,615,068
App. No.
15/618,117
Granted
Mar 28, 2023
Kind
B2
Abstract

In one aspect, a computerized method for managing tombstones in a node of a Distributed Database Base System (DDBS) includes the step of providing a rule that, for a namespace in a record of the node of the DDBS that allows expiration, mandates that a later generation's expiration time of the namespace never decreases. The computerized method includes the step of determining that an administrator of the DDBS has set an expiration time of the namespace to infinity. The computerized method includes the step of implementing a background process of the DDBS, wherein the background process scans a DDBS node's drive and flags a set of extant tombstones that are no longer covering viable namespaces or viable records. The computerized method includes the step of deleting all the flagged tombstones.

Claims (29)

1. A computerized method for managing deletes in a node of a Distributed Database Base System (DDBS) comprising:

providing a rule that, for a namespace in a record of the node of the DDBS that allows expiration, mandates that a later generation's expiration time of the namespace never decreases, wherein the DDBS comprises a NoSQL DDBS;

determining that an administrator of the DDBS has set an expiration time of a tombstone associated with a deleted record to infinity;

implementing a background process of the DDBS, wherein the background process scans a DDBS node's drive and flags a set of extant tombstones that are no longer covering viable namespaces or viable records, and wherein the background process is implemented without redirection pointers; and

deleting all the flagged tombstones, and

wherein a subsequent generation of the namespace in the record cannot have a shorter time to live (TTL) than its previous version in a Multiversion concurrency control (MVCC) chain, and the MVCC chain is used to track a current version of the record and determine deleted and/or expired versions, and

wherein the tombstone is written with a same expiration time as a namespace the tombstone covers such that all of a plurality of deleted records expire together, wherein the TTL is provided for the deleted record, and wherein the tombstone is used to indicate the deleted record.

2. The computerized method of claim 1 , wherein the MVCC chain comprises a concurrency control method that can be used by a database management system of the NoSQL DDBS to provide a concurrent access to the NoSQL DDBS.

3. A computerized system for managing deletes in one or more nodes of a Distributed Database Base System (DDBS) comprising:

a processor configured to execute instructions;

a memory including instructions when executed on the processor causes the processor to perform operations that:

provide a rule that, for a namespace in a record of a node in the one or more nodes of the DDBS that allows expiration, mandates that a later generation's expiration time of the namespace never decreases, wherein the DDBS comprises a NoSQL DDBS;

determine that an administrator of the DDBS has set an expiration time of a tombstone associated with a deleted record to infinity;

implement a background process of the DDBS, wherein the background process scans a DDBS node's drive and flags a set of extant tombstones that are no longer covering viable namespaces or viable records, and wherein the background process is implemented without redirection pointers; and

delete all the flagged tombstones, and

wherein a subsequent generation of the namespace in the record cannot have a shorter time to live (TTL) than its previous version in a Multiversion concurrency control (MVCC) chain,

use the MVCC chain to track a current version of the record and determine deleted and expired versions, and

wherein the tombstone is written with a same expiration time as a namespace the tombstone covers such that all of a plurality of deleted records expire together, wherein the TTL is provided for the deleted record, and wherein the tombstone is used to indicate the deleted record.

4. The computerized system of claim 3 , wherein the MVCC chain comprises a concurrency control method that can be used by a database management system of the NoSQL DDBS to provide a concurrent access to the NoSQL DDBS.

5. A computerized method for managing a node of a Distributed Database Base System (DDBS) comprising:

using a Multiversion concurrency control (MVCC) chain to track a current version of a record and determine deleted and expired versions, wherein a subsequent generation of a namespace in the record cannot have a shorter time to live ( 1 IL) than its previous version in the MVCC chain;

creating a later generation of the record;

setting an expiration time of the later generation of the record;

determining that the expiration time of the later generation of the record is equal to or greater than a previous generation's expiration time;

determining that an administrator of the DDBS has set an expiration time of a tombstone associated with a deleted record of the node of the DDBS to infinity;

implementing a background process of the DDBS, wherein the background process scans a DDBS node's drive and flags a set of extant tombstones that are no longer covering viable namespaces or viable records, and wherein the background process is implemented without redirection pointers; and

deleting all the flagged tombstones.

6. The computerized method of claim 5 , wherein the tombstone is written with a same expiration time as a namespace the tombstone covers such that all of a plurality of deleted records expire together.

7. The computerized method of claim 6 further comprising: providing a rule that, for a namespace in the record that allows expiration, mandates that a later generation's expiration time of the namespace never decreases.

Assignments (4)
SECURITY INTEREST Recorded Sep 4, 2024
From: AEROSPIKE, INC.
To: CANADIAN IMPERIAL BANK OF COMMERCE, AS ADMINISTRATIVE AGENT
Reel/Frame 068479/0616 →
RELEASE OF SECURITY INTEREST Recorded Aug 27, 2024
From: ACQUIOM AGENCY SERVICES LLC
To: AEROSPIKE, INC.
Reel/Frame 068408/0094 →
SECURITY INTEREST Recorded Dec 29, 2021
From: AEROSPIKE, INC.
To: ACQUIOM AGENCY SERVICES LLC
Reel/Frame 058502/0586 →
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Apr 15, 2019
From: BULKOWSKI, BRIAN J.; GOODING, ANDREW; SRINIVASAN, VENKATACHARY
To: AEROSPIKE INC.
Reel/Frame 048887/0920 →
Continuity (2)
Provisional Application 62347245 · Jun 8, 2016
Related Publication 20170357687A1 · Dec 14, 2017