Natural language support for database applications

• US 7,814,127 B2
• Filed: 11/20/2003
• Issued: 10/12/2010
• Est. Priority Date: 11/20/2003
• Status: Active Grant

• Current Assignee: Workday Incorporated
• Original Assignee: International Business Machines Corporation
• Inventors: Dettinger, Richard D., Stevens, Richard J., Kulack, Frederick A.
• Primary Examiner(s): Pham; Khanh B
• Application Number:
  US10/718,218
• Publication Number:
  US 20050114329A1
• Time in Patent Office: 2,518 Days
• Field of Search: 704/4, 704/9, 704/10, 715/534, 345/748
• US Class Current: 707/810
• CPC Class Codes: G06F 16/243 Natural language query formulation
• CPC Class Codes: G06F 16/24522 Translation of natural language queries to structured queries
• CPC Class Codes: G06F 16/90332 Natural language query formulation or dialogue systems

Abstract

A method, system and article of manufacture for data processing in databases and, more particularly, for providing natural language support in a database environment. One embodiment provides a method of providing natural language support for users running queries against a database. The method comprises providing a data abstraction model comprising a plurality of logical fields abstractly describing physical data residing in the database, and associating the data abstraction model with a language resource component defining a natural language expression for each of the plurality of logical fields.

Claims

1. A method of providing natural language support for users running queries against a database, comprising:

providing a data abstraction model comprising a plurality of logical fields abstractly describing physical data residing in the database;

associating the data abstraction model with a language resource component defining a natural language expression for each of the plurality of logical fields;

creating an effective data abstraction model by modifying the data abstraction model in accordance with a view that reflects one or more security settings for a group of users; and

displaying, to a user of the group of users, the effective data abstraction model.

2. The method of claim 1, further comprising:

creating the language resource component for the data abstraction model, the creating comprising mapping a default value to each logical field of the plurality of logical fields.

3. The method of claim 1, wherein the associating comprises:

generating, in the data abstraction model, a reference to the language resource component to associate the data abstraction model with the language resource component.

4. The method of claim 3, wherein the associated language resource component is an XML Localization Interchange File Format resource.

5. A method of providing natural language support for users running queries against a database, comprising:

providing a data abstraction model comprising a plurality of logical fields abstractly describing physical data residing in the database;

providing translation information for the data abstraction model describing translations of each of the plurality of logical fields from a first natural language expression to two or more second natural language expressions; and

displaying one of the second natural language expressions to a user, wherein which of the two or more second natural language expressions is displayed depends upon which natural language expression files are loaded to define a language resource component associated with the data abstraction model.

6. The method of claim 5, wherein the first and second natural language expressions are two different languages.

7. The method of claim 5, wherein the first and second natural language expressions are two different variations on the same language.

8. The method of claim 5, wherein providing translation information comprises providing an XML Localization Interchange File Format resource.

9. The method of claim 5, wherein the data abstraction model further comprises a reference to at least a portion of the translation information.

10. The method of claim 9, wherein the referenced portion is a default file.

11. The method of claim 5, wherein providing translation information comprises successively loading language resource files, wherein each successive language resource file comprises translations of increasing specificity to replace relatively less specific translations of one or more previously loaded language resource files.

12. The method of claim 5, wherein the translation information further describes translations of each of the plurality of logical fields from the first natural language expression to a third natural language expression, and further comprising:

displaying, to a user, at least a portion of the data abstraction model using only one of the first natural language expression, one of the two or more second natural language expression and the third natural language expression.

13. The method of claim 12, wherein which language expression is used to display the portion of the data abstraction model is based on user parameters.

14. The method of claim 13, wherein the user parameters describe a context of the user.

15. The method of claim 5, further comprising:

retrieving an abstract query expressed in the first natural language expression;

translating the abstract query on the basis of the translation information to express the abstract query in the second natural language expression; and

displaying the abstract query expressed in the second natural language expression.

16. A method of providing natural language support for users running queries against a database, comprising:

retrieving an abstract query comprising a plurality of logical fields, each corresponding to a logical field specification of a data abstraction model abstractly describing physical data residing in the database;

determining, from the data abstraction model, an associated language resource component;

determining, from the associated language resource component, at least two natural language expressions for the plurality of logical fields of the abstract query; and

displaying the abstract query in one of the at least two determined natural language expressions to a user, wherein the natural language expression displayed is determined by a security setting of the user.

17. The method of claim 16, further comprising, prior to displaying the abstract query, translating the abstract query from another natural language expression in which the abstract query was initially written.

18. The method of claim 16 wherein the associated language resource component is a language resource file, the data abstraction model including a reference to the language resource file.

19. A computer-readable medium containing a program which, when executed by a processor, performs a process of providing natural language support for users running queries against a database, the process comprising:

generating a data abstraction model comprising a plurality of logical fields abstractly describing physical data residing in the database;

associating the data abstraction model with a language resource component defining a natural language expression for each of the plurality of logical fields;

creating an effective data abstraction model by modifying the data abstraction model in accordance with the a view that reflects one or more security settings for a group of users; and

displaying, to a user of the group of users, the effective data abstraction model.

20. The computer-readable medium of claim 19, wherein the process further comprises:

