Optimization of database write operations by combining and parallelizing operations based on a hash value of primary keys
US10664470B1 · kind B1 · utility
Assignee
Inventor
Key dates
| Filing date | Aug 16, 2019 |
| Grant date | May 26, 2020 |
| Priority date | — |
| Expiry date | Aug 16, 2039 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/24561
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
Methods and systems disclosed herein may optimize write operations in a transaction to reduce the number of operations to the point where each of the write operations may be performed in parallel. The writer optimizer may review a first write operation and a second write operation to determine whether the first write operation and the second write operation write to the same row in the same table. When the first write operation and the second write operation write to the same row in the same table, the first write operation and the second write operation may be combined to generate a functionally-equivalent third write operation. The third write operation may reduce the number of operations in the transaction by replacing both the first write operation and the second write operation.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.