Patent ID: 8768904
Filing Date: 2014-07-01
Classification: G06F

Abstract:
1. A computer-implemented method for intelligent open query cursor management, comprising the steps of: opening a query cursor for use within a first job; detecting whether the open query cursor was previously requested for use within another job, wherein the step of detecting whether the open query cursor was previously requested for use within another job includes the steps of: if the open query cursor was previously requested for use within another job, intelligently managing the query cursor for subsequent use within a different job, wherein the step of intelligently managing the query cursor for subsequent use within a different job includes either the step of recycling the open query cursor for subsequent use within the different job or the step of pre-building the query cursor before it is requested for subsequent use within the different job, and wherein the step of intelligently managing the query cursor for subsequent use within a different job further includes the step of periodically rechecking the log to see if the saved query cursor or the pre-built query cursor continues to be requested at the predetermined threshold level, wherein the step of determining whether the log indicates that the open query cursor has been requested at a predetermined threshold level includes the step of determining if the open query cursor was requested at least a predetermined number of times within a predetermined period of time and/or the open query cursor was requested at least a predetermined percentile with respect to a total sample of requests.