Automated latency-aware purging of database records
US12026175B1 · kind B1 · utility
Assignee
Inventors
Key dates
| Filing date | Dec 22, 2022 |
| Grant date | Jul 2, 2024 |
| Priority date | — |
| Expiry date | Dec 22, 2042 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/2365
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
Methods and apparatuses are described for automated latency-aware purging of database records. A server determines a synchronization latency between a storage database and an online transaction processing (OLTP) database. When the synchronization latency is below a predetermined threshold, the server identifies a first database object in the OLTP database and selects database records to be purged from the first database object based upon a data purge instruction set. The server identifies a second database object in the storage database that corresponds to the first database object and selects database records in the second database object based upon the data purge instruction set. The server purges the database records from the first database object in the OLTP database when a characteristic of the database records to be purged from the first database object matches a characteristic of the database records selected in the second database object.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.