发明申请
US20060224561A1 Method and apparatus for associating logical conditions with the re-use of a database query execution strategy 有权
将逻辑条件与数据库查询执行策略的重用相关联的方法和装置

Method and apparatus for associating logical conditions with the re-use of a database query execution strategy
摘要:
A query facility for database queries saves and re-uses query execution strategies, and automatically determines whether a strategy can be re-used when an imported variable changes. The query facility automatically saves one or more logical conditions associated with the one or more imported variables in the query. When the query is reused, the logical conditions are evaluated using the imported variable values, and the previously saved execution strategy is used only if the condition or conditions are met. Preferably, the logical conditions express a range of imported variable values which are included in a database subset data structure used by the saved query execution strategy, such as a materialized query table or partitioned table. Logical conditions are preferably generated by negating the predicates from a logical expression defining the applicability of the execution strategy, inserting the negated predicates into the query, and performing a transitive closure.
信息查询
0/0