{"id":"https://openalex.org/W2068418796","doi":"https://doi.org/10.1145/1620585.1620588","title":"Relational query coprocessing on graphics processors","display_name":"Relational query coprocessing on graphics processors","publication_year":2009,"publication_date":"2009-12-01","ids":{"openalex":"https://openalex.org/W2068418796","doi":"https://doi.org/10.1145/1620585.1620588","mag":"2068418796"},"language":"en","primary_location":{"id":"doi:10.1145/1620585.1620588","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1620585.1620588","pdf_url":null,"source":{"id":"https://openalex.org/S90119964","display_name":"ACM Transactions on Database Systems","issn_l":"0362-5915","issn":["0362-5915","1557-4644"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"ACM Transactions on Database Systems","raw_type":"journal-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/A5039946576","display_name":"Bingsheng He","orcid":"https://orcid.org/0000-0001-8618-4581"},"institutions":[{"id":"https://openalex.org/I4210113369","display_name":"Microsoft Research Asia (China)","ror":"https://ror.org/0300m5276","country_code":"CN","type":"company","lineage":["https://openalex.org/I1290206253","https://openalex.org/I4210113369"]}],"countries":["CN"],"is_corresponding":true,"raw_author_name":"Bingsheng He","raw_affiliation_strings":["Microsoft Research Asia","Microsoft Research Asia,"],"affiliations":[{"raw_affiliation_string":"Microsoft Research Asia","institution_ids":["https://openalex.org/I4210113369"]},{"raw_affiliation_string":"Microsoft Research Asia,","institution_ids":["https://openalex.org/I4210113369"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5103114808","display_name":"Mian Lu","orcid":"https://orcid.org/0009-0002-4853-8881"},"institutions":[{"id":"https://openalex.org/I200769079","display_name":"Hong Kong University of Science and Technology","ror":"https://ror.org/00q4vv597","country_code":"HK","type":"education","lineage":["https://openalex.org/I200769079"]}],"countries":["HK"],"is_corresponding":false,"raw_author_name":"Mian Lu","raw_affiliation_strings":["Hong Kong University of Science and Technology"],"affiliations":[{"raw_affiliation_string":"Hong Kong University of Science and Technology","institution_ids":["https://openalex.org/I200769079"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5031932067","display_name":"Ke Yang","orcid":"https://orcid.org/0000-0002-6441-2309"},"institutions":[{"id":"https://openalex.org/I1290206253","display_name":"Microsoft (United States)","ror":"https://ror.org/00d0nc645","country_code":"US","type":"company","lineage":["https://openalex.org/I1290206253"]},{"id":"https://openalex.org/I4210105678","display_name":"Microsoft (Finland)","ror":"https://ror.org/01nehjf29","country_code":"FI","type":"company","lineage":["https://openalex.org/I1290206253","https://openalex.org/I4210105678"]}],"countries":["FI","US"],"is_corresponding":false,"raw_author_name":"Ke Yang","raw_affiliation_strings":["Microsoft Corporation","MICROSOFT CORP"],"affiliations":[{"raw_affiliation_string":"Microsoft Corporation","institution_ids":["https://openalex.org/I4210105678"]},{"raw_affiliation_string":"MICROSOFT CORP","institution_ids":["https://openalex.org/I1290206253"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5022399844","display_name":"Rui Fang","orcid":"https://orcid.org/0000-0001-6075-9201"},"institutions":[{"id":"https://openalex.org/I139787848","display_name":"Capital University","ror":"https://ror.org/00jy9e726","country_code":"US","type":"education","lineage":["https://openalex.org/I139787848"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Rui Fang","raw_affiliation_strings":["Highbridge Capital Management LLC, USA"],"affiliations":[{"raw_affiliation_string":"Highbridge Capital Management LLC, USA","institution_ids":["https://openalex.org/I139787848"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5049041008","display_name":"Naga K. Govindaraju","orcid":null},"institutions":[{"id":"https://openalex.org/I1290206253","display_name":"Microsoft (United States)","ror":"https://ror.org/00d0nc645","country_code":"US","type":"company","lineage":["https://openalex.org/I1290206253"]},{"id":"https://openalex.org/I4210105678","display_name":"Microsoft (Finland)","ror":"https://ror.org/01nehjf29","country_code":"FI","type":"company","lineage":["https://openalex.org/I1290206253","https://openalex.org/I4210105678"]}],"countries":["FI","US"],"is_corresponding":false,"raw_author_name":"Naga K. Govindaraju","raw_affiliation_strings":["Microsoft Corporation","MICROSOFT CORP"],"affiliations":[{"raw_affiliation_string":"Microsoft Corporation","institution_ids":["https://openalex.org/I4210105678"]},{"raw_affiliation_string":"MICROSOFT CORP","institution_ids":["https://openalex.org/I1290206253"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5034823616","display_name":"Qiong Luo","orcid":"https://orcid.org/0000-0002-2861-9492"},"institutions":[{"id":"https://openalex.org/I200769079","display_name":"Hong Kong University of Science and Technology","ror":"https://ror.org/00q4vv597","country_code":"HK","type":"education","lineage":["https://openalex.org/I200769079"]}],"countries":["HK"],"is_corresponding":false,"raw_author_name":"Qiong Luo","raw_affiliation_strings":["Hong Kong University of Science and Technology"],"affiliations":[{"raw_affiliation_string":"Hong Kong University of Science and Technology","institution_ids":["https://openalex.org/I200769079"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5066694652","display_name":"Pedro V. Sander","orcid":null},"institutions":[{"id":"https://openalex.org/I200769079","display_name":"Hong Kong University of Science and Technology","ror":"https://ror.org/00q4vv597","country_code":"HK","type":"education","lineage":["https://openalex.org/I200769079"]}],"countries":["HK"],"is_corresponding":false,"raw_author_name":"Pedro V. Sander","raw_affiliation_strings":["Hong Kong University of Science and Technology"],"affiliations":[{"raw_affiliation_string":"Hong Kong University of Science and Technology","institution_ids":["https://openalex.org/I200769079"]}]}],"institutions":[],"countries_distinct_count":4,"institutions_distinct_count":7,"corresponding_author_ids":["https://openalex.org/A5039946576"],"corresponding_institution_ids":["https://openalex.org/I4210113369"],"apc_list":null,"apc_paid":null,"fwci":17.2707,"has_fulltext":false,"cited_by_count":276,"citation_normalized_percentile":{"value":0.99668516,"is_in_top_1_percent":true,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":98,"max":100},"biblio":{"volume":"34","issue":"4","first_page":"1","last_page":"39"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9997000098228455,"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.9997000098228455,"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.9988999962806702,"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/T11269","display_name":"Algorithms and Data Compression","score":0.9915000200271606,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.9258898496627808},{"id":"https://openalex.org/keywords/parallel-computing","display_name":"Parallel computing","score":0.6596387624740601},{"id":"https://openalex.org/keywords/coprocessor","display_name":"Coprocessor","score":0.6443958282470703},{"id":"https://openalex.org/keywords/memory-bandwidth","display_name":"Memory bandwidth","score":0.6260572075843811},{"id":"https://openalex.org/keywords/graphics","display_name":"Graphics","score":0.5609637498855591},{"id":"https://openalex.org/keywords/massively-parallel","display_name":"Massively parallel","score":0.5083441138267517},{"id":"https://openalex.org/keywords/high-memory","display_name":"High memory","score":0.457049161195755},{"id":"https://openalex.org/keywords/data-parallelism","display_name":"Data parallelism","score":0.43486273288726807},{"id":"https://openalex.org/keywords/computation","display_name":"Computation","score":0.41696032881736755},{"id":"https://openalex.org/keywords/computer-architecture","display_name":"Computer architecture","score":0.34090399742126465},{"id":"https://openalex.org/keywords/parallelism","display_name":"Parallelism (grammar)","score":0.15561515092849731},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.11456748843193054}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.9258898496627808},{"id":"https://openalex.org/C173608175","wikidata":"https://www.wikidata.org/wiki/Q232661","display_name":"Parallel computing","level":1,"score":0.6596387624740601},{"id":"https://openalex.org/C86111242","wikidata":"https://www.wikidata.org/wiki/Q859595","display_name":"Coprocessor","level":2,"score":0.6443958282470703},{"id":"https://openalex.org/C188045654","wikidata":"https://www.wikidata.org/wiki/Q17148339","display_name":"Memory bandwidth","level":2,"score":0.6260572075843811},{"id":"https://openalex.org/C21442007","wikidata":"https://www.wikidata.org/wiki/Q1027879","display_name":"Graphics","level":2,"score":0.5609637498855591},{"id":"https://openalex.org/C190475519","wikidata":"https://www.wikidata.org/wiki/Q544384","display_name":"Massively parallel","level":2,"score":0.5083441138267517},{"id":"https://openalex.org/C2781357197","wikidata":"https://www.wikidata.org/wiki/Q5757597","display_name":"High memory","level":2,"score":0.457049161195755},{"id":"https://openalex.org/C61483411","wikidata":"https://www.wikidata.org/wiki/Q3124522","display_name":"Data parallelism","level":3,"score":0.43486273288726807},{"id":"https://openalex.org/C45374587","wikidata":"https://www.wikidata.org/wiki/Q12525525","display_name":"Computation","level":2,"score":0.41696032881736755},{"id":"https://openalex.org/C118524514","wikidata":"https://www.wikidata.org/wiki/Q173212","display_name":"Computer architecture","level":1,"score":0.34090399742126465},{"id":"https://openalex.org/C2781172179","wikidata":"https://www.wikidata.org/wiki/Q853109","display_name":"Parallelism (grammar)","level":2,"score":0.15561515092849731},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.11456748843193054},{"id":"https://openalex.org/C121684516","wikidata":"https://www.wikidata.org/wiki/Q7600677","display_name":"Computer graphics (images)","level":1,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.1145/1620585.1620588","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1620585.1620588","pdf_url":null,"source":{"id":"https://openalex.org/S90119964","display_name":"ACM Transactions on Database Systems","issn_l":"0362-5915","issn":["0362-5915","1557-4644"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"ACM Transactions on Database Systems","raw_type":"journal-article"},{"id":"pmh:oai:repository.hkust.edu.hk:1783.1-47947","is_oa":false,"landing_page_url":"http://repository.hkust.edu.hk/ir/Record/1783.1-47947","pdf_url":null,"source":{"id":"https://openalex.org/S4306401796","display_name":"Rare & Special e-Zone (The Hong Kong University of Science and Technology)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I200769079","host_organization_name":"Hong Kong University of Science and Technology","host_organization_lineage":["https://openalex.org/I200769079"],"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":"Article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[{"id":"https://openalex.org/G1985271031","display_name":null,"funder_award_id":"616808","funder_id":"https://openalex.org/F4320321592","funder_display_name":"Research Grants Council, University Grants Committee"}],"funders":[{"id":"https://openalex.org/F4320321592","display_name":"Research Grants Council, University Grants Committee","ror":"https://ror.org/00djwmt25"}],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":46,"referenced_works":["https://openalex.org/W50914958","https://openalex.org/W126446084","https://openalex.org/W1484040604","https://openalex.org/W1492783156","https://openalex.org/W1494822125","https://openalex.org/W1558805549","https://openalex.org/W1570477871","https://openalex.org/W1595783387","https://openalex.org/W1645807896","https://openalex.org/W1936410615","https://openalex.org/W1965387308","https://openalex.org/W1996466054","https://openalex.org/W1997020216","https://openalex.org/W2009036829","https://openalex.org/W2015823077","https://openalex.org/W2032309817","https://openalex.org/W2050277572","https://openalex.org/W2052050139","https://openalex.org/W2054075931","https://openalex.org/W2054468361","https://openalex.org/W2056014488","https://openalex.org/W2078528123","https://openalex.org/W2082701182","https://openalex.org/W2095875205","https://openalex.org/W2096668111","https://openalex.org/W2102967864","https://openalex.org/W2108157916","https://openalex.org/W2114640218","https://openalex.org/W2116702178","https://openalex.org/W2119547137","https://openalex.org/W2122817518","https://openalex.org/W2123686039","https://openalex.org/W2127766448","https://openalex.org/W2137077706","https://openalex.org/W2140453381","https://openalex.org/W2151826520","https://openalex.org/W2153329411","https://openalex.org/W2155651153","https://openalex.org/W2158237121","https://openalex.org/W2160204225","https://openalex.org/W2160829658","https://openalex.org/W2163229756","https://openalex.org/W2166441508","https://openalex.org/W2912031620","https://openalex.org/W4240697374","https://openalex.org/W4241513866"],"related_works":["https://openalex.org/W2378666660","https://openalex.org/W1997955449","https://openalex.org/W50122904","https://openalex.org/W127524933","https://openalex.org/W2950263839","https://openalex.org/W4294538768","https://openalex.org/W2167334577","https://openalex.org/W2997701623","https://openalex.org/W3022553707","https://openalex.org/W2068418796"],"abstract_inverted_index":{"Graphics":[0],"processors":[1],"(GPUs)":[2],"have":[3,18,114,258],"recently":[4],"emerged":[5],"as":[6,26,28,175,196,198,286,288],"powerful":[7],"coprocessors":[8],"for":[9,64,118,133],"general":[10,51],"purpose":[11,52],"computation.":[12],"Compared":[13],"with":[14,266],"commodity":[15],"CPUs,":[16],"GPUs":[17,33,88],"an":[19,148,253,267,272],"order":[20],"of":[21,58,80,93,147,160,169,203,329],"magnitude":[22],"higher":[23],"computation":[24,209,229],"power":[25],"well":[27,197,287],"memory":[29,38,108,201,211,216],"bandwidth.":[30],"Moreover,":[31,326],"new-generation":[32],"allow":[34,106],"writes":[35],"to":[36,96,99,129,183,213],"random":[37],"locations,":[39],"provide":[40],"efficient":[41],"interprocessor":[42],"communication":[43],"through":[44],"on-chip":[45],"local":[46],"memory,":[47],"and":[48,76,100,113,125,145,177,179,206,210,231,271,296,342],"support":[49,117],"a":[50,81,85,91,122,167,242,264],"parallel":[53,208],"programming":[54],"model.":[55],"Nevertheless,":[56],"many":[57],"the":[59,68,72,77,102,131,156,161,193,199,204,228,232,249,305,327,340,343],"GPU":[60,111,132,162,306],"features":[61],"are":[62,315],"specialized":[63],"graphics":[65],"processing,":[66],"including":[67],"massively":[69],"multithreaded":[70],"architecture,":[71],"Single-Instruction-Multiple-Data":[73],"processing":[74,188],"style,":[75],"execution":[78],"model":[79],"single":[82],"application":[83],"at":[84],"time.":[86],"Additionally,":[87],"rely":[89],"on":[90,155,263,283,300,323],"bus":[92],"limited":[94],"bandwidth":[95,202],"transfer":[97,235],"data":[98,234,285,294,301],"from":[101,110],"CPU,":[103,248],"do":[104],"not":[105],"dynamic":[107],"allocation":[109],"kernels,":[112],"little":[115],"hardware":[116,163],"write":[119],"conflicts.":[120],"Therefore,":[121],"careful":[123],"design":[124,166],"implementation":[126],"is":[127,333],"required":[128],"utilize":[130,192,245],"coprocessing":[134,152,221,331],"database":[135],"queries.":[136],"In":[137],"this":[138],"article,":[139],"we":[140,165,219],"present":[141],"our":[142,260,312,330],"design,":[143],"implementation,":[144],"evaluation":[146],"in-memory":[149,324],"relational":[150,186],"query":[151,187,243,298],"system,":[153],"GDB,":[154],"GPU.":[157,277],"Taking":[158],"advantage":[159],"features,":[164],"set":[168],"highly":[170],"optimized":[171,254,320],"data-parallel":[172],"primitives":[173,182],"such":[174],"split":[176],"sort,":[178],"use":[180,207],"these":[181],"implement":[184],"common":[185],"algorithms.":[189],"Our":[190,278,308],"algorithms":[191,314],"high":[194,200],"parallelism":[195],"GPU,":[205,250],"optimizations":[212],"effectively":[214],"reduce":[215],"stalls.":[217],"Furthermore,":[218],"propose":[220],"techniques":[222],"that":[223,238,291,311],"take":[224],"into":[225],"account":[226],"both":[227,339],"resources":[230],"GPU-CPU":[233],"cost":[236],"so":[237],"each":[239],"operator":[240],"in":[241],"can":[244],"suitable":[246],"processors\u2014the":[247],"or":[251,336],"both\u2014for":[252],"overall":[255],"performance.":[256],"We":[257],"evaluated":[259],"GDB":[261],"system":[262],"machine":[265],"Intel":[268],"quad-core":[269],"CPU":[270],"NVIDIA":[273],"GeForce":[274],"8800":[275],"GTX":[276],"workloads":[279],"include":[280],"microbenchmark":[281],"queries":[282,290],"memory-resident":[284],"TPC-H":[289],"involve":[292],"complex":[293],"types":[295],"multiple":[297],"operators":[299],"sets":[302],"larger":[303],"than":[304,318],"memory.":[307],"results":[309],"show":[310],"GPU-based":[313],"2--27x":[316],"faster":[317],"their":[319],"CPU-based":[321],"counterparts":[322],"data.":[325],"performance":[328],"scheme":[332],"similar":[334],"to,":[335],"better":[337],"than,":[338],"GPU-only":[341],"CPU-only":[344],"schemes.":[345]},"counts_by_year":[{"year":2025,"cited_by_count":10},{"year":2024,"cited_by_count":10},{"year":2023,"cited_by_count":9},{"year":2022,"cited_by_count":10},{"year":2021,"cited_by_count":17},{"year":2020,"cited_by_count":6},{"year":2019,"cited_by_count":14},{"year":2018,"cited_by_count":21},{"year":2017,"cited_by_count":14},{"year":2016,"cited_by_count":25},{"year":2015,"cited_by_count":28},{"year":2014,"cited_by_count":29},{"year":2013,"cited_by_count":34},{"year":2012,"cited_by_count":32}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}