Query generator
US7814090B2 · kind B2 · utility
Assignee
Inventors
Key dates
| Filing date | May 31, 2005 |
| Grant date | Oct 12, 2010 |
| Priority date | — |
| Expiry date | May 26, 2026 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/24535
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
A query generator for generating a query for retrieving data from a database comprising at least one table is disclosed. The query refers to one or more data items in a first view defined to expose a portion of the database and to one or more data items that are not exposed by the first view, at least one of which has an associated reach through flag set thereby defining it as a reach through item. The query generator is adapted to: receive user input indicating selected items to be retrieved from the database; ascertain whether any of the selected items that are not exposed by the first view are defined as reach through items; and, if so: create a second view that is a copy of the first view and add a copy of each reach through item to it; and create a query that refers only to the second view and the items exposed by it.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.