EFFICIENT ASSIGNMENT OF QUERY REQUESTS BETWEEN ANALYTICAL ENGINES OF DIFFERING COMPLEXITY

• US 20140181005A1
• Filed: 12/20/2012
• Published: 06/26/2014
• Est. Priority Date: 12/20/2012
• Status: Active Grant

• Current Assignee: SAP SE
• Original Assignee: SAP SE
• Inventors: Baumgaertel, Dirk, Schwerk, Uwe, Nos, Karl-Peter
• Granted Patent: US 9,177,036 B2
• Time in Patent Office: Days
• US Class Current: 707/602
• CPC Class Codes: G06F 16/283 Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP

Abstract

Runtime performance of report generation and other response to query requests can be improve using a report analyzer that can parse the query request and distribute the necessary analytical task among two or more analytical engines of varying levels of complexity.

Claims

1. A computer program product comprising a machine-readable medium storing instructions that, when executed by at least one programmable processor, cause the at least one programmable processor to perform operations comprising:

analyzing a received query request at runtime to determine a level of analytical complexity required to generate a report responsive to the query request;

distributing the one or more analysis tasks among a plurality of analytical reporting engines of differing analytical complexity such that a full complexity analytical engine of the plurality of analytical reporting engines is used only for those of the one or more analysis tasks that require capabilities of the full complexity analytical engine;

distributing those of the one or more analysis tasks that do not require capabilities of the full complexity analytical engine to one or more reduced complexity analytical engines of the plurality of analytical reporting engines, the one or more reduced complexity analytical reporting engines comprising fewer capabilities than the full complexity analytical engine; and

generating the report based at least in part on output from each of the plurality of analytical engines to which the one or more analytical tasks were distributed.

2. A computer program product as in claim 1, wherein the full complexity analytical engine comprises at least one of a multidimensional model and an online analytical processing (OLAP) engine.

3. A computer program product as in claim 1, wherein the determined level of analytical complexity comprises an indication of the analytical capabilities required for handling one or more analysis tasks necessary to generate the report.

4. A computer program product as in claim 1, wherein the generating of the report consumes fewer runtime resources than would be consumer were the report generated using only the full complexity analytical engine.

5. A computer program product as in claim 1, wherein the operations further comprise receiving the query request from a single user interface via which a user selects a desired set of analytical functions from a presented full range of levels of analytical complexity supported by the plurality of analytical reporting engines.

6. A computer program product as in claim 1, wherein the analyzing occurs without initiating the full complexity analytical engine.

7. A system comprising:

at least one programmable processor; and

a machine-readable medium storing instructions that, when executed by the at least one processor, cause the at least one programmable processor to perform operations comprising;

analyzing a received query request at runtime to determine a level of analytical complexity required to generate a report responsive to the query request;

distributing the one or more analysis tasks among a plurality of analytical reporting engines of differing analytical complexity such that a full complexity analytical engine of the plurality of analytical reporting engines is used only for those of the one or more analysis tasks that require capabilities of the full complexity analytical engine;

distributing those of the one or more analysis tasks that do not require capabilities of the full complexity analytical engine to one or more reduced complexity analytical engines of the plurality of analytical reporting engines, the one or more reduced complexity analytical reporting engines comprising fewer capabilities than the full complexity analytical engine; and

generating the report based at least in part on output from each of the plurality of analytical engines to which the one or more analytical tasks were distributed.

8. A system as in claim 7, wherein the full complexity analytical engine comprises at least one of a multidimensional model and an online analytical processing (OLAP) engine.

9. A system as in claim 7, wherein the determined level of analytical complexity comprises an indication of the analytical capabilities required for handling one or more analysis tasks necessary to generate the report.

10. A system as in claim 7, wherein the generating of the report consumes fewer runtime resources than would be consumer were the report generated using only the full complexity analytical engine.

11. A system as in claim 7, wherein the operations further comprise receiving the query request from a single user interface via which a user selects a desired set of analytical functions from a presented full range of levels of analytical complexity supported by the plurality of analytical reporting engines.

12. A system as in claim 7, wherein the analyzing occurs without initiating the full complexity analytical engine.

14. A computer-implemented method as in claim 7, wherein the full complexity analytical engine comprises at least one of a multidimensional model and an online analytical processing (OLAP) engine.

13. A computer-implemented method comprising:

analyzing a received query request at runtime to determine a level of analytical complexity required to generate a report responsive to the query request;

first distributing the one or more analysis tasks among a plurality of analytical reporting engines of differing analytical complexity such that a full complexity analytical engine of the plurality of analytical reporting engines is used only for those of the one or more analysis tasks that require capabilities of the full complexity analytical engine;

further distributing those of the one or more analysis tasks that do not require capabilities of the full complexity analytical engine to one or more reduced complexity analytical engines of the plurality of analytical reporting engines, the one or more reduced complexity analytical reporting engines comprising fewer capabilities than the full complexity analytical engine; and

generating the report based at least in part on output from each of the plurality of analytical engines to which the one or more analytical tasks were distributed.

15. A computer-implemented method as in claim 13, wherein the determined level of analytical complexity comprises an indication of the analytical capabilities required for handling one or more analysis tasks necessary to generate the report.

16. A computer-implemented method as in claim 13, wherein the generating of the report consumes fewer runtime resources than would be consumer were the report generated using only the full complexity analytical engine.

17. A computer-implemented method as in claim 13, wherein the operations further comprise receiving the query request from a single user interface via which a user selects a desired set of analytical functions from a presented full range of levels of analytical complexity supported by the plurality of analytical reporting engines.

18. A computer-implemented method as in claim 13, wherein the analyzing occurs without initiating the full complexity analytical engine.

19. A computer-implemented method as in claim 13, further comprising promoting the generated report.

20. A computer-implemented method as in claim 13, wherein at least one of the analyzing, the first distributing, the further distributing, and the generating are performed by at least one programmable processor.