Patent ID: 8195643

Claim:
A method comprising: receiving, by a database server from a remote application server, a select query specifying a calculation scenario, the specified calculation scenario being one of a plurality of calculation scenarios and defining a data flow model that includes one or more calculation nodes, each calculation node defining one or more operations to execute on the database server, the specified calculation scenario defining paths and/or attributes, wherein inputs for the calculation nodes comprise one or more of: a physical index, a join index, an OLAP index, and another calculation node; instantiating, by the database server, the specified calculation scenario, the instantiated calculation scenario omitting paths and attributes defined by the calculation scenario that are not required to respond to the query; executing, by the database server, the operations defined by the calculation nodes of the instantiated calculation scenario to result in a responsive data set, the executing comprising forwarding the query to a calculation node in the calculation scenario that is identified as a default node if the query does not specify a calculation node at which the query should be executed; and providing, by the database server to the application server, the data set.