Patent Document ID: 8825631
Application ID: 13593515

Base Claim:
1. A method for improved processing of structured query language (SQL) queries, the method comprising: parsing, with a query processing computing device, a received SQL query made against a relational database to obtain one or more operators and associated one or more operands and a sequence of execution of the operators; identifying, with the query processing computing device, one or more required closure-friendly operators based on the one or more operators obtained from the SQL query and determining whether each of the closure-friendly operators exist; obtaining, with the query processing computing device, any of the closure-friendly operators determined to exist from a pattern repository; dynamically generating, with the query processing computing device, any of the closure-friendly operators determined not to exist; grouping, with the query processing computing device, the obtained closure-friendly operators and the dynamically generated closure-friendly operators into one or more patterns; classifying, with the query processing computing device, an impact of each of the patterns on at least one of the relational database or a database schema of the relational database; and executing, with the query processing computing device, the SQL query using the patterns based on the sequence of the execution of the operators.

---

Claim 4:
4. The method of claim 1 , further comprising storing, with the query processing computing device, the one or more patterns including the dynamically generated closure-friendly operators in the pattern repository.