Part of the book series:Lecture Notes in Computer Science ((LNAI,volume 4994))
Included in the following conference series:
1066Accesses
Abstract
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 from queries written by humans. In particular, they contain non-declarative features, most notorious of which is theCASE 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 ofCASE expressions and present several new optimization techniques to address them. We also describe experimental evaluation of the prototype implemented in DB2 UDB V8.2.
This is a preview of subscription content,log in via an institution to check access.
Preview
Unable to display preview. Download preview PDF.
Similar content being viewed by others
References
Burns, D.: Improving sql efficiency using case,http://oracledoug.com/case.html
Dalvi, N.N., Sanghai, S.K., Roy, P., Sudarshan, S.: Pipelining in multi-query optimization. In: Proceedings of PODS, pp. 59–70 (2001)
Haas, L., Freytag, J., Lohman, G., Pirahesh, H.: Extensible query processing in starburst. In: SIGMOD Proceedings, pp. 377–388. ACM, New York (1989)
Henderyckx, J.: Version 5 case expressions: beyond sql reference. The IDUG Solutions Journal 5(3), 38–45 (1998)
Lehner, W., Cochrane, B., Pirahesh, H., Zaharioudakis, M.: fAST refresh using mass query optimization. In: Proceedings of ICDE, pp. 391–400 (2001)
Author information
Authors and Affiliations
Department of Computer Science and Engineering, York University, Toronto, Canada
Jarek Gryz
IBM Laboratory, , Toronto, Canada
Qiong Wang, Xiaoyan Qian & Calisto Zuzarte
- Jarek Gryz
You can also search for this author inPubMed Google Scholar
- Qiong Wang
You can also search for this author inPubMed Google Scholar
- Xiaoyan Qian
You can also search for this author inPubMed Google Scholar
- Calisto Zuzarte
You can also search for this author inPubMed Google Scholar
Editor information
Rights and permissions
Copyright information
© 2008 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Gryz, J., Wang, Q., Qian, X., Zuzarte, C. (2008). SQL Queries with CASE Expressions. In: An, A., Matwin, S., Raś, Z.W., Ślęzak, D. (eds) Foundations of Intelligent Systems. ISMIS 2008. Lecture Notes in Computer Science(), vol 4994. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-540-68123-6_38
Download citation
Publisher Name:Springer, Berlin, Heidelberg
Print ISBN:978-3-540-68122-9
Online ISBN:978-3-540-68123-6
eBook Packages:Computer ScienceComputer Science (R0)
Share this paper
Anyone you share the following link with will be able to read this content:
Sorry, a shareable link is not currently available for this article.
Provided by the Springer Nature SharedIt content-sharing initiative