INTERACTIVE IDENTIFICATION OF SIMILAR SQL QUERIES

Patent №

US 11,645,294

Granted

2023-05-09

Filed 2020

Owner

CLOUDERA, INC.

Lab

AI components

4

vision · kr · planning · hardware

Assignment

Recorded

Dataset

AIPD

2023_r1 edition

Application

16826113

Systems and methods for very fast grouping of “similar” SQL queries according to user-supplied similarity criteria. The user-supplied similarity criteria include a threshold quantifying the degree of similarity between SQL queries and common artifacts included in the queries. A similarity-characterizing data structure allows for the very fast grouping of “similar” SQL queries. Because the computation is distributed among multiple compute nodes, a small cluster of compute nodes takes a short time to compute the similarity-characterizing data on a workload of tens of millions of queries. The user can supply the similarity criteria through a UI or a command line tool. Furthermore, the user can adjust the degree of similarity by supplying new similarity criteria. Accordingly, the system can display in real time or near real time, updated SQL groupings corresponding to the newly supplied similarity criteria using the originally computed similarity-characterizing data structure.

VisionKnowledge representationPlanningAI hardwareG06F 16/248G06F 16/211G06F 16/2455G06F 16/285G06F 16/86

AI classification

AI hardware1.00
Planning1.00
Vision0.94
Knowledge representation0.91
Natural language0.01
Machine learning0.01
Speech0.00
Evolutionary computation0.00

Ownership

CLOUDERA, INC.

assignment · 522850171

Assignors

PANDIAN, PRITHVIRAJ, AGRAWAL, RITUPARNA, SINGH, ANUPAM

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

© 2026 NYSGPT2525 LLC