Optimal persistence of a business process

Patent metadata

Field	Value
Publication number	US-9569722-B2
Application number	US-201414514901-A
Country	US
Kind code	B2
Filing date	Oct 15, 2014
Priority date	Nov 16, 2010
Publication date	Feb 14, 2017
Grant date	Feb 14, 2017

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 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.

First claim

What is claimed is:

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…

Assignees

• IBM

Inventors

• Nagpal Abhinay R
• Ramanathan Sri
• Ramesh Sandeep
• Sivakumar Gandhi
• Trevathan Matthew B

Classifications

• G06N3/08

  Physics · mapped topic

• G06N3/09

  Physics · mapped topic

• G06N3/0499

  Physics · mapped topic

• G06Q10/06 Primary

  Physics · mapped topic

• G06F17/3041

  Physics · mapped topic