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

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