Run-time decision of bulk insert for massive data loading
US9665612B2 · kind B2 · utility
0Cited by
14References
20Claims
0Family size
Assignee
Inventors
Key dates
| Filing date | May 29, 2014 |
| Grant date | May 30, 2017 |
| Priority date | — |
| Expiry date | Jul 28, 2034 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/2372
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
A method can include initiating execution of a database command, the database command associated with a base table with at least one row to copy to a target table, the database command associated with a non-bulk insert mode; making a run-time decision on whether to automatically convert the insert mode from the non-bulk insert mode to a BULK insert mode based on the number of row buffers filled with rows from the base table during execution of the database command; and inserting at least one row into the target table using an insert mode based on the run-time decision.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.