Method and system for constructing queries

Details Method and system for constructing queries Method and system for constructing queries

1998-11-04

2000-01-18

Amsbury, Wayne

Data processing: database and file management or data structures

Database design

Data structure types

G06F 1730

Patent

active

060164883

ABSTRACT:
These and other objects, which will be apparent as the invention is more fully described, are provided by a method and system for constructing queries which make changes to an entire set of data stored in a database. In a preferred embodiment of the present invention, a user selects one or more tables from which to construct a query. Next, the system stores a list box for each selected table. Each list box is displayed on a user interface including a query window which includes an upper portion and a lower portion. The user selects one or more columns from the list boxes and drags the selected columns into a QBE grid located in the lower portion of the query window. The QBE grid provides a graphical representation of the query requested by the user. When the user invokes the query, the system determines the query type and performs appropriate action on the selected column from the selected tables.

REFERENCES:
patent: 4805099 (1989-02-01), Huber
patent: 5121477 (1992-06-01), Koopmans et al.
patent: 5392390 (1995-02-01), Crozier
patent: 5418950 (1995-05-01), Li et al.
patent: 5421008 (1995-05-01), Banning et al.
patent: 5426781 (1995-06-01), Kaplan et al.
patent: 5454106 (1995-09-01), Burns et al.
patent: 5455945 (1995-10-01), VanderDrift
patent: 5463724 (1995-10-01), Anderson et al.
patent: 5608898 (1997-03-01), Turpin et al.
patent: 5615367 (1997-03-01), Bennett et al.
patent: 5619688 (1997-04-01), Bosworth et al.
patent: 5632022 (1997-05-01), Warren et al.
patent: 5682535 (1997-10-01), Knudsen
patent: 5745712 (1998-04-01), Turpin et al.
Reflex for the Mac, Borland International, Scotts Valley, CA, 1986, Section Four: Reference, "Reflex Formulas and Queries," pp. 209-222.
Reflex for the Mac, Borland International, Scotts Valley, CA, 1986, Section Four: Reference: "Menu References," pp. 223-289.
Quattro Pro User's Guide, Borland International, Inc., 1987, 1990, pp. 338-362, 497-498.
Rizzo, T. and K. Strauss, "Darwin: Merrill Lynch Develops a New Workstation Based on Windows 2.03," Microsoft Systems Journal, Jul 1988, pp. 1-12.
Czejdo et al., "Design and Implementation of an Interactive Graphical Query Interface for a Relational Database Management System," in Proceedings of the IEEE Workshop on Visual Languages, Oct. 10-12, 1988, pp. 14-20.
Epstein, "A Graphical Query Language for Object-Oriented Data Models," in Proc. of the 1990 IEEE Workshop on Visual Languages, Oct. 4-6, 1990, pp. 36-41.
Omnis, Getting Started for Windows Users, Blyth Holdings, Inc., 1991, Chap. 4, Ad Hoc Reports and Searches, pp. 4-1, 4-14.
States et al., "A Graphical Query Language for Object Oriented Databases," in Proc. of the 1991 IEEE Workshop on Visual Languages, Oct. 8-11, 1991, pp. 205-210.
Bowman, K. and K. Abelson, Quest User's Guide, Gupta Technologies, Inc., 1991, Chap. 4, "Creating and Opening Tables," pp. 54-68.
Bowman, K. and K. Abelson, Quest User's Guide, Gupta Technologies, Inc., 1991, Chap. 5, "Editing Tables," pp. 70-84.
Bowman, K. and K. Abelson, Quest User's Guide, Gupta Technologies, Inc., 1991, Chap. 6, "Querying Tables," pp. 92-114.
Boman, K. and K. Abelson, Quest User's Guide, Gupta Technologies, Inc., 1991, Chap. 8, "Sorting and Arranging Query Results," pp. 136-149.
Bowman, K. and K. Abelson, Quest User's Guide, Technologies, Inc., 1991, Chap. 12, "Report Basics," pp. 174-182.
Bowman, K. and K. Abelson, Quest User's Guide, Gupta Technologies, Inc., 1991, Chap. 16, "Creating Tables, Views and Indexes," pp. 266-283.
Bowman, K. and K. Abelson, Quest User's Guide, Gupta Technologies, Inc., 1991, Chap. 17, "Modifying Tables, Views and Indexes," pp. 286-303.

Affiliated with

Also associated with

Rating

Method and system for constructing queries does not yet have a rating. At this time, there are no reviews or comments for this patent.

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

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-569795