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:
Nov. 18, 2014
Filed:
Aug. 23, 2013
International Business Machines Corporation, Armonk, NY (US);
Abhinay R. Nagpal, Pune, IN;
Sri Ramanathan, Lutz, FL (US);
Sandeep Ramesh, Pune, IN;
Gandhi Sivakumar, Victoria, AU;
Matthew B. Trevathan, Roswell, GA (US);
International Business Machines Corporation, Armonk, NY (US);
Abstract
Aspects of the invention provide for automatically selecting optimal fetch settings for business processes as a function of database query load and relational context by determining whether data loaded for data retrieval points is dependent upon a query result from another query process and automatically selecting an eager fetch setting if dependent upon a query result from another query process, or a lazy fetch setting if not. Usage of the data retrieval points is monitored with respect to defined units of work to define retrieval patterns and automatically update the fetch settings, including by revising selected eager fetch settings to lazy fetch settings if a data size of a defined retrieval pattern is larger than a permissible memory resource threshold.