US 11,748,349 B2
Customizable filtering for query plan stability in database systems using abstract query plans
Won Jun Chang, Seoul (KR); Jaehyok Chong, Seoul (KR); Sungguk Lim, Seoul (KR); and Youngbin Bok, Seoul (KR)
Assigned to SAP SE, Walldorf (DE)
Filed by SAP SE, Walldorf (DE)
Filed on Mar. 31, 2020, as Appl. No. 16/835,566.
Prior Publication US 2021/0303571 A1, Sep. 30, 2021
Int. Cl. G06F 16/2453 (2019.01)
CPC G06F 16/24542 (2019.01) 20 Claims
OG exemplary drawing
 
1. A computer-implemented method for selectively providing abstract query plans in database systems, the method being executed by one or more processors and comprising:
receiving, by a query processing system of a database system, a query for execution within a database system;
processing, by a query plan generator of the query processing system, the query to generate an initial query plan;
generating, by a query plan optimizer of the query processing system, a first query plan as an optimization of the initial query plan, the first query plan being executed within the database system to provide a query result;
receiving, by a query plan stability system of the query plan optimizer and in parallel with execution of the first query plan, the first query plan and a first set of query parameters of the first query plan, the first query plan corresponding to a first query submitted to a source database system, the source database system being implemented by a first release of a software; and
determining, by a filter module of the query plan stability system, that the first set of query parameters matches a first filter in a set of filters, each parameter in a first set of parameters of the first filter matching a query parameter in the first set of query parameters, one or more parameters in the first set of query parameters comprising respective predicates as workload management classes for level-wise control of target queries, for which abstract query plans are to be generated, and in response:
providing the first query plan to an abstract query plan generator of the query plan stability system that generates a first abstract query plan based on the first query plan, and
storing the first abstract query plan in an abstract query plan store, the first abstract query plan being executable to recreate a query in a target database system, the target database system being implemented by a second release of the software.