{"id":"https://openalex.org/W1971568552","doi":"https://doi.org/10.1145/1866480.1866510","title":"How to juggle columns","display_name":"How to juggle columns","publication_year":2010,"publication_date":"2010-01-01","ids":{"openalex":"https://openalex.org/W1971568552","doi":"https://doi.org/10.1145/1866480.1866510","mag":"1971568552"},"language":"en","primary_location":{"id":"doi:10.1145/1866480.1866510","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1866480.1866510","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the Fourteenth International Database Engineering & Applications Symposium on - IDEAS '10","raw_type":"proceedings-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"https://tud.qucosa.de/id/qucosa%3A80503","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5032969324","display_name":"Marcus Paradies","orcid":"https://orcid.org/0000-0002-5743-6580"},"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":true,"raw_author_name":"Marcus Paradies","raw_affiliation_strings":["SAP AG, Walldorf, Germany"],"affiliations":[{"raw_affiliation_string":"SAP AG, Walldorf, Germany","institution_ids":["https://openalex.org/I4210132444"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5029886576","display_name":"Christian Lemke","orcid":null},"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,"raw_author_name":"Christian Lemke","raw_affiliation_strings":["SAP AG, Walldorf, Germany"],"affiliations":[{"raw_affiliation_string":"SAP AG, Walldorf, Germany","institution_ids":["https://openalex.org/I4210132444"]}]},{"author_position":"middle","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-Inst., Potsdam, Germany]"],"affiliations":[{"raw_affiliation_string":"[Hasso-Plattner-Inst., Potsdam, Germany]","institution_ids":["https://openalex.org/I143288331"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5063512642","display_name":"Wolfgang Lehner","orcid":"https://orcid.org/0000-0001-8107-2775"},"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,"raw_author_name":"Wolfgang Lehner","raw_affiliation_strings":["SAP AG, Walldorf, Germany"],"affiliations":[{"raw_affiliation_string":"SAP AG, Walldorf, Germany","institution_ids":["https://openalex.org/I4210132444"]}]},{"author_position":"middle","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 Ilmenau Germany#TAB#"],"affiliations":[{"raw_affiliation_string":"Ilmenau University of Technology Ilmenau Germany#TAB#","institution_ids":["https://openalex.org/I119449181"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5011720172","display_name":"Alexander Zeier","orcid":"https://orcid.org/0000-0003-1717-5029"},"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":"Alexander Zeier","raw_affiliation_strings":["[Hasso-Plattner-Inst., Potsdam, Germany]"],"affiliations":[{"raw_affiliation_string":"[Hasso-Plattner-Inst., Potsdam, Germany]","institution_ids":["https://openalex.org/I143288331"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5070535766","display_name":"Jens Krueger","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":"Jens Krueger","raw_affiliation_strings":["[Hasso-Plattner-Inst., Potsdam, Germany]"],"affiliations":[{"raw_affiliation_string":"[Hasso-Plattner-Inst., Potsdam, Germany]","institution_ids":["https://openalex.org/I143288331"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":7,"corresponding_author_ids":["https://openalex.org/A5032969324"],"corresponding_institution_ids":["https://openalex.org/I4210132444"],"apc_list":null,"apc_paid":null,"fwci":2.6372,"has_fulltext":false,"cited_by_count":15,"citation_normalized_percentile":{"value":0.89655711,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":98},"biblio":{"volume":null,"issue":null,"first_page":"205","last_page":"215"},"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.9991999864578247,"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/T11719","display_name":"Data Quality and Management","score":0.9976000189781189,"subfield":{"id":"https://openalex.org/subfields/1803","display_name":"Management Science and Operations Research"},"field":{"id":"https://openalex.org/fields/18","display_name":"Decision Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.47229745984077454}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.47229745984077454}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.1145/1866480.1866510","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1866480.1866510","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the Fourteenth International Database Engineering & Applications Symposium on - IDEAS '10","raw_type":"proceedings-article"},{"id":"pmh:oai:qucosa:de:qucosa:80503","is_oa":true,"landing_page_url":"https://tud.qucosa.de/id/qucosa%3A80503","pdf_url":null,"source":{"id":"https://openalex.org/S4377196312","display_name":"Qucosa (Saxon State and University Library Dresden)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I3132420320","host_organization_name":"SLUB Dresden","host_organization_lineage":["https://openalex.org/I3132420320"],"host_organization_lineage_names":[],"type":"repository"},"license":"other-oa","license_id":"https://openalex.org/licenses/other-oa","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"doc-type:Text"}],"best_oa_location":{"id":"pmh:oai:qucosa:de:qucosa:80503","is_oa":true,"landing_page_url":"https://tud.qucosa.de/id/qucosa%3A80503","pdf_url":null,"source":{"id":"https://openalex.org/S4377196312","display_name":"Qucosa (Saxon State and University Library Dresden)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I3132420320","host_organization_name":"SLUB Dresden","host_organization_lineage":["https://openalex.org/I3132420320"],"host_organization_lineage_names":[],"type":"repository"},"license":"other-oa","license_id":"https://openalex.org/licenses/other-oa","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"doc-type:Text"},"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":24,"referenced_works":["https://openalex.org/W1510305954","https://openalex.org/W1781748254","https://openalex.org/W1971568552","https://openalex.org/W1995875735","https://openalex.org/W2001947543","https://openalex.org/W2060091058","https://openalex.org/W2082092506","https://openalex.org/W2097580994","https://openalex.org/W2098932141","https://openalex.org/W2102489964","https://openalex.org/W2120108467","https://openalex.org/W2123838014","https://openalex.org/W2153230306","https://openalex.org/W2170587835","https://openalex.org/W2170653744","https://openalex.org/W2317912355","https://openalex.org/W2510474575","https://openalex.org/W2913793034","https://openalex.org/W2993383518","https://openalex.org/W4229625360","https://openalex.org/W4233471163","https://openalex.org/W4233559841","https://openalex.org/W4241441866","https://openalex.org/W4250331264"],"related_works":["https://openalex.org/W2899084033","https://openalex.org/W2748952813","https://openalex.org/W2390279801","https://openalex.org/W2358668433","https://openalex.org/W2376932109","https://openalex.org/W2382290278","https://openalex.org/W2350741829","https://openalex.org/W2130043461","https://openalex.org/W2530322880","https://openalex.org/W1596801655"],"abstract_inverted_index":{"Many":[0],"relational":[1],"databases":[2],"exhibit":[3],"complex":[4],"dependencies":[5,86,120],"between":[6,87],"data":[7,17,24,50,127],"attributes,":[8],"caused":[9],"either":[10],"by":[11,19,182],"the":[12,15,48,80,91,177,188,203],"nature":[13],"of":[14,83,112,159,172,179,184,205],"underlying":[16],"or":[18,33],"explicitly":[20],"denormalized":[21],"schemas.":[22],"In":[23,75],"warehouse":[25],"scenarios,":[26],"calculated":[27],"key":[28],"figures":[29],"may":[30,36,52,59],"be":[31,37],"materialized":[32],"hierarchy":[34],"levels":[35],"held":[38],"within":[39,187],"a":[40,109,157,169],"single":[41],"dimension":[42],"table.":[43],"Such":[44],"column":[45,119],"correlations":[46],"and":[47,104,129,143,155,161,207,218],"resulting":[49],"redundancy":[51],"result":[53,61],"in":[54,62,121,132],"additional":[55],"storage":[56],"requirements.":[57],"They":[58],"also":[60],"bad":[63],"query":[64,73,106],"performance":[65,220],"if":[66],"inappropriate":[67],"independence":[68],"assumptions":[69],"are":[70],"made":[71],"during":[72],"compilation.":[74],"this":[76],"paper,":[77],"we":[78,123],"tackle":[79],"specific":[81],"problem":[82],"detecting":[84,118],"functional":[85],"columns":[88,206],"to":[89,164],"improve":[90],"compression":[92],"rate":[93],"for":[94,117,168,221],"column-based":[95],"database":[96],"systems,":[97],"which":[98],"both":[99,214],"reduces":[100,215],"main":[101],"memory":[102,145,216],"consumption":[103,217],"improves":[105,219],"performance.":[107],"Although":[108],"huge":[110],"variety":[111],"algorithms":[113,137],"have":[114],"been":[115],"proposed":[116],"databases,":[122],"maintain":[124],"that":[125,197],"increased":[126],"volumes":[128],"recent":[130],"developments":[131],"hardware":[133],"architectures":[134],"demand":[135],"novel":[136,148],"with":[138,202],"much":[139],"lower":[140],"runtime":[141],"overhead":[142],"smaller":[144],"footprint.":[146],"Our":[147,194],"approach":[149,181,199],"is":[150],"based":[151],"on":[152],"entropy":[153],"estimations":[154],"exploits":[156],"combination":[158],"sampling":[160],"multiple":[162],"heuristics":[163],"render":[165],"it":[166],"applicable":[167],"wide":[170],"range":[171],"use":[173],"cases.":[174],"We":[175],"demonstrate":[176],"quality":[178],"our":[180,198],"means":[183],"an":[185],"implementation":[186],"SAP":[189],"NetWeaver":[190],"Business":[191],"Warehouse":[192],"Accelerator.":[193],"experiments":[195],"indicate":[196],"scales":[200],"well":[201],"number":[204],"produces":[208],"reliable":[209],"dependence":[210],"structure":[211],"information.":[212],"This":[213],"nontrivial":[222],"queries.":[223]},"counts_by_year":[{"year":2024,"cited_by_count":1},{"year":2022,"cited_by_count":1},{"year":2021,"cited_by_count":1},{"year":2019,"cited_by_count":1},{"year":2016,"cited_by_count":3},{"year":2015,"cited_by_count":1},{"year":2012,"cited_by_count":4}],"updated_date":"2026-03-20T23:20:44.827607","created_date":"2025-10-10T00:00:00"}