US5826257A
Expired / Lapsed
US
⏱️ 0.0 years remaining
Method and structure for maintaining and utilizing a lookup value associated with a stored database value
Assignee: Microsoft Technology Licensing LLC
•
Filing: 1996-03-20
•
Granted: 1998-10-20
•
Expires: 2016-03-20
Abstract
Abstract A method and associated data structures for generating, maintaining, and applying "display parameters" as a portion of lookup information associated with a column in a database table. Display parameters provides for the display and retrieval of alternate values in place of the data stored in the associated column. Use of such alternate values permit the application database designer to provide more meaningful presentation of data to a user while permitting the storage of corresponding data to be optimized for storage or performance criteria. The display parameters are a portion of the lookup information associated with a column of a database table and are stored in the data dictionary of the application database. Storing the display parameters in the data dictionary permits all access to the associated column data to automatically utilize the alternate values for any data display or retrieval without further design considerations unique to the particular database access. The display parameters may comprise a static table consisting of rows (or a list) of entries. Each includes at least one alternate value for the stored value. A plurality of columns may be provided in each row to provide other alternate values useful by other column data access operations. The display parameters may alternatively comprise a second table identification and an associated query command. The second table is joined with the first table (containing the lookup associated column) by a relation. The associated query command is applied to the join to extract a table of alternate values used in accessing the associated column.
Inventors
- 👤 George Arthur Snelling, Jr.
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-11-01 06:29
CPC Classifications
G; G06; G06F; G06F16/00; G06F16/20; G06F16/28; G06F16/284; Y; Y10; Y10S; Y10S707/00; Y10S707/99931; Y10S707/99933; Y10S707/99934
Claims Analysis
Total Claims: 44
Claim 1
Independent Claim
102 words
A computer operable method for maintaining display parameters associated with a lookup column of a database table comprising the steps of: receiving user input indicative of at least one display parameter which identifies at least one alternate value associated with a lookup field of said lookup column of said database table; storing said at least one display parameter in a data dictionary associated with said database table; retrieving, responsive to access to said lookup column of said database, said display parameter from said data dictionary; and applying said retrieved display parameter to present data corresponding to said lookup column of said database.
Claim 2
Dependent Claim
102 words
A computer operable method for maintaining display parameters associated with a lookup column of a database table comprising the steps of: receiving user input indicative of at least one display parameter which identifies at least one alternate value associated with a lookup field of said lookup column of said database table; storing said at least one display parameter in a data dictionary associated with said database table; retrieving, responsive to access to said lookup column of said database, said display parameter from said data dictionary; and applying said retrieved display parameter to present data corresponding to said lookup column of said database.
Claim 3
Dependent Claim
39 words
The method of claim 1 wherein the receiving step includes the step of: receiving user input indicative of a table of rows each including an alternate display value to be associated with said lookup column of said database table.
Claim 4
Dependent Claim
30 words
The method of claim 2 wherein each of said rows includes an alternate display value list comprising a plurality of equivalent values associated with each of said alternate display value.
Claim 5
Dependent Claim
54 words
The method of claim 3 wherein the receiving step includes the step of: receiving user input indicative that a particular value is to be stored in the associated column of said database table wherein said particular value is selected from the group consisting of said alternate display value and said alternate display value list.
Claim 6
Dependent Claim
62 words
The method of claim 1 wherein the receiving step includes the steps of: receiving user input indicative of a second database table to be joined with said database table; and receiving user input indicative of a query command to be applied to said second database table to select at least one alternate display value associated with said column of said database table.
Claim 7
Dependent Claim
20 words
The method of claim 5 wherein said query command is operable to select a plurality of equivalent alternate display values.
Claim 8
Dependent Claim
42 words
The method of claim 6 wherein the receiving step includes the step of: receiving user input which indicates that a particular one of said plurality of equivalent alternate display values is to be stored in the associated column of said database table.
Claim 9
Dependent Claim
23 words
The method of claim 1 wherein the step of applying includes: displaying alternate display values for said lookup column of said database table.
Claim 10
Dependent Claim
114 words
A computer operable method for maintaining display parameters associated with a lookup column of a database table comprising the steps of: receiving user input indicative of parameters associated with a lookup field of said lookup column of said database table; generating said display parameters from said parameters, said display parameters identify at least one alternate value for said lookup field of said lookup column; storing said display parameters in a data dictionary associated with said database table; retrieving said display parameters in response to a user request to access said lookup column of said database table; and utilizing said alternate value to present data in said lookup column in response to said user request.
Claim 11
Dependent Claim
114 words
A computer operable method for maintaining display parameters associated with a lookup column of a database table comprising the steps of: receiving user input indicative of parameters associated with a lookup field of said lookup column of said database table; generating said display parameters from said parameters, said display parameters identify at least one alternate value for said lookup field of said lookup column; storing said display parameters in a data dictionary associated with said database table; retrieving said display parameters in response to a user request to access said lookup column of said database table; and utilizing said alternate value to present data in said lookup column in response to said user request.
Claim 12
Dependent Claim
41 words
The method of claim 9 wherein the receiving step includes the step of: receiving user input indicative of a list of entries each including at least one alternate display value to be associated with said lookup column of said database table.
Claim 13
Dependent Claim
29 words
The method of claim 10 wherein each of said entries including an alternate display value comprises a plurality of equivalent values associated with each of said alternate display values.
Claim 14
Dependent Claim
43 words
The method of claim 11 wherein the receiving step includes the step of: receiving user input indicative that one of said plurality of equivalent values of said each of said entries is to be stored in the associated column of said database table.
Claim 15
Dependent Claim
62 words
The method of claim 9 wherein the receiving step includes the steps of: receiving user input indicative of a second database table to be joined with said database table; and receiving user input indicative of a query command to be applied to said second database table to select at least one alternate display value associated with said column of said database table.
Claim 16
Dependent Claim
20 words
The method of claim 13 wherein said query command is operable to select a plurality of equivalent alternate display values.
Claim 17
Dependent Claim
41 words
The method of claim 14 wherein the receiving step includes the step of: receiving user input indicative that a particular one of said plurality of equivalent alternate display values is to be stored in the associated column of said database table.
Claim 18
Dependent Claim
123 words
A computer operable method for presenting at least one alternate value associated with data stored in a column of a database table comprising the steps of: retrieving, in response to a user query that accesses said data of said column of said database table, display parameters associated with said column of said database table, said display parameters includes a list of entries each including at least one alternate display value to be associated with said column of said database table; determining, from said display parameters, at least one alternate value associated with said data stored in said column of said database table; and presenting a result of said user query wherein said at least one alternate value is presented to the requesting user.
Claim 19
Dependent Claim
123 words
A computer operable method for presenting at least one alternate value associated with data stored in a column of a database table comprising the steps of: retrieving, in response to a user query that accesses said data of said column of said database table, display parameters associated with said column of said database table, said display parameters includes a list of entries each including at least one alternate display value to be associated with said column of said database table; determining, from said display parameters, at least one alternate value associated with said data stored in said column of said database table; and presenting a result of said user query wherein said at least one alternate value is presented to the requesting user.
Claim 20
Dependent Claim
29 words
The method of claim 16 wherein each of said entries including an alternate display value comprises a plurality of equivalent values associated with each of said alternate display values.
Claim 21
Dependent Claim
61 words
The method of claim 16 wherein said display parameters includes: a first data object indicative of a second database table to be joined with said database table; and a second data object indicative of a query command to be applied to said second database table to select at least one alternate display value associated with said column of said database table.
Claim 22
Dependent Claim
20 words
The method of claim 18 wherein said query command is operable to select a plurality of equivalent alternate display values.
Claim 23
Dependent Claim
120 words
A program storage device readable by a computer, tangibly embodying a program or instructions executable by the computer to perform the method steps maintaining display parameters associated with a lookup column of a database table, said method steps comprising: receiving user input indicative of at least one display parameter which identifies at least one alternate value associated with a lookup field of said lookup column of said database table; storing said at least one display parameter in a data dictionary associated with said database table; retrieving, responsive to access to said lookup column of said database, said display parameter from said data dictionary; and applying said retrieved display parameter to present data corresponding to said lookup column of said database.
Claim 24
Dependent Claim
120 words
A program storage device readable by a computer, tangibly embodying a program or instructions executable by the computer to perform the method steps maintaining display parameters associated with a lookup column of a database table, said method steps comprising: receiving user input indicative of at least one display parameter which identifies at least one alternate value associated with a lookup field of said lookup column of said database table; storing said at least one display parameter in a data dictionary associated with said database table; retrieving, responsive to access to said lookup column of said database, said display parameter from said data dictionary; and applying said retrieved display parameter to present data corresponding to said lookup column of said database.
Claim 25
Dependent Claim
43 words
The program storage device of claim 20 wherein the receiving step includes the step of: receiving user input indicative of a list of entries each including at least one alternate display value to be associated with said lookup column of said database table.
Claim 26
Dependent Claim
31 words
The program storage device of claim 21 wherein each of said entries including an alternate display value comprises a plurality of equivalent values associated with each of said alternate display values.
Claim 27
Dependent Claim
53 words
The program storage device of claim 22 wherein the receiving step includes the step of: receiving user input indicative that a the alternate display value in a particular one of said plurality of equivalent values of said each of said entries is to be stored in the associated column of said database table.
Claim 28
Dependent Claim
64 words
The program storage device of claim 20 wherein the receiving step includes the steps of: receiving user input indicative of a second database table to be joined with said database table; and receiving user input indicative of a query command to be applied to said second database table to select at least one alternate display value associated with said column of said database table.
Claim 29
Dependent Claim
22 words
The program storage device of claim 24 wherein said query command is operable to select a plurality of equivalent alternate display values.
Claim 30
Dependent Claim
43 words
The program storage device of claim 25 wherein the receiving step includes the step of: receiving user input indicative that a particular one of said plurality of equivalent alternate display values is to be stored in the associated column of said database table.
Claim 31
Dependent Claim
24 words
The program storage device of claim 20 wherein the step of applying includes: displaying alternate display values for the column of said database table.
Claim 32
Dependent Claim
143 words
A program storage device readable by a computer, tangibly embodying a program or instructions executable by the computer to perform the method steps for maintaining display parameters which identify parameters used in the display of alternate values associated with a lookup column of a database table, said method steps comprising: receiving user input indicative of parameters associated with a lookup field of said lookup column of said database table; generating said display parameters from said parameters, said display parameters identify at least one alternate value for said lookup field of said lookup column; storing said display parameters in a data dictionary associated with said database table; retrieving said display parameters in response to a user request to access said lookup column of said database table; and utilizing said alternate value to present data in said lookup column in response to said user request.
Claim 33
Dependent Claim
143 words
A program storage device readable by a computer, tangibly embodying a program or instructions executable by the computer to perform the method steps for maintaining display parameters which identify parameters used in the display of alternate values associated with a lookup column of a database table, said method steps comprising: receiving user input indicative of parameters associated with a lookup field of said lookup column of said database table; generating said display parameters from said parameters, said display parameters identify at least one alternate value for said lookup field of said lookup column; storing said display parameters in a data dictionary associated with said database table; retrieving said display parameters in response to a user request to access said lookup column of said database table; and utilizing said alternate value to present data in said lookup column in response to said user request.
Claim 34
Dependent Claim
43 words
The program storage device of claim 28 wherein the receiving step includes the step of: receiving user input indicative of a list of entries each including at least one alternate display value to be associated with said lookup column of said database table.
Claim 35
Dependent Claim
31 words
The program storage device of claim 29 wherein each of said entries including an alternate display value comprises a plurality of equivalent values associated with each of said alternate display values.
Claim 36
Dependent Claim
53 words
The program storage device of claim 30 wherein the receiving step includes the step of: receiving user input indicative that a the alternate display value in a particular one of said plurality of equivalent values of said each of said entries is to be stored in the associated column of said database table.
Claim 37
Dependent Claim
64 words
The program storage device of claim 28 wherein the receiving step includes the steps of: receiving user input indicative of a second database table to be joined with said database table; and receiving user input indicative of a query command to be applied to said second database table to select at least one alternate display value associated with said column of said database table.
Claim 38
Dependent Claim
22 words
The program storage device of claim 32 wherein said query command is operable to select a plurality of equivalent alternate display values.
Claim 39
Dependent Claim
43 words
The program storage device of claim 33 wherein the receiving step includes the step of: receiving user input indicative that a particular one of said plurality of equivalent alternate display values is to be stored in the associated column of said database table.
Claim 40
Dependent Claim
142 words
A program storage device readable by a computer, tangibly embodying a program or instructions executable by the computer to perform the method steps for presenting at least one alternate value associated with data stored in a column of a database table, said method steps comprising: retrieving, in response to a user query that accesses said data of said column of said database table, display parameters associated with said column of said database table, said display parameters includes a list of entries each including at least one alternate display value to be associated with said column of said database table; determining, from said display parameters, at least one alternate value associated with said data stored in said column of said database table; and presenting a result of said user query wherein said at least one alternate value is presented to the requesting user.
Claim 41
Dependent Claim
142 words
A program storage device readable by a computer, tangibly embodying a program or instructions executable by the computer to perform the method steps for presenting at least one alternate value associated with data stored in a column of a database table, said method steps comprising: retrieving, in response to a user query that accesses said data of said column of said database table, display parameters associated with said column of said database table, said display parameters includes a list of entries each including at least one alternate display value to be associated with said column of said database table; determining, from said display parameters, at least one alternate value associated with said data stored in said column of said database table; and presenting a result of said user query wherein said at least one alternate value is presented to the requesting user.
Claim 42
Dependent Claim
31 words
The program storage device of claim 35 wherein each of said entries including an alternate display value comprises a plurality of equivalent values associated with each of said alternate display values.
Claim 43
Dependent Claim
63 words
The program storage device of claim 35 wherein said display parameters includes: a first data object indicative of a second database table to be joined with said database table; and a second data object indicative of a query command to be applied to said second database table to select at least one alternate display value associated with said column of said database table.
Claim 44
Dependent Claim
22 words
The program storage device of claim 37 wherein said query command is operable to select a plurality of equivalent alternate display values.
References Cited (Backward Citations)
US5566330A
Cited
US5553218A
Cited
US5561793A
Cited
US5615367A
Cited
US5619688A
Cited
US5499359A
Cited
US5603025A
Cited
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 2001-10-19 | 2002-04-20 | 2002-10-20 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2005-10-19 | 2006-04-20 | 2006-10-20 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2009-10-19 | 2010-04-20 | 2010-10-20 | $7700.00 | Window Closed / Lapsed |