Database object validation for reusing captured query plans

A computing system, comprising:

• memory;
• one or more hardware processors coupled to the memory;
• and
• one or more computer readable storage media storing instructions that, when loaded into the memory, cause the one or more hardware processors to perform operations 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.

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.