{"id":"https://openalex.org/W2123854425","doi":"https://doi.org/10.1109/icdew.2011.5767654","title":"Autonomous workload-driven reorganization of column groupings in MMDBS","display_name":"Autonomous workload-driven reorganization of column groupings in MMDBS","publication_year":2011,"publication_date":"2011-04-01","ids":{"openalex":"https://openalex.org/W2123854425","doi":"https://doi.org/10.1109/icdew.2011.5767654","mag":"2123854425"},"language":"en","primary_location":{"id":"doi:10.1109/icdew.2011.5767654","is_oa":false,"landing_page_url":"https://doi.org/10.1109/icdew.2011.5767654","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2011 IEEE 27th International Conference on Data Engineering Workshops","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/A5024712151","display_name":"Felix Beier","orcid":null},"institutions":[{"id":"https://openalex.org/I119449181","display_name":"Technische Universit\u00e4t Ilmenau","ror":"https://ror.org/01weqhp73","country_code":"DE","type":"education","lineage":["https://openalex.org/I119449181"]}],"countries":["DE"],"is_corresponding":true,"raw_author_name":"Felix Beier","raw_affiliation_strings":["Ilmenau University of Technology, Germany","Ilmenau University of Technology , Germany"],"affiliations":[{"raw_affiliation_string":"Ilmenau University of Technology, Germany","institution_ids":["https://openalex.org/I119449181"]},{"raw_affiliation_string":"Ilmenau University of Technology , Germany","institution_ids":["https://openalex.org/I119449181"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5069015137","display_name":"Knut Stolze","orcid":null},"institutions":[{"id":"https://openalex.org/I4210095996","display_name":"IBM (Germany)","ror":"https://ror.org/00pm7rm97","country_code":"DE","type":"company","lineage":["https://openalex.org/I1341412227","https://openalex.org/I4210095996"]},{"id":"https://openalex.org/I1341412227","display_name":"IBM (United States)","ror":"https://ror.org/05hh8d621","country_code":"US","type":"company","lineage":["https://openalex.org/I1341412227"]}],"countries":["DE","US"],"is_corresponding":false,"raw_author_name":"Knut Stolze","raw_affiliation_strings":["IBM Research and Development, Boblingen, Germany","IBM Research and Development,B\u00f6blingen,Germany"],"affiliations":[{"raw_affiliation_string":"IBM Research and Development, Boblingen, Germany","institution_ids":["https://openalex.org/I4210095996"]},{"raw_affiliation_string":"IBM Research and Development,B\u00f6blingen,Germany","institution_ids":["https://openalex.org/I1341412227"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5068875440","display_name":"Kai-Uwe Sattler","orcid":"https://orcid.org/0000-0003-1608-7721"},"institutions":[{"id":"https://openalex.org/I119449181","display_name":"Technische Universit\u00e4t Ilmenau","ror":"https://ror.org/01weqhp73","country_code":"DE","type":"education","lineage":["https://openalex.org/I119449181"]}],"countries":["DE"],"is_corresponding":false,"raw_author_name":"Kai-Uwe Sattler","raw_affiliation_strings":["Ilmenau University of Technology, Germany","Ilmenau University of Technology , Germany"],"affiliations":[{"raw_affiliation_string":"Ilmenau University of Technology, Germany","institution_ids":["https://openalex.org/I119449181"]},{"raw_affiliation_string":"Ilmenau University of Technology , Germany","institution_ids":["https://openalex.org/I119449181"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":3,"corresponding_author_ids":["https://openalex.org/A5024712151"],"corresponding_institution_ids":["https://openalex.org/I119449181"],"apc_list":null,"apc_paid":null,"fwci":0.7002,"has_fulltext":false,"cited_by_count":2,"citation_normalized_percentile":{"value":0.73666967,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":94},"biblio":{"volume":"28","issue":null,"first_page":"22","last_page":"27"},"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/T10538","display_name":"Data Mining Algorithms and Applications","score":0.9995999932289124,"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/T11269","display_name":"Algorithms and Data Compression","score":0.9993000030517578,"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/computer-science","display_name":"Computer science","score":0.8604296445846558},{"id":"https://openalex.org/keywords/overhead","display_name":"Overhead (engineering)","score":0.6829362511634827},{"id":"https://openalex.org/keywords/workload","display_name":"Workload","score":0.6237813830375671},{"id":"https://openalex.org/keywords/column","display_name":"Column (typography)","score":0.585641622543335},{"id":"https://openalex.org/keywords/cache","display_name":"Cache","score":0.5849573612213135},{"id":"https://openalex.org/keywords/exploit","display_name":"Exploit","score":0.5154255628585815},{"id":"https://openalex.org/keywords/data-warehouse","display_name":"Data warehouse","score":0.455645889043808},{"id":"https://openalex.org/keywords/data-structure","display_name":"Data structure","score":0.4454876184463501},{"id":"https://openalex.org/keywords/spark","display_name":"SPARK (programming language)","score":0.43352964520454407},{"id":"https://openalex.org/keywords/trace","display_name":"TRACE (psycholinguistics)","score":0.41860872507095337},{"id":"https://openalex.org/keywords/query-plan","display_name":"Query plan","score":0.412637859582901},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.38796067237854004},{"id":"https://openalex.org/keywords/parallel-computing","display_name":"Parallel computing","score":0.2818833589553833},{"id":"https://openalex.org/keywords/web-search-query","display_name":"Web search query","score":0.17783960700035095},{"id":"https://openalex.org/keywords/search-engine","display_name":"Search engine","score":0.1777595579624176},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.1748729944229126},{"id":"https://openalex.org/keywords/sargable","display_name":"Sargable","score":0.13370168209075928},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.1278451681137085}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8604296445846558},{"id":"https://openalex.org/C2779960059","wikidata":"https://www.wikidata.org/wiki/Q7113681","display_name":"Overhead (engineering)","level":2,"score":0.6829362511634827},{"id":"https://openalex.org/C2778476105","wikidata":"https://www.wikidata.org/wiki/Q628539","display_name":"Workload","level":2,"score":0.6237813830375671},{"id":"https://openalex.org/C2780551164","wikidata":"https://www.wikidata.org/wiki/Q2306599","display_name":"Column (typography)","level":3,"score":0.585641622543335},{"id":"https://openalex.org/C115537543","wikidata":"https://www.wikidata.org/wiki/Q165596","display_name":"Cache","level":2,"score":0.5849573612213135},{"id":"https://openalex.org/C165696696","wikidata":"https://www.wikidata.org/wiki/Q11287","display_name":"Exploit","level":2,"score":0.5154255628585815},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.455645889043808},{"id":"https://openalex.org/C162319229","wikidata":"https://www.wikidata.org/wiki/Q175263","display_name":"Data structure","level":2,"score":0.4454876184463501},{"id":"https://openalex.org/C2781215313","wikidata":"https://www.wikidata.org/wiki/Q3493345","display_name":"SPARK (programming language)","level":2,"score":0.43352964520454407},{"id":"https://openalex.org/C75291252","wikidata":"https://www.wikidata.org/wiki/Q1315756","display_name":"TRACE (psycholinguistics)","level":2,"score":0.41860872507095337},{"id":"https://openalex.org/C2779729312","wikidata":"https://www.wikidata.org/wiki/Q784232","display_name":"Query plan","level":5,"score":0.412637859582901},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.38796067237854004},{"id":"https://openalex.org/C173608175","wikidata":"https://www.wikidata.org/wiki/Q232661","display_name":"Parallel computing","level":1,"score":0.2818833589553833},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.17783960700035095},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.1777595579624176},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.1748729944229126},{"id":"https://openalex.org/C192939062","wikidata":"https://www.wikidata.org/wiki/Q104840822","display_name":"Sargable","level":4,"score":0.13370168209075928},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.1278451681137085},{"id":"https://openalex.org/C41895202","wikidata":"https://www.wikidata.org/wiki/Q8162","display_name":"Linguistics","level":1,"score":0.0},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.0},{"id":"https://openalex.org/C38652104","wikidata":"https://www.wikidata.org/wiki/Q3510521","display_name":"Computer security","level":1,"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/C76155785","wikidata":"https://www.wikidata.org/wiki/Q418","display_name":"Telecommunications","level":1,"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/icdew.2011.5767654","is_oa":false,"landing_page_url":"https://doi.org/10.1109/icdew.2011.5767654","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2011 IEEE 27th International Conference on Data Engineering Workshops","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[{"id":"https://metadata.un.org/sdg/9","score":0.47999998927116394,"display_name":"Industry, innovation and infrastructure"}],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":21,"referenced_works":["https://openalex.org/W30948595","https://openalex.org/W620525741","https://openalex.org/W1515347377","https://openalex.org/W1873909800","https://openalex.org/W2005112390","https://openalex.org/W2038523137","https://openalex.org/W2100542992","https://openalex.org/W2109626831","https://openalex.org/W2115482638","https://openalex.org/W2116420167","https://openalex.org/W2124851765","https://openalex.org/W2130642985","https://openalex.org/W2143125604","https://openalex.org/W2171543585","https://openalex.org/W2950999996","https://openalex.org/W3138367763","https://openalex.org/W4235712778","https://openalex.org/W6601287923","https://openalex.org/W6630649040","https://openalex.org/W6638231387","https://openalex.org/W6679817081"],"related_works":["https://openalex.org/W1975949872","https://openalex.org/W3159871278","https://openalex.org/W2230552005","https://openalex.org/W2905242764","https://openalex.org/W3109411864","https://openalex.org/W3017846737","https://openalex.org/W2099525665","https://openalex.org/W4379407450","https://openalex.org/W3003280185","https://openalex.org/W2613379984"],"abstract_inverted_index":{"A":[0],"current":[1,113],"trend":[2],"to":[3,18,42,78,125,163],"achieve":[4],"high":[5],"query":[6,58,81,165],"performance":[7,59],"even":[8,84],"for":[9,64],"huge":[10],"data":[11,30,38,51,67],"warehouse":[12],"and":[13,28,35,48,57],"business":[14],"intelligence":[15],"systems":[16],"is":[17,172],"exploit":[19],"main-memory-based":[20],"processing":[21,34],"techniques":[22],"such":[23,45],"as":[24],"compression,":[25],"cache-conscious":[26],"strategies,":[27],"optimized":[29],"structures.":[31,102],"However,":[32],"update":[33],"skews":[36],"in":[37,44,76,99,111,137],"distribution":[39],"might":[40],"lead":[41],"degenerations":[43],"densely":[46],"packed":[47],"highly":[49],"compressed":[50],"structures":[52,68,160],"affecting":[53],"the":[54,93,112,156],"memory":[55,170],"efficiency":[56],"negatively.":[60],"Thus,":[61],"reorganization":[62],"tasks":[63,127],"repairing":[65],"these":[66],"are":[69],"necessary":[70],"but":[71],"should":[72],"be":[73,123],"carefully":[74],"applied":[75],"order":[77],"not":[79],"impact":[80],"execution":[82],"or":[83],"system":[85],"availability":[86],"significantly.":[87],"In":[88],"this":[89,135],"paper,":[90],"we":[91,115],"consider":[92],"special":[94],"problem":[95],"of":[96,145,155],"tuple":[97],"layout":[98],"banked":[100],"storage":[101],"Based":[103],"on":[104],"runtime":[105],"statistics":[106],"capturing":[107],"typical":[108],"access":[109],"patterns":[110],"workload,":[114],"present":[116],"a":[117,151,168],"bank":[118],"reassignment":[119],"approach":[120,136],"that":[121,150],"can":[122],"piggybacked":[124],"maintenance":[126],"without":[128],"any":[129],"administration":[130],"overhead.":[131],"We":[132],"have":[133],"implemented":[134],"IBM":[138],"Smart":[139],"Analytics":[140],"Optimizer":[141],"(ISAOPT).":[142],"The":[143],"results":[144],"our":[146],"experimental":[147],"evaluation":[148],"show":[149],"simple":[152],"automatic":[153],"restructuring":[154],"considered":[157],"hybrid":[158],"row-column-store":[159],"offers":[161],"opportunities":[162],"improve":[164],"runtimes":[166],"when":[167],"slight":[169],"overhead":[171],"acceptable.":[173]},"counts_by_year":[{"year":2013,"cited_by_count":1},{"year":2012,"cited_by_count":1}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}