Efficient assignment of query requests between analytical engines of differing complexity

• US 9,177,036 B2
• Filed: 12/20/2012
• Issued: 11/03/2015
• 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
• Primary Examiner(s): NGUYEN, KIM T
• Application Number:
  US13/722,982
• Publication Number:
  US 20140181005A1
• Time in Patent Office: 1,048 Days
• Field of Search: 707/602, 707/708
• US Class Current: 1/1
• 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 non-transitory 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:

receiving a 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;

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

distributing, based on the determined level of analytical complexity, 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, based on the determined level of analytical complexity, 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 non-transitory 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 non-transitory 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 non-transitory computer program product as in claim 1, wherein the generating of the report consumes fewer runtime resources than would be consumed were the report generated using only the full complexity analytical engine.

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

6. 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;

receiving a 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;

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

distributing, based on the determined level of analytical complexity, 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, based on the determined level of analytical complexity, 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.

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

8. A system as in claim 6, 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.

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

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

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

12. A computer-implemented method comprising:

receiving, by at least one processor, a 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;

analyzing, by the least one processor, the received query request at runtime to determine a level of analytical complexity required to generate a report responsive to the query request;

distributing, by the least one processor and based on the determined level of analytical complexity, 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, by the least one processor and based on the determined level of analytical complexity, 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, by the at least one processor, 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.

13. A computer-implemented method as in claim 12, 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.

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

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

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

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