{"id":"https://openalex.org/W2005179875","doi":"https://doi.org/10.1109/bigdata.2013.6691616","title":"Fast OLAP query execution in main memory on large data in a cluster","display_name":"Fast OLAP query execution in main memory on large data in a cluster","alternate_titles":[],"publication_year":2013,"publication_date":"2013-10-01","ids":{"openalex":"https://openalex.org/W2005179875","doi":"https://doi.org/10.1109/bigdata.2013.6691616","mag":"2005179875"},"language":"en","primary_location":{"id":"doi:10.1109/bigdata.2013.6691616","doi":"https://doi.org/10.1109/bigdata.2013.6691616","is_oa":false,"landing_page_url":"https://doi.org/10.1109/bigdata.2013.6691616","pdf_url":null,"source":{"id":"https://openalex.org/S4363607709","display_name":"IEEE International Conference on Big Data (BigData)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/P4310319808","host_organization_name":"Institute of Electrical and Electronics Engineers","host_organization_lineage":["https://openalex.org/P4310319808"],"host_organization_lineage_names":["Institute of Electrical and Electronics Engineers"],"type":"conference"},"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"},"parent_works":[],"lineage":["https://openalex.org/W2005179875"],"child_works_count":0,"type":"conference-paper","is_traditional":true,"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":null,"display_name":"Martin Weidner","orcid":null,"observed_orcids":[]},"institutions":[{"id":"https://openalex.org/I4210132444","display_name":"Systems, Applications & Products in Data Processing (Germany)","ror":"https://ror.org/03dsc8d33","country_code":"DE","type":"company","lineage":["https://openalex.org/I4210132444"]}],"countries":["DE"],"is_corresponding":false,"contributor_roles":[],"raw_author_name":"Martin Weidner","raw_affiliation_strings":["SAP AG, Walldorf, Germany"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"SAP AG, Walldorf, Germany","institution_ids":["https://openalex.org/I4210132444"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5009168177","display_name":"Jonathan Dees","orcid":null,"observed_orcids":[]},"institutions":[{"id":"https://openalex.org/I102335020","display_name":"Karlsruhe Institute of Technology","ror":"https://ror.org/04t3en479","country_code":"DE","type":"education","lineage":["https://openalex.org/I102335020","https://openalex.org/I1305996414"]},{"id":"https://openalex.org/I4210132444","display_name":"Systems, Applications & Products in Data Processing (Germany)","ror":"https://ror.org/03dsc8d33","country_code":"DE","type":"company","lineage":["https://openalex.org/I4210132444"]}],"countries":["DE"],"is_corresponding":false,"contributor_roles":[],"raw_author_name":"Jonathan Dees","raw_affiliation_strings":["Karlsruhe Institute of Technology, Karlsruhe, Germany","SAP AG, Walldorf, Germany"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Karlsruhe Institute of Technology, Karlsruhe, Germany","institution_ids":["https://openalex.org/I102335020"]},{"raw_affiliation_string":"SAP AG, Walldorf, Germany","institution_ids":["https://openalex.org/I4210132444"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5082922326","display_name":"Peter Sanders","orcid":"https://orcid.org/0000-0003-3330-9349","observed_orcids":["https://orcid.org/0000-0003-3330-9349"]},"institutions":[{"id":"https://openalex.org/I102335020","display_name":"Karlsruhe Institute of Technology","ror":"https://ror.org/04t3en479","country_code":"DE","type":"education","lineage":["https://openalex.org/I102335020","https://openalex.org/I1305996414"]}],"countries":["DE"],"is_corresponding":false,"contributor_roles":[],"raw_author_name":"Peter Sanders","raw_affiliation_strings":["Karlsruhe Institute of Technology, Karlsruhe, Germany","Karlsruhe Institute of Technology, Karlsruhe,#N#Germany"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Karlsruhe Institute of Technology, Karlsruhe, Germany","institution_ids":["https://openalex.org/I102335020"]},{"raw_affiliation_string":"Karlsruhe Institute of Technology, Karlsruhe,#N#Germany","institution_ids":["https://openalex.org/I102335020"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":2.2327,"has_fulltext":false,"cited_by_count":17,"citation_normalized_percentile":{"value":0.88289676,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":87,"max":98},"biblio":{"volume":null,"issue":null,"first_page":"518","last_page":"524"},"is_retracted":false,"is_pulled":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9916999936103821,"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"}},"topics":[{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9916999936103821,"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"}},{"id":"https://openalex.org/T10054","display_name":"Parallel Computing and Optimization Techniques","score":0.003599999938160181,"subfield":{"id":"https://openalex.org/subfields/1708","display_name":"Hardware and Architecture"},"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.0006000000284984708,"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/olap-query-processing","display_name":"OLAP query processing","score":0.8309999704360962},{"id":"https://openalex.org/keywords/inter-node-communication","display_name":"inter-node communication","score":0.7770000100135803},{"id":"https://openalex.org/keywords/tpc-h-benchmark","display_name":"TPC-H benchmark","score":0.8769999742507935},{"id":"https://openalex.org/keywords/large-data-sets","display_name":"large data sets","score":0.6290000081062317}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8879401683807373},{"id":"https://openalex.org/C201932085","wikidata":"https://www.wikidata.org/wiki/Q642514","display_name":"Online analytical processing","level":3,"score":0.6973692178726196},{"id":"https://openalex.org/C62611344","wikidata":"https://www.wikidata.org/wiki/Q1062658","display_name":"Node (physics)","level":2,"score":0.5319331884384155},{"id":"https://openalex.org/C2779343474","wikidata":"https://www.wikidata.org/wiki/Q3109175","display_name":"Context (archaeology)","level":2,"score":0.5303478837013245},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.5120609402656555},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.5110732316970825},{"id":"https://openalex.org/C164866538","wikidata":"https://www.wikidata.org/wiki/Q367351","display_name":"Cluster (spacecraft)","level":2,"score":0.48006901144981384},{"id":"https://openalex.org/C185798385","wikidata":"https://www.wikidata.org/wiki/Q1161707","display_name":"Benchmark (surveying)","level":2,"score":0.4720768928527832},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.4682159423828125},{"id":"https://openalex.org/C173608175","wikidata":"https://www.wikidata.org/wiki/Q232661","display_name":"Parallel computing","level":1,"score":0.46746826171875},{"id":"https://openalex.org/C120314980","wikidata":"https://www.wikidata.org/wiki/Q180634","display_name":"Distributed computing","level":1,"score":0.3361775875091553},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.3261062800884247},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.11123600602149963},{"id":"https://openalex.org/C13280743","wikidata":"https://www.wikidata.org/wiki/Q131089","display_name":"Geodesy","level":1,"score":0.0},{"id":"https://openalex.org/C127413603","wikidata":"https://www.wikidata.org/wiki/Q11023","display_name":"Engineering","level":0,"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},{"id":"https://openalex.org/C205649164","wikidata":"https://www.wikidata.org/wiki/Q1071","display_name":"Geography","level":0,"score":0.0},{"id":"https://openalex.org/C66938386","wikidata":"https://www.wikidata.org/wiki/Q633538","display_name":"Structural engineering","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1109/bigdata.2013.6691616","doi":"https://doi.org/10.1109/bigdata.2013.6691616","is_oa":false,"landing_page_url":"https://doi.org/10.1109/bigdata.2013.6691616","pdf_url":null,"source":{"id":"https://openalex.org/S4363607709","display_name":"IEEE International Conference on Big Data (BigData)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/P4310319808","host_organization_name":"Institute of Electrical and Electronics Engineers","host_organization_lineage":["https://openalex.org/P4310319808"],"host_organization_lineage_names":["Institute of Electrical and Electronics Engineers"],"type":"conference"},"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":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":31,"referenced_works":["https://openalex.org/W1482997398","https://openalex.org/W1528326260","https://openalex.org/W1536852470","https://openalex.org/W1571563640","https://openalex.org/W1584639770","https://openalex.org/W1587227579","https://openalex.org/W1814428676","https://openalex.org/W1867390120","https://openalex.org/W1902354325","https://openalex.org/W1909964791","https://openalex.org/W1921087388","https://openalex.org/W1987875246","https://openalex.org/W1997020216","https://openalex.org/W2036853599","https://openalex.org/W2037394610","https://openalex.org/W2063663576","https://openalex.org/W2071009745","https://openalex.org/W2100444372","https://openalex.org/W2102729946","https://openalex.org/W2105079611","https://openalex.org/W2106771621","https://openalex.org/W2116400826","https://openalex.org/W2117848638","https://openalex.org/W2134206624","https://openalex.org/W2137259192","https://openalex.org/W2139541761","https://openalex.org/W2165900899","https://openalex.org/W2173080636","https://openalex.org/W3139669840","https://openalex.org/W4246367117","https://openalex.org/W4285719527"],"related_works":["https://openalex.org/W2137259192","https://openalex.org/W2585489975","https://openalex.org/W1571563640","https://openalex.org/W2784237011","https://openalex.org/W7137995479","https://openalex.org/W2057906139","https://openalex.org/W2141088026","https://openalex.org/W2588093701","https://openalex.org/W45109438","https://openalex.org/W2905683124"],"abstract_inverted_index":{"Main":[0],"memory":[1,45],"column-stores":[2],"have":[3],"proven":[4],"to":[5,38,61,170,172],"be":[6],"efficient":[7,73,103,116],"for":[8,72,102,126,159],"processing":[9,55],"analytical":[10,76],"queries.":[11,133],"Still,":[12],"there":[13,153],"has":[14],"been":[15],"little":[16],"work":[17],"in":[18,84,123,138],"the":[19,39,54,94,113,180],"context":[20],"of":[21,41,56,75,82,93,130,149,164,175],"clusters.":[22],"Using":[23],"only":[24],"a":[25,62,85,124,128,139],"single":[26,109],"machine":[27],"poses":[28],"several":[29],"restrictions:":[30],"Processing":[31],"power":[32],"and":[33,43,111,115],"data":[34,58,83],"volume":[35],"are":[36,154],"bounded":[37],"number":[40],"cores":[42],"main":[44],"fitting":[46],"on":[47,79,108],"one":[48,171],"tightly":[49],"coupled":[50],"system.":[51],"To":[52],"enable":[53],"larger":[57],"sets,":[59],"switching":[60],"cluster":[63,88,142,157],"becomes":[64],"necessary.":[65],"In":[66],"this":[67],"work,":[68],"we":[69,167],"explore":[70],"techniques":[71],"execution":[74],"SQL":[77],"queries":[78,145],"large":[80],"amounts":[81],"parallel":[86],"database":[87],"while":[89],"making":[90],"maximal":[91],"use":[92],"available":[95],"hardware.":[96],"This":[97],"includes":[98],"precompiled":[99],"query":[100],"plans":[101],"CPU":[104],"utilization,":[105],"full":[106],"parallelization":[107],"nodes":[110],"across":[112],"cluster,":[114],"inter-node":[117],"communication.":[118],"We":[119,134],"implement":[120],"all":[121],"features":[122],"prototype":[125],"running":[127,143],"subset":[129],"TPC-H":[131,144],"benchmark":[132],"evaluate":[135],"our":[136],"implementation":[137],"128":[140],"node":[141],"with":[146],"30000":[147],"gigabyte":[148,163],"uncompressed":[150],"data.":[151],"Currently,":[152],"no":[155],"official":[156],"results":[158],"more":[160],"than":[161,179],"10000":[162],"data,":[165],"where":[166],"achieve":[168],"up":[169],"two":[173],"orders":[174],"magnitudes":[176],"better":[177],"performance":[178],"current":[181],"record":[182],"holder.":[183]},"cited_by_api_url":"https://api.openalex.org/works?filter=cites:W2005179875","counts_by_year":[{"year":2024,"cited_by_count":1},{"year":2021,"cited_by_count":1},{"year":2018,"cited_by_count":2},{"year":2017,"cited_by_count":2},{"year":2016,"cited_by_count":4},{"year":2015,"cited_by_count":4},{"year":2014,"cited_by_count":3}],"updated_date":"2026-11-16T12:05:36.265796","created_date":"2016-06-24T00:00:00"}
