{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,5,17]],"date-time":"2026-05-17T23:06:56Z","timestamp":1779059216373,"version":"3.51.4"},"publisher-location":"Cham","reference-count":15,"publisher":"Springer Nature Switzerland","isbn-type":[{"value":"9783032198648","type":"print"},{"value":"9783032198655","type":"electronic"}],"license":[{"start":{"date-parts":[[2026,1,1]],"date-time":"2026-01-01T00:00:00Z","timestamp":1767225600000},"content-version":"tdm","delay-in-days":0,"URL":"https:\/\/www.springernature.com\/gp\/researchers\/text-and-data-mining"},{"start":{"date-parts":[[2026,1,1]],"date-time":"2026-01-01T00:00:00Z","timestamp":1767225600000},"content-version":"vor","delay-in-days":0,"URL":"https:\/\/www.springernature.com\/gp\/researchers\/text-and-data-mining"}],"content-domain":{"domain":["link.springer.com"],"crossmark-restriction":false},"short-container-title":[],"published-print":{"date-parts":[[2026]]},"DOI":"10.1007\/978-3-032-19865-5_13","type":"book-chapter","created":{"date-parts":[[2026,5,17]],"date-time":"2026-05-17T22:35:01Z","timestamp":1779057301000},"page":"160-167","update-policy":"https:\/\/doi.org\/10.1007\/springer_crossmark_policy","source":"Crossref","is-referenced-by-count":0,"title":["Speeding up\u00a0SQL Subqueries via\u00a0Decoupling of\u00a0Non-correlated Predicate"],"prefix":"10.1007","author":[{"ORCID":"https:\/\/orcid.org\/0009-0005-9885-6257","authenticated-orcid":false,"given":"Dmitrii","family":"Radivonchik","sequence":"first","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"ORCID":"https:\/\/orcid.org\/0009-0009-2961-6021","authenticated-orcid":false,"given":"Yakov","family":"Kuzin","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"ORCID":"https:\/\/orcid.org\/0009-0007-3042-345X","authenticated-orcid":false,"given":"Anton","family":"Chizhov","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"ORCID":"https:\/\/orcid.org\/0009-0000-1519-8740","authenticated-orcid":false,"given":"Dmitriy","family":"Shcheka","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"ORCID":"https:\/\/orcid.org\/0000-0001-6739-7303","authenticated-orcid":false,"given":"Mikhail","family":"Firsov","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"ORCID":"https:\/\/orcid.org\/0000-0003-4727-3455","authenticated-orcid":false,"given":"Kirill","family":"Smirnov","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"ORCID":"https:\/\/orcid.org\/0000-0002-4265-9642","authenticated-orcid":false,"given":"George","family":"Chernishev","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]}],"member":"297","published-online":{"date-parts":[[2026,5,1]]},"reference":[{"key":"13_CR1","unstructured":"TPC BENCHMARK(TM) H (Decision Support) Standard Specification Revision 3.0.1. https:\/\/www.tpc.org\/TPC_Documents_Current_Versions\/pdf\/TPC-H_v3.0.1.pdf"},{"key":"13_CR2","doi-asserted-by":"crossref","unstructured":"Abadi, D., Boncz, P., Harizopoulos, S.: The Design and Implementation of Modern Column-Oriented Database Systems. Now Publishers Inc. (2013)","DOI":"10.1561\/9781601987556"},{"key":"13_CR3","doi-asserted-by":"crossref","unstructured":"Bellamkonda, S., Ahmed, R., Witkowski, A., et al.: Enhanced subquery optimizations in Oracle. Proc. VLDB Endow. 2(2), 1366\u20131377 (2009)","DOI":"10.14778\/1687553.1687563"},{"key":"13_CR4","doi-asserted-by":"crossref","unstructured":"Bruno, N., Galindo-Legaria, C., Joshi, M.: Query decorrelation in the fabric data warehouse. In: SIGMOD\u201925, pp. 297\u2013309 (2025)","DOI":"10.1145\/3722212.3724448"},{"key":"13_CR5","unstructured":"Chernishev, G.A., Galaktionov, V., Grigorev, V.V., et\u00a0al.: A comprehensive study of late materialization strategies for a disk-based column-store. In: DOLAP@EDBT\/ICDT\u201922, CEUR, vol.\u00a03130, pp. 21\u201330. CEUR-WS.org (2022)"},{"key":"13_CR6","doi-asserted-by":"crossref","unstructured":"Elhemali, M., Galindo-Legaria, C.A., Grabs, T., Joshi, M.M.: Execution strategies for SQL subqueries. In: SIGMOD\u201907, pp. 993\u20131004 (2007)","DOI":"10.1145\/1247480.1247598"},{"key":"13_CR7","doi-asserted-by":"crossref","unstructured":"Firsov, M., Polyntsov, M., Smirnov, K., Chernishev, G.: Finding a second wind: speeding up graph traversal queries in RDBMSs using column-oriented processing. In: MEDI\u201923, pp. 186\u2013199. Springer Nature Switzerland, Cham (2024)","DOI":"10.1007\/978-3-031-49333-1_14"},{"issue":"2","key":"13_CR8","doi-asserted-by":"publisher","first-page":"73","DOI":"10.1145\/152610.152611","volume":"25","author":"G Graefe","year":"1993","unstructured":"Graefe, G.: Query evaluation techniques for large databases. ACM Comput. Surv. 25(2), 73\u2013169 (1993)","journal-title":"ACM Comput. Surv."},{"key":"13_CR9","unstructured":"Harizopoulos, S., Abadi, D., Boncz, P.: Column-Oriented Database Systems, VLDB 2009 Tutorial (2009)"},{"key":"13_CR10","doi-asserted-by":"crossref","unstructured":"Kim, A., Madden, S.: Optimizing disjunctive queries with tagged execution. In: Proc. ACM Manage. Data 2(3) (2024)","DOI":"10.1145\/3654961"},{"key":"13_CR11","doi-asserted-by":"crossref","unstructured":"Klyuchikov, E., Polyntsov, M., Chizhov, A., et\u00a0al.: Hybrid materialization in a disk-based column-store. In: CODS-COMAD\u201924, pp. 164\u2013172 (2024)","DOI":"10.1145\/3632410.3632422"},{"key":"13_CR12","unstructured":"Radivonchik, D., et al.: Speeding up sql subqueries via decoupling of non-correlated predicate (extended version) (2025), https:\/\/arxiv.org\/abs\/2510.05907"},{"key":"13_CR13","unstructured":"Silberschatz, A., Korth, H.F., Sudarshan, S.: Database System Concepts, Seventh Edition. McGraw-Hill Book Company (2020), https:\/\/www.db-book.com\/"},{"issue":"2","key":"13_CR14","doi-asserted-by":"publisher","first-page":"218","DOI":"10.1145\/22952.22955","volume":"12","author":"P Valduriez","year":"1987","unstructured":"Valduriez, P.: Join Indices. ACM Trans. Database Syst. 12(2), 218\u2013246 (1987)","journal-title":"ACM Trans. Database Syst."},{"key":"13_CR15","doi-asserted-by":"crossref","unstructured":"Zhao, J., Zhang, H., Gao, Y.: Efficient query re-optimization with judicious subquery selections. Proc. ACM Manag. Data 1(2) (2023)","DOI":"10.1145\/3589330"}],"container-title":["Lecture Notes in Computer Science","Model and Data Engineering"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/link.springer.com\/content\/pdf\/10.1007\/978-3-032-19865-5_13","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2026,5,17]],"date-time":"2026-05-17T22:35:07Z","timestamp":1779057307000},"score":1,"resource":{"primary":{"URL":"https:\/\/link.springer.com\/10.1007\/978-3-032-19865-5_13"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2026]]},"ISBN":["9783032198648","9783032198655"],"references-count":15,"URL":"https:\/\/doi.org\/10.1007\/978-3-032-19865-5_13","relation":{},"ISSN":["0302-9743","1611-3349"],"issn-type":[{"value":"0302-9743","type":"print"},{"value":"1611-3349","type":"electronic"}],"subject":[],"published":{"date-parts":[[2026]]},"assertion":[{"value":"1 May 2026","order":1,"name":"first_online","label":"First Online","group":{"name":"ChapterHistory","label":"Chapter History"}},{"value":"MEDI","order":1,"name":"conference_acronym","label":"Conference Acronym","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"International Conference on Model and Data Engineering","order":2,"name":"conference_name","label":"Conference Name","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"Cairo","order":3,"name":"conference_city","label":"Conference City","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"Egypt","order":4,"name":"conference_country","label":"Conference Country","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"2025","order":5,"name":"conference_year","label":"Conference Year","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"2 November 2025","order":7,"name":"conference_start_date","label":"Conference Start Date","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"4 November 2025","order":8,"name":"conference_end_date","label":"Conference End Date","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"14","order":9,"name":"conference_number","label":"Conference Number","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"medi2025","order":10,"name":"conference_id","label":"Conference ID","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"https:\/\/sites.google.com\/view\/medi2025-sut\/home","order":11,"name":"conference_url","label":"Conference URL","group":{"name":"ConferenceInfo","label":"Conference Information"}}]}}