Natural language query construction using purpose-driven template

• US 7,720,867 B2
• Filed: 09/08/2004
• Issued: 05/18/2010
• Est. Priority Date: 09/08/2004
• Status: Active Grant

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: Li, Hui, Subramanian, Keshavan, Joby, George, Goswami, Indranil, Bhandarkar, Veena, Sego, Robert M., Ranka, Sunil S.
• Primary Examiner(s): LeRoux; Etienne P
• Assistant Examiner(s): Nguyen; Cindy
• Application Number:
  US10/937,602
• Publication Number:
  US 20060053096A1
• Time in Patent Office: 2,078 Days
• Field of Search: 707/3, 707/4
• US Class Current: 707/793
• CPC Class Codes: G06F 16/2428 Query predicate definition using graphical user interfaces, including menus and forms G06F16/2423 takes precedence

Abstract

Constructing a query in a natural-language format using a purpose-driven query template. A user is prompted to select one of a plurality of query purposes. User-input is received indicating a selected one of the plurality of query purposes. A first list of conditions is selected from a plurality of lists of conditions based on the selected one of the plurality of query purposes, then displayed in a format in which each of a plurality of conditions in the first list is grammatically joined to at least one other condition in the first list to form a query sentence, and wherein each of the plurality of conditions in the first list is associated with a respective set of user-selectable values.

Claims

1. A method comprising:

prompting a user to select one of a plurality of templates;

receiving user input that indicates a selected one of the plurality of templates; and

displaying the selected template in a format in which each of a plurality of conditions is grammatically joined to at least one other condition to form a query sentence, and

wherein each of the plurality of conditions has;

(a) a pre-selected attribute that is not user-modifiable within the condition, and (b) one or more user-selectable fields, wherein a user-selectable field allows a user of the template to define the condition for the pre-selected attribute;

wherein the one or more user-selectable fields comprises a set of operators that express a relationship between two or more objects in the query sentence, and

wherein the method steps are performed by one or more computing devices.

2. The method of claim 1 further comprising prompting a user to select one of a plurality of query purposes.

3. The method of claim 2 further comprising receiving a request to query a data source and wherein prompting a user to select one of a plurality of query purposes comprises prompting a user to select one of the plurality of query purposes in response to receiving the request to query a data source.

4. The method of claim 3 wherein receiving a request to query a data source comprises receiving user-input that identifies one of a plurality of data sources to be queried.

5. The method of claim 4 wherein prompting a user to select one of the plurality of query purposes comprises:

selecting a first set of query purposes from a plurality of sets of query purposes based on the identified one of the plurality of data sources;

displaying the first set of query purposes; and

prompting the user to select a query purpose from the first set of query purposes.

6. The method of claim 1 wherein displaying the selected template comprises displaying the first selected template in a format in which the plurality of conditions in the first list are grammatically joined by respective conjunctions.

7. The method of claim 6 wherein at least one of the conjunctions is a disjunctive conjunction.

8. The method of claim 1 wherein at least one of the two or more objects in the query sentence is another set of user-selectable values.

9. The method of claim 1 wherein the set of operators comprises at least one equality operator.

10. The method of claim 1 wherein the at least one equality operator is a prose expression.

11. The method of claim 1 further comprising displaying, for each condition in the selected template, a value that indicates the number of data source records that meet both the condition and any preceding conditions in the first list of conditions.

12. The method of claim 1 further comprising displaying data source records that meet each of the conditions in the selected template.

25. The method of claim 1, further comprising:

an administrator indicating that one or more of the plurality of conditions is mandatory;

wherein the pre-selected attribute that is not user-modifiable within the condition is a mandatory condition.

26. The method of claim 1, further comprising:

an administrator indicating that one or more of the plurality of conditions is optional.

27. The method of claim 8 further comprising:

displaying the user-selectable values in the form of value prompts.

28. The method of claim 27 further comprising:

displaying the value prompts with distinctively shaded, colored, and/or formatted labels.

29. The method of claim 27 further comprising:

displaying multiple instances of the same value prompt in order to improve readability.

13. A method of generating a template comprising:

receiving a list of attributes;

for each attribute, receiving information that indicates how a user who forms a query using the template is allowed to define a condition for the attribute;

