US5499368A
Expired / Lapsed
US
⏱️ 0.0 years remaining
Scaled depiction of information from a database
Assignee: International Business Machines Corp
•
Filing: 1994-12-01
•
Granted: 1996-03-12
•
Expires: 2014-12-01
Abstract
Abstract A method, system and program providing scaled depiction of information from a database. In a preferred form, tables and lists are obtained from a database and used to build a data structure. The data structure is employed to define various relationships between the dynamic data and the database information using a numberline to display ranges of information to a user. The system employs a query interface and a relational database to provide an ergonomic, natural display system for a database user.
Inventors
- 👤 Bruce A. Tate
- 👤 Shih-Gong Li
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-10-29 00:50
CPC Classifications
G; G06; G06F; G06F16/00; G06F16/20; G06F16/24; G06F16/248; G06F16/26; Y; Y10; Y10S; Y10S707/00; Y10S707/99931; Y10S707/99933; Y10S707/99934; Y10S707/99935
Claims Analysis
Total Claims: 18
Claim 1
Independent Claim
112 words
An apparatus for displaying a plurality of columns from a database as a plurality of numberlines, said numberlines used to generate a database query, comprising: a processor; use controls; in response to said user controls, means for controlling said processor to retrieve a plurality of columns from said database; a display for displaying a range of values of each of said retrieved columns, each of said ranges being displayed as one of said numberlines; in response to said user controls, means for controlling said processor to create at least one subrange of values on each of said numberlines; and means for controlling said processor to build a database query from said subranges.
Claim 2
Independent Claim
112 words
An apparatus for displaying a plurality of columns from a database as a plurality of numberlines, said numberlines used to generate a database query, comprising: a processor; use controls; in response to said user controls, means for controlling said processor to retrieve a plurality of columns from said database; a display for displaying a range of values of each of said retrieved columns, each of said ranges being displayed as one of said numberlines; in response to said user controls, means for controlling said processor to create at least one subrange of values on each of said numberlines; and means for controlling said processor to build a database query from said subranges.
Claim 3
Dependent Claim
46 words
The apparatus as recited in claim 1, wherein said means for controlling said processor to create at least one subrange comprises: in response to said user controls, means for controlling said processor to create at least one additional subrange of values on each of said numberlines.
Claim 4
Dependent Claim
59 words
The apparatus as recited in claim 2, wherein said means for controlling said processor to build a database query comprises: means for logically ORING said subrange with said at least one additional subrange on each numberline to generate a database subquery for each numberline; and means for logically ANDING each of said database subqueries to generate said database query.
Claim 5
Dependent Claim
36 words
The apparatus as recited in claim 1, including means for displaying a concentration scale adjacent to each of said numberlines, each of said concentration scales indicating a concentration of said values within each of said numberlines.
Claim 6
Dependent Claim
108 words
The apparatus as recited in claim 1 wherein said means for controlling said processor to retrieve a plurality of columns comprises: in response to said user controls, means for retrieving at least one table from said database, said table having one or more columns; means for retrieving a column name and column type for each of said columns; means for determining the minimum and maximum value for each of said columns; means for initializing a number bar by positioning each of said column names on said number bar; and in response to said user controls, means for retrieving at least one of said columns on said number bar.
Claim 7
Dependent Claim
37 words
The apparatus as recited in claim 5 wherein said display for displaying a range of values further comprises: said display for displaying said minimum and maximum values for each of said columns on each of said numberlines.
Claim 8
Dependent Claim
71 words
The apparatus as recited in claim 6 wherein said means for controlling said processor to create at least one subrange comprises: said user controls for positioning a pointer on said numberline; said user controls for activating said pointer to create a subrange separator, said subrange separator comprising a double dot; and in response to said user controls, said pointer for moving either dot of said double dot to change said subrange.
Claim 9
Independent Claim
116 words
A method for controlling a computer system, having at least user controls to control a pointer and a display, to display at least one column from a database as a numberline, said numberline used to generate a database query, comprising the computer-implemented steps of: (a) in response to said user controls, retrieving at least one column from said database; (b) displaying a range of values for said retrieved column as a numberline on said display; (c) in response to said user controls, creating at least one subrange of values on said numberline; (d) repeating said steps (a) through (c) until no more columns are retrieved; and (e) building a database query using each of said subranges.
Claim 10
Independent Claim
116 words
A method for controlling a computer system, having at least user controls to control a pointer and a display, to display at least one column from a database as a numberline, said numberline used to generate a database query, comprising the computer-implemented steps of: (a) in response to said user controls, retrieving at least one column from said database; (b) displaying a range of values for said retrieved column as a numberline on said display; (c) in response to said user controls, creating at least one subrange of values on said numberline; (d) repeating said steps (a) through (c) until no more columns are retrieved; and (e) building a database query using each of said subranges.
Claim 11
Dependent Claim
34 words
The method as recited in claim 8, wherein said step (c) comprises the step of: in response to said user controls, creating at least one additional subrange of values on each of said numberlines.
Claim 12
Dependent Claim
51 words
The method as recited in claim 9, wherein said step of building a database query comprises the steps of: logically ORING said subrange with said additional subrange on each numberline to generate a database subquery for each numberline; and logically ANDING each of said database subqueries to generate said database query.
Claim 13
Dependent Claim
37 words
The method as recited in claim 8, including the step of displaying a concentration scale adjacent to each of said numberlines, each of said concentration scales indicating a concentration of said values within each of said numberlines.
Claim 14
Dependent Claim
90 words
The method of claim 8 wherein said step (a) comprises the steps of: in response to said user controls, retrieving at least one table from said database, said table having one or more columns; retrieving a column name and column type for each of said columns; determining the minimum and maximum value for each of said columns; initializing a number bar by positioning each of said column names on said number bar; and in response to said user controls, retrieving one or more of said columns on said number bar.
Claim 15
Dependent Claim
29 words
The method of claim 12 wherein said step (b) comprises the following step: displaying said minimum and maximum values of each of said columns on each of said numberlines.
Claim 16
Dependent Claim
93 words
The method of claim 8 wherein said step (c) comprises the steps of: (f) in response to said user controls, positioning said pointer on at least one of said numberlines; (g) in response to said user controls, activating said pointer to create a subrange separator, said subrange separator comprising a double dot; (h) in response to said user controls, moving either of said dots according to the movement of said pointer to change said subrange; and (i) in response to said user controls, repeating said steps (f) through (h) to create additional subranges.
Claim 17
Independent Claim
102 words
An apparatus for displaying at least one column from a database as a numberline, said numberline used to generate a database query, comprising: a processor; user controls; in response to a first command from said user controls, said processor for retrieving at least one column from said database; a display for displaying a range of values for said retrieved column, said range being displayed as a numberline; in response to a second command from said user controls, said processor for creating at least a first subrange of values on said numberline; and said processor for building a database query from said subrange.
Claim 18
Independent Claim
102 words
An apparatus for displaying at least one column from a database as a numberline, said numberline used to generate a database query, comprising: a processor; user controls; in response to a first command from said user controls, said processor for retrieving at least one column from said database; a display for displaying a range of values for said retrieved column, said range being displayed as a numberline; in response to a second command from said user controls, said processor for creating at least a first subrange of values on said numberline; and said processor for building a database query from said subrange.
References Cited (Backward Citations)
US4479196A
Cited
US4506326A
Cited
US5047918A
Cited
US4805134A
Cited
US5010478A
Cited
US5065338A
Cited
US4752889A
Cited
US5299287A
Cited
US5133045A
Cited
US5295242A
Cited
US5265246A
Cited
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 1999-03-12 | 1999-09-11 | 2000-03-12 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2003-03-12 | 2003-09-11 | 2004-03-12 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2007-03-12 | 2007-09-11 | 2008-03-12 | $7700.00 | Window Closed / Lapsed |