Patent · US Active

Optimization of business warehouse queries by calculation engines

US9146979B2 · kind B2 · utility

2Cited by

7References

31Claims

0Family size

Assignee

SAP SE · DE

Inventors

Christoph Weyerhaeuser · Leimen, DE
Tobias Mindnich · Walldorf, DE
Daniel Baeumges · Viersen, DE
Johannes Merx · Heidelberg, DE

Key dates

Filing date	Jun 13, 2013
Grant date	Sep 29, 2015
Priority date	—
Expiry date	Jan 31, 2034

Classification

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

Abstract

A query is received by a database server from a remote application server. The query is associated with a calculation scenario that defines a data flow model that includes one or more calculation nodes with each calculation node defining one or more operations to execute on the database server. Thereafter, at least one of the calculation nodes is transformed into a star schema. Next, the database server instantiates the calculation scenario with the transformed at least one calculation node. Subsequently, a calculation engine of the database server executes the operations defined by the calculation nodes of the instantiated calculation scenario other than the transformed at least one calculation node and, additionally, an OLAP engine executes the transformed at least one calculation node to collectively result in a responsive data set.

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