Retroreflective join graph generation for relational database queries
US11281671B2 · kind B2 · utility
Assignee
Inventors
Key dates
| Filing date | May 20, 2019 |
| Grant date | Mar 22, 2022 |
| Priority date | — |
| Expiry date | May 5, 2040 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/9024
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
A method, system and computer program product for join graph generation based upon a log of previously executed database queries includes method for generating a join graph for relational database queries. The method includes loading into memory of a computer, a log of a set of database queries previously executed against data in a database and sequentially parsing each of the queries in the log to identify different semantically characterizable components of each of the queries. The method further includes generating a join graph for each of the queries from corresponding ones of the components. Finally, the method includes selectively adding each of the generated join graphs to a set of join graphs in a data model for the data in the database.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.