US Patent Application 17826007. DATABASE OBJECT VALIDATION FOR REUSING CAPTURED QUERY PLANS simplified abstract
Contents
DATABASE OBJECT VALIDATION FOR REUSING CAPTURED QUERY PLANS
Organization Name
Inventor(s)
DATABASE OBJECT VALIDATION FOR REUSING CAPTURED QUERY PLANS - A simplified explanation of the abstract
This abstract first appeared for US patent application 17826007 titled 'DATABASE OBJECT VALIDATION FOR REUSING CAPTURED QUERY PLANS
Simplified Explanation
- The patent application describes a computer implemented method for receiving a request for a fallback query execution plan in a database system. - The method evaluates whether an object in the database system and a captured object have the same logical structure. - If the evaluation indicates that the objects have the same logical structure, the method reuses the fallback query execution plan to execute the query. - The evaluation process involves identifying the logical structure of the captured object stored in an object definition table. - The method also obtains the current logical structure of the object and compares it with the logical structure of the captured object. - The purpose of this method is to optimize query execution by reusing a fallback plan when the object and captured object have the same logical structure.
Original Abstract Submitted
A computer implemented method can receive a request for a fallback query execution plan of a query in a database system. The query involves an object of the database system. The object is associated with a captured object. The method can evaluate whether the object and the captured object have the same logical structure. Responsive to an indication that the object and the captured object have the same logical structure, the method can reuse the fallback query execution plan to execute the query. The evaluating includes 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.