The patent badge is an abbreviated version of the USPTO patent document. The patent badge does contain a link to the full patent document.
The patent badge is an abbreviated version of the USPTO patent document. The patent badge covers the following: Patent number, Date patent was issued, Date patent was filed, Title of the patent, Applicant, Inventor, Assignee, Attorney firm, Primary examiner, Assistant examiner, CPCs, and Abstract. The patent badge does contain a link to the full patent document (in Adobe Acrobat format, aka pdf). To download or print any patent click here.
Patent No.:
Date of Patent:
May. 22, 2012
Filed:
Feb. 05, 2008
Jeffrey A. Berger, San Jose, CA (US);
You-chin Fuh, San Jose, CA (US);
Yue Huang, San Jose, CA (US);
Hong Min, Poughkeepsie, NY (US);
Terence P. Purcell, Springfield, IL (US);
Kou-horng A. Yang, Saratoga, CA (US);
Jeffrey A. Berger, San Jose, CA (US);
You-Chin Fuh, San Jose, CA (US);
Yue Huang, San Jose, CA (US);
Hong Min, Poughkeepsie, NY (US);
Terence P. Purcell, Springfield, IL (US);
Kou-Horng A. Yang, Saratoga, CA (US);
International Business Machines Corporation, Armonk, NY (US);
Abstract
A method, system, and computer program product are provided for retrieving records into a main memory. A first number of gaps and a first total gap size are received for a list of records from a database subsystem. A determination is made of a first average gap size using the first number of gaps and the first total gap size. A determination is made as to whether the first average gap size is greater than a prestaging threshold value. Responsive to the first average gap size being equal to or less than the prestaging threshold value, a prestaging flag is set for the list of records. Then, the list of records is retrieved into the main memory using prestaging.