Invention Application
- Patent Title: DATABASE MANAGEMENT SYSTEM QUERY PLAN CACHE MANAGEMENT
-
Application No.: US16567260Application Date: 2019-09-11
-
Publication No.: US20210073232A1Publication Date: 2021-03-11
- Inventor: Sung Gun Lee , Sanghee Lee , Hyung Jo Yoon , Boyeong Jeong
- Applicant: SAP SE
- Applicant Address: DE Walldorf
- Assignee: SAP SE
- Current Assignee: SAP SE
- Current Assignee Address: DE Walldorf
- Main IPC: G06F16/2455
- 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.
Public/Granted literature
- US11036740B2 Database management system query plan cache management Public/Granted day:2021-06-15
Information query