Ranging techniques for efficient cleaning of unneeded row-versions of a database

A device for cleaning unneeded row-versions in a database system comprising:

• one or more processors configured to:
• select eligible row-versions for inspection;
• inspect the selected row-versions, wherein the inspection results in a classification of eligible row-versions as unneeded or reliant;
• mark row-versions classified as unneeded as approved for immediate removal;
• add row-versions classified as reliant to cleaner structures;
• and
• upon detection of removal of all point-in-times (PiTs) related to a reliant row-version, delete the reliant row-version, wherein the detection is performed by monitoring the cleaner structures.

A non-transitory computer-readable medium storing a set of instructions for cleaning unneeded row-versions in a database system, the set of instructions comprising:

• one or more instructions that, when executed by one or more processors of a device, cause the device to:
• select eligible row-versions for inspection;
• inspect the selected row-versions, wherein the inspection results in a classification of eligible row-versions as unneeded or reliant;
• mark row-versions classified as unneeded as approved for immediate removal;
• add row-versions classified as reliant to cleaner structures;
• and
• upon detection of removal of all point-in-times (PiTs) related to a reliant row-version, delete the reliant row-version, wherein the detection is performed by monitoring the cleaner structures.