Patent ID: 11907217
Assignee: SAP SE
Field: Computer technology (Electrical engineering)
Classification: CPC G | IPC G

Claim 19:
20. One or more non-transitory computer-readable media having encoded thereon computer-executable instructions causing one or more processors to perform a method comprising:
receiving a request for a fallback query execution plan of a query in a database system, wherein the query involves a system table in the database system, wherein the system table is paired with a captured table;
evaluating whether the system table and the captured table have the same logical structure;
responsive to an indication that the system table and the captured table have the same logical structure, reusing the fallback query execution plan to execute the query; and
responsive to an indication that the system table and the captured table have different logical structures, rejecting the request for the fallback query execution plan,
wherein the evaluating comprises:
identifying a logical structure of the captured table stored in an object definition table;
obtaining a current logical structure of the system table; and
comparing the logical structure of the captured table with the current logical structure of the system table,

wherein identifying the logical structure of the captured table comprises searching an object mapping table to find a first reference linked to the logical structure of the captured table 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 tables, wherein the object mapping table comprises one or more records containing attributes of the one or more captured tables and references to the logical structures of the one or more captured tables that are stored in the object definition table.