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 monitoring usage of a data retrieval point with respect to a defined unit of work. A multilayer feed-forward neural network is used to predict, as a function of training sets composed of historical data generated by the monitored usage of the data retrieval point, a future value of a data size of results from an eager fetch setting for the data retrieval point. The eager fetch is automatically revised to a lazy fetch setting in response to determining that the future data size value of the eager fetch setting results is larger than a permissible memory resource threshold.

主权项

1. A computer-implemented method for automatically selecting fetch settings for business processes as a function of database query load and relational context, the method comprising executing on a processor the steps of:
monitoring usage of at least one data retrieval point with respect to a defined unit of work, wherein the at least one data retrieval point is enabled during a creation of a business process execution language process; using a multilayer feed-forward neural network to predict, as a function of training sets composed of historical data generated by the monitored usage of the at least one data retrieval point, a future value of a data size of results from an eager fetch setting for the at least one data retrieval point; and automatically revising the eager fetch setting for the at least one data retrieval point to a lazy fetch setting in response to determining that the future value of the data size of results from the eager fetch setting is larger than a permissible memory resource threshold.