Atomic deletion of database data categories
View Patent ↗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.
1. 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.
2. The method of claim 1 , where, when determining the category associated with the data item, the method further comprises:
determining the category associated with the data item by extracting data related to the data item, or
determining the category associated with the data item by calculating a function of the data item.
3. The method of claim 1 , where, when determining the category associated with the data item, the method further comprises:
determining the category based on a publish request received from another device, the publish request including:
a publisher identifier that identifies the other device.
4. The method of claim 3 , further comprising:
using the publisher identifier as the category.
5. The method of claim 1 , further comprising:
determining whether the retrieved item deletion count is equal to the retrieved category deletion count; and
retrieving, when the retrieved item deletion count is equal to the retrieved category deletion count, the data item.
6. The method of claim 1 , where, when hiding the data item, the method further comprises:
marking the data item as non-retrievable.
7. A device comprising:
a 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.
8. The device of claim 7 , where, when determining the category associated with the data item, the processor is further to:
determine the category associated with the data item by extracting data related to the data item, or
determine the category associated with the data item by calculating a function of the data item.
9. The device of claim 7 , where, when determining the category associated with the data item, the processor is further to:
determine the category based on a publish request received from another device, the publish request including:
a publisher identifier that identifies the other device.
10. The device of claim 9 , where the processor is further to:
use the publisher identifier as the category.
11. The device of claim 7 , where the processor is further to:
determine whether the retrieved item deletion count is equal to the retrieved category deletion count; and
retrieve, when the retrieved item deletion count is equal to the retrieved category deletion count, the data item for collection.
12. The device of claim 9 , where, when hiding the data item, the processor is further to:
mark the data item as non-retrievable.
13. 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.
14. The non-transitory computer-readable medium of claim 13 , where the one or more instructions to determine the category associated with the data item further include:
one or more instructions which, when executed by the at least one processor, cause the at least one processor to:
determine the category associated with the data item by extracting data related to the data item, or
determine the category associated with the data item by calculating a function of the data item.
15. The non-transitory computer-readable medium of claim 13 , where the one or more instructions to determine the category associated with the data item further include:
one or more instructions which, when executed by the at least one processor, cause the at least one processor to:
extract the category based on a publish request received from another device, the publish request including:
a publisher identifier that identifies the other device.
16. The non-transitory computer-readable medium of claim 15 , where the instructions further comprise:
one or more instructions which, when executed by the at least one processor, cause the at least one processor to:
use the publisher identifier as the category.
17. The non-transitory computer-readable medium of claim 13 , where the instructions further comprise:
one or more instructions which, when executed by the at least one processor, cause the at least one processor to:
determine whether the retrieved item deletion count is equal to the retrieved category deletion count; and
retrieve, when the retrieved item deletion count is equal to the retrieved category deletion count, the data item for collection.
18. The non-transitory computer-readable medium of claim 13 , where the one or more instructions to hide the data item further include:
one or more instructions which, when executed by the at least one processor, cause the at least one processor to:
mark the data item as non-retrievable.
19. The method of claim 1 , further comprising:
providing the retrieved item to another device,
the other device transmitting the query.
20. The device of claim 7 , where the processor is further to:
provide the retrieved item to another device,
the other device transmitting the query.