{"id":"https://openalex.org/W2028471152","doi":"https://doi.org/10.1145/2065003.2065015","title":"Aggregation strategies for columnar in-memory databases in a mixed workload","display_name":"Aggregation strategies for columnar in-memory databases in a mixed workload","publication_year":2011,"publication_date":"2011-10-28","ids":{"openalex":"https://openalex.org/W2028471152","doi":"https://doi.org/10.1145/2065003.2065015","mag":"2028471152"},"language":"en","primary_location":{"id":"doi:10.1145/2065003.2065015","is_oa":false,"landing_page_url":"https://doi.org/10.1145/2065003.2065015","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 4th workshop on Workshop for Ph.D. students in information & knowledge management","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"]}],"countries":["DE"],"is_corresponding":true,"raw_author_name":"Stephan M\u00fcller","raw_affiliation_strings":["Hasso-Plattner-Institut, Potsdam, Germany"],"affiliations":[{"raw_affiliation_string":"Hasso-Plattner-Institut, 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/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-Institut, Potsdam, Germany"],"affiliations":[{"raw_affiliation_string":"Hasso-Plattner-Institut, Potsdam, Germany","institution_ids":["https://openalex.org/I143288331"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":["https://openalex.org/A5076938453"],"corresponding_institution_ids":["https://openalex.org/I143288331"],"apc_list":null,"apc_paid":null,"fwci":0.366883,"has_fulltext":false,"cited_by_count":4,"citation_normalized_percentile":{"value":0.6166262,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":94,"max":96},"biblio":{"volume":null,"issue":null,"first_page":"51","last_page":"58"},"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.9997000098228455,"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.9997000098228455,"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.9988999962806702,"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/T10772","display_name":"Distributed systems and fault tolerance","score":0.9911999702453613,"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/computer-science","display_name":"Computer science","score":0.8266850113868713},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.7129068374633789},{"id":"https://openalex.org/keywords/materialized-view","display_name":"Materialized view","score":0.6999576687812805},{"id":"https://openalex.org/keywords/aggregate","display_name":"Aggregate (composite)","score":0.6793694496154785},{"id":"https://openalex.org/keywords/analytics","display_name":"Analytics","score":0.6589069962501526},{"id":"https://openalex.org/keywords/workload","display_name":"Workload","score":0.6429742574691772},{"id":"https://openalex.org/keywords/online-analytical-processing","display_name":"Online analytical processing","score":0.6178517937660217},{"id":"https://openalex.org/keywords/transaction-processing","display_name":"Transaction processing","score":0.5483685731887817},{"id":"https://openalex.org/keywords/data-warehouse","display_name":"Data warehouse","score":0.44170334935188293},{"id":"https://openalex.org/keywords/on-the-fly","display_name":"On the fly","score":0.42648300528526306},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.20816963911056519},{"id":"https://openalex.org/keywords/database-transaction","display_name":"Database transaction","score":0.2027365267276764},{"id":"https://openalex.org/keywords/view","display_name":"View","score":0.17498940229415894},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.09730002284049988}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8266850113868713},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.7129068374633789},{"id":"https://openalex.org/C98199447","wikidata":"https://www.wikidata.org/wiki/Q2445044","display_name":"Materialized view","level":4,"score":0.6999576687812805},{"id":"https://openalex.org/C4679612","wikidata":"https://www.wikidata.org/wiki/Q866298","display_name":"Aggregate (composite)","level":2,"score":0.6793694496154785},{"id":"https://openalex.org/C79158427","wikidata":"https://www.wikidata.org/wiki/Q485396","display_name":"Analytics","level":2,"score":0.6589069962501526},{"id":"https://openalex.org/C2778476105","wikidata":"https://www.wikidata.org/wiki/Q628539","display_name":"Workload","level":2,"score":0.6429742574691772},{"id":"https://openalex.org/C201932085","wikidata":"https://www.wikidata.org/wiki/Q642514","display_name":"Online analytical processing","level":3,"score":0.6178517937660217},{"id":"https://openalex.org/C72108876","wikidata":"https://www.wikidata.org/wiki/Q844565","display_name":"Transaction processing","level":3,"score":0.5483685731887817},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.44170334935188293},{"id":"https://openalex.org/C2781020372","wikidata":"https://www.wikidata.org/wiki/Q533093","display_name":"On the fly","level":2,"score":0.42648300528526306},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.20816963911056519},{"id":"https://openalex.org/C75949130","wikidata":"https://www.wikidata.org/wiki/Q848010","display_name":"Database transaction","level":2,"score":0.2027365267276764},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.17498940229415894},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.09730002284049988},{"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/C159985019","wikidata":"https://www.wikidata.org/wiki/Q181790","display_name":"Composite material","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/2065003.2065015","is_oa":false,"landing_page_url":"https://doi.org/10.1145/2065003.2065015","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 4th workshop on Workshop for Ph.D. students in information & knowledge management","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":36,"referenced_works":["https://openalex.org/W74743223","https://openalex.org/W126344800","https://openalex.org/W1488870204","https://openalex.org/W1506170043","https://openalex.org/W1520432709","https://openalex.org/W1521194487","https://openalex.org/W1527733826","https://openalex.org/W1556640847","https://openalex.org/W1596568456","https://openalex.org/W1977330283","https://openalex.org/W1987238352","https://openalex.org/W1998085622","https://openalex.org/W2005112390","https://openalex.org/W2025619570","https://openalex.org/W2039601877","https://openalex.org/W2039910065","https://openalex.org/W2072764742","https://openalex.org/W2073824505","https://openalex.org/W2100773341","https://openalex.org/W2102967864","https://openalex.org/W2103201239","https://openalex.org/W2113458201","https://openalex.org/W2123686039","https://openalex.org/W2136390693","https://openalex.org/W2144839430","https://openalex.org/W2152191782","https://openalex.org/W2155651153","https://openalex.org/W2158237121","https://openalex.org/W2165467455","https://openalex.org/W2185907055","https://openalex.org/W2197881366","https://openalex.org/W2296677182","https://openalex.org/W2491738624","https://openalex.org/W2518548975","https://openalex.org/W6605127035","https://openalex.org/W6631453627"],"related_works":["https://openalex.org/W2378213774","https://openalex.org/W2357522326","https://openalex.org/W1988774479","https://openalex.org/W2363019959","https://openalex.org/W6138692","https://openalex.org/W1535822977","https://openalex.org/W23190051","https://openalex.org/W2367419170","https://openalex.org/W2377387014","https://openalex.org/W2381646725"],"abstract_inverted_index":{"The":[0,26],"recent":[1],"trend":[2],"towards":[3],"analytics":[4],"on":[5,70],"operational":[6],"data":[7],"has":[8,55],"led":[9,56],"to":[10,50,57],"an":[11],"approach":[12],"of":[13,28,61],"reunifying":[14],"online":[15,19],"transactional":[16],"processing":[17,21],"and":[18,35,40,66],"analytical":[20],"in":[22],"one":[23],"single":[24],"database.":[25],"advent":[27],"columnar":[29],"in-memory":[30],"databases":[31],"makes":[32],"this":[33],"viable":[34],"feasible":[36],"as":[37],"expensive":[38],"join":[39],"aggregation":[41],"operations":[42],"can":[43],"be":[44],"performed":[45],"with":[46],"superior":[47],"performance":[48],"compared":[49],"traditional":[51],"row-oriented":[52],"databases.":[53],"This":[54],"the":[58,71],"radical":[59],"proposal":[60],"abandoning":[62],"materialized":[63],"aggregate":[64],"tables":[65],"calculate":[67],"all":[68],"aggregations":[69],"fly.":[72]},"counts_by_year":[{"year":2015,"cited_by_count":2}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}