US5261093A
Expired / Lapsed
US
⏱️ 0.0 years remaining
Interactive relational database analysis with successive refinement steps in selection of ouput data from underlying database
Assignee: Sarnoff Corp
•
Filing: 1990-11-05
•
Granted: 1993-11-09
•
Expires: 2010-11-05
Abstract
Abstract A multi-step method enables a user to extract useful information from a complex relational database without needing to construct elaborate Structured Query Language statements or to become familiar with details of the particular data model involved. In particular, the method generates a table of output data from a relational database having one or more database tables made up of columns of attributes, rows instances, and one or more keys composed of one or more attributes each as elements. In the method, the steps include selecting an attribute from one of the database tables upon which to base an intermediate table, displaying a key of the database table containing the selected attribute, selecting an attribute element of that key for constraint, generating and displaying a list of alternative attribute sets the members of any of which when constrained will constrain the selected attribute element, selecting a set from that list of alternative attribute sets, generating and displaying a list of combinations of values for the selected attribute set, selecting one of the combinations of values from the list of value combinations, generating an intermediate table in accordance with the selected combinations of values from the list of value combinations, and generating the table of output data from the intermediate table. The intermediate table has only keys whose values have not been constrained.
Inventors
- 👤 Charles A. Asmuth
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-11-05 12:49
CPC Classifications
G; G06; G06F; G06F16/00; G06F16/20; G06F16/24; G06F16/242; G06F16/2428; Y; Y10; Y10S; Y10S707/00; Y10S707/99931; Y10S707/99932
Claims Analysis
Total Claims: 6
Claim 1
Independent Claim
278 words
In a computer based relational database system comprising at least one database table in computer memory composed of columns of attributes, lines of instances, and a primary key composed of at least one attribute as an element, a method of generating a table of output data in computer memory comprising the steps of: selecting an attribute from said database table upon which to base an intermediate table in computer memory; displaying on a monitor the primary key of said database table containing said selected attribute; selecting a first attribute element of said primary key for constraint; generating in computer memory and displaying on said monitor a first list of alternative attribute sets the members of nay of which when constrained will constrain said first selected attribute element; selecting a set from said first list of alternative attribute sets; generating in computer memory and displaying on said monitor a first list of combinations of attribute values for said selected attribute set; selecting one of said combinations of attribute values from said first list of combinations of attribute values so as to establish the value of the first attribute element of said primary key; generating in computer memory a first intermediate table comprising those rows of said database table for which said primary key has a value determined by the selected combination of attribute values from said first list of combinations of attribute values in accordance with said selected combinations of attribute values, said first intermediate table having only keys whose attribute values have not been constrained; and generating in computer memory said output table of data from said first intermediate table and displaying said output table on said monitor.
Claim 2
Dependent Claim
278 words
In a computer based relational database system comprising at least one database table in computer memory composed of columns of attributes, lines of instances, and a primary key composed of at least one attribute as an element, a method of generating a table of output data in computer memory comprising the steps of: selecting an attribute from said database table upon which to base an intermediate table in computer memory; displaying on a monitor the primary key of said database table containing said selected attribute; selecting a first attribute element of said primary key for constraint; generating in computer memory and displaying on said monitor a first list of alternative attribute sets the members of nay of which when constrained will constrain said first selected attribute element; selecting a set from said first list of alternative attribute sets; generating in computer memory and displaying on said monitor a first list of combinations of attribute values for said selected attribute set; selecting one of said combinations of attribute values from said first list of combinations of attribute values so as to establish the value of the first attribute element of said primary key; generating in computer memory a first intermediate table comprising those rows of said database table for which said primary key has a value determined by the selected combination of attribute values from said first list of combinations of attribute values in accordance with said selected combinations of attribute values, said first intermediate table having only keys whose attribute values have not been constrained; and generating in computer memory said output table of data from said first intermediate table and displaying said output table on said monitor.
Claim 3
Dependent Claim
223 words
The method of claim 1 further comprising the steps of: selecting a second attribute element of said primary key for constraint; generating in computer memory and displaying on said monitor a second list of alternative attribute sets the members of any of which when constrained will constrain said second selected attribute element; selecting one set from said second list of alternative attribute sets; generating in computer memory and displaying on said monitor a second list of combinations of attribute values for said attribute set selected from said second list of alternative attribute sets; selecting one of said combinations of attribute values from said second list of combinations of attribute values so as to establish the value of the second attribute element of said primary key; and generating in computer memory a second intermediate table comprising those rows of said first intermediate database table for which said primary key has a value determined by the selected combination of attribute values from said second list of combinations of attribute values in accordance with said selected combinations of attribute values from said second list of combinations of attribute values, said second intermediate table having only keys whose attribute values have not been constrained; and in which said output table of data is generated in computer memory from said second intermediate table and displayed on said monitor.
Claim 4
Dependent Claim
288 words
In a computer based relational database system comprising a plurality of database tables in computer memory each composed of columns of attributes, lines of instances, and a primary key composed of at least one attribute as an element, the method of generating a table of output data in computer memory comprising the steps of: selecting an attribute from one of said database tables upon which to base an intermediate table in computer memory; displaying on a monitor the primary key of the one of said database tables containing said selected attribute; selecting a first attribute element of said primary key for constraint; generating in computer memory and displaying on said monitor a first list of alternative attribute sets the members of any of which when constrained will constrain said first selected attribute element; selecting a set from said first list of alternative attribute sets; generating in computer memory and displaying on said monitor a first list of combinations of attribute values for said selected attribute set; selecting one of said combinations of attribute values from said first list of combinations of attribute values so as to establish the value of the first attribute element of said primary key; generating in computer memory a first intermediate table comprising those rows of said database table for which said primary key has a value determined by the selected combination of attribute values from said first list of combinations of attribute values in accordance with said selected combinations of attribute values from said first list, said first intermediate table having only keys whose attribute values have not been constrained; and generating in computer memory said output table of data from said first intermediate table and displaying said output table on said monitor.
Claim 5
Dependent Claim
288 words
In a computer based relational database system comprising a plurality of database tables in computer memory each composed of columns of attributes, lines of instances, and a primary key composed of at least one attribute as an element, the method of generating a table of output data in computer memory comprising the steps of: selecting an attribute from one of said database tables upon which to base an intermediate table in computer memory; displaying on a monitor the primary key of the one of said database tables containing said selected attribute; selecting a first attribute element of said primary key for constraint; generating in computer memory and displaying on said monitor a first list of alternative attribute sets the members of any of which when constrained will constrain said first selected attribute element; selecting a set from said first list of alternative attribute sets; generating in computer memory and displaying on said monitor a first list of combinations of attribute values for said selected attribute set; selecting one of said combinations of attribute values from said first list of combinations of attribute values so as to establish the value of the first attribute element of said primary key; generating in computer memory a first intermediate table comprising those rows of said database table for which said primary key has a value determined by the selected combination of attribute values from said first list of combinations of attribute values in accordance with said selected combinations of attribute values from said first list, said first intermediate table having only keys whose attribute values have not been constrained; and generating in computer memory said output table of data from said first intermediate table and displaying said output table on said monitor.
Claim 6
Dependent Claim
223 words
The method of claim 3 further comprising the steps of: selecting a second attribute element of said primary key for constraint; generating in computer memory and displaying on said monitor a second list of alternative attribute sets the members of any of which when constrained will constrain said second selected attribute element; selecting one set from said second list of alternative attribute sets; generating in computer memory and displaying on said monitor a second list of combinations of attribute values for said attribute set selected from said second list of alternative attribute sets; selecting one of said combinations of attribute values from said second list of combinations of attribute values so as to establish the value of the second attribute element of said primary key; and generating in computer memory a second intermediate table comprising those rows of said first intermediate database table for which said primary key has a value determined by the selected combination of attribute values from said second list of combinations of attribute values in accordance with said selected combinations of attribute values from said second list of combinations of attribute values, said second intermediate table having only keys whose attribute values have not been constrained; and in which said output table of data is generated in computer memory from said second intermediate table and displayed on said monitor.
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) | 1996-11-08 | 1997-05-10 | 1997-11-09 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2000-11-08 | 2001-05-10 | 2001-11-09 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2004-11-08 | 2005-05-10 | 2005-11-09 | $7700.00 | Window Closed / Lapsed |