公开(公告)号：US11249962B2

公开(公告)日：2022-02-15

申请号：US16411869

申请日：2019-05-14

Applicant: SAP SE

Inventor： Panfeng Zhou ,  Xu-Dong Qian ,  Yanhong Wang ,  Shyam Sunder Reddy Avula ,  Amarnadh Sai Eluri ,  Chirag Samtani

IPC: G06F16/21 ,  G06F16/185 ,  G06F11/34 ,  G06F16/242

Abstract: Disclosed herein are systems, methods, and devices for providing load unit recommendations. An example method includes 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. Subsequently, the method includes 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. The load unit indicates whether to load the whole database object, or only a portion thereof, into a main memory of the DBMS while accessing the database object.