Fast batch loading and incremental loading of data into a database
US8165988B2 · kind B2 · utility
31Cited by
4References
3Claims
0Family size
Assignee
Inventors
Key dates
| Filing date | Jan 4, 2011 |
| Grant date | Apr 24, 2012 |
| Priority date | — |
| Expiry date | Jan 4, 2031 |
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.