System and method for performance complex heterogeneous database queries using a single SQL expression
US6341277B1 · kind B1 · utility
Assignee
Inventors
Key dates
| Filing date | Apr 9, 1999 |
| Grant date | Jan 22, 2002 |
| Priority date | — |
| Expiry date | Apr 9, 2019 |
Classification
- Technology area (CPC Y)Emerging Cross-Sectional Technologies
- CPC primaryY10S707/99935
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
Query objects are created by a client process. The query objects have one or more sub-query objects and one or more execute methods that are capable of operating on their respective query object to produce one or more query expressions. All of the execute methods are capable of producing the respective query expression that is compatible with a structured query language. A compound query contains one or more boolean expressions of one or more of the query objects. The compound query has one or more compound execute methods which invoke one or more the execute methods of each of the query objects. Each of the execute methods returns their respective query expression and the compound execute method uses one or more common table expressions to combine the query expressions to form a single compound query expression that represents the boolean expression. This single expression can be execute against a database to return a result without executing any of the query expressions against the database individually.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.