SAP SE
LOAD UNIT RECOMMENDATION SYSTEM

Abstract:

Disclosed herein are system, method, and device embodiments for providing load unit recommendations. An embodiment operates by monitoring queries executed by a database management system including a database object, determining an access frequency of the database object based upon the monitoring, and determining relative access counter information for the database object based on the access frequency. Some embodiments may further operate by generating a sorted element based on the relative access counter information, determining threshold values based on threshold information and the sorted element, and determining a load unit for the database object based on the sorted element and the threshold values, wherein the load unit may indicate whether to load the whole database object into main memory of the DBMS while accessing the database object or only load a portion of the database object into main memory of the DBMS when accessing the database object.