Extensible query processing in starburst
SIGMOD '89 Proceedings of the 1989 ACM SIGMOD international conference on Management of data
Pipelining in multi-query optimization
PODS '01 Proceedings of the twentieth ACM SIGMOD-SIGACT-SIGART symposium on Principles of database systems
fAST Refresh using Mass Query Optimization
Proceedings of the 17th International Conference on Data Engineering
Hi-index | 0.00 |
In recent years more and more queries are generated automatically by query managers/builders with end-users providing only specific parameters through GUIs.Queries generated automatically can be quite different fromqueries written by humans. In particular, they contain non-declarative features, most notorious of which is the CASE expression. Current query optimizers are often ill-prepared for the new types of queries as they do not deal well with procedural 'insertions'. In this paper, we discuss the inefficiencies of CASE expressions and present several new optimization techniques to address them. We also describe experimental evaluation of the prototype implemented in DB2 UDB V8.2.