{"id":"https://openalex.org/W2954484440","doi":"https://doi.org/10.1145/3329785.3329928","title":"Towards Practical Vectorized Analytical Query Engines","display_name":"Towards Practical Vectorized Analytical Query Engines","publication_year":2019,"publication_date":"2019-06-24","ids":{"openalex":"https://openalex.org/W2954484440","doi":"https://doi.org/10.1145/3329785.3329928","mag":"2954484440"},"language":"en","primary_location":{"id":"doi:10.1145/3329785.3329928","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3329785.3329928","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/3329785.3329928","source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 15th International Workshop on Data Management on New Hardware","raw_type":"proceedings-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"gold","oa_url":"https://dl.acm.org/doi/pdf/10.1145/3329785.3329928","any_repository_has_fulltext":null},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5077806101","display_name":"Orestis Polychroniou","orcid":"https://orcid.org/0000-0002-3164-0137"},"institutions":[],"countries":[],"is_corresponding":true,"raw_author_name":"Orestis Polychroniou","raw_affiliation_strings":["Amazon Web Services and Columbia University"],"affiliations":[{"raw_affiliation_string":"Amazon Web Services and Columbia University","institution_ids":[]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5021663937","display_name":"Kenneth A. Ross","orcid":"https://orcid.org/0000-0001-9397-6990"},"institutions":[{"id":"https://openalex.org/I78577930","display_name":"Columbia University","ror":"https://ror.org/00hj8s172","country_code":"US","type":"education","lineage":["https://openalex.org/I78577930"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Kenneth A. Ross","raw_affiliation_strings":["Columbia University"],"affiliations":[{"raw_affiliation_string":"Columbia University","institution_ids":["https://openalex.org/I78577930"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":["https://openalex.org/A5077806101"],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":2.0038,"has_fulltext":true,"cited_by_count":19,"citation_normalized_percentile":{"value":0.87238315,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":98},"biblio":{"volume":null,"issue":null,"first_page":"1","last_page":"7"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9994000196456909,"subfield":{"id":"https://openalex.org/subfields/1711","display_name":"Signal Processing"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},"topics":[{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9994000196456909,"subfield":{"id":"https://openalex.org/subfields/1711","display_name":"Signal Processing"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9993000030517578,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T12292","display_name":"Graph Theory and Algorithms","score":0.9952999949455261,"subfield":{"id":"https://openalex.org/subfields/1707","display_name":"Computer Vision and Pattern Recognition"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/simd","display_name":"SIMD","score":0.9267485737800598},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8555655479431152},{"id":"https://openalex.org/keywords/parallel-computing","display_name":"Parallel computing","score":0.6103779077529907},{"id":"https://openalex.org/keywords/vectorization","display_name":"Vectorization (mathematics)","score":0.5157744884490967}],"concepts":[{"id":"https://openalex.org/C150552126","wikidata":"https://www.wikidata.org/wiki/Q339387","display_name":"SIMD","level":2,"score":0.9267485737800598},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8555655479431152},{"id":"https://openalex.org/C173608175","wikidata":"https://www.wikidata.org/wiki/Q232661","display_name":"Parallel computing","level":1,"score":0.6103779077529907},{"id":"https://openalex.org/C41681595","wikidata":"https://www.wikidata.org/wiki/Q7917855","display_name":"Vectorization (mathematics)","level":2,"score":0.5157744884490967}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/3329785.3329928","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3329785.3329928","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/3329785.3329928","source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 15th International Workshop on Data Management on New Hardware","raw_type":"proceedings-article"}],"best_oa_location":{"id":"doi:10.1145/3329785.3329928","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3329785.3329928","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/3329785.3329928","source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 15th International Workshop on Data Management on New Hardware","raw_type":"proceedings-article"},"sustainable_development_goals":[],"awards":[{"id":"https://openalex.org/G5186389501","display_name":null,"funder_award_id":"IIS-1422488","funder_id":"https://openalex.org/F4320306076","funder_display_name":"National Science Foundation"},{"id":"https://openalex.org/G5292489514","display_name":"III: Small: Database Algorithms for Modern CPU Memory Hierarchies","funder_award_id":"1422488","funder_id":"https://openalex.org/F4320306076","funder_display_name":"National Science Foundation"}],"funders":[{"id":"https://openalex.org/F4320306076","display_name":"National Science Foundation","ror":"https://ror.org/021nxhr62"}],"has_content":{"pdf":true,"grobid_xml":true},"content_urls":{"pdf":"https://content.openalex.org/works/W2954484440.pdf","grobid_xml":"https://content.openalex.org/works/W2954484440.grobid-xml"},"referenced_works_count":55,"referenced_works":["https://openalex.org/W1194153933","https://openalex.org/W1602137482","https://openalex.org/W1605782097","https://openalex.org/W1852127287","https://openalex.org/W1966485119","https://openalex.org/W1967091776","https://openalex.org/W1967601791","https://openalex.org/W1982013147","https://openalex.org/W1995302096","https://openalex.org/W2006552857","https://openalex.org/W2019186666","https://openalex.org/W2025051251","https://openalex.org/W2055774867","https://openalex.org/W2062666276","https://openalex.org/W2072541977","https://openalex.org/W2082695854","https://openalex.org/W2086977914","https://openalex.org/W2096496252","https://openalex.org/W2097880677","https://openalex.org/W2099035968","https://openalex.org/W2104003087","https://openalex.org/W2105079611","https://openalex.org/W2106771621","https://openalex.org/W2122048769","https://openalex.org/W2124851765","https://openalex.org/W2125529470","https://openalex.org/W2144839430","https://openalex.org/W2146461854","https://openalex.org/W2147076738","https://openalex.org/W2153952995","https://openalex.org/W2157174514","https://openalex.org/W2166955231","https://openalex.org/W2172165802","https://openalex.org/W2249320699","https://openalex.org/W2278783412","https://openalex.org/W2406955896","https://openalex.org/W2409939811","https://openalex.org/W2430301697","https://openalex.org/W2433128352","https://openalex.org/W2439390339","https://openalex.org/W2440477515","https://openalex.org/W2484902940","https://openalex.org/W2548100623","https://openalex.org/W2765206444","https://openalex.org/W2767926324","https://openalex.org/W2806132641","https://openalex.org/W2897173745","https://openalex.org/W2912601938","https://openalex.org/W2916238833","https://openalex.org/W2961966181","https://openalex.org/W3136655632","https://openalex.org/W3138367763","https://openalex.org/W3139669840","https://openalex.org/W3141434431","https://openalex.org/W6678708722"],"related_works":["https://openalex.org/W2566637483","https://openalex.org/W2127324789","https://openalex.org/W3024308452","https://openalex.org/W4244894488","https://openalex.org/W4285390450","https://openalex.org/W2366442643","https://openalex.org/W2021715972","https://openalex.org/W2090268225","https://openalex.org/W75461624","https://openalex.org/W2766828645"],"abstract_inverted_index":{"Query":[0],"execution":[1],"engines":[2,76],"are":[3,23],"adapting":[4],"to":[5,11,47,63],"the":[6,36,58,73,119],"underlying":[7],"hardware":[8],"in":[9,25,112],"order":[10],"maximize":[12],"performance.":[13],"Wider":[14],"SIMD":[15,20,45,62],"registers":[16],"and":[17,101,109],"more":[18],"complex":[19],"instruction":[21],"sets":[22],"emerging":[24],"mainstream":[26],"CPUs":[27],"as":[28,30,35],"well":[29],"new":[31],"processor":[32],"designs,":[33],"such":[34],"many-core":[37],"platforms":[38],"that":[39],"rely":[40,77],"on":[41,78],"data":[42],"parallelism":[43],"via":[44],"vectorization":[46],"pack":[48],"a":[49],"larger":[50],"number":[51],"of":[52,80],"smaller":[53],"cores":[54],"per":[55],"chip.":[56],"In":[57,90,114],"database":[59],"literature,":[60],"using":[61],"optimize":[64],"stand-alone":[65],"operators":[66,83,87],"with":[67],"key-rid":[68],"pairs":[69],"is":[70],"common,":[71],"yet":[72],"state-of-the-art":[74],"query":[75,98],"compilation":[79],"tightly":[81],"coupled":[82],"where":[84],"hand-optimized":[85,125],"individual":[86],"become":[88],"impractical.":[89],"this":[91],"paper,":[92],"we":[93],"present":[94],"VIP,":[95],"an":[96],"analytical":[97],"engine":[99],"designed":[100],"built":[102],"bottom-up":[103],"from":[104,118],"pre-compiled":[105],"column-oriented":[106],"data-parallel":[107],"sub-operators":[108],"implemented":[110],"entirely":[111],"SIMD.":[113],"our":[115],"evaluation":[116],"derived":[117],"TPC-H":[120],"workload,":[121],"VIP":[122],"outperforms":[123],"query-specific":[124],"scalar":[126],"code.":[127]},"counts_by_year":[{"year":2025,"cited_by_count":1},{"year":2024,"cited_by_count":3},{"year":2023,"cited_by_count":3},{"year":2022,"cited_by_count":5},{"year":2021,"cited_by_count":1},{"year":2020,"cited_by_count":5},{"year":2019,"cited_by_count":1}],"updated_date":"2026-04-21T08:09:41.155169","created_date":"2025-10-10T00:00:00"}