displaying, to a user, at least a portion of the data abstraction model in accordance with the natural language expression defined by the language resource component.

21. The computer-readable medium of claim 19, wherein the process further comprises:

creating the language resource component for the data abstraction model, the creating comprising mapping a default value to each logical field of the plurality of logical fields.

22. The computer-readable medium of claim 19, wherein the associating comprises:

generating, in the data abstraction model, a reference to the language resource component to associate the data abstraction model with the language resource component.

23. The computer-readable medium of claim 22, wherein the associated language resource component is an XML Localization Interchange File Format resource.

24. A computer-readable medium containing a program which, when executed by a processor, performs a process of providing natural language support for users running queries against a database, the process comprising:

retrieving a data abstraction model comprising a plurality of logical fields abstractly describing physical data residing in the database;

retrieving translation information for the data abstraction model describing translations of each of the plurality of logical fields from a first natural language expression to a second natural language expression;

creating an effective data abstraction model by modifying the data abstraction model in accordance with the translation information and a view that reflects one or more security settings for a group of users; and

displaying, to a user of the group of users, the effective data abstraction model.

25. The computer-readable medium of claim 24, wherein the first and second natural language expressions are two different languages.

26. The computer-readable medium of claim 24, wherein the first and second natural language expressions are two different variations on the same language.

27. The computer-readable medium of claim 24, wherein retrieving translation information comprises retrieving an XML Localization Interchange File Format resource.

28. The computer-readable medium of claim 24, wherein the data abstraction model further comprises a reference to at least a portion of the translation information.

29. The computer-readable medium of claim 28, wherein the referenced portion is a default file.

30. The computer-readable medium of claim 24, wherein retrieving translation information comprises successively loading language resource files, wherein each successive language resource file comprises translations of increasing specificity to replace relatively less specific translations of one or more previously loaded language resource files.

31. The computer-readable medium of claim 24, wherein the translation information further describes translations of each of the plurality of logical fields from the first natural language expression to a third natural language expression, and the process further comprising:

displaying, to a user, at least a portion of the data abstraction model using only one of the first natural language expression, the second natural language expression and the third natural language expression.

32. The computer-readable medium of claim 31, wherein which language expression is used to display the portion of the data abstraction model is based on user parameters.

33. The computer-readable medium of claim 32, wherein the user parameters describe a context of the user.

34. The computer-readable medium of claim 24, wherein the process further comprises:

retrieving an abstract query expressed in the first natural language expression;

translating the abstract query on the basis of the translation information to express the abstract query in the second natural language expression; and

displaying the abstract query expressed in the second natural language expression.

35. A computer-readable medium containing a program which, when executed by a processor, performs a process of providing natural language support for users running queries against a database, the process comprising:

retrieving an abstract query comprising a plurality of logical fields, each corresponding to a logical field specification of a data abstraction model abstractly describing physical data residing in the database;

determining, from the data abstraction model, an associated language resource component;

determining, from the associated language resource component, at least two natural language expressions for the plurality of logical fields of the abstract query; and

displaying the abstract query in one of the at least two determined natural language expressions to a user, wherein the natural language expression displayed is determined by a security setting of the user.

36. The computer-readable medium of claim 35, wherein the process further comprises, prior to displaying the abstract query, translating the abstract query from another natural language expression in which the abstract query was initially written.

37. The computer-readable medium of claim 35 wherein the associated language resource component is a language resource file, the data abstraction model including a reference to the language resource file.

38. A computer system, comprising:

a database having data; and

a natural language support manager residing in memory for providing natural language support for users running queries against the data of the database, the natural language support manager being configured for;

retrieving a data abstraction model comprising a plurality of logical fields abstractly describing physical data residing in the database;

associating the data abstraction model with a language resource component defining a natural language expression for each of the plurality of logical fields;

creating an effective data abstraction model by modifying the data abstraction model in accordance with the translation information and a view that reflects one or more security settings for a group of users; and

displaying, to a user of the group of users, the effective data abstraction model.

39. A computer system, comprising:

a database having data; and

a natural language support manager residing in memory for providing natural language support for users running queries against the data of the database, the natural language support manager being configured for;

retrieving a data abstraction model comprising a plurality of logical fields abstractly describing physical data residing in the database;

retrieving translation information for the data abstraction model describing translations of each of the plurality of logical fields from a first natural language expression to a second natural language expression;

creating an effective data abstraction model by modifying the data abstraction model in accordance with the translation information and a view that reflects one or more security settings for a group of users; and

displaying, to a user of the group of users, the effective data abstraction model.

40. A computer system, comprising:

a database having data; and

a natural language support manager residing in memory for providing natural language support for users running queries against the data of the database, the natural language support manager being configured for;

retrieving an abstract query comprising a plurality of logical fields, each corresponding to a logical field specification of a data abstraction model abstractly describing physical data residing in the database;

determining, from the data abstraction model, an associated language resource component;

determining, from the associated language resource component, at least two natural language expressions for the plurality of logical fields of the abstract query; and

displaying the abstract query in one of the at least two determined natural language expressions to a user, wherein the natural language expression displayed is determined by a security setting of the user.