US 8,478,797 B2 · Atomic deletion of database data categories

Abstract

A device maintains, in a database, a plurality of data items, each data item of the plurality of data items being associated with a respective category. The device associates, in the database, a first counter value with each data item, the first counter value indicating a number of times the respective category has been deleted from the database at a time when the data item was stored in the database. The device associates, in the database or another database, a second counter value with the respective category, the second counter value indicating a current value for a number of times the respective category has been deleted from the database. The device selectively deletes, from the database, one or more data items of the plurality of data items from the database based on the first counter values and the second counter value.

Claims20

Dependent claims

A method comprising:

receiving, by a device, a query for a data item;
retrieving, by the device, an item deletion count associated with the data item;
determining, by the device, a category associated with the data item;
retrieving, by the device, a category deletion count associated with the determined category;
comparing, by the device, the retrieved item deletion count and the retrieved category deletion count;
determining, by the device, whether the retrieved item deletion count is greater than or less than the retrieved category deletion count;
retrieving, by the device and when the retrieved item deletion count is greater than the retrieved category deletion count, the data item for collection;
and
hiding, by the device and when the retrieved item deletion count is less than the retrieved category deletion count, the data item from collection.

6 more elements

A non-transitory computer-readable medium storing instructions, the instructions comprising:

one or more instructions which, when executed by at least one processor, cause the at least one processor to:
receive a query for a data item;
retrieve an item deletion count associated with the data item;
determine a category associated with the data item;
retrieve a category deletion count associated with the determined category;
compare the retrieved item deletion count and the retrieved category deletion count;
determine whether the retrieved item deletion count is greater than or less than the retrieved category deletion count;
retrieve, when the retrieved item deletion count is greater than the retrieved category deletion count, the data item for collection;
and
hide, when the retrieved item deletion count is less than the retrieved category deletion count, the data item from collection.

7 more elements

Dependencies are inferred from the claim text.

Atomic deletion of database data categories

Life of this patent

Atomic deletion of database data categories

Life of this patent

Abstract

Claims20