Database calculation engine

摘要

A select query or a data referencing a calculation scenario is received by a database server from a remote application server. The specified calculation scenario is one of a plurality of calculation scenarios and it defines a data flow model that includes one or more calculation nodes. Each calculation node defines one or more operations to execute on the database server. Thereafter, the database server instantiates the specified calculation scenario and executes the operations defined by the calculation nodes of the instantiated calculation scenario to result in a responsive data set. This data set is then provided by the database server to the application server. Related apparatus, systems, techniques and articles are also described.

主权项

1. 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 to respond to the query, at least one calculated node defining a calculated attribute; instantiating, by the database server, the specified calculation scenario, wherein at least a portion of paths and/or attributes defined by the specified calculation scenario are not required to respond to the query, and instantiating the specified calculation scenario includes omitting the paths and attributes defined by the specified 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 data set responsive to the query; and providing, by the database server to the application server, the data set.