Database queries using dynamically calculated dimensions
AssigneeSap SE
InventorsJustin Wong, Clarence Chuahuico
Life of this patent
Estimating the term…
Abstract
Some embodiments provide a non-transitory machine-readable medium that stores a program. The program receives from a client device a request for data stored in a database categorized based on a calculated dimension. The program further generates the calculated dimension based on a subset of the data stored in the database. The program also generates an intermediary data structure by combining the calculated dimension with the data stored in the database. The program further generates results for the request by aggregating the data in the intermediary data structure based on the calculated dimension. The program also provides the results for the request to the client device.
Claims20
A non-transitory machine-readable medium storing a program executable by at least one processing unit of a device, the program comprising sets of instructions for:
- receiving from a client device a request for data stored in a database categorized based on a calculated dimension;
- generating the calculated dimension based on a subset of the data stored in the database;
- generating an intermediary data structure by combining the calculated dimension with the data stored in the database;
- generating results for the request by aggregating the data in the intermediary data structure based on the calculated dimension;
- and
- providing the results for the request to the client device.
A method, performed by a device, comprising:
- receiving from a client device a request for data stored in a database categorized based on a calculated dimension;
- generating the calculated dimension based on a subset of the data stored in the database;
- generating an intermediary data structure by combining the calculated dimension with the data stored in the database;
- generating results for the request by aggregating the data in the intermediary data structure based on the calculated dimension;
- and
- providing the results for the request to the client device.
A system comprising:
- a set of processing units;
- and
- a non-transitory machine-readable medium storing instructions that when executed by at least one processing unit in the set of processing units cause the at least one processing unit to:
- receive from a client device a request for data stored in a database categorized based on a calculated dimension;
- generate the calculated dimension based on a subset of the data stored in the database;
- generate an intermediary data structure by combining the calculated dimension with the data stored in the database;
- generate results for the request by aggregating the data in the intermediary data structure based on the calculated dimension;
- and
- provide the results for the request to the client device.
Dependencies are inferred from the claim text.