SAP SE
HYBRID COMPILATION FRAMEWORK FOR ARBITRARY AD-HOC IMPERATIVE FUNCTIONS IN DATABASE QUERIES

Abstract:

Implementations of the present disclosure include providing a parse tree including a declarative portion and an imperative portion, dividing the parse tree to provide a first parse sub-tree and a second parse sub-tree, compiling the first parse sub-tree using a declarative compiler to provide a query execution plan (QEP) including an imperative script operator to prompt execution of the imperative portion, compiling the second parse sub-tree using an imperative compiler to provide one or more script execution plans, executing, by an execution engine, the QEP until encountering an imperative script operator, and, in response to encountering the imperative script operator, initiating execution of the one or more script execution plans to provide an imperative result, and providing a query result at least partially including the imperative result.