Low-latency method to replace SQL insert for bulk data transfer to relational database
US7305410B2 · kind B2 · utility
Assignee
Inventors
Key dates
| Filing date | Dec 12, 2003 |
| Grant date | Dec 4, 2007 |
| Priority date | — |
| Expiry date | Mar 2, 2025 |
Classification
- Technology area (CPC Y)Emerging Cross-Sectional Technologies
- CPC primaryY10S707/99945
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
The invention is generally directed to a method for efficiently loading bulk data into a relational database with reduced load time. A database with record data loaded therein is provided in a computer's main memory. A coordinating program is invoked as well as a standard load utility program that issues record data input requests, opens record data from external media and loads record data to the database therefrom. With the coordinating program record data input requests made by the load utility from external media are intercepted. Record data input requests from external media are replaced with record data input requests from the computer's main memory. Record data from the computer's main memory is inserted directly into the database by the load utility. As a result, delays encountered by reading of input files on the external media by the load utility are avoided thereby freeing up computer resources.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.