A method, a system, and a computer program product for executing a query. A query associated with a calculation scenario defining a data flow model that includes one or more calculation nodes is received. Each calculation node corresponds to an operation being performed on one or more database tables stored at a database. The calculation nodes include a first calculation node corresponding to a ranking filter operation. A calculation engine executes the calculation scenario and performs the ranking filter operation to generate a data structure storing a plurality of rows of the database tables. Based on the executing of the calculation scenario, a result data set including at least one row from the plurality of rows is generated and provided by a database server to an application server.
展开▼