Integrated Execution of Relational And Non-Relational Calculation Models by a Database System

摘要

A query that requests a filter attribute is received by a database server from a remote application server that is associated with at least one calculation scenario that includes calculation nodes having relational operators and calculation nodes having non-relational operators. The calculation nodes having relational or non-relational operators are optimized by a calculation engine model optimizer and the calculation nodes having relational operators are further optimized by a relational database optimizer. Thereafter, the operations defined by the optimized calculation nodes can be executed to result in a responsive data set. Next, the data set is provided to the application server by the database server.

主权项

1. A method comprising:
receiving, by a database server from a remote application server, a query that is associated with a first calculation scenario and a second calculation scenario that each define a data flow model that includes one or more calculation nodes arranged in a hierarchy, the first calculation scenario comprising calculation nodes performing operations on non-relational data and the second calculation scenario comprising calculation nodes performing operations on relational data; instantiating and optimizing, by the database server, the first and the second calculation scenario, the optimizing of the first and the second calculation scenario using a calculation engine model optimizer; optimizing, subsequent to the instantiating, the second calculation scenario using a relational database optimizer; executing, by the database server, the operations defined by the calculation nodes of both of the optimized first calculation scenario and the optimized second calculation scenario to result in a responsive data set; and providing, by the database server to the application server, the data set.