Patent · US Active

OLAP execution model using relational operations

US8650181B2 · kind B2 · utility

3Cited by

2References

14Claims

0Family size

Assignee

SAP AG · DE

Inventors

Stefan Dipper · Wiesloch, DE
Erich Marschall · Schallstadt, DE
Tobias Mindnich · Walldorf, DE
Daniel Baeumges · Viersen, DE
Christoph Weyerhaeuser · Leimen, DE

Key dates

Filing date	Nov 22, 2010
Grant date	Feb 11, 2014
Priority date	—
Expiry date	Oct 2, 2031

Classification

Technology area (CPC G)Physics
CPC primaryG06F16/283
WIPO fieldComputer technology
WIPO sectorElectrical engineering

Abstract

In one embodiment the present invention includes an OLAP execution model using relational operations. In one embodiment, the present invention includes, a method comprising receiving a first query in an online analytic processor (OLAP) executing on one or more computers, the OLAP generating and comprising a model specifying a graph defining a plurality of nodes and a plurality of tiers, each node corresponding to a different operation on data. A second query is generated by the OLAP. The second query includes a plurality of layered subqueries each corresponding to one of the nodes in the graph for specifying the different operations on data. The second query is received in a relational engine coupled to the datastore. The relational engine executes the second query, and in accordance therewith, retrieves data.

Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.