The patent badge is an abbreviated version of the USPTO patent document. The patent badge does contain a link to the full patent document.

The patent badge is an abbreviated version of the USPTO patent document. The patent badge covers the following: Patent number, Date patent was issued, Date patent was filed, Title of the patent, Applicant, Inventor, Assignee, Attorney firm, Primary examiner, Assistant examiner, CPCs, and Abstract. The patent badge does contain a link to the full patent document (in Adobe Acrobat format, aka pdf). To download or print any patent click here.

Date of Patent:
Jul. 22, 2025

Filed:

Aug. 29, 2022
Applicant:

Kinaxis Inc., Ottawa, CA;

Inventors:

Angela Lin, Ottawa, CA;

Dylan Ellicott, Ottawa, CA;

Marin Creanga, Ottawa, CA;

Assignee:

Kinaxis Inc., Ottawa, CA;

Attorney:
Primary Examiner:
Int. Cl.
CPC ...
G06F 7/00 (2006.01); G06F 16/22 (2019.01); G06F 16/23 (2019.01);
U.S. Cl.
CPC ...
G06F 16/2386 (2019.01); G06F 16/22 (2019.01); G06F 16/2343 (2019.01); G06F 16/2358 (2019.01);
Abstract

Systems and methods for efficient bulk data deletion. The system comprises: 1) a deletion record set; an in-memory database representation comprising: tables and records; one or more exclusive locks for the records; and a record block index; 2) a persistent database representation comprising: record blocks; and a transaction log. The method comprises: receiving, by a processor, a deletion record set; acquiring, by the processor, an exclusive lock for one or more records in the deletion record set; deleting, by the processor, the deletion record set from an in-memory representation of the database; generating, by the processor, one or more post-delete record block sets; updating, by the processor, an in-memory record block index; writing, by the processor, the one or more post-delete record block sets to a persistent storage representation of the database; and, adding, by the processor, a transaction log entry for the record block index update.


Find Patent Forward Citations

Loading…