公开(公告)号：US20210073232A1

公开(公告)日：2021-03-11

申请号：US16567260

申请日：2019-09-11

Applicant: SAP SE

Inventor： Sung Gun Lee ,  Sanghee Lee ,  Hyung Jo Yoon ,  Boyeong Jeong

IPC: G06F16/2455 ,  G06F16/28 ,  G06F16/2453

Abstract: According to some embodiments, a system to manage a query plan cache for a Database Management System (“DBMS”) includes a DBMS query plan cache data store. The DBMS query plan cache data store may contain, for example, electronic records representing a plurality of query plans each associated with a set of instructions created in response to a query previously submitted by a user. A DBMS query plan cache management platform may then calculate a utility score for each query plan in the DBMS query plan cache data store. At least one query plan may be evicted from the DBMS query plan cache data store based on the calculated utility score, wherein the evicting is not based on a size of the DBMS query plan cache.

公开(公告)号：US11036740B2

公开(公告)日：2021-06-15

申请号：US16567260

申请日：2019-09-11

Applicant: SAP SE

Inventor： Sung Gun Lee ,  Sanghee Lee ,  Hyung Jo Yoon ,  Boyeong Jeong

IPC: G06F16/30 ,  G06F16/2455 ,  G06F16/2453 ,  G06F16/28

Abstract: According to some embodiments, a system to manage a query plan cache for a Database Management System (“DBMS”) includes a DBMS query plan cache data store. The DBMS query plan cache data store may contain, for example, electronic records representing a plurality of query plans each associated with a set of instructions created in response to a query previously submitted by a user. A DBMS query plan cache management platform may then calculate a utility score for each query plan in the DBMS query plan cache data store. At least one query plan may be evicted from the DBMS query plan cache data store based on the calculated utility score, wherein the evicting is not based on a size of the DBMS query plan cache.