Resumes
Resumes
Michael Skopec Phones & Addresses
-
Harrison, ID
-
Woodridge, IL
-
Coeur d Alene, ID
-
Lemont, IL
-
3150 Cannonball Trl, Yorkville, IL 60560 (630) 882-8278
-
31504 Cannonball Trl, Yorkville, IL 60560 (630) 882-8278
-
Bristol, IL
-
Montgomery, IL
-
Kootenai, ID
Publications
Us Patents
Low-Latency Method To Replace Sql Insert For Bulk Data Transfer To Relational Database
View pageUS Patent:
20040128299, Jul 1, 2004
Filed:
Dec 12, 2003
Appl. No.:
10/735533
Inventors:
Michael Skopec - Montgomery IL, US
Paul Bartholf - Joliet IL, US
Paul Bartholf - Joliet IL, US
International Classification:
G06F017/00
US Classification:
707/100000
Abstract:
The invention is generally directed to a novel and unique method for loading bulk data into a relational database. A database with record data loaded therein is provided in a computer's main memory. A coordinating program in 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 is avoided thereby making the bulk loading of data into a database more efficient by reducing load time and freeing up computer resources.