Index updates using parallel and hybrid execution
US9684684B2 · kind B2 · utility
1Cited by
16References
17Claims
0Family size
Assignee
Inventors
Key dates
| Filing date | Jul 8, 2014 |
| Grant date | Jun 20, 2017 |
| Priority date | — |
| Expiry date | Aug 6, 2035 |
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.