公开(公告)号：US11775488B2

公开(公告)日：2023-10-03

申请号：US17699747

申请日：2022-03-21

Applicant: SAP SE

Inventor： Panfeng Zhou ,  Vivek Kandiyanallur ,  Colin Florendo ,  Robert Schulze ,  Zheng-Wei She ,  Yanhong Wang ,  Amarnadh Sai Eluri

IPC: G06F16/00 ,  G06F16/21 ,  G06F16/22 ,  G06N5/04

CPC classification number: G06F16/213 ,  G06F16/221 ,  G06F16/2255 ,  G06N5/04

Abstract: System, method, and various embodiments for providing a data access and recommendation system are described herein. An embodiment operates by identifying a column access of one or more data values of a first column of a plurality of columns of a table of a database during a sampling period. A count of how many of the one or more data values are accessed during the column access are recorded. A first counter is incremented by the count. The sampling period is determined to have expired. A load recommendation on how to load data values into the first column based on the first counter is computed. The load recommendation for implementation into the database for one or more subsequent column accesses is provided.

公开(公告)号：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.

公开(公告)号：US11442862B2

公开(公告)日：2022-09-13

申请号：US16850310

申请日：2020-04-16

Applicant: SAP SE

Inventor： Robert Schulze ,  Adrian Dragusanu ,  Anup Ghatage ,  Colin Florendo ,  Mihnea Andrei ,  Randall Hammon ,  Sarika Iyer ,  Simhachala Sasikanth Gottapu ,  Yanhong Wang

IPC: G06F12/08 ,  G06F12/0862 ,  G06F12/0882 ,  G06F16/24 ,  G06F16/22

Abstract: Disclosed herein are system, method, and computer program product embodiments for performing fair prefetching. An embodiment operates by splitting a data vector into a first subrange and a second subrange. The embodiment performs a first chance prefetch operation on the first subrange based on a fixed number of pages, thereby loading a set of pages of the first subrange into a main memory. The embodiment performs the first chance prefetch operation on the second subrange based on the fixed number of pages, thereby loading a first set of pages of the second subrange into the main memory. The embodiment performs a second chance prefetch operation on the second subrange based on the performing the first chance prefetch operation on the second subrange, thereby loading a second set of pages of the second subrange into the main memory. The embodiment then executes the query.

公开(公告)号：US11308047B2

公开(公告)日：2022-04-19

申请号：US16816511

申请日：2020-03-12

Applicant: SAP SE

Inventor： Panfeng Zhou ,  Vivek Kandiyanallur ,  Colin Florendo ,  Robert Schulze ,  Zheng-Wei She ,  Yanhong Wang ,  Amarnadh Sai Eluri

IPC: G06F16/00 ,  G06F16/21 ,  G06F16/22 ,  G06N5/04

Abstract: System, method, and various embodiments for providing a data access and recommendation system are described herein. An embodiment operates by identifying a column access of one or more data values of a first column of a plurality of columns of a table of a database during a sampling period. A count of how many of the one or more data values are accessed during the column access are recorded. A first counter, corresponding to the first column and stored in a distributed hash table, is incremented by the count. The sampling period is determined to have expired. A load recommendation on how to load data values into the first column based on the first counter is computed. The load recommendation for implementation into the database for one or more subsequent column accesses is provided.

公开(公告)号：US20210286777A1

公开(公告)日：2021-09-16

申请号：US16816511

申请日：2020-03-12

Applicant: SAP SE

Inventor： PANFENG ZHOU ,  Vivek Kandiyanallur ,  Colin Florendo ,  Robert Schulze ,  Zheng-wei She ,  Yanhong Wang ,  Amarnadh Sai Eluri

IPC: G06F16/21 ,  G06F16/22 ,  G06N5/04

Abstract: System, method, and various embodiments for providing a data access and recommendation system are described herein. An embodiment operates by identifying a column access of one or more data values of a first column of a plurality of columns of a table of a database during a sampling period. A count of how many of the one or more data values are accessed during the column access are recorded. A first counter, corresponding to the first column and stored in a distributed hash table, is incremented by the count. The sampling period is determined to have expired. A load recommendation on how to load data values into the first column based on the first counter is computed. The load recommendation for implementation into the database for one or more subsequent column accesses is provided.