US 11,907,217 B2
Database object validation for reusing captured query plans
Youngbin Bok, Seoul (KR); Won Jun Chang, Seoul (KR); and Jaehyok Chong, Seoul (KR)
Assigned to SAP SE, Walldorf (DE)
Filed by SAP SE, Walldorf (DE)
Filed on May 26, 2022, as Appl. No. 17/826,007.
Prior Publication US 2023/0385276 A1, Nov. 30, 2023
Int. Cl. G06F 16/2453 (2019.01)
CPC G06F 16/24542 (2019.01) 20 Claims
OG exemplary drawing
 
1. A computer-implemented method comprising:
receiving a request for a fallback query execution plan of a query in a database system, wherein the query involves an object of the database system, wherein the object is associated with a captured object;
evaluating whether the object and the captured object have the same logical structure; and
responsive to an indication that the object and the captured object have the same logical structure, reusing the fallback query execution plan to execute the query,
wherein the evaluating comprises:
identifying a logical structure of the captured object stored in an object definition table;
obtaining a current logical structure of the object; and
comparing the logical structure of the captured object with the current logical structure of the object,
wherein identifying the logical structure of the captured object comprises searching an object mapping table to find a first reference linked to the logical structure of the captured object stored in the object definition table,
wherein the logical structure of the captured object is based on a definition statement of the captured object using a captured version of the definition statement,
wherein the object definition table stores logical structures of one or more captured objects, wherein the object mapping table comprises one or more records containing attributes of the one or more captured objects and references to the logical structures of the one or more captured objects stored in the object definition table.