Hierarchical runtime settings within distributed query execution frameworks

A non-transitory computer program product storing instructions which, when executed by at least one data processor of at least one computing system, result in operations comprising:

• receiving, by a database server from a remote application server, a query associated with a calculation scenario, the calculation scenario defining a data flow model that includes one or more calculation nodes that each define one or more operations to execute by a calculation engine on the database server;
• instantiating, by the database server, a runtime model of the calculation scenario, the instantiating comprising accessing a local settings object stored with the calculation scenario, the local settings object specifying local settings for the calculation scenario;
• executing, by the database server, the operations defined by the calculation nodes of the instantiated calculation scenario to result in a responsive data set;
• and
• providing, by the database server to the application server, the data set.

A method comprising:

• receiving, by a database server from a remote application server, a query associated with a calculation scenario, the calculation scenario defining a data flow model that includes one or more calculation nodes that each define one or more operations to execute by a calculation engine on the database server;
• instantiating, by the database server, a runtime model of the calculation scenario, the instantiating comprising accessing settings, and if necessary, resolving conflicts among the settings for the calculation scenario, wherein the settings comprise global settings, local settings specified by a local settings object stored with the calculation scenario, and query settings specified by 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;
• and
• providing, by the database server to the application server, the data set.