The patent badge is an abbreviated version of the USPTO patent document. The patent badge does contain a link to the full patent document.
The patent badge is an abbreviated version of the USPTO patent document. The patent badge covers the following: Patent number, Date patent was issued, Date patent was filed, Title of the patent, Applicant, Inventor, Assignee, Attorney firm, Primary examiner, Assistant examiner, CPCs, and Abstract. The patent badge does contain a link to the full patent document (in Adobe Acrobat format, aka pdf). To download or print any patent click here.
Patent No.:
Date of Patent:
Oct. 12, 2010
Filed:
May. 31, 2005
Jitendra Dhamija, Karnataka, IN;
Suresh Mali, Bangalore, IN;
Christopher Evans, Bristol, GB;
Paolo Fragapane, Bristol, GB;
James Steadman, Bath, GB;
Andrew Osborn, Bristol, GB;
Jitendra Dhamija, Karnataka, IN;
Suresh Mali, Bangalore, IN;
Christopher Evans, Bristol, GB;
Paolo Fragapane, Bristol, GB;
James Steadman, Bath, GB;
Andrew Osborn, Bristol, GB;
Oracle International Corporation, Redwood Shores, CA (US);
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.