{"id":"https://openalex.org/W2008480196","doi":"https://doi.org/10.1109/bigdata.2013.6691699","title":"Workload-aware aggregate maintenance in columnar in-memory databases","display_name":"Workload-aware aggregate maintenance in columnar in-memory databases","publication_year":2013,"publication_date":"2013-10-01","ids":{"openalex":"https://openalex.org/W2008480196","doi":"https://doi.org/10.1109/bigdata.2013.6691699","mag":"2008480196"},"language":"en","primary_location":{"id":"doi:10.1109/bigdata.2013.6691699","is_oa":false,"landing_page_url":"https://doi.org/10.1109/bigdata.2013.6691699","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2013 IEEE International Conference on Big 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/A5076938453","display_name":"Stephan A. M\u00fcller","orcid":"https://orcid.org/0000-0003-3414-307X"},"institutions":[{"id":"https://openalex.org/I143288331","display_name":"Hasso Plattner Institute","ror":"https://ror.org/058rn5r42","country_code":"DE","type":"facility","lineage":["https://openalex.org/I143288331","https://openalex.org/I176453806"]},{"id":"https://openalex.org/I176453806","display_name":"University of Potsdam","ror":"https://ror.org/03bnmw459","country_code":"DE","type":"education","lineage":["https://openalex.org/I176453806"]}],"countries":["DE"],"is_corresponding":true,"raw_author_name":"Stephan Muller","raw_affiliation_strings":["Hasso Plattner Institute, University of Potsdam, Germany","Hasso-Plattner Inst., Univ. of Potsdam, Potsdam, Germany"],"affiliations":[{"raw_affiliation_string":"Hasso Plattner Institute, University of Potsdam, Germany","institution_ids":["https://openalex.org/I143288331","https://openalex.org/I176453806"]},{"raw_affiliation_string":"Hasso-Plattner Inst., Univ. of Potsdam, Potsdam, Germany","institution_ids":["https://openalex.org/I143288331"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5051434400","display_name":"Lars Butzmann","orcid":null},"institutions":[{"id":"https://openalex.org/I176453806","display_name":"University of Potsdam","ror":"https://ror.org/03bnmw459","country_code":"DE","type":"education","lineage":["https://openalex.org/I176453806"]},{"id":"https://openalex.org/I143288331","display_name":"Hasso Plattner Institute","ror":"https://ror.org/058rn5r42","country_code":"DE","type":"facility","lineage":["https://openalex.org/I143288331","https://openalex.org/I176453806"]}],"countries":["DE"],"is_corresponding":false,"raw_author_name":"Lars Butzmann","raw_affiliation_strings":["Hasso Plattner Institute, University of Potsdam, Germany","Hasso-Plattner Inst., Univ. of Potsdam, Potsdam, Germany"],"affiliations":[{"raw_affiliation_string":"Hasso Plattner Institute, University of Potsdam, Germany","institution_ids":["https://openalex.org/I143288331","https://openalex.org/I176453806"]},{"raw_affiliation_string":"Hasso-Plattner Inst., Univ. of Potsdam, Potsdam, Germany","institution_ids":["https://openalex.org/I143288331"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5091899147","display_name":"Stefan Klauck","orcid":null},"institutions":[{"id":"https://openalex.org/I143288331","display_name":"Hasso Plattner Institute","ror":"https://ror.org/058rn5r42","country_code":"DE","type":"facility","lineage":["https://openalex.org/I143288331","https://openalex.org/I176453806"]},{"id":"https://openalex.org/I176453806","display_name":"University of Potsdam","ror":"https://ror.org/03bnmw459","country_code":"DE","type":"education","lineage":["https://openalex.org/I176453806"]}],"countries":["DE"],"is_corresponding":false,"raw_author_name":"Stefan Klauck","raw_affiliation_strings":["Hasso Plattner Institute, University of Potsdam, Germany","Hasso-Plattner Inst., Univ. of Potsdam, Potsdam, Germany"],"affiliations":[{"raw_affiliation_string":"Hasso Plattner Institute, University of Potsdam, Germany","institution_ids":["https://openalex.org/I143288331","https://openalex.org/I176453806"]},{"raw_affiliation_string":"Hasso-Plattner Inst., Univ. of Potsdam, Potsdam, Germany","institution_ids":["https://openalex.org/I143288331"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5035480309","display_name":"Hasso Plattner","orcid":null},"institutions":[{"id":"https://openalex.org/I176453806","display_name":"University of Potsdam","ror":"https://ror.org/03bnmw459","country_code":"DE","type":"education","lineage":["https://openalex.org/I176453806"]},{"id":"https://openalex.org/I143288331","display_name":"Hasso Plattner Institute","ror":"https://ror.org/058rn5r42","country_code":"DE","type":"facility","lineage":["https://openalex.org/I143288331","https://openalex.org/I176453806"]}],"countries":["DE"],"is_corresponding":false,"raw_author_name":"Hasso Plattner","raw_affiliation_strings":["Hasso Plattner Institute, University of Potsdam, Germany","Hasso-Plattner Inst., Univ. of Potsdam, Potsdam, Germany"],"affiliations":[{"raw_affiliation_string":"Hasso Plattner Institute, University of Potsdam, Germany","institution_ids":["https://openalex.org/I143288331","https://openalex.org/I176453806"]},{"raw_affiliation_string":"Hasso-Plattner Inst., Univ. of Potsdam, Potsdam, Germany","institution_ids":["https://openalex.org/I143288331"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":4,"corresponding_author_ids":["https://openalex.org/A5076938453"],"corresponding_institution_ids":["https://openalex.org/I143288331","https://openalex.org/I176453806"],"apc_list":null,"apc_paid":null,"fwci":1.4498,"has_fulltext":false,"cited_by_count":5,"citation_normalized_percentile":{"value":0.83577078,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":90,"max":96},"biblio":{"volume":null,"issue":null,"first_page":"62","last_page":"69"},"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/T10772","display_name":"Distributed systems and fault tolerance","score":0.9987000226974487,"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/T10101","display_name":"Cloud Computing and Resource Management","score":0.9986000061035156,"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/materialized-view","display_name":"Materialized view","score":0.9496757388114929},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8483331799507141},{"id":"https://openalex.org/keywords/aggregate","display_name":"Aggregate (composite)","score":0.6980466842651367},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.6304500699043274},{"id":"https://openalex.org/keywords/context","display_name":"Context (archaeology)","score":0.5662122368812561},{"id":"https://openalex.org/keywords/consistency","display_name":"Consistency (knowledge bases)","score":0.5603410005569458},{"id":"https://openalex.org/keywords/workload","display_name":"Workload","score":0.5162546634674072},{"id":"https://openalex.org/keywords/column","display_name":"Column (typography)","score":0.4489065706729889},{"id":"https://openalex.org/keywords/resource","display_name":"Resource (disambiguation)","score":0.430294394493103},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.18452271819114685},{"id":"https://openalex.org/keywords/view","display_name":"View","score":0.15039095282554626},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.14536195993423462},{"id":"https://openalex.org/keywords/computer-network","display_name":"Computer network","score":0.09219092130661011}],"concepts":[{"id":"https://openalex.org/C98199447","wikidata":"https://www.wikidata.org/wiki/Q2445044","display_name":"Materialized view","level":4,"score":0.9496757388114929},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8483331799507141},{"id":"https://openalex.org/C4679612","wikidata":"https://www.wikidata.org/wiki/Q866298","display_name":"Aggregate (composite)","level":2,"score":0.6980466842651367},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.6304500699043274},{"id":"https://openalex.org/C2779343474","wikidata":"https://www.wikidata.org/wiki/Q3109175","display_name":"Context (archaeology)","level":2,"score":0.5662122368812561},{"id":"https://openalex.org/C2776436953","wikidata":"https://www.wikidata.org/wiki/Q5163215","display_name":"Consistency (knowledge bases)","level":2,"score":0.5603410005569458},{"id":"https://openalex.org/C2778476105","wikidata":"https://www.wikidata.org/wiki/Q628539","display_name":"Workload","level":2,"score":0.5162546634674072},{"id":"https://openalex.org/C2780551164","wikidata":"https://www.wikidata.org/wiki/Q2306599","display_name":"Column (typography)","level":3,"score":0.4489065706729889},{"id":"https://openalex.org/C206345919","wikidata":"https://www.wikidata.org/wiki/Q20380951","display_name":"Resource (disambiguation)","level":2,"score":0.430294394493103},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.18452271819114685},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.15039095282554626},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.14536195993423462},{"id":"https://openalex.org/C31258907","wikidata":"https://www.wikidata.org/wiki/Q1301371","display_name":"Computer network","level":1,"score":0.09219092130661011},{"id":"https://openalex.org/C159985019","wikidata":"https://www.wikidata.org/wiki/Q181790","display_name":"Composite material","level":1,"score":0.0},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.0},{"id":"https://openalex.org/C192562407","wikidata":"https://www.wikidata.org/wiki/Q228736","display_name":"Materials science","level":0,"score":0.0},{"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/C86803240","wikidata":"https://www.wikidata.org/wiki/Q420","display_name":"Biology","level":0,"score":0.0},{"id":"https://openalex.org/C151730666","wikidata":"https://www.wikidata.org/wiki/Q7205","display_name":"Paleontology","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1109/bigdata.2013.6691699","is_oa":false,"landing_page_url":"https://doi.org/10.1109/bigdata.2013.6691699","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2013 IEEE International Conference on Big Data","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":37,"referenced_works":["https://openalex.org/W74743223","https://openalex.org/W137313736","https://openalex.org/W253264081","https://openalex.org/W1527733826","https://openalex.org/W1556530724","https://openalex.org/W1943411325","https://openalex.org/W1969877208","https://openalex.org/W1977330283","https://openalex.org/W2025227784","https://openalex.org/W2029406036","https://openalex.org/W2039910065","https://openalex.org/W2073824505","https://openalex.org/W2079249644","https://openalex.org/W2091459966","https://openalex.org/W2099918651","https://openalex.org/W2102729946","https://openalex.org/W2114712170","https://openalex.org/W2116476518","https://openalex.org/W2118385974","https://openalex.org/W2125759315","https://openalex.org/W2131165411","https://openalex.org/W2132582487","https://openalex.org/W2134791164","https://openalex.org/W2150282015","https://openalex.org/W2248652221","https://openalex.org/W2491738624","https://openalex.org/W3015061971","https://openalex.org/W4248563344","https://openalex.org/W6605624096","https://openalex.org/W6631453627","https://openalex.org/W6633547644","https://openalex.org/W6640690195","https://openalex.org/W6655000594","https://openalex.org/W6673288087","https://openalex.org/W6677702014","https://openalex.org/W6679865122","https://openalex.org/W6987032954"],"related_works":["https://openalex.org/W2125738398","https://openalex.org/W2038176938","https://openalex.org/W2376402673","https://openalex.org/W2953224074","https://openalex.org/W1606751452","https://openalex.org/W2585331044","https://openalex.org/W2588278736","https://openalex.org/W2114713465","https://openalex.org/W2381166277","https://openalex.org/W1591045846"],"abstract_inverted_index":{"Database":[0],"workloads":[1],"generated":[2],"by":[3,28],"enterprise":[4],"applications":[5],"are":[6,59,123],"comprised":[7],"of":[8,39,64],"short-running":[9],"transactional":[10],"as":[11,13],"well":[12],"long-running":[14],"analytical":[15],"queries":[16,23,80,86],"with":[17,36,177],"resource-intensive":[18],"aggregations.":[19],"The":[20],"expensive":[21],"aggregate":[22,120],"can":[24],"be":[25],"significantly":[26],"accelerated":[27],"using":[29],"materialized":[30,40,83,119],"views.":[31],"This":[32],"speed-up,":[33],"however,":[34],"comes":[35],"the":[37,50,62,77,82,88,105,112,139],"cost":[38,136],"view":[41,56,84,107,128,141],"maintenance":[42,57,108,129,142,170],"which":[43,147],"is":[44,151,172],"necessary":[45],"to":[46,125,153,155],"guarantee":[47],"consistency":[48],"when":[49],"underlying":[51],"data":[52],"changes.":[53],"While":[54],"several":[55],"strategies":[58,130,143,171],"applicable":[60],"in":[61,97,160],"context":[63],"an":[65],"in-memory":[66],"column":[67],"store,":[68],"their":[69],"performance":[70],"depends":[71],"on":[72,111,131],"various":[73],"factors,":[74],"most":[75],"importantly":[76],"ratio":[78,149],"between":[79,127,169],"accessing":[81],"and":[85],"altering":[87],"base":[89],"data,":[90],"called":[91],"insert":[92,148],"ratio.":[93],"As":[94],"a":[95,178],"contribution":[96],"this":[98],"paper,":[99],"we":[100,122],"propose":[101],"algorithms":[102],"that":[103,144,163],"determine":[104,145],"best-performing":[106],"strategy":[109],"based":[110],"currently":[113],"monitored":[114],"factors.":[115],"Using":[116],"our":[117],"novel":[118],"engine,":[121],"able":[124],"switch":[126,154],"demand.":[132],"We":[133],"have":[134],"created":[135],"models":[137],"for":[138,164],"identified":[140,166],"at":[146],"it":[150],"advisable":[152],"another":[156],"strategy.":[157,180],"Our":[158],"benchmarks":[159],"SanssouciDB":[161],"reveal":[162],"all":[165],"workloads,":[167],"switching":[168],"more":[173],"beneficial":[174],"than":[175],"staying":[176],"single":[179]},"counts_by_year":[{"year":2019,"cited_by_count":1},{"year":2015,"cited_by_count":2},{"year":2014,"cited_by_count":2}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}