Patent ID: 9378264
Filing Date: 2016-06-28
CPC Classification: G06F

Claim Text:
1. A method comprising: receiving, by a computing device, a query for analyzing data in a database, wherein the query includes a first level calculation for a reference characteristic that is performed before a second level calculation for the reference characteristic, and wherein the first level calculation includes a constant selection operator of the reference characteristic that is configured to remove a group by of the reference characteristic at the first level calculation; determining, by the computing device, when a FIX operator is present in the query, the FIX operator configured to explicitly remove group by information for the reference characteristic in the first level calculation; performing, by the computing device, the first level calculation using the constant selection operator by removing the group by information for the reference characteristic for the first level calculation to determine a first level calculation result, wherein without the use of the FIX operator, the constant selection operator of the reference characteristic would not be used due to a rule specifying the group by information of the reference characteristic should not be removed by the first level calculation when the reference characteristic is present in the first level calculation and the second level calculation; and performing, by the computing device, 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 second level calculation comprises an exception aggregation that uses the first level calculation result in performing the second level calculation, and wherein the exception aggregation performs the second level calculation by aggregating by the reference characteristic to determine the second level calculation result.