Invention Grant
- Patent Title: Retroreflective clustered join graph generation for relational database queries
-
Application No.: US16822620Application Date: 2020-03-18
-
Publication No.: US11269880B2Publication Date: 2022-03-08
- Inventor: Julian Hyde , Jonathan Swenson
- Applicant: Google LLC
- Applicant Address: US CA Mountain View
- Assignee: Google LLC
- Current Assignee: Google LLC
- Current Assignee Address: US CA Mountain View
- Agency: Honigman LLP
- Agent Brett A. Krueger
- Main IPC: G06F16/2452
- IPC: G06F16/2452 ; G06F16/2453 ; G06F16/28 ; G06F16/901

Abstract:
A method, system and computer program product for clustered join graph generation based upon a log of previously executed database queries includes loading into memory of a computer, a log of a set of database queries previously executed against data in a database of the database management system, sequentially parsing each of the queries in the log to identify different semantically characterizable components of each of the queries, generating a join graph for each of the queries from corresponding ones of the components, clustering different generated join graphs according to semantic commonalities so as to form different clusters of join graphs, each for a different semantic commonality, combining the generated join graphs for each cluster into a combined join graph for the corresponding cluster and adding each of the combined join graphs to a set of join graphs in a data model for the data in the database.
Public/Granted literature
- US20200372026A1 RETROREFLECTIVE CLUSTERED JOIN GRAPH GENERATION FOR RELATIONAL DATABASE QUERIES Public/Granted day:2020-11-26
Information query