Patent ID: 8538963
Filing Date: 2013-09-17
Classification: G06F,G06N,G06Q

Abstract:
1. A method for automatically selecting optimal fetch settings for each of a plurality of business processes as a function of database query load and relational context, the method comprising: identifying each of a plurality of data retrieval points enabled during a creation of a business process execution language process; determining for each of the respective plurality of data retrieval points via a processor whether data loaded is dependent upon a query result from another query process; automatically selecting an eager fetch setting for each of the plurality of data retrieval points dependent upon the query result from another query process, and selecting a lazy fetch setting for each of the plurality of data retrieval points that are not dependent upon a query result from another query process; monitoring usage of the business process execution language process data retrieval points with respect to a defined unit of work and defining retrieval patterns for each of the data retrieval points as a function of the monitoring; and automatically updating the fetch settings as a function of the defined retrieval patterns by revising each of the selected eager fetch settings for the data retrieval points that have defined retrieval patterns that are larger than a permissible memory resource threshold to lazy fetch settings.