based on the list of attributes and the information, generating the template comprising a set of conditions, wherein each condition in the template is grammatically joined to at least one other condition in the template to form a query sentence, and wherein each condition in the template includes a pre-selected attribute from the list of attributes and one or more user-selectable fields based on the information, wherein the pre-selected attribute in each condition is not user-modifiable within the condition;

wherein the one or more user-selectable fields comprises a set of operators that express a relationship between two or more objects in the query sentence; and

storing the template,

wherein the method steps are performed by one or more computing devices.

14. The method of claim 13 wherein the list of attributes correspond to columns within a hierarchical data source.

15. The method of claim 13 further comprising:

prompting a user that is defining the template whether each of the conditions may be removed from the template at the option of a user who forms a query using the template.

16. The method of claim 13, wherein the pre-selected attribute in each of the conditions is not selectable by a user who forms a query using the template.

17. The method of claim 13, wherein generating the template defines a fixed grammatical structure for the template.

18. The method of claim 13, further comprising:

receiving user input that indicates a selection of a query purpose from a plurality of query purposes; and

associating the template with the query purpose.

19. The method of claim 13, wherein the information includes a set of values from which the user who forms a query using the template is allowed to select a value.

20. The method of claim 13, wherein the information defines a calculation that is to be made based on input from a user who forms a query using the template.

21. The method of claim 13, wherein the information defines input to be requested from a user who forms a query using the template.

22. The method of claim 13, wherein the information includes a set of value attributes from which a user who forms a query using the template is allowed to select a value attribute to be used in forming the condition.

23. The method of claim 13, wherein the information includes a set of operators from which the user who forms a query using the template is allowed to select an operator to form the condition for the pre-selected attribute.

24. A computer-readable medium storing one or more sequences of instructions which, when executed by one or more processors, causes the one or more processors to:

receiving a list of attributes;

for each attribute, receiving information that indicates how a user who forms a query using the template is allowed to define a condition for the attribute;

based on the list of attributes and the information, generating the template comprising a set of conditions, wherein each condition in the template is grammatically joined to at least one other condition in the template to form a query sentence, and wherein each condition in the template includes;

a pre-selected attribute from the list of attributes, and (b) one or more user-selectable fields based on the information, wherein the pre-selected attribute in each condition is not user-modifiable within the condition;

wherein the one or more user-selectable fields comprises a set of operators that express a relationship between two or more objects in the query sentence; and

storing the template.

30. A method comprising:

prompting a user to select one of a plurality of templates;

receiving user input that indicates a selected one of the plurality of templates;

displaying the selected template in a format in which each of a plurality of conditions is grammatically joined to at least one other condition to form a query sentence,

a user-selectable field allowing a user of the template to define the condition for the attribute;

wherein the user-selectable field comprises a set of operators that express a relationship between two or more objects in the query sentence;

displaying and updating the query sentence as the user makes adjustments to one or more of the plurality of conditions; and

concurrently displaying a running totals column thereby enabling a projected total of a number of records, said projected total of a number of records appearing as each of the plurality of conditions is applied,

wherein the method steps are performed by one or more computing devices.

31. The method of claim 30, further comprising:

displaying a delta column which shows a change in the number of returned records that results from application of one of the plurality of conditions.

32. The method of claim 30, further comprising:

displaying a delete column for deleting one or more of the conditions.

33. The method of claim 30 further comprising:

displaying a preview button for enabling a user to view of subset of entries that will appear in a query result.

34. The method of claim 30 further comprising:

displaying a recalculate button to execute a query expression and obtain running totals and delta values for the various conditions within that expression.

35. The method of claim 30 further comprising:

displaying an Structured Query Language (SQL) button which allows a user to view a natural language query expression in the format of an SQL statement.

36. The method of claim 30 further comprising:

displaying a generation link to view alternative generations of a query expression.

37. The method of claim 30 further comprising:

displaying an apply button to archive a query expression, notes, and other information entered by the user.

38. The method of claim 30 further comprising:

displaying a condition-entry display for presenting meta-data that includes an administrator'"'"'s selections from prior displays, name of a specific table, view or other data structure, and a unique identifier that may be used as a primary key.

39. The method of claim 30 further comprising:

allowing an administrator to enter an attribute display name; and

displaying that attribute display name within a natural language query expression.