Data processing: database and file management or data structures – Database design – Data structure types
Reexamination Certificate
2007-12-04
2007-12-04
Pannala, Sathyanarayan (Department: 2164)
Data processing: database and file management or data structures
Database design
Data structure types
C707S793000, C707S793000
Reexamination Certificate
active
10735533
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.
REFERENCES:
patent: 4506326 (1985-03-01), Shaw et al.
patent: 5280583 (1994-01-01), Nakayama et al.
patent: 5642505 (1997-06-01), Fushimi
patent: 5644763 (1997-07-01), Roy
patent: 5706494 (1998-01-01), Cochrane et al.
patent: 5842196 (1998-11-01), Agarwal et al.
patent: 5873075 (1999-02-01), Cochrane et al.
patent: 5956706 (1999-09-01), Carey et al.
patent: 5974407 (1999-10-01), Sacks
patent: 6029163 (2000-02-01), Ziauddin
patent: 6219660 (2001-04-01), Haderie et al.
patent: 6353833 (2002-03-01), Bird et al.
patent: 6385604 (2002-05-01), Bakalash et al.
patent: 6421658 (2002-07-01), Carey et al.
patent: 6427143 (2002-07-01), Isip, Jr. et al.
patent: 6438536 (2002-08-01), Edwards et al.
patent: 6442543 (2002-08-01), Snodgrass et al.
patent: 6453314 (2002-09-01), Chan et al.
patent: 6456995 (2002-09-01), Salo et al.
patent: 6470354 (2002-10-01), Aldridge et al.
patent: 6735597 (2004-05-01), Paradies
patent: 2002/0052868 (2002-05-01), Mohindra et al.
patent: 2002/0073089 (2002-06-01), Schwartz
patent: 2002/0129035 (2002-09-01), Hayes et al.
patent: 2002/0174103 (2002-11-01), Hsiao et al.
patent: 2003/0154098 (2003-08-01), Kalnas et al.
patent: 2004/0225745 (2004-11-01), Carroll et al.
Bartholf Paul
Skopec Michael
Barlow, Josephs & Holmes Ltd
Pannala Sathyanarayan
Rocket Software, Inc.
LandOfFree
Low-latency method to replace SQL insert for bulk data... does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with Low-latency method to replace SQL insert for bulk data..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Low-latency method to replace SQL insert for bulk data... will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-3897393