Patent · US Active

Database query calculation using an operator that explicitly removes group-by characteristics

US10489394B2 · kind B2 · utility

0Cited by

12References

20Claims

0Family size

Assignee

SAP SE · DE

Inventors

Sebastian Schroetel · Walldorf, DE
Stefan Dipper · Wiesloch, DE
Michael Wilking · Walldorf, DE
Christof Mueller · Walldorf, DE

Key dates

Filing date	May 25, 2016
Grant date	Nov 26, 2019
Priority date	—
Expiry date	Aug 3, 2036

Classification

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

Abstract

In one embodiment, a method receives a query for analyzing data in a database. The query includes a first level calculation that is performed before a second level calculation. When an operator associated with the first level calculation is present in the query, the method performs: calculating the first level calculation by removing group by information for a reference characteristic for the first level calculation to determine a first level calculation result and calculating the second level calculation using the first level calculation result using the group by information for the reference characteristic to determine a second level calculation result, wherein the group by in the second level calculation combines groups of rows in a database table of the database that have the same content in their specified columns.

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