Semantic searches in a business intelligence system

• US 10,664,488 B2
• Filed: 09/22/2015
• Issued: 05/26/2020
• Est. Priority Date: 09/25/2014
• Status: Active Grant

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: Venkata, Ananth, Vigeant, Jacques, Gopalakrishna, Satish
• Primary Examiner(s): Lin, Shew Fen
• Application Number:
  US14/861,893
• Publication Number:
  US 20160092572A1
• Time in Patent Office: 1,708 Days
• CPC Class Codes: G06F 16/24534 Query rewriting; Transformation
• CPC Class Codes: G06F 16/248 Presentation of query results

Abstract

A computer-implemented method of executing a user query includes presenting a user interface to allow a user to enter a query, receiving a user-entered textual request through the interface, launching a search service to rewrite the textual request into a search query, sending the search query to a presentation server, receiving an answer to the query, and returning the answer to the user as a graphical representation. A computer-implemented method includes receiving a crawl request from a user, launching a crawl manager to monitor the crawl request and track statistics related to the crawl, starting a crawl task based upon the crawl request, indexing a business intelligence presentation server to create a data index, and storing the data index.

Claims

1. A computer-implemented method, comprising:

causing a graphical user interface to be displayed on a device, wherein the graphical user interface is generated by a search application executing on the device, and wherein the graphical user interface includes a search bar operable to accept user input;

receiving a first search term entered using the search bar;

displaying the first search term in the search bar;

generating a query using the first search term, wherein the query is generated by rewriting the first search term to a query language form;

executing, using the query, a search of one or more data stores by an index searcher;

determining a first visualization for presenting a first result obtained from searching the one or more data stores, wherein the first visualization is determined based on a number of search terms in the search bar and the first result, wherein the first visualization includes a chart of a first type;

displaying the first visualization in the graphical user interface;

receiving an indication of a selection of the first search term within the search bar;

in response to receiving the indication of the selection, displaying a drop down list within the graphical user interface, the drop down list including one or more suggested search parameters based on the first search term and a statistic indicating most frequently used search terms;

receiving a second search term due to selection of a suggested parameter from the one or more suggested search parameters in the drop down list;

displaying the second search term in the search bar, wherein the second search term is displayed simultaneously with the first search term;

determining, in response to receiving the second search term, a second result, wherein the second result is based on a number of search terms in the search bar and the second search term;

determining, in response to determining the second result, a second visualization for presenting the second result, wherein the second visualization includes a chart of a second type, wherein the second type is different from the first type; and

replacing, in response to determining the second visualization, the first visualization with the second visualization

adding the first search term, the second search term, and other inputs determined through the graphical user interface to a set of user preferences, wherein the set of user preferences are associated with a particular user, and where the set of user preferences is used to search the one or more data stores or to determine the first visualization or the second visualization; and

generating a graph, wherein nodes in the graph are associated with the set of user preferences, and wherein the graph is traversed to determine a user preference.

2. The computer-implemented method of claim 1, wherein the first search term is determined from a text string input into the search bar.

3. The computer-implemented method of claim 1, wherein the one or more suggested search terms are determined based on past searches.

4. The computer-implemented method of claim 1, wherein the second visualization is based on a number of search terms simultaneously displayed in the search bar.

5. The computer-implemented method of claim 1, wherein the first visualization is further based on a stored user preference.

6. The computer-implemented method of claim 1, further comprising:

generating one or more additional visualizations, wherein the one or more additional visualizations are based on the first search term, the first result, the second search term, and the second result; and

displaying, simultaneously with the second visualization, the one or more additional visualizations in a side bar in the graphical user interface, wherein at least one visualization of the one or more additional visualizations includes a chart of a third type, wherein the third type is different from the second type.

7. The computer-implemented method of claim 1, wherein determining the second result comprises:

generating a second query for the second search term; and

executing, using the second query, a second search of the one or more data stores, where the second visualization is further based on additional data included with a result of the second search.

8. The computer-implemented method of claim 1, further comprising:

adding the first search term and the second search term to a statistical model associated with the particular user, wherein the statistical model is used to determine content relevant to the particular user.

9. The computer-implemented method of claim 1, wherein the set of user preferences include statistics determined from search terms.

10. The computer-implemented method of claim 1, wherein the set of user preferences include information derived from the device when the first search term or the second search term is selected.

11. The computer-implemented method of claim 1, wherein the device is a mobile device.

13. The computer-implemented method of claim 1, further comprising:

determining the chart of the first type, based at least in part on a key term within the search bar, wherein the key term includes at least one of the following terms;

versus;

target;

or

projected.

12. A system, comprising:

a search system comprising one or more servers; and

a data store storing data indexes;

wherein the search system is configured to;

cause a graphical user interface to be displayed on a device, wherein the graphical user interface includes a search bar operable to accept user input;

receive a first search term entered using the search bar;

generate a query using the first search term, wherein the query is generated by rewriting the first search term to a query language form;

execute, using the query, a search of one or more data stores by an index searcher;

determine a first visualization for presenting a first result obtained from searching the one or more data stores, wherein the first visualization is determined based on a number of search terms in the search bar, context associated with the first search term, and with the first result, wherein the first visualization includes a chart of a first type;

display the first visualization in the graphical user interface;

receive an indication of a selection of the first search term within the search bar;

in response to receiving the indication of the selection, display a drop down list within the graphical user interface, the drop down list including one or more suggested search parameters based on the first search term and a statistic indicating most frequently used search terms;

receive a second search term due to selection of a suggested parameter from the one or more suggested search parameters in the drop down list wherein the second search term is present in the search bar, simultaneous with the first search term, and wherein the second search term is entered after the first visualization is displayed;

determine, in response to receiving the second search term, a second result, wherein the second result is based on a number of search terms in the search bar and context associated with the second search term;

determine, in response to determining the second result, a second visualization for presenting the second result, wherein the second visualization includes a chart of a second type, wherein the second type is different from the first type; and

replace, in response to determining the second visualization, the first visualization with the second visualization

add the first search term, the second search term, and other inputs determined through the graphical user interface to a set of user preferences, wherein the set of user preferences are associated with a particular user, and where the set of user preferences is used to search the one or more data stores or to determine the first visualization or the second visualization; and

generate a graph, wherein nodes in the graph are associated with the set of user preferences, and wherein the graph is traversed to determine a user preference.

14. The system according to claim 12, wherein the search system is further configured to:

generate a second query for the second search term; and

execute, using the second query, a second search of the one or more data stores, where the second visualization is further based on additional data included with a result of the second search.

15. The system of claim 14, wherein the first search term is determined from a text string input into the search bar.

16. The system of claim 12, wherein the one or more suggested search terms are determined based on past searches.

17. The system of claim 14, wherein the second visualization is based on a number of search terms simultaneously displayed in the search bar.

18. The system of claim 14, wherein the search system is further configured to:

generate one or more additional visualizations, wherein the one or more additional visualizations are based on the first search term, the first result, the second search term, and the second result; and

display, simultaneously with the second visualization, the one or more additional visualizations in a side bar in the graphical user interface, wherein at least one visualization of the one or more additional visualizations includes a chart of a third type, wherein the third type is different from the second type.