IP3 2025 – Improved SQL Query Processing (Lot 12985)

This lot is generally related to database management systems for optimizing various aspects of query execution, database design, and resource management and enhancing the performance of SQL queries against a relational database. Techniques are disclosed to parse the SQL query made against the database to obtain each operator and associated operands, determine the sequence of execution of the operator, and determine the presence of all needed closure-friendly operators. Also disclosed are techniques to dynamically generate all non-available closure-friendly operators that are not available and group the available closure-friendly operators and dynamically generated closure-friendly operators into a pattern. The system queries and classifies relational databases, having each pattern and a database schema, and executes the query based on the sequence of the execution of the operator. The technology may be implemented in RDBMS, database management systems, etc.