Method and system for constructing database queries using a fiel

Details Method and system for constructing database queries using a fiel Method and system for constructing database queries using a fiel

1993-09-02

1997-04-08

Amsbury, Wayne

Boots, shoes, and leggings

364DIG1, 3642821, G06F 1730

Patent

active

056196881

ABSTRACT:
A method and system for constructing queries which make changes to an entire set of data stored in a database is provided. In a preferred embodiment of the present invention, a user selects one of 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: 5392390 (1995-02-01), Crozier
patent: 5418950 (1995-05-01), Li et al.
patent: 5426781 (1995-06-01), Kaplan et al.
patent: 5463724 (1995-10-01), Anderson et al.
Quattro Pro User's Guide, Borland International, Inc. .COPYRGT. 1987, 1990 pp. 338-362, 497-498.
Czejdo et al, "Design and Implementation of an Interactive Graphical Query Interface for a Relational Database Management System", 1988 IEEE Workshop on Visual Languages, 10-12 Oct. 1988, pp. 14-20.
Epstein, "A Graphical Query Language for Object-Oriented Data Models", Proc. of the 1990 IEEE Workshop on Visual Languages, 4-6 Oct. 1990, pp. 36-41
Staes et al, "A Graphical Query Language for Object Oriented Databases", Proc of the 1991 IEEE Workshop on Visual Languages, 8-11 Oct. 1991, pp. 205-210.
Tony Rizzo and Karen Strauss, "Darwin: Merrill Lynch Develops a New Workstation Based on Windows 2.03," Microsoft Systems Journal, Jul., 1988, pp. 1-12.
Omnis, Blyth Holdings Inc., 1991, Chap. 4, "Ad hoc Reports and Searches, " pp. 4-1 -4-14.
Reflex for the Mac, Borland International, Scotts Valley, California, 1986, Section Four: Reference, "Reflex Formulas and Queries", pp. 209-222.
Reflex for the Mac, Borland International, Scotts Valley, California, 1986, Section Four: Reference, "Menu References," pp. 223-289.
Karen Bowman and Kamali Abelson, Quest User's Guide, Gupta Technologies, Inc., 1991, Chap. 4, "Creating and Opening Tables," pp. 54-68.
Karen Bowman and Kamali Abelson, Quest User's Guide, Gupta Technologies, Inc., 1991, Chap. 5, "Editing Tables," pp. 70-84.
Karen Bowman and Kamali Abelson, Quest User's Guide, Gupta Technologies, Inc., 1991, Chap. 6, "Querying Tables," pp. 92-114.
Karen Bowman and Kamali Abelson, Quest User's Guide, Gupta Technologies, Inc., 1991, Chap. 8, "Sorting and Arranging Query Results," pp. 136-149.
Karen Bowman and Kamali Abelson, Quest User's Guide, Gupta Technologies, Inc., 1991, Chap. 12, "Report Basics," pp. 174-182.
Karen Bowman and Kamali Abelson, Quest User's Guide, Gupta Technologies, Inc., 1991, Chap. 16, "Creating Tables, Views, and Indexes," pp. 266-283.
Karen Bowman and Kamali 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 database queries using a fiel 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 database queries using a fiel, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Method and system for constructing database queries using a fiel will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-2402967