Skip to main content

SQL Queries with CASE Expressions

  • Conference paper
Foundations of Intelligent Systems (ISMIS 2008)

Part of the book series: Lecture Notes in Computer Science ((LNAI,volume 4994))

Included in the following conference series:

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 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.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Similar content being viewed by others

References

  1. Burns, D.: Improving sql efficiency using case, http://oracledoug.com/case.html

  2. Dalvi, N.N., Sanghai, S.K., Roy, P., Sudarshan, S.: Pipelining in multi-query optimization. In: Proceedings of PODS, pp. 59–70 (2001)

    Google Scholar 

  3. Haas, L., Freytag, J., Lohman, G., Pirahesh, H.: Extensible query processing in starburst. In: SIGMOD Proceedings, pp. 377–388. ACM, New York (1989)

    Google Scholar 

  4. Henderyckx, J.: Version 5 case expressions: beyond sql reference. The IDUG Solutions Journal 5(3), 38–45 (1998)

    Google Scholar 

  5. Lehner, W., Cochrane, B., Pirahesh, H., Zaharioudakis, M.: fAST refresh using mass query optimization. In: Proceedings of ICDE, pp. 391–400 (2001)

    Google Scholar 

Download references

Author information

Authors and Affiliations

Authors

Editor information

Aijun An Stan Matwin Zbigniew W. Raś Dominik Ślęzak

Rights and permissions

Reprints 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

  • DOI: https://doi.org/10.1007/978-3-540-68123-6_38

  • 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)

Publish with us

Policies and ethics