International Business Machines Corporation

Shuanglin Guo

Terence Patrick Purcell

Thomas Abel Beavin

Brandon Jabr

According to an aspect, a computer-implemented method for improving query performance in a databased management system (DBMS) includes receiving, by a query optimizer of the DMBS, a query for execution. The method also includes creating, by the query optimizer, an initial access path for the query based on state and executing the query based on the initial access path. The method further includes observing, by a query agent of the DBMS, the execution of the query and modifying at least one of the state based on a determination by the query agent that a change to the initial access path would improve the execution of the query.

Growing community of inventors

Cupertino, China

Shuanglin Guo