Structured query language table merging
US7725457B2 · kind B2 · utility
0Cited by
8References
5Claims
0Family size
Assignee
Inventors
Key dates
| Filing date | Dec 19, 2003 |
| Grant date | May 25, 2010 |
| Priority date | — |
| Expiry date | Sep 2, 2024 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/24537
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
A method of modifying a Structured Query Language (SQL) statement in order to reduce the number of joins executed by a database is disclosed. The method includes presenting the SQL statement to the database and identifying joins in the SQL statement for removal in accordance with one or more predetermined criteria. For each identified join, the SQL statement may be modified so as to remove the identified join and to change references to a first instance of a table which is referred to by the identified join to a second instance of the table.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.