Patent ID: 8892557

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