US 12,282,480 B2
Query performance discovery and improvement
Sheng Yan Sun, Beijing (CN); Peng Hui Jiang, Beijing (CN); Xiao Ming Ma, Xi'an (CN); and Xue Ying Zhang, Xi'an (CN)
Assigned to International Business Machines Corporation, Armonk, NY (US)
Filed by INTERNATIONAL BUSINESS MACHINES CORPORATION, Armonk, NY (US)
Filed on Sep. 6, 2023, as Appl. No. 18/242,704.
Prior Publication US 2025/0077515 A1, Mar. 6, 2025
Int. Cl. G06F 16/2453 (2019.01); G06N 5/022 (2023.01); G06N 20/00 (2019.01)
CPC G06F 16/24542 (2019.01) [G06N 5/022 (2013.01); G06N 20/00 (2019.01)] 20 Claims
OG exemplary drawing
 
1. A computer-implemented method, comprising:
analyzing, by a processor set, a query pattern of an incoming query on a database;
performing, by the processor set, a semantic analysis of the query pattern of the incoming query;
generating, by the processor set, a re-write query that has an improved query performance in comparison to a query performance of the incoming query based on the analyzed query pattern and the semantic analysis;
building, by the processor set, a query model using machine learning based on at least one of the query pattern and the semantic analysis;
applying, by the processor set, the re-write query by performing the re-write query on the database to provide the improved query performance; and
receiving, by the processor set, another re-write query based on a trained external model.