Query generator

Details Query generator Query generator

2005-05-31

2010-10-12

Cottingham, John R. (Department: 2167)

Data processing: database and file management or data structures

Database and file access

Query optimization

Reexamination Certificate

active

07814090

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.

REFERENCES:
patent: 5345585 (1994-09-01), Iyer et al.
patent: 5537590 (1996-07-01), Amado
patent: 5557791 (1996-09-01), Cheng et al.
patent: 5666525 (1997-09-01), Ross
patent: 5751949 (1998-05-01), Thomson et al.
patent: 5797136 (1998-08-01), Boyer et al.
patent: 5907846 (1999-05-01), Berner et al.
patent: 5991754 (1999-11-01), Raitto et al.
patent: 6226637 (2001-05-01), Carey et al.
patent: 6282547 (2001-08-01), Hirsch
patent: 6289335 (2001-09-01), Downing et al.
patent: 6374263 (2002-04-01), Bunger et al.
patent: 6477525 (2002-11-01), Bello et al.
patent: 6477527 (2002-11-01), Carey et al.
patent: 6484162 (2002-11-01), Edlund et al.
patent: 6629094 (2003-09-01), Colby et al.
patent: 6718320 (2004-04-01), Subramanian et al.
patent: 6885990 (2005-04-01), Ohmori et al.
patent: 7158994 (2007-01-01), Smith et al.
patent: 7181435 (2007-02-01), Cambot et al.
patent: 7225189 (2007-05-01), McCormack et al.
patent: 2001/0051949 (2001-12-01), Carey et al.
patent: 2002/0010695 (2002-01-01), Kearsey et al.
patent: 2002/0095405 (2002-07-01), Fujiwara
patent: 2003/0046639 (2003-03-01), Fai et al.
patent: 2003/0069877 (2003-04-01), Grefenstette et al.
patent: 2004/0220911 (2004-11-01), Zuzarte et al.
patent: 2004/0225666 (2004-11-01), Hinshaw et al.
patent: 2005/0038673 (2005-02-01), Stookey et al.
patent: 2005/0091253 (2005-04-01), Cragun et al.
patent: 2006/0004794 (2006-01-01), Pizzo et al.
patent: 2006/0036568 (2006-02-01), Moore et al.
patent: 2007/0203933 (2007-08-01), Iversen et al.
patent: 2007/0219951 (2007-09-01), Ahmed et al.
patent: 2007/0239744 (2007-10-01), Bruno et al.
patent: 2008/0034283 (2008-02-01), Gragun et al.

Affiliated with

Also associated with

Rating

Query generator does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Query generator, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Query generator will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-4236715