Invention Grant
- Patent Title: Customizable filtering for query plan stability in database systems using abstract query plans
-
Application No.: US16835566Application Date: 2020-03-31
-
Publication No.: US11748349B2Publication Date: 2023-09-05
- Inventor: Won Jun Chang , Jaehyok Chong , Sungguk Lim , Youngbin Bok
- Applicant: SAP SE
- Applicant Address: DE Walldorf
- Assignee: SAP SE
- Current Assignee: SAP SE
- Current Assignee Address: DE Walldorf
- Agency: Fish & Richardson P.C.
- Main IPC: G06F16/2453
- IPC: G06F16/2453

Abstract:
Methods, systems, and computer-readable storage media for receiving a query plan and a set of query parameters of the query plan, the query plan corresponding to a query submitted to a database system, and determining that the set of query parameters matches a filter in a set of filters, each parameter in a set of parameters of the filter matching a query parameter in the set of query parameters, and in response: providing the query plan to an abstract query plan generator that generates an abstract query plan based on the query plan, and storing the abstract query plan in an abstract query plan store.
Public/Granted literature
- US20210303571A1 CUSTOMIZABLE FILTERING FOR QUERY PLAN STABILITY IN DATABASE SYSTEMS USING ABSTRACT QUERY PLANS Public/Granted day:2021-09-30
Information query