Method and structure for maintaining and utilizing a lookup value associated with a stored database value

• US 5,826,257 A
• Filed: 03/20/1996
• Issued: 10/20/1998
• Est. Priority Date: 03/20/1996
• Status: Expired due to Term

• Current Assignee: Microsoft Technology Licensing LLC (Microsoft Corporation)
• Original Assignee: Microsoft Corporation
• Inventors: Snelling, George Arthur Jr.
• Primary Examiner(s): Amsbury, Wayne
• Assistant Examiner(s): Corrielus, Jean M.
• Application Number:
  US08/619,129
• Time in Patent Office: 944 Days
• Field of Search: 395/604, 707/4, 707/3, 345/156, 345/326, 345/340, 345/347
• US Class Current: 1/1
• CPC Class Codes: G06F 16/284 Relational databases
• CPC Class Codes: Y10S 707/99933 Query processing, i.e. searching
• CPC Class Codes: Y10S 707/99934 Query formulation, input preparation, or translation

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.

Claims

1. 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.

2. 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.

3. 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.

4. 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.

5. 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.

6. The method of claim 5 wherein said query command is operable to select a plurality of equivalent alternate display values.

7. 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.

8. The method of claim 1 wherein the step of applying includes:

displaying alternate display values for said lookup column of said database table.

9. 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.

10. 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.

11. 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.

12. 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.

13. 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.

14. The method of claim 13 wherein said query command is operable to select a plurality of equivalent alternate display values.

15. 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.

16. 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.

17. 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.

18. 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.

19. The method of claim 18 wherein said query command is operable to select a plurality of equivalent alternate display values.

20. 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.

21. 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.

22. 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.

23. 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.

24. 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.

25. The program storage device of claim 24 wherein said query command is operable to select a plurality of equivalent alternate display values.

26. 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.

27. The program storage device of claim 20 wherein the step of applying includes:

displaying alternate display values for the column of said database table.

28. 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.

29. 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.

30. 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.

31. 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.

32. 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.

33. The program storage device of claim 32 wherein said query command is operable to select a plurality of equivalent alternate display values.

34. 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.

35. 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.

36. 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.

37. 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.

38. The program storage device of claim 37 wherein said query command is operable to select a plurality of equivalent alternate display values.