User defined text NLS enablement

• US 20040111254A1
• Filed: 12/05/2002
• Published: 06/10/2004
• Est. Priority Date: 12/05/2002
• Status: Abandoned Application

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Gogel, Edward D., Klosterboer, Larry K., Jen, Michael, Sack, Noah G.
• Application Number:
  US10/313,504
• Publication Number:
  US 20040111254A1
• Time in Patent Office: Days
• US Class Current: 704/8
• CPC Class Codes: G06F 16/284 Relational databases
• CPC Class Codes: G06F 9/454 Multi-language systems; Localisation; Internationalisation

Abstract

A system, method and program product for storing relational tables wherein the tables comprises alternative messages according to a variant such as a national language. The relational tables further comprise at least a message key specifying a message and a variant key specifying a variant for selecting the appropriate message from the alternative messages. For example, the relational tables comprise language variant=1 for English and Variant=2 for French. An SQL query searches or sorts the list relational tables for entries appropriate for the language of interest. The relational table entries can be edited and new alternative messages are assigned a new message key according to a predetermined algorithm.

Claims

1. A system for providing a relational table having a plurality of message texts, said system comprising:

a memory for storing data;

a relational table stored in said memory, said relational table having;

one or more message text areas wherein a first message text area comprises a plurality of message texts, said message texts comprising a first message text and a second message text;

one or more message identification areas wherein a first message identification area comprises a plurality of message identifications, wherein a first message identification is related to both of said first message text and said second message text; and

one or more variant identification areas wherein a first variant identification area comprises a plurality of first variant identifications and second variant identifications, wherein said first variant identification is related to said first message text.

2. The system of claim 1 wherein the first message text is in a first national language and the second message text is in a second national language, and the first variant identification area is related to national languages and the first variant identification is related to said first national language.

3. The system of claim 1 wherein the first variant identification area is related to any one of company, department or skill level and the first variant identification is related to any one of a first company, a first department or a first skill level.

4. The system of claim 1 further comprising an application program for supplying a message identification and a variant identification to said relational table for receiving from said table a message text related to said message identification said variant identification.

5. The system of claim 4 further comprising a second relational table joined to the first relational table by any one of said message identification or said variant identification wherein said application program provides a search argument to said second relational table, which second relational table supplies said one of said message identification or said variant identification for said first relational table.

6. The system of claim 1 further comprising an insertion program for adding at least one message identifier, variant identifier and message text into said relational table.

7. The system of claim 1 wherein said memory includes a message receiving area for receiving messages from said relational table, and said system further comprising a sort program for sorting the messages in said message receiving area whereby messages are sorted in accordance with the variant identified by the variant identifications of said received messages.

8. The system of claim 1 wherein said memory includes a message receiving area for receiving messages from said relational table, and said system further comprises a search routine for searching the messages in said message receiving area whereby messages are searched in accordance with the variant identified by the variant identifications of said received messages.

9. A method for providing a relational table having a plurality of message texts, said method comprising the steps of:

storing a relational table in a memory;

storing in said table one or more message text areas wherein a first message text area comprises a plurality of message texts, said message texts comprising a first message text and a second message text;

storing in said table one or more message identification areas wherein a first message identification area comprises a plurality of message identifications, wherein a first message identification is related to both of said first message text and said second message text; and

storing in said table one or more variant identification areas wherein a first variant identification area comprises a plurality of first variant identifications and second variant identifications, wherein said first variant identification is related to said first message text.

10. The method of claim 9 wherein the first message text is in a first national language and the second message text is in a second national language, and the first variant identification area is related to national languages and the first variant identification is related to said first national language.

11. The method of claim 9 wherein the first variant identification area is related to any one of company, department or skill level and the first variant identification is related to any one of a first company, a first department or a first skill level.

12. The method of claim 9 further comprising the steps of:

supplying a message identification

supplying a variant identification to said relational table; and

receiving from said table a message text related to said message identification said variant identification.

13. The method of claim 12 further comprising the steps of:

joining a second relational table to the first relational table by any one of said message identification or said variant identification;

providing a search argument to said second relational table; and

supplying from said second relational table said one of said message identification or said variant identification for said first relational table.

14. The method of claim 9 further comprising the steps of:

an insertion program adding at least one message identifier, variant identifier and message text into said relational table.

15. The method of claim 9 further comprising the steps of:

receiving at said memory in a message receiving area, messages from said relational table; and

sorting the messages in said message receiving area whereby messages are sorted in accordance with the variant identified by the variant identifications of said received messages.

16. The method of claim 9 further comprising the steps of:

receiving at said memory in a message receiving area, messages from said relational table; and

searching the messages in said message receiving area whereby messages are searched in accordance with the variant identified by the variant identifications of said received messages.

17. A computer program product for providing a relational table having a plurality of message texts, said computer program product comprising a computer readable medium having computer readable program code therein comprising:

computer readable program code for storing a relational table in a memory;

computer readable program code for storing in said table one or more message text areas wherein a first message text area comprises a plurality of message texts, said message texts comprising a first message text and a second message text;

computer readable program code for storing in said table one or more message identification areas wherein a first message identification area comprises a plurality of message identifications, wherein a first message identification is related to both of said first message text and said second message text; and

computer readable program code for storing in said table one or more variant identification areas wherein a first variant identification area comprises a plurality of first variant identifications and second variant identifications, wherein said first variant identification is related to said first message text.

18. The computer program product of claim 17 wherein the first message text is in a first national language and the second message text is in a second national language, and the first variant identification area is related to national languages and the first variant identification is related to said first national language.

19. The computer program product of claim 17 wherein the first variant identification area is related to any one of company, department or skill level and the first variant identification is related to any one of a first company, a first department or a first skill level

20. The computer program product of claim 17 further comprising

computer readable program code for supplying a message identification

computer readable program code for supplying a variant identification to said relational table;

and

computer readable program code for receiving from said table a message text related to said message identification said variant identification.