{"id":"https://openalex.org/W1987238352","doi":"https://doi.org/10.1145/1409360.1409380","title":"Breaking the memory wall in MonetDB","display_name":"Breaking the memory wall in MonetDB","publication_year":2008,"publication_date":"2008-12-01","ids":{"openalex":"https://openalex.org/W1987238352","doi":"https://doi.org/10.1145/1409360.1409380","mag":"1987238352"},"language":"en","primary_location":{"id":"doi:10.1145/1409360.1409380","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1409360.1409380","pdf_url":null,"source":{"id":"https://openalex.org/S103482838","display_name":"Communications of the ACM","issn_l":"0001-0782","issn":["0001-0782","1557-7317"],"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":"Communications of the ACM","raw_type":"journal-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"https://ir.cwi.nl/pub/13805","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5058712681","display_name":"Peter Boncz","orcid":"https://orcid.org/0000-0001-6256-0140"},"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"]}],"countries":["NL"],"is_corresponding":true,"raw_author_name":"Peter A. Boncz","raw_affiliation_strings":["CWI, Kruislaan, Amsterdam, the Netherlands"],"affiliations":[{"raw_affiliation_string":"CWI, Kruislaan, Amsterdam, the Netherlands","institution_ids":["https://openalex.org/I1341640284"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5108572275","display_name":"Martin Kersten","orcid":null},"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"]}],"countries":["NL"],"is_corresponding":false,"raw_author_name":"Martin L. Kersten","raw_affiliation_strings":["CWI, Kruislaan, Amsterdam, the Netherlands"],"affiliations":[{"raw_affiliation_string":"CWI, Kruislaan, Amsterdam, the Netherlands","institution_ids":["https://openalex.org/I1341640284"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5030666511","display_name":"Stefan Manegold","orcid":"https://orcid.org/0000-0001-7938-4358"},"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"]}],"countries":["NL"],"is_corresponding":false,"raw_author_name":"Stefan Manegold","raw_affiliation_strings":["CWI, Kruislaan, Amsterdam, the Netherlands"],"affiliations":[{"raw_affiliation_string":"CWI, Kruislaan, Amsterdam, the Netherlands","institution_ids":["https://openalex.org/I1341640284"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":3,"corresponding_author_ids":["https://openalex.org/A5058712681"],"corresponding_institution_ids":["https://openalex.org/I1341640284"],"apc_list":null,"apc_paid":null,"fwci":11.7732,"has_fulltext":false,"cited_by_count":248,"citation_normalized_percentile":{"value":0.98846605,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":96,"max":100},"biblio":{"volume":"51","issue":"12","first_page":"77","last_page":"85"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9998999834060669,"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.9998999834060669,"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.9994999766349792,"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.9950000047683716,"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/computer-science","display_name":"Computer science","score":0.8758887052536011},{"id":"https://openalex.org/keywords/exploit","display_name":"Exploit","score":0.7101385593414307},{"id":"https://openalex.org/keywords/bottleneck","display_name":"Bottleneck","score":0.616602897644043},{"id":"https://openalex.org/keywords/cache","display_name":"Cache","score":0.583422839641571},{"id":"https://openalex.org/keywords/parallel-computing","display_name":"Parallel computing","score":0.5585089921951294},{"id":"https://openalex.org/keywords/cas-latency","display_name":"CAS latency","score":0.5174508690834045},{"id":"https://openalex.org/keywords/cache-only-memory-architecture","display_name":"Cache-only memory architecture","score":0.5134338140487671},{"id":"https://openalex.org/keywords/central-processing-unit","display_name":"Central processing unit","score":0.5121676921844482},{"id":"https://openalex.org/keywords/latency","display_name":"Latency (audio)","score":0.44504308700561523},{"id":"https://openalex.org/keywords/memory-map","display_name":"Memory map","score":0.4357423186302185},{"id":"https://openalex.org/keywords/cpu-cache","display_name":"CPU cache","score":0.3898221254348755},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.3837849795818329},{"id":"https://openalex.org/keywords/computer-architecture","display_name":"Computer architecture","score":0.3577791750431061},{"id":"https://openalex.org/keywords/embedded-system","display_name":"Embedded system","score":0.3025106191635132},{"id":"https://openalex.org/keywords/shared-memory","display_name":"Shared memory","score":0.27206724882125854},{"id":"https://openalex.org/keywords/cache-coloring","display_name":"Cache coloring","score":0.2069735825061798},{"id":"https://openalex.org/keywords/semiconductor-memory","display_name":"Semiconductor memory","score":0.1377442181110382},{"id":"https://openalex.org/keywords/memory-controller","display_name":"Memory controller","score":0.11432662606239319}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8758887052536011},{"id":"https://openalex.org/C165696696","wikidata":"https://www.wikidata.org/wiki/Q11287","display_name":"Exploit","level":2,"score":0.7101385593414307},{"id":"https://openalex.org/C2780513914","wikidata":"https://www.wikidata.org/wiki/Q18210350","display_name":"Bottleneck","level":2,"score":0.616602897644043},{"id":"https://openalex.org/C115537543","wikidata":"https://www.wikidata.org/wiki/Q165596","display_name":"Cache","level":2,"score":0.583422839641571},{"id":"https://openalex.org/C173608175","wikidata":"https://www.wikidata.org/wiki/Q232661","display_name":"Parallel computing","level":1,"score":0.5585089921951294},{"id":"https://openalex.org/C189930140","wikidata":"https://www.wikidata.org/wiki/Q1112878","display_name":"CAS latency","level":4,"score":0.5174508690834045},{"id":"https://openalex.org/C3720319","wikidata":"https://www.wikidata.org/wiki/Q5015937","display_name":"Cache-only memory architecture","level":5,"score":0.5134338140487671},{"id":"https://openalex.org/C49154492","wikidata":"https://www.wikidata.org/wiki/Q5300","display_name":"Central processing unit","level":2,"score":0.5121676921844482},{"id":"https://openalex.org/C82876162","wikidata":"https://www.wikidata.org/wiki/Q17096504","display_name":"Latency (audio)","level":2,"score":0.44504308700561523},{"id":"https://openalex.org/C74426580","wikidata":"https://www.wikidata.org/wiki/Q719484","display_name":"Memory map","level":3,"score":0.4357423186302185},{"id":"https://openalex.org/C189783530","wikidata":"https://www.wikidata.org/wiki/Q352090","display_name":"CPU cache","level":3,"score":0.3898221254348755},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.3837849795818329},{"id":"https://openalex.org/C118524514","wikidata":"https://www.wikidata.org/wiki/Q173212","display_name":"Computer architecture","level":1,"score":0.3577791750431061},{"id":"https://openalex.org/C149635348","wikidata":"https://www.wikidata.org/wiki/Q193040","display_name":"Embedded system","level":1,"score":0.3025106191635132},{"id":"https://openalex.org/C133875982","wikidata":"https://www.wikidata.org/wiki/Q764810","display_name":"Shared memory","level":2,"score":0.27206724882125854},{"id":"https://openalex.org/C201148951","wikidata":"https://www.wikidata.org/wiki/Q5015976","display_name":"Cache coloring","level":4,"score":0.2069735825061798},{"id":"https://openalex.org/C98986596","wikidata":"https://www.wikidata.org/wiki/Q1143031","display_name":"Semiconductor memory","level":2,"score":0.1377442181110382},{"id":"https://openalex.org/C100800780","wikidata":"https://www.wikidata.org/wiki/Q1175867","display_name":"Memory controller","level":3,"score":0.11432662606239319},{"id":"https://openalex.org/C76155785","wikidata":"https://www.wikidata.org/wiki/Q418","display_name":"Telecommunications","level":1,"score":0.0},{"id":"https://openalex.org/C38652104","wikidata":"https://www.wikidata.org/wiki/Q3510521","display_name":"Computer security","level":1,"score":0.0}],"mesh":[],"locations_count":4,"locations":[{"id":"doi:10.1145/1409360.1409380","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1409360.1409380","pdf_url":null,"source":{"id":"https://openalex.org/S103482838","display_name":"Communications of the ACM","issn_l":"0001-0782","issn":["0001-0782","1557-7317"],"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":"Communications of the ACM","raw_type":"journal-article"},{"id":"pmh:oai:dare.uva.nl:openaire_cris_publications/67c03b3e-2afe-498c-b4e6-fbc6694a5c78","is_oa":false,"landing_page_url":"https://handle.uba.uva.nl/personal/pure/en/publications/breaking-the-memory-wall-in-monetdb(67c03b3e-2afe-498c-b4e6-fbc6694a5c78).html","pdf_url":null,"source":{"id":"https://openalex.org/S4306400088","display_name":"UvA-DARE (University of Amsterdam)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I887064364","host_organization_name":"University of Amsterdam","host_organization_lineage":["https://openalex.org/I887064364"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Boncz, P A, Kersten, M L & Manegold, S 2008, 'Breaking the memory wall in MonetDB', Communications of the ACM, vol. 51, no. 12, pp. 77-85. < http://doi.acm.org/10.1145/1409360.1409380 >","raw_type":"info:eu-repo/semantics/publishedVersion"},{"id":"pmh:cwi:oai:cwi.nl:13805","is_oa":true,"landing_page_url":"https://ir.cwi.nl/pub/13805","pdf_url":null,"source":{"id":"https://openalex.org/S4306401843","display_name":"Data Archiving and Networked Services (DANS)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I1322597698","host_organization_name":"Royal Netherlands Academy of Arts and Sciences","host_organization_lineage":["https://openalex.org/I1322597698"],"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":"Communications of the ACM, 51(12), 77 - 85","raw_type":"info:eu-repo/semantics/article"},{"id":"pmh:uvapub:oai:dare.uva.nl:publications/67c03b3e-2afe-498c-b4e6-fbc6694a5c78","is_oa":false,"landing_page_url":"https://dare.uva.nl/personal/pure/en/publications/breaking-the-memory-wall-in-monetdb(67c03b3e-2afe-498c-b4e6-fbc6694a5c78).html","pdf_url":null,"source":{"id":"https://openalex.org/S4306401843","display_name":"Data Archiving and Networked Services (DANS)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I1322597698","host_organization_name":"Royal Netherlands Academy of Arts and Sciences","host_organization_lineage":["https://openalex.org/I1322597698"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"Communications of the ACM, 51(12), 77 - 85. Association for Computing Machinery (ACM)","raw_type":"info:eu-repo/semantics/article"}],"best_oa_location":{"id":"pmh:cwi:oai:cwi.nl:13805","is_oa":true,"landing_page_url":"https://ir.cwi.nl/pub/13805","pdf_url":null,"source":{"id":"https://openalex.org/S4306401843","display_name":"Data Archiving and Networked Services (DANS)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I1322597698","host_organization_name":"Royal Netherlands Academy of Arts and Sciences","host_organization_lineage":["https://openalex.org/I1322597698"],"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":"Communications of the ACM, 51(12), 77 - 85","raw_type":"info:eu-repo/semantics/article"},"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":23,"referenced_works":["https://openalex.org/W1569974523","https://openalex.org/W1570477871","https://openalex.org/W1645807896","https://openalex.org/W1796870311","https://openalex.org/W1999563089","https://openalex.org/W2025826925","https://openalex.org/W2099580433","https://openalex.org/W2105220449","https://openalex.org/W2111255560","https://openalex.org/W2113045536","https://openalex.org/W2122048769","https://openalex.org/W2124851765","https://openalex.org/W2127766448","https://openalex.org/W2147076738","https://openalex.org/W2147285994","https://openalex.org/W2155651153","https://openalex.org/W2157979971","https://openalex.org/W2160404300","https://openalex.org/W2518548975","https://openalex.org/W2580215662","https://openalex.org/W2914512445","https://openalex.org/W3138135046","https://openalex.org/W4205806386"],"related_works":["https://openalex.org/W254684032","https://openalex.org/W2781952239","https://openalex.org/W2606565524","https://openalex.org/W63770251","https://openalex.org/W1848192231","https://openalex.org/W3021597805","https://openalex.org/W4317815260","https://openalex.org/W4247553987","https://openalex.org/W4233816696","https://openalex.org/W2380172837"],"abstract_inverted_index":{"In":[0,39],"the":[1,36,47,73,82,97,113,123,140],"past":[2],"decades,":[3],"advances":[4,13],"in":[5,14,59,68,139],"speed":[6],"of":[7,56,64,81,99,115,128],"commodity":[8],"CPUs":[9],"have":[10],"far":[11],"outpaced":[12],"RAM":[15],"latency.":[16],"Main-memory":[17],"access":[18],"has":[19,51],"therefore":[20],"become":[21],"a":[22,29,54,79],"performance":[23],"bottleneck":[24],"for":[25],"many":[26],"computer":[27],"applications;":[28],"phenomenon":[30],"that":[31],"is":[32],"widely":[33],"known":[34],"as":[35],"\"memory":[37],"wall.\"":[38],"this":[40],"paper,":[41],"we":[42],"report":[43],"how":[44],"research":[45],"around":[46],"MonetDB":[48],"database":[49,57],"system":[50],"led":[52],"to":[53,61,70,86,106,132],"redesign":[55,80],"architecture":[58],"order":[60],"take":[62],"advantage":[63],"modern":[65],"hardware,":[66],"and":[67,92,121,125,134],"particular":[69],"avoid":[71],"hitting":[72],"memory":[74,129],"wall.":[75],"This":[76],"encompasses":[77],"(i)":[78],"query":[83,118,141],"execution":[84],"model":[85],"better":[87,107],"exploit":[88,108],"pipelined":[89],"CPU":[90,93,109],"architectures":[91],"instruction":[94],"caches;":[95,111],"(ii)":[96],"use":[98],"columnar":[100],"rather":[101],"than":[102],"row-wise":[103],"data":[104,110],"storage":[105],"(iii)":[112],"design":[114,124],"new":[116],"cache-conscious":[117,137],"processing":[119],"algorithms;":[120],"(iv)":[122],"automatic":[126],"calibration":[127],"cost":[130],"models":[131],"choose":[133],"tune":[135],"these":[136],"algorithms":[138],"optimizer.":[142]},"counts_by_year":[{"year":2026,"cited_by_count":1},{"year":2025,"cited_by_count":6},{"year":2024,"cited_by_count":10},{"year":2023,"cited_by_count":10},{"year":2022,"cited_by_count":8},{"year":2021,"cited_by_count":18},{"year":2020,"cited_by_count":13},{"year":2019,"cited_by_count":12},{"year":2018,"cited_by_count":45},{"year":2017,"cited_by_count":15},{"year":2016,"cited_by_count":14},{"year":2015,"cited_by_count":12},{"year":2014,"cited_by_count":14},{"year":2013,"cited_by_count":26},{"year":2012,"cited_by_count":13}],"updated_date":"2026-04-04T16:13:02.066488","created_date":"2025-10-10T00:00:00"}