US5630122A
Expired / Lapsed
US
⏱️ 0.0 years remaining
Computerized report-based interactive database query interface
Assignee: International Business Machines Corp
•
Filing: 1995-03-02
•
Granted: 1997-05-13
•
Expires: 2015-03-02
Abstract
Abstract In a computer database system, a method and system are provided for interactively and iteratively constructing a query using a table metaphor displayed on a user display. Alterations are made directly to the table metaphor by the database user. The alterations relate to adding, deleting, or combining columns of attributes and limiting ranges of attribute values. The alterations are registered and the table metaphor updated to reflect the registered alterations. The table metaphor can be repeatedly used to further register additional alterations. The query corresponding to the table metaphor in its final form is run against the full database to generate a report in the format indicated by the table metaphor.
Inventors
- 👤 Craig A. Kaplan
- 👤 Stanley E. Taylor
- 👤 Gregory J. Wolff
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-10-27 08:27
CPC Classifications
G; G06; G06F; G06F16/00; G06F16/20; G06F16/24; G06F16/242; G06F16/2428; Y; Y10; Y10S; Y10S707/00; Y10S707/953; Y10S707/954; Y10S707/99931; Y10S707/99933; Y10S707/99934; Y10S707/99941; Y10S707/99943; Y10S707/99944
Claims Analysis
Total Claims: 4
Claim 1
Independent Claim
180 words
A computer program on a computer usable medium having computer readable program code means embodied in said medium for generating a report by enabling a user to interact with a computer system connected to a storage device having a database of data, comprising: computer readable program code means for causing a displaying, on a display screen of the computer system, of a table metaphor having rows and columns of attribute value cells, the attribute value cells containing attribute values reflective of a subset of attribute values of the database data; computer readable program code means for causing a registering of direct alterations to the table metaphor; computer readable program code means for causing a displaying, on the display screen, of a revised table metaphor graphically representing a revised report format reflecting the registered direct alterations; computer readable program code means for causing a query statement, corresponding to the revised table metaphor, to be determined; and computer readable program code means for causing a running of the query statement on the database to produce query output in the revised report format.
Claim 2
Dependent Claim
180 words
A computer program on a computer usable medium having computer readable program code means embodied in said medium for generating a report by enabling a user to interact with a computer system connected to a storage device having a database of data, comprising: computer readable program code means for causing a displaying, on a display screen of the computer system, of a table metaphor having rows and columns of attribute value cells, the attribute value cells containing attribute values reflective of a subset of attribute values of the database data; computer readable program code means for causing a registering of direct alterations to the table metaphor; computer readable program code means for causing a displaying, on the display screen, of a revised table metaphor graphically representing a revised report format reflecting the registered direct alterations; computer readable program code means for causing a query statement, corresponding to the revised table metaphor, to be determined; and computer readable program code means for causing a running of the query statement on the database to produce query output in the revised report format.
Claim 3
Dependent Claim
135 words
A computer program on a computer usable medium having computer readable program code means embodied in said medium for formulating a report using data contained in a database stored in a storage device, comprising: computer readable program code means for causing a providing of a subset of the database data in a displayed metaphor table on a display device of a computer system connected to said storage device; computer readable program code means for causing a registering of at least one direct alteration to the metaphor table to graphically represent a report format; computer readable program code means for causing a query, corresponding to the report format, to be determined; and computer readable program code means for causing a running of the query on the database data to produce the report in the report format.
Claim 4
Dependent Claim
135 words
A computer program on a computer usable medium having computer readable program code means embodied in said medium for formulating a report using data contained in a database stored in a storage device, comprising: computer readable program code means for causing a providing of a subset of the database data in a displayed metaphor table on a display device of a computer system connected to said storage device; computer readable program code means for causing a registering of at least one direct alteration to the metaphor table to graphically represent a report format; computer readable program code means for causing a query, corresponding to the report format, to be determined; and computer readable program code means for causing a running of the query on the database data to produce the report in the report format.
References Cited (Backward Citations)
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 2000-05-12 | 2000-11-11 | 2001-05-13 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2004-05-12 | 2004-11-11 | 2005-05-13 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2008-05-12 | 2008-11-11 | 2009-05-13 | $7700.00 | Window Closed / Lapsed |