公开(公告)号：US20230024210A1

公开(公告)日：2023-01-26

申请号：US17381062

申请日：2021-07-20

Applicant: SAP SE

Inventor： Jaeyeon Won ,  Sung Gun Lee ,  Sanghee Lee ,  Boyeong Jeon ,  Hyung Jo Yoon ,  JunGyoung Seong

IPC: G06F16/2455 ,  G06F16/2453 ,  G06F11/34

Abstract: A computer-implemented method can measure query locality during execution of a plurality of incoming queries in a database management system. The database management system includes a query execution plan cache which has a size that can store at least some of query execution plans generated for the plurality of incoming queries. Based on the measured query locality, the method can adjust the size of the query execution plan cache.

公开(公告)号：US11567938B1

公开(公告)日：2023-01-31

申请号：US17381062

申请日：2021-07-20

Applicant: SAP SE

Inventor： Jaeyeon Won ,  Sung Gun Lee ,  Sanghee Lee ,  Boyeong Jeon ,  Hyung Jo Yoon ,  JunGyoung Seong

IPC: G06F16/245 ,  G06F16/2455 ,  G06F16/2453

Abstract: A computer-implemented method can measure query locality during execution of a plurality of incoming queries in a database management system. The database management system includes a query execution plan cache which has a size that can store at least some of query execution plans generated for the plurality of incoming queries. Based on the measured query locality, the method can adjust the size of the query execution plan cache.

公开(公告)号：US20230021502A1

公开(公告)日：2023-01-26

申请号：US17381059

申请日：2021-07-20

Applicant: SAP SE

Inventor： Jaeyeon Won ,  Sung Gun Lee ,  Sanghee Lee ,  Boyeong Jeon ,  Hyung Jo Yoon ,  JunGyoung Seong

IPC: G06F16/2453

Abstract: A method for intelligent query plan cache size management can be implemented. During execution of a plurality of incoming queries in a database management system, the method can measure actual compilation times of generating query execution plans for the plurality of incoming queries. The database management system can have a query execution plan cache which has a size that can store at least some of the query execution plans. The method can monitor differences between the actual compilation times and ideal compilation times of generating query execution plans for the plurality of incoming queries. The ideal compilation times can be estimated by assuming no query execution plan is evicted from the query execution plan cache. The method can adjust the size of the query execution plan cache based on the monitored differences.

公开(公告)号：US20240232196A1

公开(公告)日：2024-07-11

申请号：US18616771

申请日：2024-03-26

Applicant: SAP SE

Inventor： Jaeyeon Won ,  Sung Gun Lee ,  Sanghee Lee ,  Boyeong Jeon ,  Hyung Jo Yoon ,  JunGyoung Seong

IPC: G06F16/2453

CPC classification number: G06F16/24542 ,  G06F16/24539

Abstract: A method for intelligent query plan cache size management can be implemented. The method measures actual compilation times of generating query execution plans for a plurality of incoming queries. At least some of the query execution plans are stored in a query execution plan cache. The method can estimate ideal compilation times of generating the query execution plans for the plurality of incoming queries under an assumption that no query execution plan is evicted from the query execution plan cache, monitor differences between the actual compilation times and the ideal compilation times in continuous time windows, and adjust a size of the query execution plan cache in runtime based on the monitored differences.

公开(公告)号：US11971889B2

公开(公告)日：2024-04-30

申请号：US17381059

申请日：2021-07-20

Applicant: SAP SE

Inventor： Jaeyeon Won ,  Sung Gun Lee ,  Sanghee Lee ,  Boyeong Jeon ,  Hyung Jo Yoon ,  JunGyoung Seong

IPC: G06F16/2453

CPC classification number: G06F16/24542 ,  G06F16/24539

Abstract: A method for intelligent query plan cache size management can be implemented. During execution of a plurality of incoming queries in a database management system, the method can measure actual compilation times of generating query execution plans for the plurality of incoming queries. The database management system can have a query execution plan cache which has a size that can store at least some of the query execution plans. The method can monitor differences between the actual compilation times and ideal compilation times of generating query execution plans for the plurality of incoming queries. The ideal compilation times can be estimated by assuming no query execution plan is evicted from the query execution plan cache. The method can adjust the size of the query execution plan cache based on the monitored differences.