Optimal persistence of a business process

摘要

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.

主权项

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 plurality of data retrieval points via a processor whether data loaded is dependent upon a query result from another query process, wherein determining that the data loaded is dependent upon a query result from another query process is in response to determining that a task corresponding to the respective data retrieval point always requires at least one additional query to acquire all information needed from a database; the processor automatically selecting an eager fetch setting for each of the plurality of data retrieval points that are determined to be dependent upon a query result from another query process; and the processor automatically selecting a lazy fetch setting for each of the plurality of data retrieval points that are determined to be not dependent upon a query result from another query process.