Fast bulk loading and incremental loading of data into a database
US7895151B2 · kind B2 · utility
8Cited by
9References
24Claims
0Family size
Assignee
Inventors
Key dates
| Filing date | Jun 23, 2008 |
| Grant date | Feb 22, 2011 |
| Priority date | — |
| Expiry date | Aug 5, 2029 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/284
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
Embodiments of the present invention provide for batch and incremental loading of data into a database. In the present invention, the loader infrastructure utilizes machine code database instructions and hardware acceleration to parallelize the load operations with the I/O operations. A large, hardware accelerator memory is used as staging cache for the load process. The load process also comprises an index profiling phase that enables balanced partitioning of the created indexes to allow for pipelined load. The online incremental loading process may also be performed while serving queries.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.