Index updates using parallel and hybrid execution
US9977804B2 · kind B2 · utility
0Cited by
18References
20Claims
0Family size
Assignee
Inventors
Key dates
| Filing date | Jun 1, 2017 |
| Grant date | May 22, 2018 |
| Priority date | — |
| Expiry date | Jun 1, 2037 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/2386
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
A method can include receiving a request to execute a database command identifying a target table; identifying a plurality of rows to insert into the target table based in part on the database command; writing rows, from the plurality of rows, into a data page until the data page is full; determining, by an index thread manager, a number of threads to use for updating indexes defined for the target table; and upon determining the data page is full, updating, in parallel, the indexes defined for the target table using the number of threads.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.