Unification of search and analytics

• US 9,703,833 B2
• Filed: 11/30/2012
• Issued: 07/11/2017
• Est. Priority Date: 11/30/2012
• Status: Active Grant

• Current Assignee: SAP SE
• Original Assignee: SAP SE
• Inventors: Kresser, Florian, Porscha, Waldemar, Michels, Frank, Mnkel, Christian, Buchmann, Daniel, Pesarese, Marco
• Primary Examiner(s): Lin, Shew-Fen
• Application Number:
  US13/690,510
• Publication Number:
  US 20140156634A1
• Time in Patent Office: 1,684 Days
• CPC Class Codes: G06F 16/24544 Join order optimisation
• CPC Class Codes: G06F 16/26 Visual data mining; Browsing structured data

Abstract

A system includes reception of a request conforming to a modeled query and join filter criteria, the request comprising a first subrequest associated with a search attribute view and a second subrequest associated with an analytical view, definition of a join between the search attribute view and the analytical view based on one or more view attributes of the search attribute view, and filtering of a result set associated with the first subrequest based on the join and on the join filter criteria.

Claims

1. A system comprising:

a computing device comprising;

a memory storing processor-executable program code; and

a processor to execute the processor-executable program code in order to cause the computing device to;

receive a request conforming to a modeled query and join filter criteria associated with join conditions, the request comprising a first subrequest associated with a text search result item list and a second subrequest associated with an analytical view and a table for data of the analytical view;

receive, via a get service, a query ID associated with the modeled query;

retrieve metadata associated with the query ID to be transmitted to a user, the metadata generated by a database administrator;

transmit the modeled query based on the metadata to the user;

receive an additional join filter from the user wherein the additional join filter comprises additional join filter criteria and is based on the received modeled query;

define a join between the text search result item list and the table, the join associating one or more attributes of the text search result item list with one or more facets of the table, wherein definition of the join comprises embedding of the text search result item list into the table;

receive search results corresponding to the text search result item list; and

filter the search results and a result set of data of the analytical view based on the join, the join filter criteria and on the additional join filter criteria.

2. The system according to claim 1, wherein the analytical view comprises at least one calculated member and the text search result item list comprises at least one item.

3. The system of claim 1, wherein the search results further comprise a generic information artifact comprising a log of messages associated with the metadata.

4. A non-transitory computer-readable medium storing program code, the program code executable by a processor of a computing system to cause the computing system to:

receive a request conforming to a modeled query and join filter criteria associated with join conditions, the request comprising a first subrequest associated with a text search result item list and a second subrequest associated with an analytical view and a table for data of the analytical view;

receive, via a get service, a query ID associated with the modeled query;

retrieve metadata associated with the query ID to be transmitted to a user, the metadata generated by a database administrator;

transmit the modeled query based on the metadata to the user;

receive an additional join filter from the user wherein the additional join filter comprises additional join filter criteria and is based on the received modeled query;

define a join between the text search result item list and the table, the join associating one or more attributes of the text search result item list with one or more facets of the table, wherein definition of the join comprises embedding of the text search result item list into the table;

receive search results corresponding to the text search result item list; and

filter the search results and a result set of data of the analytical view based on the join, the join filter criteria and on the additional join filter criteria.

5. The medium according to claim 4, wherein the analytical view comprises at least one calculated member and the text search result item list comprises at least one item.

6. The medium of claim 4, wherein the search results further comprise a generic information artifact comprising a log of messages associated with the metadata.

7. A computer-implemented method comprising:

receive a request conforming to a modeled query, the request comprising a first subrequest associated with a text search result item list and a second subrequest associated with an analytical view and a table for data of the analytical view;

receive, via a get service, a query ID associated with the modeled query;

retrieve metadata associated with the query ID to be transmitted to a user, the metadata generated by a database administrator;

transmit the modeled query based on the metadata to the user;

receive an additional join filter from the user wherein the additional join filter comprises additional join filter criteria and is based on the received modeled query;

define a join between the text search result item list and the table, the join including one or more view attributes of the text search result item list with one or more facets of the table, wherein definition of the join comprises embedding of the text search result item list into the table;

receive search results corresponding to the text search result item list; and

filter the search results and a result set of data of the analytical view based on the join, the join filter criteria and on the additional join filter criteria.

8. The method according to claim 7, wherein the analytical view comprises at least one calculated member and the text search result list comprises at least one item.

9. The method of claim 7, wherein the search results further comprise a generic information artifact comprising a log of messages associated with the metadata.