HYBRID OPTIMIZATION STRATEGIES IN AUTOMATIC SQL TUNING

Patent №

US 7,979,422

Granted

2011-07-12

Filed 2008

Owner

ORACLE INTERNATIONAL CORPORATION

Lab

AI components

5

ml · nlp · planning · evo · hardware

Assignment

Recorded

Dataset

AIPD

2023_r1 edition

Application

12221131

Systems, methods, and other embodiments associated with hybrid optimization strategies in automatic SQL tuning are described. One example method includes receiving a first (e.g., cost-based) execution plan for a user structured query language statement (User SQL) from a first (e.g., cost-based) optimizer. The example method may also include receiving a second (e.g., rules-based) execution plan for the User SQL from a second, different (e.g., rules-based) query optimizer. The method may include identifying a preferred execution plan based on data produced by test executing the execution plans in a reproduced execution environment that reproduces at least a portion of an execution environment in which the user SQL runs. The method may also include controlling a database to execute the User SQL using the preferred execution plan.

AI classification

Natural language1.00
Planning1.00
AI hardware0.97
Evolutionary computation0.67
Machine learning0.57
Knowledge representation0.38
Vision0.00
Speech0.00

Ownership

ORACLE INTERNATIONAL CORPORATION

assignment · 217080237

Assignors

BELKNAP, PETER, YAGOUB, KHALED, DIAS, KARL, DAGEVILLE, BENOIT, CRUANES, THIERRY, SINGH, ANUPAM

On an employer assignment, the assignors are typically the inventors.

© 2026 NYSGPT2525 LLC