METHODS AND APPARATUS OF SHARED EXPRESSION EVALUATION ACROSS RDBMS AND STORAGE LAYER

摘要

Techniques are provided for sharing expression evaluation across a database management system and a storage layer. According to an embodiment, a plurality of target operators are identified that include a common expression. Each respective target operator corresponds to a step that evaluates the common expression during query execution. The plurality of target operators are modified to enable sharing of an evaluation result of the common expression. The query is executed according to the target operators. During query execution, the evaluation result is shared by the target operators. In other embodiments, the evaluation of the common expression is pushed to a storage layer. During query execution, a database management system retrieves the evaluation result of the common expression from the storage layer.

主权项

1. A method for optimizing query execution, the method comprising:
identifying, in an query execution plan, a plurality of target operators that include a common expression; wherein each respective target operator corresponds to a step that evaluates the common expression during query execution to perform a respective operation; modifying the plurality of target operators to enable sharing of an evaluation result of the common expression; executing the query according to the modified target operators; wherein during said executing, the evaluation result is shared by the target operators; wherein the method is performed by one or more computing devices.