Efficient production and consumption for data changes in a database under high concurrency
US11860847B2 · kind B2 · utility
Assignee
Inventor
Key dates
| Filing date | Dec 3, 2020 |
| Grant date | Jan 2, 2024 |
| Priority date | — |
| Expiry date | Dec 30, 2041 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/2308
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
A seed value assigned to a database table is determined. Numerically ordered invocation numbers are determined. Unordered pseudorandom numbers are generated based on the seed value and the invocation numbers to index temporally ordered data changes to the database table. It is determined whether the total number of yet-to-be-saved pseudorandom numbers reaches a maximum total number threshold. If so, the yet-to-be-saved pseudorandom numbers and a sequence of corresponding invocation numbers are saved in a sync table.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.