UNIFICATION OF SEARCH AND ANALYTICS

• US 20140156634A1
• Filed: 11/30/2012
• Published: 06/05/2014
• Est. Priority Date: 11/30/2012
• Status: Active Grant

• Current Assignee: SAP SE
• Original Assignee: Christian Munkel
• Inventors: Buchmann, Daniel, Pesarese, Marco, Kresser, Florian, Porscha, Waldemar, Michels, Frank, Mnkel, Christian
• Granted Patent: US 9,703,833 B2
• Time in Patent Office: Days
• US Class Current: 707/714
• 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, the request comprising a first subrequest associated with a search attribute view and a second subrequest associated with an analytical view;

define a join between the search attribute view and the analytical view based on one or more view attributes of the search attribute view; and

filter a result set of associated with the first subrequest based on the join and on the join filter criteria.

2. A system according to claim 1, wherein definition of the join comprises embedding of the attribute view into the analytical view.

3. A system according to claim 2, wherein the join joins an anchor table of the analytical view and the embedded attribute view.

4. A system according to claim 1, wherein the join joins an anchor table of the analytical view and the attribute view.

5. A system according to claim 1, wherein the analytical view comprises at least one calculated member and the attribute view comprises at least one item.

6. 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, the request comprising a first subrequest associated with a search attribute view and a second subrequest associated with an analytical view;

define a join between the search attribute view and the analytical view based on one or more view attributes of the search attribute view; and

filter a result set of associated with the first subrequest based on the join and on the join filter criteria.

7. A medium according to claim 6, wherein definition of the join comprises embedding of the attribute view into the analytical view.

8. A medium according to claim 7, wherein the join joins an anchor table of the analytical view and the embedded attribute view.

9. A medium according to claim 6, wherein the join joins an anchor table of the analytical view and the attribute view.

10. A medium according to claim 6, wherein the analytical view comprises at least one calculated member and the attribute view comprises at least one item.

11. A computer-implemented method comprising:

receive 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;

define a join between the search attribute view and the analytical view based on one or more view attributes of the search attribute view; and

filter a result set of associated with the first subrequest based on the join and on the join filter criteria.

12. A method according to claim 11, wherein defining the join comprises embedding of the attribute view into the analytical view.

13. A method according to claim 12, wherein the join joins an anchor table of the analytical view and the embedded attribute view.

14. A method according to claim 11, wherein the join joins an anchor table of the analytical view and the attribute view.

15. A method according to claim 11, wherein the analytical view comprises at least one calculated member and the attribute view comprises at least one item.