{"id":"https://openalex.org/W1999883293","doi":"https://doi.org/10.1109/icde.2013.6544909","title":"Materialization strategies in the Vertica analytic database: Lessons learned","display_name":"Materialization strategies in the Vertica analytic database: Lessons learned","publication_year":2013,"publication_date":"2013-04-01","ids":{"openalex":"https://openalex.org/W1999883293","doi":"https://doi.org/10.1109/icde.2013.6544909","mag":"1999883293"},"language":"en","primary_location":{"id":"doi:10.1109/icde.2013.6544909","is_oa":false,"landing_page_url":"https://doi.org/10.1109/icde.2013.6544909","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2013 IEEE 29th International Conference on Data Engineering (ICDE)","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/A5078763446","display_name":"Lakshmikant Shrinivas","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"L. Shrinivas","raw_affiliation_strings":["Vertica Systems- HP Company, Cambridge, MA, USA","Vertica Syst., HP Co., Cambridge, MA, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Vertica Systems- HP Company, Cambridge, MA, USA","institution_ids":[]},{"raw_affiliation_string":"Vertica Syst., HP Co., Cambridge, MA, USA","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5083195789","display_name":"Sreenath Bodagala","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"S. Bodagala","raw_affiliation_strings":["Vertica Systems- HP Company, Cambridge, MA, USA","Vertica Syst., HP Co., Cambridge, MA, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Vertica Systems- HP Company, Cambridge, MA, USA","institution_ids":[]},{"raw_affiliation_string":"Vertica Syst., HP Co., Cambridge, MA, USA","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5002810936","display_name":"Ramakrishna Varadarajan","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"R. Varadarajan","raw_affiliation_strings":["Vertica Systems- HP Company, Cambridge, MA, USA","Vertica Syst., HP Co., Cambridge, MA, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Vertica Systems- HP Company, Cambridge, MA, USA","institution_ids":[]},{"raw_affiliation_string":"Vertica Syst., HP Co., Cambridge, MA, USA","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5079213222","display_name":"Ariel Cary","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"A. Cary","raw_affiliation_strings":["Vertica Systems- HP Company, Cambridge, MA, USA","Vertica Syst., HP Co., Cambridge, MA, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Vertica Systems- HP Company, Cambridge, MA, USA","institution_ids":[]},{"raw_affiliation_string":"Vertica Syst., HP Co., Cambridge, MA, USA","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5049046541","display_name":"Vivek Bharathan","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"V. Bharathan","raw_affiliation_strings":["Vertica Systems- HP Company, Cambridge, MA, USA","Vertica Syst., HP Co., Cambridge, MA, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Vertica Systems- HP Company, Cambridge, MA, USA","institution_ids":[]},{"raw_affiliation_string":"Vertica Syst., HP Co., Cambridge, MA, USA","institution_ids":[]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5079515510","display_name":"Chuck Bear","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"C. Bear","raw_affiliation_strings":["Vertica Systems- HP Company, Cambridge, MA, USA","Vertica Syst., HP Co., Cambridge, MA, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Vertica Systems- HP Company, Cambridge, MA, USA","institution_ids":[]},{"raw_affiliation_string":"Vertica Syst., HP Co., Cambridge, MA, USA","institution_ids":[]}]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":6,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":2.5766,"has_fulltext":false,"cited_by_count":27,"citation_normalized_percentile":{"value":0.89821016,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":97},"biblio":{"volume":null,"issue":null,"first_page":"1196","last_page":"1207"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9998000264167786,"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.9998000264167786,"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.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/T11269","display_name":"Algorithms and Data Compression","score":0.9965999722480774,"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/joins","display_name":"Joins","score":0.9012778997421265},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.7947943806648254},{"id":"https://openalex.org/keywords/sort","display_name":"sort","score":0.7354423999786377},{"id":"https://openalex.org/keywords/strengths-and-weaknesses","display_name":"Strengths and weaknesses","score":0.49578389525413513},{"id":"https://openalex.org/keywords/tuple","display_name":"Tuple","score":0.45794907212257385},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.40104782581329346},{"id":"https://openalex.org/keywords/data-science","display_name":"Data science","score":0.3278071880340576},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.1284720003604889}],"concepts":[{"id":"https://openalex.org/C2778692605","wikidata":"https://www.wikidata.org/wiki/Q4041866","display_name":"Joins","level":2,"score":0.9012778997421265},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7947943806648254},{"id":"https://openalex.org/C88548561","wikidata":"https://www.wikidata.org/wiki/Q347599","display_name":"sort","level":2,"score":0.7354423999786377},{"id":"https://openalex.org/C63882131","wikidata":"https://www.wikidata.org/wiki/Q17122954","display_name":"Strengths and weaknesses","level":2,"score":0.49578389525413513},{"id":"https://openalex.org/C118930307","wikidata":"https://www.wikidata.org/wiki/Q600590","display_name":"Tuple","level":2,"score":0.45794907212257385},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.40104782581329346},{"id":"https://openalex.org/C2522767166","wikidata":"https://www.wikidata.org/wiki/Q2374463","display_name":"Data science","level":1,"score":0.3278071880340576},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.1284720003604889},{"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/C111472728","wikidata":"https://www.wikidata.org/wiki/Q9471","display_name":"Epistemology","level":1,"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/C138885662","wikidata":"https://www.wikidata.org/wiki/Q5891","display_name":"Philosophy","level":0,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1109/icde.2013.6544909","is_oa":false,"landing_page_url":"https://doi.org/10.1109/icde.2013.6544909","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2013 IEEE 29th International Conference on Data Engineering (ICDE)","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":28,"referenced_works":["https://openalex.org/W180056467","https://openalex.org/W1497285001","https://openalex.org/W1761301028","https://openalex.org/W1791587242","https://openalex.org/W1852059679","https://openalex.org/W1969450725","https://openalex.org/W2006296837","https://openalex.org/W2043934800","https://openalex.org/W2051244613","https://openalex.org/W2069944651","https://openalex.org/W2087796842","https://openalex.org/W2100542992","https://openalex.org/W2102639991","https://openalex.org/W2116436709","https://openalex.org/W2123845384","https://openalex.org/W2144839430","https://openalex.org/W2146709231","https://openalex.org/W2153485419","https://openalex.org/W2162621793","https://openalex.org/W2167631575","https://openalex.org/W2949504798","https://openalex.org/W3138367763","https://openalex.org/W6607320512","https://openalex.org/W6629870147","https://openalex.org/W6637898976","https://openalex.org/W6638231387","https://openalex.org/W6638950451","https://openalex.org/W6663491889"],"related_works":["https://openalex.org/W2088925915","https://openalex.org/W2382891957","https://openalex.org/W2393491644","https://openalex.org/W2016456293","https://openalex.org/W2161128265","https://openalex.org/W1997896902","https://openalex.org/W2138101384","https://openalex.org/W2140894225","https://openalex.org/W4212828571","https://openalex.org/W2125826941"],"abstract_inverted_index":{"Column":[0],"store":[1],"databases":[2],"allow":[3],"for":[4,109],"various":[5],"tuple":[6],"reconstruction":[7],"strategies":[8],"(also":[9,64],"called":[10,65],"materialization":[11,14,27,87,169],"strategies).":[12],"Early":[13],"is":[15,28,47],"easy":[16],"to":[17,31,76,95,118,124,186],"implement":[18],"but":[19],"generally":[20],"performs":[21,35],"worse":[22,107],"than":[23,38],"late":[24,100,143],"materialization.":[25],"Late":[26],"more":[29],"complex":[30],"implement,":[32],"and":[33,129,144,150,152],"usually":[34],"much":[36],"better":[37],"early":[39,86,145],"materialization,":[40,101,146],"although":[41],"there":[42],"are":[43],"situations":[44],"where":[45,58],"it":[46],"worse.":[48],"We":[49,83,162],"identify":[50],"these":[51,168],"situations,":[52],"which":[53,171],"essentially":[54],"revolve":[55],"around":[56],"joins":[57],"neither":[59],"input":[60],"fits":[61],"in":[62,121],"memory":[63],"spilling":[66,110],"joins).":[67],"Sideways":[68],"information":[69,91,159,183],"passing":[70,92,160,184],"techniques":[71],"provide":[72],"a":[73],"viable":[74],"solution":[75],"get":[77,96],"the":[78,97,103,133,154,173],"best":[79],"of":[80,99,132,156,166,181],"both":[81],"worlds.":[82],"demonstrate":[84],"how":[85],"combined":[88],"with":[89,127,142],"sideways":[90,158,182],"allows":[93],"us":[94],"benefits":[98,117],"without":[102],"bookkeeping":[104],"complexity":[105],"or":[106],"performance":[108,175],"joins.":[111],"It":[112],"also":[113],"provides":[114],"some":[115,189],"other":[116],"query":[119],"processing":[120],"Vertica":[122],"due":[123],"positive":[125],"interaction":[126],"compression":[128],"sort":[130],"orders":[131],"data.":[134],"In":[135],"this":[136],"paper,":[137],"we":[138],"report":[139],"our":[140,157,179],"experiences":[141],"highlight":[147,172],"their":[148],"strengths":[149],"weaknesses,":[151],"present":[153],"details":[155],"implementation.":[161],"show":[163],"experimental":[164],"results":[165],"comparing":[167],"strategies,":[170],"significant":[174],"improvements":[176],"provided":[177],"by":[178],"implementation":[180],"(up":[185],"72%":[187],"on":[188],"TPC-H":[190],"queries).":[191]},"counts_by_year":[{"year":2025,"cited_by_count":3},{"year":2024,"cited_by_count":3},{"year":2023,"cited_by_count":1},{"year":2022,"cited_by_count":1},{"year":2021,"cited_by_count":3},{"year":2020,"cited_by_count":1},{"year":2019,"cited_by_count":2},{"year":2018,"cited_by_count":3},{"year":2017,"cited_by_count":2},{"year":2016,"cited_by_count":1},{"year":2015,"cited_by_count":3},{"year":2014,"cited_by_count":3},{"year":2013,"cited_by_count":1}],"updated_date":"2026-06-11T09:08:48.828518","created_date":"2025-10-10T00:00:00"}