{"id":"https://openalex.org/W2507304688","doi":"https://doi.org/10.1145/3035918.3035957","title":"Revisiting Reuse in Main Memory Database Systems","display_name":"Revisiting Reuse in Main Memory Database Systems","publication_year":2017,"publication_date":"2017-05-09","ids":{"openalex":"https://openalex.org/W2507304688","doi":"https://doi.org/10.1145/3035918.3035957","mag":"2507304688"},"language":"en","primary_location":{"id":"doi:10.1145/3035918.3035957","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3035918.3035957","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2017 ACM International Conference on Management of Data","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/A5044304184","display_name":"Kayhan Dursun","orcid":null},"institutions":[{"id":"https://openalex.org/I27804330","display_name":"Brown University","ror":"https://ror.org/05gq02987","country_code":"US","type":"education","lineage":["https://openalex.org/I27804330"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"Kayhan Dursun","raw_affiliation_strings":["Brown University, Providence, RI, USA"],"affiliations":[{"raw_affiliation_string":"Brown University, Providence, RI, USA","institution_ids":["https://openalex.org/I27804330"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5073504200","display_name":"Carsten Binnig","orcid":"https://orcid.org/0000-0002-2744-7836"},"institutions":[{"id":"https://openalex.org/I27804330","display_name":"Brown University","ror":"https://ror.org/05gq02987","country_code":"US","type":"education","lineage":["https://openalex.org/I27804330"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Carsten Binnig","raw_affiliation_strings":["Brown University, Providence, RI, USA"],"affiliations":[{"raw_affiliation_string":"Brown University, Providence, RI, USA","institution_ids":["https://openalex.org/I27804330"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5109862110","display_name":"U\u011fur \u00c7etintemel","orcid":null},"institutions":[{"id":"https://openalex.org/I27804330","display_name":"Brown University","ror":"https://ror.org/05gq02987","country_code":"US","type":"education","lineage":["https://openalex.org/I27804330"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Ugur Cetintemel","raw_affiliation_strings":["Brown University, Providence, RI, USA"],"affiliations":[{"raw_affiliation_string":"Brown University, Providence, RI, USA","institution_ids":["https://openalex.org/I27804330"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5034086130","display_name":"Tim Kraska","orcid":"https://orcid.org/0009-0003-2414-2759"},"institutions":[{"id":"https://openalex.org/I27804330","display_name":"Brown University","ror":"https://ror.org/05gq02987","country_code":"US","type":"education","lineage":["https://openalex.org/I27804330"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"TIm Kraska","raw_affiliation_strings":["Brown University, Providence, RI, USA"],"affiliations":[{"raw_affiliation_string":"Brown University, Providence, RI, USA","institution_ids":["https://openalex.org/I27804330"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":4,"corresponding_author_ids":["https://openalex.org/A5044304184"],"corresponding_institution_ids":["https://openalex.org/I27804330"],"apc_list":null,"apc_paid":null,"fwci":3.108,"has_fulltext":false,"cited_by_count":24,"citation_normalized_percentile":{"value":0.92514054,"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":"1275","last_page":"1289"},"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.9995999932289124,"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.9995999932289124,"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/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/T10101","display_name":"Cloud Computing and Resource Management","score":0.9990000128746033,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"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.879170298576355},{"id":"https://openalex.org/keywords/cache","display_name":"Cache","score":0.6270854473114014},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.6016589403152466},{"id":"https://openalex.org/keywords/materialized-view","display_name":"Materialized view","score":0.5756990909576416},{"id":"https://openalex.org/keywords/reuse","display_name":"Reuse","score":0.5649220943450928},{"id":"https://openalex.org/keywords/overhead","display_name":"Overhead (engineering)","score":0.5627423524856567},{"id":"https://openalex.org/keywords/query-optimization","display_name":"Query optimization","score":0.49422696232795715},{"id":"https://openalex.org/keywords/hash-function","display_name":"Hash function","score":0.47620925307273865},{"id":"https://openalex.org/keywords/memory-hierarchy","display_name":"Memory hierarchy","score":0.47318363189697266},{"id":"https://openalex.org/keywords/table","display_name":"Table (database)","score":0.45038747787475586},{"id":"https://openalex.org/keywords/hash-table","display_name":"Hash table","score":0.44789159297943115},{"id":"https://openalex.org/keywords/query-plan","display_name":"Query plan","score":0.43878284096717834},{"id":"https://openalex.org/keywords/cpu-cache","display_name":"CPU cache","score":0.42918169498443604},{"id":"https://openalex.org/keywords/parallel-computing","display_name":"Parallel computing","score":0.33941739797592163},{"id":"https://openalex.org/keywords/view","display_name":"View","score":0.3272199034690857},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.27016907930374146},{"id":"https://openalex.org/keywords/sargable","display_name":"Sargable","score":0.23724910616874695},{"id":"https://openalex.org/keywords/web-search-query","display_name":"Web search query","score":0.15870967507362366},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.14775067567825317},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.1432577669620514},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.14273151755332947}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.879170298576355},{"id":"https://openalex.org/C115537543","wikidata":"https://www.wikidata.org/wiki/Q165596","display_name":"Cache","level":2,"score":0.6270854473114014},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.6016589403152466},{"id":"https://openalex.org/C98199447","wikidata":"https://www.wikidata.org/wiki/Q2445044","display_name":"Materialized view","level":4,"score":0.5756990909576416},{"id":"https://openalex.org/C206588197","wikidata":"https://www.wikidata.org/wiki/Q846574","display_name":"Reuse","level":2,"score":0.5649220943450928},{"id":"https://openalex.org/C2779960059","wikidata":"https://www.wikidata.org/wiki/Q7113681","display_name":"Overhead (engineering)","level":2,"score":0.5627423524856567},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.49422696232795715},{"id":"https://openalex.org/C99138194","wikidata":"https://www.wikidata.org/wiki/Q183427","display_name":"Hash function","level":2,"score":0.47620925307273865},{"id":"https://openalex.org/C2778100165","wikidata":"https://www.wikidata.org/wiki/Q1589327","display_name":"Memory hierarchy","level":3,"score":0.47318363189697266},{"id":"https://openalex.org/C45235069","wikidata":"https://www.wikidata.org/wiki/Q278425","display_name":"Table (database)","level":2,"score":0.45038747787475586},{"id":"https://openalex.org/C67388219","wikidata":"https://www.wikidata.org/wiki/Q207440","display_name":"Hash table","level":3,"score":0.44789159297943115},{"id":"https://openalex.org/C2779729312","wikidata":"https://www.wikidata.org/wiki/Q784232","display_name":"Query plan","level":5,"score":0.43878284096717834},{"id":"https://openalex.org/C189783530","wikidata":"https://www.wikidata.org/wiki/Q352090","display_name":"CPU cache","level":3,"score":0.42918169498443604},{"id":"https://openalex.org/C173608175","wikidata":"https://www.wikidata.org/wiki/Q232661","display_name":"Parallel computing","level":1,"score":0.33941739797592163},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.3272199034690857},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.27016907930374146},{"id":"https://openalex.org/C192939062","wikidata":"https://www.wikidata.org/wiki/Q104840822","display_name":"Sargable","level":4,"score":0.23724910616874695},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.15870967507362366},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.14775067567825317},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.1432577669620514},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.14273151755332947},{"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/C18903297","wikidata":"https://www.wikidata.org/wiki/Q7150","display_name":"Ecology","level":1,"score":0.0},{"id":"https://openalex.org/C86803240","wikidata":"https://www.wikidata.org/wiki/Q420","display_name":"Biology","level":0,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/3035918.3035957","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3035918.3035957","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2017 ACM International Conference on Management of Data","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[{"id":"https://metadata.un.org/sdg/16","score":0.49000000953674316,"display_name":"Peace, Justice and strong institutions"}],"awards":[{"id":"https://openalex.org/G2683461770","display_name":null,"funder_award_id":"1514491","funder_id":"https://openalex.org/F4320306076","funder_display_name":"National Science Foundation"},{"id":"https://openalex.org/G2817159641","display_name":null,"funder_award_id":"1526639","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":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":33,"referenced_works":["https://openalex.org/W1185726409","https://openalex.org/W1510316320","https://openalex.org/W1563590781","https://openalex.org/W1835416193","https://openalex.org/W1960895309","https://openalex.org/W1963445704","https://openalex.org/W1971885140","https://openalex.org/W1983428358","https://openalex.org/W1992977903","https://openalex.org/W2006552857","https://openalex.org/W2026984353","https://openalex.org/W2041414515","https://openalex.org/W2058978608","https://openalex.org/W2059922215","https://openalex.org/W2075018787","https://openalex.org/W2089347259","https://openalex.org/W2100099053","https://openalex.org/W2102729946","https://openalex.org/W2103216163","https://openalex.org/W2106771621","https://openalex.org/W2108490710","https://openalex.org/W2112312025","https://openalex.org/W2117538598","https://openalex.org/W2141558360","https://openalex.org/W2150606131","https://openalex.org/W2171492933","https://openalex.org/W2247645225","https://openalex.org/W2296601204","https://openalex.org/W2396309311","https://openalex.org/W2399653841","https://openalex.org/W2401974969","https://openalex.org/W2518548975","https://openalex.org/W3105820654"],"related_works":["https://openalex.org/W16924853","https://openalex.org/W1021093982","https://openalex.org/W2382405670","https://openalex.org/W1582942928","https://openalex.org/W1490264602","https://openalex.org/W2039555859","https://openalex.org/W3193790833","https://openalex.org/W2955180461","https://openalex.org/W1487803663","https://openalex.org/W2549774162"],"abstract_inverted_index":{"Reusing":[0],"intermediates":[1],"in":[2,11,53,104],"databases":[3,107],"to":[4,22,78,108],"speed-up":[5],"analytical":[6,164],"query":[7,35,75],"processing":[8,76],"was":[9],"studied":[10],"prior":[12],"work.":[13],"Existing":[14],"solutions":[15],"require":[16],"intermediate":[17],"results":[18],"of":[19,160],"individual":[20],"operators":[21],"be":[23],"materialized":[24,73],"using":[25],"materialization":[26,31],"operators.":[27],"However,":[28],"inserting":[29],"such":[30],"operations":[32],"into":[33,133],"a":[34,61],"plan":[36],"not":[37],"only":[38],"incurs":[39],"additional":[40,168],"execution":[41],"costs":[42,145],"but":[43],"also":[44],"often":[45],"eliminates":[46],"important":[47],"cache-":[48],"and":[49,81,111,142],"register-locality":[50],"opportunities,":[51],"resulting":[52],"even":[54],"higher":[55],"performance":[56,158],"penalties.":[57],"This":[58],"paper":[59],"studies":[60],"novel":[62],"reuse":[63,123],"model":[64],"for":[65,89,125,162,170],"intermediates,":[66],"which":[67],"caches":[68],"internal":[69,101],"physical":[70],"data":[71,102,143],"structures":[72],"during":[74],"(due":[77],"pipeline":[79],"breakers)":[80],"externalizes":[82],"them":[83],"so":[84],"that":[85,131],"they":[86],"become":[87],"reusable":[88],"upcoming":[90],"operations.":[91,113],"We":[92],"focus":[93],"on":[94,153],"hash":[95,126,135],"tables,":[96,127],"the":[97,122,140,147],"most":[98],"commonly":[99],"used":[100],"structure":[103],"main":[105],"memory":[106],"perform":[109],"join":[110],"aggregation":[112],"As":[114],"queries":[115],"arrive,":[116],"our":[117,154],"reuse-aware":[118],"optimizer":[119],"reasons":[120],"about":[121],"opportunities":[124],"employing":[128],"cost":[129],"models":[130],"take":[132],"account":[134],"table":[136],"statistics":[137],"together":[138],"with":[139,166],"CPU":[141],"movement":[144],"within":[146],"cache":[148],"hierarchy.":[149],"Experimental":[150],"results,":[151],"based":[152],"prototype":[155],"implementation,":[156],"demonstrate":[157],"gains":[159],"2x":[161],"typical":[163],"workloads":[165],"no":[167],"overhead":[169],"materializing":[171],"intermediates.":[172]},"counts_by_year":[{"year":2025,"cited_by_count":1},{"year":2024,"cited_by_count":2},{"year":2023,"cited_by_count":3},{"year":2022,"cited_by_count":1},{"year":2021,"cited_by_count":2},{"year":2020,"cited_by_count":3},{"year":2019,"cited_by_count":3},{"year":2018,"cited_by_count":7},{"year":2017,"cited_by_count":2}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}