System and method for the support of multilingual applications

• US 7,818,282 B2
• Filed: 07/02/2004
• Issued: 10/19/2010
• Est. Priority Date: 07/02/2004
• Status: Expired due to Fees

• Current Assignee: LinkedIn Corporation (Microsoft Corporation)
• Original Assignee: International Business Machines Corporation
• Inventors: Ferguson, Kevin M., Potter, Charles M., Cazemier, Hendrik, Blackwell, Richard F., McCully, Eric, Godfrey, Lee Daw-Yong, Lacoursiere, Guy, Tennier, Claude, Leese, Kenneth R., Salter, Wayne C.
• Primary Examiner(s): Le; Miranda
• Application Number:
  US10/884,807
• Publication Number:
  US 20060004738A1
• Time in Patent Office: 2,300 Days
• Field of Search: 707 1- 10, 707100-1041, 707200-201, 707/999.004, 707/999.01, 707/802, 707/807, 707/810, 704 1- 5, 704/8, 704/9, 715530-531, 715/536, 715/703, 715/234, 715/203, 705/26, 705/27
• US Class Current: 704/8
• CPC Class Codes: G06F 9/454 Multi-language systems; Localisation; Internationalisation
• CPC Class Codes: Y10S 707/99934 Query formulation, input preparation, or translation

Abstract

A method, a system and a storage medium for preparing multilingual reports at client sites. The client sites are connected to a server and a data source. Each of the client sites may use a different locale. A product locale is selected at the client site for defining a user interface appearance. After a report specification is generated, a content locale is selected at the client site, which defines an appearance and a format of a report. A metadata model with run-time parameters is then constructed. The run-time parameters include mapping rules for the content locale. The run-time parameters are updated based on the content locale. A query is built using the report specification and the metadata model. Data appropriate to the individual content locale is then extracted from the same data source using the query.

Claims

1. A method for preparing multilingual reports at client sites, the client sites connected to a server and a data source of a database, the method comprising:

receiving selection of a product locale from a plurality of locales at a client site, wherein the product locale defines a user interface appearance for a user interface, and wherein each of the client sites uses at least one of the plurality of locales;

generating a report specification based on input received from the user interface, wherein the report specification is used to extract data from the data source of the database, and wherein the report specification provides a structure for a report produced from the report specification;

receiving selection of a content locale from the plurality of locales at the client site;

constructing a metadata model having run-time parameters, wherein the run-time parameters include a session parameter that is based on the content locale, and wherein the metadata model includes model objects representing the data source of the database;

building a query using the report specification and the metadata model, wherein the query includes at least one data access statement having one or more expressions that determine one or more tables to use for substitution into the one or more expressions, wherein each of the one or more tables maps session parameters to values, and wherein at least one of the one or more tables comprises a parameter map defining an entire expression;

substituting one or more values into the one or more expressions based on the session parameter and the one or more tables to generate a resultant query, wherein the session parameter determines an appropriate entry in each of the one or more tables;

extracting content locale-specific data from the data source of the database using the resultant query; and

preparing a report using the extracted content locale-specific data, wherein the content locale defines an appearance and a format for content within the report.

2. The method of claim 1, wherein the one or more expressions comprise one or more macro-style text substitution expressions.

3. The method of claim 1, wherein the run-time parameters are updated by a lookup on a key-value table.

4. The method of claim 1, wherein the run-time parameters are updated by a lookup on a coded row table.

5. The method of claim 1, wherein the run-time parameters are updated by a lookup on a key-value table with separate query items on separate columns.

6. The method of claim 1, wherein the query is in Structured Query Language (SQL), and the one or more expressions are macrotized SQL expressions.

7. The method of claim 1, further comprising validating arbitrary content locale values, and mapping the arbitrary content locale values to content locale values in the data source.

8. The method of claim 1, wherein the product locale is a system default locale.

9. The method of claim 1, wherein the content locale is a browser locale.

10. The method of claim 1, wherein the content locale is a client environment locale.

11. The method of claim 1, further comprising mapping full product locales to an available product locale.

12. The method of claim 1 further comprising formatting dates, times, numbers and other numeric data inferred from the content locale.

13. A computer-readable memory medium storing instructions that cause a computer to:

receive selection of a product locale from a plurality of locales at a client site, wherein the product locale defines a user interface appearance for a user interface, and wherein the client site is part of a plurality of client sites, and wherein each of the client sites uses at least one of the plurality of locales;

generate a report specification based on input received from the user interface, wherein the report specification is used to extract data from the data source of the database, and wherein the report specification provides a structure for a report produced from the report specification;

receive selection of a content locale from the plurality of locales at the client site;

construct a metadata model having run-time parameters, wherein the run-time parameters include a session parameter that is based on the content locale, and wherein the metadata model includes model objects representing the data source of the database;

build a query using the report specification and the metadata model, wherein the query includes at least one data access statement having one or more expressions that determine one or more tables to use for substitution into the one or more expressions, wherein each of the one or more tables maps session parameters to values, and wherein at least one of the one or more tables comprises a parameter map defining an entire expression;

substitute one or more values into the one or more expressions based on the session parameter and the one or more tables to generate a resultant query, wherein the session parameter determines an appropriate entry in each of the one or more tables;

extract content locale-specific data from the data source of the database using the resultant query; and

prepare a report using the extracted content locale-specific data, wherein the content locale defines an appearance and a format for content within the report.

14. The computer-readable memory of claim 13, wherein the query is in Structured Query Language (SQL), and the one or more expressions are macrotized SQL expressions.

15. The computer-readable memory of claim 13, further comprising instructions to validate arbitrary content locale values, and mapping the arbitrary content locale values to content locale values in the data source.

16. The computer-readable memory medium of claim 13, wherein the product locale is a system default locale.

17. The computer-readable memory of claim 13, wherein the content locale is a browser locale.

18. The computer-readable memory of claim 13, wherein the content locale is a client environment locale.

19. The computer-readable memory of claim 13, further comprising instructions to format dates, times, numbers and other numeric data inferred from the content locale.