US5619688A
Expired / Lapsed
US
⏱️ 0.0 years remaining
Method and system for constructing database queries using a field selection grid
Assignee: Microsoft Technology Licensing LLC
•
Filing: 1993-09-02
•
Granted: 1997-04-08
•
Expires: 2013-09-02
Abstract
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.
Inventors
- 👤 Adam Bosworth
- 👤 Ross A. Hunter
- 👤 David J. Habib
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-10-31 13:18
CPC Classifications
G; G06; G06F; G06F16/00; G06F16/20; G06F16/24; G06F16/242; G06F16/2428; G06F16/2423; Y; Y10; Y10S; Y10S707/00; Y10S707/99931; Y10S707/99933; Y10S707/99934
Claims Analysis
Total Claims: 26
Claim 1
Independent Claim
165 words
A method in a computer system for specifying selection criteria for retrieval of information from a database table having a plurality of fields with field names, the computer system having a display device, the method comprising the steps of: displaying on the display device a selection grid having rows and columns, the selection grid having one of the rows designated as a field name row having empty fields for containing user-specified field names and one of the rows designated as a criteria row for containing selection criteria corresponding to the field name in the same column; specifying by a user of the computer system one field name of the database table for which to specify a selection criterion; displaying the user-specified field name in one of the empty fields of the field name row; specifying by the user the selection criterion for the user-specified field name; and displaying the specified selection criterion within the criteria row in a column corresponding to the user-specified field name.
Claim 2
Independent Claim
165 words
A method in a computer system for specifying selection criteria for retrieval of information from a database table having a plurality of fields with field names, the computer system having a display device, the method comprising the steps of: displaying on the display device a selection grid having rows and columns, the selection grid having one of the rows designated as a field name row having empty fields for containing user-specified field names and one of the rows designated as a criteria row for containing selection criteria corresponding to the field name in the same column; specifying by a user of the computer system one field name of the database table for which to specify a selection criterion; displaying the user-specified field name in one of the empty fields of the field name row; specifying by the user the selection criterion for the user-specified field name; and displaying the specified selection criterion within the criteria row in a column corresponding to the user-specified field name.
Claim 3
Dependent Claim
118 words
The method according to claim 1, prior to the step of specifying by a user of the computer system one field name of the database table, further comprising the step of displaying on the display device the plurality of field names of the database table, wherein the step of specifying by a user of the computer system one field name of the database table includes the steps of: using a pointing device, selecting the one field name from the displayed plurality of field names; dragging the selected field name to one of the empty fields of the field name row; and dropping the selected field name into the one of the empty fields of the field name row.
Claim 4
Dependent Claim
56 words
The method according to claim 1, after the step of displaying on the display device a selection grid, further comprising the steps of: selecting one of the empty fields of the field name row; and displaying the plurality of field names of the database table responsive to the selection of the one of the empty fields.
Claim 5
Dependent Claim
38 words
The method according to claim 3 wherein the step of specifying by a user of the computer system one field name of the database table includes the step of selecting one of the displayed plurality of field names.
Claim 6
Dependent Claim
42 words
The method according to claim 3 wherein the step of displaying the plurality of field names of the database table includes the step of displaying the plurality of field names in a drop down menu in proximity to the field name row.
Claim 7
Dependent Claim
78 words
The method according to claim 1 wherein one row of the selection grid is designated as a show row having fields, each field for specifying whether the corresponding field name is to be displayed in a report generated according to the displayed selection grid, the method further comprising the steps of: selecting one field of the show row; and displaying in the selected field an indication that the corresponding field name is to be displayed in the report.
Claim 8
Dependent Claim
78 words
The method according to claim 1 wherein one row of the selection grid is designated as a sort row having fields, each field for specifying whether the corresponding field name is to be sorted in a report generated according to the displayed selection grid, the method further comprising the steps of: selecting one field of the sort row; and displaying in the selected field an indication that the corresponding field name is to be sorted in the report.
Claim 9
Dependent Claim
62 words
The method according to claim 1 wherein the user-specified field names and the selection criteria define a query specification, the method further comprising the steps of: selecting by the user a query language representation for the query specification displayed in the selection grid; and displaying on the display device the query specification in the query language representation according to the user selection.
Claim 10
Dependent Claim
19 words
The method according to claim 8 wherein the step of selecting includes selecting a structured query language (SQL) representation.
Claim 11
Independent Claim
164 words
A method in a computer system for specifying a cross tabulation for a database table having a plurality of fields, each field having a field name, the computer system having a display device, the method comprising the steps of: displaying on the display device a selection grid having rows and columns, one of the rows of the selection grid being designated as a field name row having empty fields for containing user-specified field names and another one of the rows of the selection grid being designated as a cross tabulation row; receiving, from a user of the computer system, the field names to use in the cross tabulation and displaying within the empty fields of the field name row of the selection grid the received field names; and receiving from the user a function of each of the displayed field names and displaying the received functions within the cross tabulation row, whereby the cross tabulation is generated in accordance with the displayed selection grid.
Claim 12
Independent Claim
164 words
A method in a computer system for specifying a cross tabulation for a database table having a plurality of fields, each field having a field name, the computer system having a display device, the method comprising the steps of: displaying on the display device a selection grid having rows and columns, one of the rows of the selection grid being designated as a field name row having empty fields for containing user-specified field names and another one of the rows of the selection grid being designated as a cross tabulation row; receiving, from a user of the computer system, the field names to use in the cross tabulation and displaying within the empty fields of the field name row of the selection grid the received field names; and receiving from the user a function of each of the displayed field names and displaying the received functions within the cross tabulation row, whereby the cross tabulation is generated in accordance with the displayed selection grid.
Claim 13
Dependent Claim
34 words
The method of claim 10 wherein the step of displaying the received functions within the cross tabulation row displays each received function in the same column in which the corresponding field name is displayed.
Claim 14
Dependent Claim
52 words
The method of claim 10 wherein a row of the selection grid is designated as a totaling row, and the method further includes the step of receiving from the user an indication of an action to perform in the cross tabulation and displaying within the totaling row the indication of the action.
Claim 15
Dependent Claim
27 words
The method of claim 10, including the step of, in response to a request by the user, displaying a list of functions available for the cross tabulation.
Claim 16
Dependent Claim
29 words
The method of claim 13 wherein the step of displaying the list of functions displays the list in a drop down menu in proximity to the cross tabulation row.
Claim 17
Dependent Claim
29 words
The method of claim 10 wherein the function to be received from the user is one of a row heading function, a column heading function, and a value function.
Claim 18
Dependent Claim
109 words
A computer system for identifying a field name of a table for retrieving information from the table, the table having a plurality of field names, the computer system comprising: a display device for displaying the plurality of field names; a query grid displayed on the display device, the query grid having a plurality of columns and a row designated as a field name row having empty fields for containing field names; and a pointing device for inserting into one of the empty fields of the field name row one of the displayed plurality of field names to identify the field name of the table from which to retrieve information.
Claim 19
Dependent Claim
109 words
A computer system for identifying a field name of a table for retrieving information from the table, the table having a plurality of field names, the computer system comprising: a display device for displaying the plurality of field names; a query grid displayed on the display device, the query grid having a plurality of columns and a row designated as a field name row having empty fields for containing field names; and a pointing device for inserting into one of the empty fields of the field name row one of the displayed plurality of field names to identify the field name of the table from which to retrieve information.
Claim 20
Independent Claim
167 words
A method, in a computer system having a display device, for specifying selection criteria for retrieval of information from a database table having a plurality of fields with field names, the method comprising the steps of: displaying the plurality of field names of the database table in a first portion of the display device; displaying a query grid in a second portion of the display device, the query grid having rows and columns, the query grid having one row designated as a field name row for containing user-selected field names and another row designated as a criteria row for containing selection criteria; and selecting by a user a field name from the displayed plurality of field names; displaying the selected field name in one column of the field name row; specifying by the user a selection criterion for the selected field name; and displaying the specified selection criterion in a column of the criteria row corresponding to the selected field name displayed in the field name row.
Claim 21
Independent Claim
167 words
A method, in a computer system having a display device, for specifying selection criteria for retrieval of information from a database table having a plurality of fields with field names, the method comprising the steps of: displaying the plurality of field names of the database table in a first portion of the display device; displaying a query grid in a second portion of the display device, the query grid having rows and columns, the query grid having one row designated as a field name row for containing user-selected field names and another row designated as a criteria row for containing selection criteria; and selecting by a user a field name from the displayed plurality of field names; displaying the selected field name in one column of the field name row; specifying by the user a selection criterion for the selected field name; and displaying the specified selection criterion in a column of the criteria row corresponding to the selected field name displayed in the field name row.
Claim 22
Dependent Claim
56 words
The method according to claim 17, after the step of selecting by a user a field name from the displayed plurality of field names, further comprising the steps of: dragging the selected field name to a column of the field name row; and dropping the selected field name into the column of the field name row.
Claim 23
Independent Claim
187 words
A method, in a computer system having a display device and a pointing device, for specifying selection criteria for retrieval of information from a database table having a plurality of fields with field names, the method comprising the steps of: displaying the plurality of field names of the database table in a portion of the display device; displaying a query grid in another portion of the display device, the query grid having rows and columns, the query grid having one row designated as a field name row for containing user-selected field names and another row designated as a criteria row for containing selection criteria; and using the pointing device, selecting by a user a field name from the displayed plurality of field names; dragging the selected field name to a column of the field name row; and dropping the selected field name into the column of the field name row; specifying by the user a selection criterion for the selected field name; and displaying the specified selection criterion in a column of the criteria row corresponding to the dropped field name displayed in the field name row.
Claim 24
Independent Claim
187 words
A method, in a computer system having a display device and a pointing device, for specifying selection criteria for retrieval of information from a database table having a plurality of fields with field names, the method comprising the steps of: displaying the plurality of field names of the database table in a portion of the display device; displaying a query grid in another portion of the display device, the query grid having rows and columns, the query grid having one row designated as a field name row for containing user-selected field names and another row designated as a criteria row for containing selection criteria; and using the pointing device, selecting by a user a field name from the displayed plurality of field names; dragging the selected field name to a column of the field name row; and dropping the selected field name into the column of the field name row; specifying by the user a selection criterion for the selected field name; and displaying the specified selection criterion in a column of the criteria row corresponding to the dropped field name displayed in the field name row.
Claim 25
Independent Claim
151 words
A method in a computer system for updating a database table having fields with field names, the computer system having a display device, the method comprising the steps of: displaying on the display device an update grid having rows and columns, wherein one of the rows is designated as a field name row having empty fields for containing user-specified field names and another one of the rows is designated as an update row; specifying by a user of the computer system one field name of the database table; displaying the user-specified field name in one of the empty fields of the field name row; receiving from the user an update specification, the update specification specifying how to update the field with the displayed field name; and displaying in a column of the update row the update specification, whereby the computer system updates the database table in accordance with the update specification.
Claim 26
Independent Claim
151 words
A method in a computer system for updating a database table having fields with field names, the computer system having a display device, the method comprising the steps of: displaying on the display device an update grid having rows and columns, wherein one of the rows is designated as a field name row having empty fields for containing user-specified field names and another one of the rows is designated as an update row; specifying by a user of the computer system one field name of the database table; displaying the user-specified field name in one of the empty fields of the field name row; receiving from the user an update specification, the update specification specifying how to update the field with the displayed field name; and displaying in a column of the update row the update specification, whereby the computer system updates the database table in accordance with the update specification.
References Cited (Backward Citations)
US4805099A
Cited
EP0314279A2
Cited
WO1992016903A1
Cited
US5463724A
Cited
US5392390A
Cited
US5426781A
Cited
US5418950A
Cited
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 2000-04-07 | 2000-10-07 | 2001-04-08 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2004-04-07 | 2004-10-07 | 2005-04-08 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2008-04-07 | 2008-10-07 | 2009-04-08 | $7700.00 | Window Closed / Lapsed |