Data processing: database and file management or data structures – Database design – Data structure types
Patent
1996-03-20
1998-10-20
Amsbury, Wayne
Data processing: database and file management or data structures
Database design
Data structure types
707 3, 345156, 345326, 345340, 345347, G06F 1730
Patent
active
058262571
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.
REFERENCES:
patent: 5499359 (1996-03-01), Vijaykumar
patent: 5553218 (1996-09-01), Li et al.
patent: 5561793 (1996-10-01), Bennet et al.
patent: 5566330 (1996-10-01), Sheffield
patent: 5603025 (1997-02-01), Tabb et al.
patent: 5615367 (1997-03-01), Bennet et al.
patent: 5619688 (1997-04-01), Bosworth et al.
Karen Bowman and Kamali Abelson, Quest User's Guide, Gupta Tech, Inc., 1991, Chap. 4 "Creating and Opening Tables," pp. 54-68, Jan. 1991.
Karen Bowman and Kamali Abelson Quest User's Guide Gupta Tech., Inc., 1991, Chap. 5 "Editing table's," pp. 70-84, pp. 286-303 Chap. 17, Jan. 1991.
Karen Bowman and Kamali Abelson, Quest User's Guide Gupta Tech Chap. 6 "Querying tables," pp. 92-114, pp. 226-283 Chap. 16, Jan. 1991.
Karen Bowman and Kamali Abelson, Quest User's Guide Gupta Technologies, Inc., pp. 136-149, Chap. 8, pp. 174-182 Chap. 12, Jan. 1991.
Amsbury Wayne
Corrielus Jean M.
Microsoft Corporation
LandOfFree
Method and structure for maintaining and utilizing a lookup valu does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with Method and structure for maintaining and utilizing a lookup valu, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Method and structure for maintaining and utilizing a lookup valu will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-260006