{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2022,4,5]],"date-time":"2022-04-05T21:10:04Z","timestamp":1649193004052},"reference-count":6,"publisher":"Springer Science and Business Media LLC","issue":"3","license":[{"start":{"date-parts":[[2009,5,13]],"date-time":"2009-05-13T00:00:00Z","timestamp":1242172800000},"content-version":"tdm","delay-in-days":0,"URL":"http:\/\/www.springer.com\/tdm"}],"content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":["J Intell Inf Syst"],"published-print":{"date-parts":[[2010,6]]},"DOI":"10.1007\/s10844-009-0091-x","type":"journal-article","created":{"date-parts":[[2009,5,12]],"date-time":"2009-05-12T05:08:24Z","timestamp":1242104904000},"page":"345-366","source":"Crossref","is-referenced-by-count":0,"title":["Queries with CASE expressions"],"prefix":"10.1007","volume":"34","author":[{"given":"Jarek","family":"Gryz","sequence":"first","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Qiong","family":"Wang","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Xiaoyan","family":"Qian","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Calisto","family":"Zuzarte","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]}],"member":"297","published-online":{"date-parts":[[2009,5,13]]},"reference":[{"key":"91_CR1","unstructured":"Burns, D. (2006). Improving sql efficiency using case. http:\/\/oracledoug.com\/case.html ."},{"key":"91_CR2","doi-asserted-by":"crossref","unstructured":"Dalvi, N. N., Sanghai, S. K., Roy, P., & Sudarshan, S. (2001). Pipelining in multi-query optimization. In Proceedings of PODS (pp. 59\u201370).","DOI":"10.1145\/375551.375561"},{"key":"91_CR3","first-page":"377","volume-title":"SIGMOD proceedings","author":"LM Haas","year":"1989","unstructured":"Haas, L. M., Freytag, J. C., Lohman, G. M., & Pirahesh, H. (1989). Extensible query processing in starburst. In SIGMOD proceedings (pp. 377\u2013388). New York: ACM."},{"key":"91_CR4","unstructured":"Henderyckx, J. (1998). Version 5 case expressions: Beyond sql reference. The IDUG Solutions Journal, 5(3), 38\u201345."},{"key":"91_CR5","doi-asserted-by":"crossref","unstructured":"Lehner, W., Cochrane, B., Pirahesh, H., & Zaharioudakis, M. (2001). Fast refresh using mass query optimization. In Proceedings of ICDE (pP. 391\u2013400).","DOI":"10.1109\/ICDE.2001.914852"},{"key":"91_CR6","doi-asserted-by":"crossref","unstructured":"Pirahesh, H., Leung, T. Y. C., & Hasan, W. (1997). A rule engine for query transformation in Starburst and IBM DB2 C\/S DBMS. In Proc. ICDE (pp. 391\u2013400).","DOI":"10.1109\/ICDE.1997.581945"}],"container-title":["Journal of Intelligent Information Systems"],"original-title":[],"language":"en","link":[{"URL":"http:\/\/link.springer.com\/content\/pdf\/10.1007\/s10844-009-0091-x.pdf","content-type":"application\/pdf","content-version":"vor","intended-application":"text-mining"},{"URL":"http:\/\/link.springer.com\/article\/10.1007\/s10844-009-0091-x\/fulltext.html","content-type":"text\/html","content-version":"vor","intended-application":"text-mining"},{"URL":"http:\/\/link.springer.com\/content\/pdf\/10.1007\/s10844-009-0091-x","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2019,5,31]],"date-time":"2019-05-31T02:10:48Z","timestamp":1559268648000},"score":1,"resource":{"primary":{"URL":"http:\/\/link.springer.com\/10.1007\/s10844-009-0091-x"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2009,5,13]]},"references-count":6,"journal-issue":{"issue":"3","published-print":{"date-parts":[[2010,6]]}},"alternative-id":["91"],"URL":"https:\/\/doi.org\/10.1007\/s10844-009-0091-x","relation":{},"ISSN":["0925-9902","1573-7675"],"issn-type":[{"value":"0925-9902","type":"print"},{"value":"1573-7675","type":"electronic"}],"subject":[],"published":{"date-parts":[[2009,5,13]]}}}