Composable SQL query generation
US8645346B2 · kind B2 · utility
17Cited by
7References
20Claims
0Family size
Assignee
Inventors
Key dates
| Filing date | Jun 16, 2011 |
| Grant date | Feb 4, 2014 |
| Priority date | — |
| Expiry date | Nov 23, 2031 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/2452
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
A system and method for facilitating querying one or more data sources. A system provides mechanisms to enable flexible specification of user queries and generation of one or more SQL queries that correspond closely to corresponding user queries. An operator tree and a logical operator tree may be created as intermediate steps to generate the one or more SQL queries. Capabilities of data sources are determined and used to generate remotable SQL queries for composable queries, to reduce an amount of post-processing that is performed on result sets. The system enables user queries that extend beyond those defined by a data model.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.