{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,11,11]],"date-time":"2026-11-11T00:09:13Z","timestamp":1794355753514,"version":"4.9.0"},"publisher-location":"Berlin, Heidelberg","reference-count":5,"publisher":"Springer Berlin Heidelberg","isbn-type":[{"value":"9783540681229","type":"print"},{"value":"9783540681236","type":"electronic"}],"content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":[],"DOI":"10.1007\/978-3-540-68123-6_38","type":"book-chapter","created":{"date-parts":[[2008,5,9]],"date-time":"2008-05-09T08:11:39Z","timestamp":1210320699000},"page":"351-360","source":"Crossref","is-referenced-by-count":3,"title":["SQL Queries with CASE Expressions"],"prefix":"10.1007","author":[{"given":"Jarek","family":"Gryz","sequence":"first","affiliation":[],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Qiong","family":"Wang","sequence":"additional","affiliation":[],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Xiaoyan","family":"Qian","sequence":"additional","affiliation":[],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Calisto","family":"Zuzarte","sequence":"additional","affiliation":[],"role":[{"vocabulary":"crossref","role":"author"}]}],"member":"297","reference":[{"key":"38_CR1","unstructured":"Burns, D.: Improving sql efficiency using case, \n                    \n                      http:\/\/oracledoug.com\/case.html"},{"key":"38_CR2","doi-asserted-by":"crossref","unstructured":"Dalvi, N.N., Sanghai, S.K., Roy, P., Sudarshan, S.: Pipelining in multi-query optimization. In: Proceedings of PODS, pp. 59\u201370 (2001)","DOI":"10.1145\/375551.375561"},{"key":"38_CR3","first-page":"377","volume-title":"SIGMOD Proceedings","author":"L. Haas","year":"1989","unstructured":"Haas, L., Freytag, J., Lohman, G., Pirahesh, H.: Extensible query processing in starburst. In: SIGMOD Proceedings, pp. 377\u2013388. ACM, New York (1989)"},{"issue":"3","key":"38_CR4","first-page":"38","volume":"5","author":"J. Henderyckx","year":"1998","unstructured":"Henderyckx, J.: Version 5 case expressions: beyond sql reference. The IDUG Solutions Journal\u00a05(3), 38\u201345 (1998)","journal-title":"The IDUG Solutions Journal"},{"key":"38_CR5","doi-asserted-by":"crossref","unstructured":"Lehner, W., Cochrane, B., Pirahesh, H., Zaharioudakis, M.: fAST refresh using mass query optimization. In: Proceedings of ICDE, pp. 391\u2013400 (2001)","DOI":"10.1109\/ICDE.2001.914852"}],"container-title":["Lecture Notes in Computer Science","Foundations of Intelligent Systems"],"original-title":[],"language":"en","link":[{"URL":"http:\/\/link.springer.com\/content\/pdf\/10.1007\/978-3-540-68123-6_38.pdf","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2021,5,3]],"date-time":"2021-05-03T00:35:53Z","timestamp":1620002153000},"score":1,"resource":{"primary":{"URL":"http:\/\/link.springer.com\/10.1007\/978-3-540-68123-6_38"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[null]]},"ISBN":["9783540681229","9783540681236"],"references-count":5,"URL":"https:\/\/doi.org\/10.1007\/978-3-540-68123-6_38","relation":{"is-part-of":[{"id-type":"doi","id":"https:\/\/doi.org\/10.1007\/978-3-540-68123-6","asserted-by":"object"}]},"subject":[]}}