{"id":"https://openalex.org/W2053955827","doi":"https://doi.org/10.1145/2485278.2485282","title":"Optimizing select conditions on GPUs","display_name":"Optimizing select conditions on GPUs","publication_year":2013,"publication_date":"2013-06-24","ids":{"openalex":"https://openalex.org/W2053955827","doi":"https://doi.org/10.1145/2485278.2485282","mag":"2053955827"},"language":"en","primary_location":{"id":"doi:10.1145/2485278.2485282","is_oa":false,"landing_page_url":"https://doi.org/10.1145/2485278.2485282","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the Ninth International Workshop on Data Management on New Hardware","raw_type":"proceedings-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":false,"oa_status":"closed","oa_url":null,"any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5063629406","display_name":"Evangelia Sitaridi","orcid":null},"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":true,"raw_author_name":"Evangelia A. Sitaridi","raw_affiliation_strings":["Columbia University"],"affiliations":[{"raw_affiliation_string":"Columbia University","institution_ids":["https://openalex.org/I78577930"]}]},{"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/A5063629406"],"corresponding_institution_ids":["https://openalex.org/I78577930"],"apc_list":null,"apc_paid":null,"fwci":2.8369,"has_fulltext":false,"cited_by_count":35,"citation_normalized_percentile":{"value":0.9065262,"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":"8"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10054","display_name":"Parallel Computing and Optimization Techniques","score":0.9994999766349792,"subfield":{"id":"https://openalex.org/subfields/1708","display_name":"Hardware and Architecture"},"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/T10054","display_name":"Parallel Computing and Optimization Techniques","score":0.9994999766349792,"subfield":{"id":"https://openalex.org/subfields/1708","display_name":"Hardware and Architecture"},"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/T11269","display_name":"Algorithms and Data Compression","score":0.9976999759674072,"subfield":{"id":"https://openalex.org/subfields/1702","display_name":"Artificial Intelligence"},"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/T10715","display_name":"Distributed and Parallel Computing Systems","score":0.9958000183105469,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8655223846435547},{"id":"https://openalex.org/keywords/thread","display_name":"Thread (computing)","score":0.7272859811782837},{"id":"https://openalex.org/keywords/parallel-computing","display_name":"Parallel computing","score":0.7161558270454407},{"id":"https://openalex.org/keywords/implementation","display_name":"Implementation","score":0.6485217809677124},{"id":"https://openalex.org/keywords/scheduling","display_name":"Scheduling (production processes)","score":0.5657889246940613},{"id":"https://openalex.org/keywords/kernel","display_name":"Kernel (algebra)","score":0.562653660774231},{"id":"https://openalex.org/keywords/multi-core-processor","display_name":"Multi-core processor","score":0.5541762113571167},{"id":"https://openalex.org/keywords/operator","display_name":"Operator (biology)","score":0.44054728746414185},{"id":"https://openalex.org/keywords/query-plan","display_name":"Query plan","score":0.43458011746406555},{"id":"https://openalex.org/keywords/multithreading","display_name":"Multithreading","score":0.4126827120780945},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.28150320053100586},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.1321844756603241}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8655223846435547},{"id":"https://openalex.org/C138101251","wikidata":"https://www.wikidata.org/wiki/Q213092","display_name":"Thread (computing)","level":2,"score":0.7272859811782837},{"id":"https://openalex.org/C173608175","wikidata":"https://www.wikidata.org/wiki/Q232661","display_name":"Parallel computing","level":1,"score":0.7161558270454407},{"id":"https://openalex.org/C26713055","wikidata":"https://www.wikidata.org/wiki/Q245962","display_name":"Implementation","level":2,"score":0.6485217809677124},{"id":"https://openalex.org/C206729178","wikidata":"https://www.wikidata.org/wiki/Q2271896","display_name":"Scheduling (production processes)","level":2,"score":0.5657889246940613},{"id":"https://openalex.org/C74193536","wikidata":"https://www.wikidata.org/wiki/Q574844","display_name":"Kernel (algebra)","level":2,"score":0.562653660774231},{"id":"https://openalex.org/C78766204","wikidata":"https://www.wikidata.org/wiki/Q555032","display_name":"Multi-core processor","level":2,"score":0.5541762113571167},{"id":"https://openalex.org/C17020691","wikidata":"https://www.wikidata.org/wiki/Q139677","display_name":"Operator (biology)","level":5,"score":0.44054728746414185},{"id":"https://openalex.org/C2779729312","wikidata":"https://www.wikidata.org/wiki/Q784232","display_name":"Query plan","level":5,"score":0.43458011746406555},{"id":"https://openalex.org/C201410400","wikidata":"https://www.wikidata.org/wiki/Q1064412","display_name":"Multithreading","level":3,"score":0.4126827120780945},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.28150320053100586},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.1321844756603241},{"id":"https://openalex.org/C192939062","wikidata":"https://www.wikidata.org/wiki/Q104840822","display_name":"Sargable","level":4,"score":0.0},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.0},{"id":"https://openalex.org/C86339819","wikidata":"https://www.wikidata.org/wiki/Q407384","display_name":"Transcription factor","level":3,"score":0.0},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.0},{"id":"https://openalex.org/C158448853","wikidata":"https://www.wikidata.org/wiki/Q425218","display_name":"Repressor","level":4,"score":0.0},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.0},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.0},{"id":"https://openalex.org/C21547014","wikidata":"https://www.wikidata.org/wiki/Q1423657","display_name":"Operations management","level":1,"score":0.0},{"id":"https://openalex.org/C185592680","wikidata":"https://www.wikidata.org/wiki/Q2329","display_name":"Chemistry","level":0,"score":0.0},{"id":"https://openalex.org/C114614502","wikidata":"https://www.wikidata.org/wiki/Q76592","display_name":"Combinatorics","level":1,"score":0.0},{"id":"https://openalex.org/C104317684","wikidata":"https://www.wikidata.org/wiki/Q7187","display_name":"Gene","level":2,"score":0.0},{"id":"https://openalex.org/C55493867","wikidata":"https://www.wikidata.org/wiki/Q7094","display_name":"Biochemistry","level":1,"score":0.0},{"id":"https://openalex.org/C162324750","wikidata":"https://www.wikidata.org/wiki/Q8134","display_name":"Economics","level":0,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/2485278.2485282","is_oa":false,"landing_page_url":"https://doi.org/10.1145/2485278.2485282","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the Ninth International Workshop on Data Management on New Hardware","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[{"id":"https://metadata.un.org/sdg/8","display_name":"Decent work and economic growth","score":0.47999998927116394}],"awards":[{"id":"https://openalex.org/G7425740805","display_name":null,"funder_award_id":"IIS-1218222","funder_id":"https://openalex.org/F4320337389","funder_display_name":"Division of Information and Intelligent Systems"}],"funders":[{"id":"https://openalex.org/F4320306076","display_name":"National Science Foundation","ror":"https://ror.org/021nxhr62"},{"id":"https://openalex.org/F4320309480","display_name":"Nvidia","ror":"https://ror.org/03jdj4y14"},{"id":"https://openalex.org/F4320337389","display_name":"Division of Information and Intelligent Systems","ror":"https://ror.org/053a2cp42"}],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":20,"referenced_works":["https://openalex.org/W1992558790","https://openalex.org/W1998545184","https://openalex.org/W2013247896","https://openalex.org/W2019186666","https://openalex.org/W2022750656","https://openalex.org/W2023236551","https://openalex.org/W2048622250","https://openalex.org/W2060883486","https://openalex.org/W2089482246","https://openalex.org/W2106329447","https://openalex.org/W2106771621","https://openalex.org/W2112828875","https://openalex.org/W2128329055","https://openalex.org/W2135947393","https://openalex.org/W2144839430","https://openalex.org/W2156831150","https://openalex.org/W2167675119","https://openalex.org/W2169880332","https://openalex.org/W2257258878","https://openalex.org/W3013490664"],"related_works":["https://openalex.org/W2115561485","https://openalex.org/W1985089255","https://openalex.org/W2153202644","https://openalex.org/W2010970156","https://openalex.org/W2482815832","https://openalex.org/W2105895556","https://openalex.org/W2733115356","https://openalex.org/W2377593213","https://openalex.org/W2294358097","https://openalex.org/W4235861380"],"abstract_inverted_index":{"Implementations":[0],"of":[1,31,41,47,66,96],"data":[2],"processing":[3],"operators":[4],"on":[5],"GPU":[6,32],"processors":[7],"have":[8,72],"achieved":[9],"significant":[10],"performance":[11,137],"improvements":[12],"over":[13],"their":[14],"multicore":[15],"CPU":[16],"counterparts.":[17],"To":[18],"achieve":[19],"maximum":[20],"performance,":[21],"database":[22],"operator":[23,148],"implementations":[24],"must":[25],"take":[26],"into":[27,122],"consideration":[28],"special":[29],"features":[30],"architectures.":[33],"A":[34],"crucial":[35],"difference":[36],"is":[37,43],"that":[38,134,140],"the":[39,64,75,94,111],"unit":[40],"execution":[42,77,113],"a":[44,58,70,116],"group":[45],"(\"warp\")":[46],"threads,":[48],"32":[49],"threads":[50,68,81],"in":[51,69],"our":[52,141],"target":[53],"architecture,":[54],"as":[55],"opposed":[56],"to":[57,73,90],"single":[59],"thread":[60],"for":[61,115],"CPUs.":[62],"In":[63],"presence":[65],"branches,":[67],"warp":[71],"follow":[74],"same":[76],"path;":[78],"if":[79],"some":[80],"diverge":[82],"then":[83],"different":[84],"paths":[85],"are":[86],"serialized.":[87],"Additionally,":[88],"similarly":[89],"CPUs,":[91],"branches":[92],"degrade":[93],"efficiency":[95],"instruction":[97],"scheduling.":[98],"Here,":[99],"we":[100],"study":[101],"conjunctive":[102,117],"selection":[103],"queries":[104],"where":[105],"branching":[106],"hurts":[107],"performance.":[108,149],"We":[109],"compute":[110],"optimal":[112],"plan":[114],"query,":[118],"taking":[119],"branch":[120],"penalties":[121],"account":[123],"and":[124,128,139,146],"consider":[125],"both":[126],"single-kernel":[127],"multi-kernel":[129],"plans.":[130],"Our":[131],"evaluation":[132],"suggests":[133],"divergence":[135],"affects":[136],"significantly":[138],"techniques":[142],"reduce":[143],"resource":[144],"underutilization":[145],"improve":[147]},"counts_by_year":[{"year":2024,"cited_by_count":3},{"year":2023,"cited_by_count":1},{"year":2022,"cited_by_count":5},{"year":2021,"cited_by_count":2},{"year":2020,"cited_by_count":4},{"year":2019,"cited_by_count":2},{"year":2018,"cited_by_count":6},{"year":2017,"cited_by_count":3},{"year":2016,"cited_by_count":2},{"year":2015,"cited_by_count":5},{"year":2014,"cited_by_count":2}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}