Patent US5608899A successfully refreshed from Google Patents.
US5608899A
Expired / Lapsed
US
⏱️ 0.0 years remaining
Method and apparatus for searching a database by interactively modifying a database query
Assignee: International Business Machines Corp
•
Filing: 1993-06-04
•
Granted: 1997-03-04
•
Expires: 2013-06-04
Abstract
Abstract An apparatus for modifying a database query including apparatus for graphically displaying in at least two dimensions data obtained from a database by the database query, apparatus for selecting at least one portion of the graphically displayed data, and apparatus for modifying the database query according to the selected portion of the graphically displayed data. In addition, a method for modifying a database query including the steps of graphically displaying in at least two dimensions data obtained from a database by the database query, selecting at least one portion of the graphically displayed data, and modifying the database query according to the selected portion of the graphically displayed data.
Inventors
- 👤 Shih-Gong Li
- 👤 Bruce A. Tate
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-10-29 23:30
CPC Classifications
G; G06; G06F; G06F16/00; G06F16/20; G06F16/24; G06F16/248; G06F16/242; G06F16/2425; G06F16/2428; Y; Y10; Y10S; Y10S707/00; Y10S707/99931; Y10S707/99933; Y10S707/99934; Y10S715/00; Y10S715/961; Y10S715/965; Y10S715/966; Y10S715/968
Claims Analysis
Total Claims: 24
Claim 1
Independent Claim
110 words
An apparatus for modifying a database query comprising: means for graphically displaying, in at least two dimensions, data obtained from a database by the database query in a graph window and for separately displaying said database query in a query window; means for selecting at least one portion of the graphically displayed data in said graph window; and means for modifying the database query with a WHERE clause according to the selected portion of the graphically displayed data, said database query modifying means including means for reflecting the modification to the database query in the query window and means for modifying the graphically displayed data using the modified database query.
Claim 2
Independent Claim
110 words
An apparatus for modifying a database query comprising: means for graphically displaying, in at least two dimensions, data obtained from a database by the database query in a graph window and for separately displaying said database query in a query window; means for selecting at least one portion of the graphically displayed data in said graph window; and means for modifying the database query with a WHERE clause according to the selected portion of the graphically displayed data, said database query modifying means including means for reflecting the modification to the database query in the query window and means for modifying the graphically displayed data using the modified database query.
Claim 3
Dependent Claim
23 words
The apparatus of claim 1 further comprising means for iteratively actuating said means for graphically displaying, means for selecting and means for modifying.
Claim 4
Dependent Claim
27 words
The apparatus of claim 1 wherein the means for graphically displaying includes means for graphically displaying a line chart of the data obtained by the database query.
Claim 5
Dependent Claim
28 words
The apparatus of claim 3 wherein the means for selecting includes means for utilizing a variable sized box to select at least one portion of the line chart.
Claim 6
Dependent Claim
21 words
The apparatus of claim 1 wherein the means for selecting includes means for selecting multiple portions of the graphically displayed data.
Claim 7
Independent Claim
96 words
A method for modifying a database query comprising the steps of: graphically displaying, in at least two dimensions, data obtained from a database by the database query in a graph window and separately displaying said database query in a query window; selecting at least one portion of the graphically displayed data in said graph window; and modifying the database query with a WHERE clause according to the selected portion of the graphically displayed data, reflecting the modification to the database query in the query window and modifying the graphically displayed data using the modified database query.
Claim 8
Independent Claim
96 words
A method for modifying a database query comprising the steps of: graphically displaying, in at least two dimensions, data obtained from a database by the database query in a graph window and separately displaying said database query in a query window; selecting at least one portion of the graphically displayed data in said graph window; and modifying the database query with a WHERE clause according to the selected portion of the graphically displayed data, reflecting the modification to the database query in the query window and modifying the graphically displayed data using the modified database query.
Claim 9
Dependent Claim
19 words
The method of claim 6 further comprising the step of repeating the steps of graphically displaying, selecting and modifying.
Claim 10
Dependent Claim
25 words
The method of claim 6 wherein the step of graphically displaying includes graphically displaying a line chart of the data obtained by the database query.
Claim 11
Dependent Claim
26 words
The method of claim 8 wherein the step of selecting includes utilizing a variable sized box to select at least one portion of the line chart.
Claim 12
Dependent Claim
19 words
The method of claim 6 wherein the step of selecting includes selecting multiple portions of the graphically displayed data.
Claim 13
Dependent Claim
126 words
A data processing system for modifying a database query comprising: memory means for storing database data; means for graphically displaying, in at least two dimensions, data obtained from a database by the database query in a graph window and for separately displaying said database query in a query window; processing means for processing said stored database data; means for selecting at least one portion of the graphically displayed data in said graph window; and means for modifying the database query with a WHERE clause according to the selected portion of the graphically displayed data, said database query modifying means including means for reflecting the modification to the database query in said query window and means for modifying the graphically displayed data using the modified database query.
Claim 14
Dependent Claim
126 words
A data processing system for modifying a database query comprising: memory means for storing database data; means for graphically displaying, in at least two dimensions, data obtained from a database by the database query in a graph window and for separately displaying said database query in a query window; processing means for processing said stored database data; means for selecting at least one portion of the graphically displayed data in said graph window; and means for modifying the database query with a WHERE clause according to the selected portion of the graphically displayed data, said database query modifying means including means for reflecting the modification to the database query in said query window and means for modifying the graphically displayed data using the modified database query.
Claim 15
Dependent Claim
25 words
The data processing system of claim 11 further comprising means for iteratively actuating said means for graphically displaying, means for selecting and means for modifying.
Claim 16
Dependent Claim
29 words
The data processing system of claim 11 wherein the means for graphically displaying includes means for graphically displaying a line chart of the data obtained by the database query.
Claim 17
Dependent Claim
30 words
The data processing system of claim 13 wherein the means for selecting includes means for utilizing a variable sized box to select at least one portion of the line chart.
Claim 18
Dependent Claim
23 words
The data processing system of claim 11 wherein the means for selecting includes means for selecting multiple portions of the graphically displayed data.
Claim 19
Dependent Claim
119 words
A computer program product stored in memory executable by a processor for modifying a database query comprising: means for graphically displaying, in at least two dimensions, data obtained from a database by the database query in a graph window and for separately displaying said database query in a query window; means for selecting at least one portion of the graphically displayed data in said graph window; and means for modifying the database query with a WHERE clause according to the selected portion of the graphically displayed data, said database query modifying means including means for reflecting the modification to the database query in said query window and means for modifying the graphically displayed data using the modified database query.
Claim 20
Dependent Claim
119 words
A computer program product stored in memory executable by a processor for modifying a database query comprising: means for graphically displaying, in at least two dimensions, data obtained from a database by the database query in a graph window and for separately displaying said database query in a query window; means for selecting at least one portion of the graphically displayed data in said graph window; and means for modifying the database query with a WHERE clause according to the selected portion of the graphically displayed data, said database query modifying means including means for reflecting the modification to the database query in said query window and means for modifying the graphically displayed data using the modified database query.
Claim 21
Dependent Claim
25 words
The computer program product of claim 16 further comprising means for iteratively actuating said means for graphically displaying, means for selecting and means for modifying.
Claim 22
Dependent Claim
29 words
The computer program product of claim 16 wherein the means for graphically displaying includes means for graphically displaying a line chart of the data obtained by the database query.
Claim 23
Dependent Claim
30 words
The computer program product of claim 18 wherein the means for selecting includes means for utilizing a variable sized box to select at least one portion of the line chart.
Claim 24
Dependent Claim
23 words
The computer program product of claim 16 wherein the means for selecting includes means for selecting multiple portions of the graphically displayed data.
References Cited (Backward Citations)
US4506326A
Cited
US5053956A
Cited
US5172245A
Cited
US4989610A
Cited
US4972328A
Cited
US5019961A
Cited
US5161225A
Cited
US5168441A
Cited
EP0477152A2
Cited
US5265246A
Cited
EP0491517A2
Cited
US5319560A
Cited
US5426781A
Cited
US5414809A
Cited
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 2000-03-03 | 2000-09-02 | 2001-03-04 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2004-03-03 | 2004-09-02 | 2005-03-04 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2008-03-03 | 2008-09-02 | 2009-03-04 | $7700.00 | Window Closed / Lapsed |