Consistent aggregation in a database

摘要

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 and that includes a pre-defined aggregation property. Each calculation node defines one or more operations to execute on the database server. The database server can include a column-oriented database. Thereafter, the database server instantiates the calculation scenario such that, based on the aggregation property, at least one non-aggregating operation specified by a calculation node is transformed into a aggregating operation based on a root node aggregation of the calculation scenario. Subsequently, the database server executes the operations defined by the calculation nodes of the optimized calculation scenario to result in a responsive data set. The database server then provides the data set to the application server.

主权项

1. A method comprising:
receiving, by a database server from a remote application server, a query associated with a calculation scenario that defines a data flow model that includes one or more calculation nodes and that includes a pre-defined aggregation property, each calculation node defining one or more operations to execute on the database server, the database server comprising a column-oriented database; instantiating, by the database server, the calculation scenario, the instantiating, based on the aggregation property, transforming at least one non-aggregating operation specified by a calculation node into a aggregating operation based on a root node aggregation of the calculation scenario; executing, by the database server, the operations defined by the calculation nodes of the optimized calculation scenario to result in a responsive data set; and providing, by the database server to the application server, the data set.