{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2025,3,26]],"date-time":"2025-03-26T05:42:05Z","timestamp":1742967725138,"version":"3.40.3"},"publisher-location":"Cham","reference-count":30,"publisher":"Springer International Publishing","isbn-type":[{"type":"print","value":"9783030964979"},{"type":"electronic","value":"9783030964986"}],"license":[{"start":{"date-parts":[[2022,1,1]],"date-time":"2022-01-01T00:00:00Z","timestamp":1640995200000},"content-version":"tdm","delay-in-days":0,"URL":"https:\/\/www.springer.com\/tdm"},{"start":{"date-parts":[[2022,1,1]],"date-time":"2022-01-01T00:00:00Z","timestamp":1640995200000},"content-version":"vor","delay-in-days":0,"URL":"https:\/\/www.springer.com\/tdm"}],"content-domain":{"domain":["link.springer.com"],"crossmark-restriction":false},"short-container-title":[],"published-print":{"date-parts":[[2022]]},"DOI":"10.1007\/978-3-030-96498-6_19","type":"book-chapter","created":{"date-parts":[[2022,3,9]],"date-time":"2022-03-09T11:03:04Z","timestamp":1646823784000},"page":"327-339","update-policy":"https:\/\/doi.org\/10.1007\/springer_crossmark_policy","source":"Crossref","is-referenced-by-count":0,"title":["Scaling SQL to the Supercomputer for Interactive Analysis of Simulation Data"],"prefix":"10.1007","author":[{"given":"Jens","family":"Glaser","sequence":"first","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Felipe","family":"Arambur\u00fa","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"William","family":"Malpica","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Benjam\u00edn","family":"Hern\u00e1ndez","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Matthew","family":"Baker","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Rodrigo","family":"Arambur\u00fa","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]}],"member":"297","published-online":{"date-parts":[[2022,3,10]]},"reference":[{"key":"19_CR1","unstructured":"dask-sql. https:\/\/github.com\/dask-contrib\/dask-sql (2021). Accessed 5 Nov 2021"},{"key":"19_CR2","doi-asserted-by":"publisher","unstructured":"Bakkum, P., Skadron, K.: Accelerating SQL database operations on a GPU with CUDA. In: Proceedings of the 3rd Workshop on General-Purpose Computation on Graphics Processing Units, GPGPU-3, pp. 94\u2013103. Association for Computing Machinery, New York, NY, USA (2010). https:\/\/doi.org\/10.1145\/1735688.1735706","DOI":"10.1145\/1735688.1735706"},{"key":"19_CR3","unstructured":"BlazingSQL: high performance SQL engine on RAPIDS AI. https:\/\/blazingsql.com\/ (2021). Accessed 08 Oct 2021"},{"issue":"12","key":"19_CR4","doi-asserted-by":"publisher","first-page":"1398","DOI":"10.14778\/2536274.2536325","volume":"6","author":"S Bre\u00df","year":"2013","unstructured":"Bre\u00df, S., Saake, G.: Why it is time for a HyPE: a hybrid query processing engine for efficient GPU coprocessing in DBMS. Proc. VLDB Endow. 6(12), 1398\u20131403 (2013). https:\/\/doi.org\/10.14778\/2536274.2536325","journal-title":"Proc. VLDB Endow."},{"key":"19_CR5","doi-asserted-by":"crossref","unstructured":"Bre, S., Beier, F., Rauhe, H., Sattler, K.U., Schallehn, E., Saake, G.: Efficient co-processor utilization in database query processing. Inf. Syst. 38(8), 1084\u20131096 (2013). https:\/\/www.sciencedirect.com\/science\/article\/pii\/S0306437913000732","DOI":"10.1016\/j.is.2013.05.004"},{"key":"19_CR6","doi-asserted-by":"crossref","unstructured":"Chapman, B., et al.: Introducing OpenSHMEM: SHMEM for the PGAS community. In: Proceedings of the Fourth Conference on Partitioned Global Address Space Programming Model, pp. 1\u20133 (2010)","DOI":"10.1145\/2020373.2020375"},{"key":"19_CR7","unstructured":"Chrysogelos, P., Sioulas, P., Ailamaki, A.: Hardware-conscious query processing in GPU-accelerated analytical engines. In: Proceedings of the 9th Biennial Conference on Innovative Data Systems Research. No. CONF (2019)"},{"issue":"1","key":"19_CR8","doi-asserted-by":"publisher","first-page":"107","DOI":"10.1145\/1327452.1327492","volume":"51","author":"J Dean","year":"2008","unstructured":"Dean, J., Ghemawat, S.: MapReduce: simplified data processing on large clusters. Commun. ACM 51(1), 107\u2013113 (2008)","journal-title":"Commun. ACM"},{"key":"19_CR9","doi-asserted-by":"publisher","unstructured":"DeWitt, D., Gray, J.: Parallel database systems: the future of high performance database systems. Commun. ACM 35(6), 85\u201398 (1992). https:\/\/doi.org\/10.1145\/129888.129894","DOI":"10.1145\/129888.129894"},{"key":"19_CR10","doi-asserted-by":"publisher","unstructured":"Fang, R., et al.: GPUQP: query co-processing using graphics processors. In: Proceedings of the 2007 ACM SIGMOD International Conference on Management of Data. SIGMOD 2007, pp. 1061\u20131063. Association for Computing Machinery, New York, NY, USA (2007). https:\/\/doi.org\/10.1145\/1247480.1247606","DOI":"10.1145\/1247480.1247606"},{"key":"19_CR11","doi-asserted-by":"publisher","unstructured":"Fang, W., He, B., Luo, Q.: Database compression on graphics processors. Proc. VLDB Endow. 3(1\u20132), 670\u2013680 (2010). https:\/\/doi.org\/10.14778\/1920841.1920927","DOI":"10.14778\/1920841.1920927"},{"key":"19_CR12","doi-asserted-by":"publisher","unstructured":"Glaser, J., et al.: High-throughput virtual laboratory for drug discovery using massive datasets. Int. J. High Perform. Comput. Appl. 35, 452\u2013468 (2021). https:\/\/doi.org\/10.1177\/10943420211001565","DOI":"10.1177\/10943420211001565"},{"key":"19_CR13","doi-asserted-by":"publisher","unstructured":"Govindaraju, N.K., Lloyd, B., Wang, W., Lin, M., Manocha, D.: Fast computation of database operations using graphics processors. In: Proceedings of the 2004 ACM SIGMOD International Conference on Management of Data. SIGMOD 2004, pp. 215\u2013226. Association for Computing Machinery, New York, NY, USA (2004). https:\/\/doi.org\/10.1145\/1007568.1007594","DOI":"10.1145\/1007568.1007594"},{"key":"19_CR14","doi-asserted-by":"publisher","unstructured":"He, B., Relational query coprocessing on graphics processors. ACM Trans. Database Syst. 34(4) (2009). https:\/\/doi.org\/10.1145\/1620585.1620588","DOI":"10.1145\/1620585.1620588"},{"key":"19_CR15","series-title":"Communications in Computer and Information Science","doi-asserted-by":"publisher","first-page":"366","DOI":"10.1007\/978-3-030-63393-6_24","volume-title":"Driving Scientific and Engineering Discoveries Through the Convergence of HPC, Big Data and AI","author":"B Hern\u00e1ndez","year":"2020","unstructured":"Hern\u00e1ndez, B., et al.: Performance evaluation of Python based data analytics frameworks in summit: early experiences. In: Nichols, J., Verastegui, B., Maccabe, A.B., Hernandez, O., Parete-Koon, S., Ahearn, T. (eds.) SMC 2020. CCIS, vol. 1315, pp. 366\u2013380. Springer, Cham (2020). https:\/\/doi.org\/10.1007\/978-3-030-63393-6_24"},{"key":"19_CR16","unstructured":"Huebl, A.: OpenPMD release 1.4.0 with support for data processing through dask. https:\/\/github.com\/openPMD\/openPMD-api\/releases\/tag\/0.14.0 (2021)"},{"key":"19_CR17","doi-asserted-by":"crossref","unstructured":"Lee, S., Park, S.: Performance analysis of big data ETL process over CPU-GPU heterogeneous architectures. In: 2021 IEEE 37th International Conference on Data Engineering Workshops (ICDEW), pp. 42\u201347 (2021)","DOI":"10.1109\/ICDEW53142.2021.00015"},{"key":"19_CR18","doi-asserted-by":"crossref","unstructured":"Lu, X., et al.: High-performance design of hadoop RPC with RDMA over InfiniBand. In: 2013 42nd International Conference on Parallel Processing, pp. 641\u2013650 (2013)","DOI":"10.1109\/ICPP.2013.78"},{"key":"19_CR19","unstructured":"NVIDIA: Open GPU data science-RAPIDS. https:\/\/rapids.ai (2021). Accessed 26 May 2021"},{"key":"19_CR20","doi-asserted-by":"publisher","unstructured":"Olsen, S., Romoser, B., Zong, Z.: SQLPhi: a SQL-based database engine for intel Xeon Phi coprocessors. In: Proceedings of the 2014 International Conference on Big Data Science and Computing. BigDataScience 2014. Association for Computing Machinery, New York, NY, USA (2014). https:\/\/doi.org\/10.1145\/2640087.2644172","DOI":"10.1145\/2640087.2644172"},{"key":"19_CR21","unstructured":"OmniSciDB: OmniSciDB: open source SQL-based, relational, columnar database engine. https:\/\/github.com\/omnisci\/omniscidb (2021). Accessed 26 May 2021"},{"key":"19_CR22","first-page":"2825","volume":"12","author":"F Pedregosa","year":"2011","unstructured":"Pedregosa, F., et al.: Scikit-learn: machine learning in Python. J. Mach. Learn. Res. 12, 2825\u20132830 (2011)","journal-title":"J. Mach. Learn. Res."},{"key":"19_CR23","unstructured":"PGStrom: PG-Strom: a GPU extension module of PostgreSQL. https:\/\/github.com\/heterodb\/pg-strom (2021). Accessed 26 May 2021"},{"key":"19_CR24","doi-asserted-by":"crossref","unstructured":"Poeschel, F., et al.: Transitioning from file-based HPC workflows to streaming data pipelines with openPMD and ADIOS2. arXiv preprint arXiv:2107.06108 (2021)","DOI":"10.1007\/978-3-030-96498-6_6"},{"key":"19_CR25","doi-asserted-by":"crossref","unstructured":"Shamis, P., et al.: UCX: an open source framework for HPC network APIs and beyond. In: 2015 IEEE 23rd Annual Symposium on High-Performance Interconnects, pp. 40\u201343. IEEE (2015)","DOI":"10.1109\/HOTI.2015.13"},{"key":"19_CR26","doi-asserted-by":"crossref","unstructured":"Shehab, E., Algergawy, A., Sarhan, A.: Accelerating relational database operations using both CPU and GPU co-processor. Comput. Electr. Eng. 57, 69\u201380 (2017). https:\/\/www.sciencedirect.com\/science\/article\/pii\/S0045790616310631","DOI":"10.1016\/j.compeleceng.2016.12.014"},{"key":"19_CR27","doi-asserted-by":"publisher","unstructured":"The pandas development team: pandas-dev\/pandas: Pandas (2020). https:\/\/doi.org\/10.5281\/zenodo.3509134","DOI":"10.5281\/zenodo.3509134"},{"key":"19_CR28","unstructured":"UCX: UCX Client-Server. https:\/\/openucx.github.io\/ucx\/api\/v1.10\/html\/ucp_client_server_8c-example.html (2021). Accessed 26 May 2021"},{"key":"19_CR29","doi-asserted-by":"crossref","unstructured":"Weininger, D.: SMILES, a chemical language and information system. 1. Introduction to methodology and encoding rules. J. Chem. Inf. Comput. Sci. 28(1), 31\u201336 (1988)","DOI":"10.1021\/ci00057a005"},{"key":"19_CR30","doi-asserted-by":"publisher","unstructured":"Woods, L., Istv\u00e1n, Z., Alonso, G.: Ibex: an intelligent storage engine with support for advanced SQL offloading. Proc. VLDB Endow. 7(11), 963\u2013974 (2014). https:\/\/doi.org\/10.14778\/2732967.2732972","DOI":"10.14778\/2732967.2732972"}],"container-title":["Communications in Computer and Information Science","Driving Scientific and Engineering Discoveries Through the Integration of Experiment, Big Data, and Modeling and Simulation"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/link.springer.com\/content\/pdf\/10.1007\/978-3-030-96498-6_19","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2022,7,5]],"date-time":"2022-07-05T09:08:22Z","timestamp":1657012102000},"score":1,"resource":{"primary":{"URL":"https:\/\/link.springer.com\/10.1007\/978-3-030-96498-6_19"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2022]]},"ISBN":["9783030964979","9783030964986"],"references-count":30,"URL":"https:\/\/doi.org\/10.1007\/978-3-030-96498-6_19","relation":{},"ISSN":["1865-0929","1865-0937"],"issn-type":[{"type":"print","value":"1865-0929"},{"type":"electronic","value":"1865-0937"}],"subject":[],"published":{"date-parts":[[2022]]},"assertion":[{"value":"10 March 2022","order":1,"name":"first_online","label":"First Online","group":{"name":"ChapterHistory","label":"Chapter History"}},{"value":"SMC","order":1,"name":"conference_acronym","label":"Conference Acronym","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"Smoky Mountains Computational Sciences and Engineering Conference","order":2,"name":"conference_name","label":"Conference Name","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"2021","order":5,"name":"conference_year","label":"Conference Year","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"18 October 2021","order":7,"name":"conference_start_date","label":"Conference Start Date","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"20 October 2021","order":8,"name":"conference_end_date","label":"Conference End Date","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"21","order":9,"name":"conference_number","label":"Conference Number","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"smc2021","order":10,"name":"conference_id","label":"Conference ID","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"https:\/\/smc2021.ornl.gov","order":11,"name":"conference_url","label":"Conference URL","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"Single-blind","order":1,"name":"type","label":"Type","group":{"name":"ConfEventPeerReviewInformation","label":"Peer Review Information (provided by the conference organizers)"}},{"value":"EasyChair","order":2,"name":"conference_management_system","label":"Conference Management System","group":{"name":"ConfEventPeerReviewInformation","label":"Peer Review Information (provided by the conference organizers)"}},{"value":"88","order":3,"name":"number_of_submissions_sent_for_review","label":"Number of Submissions Sent for Review","group":{"name":"ConfEventPeerReviewInformation","label":"Peer Review Information (provided by the conference organizers)"}},{"value":"33","order":4,"name":"number_of_full_papers_accepted","label":"Number of Full Papers Accepted","group":{"name":"ConfEventPeerReviewInformation","label":"Peer Review Information (provided by the conference organizers)"}},{"value":"3","order":5,"name":"number_of_short_papers_accepted","label":"Number of Short Papers Accepted","group":{"name":"ConfEventPeerReviewInformation","label":"Peer Review Information (provided by the conference organizers)"}},{"value":"38% - The value is computed by the equation \"Number of Full Papers Accepted \/ Number of Submissions Sent for Review * 100\" and then rounded to a whole number.","order":6,"name":"acceptance_rate_of_full_papers","label":"Acceptance Rate of Full Papers","group":{"name":"ConfEventPeerReviewInformation","label":"Peer Review Information (provided by the conference organizers)"}},{"value":"3","order":7,"name":"average_number_of_reviews_per_paper","label":"Average Number of Reviews per Paper","group":{"name":"ConfEventPeerReviewInformation","label":"Peer Review Information (provided by the conference organizers)"}},{"value":"3","order":8,"name":"average_number_of_papers_per_reviewer","label":"Average Number of Papers per Reviewer","group":{"name":"ConfEventPeerReviewInformation","label":"Peer Review Information (provided by the conference organizers)"}},{"value":"No","order":9,"name":"external_reviewers_involved","label":"External Reviewers Involved","group":{"name":"ConfEventPeerReviewInformation","label":"Peer Review Information (provided by the conference organizers)"}}]}}