{"id":"https://openalex.org/W1992977903","doi":"https://doi.org/10.1145/1559845.1559879","title":"An architecture for recycling intermediates in a column-store","display_name":"An architecture for recycling intermediates in a column-store","publication_year":2009,"publication_date":"2009-06-29","ids":{"openalex":"https://openalex.org/W1992977903","doi":"https://doi.org/10.1145/1559845.1559879","mag":"1992977903"},"language":"en","primary_location":{"id":"doi:10.1145/1559845.1559879","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1559845.1559879","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2009 ACM SIGMOD International Conference on Management of data","raw_type":"proceedings-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"https://ir.cwi.nl/pub/14287/14287A.pdf","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5110159346","display_name":"Milena G. Ivanova","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":true,"raw_author_name":"Milena G. Ivanova","raw_affiliation_strings":["Centrum Wiskunde en Informatica, Amsterdam, Netherlands"],"affiliations":[{"raw_affiliation_string":"Centrum Wiskunde en Informatica, Amsterdam, 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":["Centrum Wiskunde en Informatica, Amsterdam, Netherlands"],"affiliations":[{"raw_affiliation_string":"Centrum Wiskunde en Informatica, Amsterdam, Netherlands","institution_ids":["https://openalex.org/I1341640284"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5041092741","display_name":"Niels Nes","orcid":"https://orcid.org/0009-0000-5927-2551"},"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":"Niels J. Nes","raw_affiliation_strings":["Centrum Wiskunde en Informatica, Amsterdam, Netherlands"],"affiliations":[{"raw_affiliation_string":"Centrum Wiskunde en Informatica, Amsterdam, Netherlands","institution_ids":["https://openalex.org/I1341640284"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5103276504","display_name":"Romulo Gon\u00e7alves","orcid":"https://orcid.org/0000-0003-2225-1428"},"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":"Romulo A.P. Gon\u00e7alves","raw_affiliation_strings":["Centrum Wiskunde en Informatica, Amsterdam, Netherlands"],"affiliations":[{"raw_affiliation_string":"Centrum Wiskunde en Informatica, Amsterdam, Netherlands","institution_ids":["https://openalex.org/I1341640284"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":4,"corresponding_author_ids":["https://openalex.org/A5110159346"],"corresponding_institution_ids":["https://openalex.org/I1341640284"],"apc_list":null,"apc_paid":null,"fwci":9.7888,"has_fulltext":true,"cited_by_count":75,"citation_normalized_percentile":{"value":0.98224828,"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":"309","last_page":"320"},"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.9998000264167786,"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.9998000264167786,"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.9986000061035156,"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"}},{"id":"https://openalex.org/T10772","display_name":"Distributed systems and fault tolerance","score":0.9980000257492065,"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/tuple","display_name":"Tuple","score":0.8949955701828003},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8517181873321533},{"id":"https://openalex.org/keywords/pipeline","display_name":"Pipeline (software)","score":0.7836825847625732},{"id":"https://openalex.org/keywords/cache","display_name":"Cache","score":0.7576339840888977},{"id":"https://openalex.org/keywords/reuse","display_name":"Reuse","score":0.6537730693817139},{"id":"https://openalex.org/keywords/tuple-space","display_name":"Tuple space","score":0.6132752299308777},{"id":"https://openalex.org/keywords/throughput","display_name":"Throughput","score":0.5823541879653931},{"id":"https://openalex.org/keywords/materialized-view","display_name":"Materialized view","score":0.5720072984695435},{"id":"https://openalex.org/keywords/parallel-computing","display_name":"Parallel computing","score":0.5592343211174011},{"id":"https://openalex.org/keywords/column","display_name":"Column (typography)","score":0.5323712229728699},{"id":"https://openalex.org/keywords/architecture","display_name":"Architecture","score":0.465749591588974},{"id":"https://openalex.org/keywords/state","display_name":"State (computer science)","score":0.45928075909614563},{"id":"https://openalex.org/keywords/function","display_name":"Function (biology)","score":0.44832414388656616},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.3727535605430603},{"id":"https://openalex.org/keywords/computer-architecture","display_name":"Computer architecture","score":0.33003413677215576},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.28256261348724365},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.21396282315254211},{"id":"https://openalex.org/keywords/view","display_name":"View","score":0.09753191471099854},{"id":"https://openalex.org/keywords/computer-network","display_name":"Computer network","score":0.07854372262954712}],"concepts":[{"id":"https://openalex.org/C118930307","wikidata":"https://www.wikidata.org/wiki/Q600590","display_name":"Tuple","level":2,"score":0.8949955701828003},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8517181873321533},{"id":"https://openalex.org/C43521106","wikidata":"https://www.wikidata.org/wiki/Q2165493","display_name":"Pipeline (software)","level":2,"score":0.7836825847625732},{"id":"https://openalex.org/C115537543","wikidata":"https://www.wikidata.org/wiki/Q165596","display_name":"Cache","level":2,"score":0.7576339840888977},{"id":"https://openalex.org/C206588197","wikidata":"https://www.wikidata.org/wiki/Q846574","display_name":"Reuse","level":2,"score":0.6537730693817139},{"id":"https://openalex.org/C56800130","wikidata":"https://www.wikidata.org/wiki/Q1684164","display_name":"Tuple space","level":3,"score":0.6132752299308777},{"id":"https://openalex.org/C157764524","wikidata":"https://www.wikidata.org/wiki/Q1383412","display_name":"Throughput","level":3,"score":0.5823541879653931},{"id":"https://openalex.org/C98199447","wikidata":"https://www.wikidata.org/wiki/Q2445044","display_name":"Materialized view","level":4,"score":0.5720072984695435},{"id":"https://openalex.org/C173608175","wikidata":"https://www.wikidata.org/wiki/Q232661","display_name":"Parallel computing","level":1,"score":0.5592343211174011},{"id":"https://openalex.org/C2780551164","wikidata":"https://www.wikidata.org/wiki/Q2306599","display_name":"Column (typography)","level":3,"score":0.5323712229728699},{"id":"https://openalex.org/C123657996","wikidata":"https://www.wikidata.org/wiki/Q12271","display_name":"Architecture","level":2,"score":0.465749591588974},{"id":"https://openalex.org/C48103436","wikidata":"https://www.wikidata.org/wiki/Q599031","display_name":"State (computer science)","level":2,"score":0.45928075909614563},{"id":"https://openalex.org/C14036430","wikidata":"https://www.wikidata.org/wiki/Q3736076","display_name":"Function (biology)","level":2,"score":0.44832414388656616},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.3727535605430603},{"id":"https://openalex.org/C118524514","wikidata":"https://www.wikidata.org/wiki/Q173212","display_name":"Computer architecture","level":1,"score":0.33003413677215576},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.28256261348724365},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.21396282315254211},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.09753191471099854},{"id":"https://openalex.org/C31258907","wikidata":"https://www.wikidata.org/wiki/Q1301371","display_name":"Computer network","level":1,"score":0.07854372262954712},{"id":"https://openalex.org/C126042441","wikidata":"https://www.wikidata.org/wiki/Q1324888","display_name":"Frame (networking)","level":2,"score":0.0},{"id":"https://openalex.org/C118615104","wikidata":"https://www.wikidata.org/wiki/Q121416","display_name":"Discrete mathematics","level":1,"score":0.0},{"id":"https://openalex.org/C142362112","wikidata":"https://www.wikidata.org/wiki/Q735","display_name":"Art","level":0,"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/C153349607","wikidata":"https://www.wikidata.org/wiki/Q36649","display_name":"Visual arts","level":1,"score":0.0},{"id":"https://openalex.org/C555944384","wikidata":"https://www.wikidata.org/wiki/Q249","display_name":"Wireless","level":2,"score":0.0},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"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/C78458016","wikidata":"https://www.wikidata.org/wiki/Q840400","display_name":"Evolutionary biology","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":7,"locations":[{"id":"doi:10.1145/1559845.1559879","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1559845.1559879","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2009 ACM SIGMOD International Conference on Management of data","raw_type":"proceedings-article"},{"id":"pmh:cwi:oai:cwi.nl:14287","is_oa":true,"landing_page_url":"https://ir.cwi.nl/pub/14287","pdf_url":"https://ir.cwi.nl/pub/14287/14287A.pdf","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":"","raw_type":"info:eu-repo/semantics/conferencepaper"},{"id":"pmh:oai:cwi.nl:16695","is_oa":true,"landing_page_url":"https://ir.cwi.nl/pub/16695","pdf_url":"https://ir.cwi.nl/pub/16695/16695D.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":"ACM Transactions on Database Systems vol. 35 no. 4, pp. 1-41","raw_type":"info:eu-repo/semantics/article"},{"id":"pmh:oai:gfzpublic.gfz-potsdam.de:item_5025251","is_oa":false,"landing_page_url":"https://gfzpublic.gfz-potsdam.de/pubman/item/item_5025251","pdf_url":null,"source":{"id":"https://openalex.org/S4306401313","display_name":"Publication Database GFZ (GFZ German Research Centre for Geosciences)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I4210152878","host_organization_name":"GFZ Helmholtz Centre for Geosciences","host_organization_lineage":["https://openalex.org/I4210152878"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"ACM Transactions on Database Systems","raw_type":"info:eu-repo/semantics/article"},{"id":"pmh:oai:gfzpublic.gfz-potsdam.de:item_5025254","is_oa":false,"landing_page_url":"https://gfzpublic.gfz-potsdam.de/pubman/item/item_5025254","pdf_url":null,"source":{"id":"https://openalex.org/S4306401313","display_name":"Publication Database GFZ (GFZ German Research Centre for Geosciences)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I4210152878","host_organization_name":"GFZ Helmholtz Centre for Geosciences","host_organization_lineage":["https://openalex.org/I4210152878"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"Proceedings","raw_type":"info:eu-repo/semantics/conferenceObject"},{"id":"pmh:oai:gfzpublic.gfz.de:item_5025251","is_oa":false,"landing_page_url":"https://gfzpublic.gfz.de/pubman/item/item_5025251","pdf_url":null,"source":{"id":"https://openalex.org/S4306401313","display_name":"Publication Database GFZ (GFZ German Research Centre for Geosciences)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I4210152878","host_organization_name":"GFZ Helmholtz Centre for Geosciences","host_organization_lineage":["https://openalex.org/I4210152878"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"ACM Transactions on Database Systems","raw_type":"info:eu-repo/semantics/article"},{"id":"pmh:oai:gfzpublic.gfz.de:item_5025254","is_oa":false,"landing_page_url":"https://gfzpublic.gfz.de/pubman/item/item_5025254","pdf_url":null,"source":{"id":"https://openalex.org/S4306401313","display_name":"Publication Database GFZ (GFZ German Research Centre for Geosciences)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I4210152878","host_organization_name":"GFZ Helmholtz Centre for Geosciences","host_organization_lineage":["https://openalex.org/I4210152878"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"Proceedings","raw_type":"info:eu-repo/semantics/conferenceObject"}],"best_oa_location":{"id":"pmh:cwi:oai:cwi.nl:14287","is_oa":true,"landing_page_url":"https://ir.cwi.nl/pub/14287","pdf_url":"https://ir.cwi.nl/pub/14287/14287A.pdf","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":"","raw_type":"info:eu-repo/semantics/conferencepaper"},"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":true},"content_urls":{"pdf":"https://content.openalex.org/works/W1992977903.pdf"},"referenced_works_count":26,"referenced_works":["https://openalex.org/W53283472","https://openalex.org/W1551562200","https://openalex.org/W1585730347","https://openalex.org/W1605782097","https://openalex.org/W1835416193","https://openalex.org/W1960895309","https://openalex.org/W1987238352","https://openalex.org/W1989163741","https://openalex.org/W2038176938","https://openalex.org/W2061751973","https://openalex.org/W2068010682","https://openalex.org/W2084961399","https://openalex.org/W2096307514","https://openalex.org/W2098416578","https://openalex.org/W2104704499","https://openalex.org/W2106105896","https://openalex.org/W2119946100","https://openalex.org/W2122816893","https://openalex.org/W2124624809","https://openalex.org/W2134912727","https://openalex.org/W2140453381","https://openalex.org/W2164591245","https://openalex.org/W2171492933","https://openalex.org/W2951321531","https://openalex.org/W4255327858","https://openalex.org/W6641017242"],"related_works":["https://openalex.org/W2801510041","https://openalex.org/W2156798910","https://openalex.org/W2503901328","https://openalex.org/W1850895539","https://openalex.org/W181867345","https://openalex.org/W2005818379","https://openalex.org/W174833201","https://openalex.org/W3169301243","https://openalex.org/W2054999976","https://openalex.org/W4385633994"],"abstract_inverted_index":{"Automatically":[0],"recycling":[1],"(intermediate)":[2],"results":[3],"is":[4],"a":[5,25],"grand":[6],"challenge":[7],"for":[8,41],"state-of-the-art":[9],"databases":[10],"to":[11,46],"improve":[12],"both":[13],"query":[14],"response":[15],"time":[16],"and":[17,22,50],"throughput.":[18],"Tuples":[19],"are":[20],"loaded":[21],"streamed":[23],"through":[24],"tuple-at-a-time":[26],"processing":[27],"pipeline":[28],"avoiding":[29],"materialization":[30],"of":[31,43],"intermediates":[32],"as":[33,35],"much":[34],"possible.":[36],"This":[37],"limits":[38],"the":[39],"opportunities":[40],"reuse":[42],"overlapping":[44],"computations":[45],"DBA-defined":[47],"materialized":[48],"views":[49],"function/result":[51],"cache":[52],"tuning.":[53]},"counts_by_year":[{"year":2025,"cited_by_count":2},{"year":2023,"cited_by_count":1},{"year":2022,"cited_by_count":1},{"year":2021,"cited_by_count":5},{"year":2020,"cited_by_count":1},{"year":2019,"cited_by_count":4},{"year":2018,"cited_by_count":7},{"year":2017,"cited_by_count":6},{"year":2016,"cited_by_count":3},{"year":2015,"cited_by_count":4},{"year":2014,"cited_by_count":4},{"year":2013,"cited_by_count":10},{"year":2012,"cited_by_count":9}],"updated_date":"2026-04-05T17:49:38.594831","created_date":"2025-10-10T00:00:00"}