Database script translation tool

• US 20050065771A1
• Filed: 09/18/2003
• Published: 03/24/2005
• Est. Priority Date: 09/18/2003
• Status: Active Grant

• Current Assignee: Kyndryl Incorporated
• Original Assignee: International Business Machines Corporation
• Inventors: Handy Bosma, John Hans, Walker, Keith Raymond, Chen, Yen-Fu
• Granted Patent: US 7,415,405 B2
• Time in Patent Office: Days
• US Class Current: 704/2
• CPC Class Codes: G06F 40/53 Processing of non-Latin text kana-to-kanji conversion G06F40/129; vowelisation G06F40/232
• CPC Class Codes: G06F 40/55 Rule-based translation

Abstract

A method for translating the string literals in a database script from a source language (i.e. English) into a target language (i.e. Chinese). The invention comprises a Conversion Program (CP) and a Field Expansion Program (FEP). The CP copies a database script in a source language and runs the FEP, which analyzes the database script and determines the maximum width of the fields. The user may then adjust the field length as necessary. The CP then substitutes labels for the string literals in the new database script, which creates a message file. The CP uses a pre-existing data file to translate the source language string literals into the target language string literals. The translated message file is called a label file. The CP then uses the label file to substitute the target language string literals for the labels in the database script.

Claims

1. A method comprising:

acquiring a database script in a source language;

substituting a source language string literal with a label, thereby creating a message file;

using a data file to translate the source language string literal in the message file with a target language string literal, thereby creating a label file; and

substituting the label in the copied database script with the target language string literal in the label file.

2. The method of claim 1 further comprising:

adjusting the field width in the copied database script.

3. The method of claim 2 wherein the adjusting occurs without user intervention.

4. The method of claim 2 wherein the adjusting the field width step comprises:

analyzing a database script to determine the maximum width of each field;

displaying a list of fields, field widths, and maximum field widths; and

allowing a user to modify a field width.

5. The method of claim 1 further comprising:

running the copied database script to create a target language database.

6. The method of claim 1 further comprising:

copying the database script.

7. The method of claim 1 wherein the source language is English.

8. A program product operable on a computer, the program product comprising:

a computer-usable medium;

wherein the computer usable medium comprises instructions comprising;

instructions for acquiring a database script in a source language;

instructions for substituting a source language string literal with a label, thereby creating a message file;

instructions for using a data file to translate the source language string literal in the message file with a target language string literals, thereby creating a label file; and

instructions for substituting the label in the copied database script with the target language string literal in the label file.

9. The program product of claim 8 further comprising:

instructions for adjusting the field width in the copied database script.

10. The program product of claim 9 wherein the adjusting occurs without user intervention.

11. The program product of claim 9 wherein the adjusting the field width step comprises:

instructions for analyzing a database script to determine the maximum width of each field;

instructions for displaying a list of fields, field widths, and maximum field widths; and

instructions for allowing a user to modify a field width.

12. The program product of claim 8 further comprising:

instructions for running the copied database script to create a target language database.

13. The program product of claim 8 further comprising:

instructions for copying the database script.

14. The program product of claim 8 wherein the source language is English.

15. A program product operable on a computer, the program product comprising:

a computer-usable medium;

wherein the computer usable medium comprises instructions comprising;

a conversion program capable of converting a database script from a source language into a target language; and

a field expansion program capable of expanding the width of a field in the database script.

16. The program product of claim 15 wherein the conversion program comprises:

instructions for acquiring a database script in a source language;

instructions for substituting a source language string literal with a label, thereby creating a message file;

instructions for using a data file to translate the source language string literal in the message file with a target language string literals, thereby creating a label file; and

instructions for substituting the label in the copied database script with the target language string literal in the label file.

17. The program product of claim 16 wherein the conversion program further comprises:

instructions for adjusting the field width in the copied database script.

18. The program product of claim 17 wherein the adjusting occurs without user intervention.

19. The program product of claim 15 wherein the field expansion program comprises:

instructions for analyzing a database script to determine the maximum width of each field;

instructions for displaying a list of fields, field widths, and maximum field widths; and

instructions for allowing a user to modify a field width.

20. The program product of claim 16 wherein the conversion program further comprises:

instructions for running the copied database script to create a target language database.

21. The program product of claim 16 wherein the conversion program further comprises:

instructions for copying the database script.

22. The program product of claim 16 wherein the source language is English.

23. A graphical user interface (GUI) for translating a database script from a source language to a target language.

24. The GUI of claim 23 wherein the GUI comprises:

a window;

a menu displayed on the window;

an option displayed on the menu;

wherein user selection of the option causes a computer program to execute, the computer program comprising;

a conversion program capable of converting a database script from a source language into a target language; and

a field expansion program capable of expanding the width of a field in the database script.

25. The GUI of claim 24 wherein the conversion program comprises:

instructions for acquiring a database script in a source language;

instructions for substituting a source language string literal with a label, thereby creating a message file;

instructions for using a data file to translate the source language string literal in the message file with a target language string literals, thereby creating a label file; and

instructions for substituting the label in the copied database script with the target language string literal in the label file.

26. The GUI of claim 25 further comprising:

instructions for adjusting the field width in the copied database script.

27. The GUI of claim 26 wherein the adjusting occurs without user intervention.

28. The GUI of claim 24 wherein the field expansion program comprises:

instructions for analyzing a database script to determine the maximum width of each field;

instructions for displaying a list of fields, field widths, and maximum field widths; and

instructions for allowing a user to modify a field width.

29. The GUI of claim 25 further comprising:

instructions for running the copied database script to create a target language database.

30. The GUI of claim 25 further comprising:

instructions for copying the database script.

31. The GUI of claim 25 wherein the source language is English.