{"id":"https://openalex.org/W2294745660","doi":"https://doi.org/10.1145/2949689.2949703","title":"Vectorized UDFs in Column-Stores","display_name":"Vectorized UDFs in Column-Stores","publication_year":2016,"publication_date":"2016-07-08","ids":{"openalex":"https://openalex.org/W2294745660","doi":"https://doi.org/10.1145/2949689.2949703","mag":"2294745660"},"language":"en","primary_location":{"id":"doi:10.1145/2949689.2949703","is_oa":false,"landing_page_url":"https://doi.org/10.1145/2949689.2949703","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 28th International Conference on Scientific and Statistical Database Management","raw_type":"proceedings-article"},"type":"conference-paper","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"https://ir.cwi.nl/pub/25206/a16-raasveldt.pdf","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5074274947","display_name":"Mark Raasveldt","orcid":"https://orcid.org/0000-0001-5005-6844"},"institutions":[{"id":"https://openalex.org/I1341640284","display_name":"Centrum Wiskunde & Informatica","ror":"https://ror.org/00x7ekv49","country_code":"NL","type":"facility","lineage":["https://openalex.org/I1341640284","https://openalex.org/I2800991832","https://openalex.org/I4405262988"]}],"countries":["NL"],"is_corresponding":false,"raw_author_name":"Mark Raasveldt","raw_affiliation_strings":["CWI, Amsterdam, the Netherlands"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"CWI, Amsterdam, the Netherlands","institution_ids":["https://openalex.org/I1341640284"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5050785612","display_name":"Hannes M\u00fchleisen","orcid":"https://orcid.org/0000-0001-8552-0029"},"institutions":[{"id":"https://openalex.org/I1341640284","display_name":"Centrum Wiskunde & Informatica","ror":"https://ror.org/00x7ekv49","country_code":"NL","type":"facility","lineage":["https://openalex.org/I1341640284","https://openalex.org/I2800991832","https://openalex.org/I4405262988"]}],"countries":["NL"],"is_corresponding":false,"raw_author_name":"Hannes M\u00fchleisen","raw_affiliation_strings":["CWI, Amsterdam, the Netherlands"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"CWI, Amsterdam, the Netherlands","institution_ids":["https://openalex.org/I1341640284"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":[],"corresponding_institution_ids":["https://openalex.org/I1341640284"],"apc_list":null,"apc_paid":null,"fwci":3.5316,"has_fulltext":true,"cited_by_count":30,"citation_normalized_percentile":{"value":0.93915421,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":89,"max":99},"biblio":{"volume":null,"issue":null,"first_page":"1","last_page":"12"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9986000061035156,"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"}},"topics":[{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9986000061035156,"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/T11181","display_name":"Advanced Data Storage Technologies","score":0.995199978351593,"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/T11986","display_name":"Scientific Computing and Data Management","score":0.9932000041007996,"subfield":{"id":"https://openalex.org/subfields/1802","display_name":"Information Systems and Management"},"field":{"id":"https://openalex.org/fields/18","display_name":"Decision Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8531293869018555},{"id":"https://openalex.org/keywords/python","display_name":"Python (programming language)","score":0.7819353342056274},{"id":"https://openalex.org/keywords/scripting-language","display_name":"Scripting language","score":0.7696458101272583},{"id":"https://openalex.org/keywords/parsing","display_name":"Parsing","score":0.6618086695671082},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.5903871655464172},{"id":"https://openalex.org/keywords/overhead","display_name":"Overhead (engineering)","score":0.5226578116416931},{"id":"https://openalex.org/keywords/data-type","display_name":"Data type","score":0.43771013617515564},{"id":"https://openalex.org/keywords/data-management","display_name":"Data management","score":0.42566096782684326},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.4076562225818634},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.3306843638420105}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8531293869018555},{"id":"https://openalex.org/C519991488","wikidata":"https://www.wikidata.org/wiki/Q28865","display_name":"Python (programming language)","level":2,"score":0.7819353342056274},{"id":"https://openalex.org/C61423126","wikidata":"https://www.wikidata.org/wiki/Q187432","display_name":"Scripting language","level":2,"score":0.7696458101272583},{"id":"https://openalex.org/C186644900","wikidata":"https://www.wikidata.org/wiki/Q194152","display_name":"Parsing","level":2,"score":0.6618086695671082},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5903871655464172},{"id":"https://openalex.org/C2779960059","wikidata":"https://www.wikidata.org/wiki/Q7113681","display_name":"Overhead (engineering)","level":2,"score":0.5226578116416931},{"id":"https://openalex.org/C138958017","wikidata":"https://www.wikidata.org/wiki/Q190087","display_name":"Data type","level":2,"score":0.43771013617515564},{"id":"https://openalex.org/C1668388","wikidata":"https://www.wikidata.org/wiki/Q1149776","display_name":"Data management","level":2,"score":0.42566096782684326},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.4076562225818634},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.3306843638420105}],"mesh":[],"locations_count":3,"locations":[{"id":"doi:10.1145/2949689.2949703","is_oa":false,"landing_page_url":"https://doi.org/10.1145/2949689.2949703","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 28th International Conference on Scientific and Statistical Database Management","raw_type":"proceedings-article"},{"id":"pmh:oai:cwi.nl:25206","is_oa":true,"landing_page_url":"https://ir.cwi.nl/pub/25206","pdf_url":"https://ir.cwi.nl/pub/25206/a16-raasveldt.pdf","source":{"id":"https://openalex.org/S7407055335","display_name":"Centrum Wiskunde & Informatica (CWI), the national research institute for mathematics and computer science in the Netherlands","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"info:eu-repo/semantics/conferenceObject"},{"id":"pmh:oai:dspace.library.uu.nl:1874/325669","is_oa":true,"landing_page_url":"http://dspace.library.uu.nl:8080/handle/1874/325669","pdf_url":null,"source":{"id":"https://openalex.org/S4306401649","display_name":"Utrecht University Repository (Utrecht University)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I193662353","host_organization_name":"Utrecht University","host_organization_lineage":["https://openalex.org/I193662353"],"host_organization_lineage_names":[],"type":"repository"},"license":"other-oa","license_id":"https://openalex.org/licenses/other-oa","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":"Master thesis"}],"best_oa_location":{"id":"pmh:oai:cwi.nl:25206","is_oa":true,"landing_page_url":"https://ir.cwi.nl/pub/25206","pdf_url":"https://ir.cwi.nl/pub/25206/a16-raasveldt.pdf","source":{"id":"https://openalex.org/S7407055335","display_name":"Centrum Wiskunde & Informatica (CWI), the national research institute for mathematics and computer science in the Netherlands","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"info:eu-repo/semantics/conferenceObject"},"sustainable_development_goals":[],"awards":[{"id":"https://openalex.org/G1290265118","display_name":"Process mining for multi-objective online control (PROMIMOOC)","funder_award_id":"650.002.001","funder_id":"https://openalex.org/F4320321800","funder_display_name":"Nederlandse Organisatie voor Wetenschappelijk Onderzoek"}],"funders":[{"id":"https://openalex.org/F4320321800","display_name":"Nederlandse Organisatie voor Wetenschappelijk Onderzoek","ror":"https://ror.org/04jsz6e67"}],"has_content":{"grobid_xml":true,"pdf":true},"content_urls":{"pdf":"https://content.openalex.org/works/W2294745660.pdf","grobid_xml":"https://content.openalex.org/works/W2294745660.grobid-xml"},"referenced_works_count":28,"referenced_works":["https://openalex.org/W201801013","https://openalex.org/W1521148341","https://openalex.org/W1536826708","https://openalex.org/W1575011129","https://openalex.org/W1602670935","https://openalex.org/W1603747016","https://openalex.org/W2006296837","https://openalex.org/W2058494157","https://openalex.org/W2060220453","https://openalex.org/W2064803206","https://openalex.org/W2067650870","https://openalex.org/W2068644217","https://openalex.org/W2088398920","https://openalex.org/W2090336847","https://openalex.org/W2091705820","https://openalex.org/W2101234009","https://openalex.org/W2102727638","https://openalex.org/W2106771621","https://openalex.org/W2109025447","https://openalex.org/W2112485457","https://openalex.org/W2117546628","https://openalex.org/W2117707942","https://openalex.org/W2124851765","https://openalex.org/W2146292423","https://openalex.org/W2160967997","https://openalex.org/W2162973062","https://openalex.org/W2165467455","https://openalex.org/W2342249984"],"related_works":["https://openalex.org/W3023169329","https://openalex.org/W4389470870","https://openalex.org/W2782165897","https://openalex.org/W1582950852","https://openalex.org/W4300438041","https://openalex.org/W2054104202","https://openalex.org/W2139703748","https://openalex.org/W2761254753","https://openalex.org/W1024825291","https://openalex.org/W2188981919"],"abstract_inverted_index":{"Data":[0,69],"Scientists":[1],"rely":[2],"on":[3,18],"vector-based":[4],"scripting":[5],"languages":[6],"such":[7,84],"as":[8,51,53,85],"R,":[9],"Python":[10],"and":[11,47],"MATLAB":[12],"to":[13],"perform":[14],"ad-hoc":[15],"data":[16,21,26,33,50,63,81,86],"analysis":[17,82,94],"potentially":[19],"large":[20,25],"sets.":[22],"When":[23],"facing":[24],"sets,":[27],"they":[28],"are":[29],"only":[30],"efficient":[31],"when":[32],"is":[34],"processed":[35],"using":[36],"vectorized":[37],"or":[38],"bulk":[39],"operations.":[40],"At":[41],"the":[42,58],"same":[43],"time,":[44],"overwhelming":[45],"volume":[46],"variety":[48],"of":[49,60,80],"well":[52],"parsing":[54],"overhead":[55],"suggests":[56],"that":[57],"use":[59],"specialized":[61],"analytical":[62],"management":[64],"systems":[65],"would":[66],"be":[67,73],"beneficial.":[68],"might":[70],"also":[71],"already":[72],"stored":[74],"in":[75],"a":[76,90],"database.":[77],"Efficient":[78],"execution":[79],"programs":[83],"mining":[87],"directly":[88],"inside":[89],"database":[91],"greatly":[92],"improves":[93],"efficiency.":[95]},"counts_by_year":[{"year":2026,"cited_by_count":1},{"year":2025,"cited_by_count":3},{"year":2024,"cited_by_count":4},{"year":2023,"cited_by_count":3},{"year":2022,"cited_by_count":2},{"year":2021,"cited_by_count":2},{"year":2020,"cited_by_count":1},{"year":2019,"cited_by_count":4},{"year":2018,"cited_by_count":7},{"year":2017,"cited_by_count":3}],"updated_date":"2026-08-01T09:00:35.917206","created_date":"2025-10-10T00:00:00"}