{"id":"https://openalex.org/W2558012959","doi":"https://doi.org/10.1145/3035918.3035930","title":"Wide Table Layout Optimization based on Column Ordering and Duplication","display_name":"Wide Table Layout Optimization based on Column Ordering and Duplication","publication_year":2017,"publication_date":"2017-05-09","ids":{"openalex":"https://openalex.org/W2558012959","doi":"https://doi.org/10.1145/3035918.3035930","mag":"2558012959"},"language":"en","primary_location":{"id":"doi:10.1145/3035918.3035930","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3035918.3035930","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2017 ACM International Conference on Management of 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/A5066724170","display_name":"Haoqiong Bian","orcid":"https://orcid.org/0000-0001-5144-4427"},"institutions":[{"id":"https://openalex.org/I78988378","display_name":"Renmin University of China","ror":"https://ror.org/041pakw92","country_code":"CN","type":"education","lineage":["https://openalex.org/I78988378"]}],"countries":["CN"],"is_corresponding":true,"raw_author_name":"Haoqiong Bian","raw_affiliation_strings":["Renmin University of China, Beijing, China"],"affiliations":[{"raw_affiliation_string":"Renmin University of China, Beijing, China","institution_ids":["https://openalex.org/I78988378"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5100451656","display_name":"Ying Yan","orcid":"https://orcid.org/0009-0003-3890-6238"},"institutions":[{"id":"https://openalex.org/I4210113369","display_name":"Microsoft Research Asia (China)","ror":"https://ror.org/0300m5276","country_code":"CN","type":"company","lineage":["https://openalex.org/I1290206253","https://openalex.org/I4210113369"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Ying Yan","raw_affiliation_strings":["Microsoft Research, Beijing, China"],"affiliations":[{"raw_affiliation_string":"Microsoft Research, Beijing, China","institution_ids":["https://openalex.org/I4210113369"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5018442175","display_name":"Wenbo Tao","orcid":null},"institutions":[{"id":"https://openalex.org/I63966007","display_name":"Massachusetts Institute of Technology","ror":"https://ror.org/042nb2s44","country_code":"US","type":"education","lineage":["https://openalex.org/I63966007"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Wenbo Tao","raw_affiliation_strings":["Massachusetts Institute of Technology, Cambridge, MA, USA"],"affiliations":[{"raw_affiliation_string":"Massachusetts Institute of Technology, Cambridge, MA, USA","institution_ids":["https://openalex.org/I63966007"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5044762054","display_name":"Liang Jeff Chen","orcid":null},"institutions":[{"id":"https://openalex.org/I4210113369","display_name":"Microsoft Research Asia (China)","ror":"https://ror.org/0300m5276","country_code":"CN","type":"company","lineage":["https://openalex.org/I1290206253","https://openalex.org/I4210113369"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Liang Jeff Chen","raw_affiliation_strings":["Microsoft Research, Beijing, China"],"affiliations":[{"raw_affiliation_string":"Microsoft Research, Beijing, China","institution_ids":["https://openalex.org/I4210113369"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5057384573","display_name":"Yueguo Chen","orcid":"https://orcid.org/0000-0003-2720-7135"},"institutions":[{"id":"https://openalex.org/I78988378","display_name":"Renmin University of China","ror":"https://ror.org/041pakw92","country_code":"CN","type":"education","lineage":["https://openalex.org/I78988378"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Yueguo Chen","raw_affiliation_strings":["Renmin University of China, Beijing, China"],"affiliations":[{"raw_affiliation_string":"Renmin University of China, Beijing, China","institution_ids":["https://openalex.org/I78988378"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5008721449","display_name":"Xiaoyong Du","orcid":"https://orcid.org/0000-0002-5757-9135"},"institutions":[{"id":"https://openalex.org/I78988378","display_name":"Renmin University of China","ror":"https://ror.org/041pakw92","country_code":"CN","type":"education","lineage":["https://openalex.org/I78988378"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Xiaoyong Du","raw_affiliation_strings":["Renmin University of China, Beijing, China"],"affiliations":[{"raw_affiliation_string":"Renmin University of China, Beijing, China","institution_ids":["https://openalex.org/I78988378"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5041937385","display_name":"Thomas Moscibroda","orcid":"https://orcid.org/0000-0002-8729-7841"},"institutions":[{"id":"https://openalex.org/I4210113369","display_name":"Microsoft Research Asia (China)","ror":"https://ror.org/0300m5276","country_code":"CN","type":"company","lineage":["https://openalex.org/I1290206253","https://openalex.org/I4210113369"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Thomas Moscibroda","raw_affiliation_strings":["Microsoft Research, Beijing, China"],"affiliations":[{"raw_affiliation_string":"Microsoft Research, Beijing, China","institution_ids":["https://openalex.org/I4210113369"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":7,"corresponding_author_ids":["https://openalex.org/A5066724170"],"corresponding_institution_ids":["https://openalex.org/I78988378"],"apc_list":null,"apc_paid":null,"fwci":3.5004,"has_fulltext":false,"cited_by_count":29,"citation_normalized_percentile":{"value":0.93423,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":90,"max":99},"biblio":{"volume":null,"issue":null,"first_page":"299","last_page":"314"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11181","display_name":"Advanced Data Storage Technologies","score":0.9998000264167786,"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/T11181","display_name":"Advanced Data Storage Technologies","score":0.9998000264167786,"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/T10317","display_name":"Advanced Database Systems and Queries","score":0.9986000061035156,"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.9972000122070312,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/column","display_name":"Column (typography)","score":0.919337272644043},{"id":"https://openalex.org/keywords/partition","display_name":"Partition (number theory)","score":0.686310887336731},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.6803773641586304},{"id":"https://openalex.org/keywords/redundancy","display_name":"Redundancy (engineering)","score":0.5524486899375916},{"id":"https://openalex.org/keywords/table","display_name":"Table (database)","score":0.497074156999588},{"id":"https://openalex.org/keywords/column-generation","display_name":"Column generation","score":0.48730671405792236},{"id":"https://openalex.org/keywords/workload","display_name":"Workload","score":0.4852306842803955},{"id":"https://openalex.org/keywords/row-and-column-spaces","display_name":"Row and column spaces","score":0.4315694570541382},{"id":"https://openalex.org/keywords/parallel-computing","display_name":"Parallel computing","score":0.32820260524749756},{"id":"https://openalex.org/keywords/row","display_name":"Row","score":0.32555490732192993},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.2435818314552307},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.2168104350566864},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.17204442620277405},{"id":"https://openalex.org/keywords/mathematical-optimization","display_name":"Mathematical optimization","score":0.11960703134536743}],"concepts":[{"id":"https://openalex.org/C2780551164","wikidata":"https://www.wikidata.org/wiki/Q2306599","display_name":"Column (typography)","level":3,"score":0.919337272644043},{"id":"https://openalex.org/C42812","wikidata":"https://www.wikidata.org/wiki/Q1082910","display_name":"Partition (number theory)","level":2,"score":0.686310887336731},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.6803773641586304},{"id":"https://openalex.org/C152124472","wikidata":"https://www.wikidata.org/wiki/Q1204361","display_name":"Redundancy (engineering)","level":2,"score":0.5524486899375916},{"id":"https://openalex.org/C45235069","wikidata":"https://www.wikidata.org/wiki/Q278425","display_name":"Table (database)","level":2,"score":0.497074156999588},{"id":"https://openalex.org/C168956720","wikidata":"https://www.wikidata.org/wiki/Q3123181","display_name":"Column generation","level":2,"score":0.48730671405792236},{"id":"https://openalex.org/C2778476105","wikidata":"https://www.wikidata.org/wiki/Q628539","display_name":"Workload","level":2,"score":0.4852306842803955},{"id":"https://openalex.org/C104140500","wikidata":"https://www.wikidata.org/wiki/Q2088159","display_name":"Row and column spaces","level":3,"score":0.4315694570541382},{"id":"https://openalex.org/C173608175","wikidata":"https://www.wikidata.org/wiki/Q232661","display_name":"Parallel computing","level":1,"score":0.32820260524749756},{"id":"https://openalex.org/C135598885","wikidata":"https://www.wikidata.org/wiki/Q1366302","display_name":"Row","level":2,"score":0.32555490732192993},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.2435818314552307},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.2168104350566864},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.17204442620277405},{"id":"https://openalex.org/C126255220","wikidata":"https://www.wikidata.org/wiki/Q141495","display_name":"Mathematical optimization","level":1,"score":0.11960703134536743},{"id":"https://openalex.org/C76155785","wikidata":"https://www.wikidata.org/wiki/Q418","display_name":"Telecommunications","level":1,"score":0.0},{"id":"https://openalex.org/C114614502","wikidata":"https://www.wikidata.org/wiki/Q76592","display_name":"Combinatorics","level":1,"score":0.0},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","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}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/3035918.3035930","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3035918.3035930","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2017 ACM International Conference on Management of 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":44,"referenced_works":["https://openalex.org/W46131467","https://openalex.org/W108855261","https://openalex.org/W1444968430","https://openalex.org/W1551329015","https://openalex.org/W1973124645","https://openalex.org/W1981988185","https://openalex.org/W1986342384","https://openalex.org/W1993892970","https://openalex.org/W1998271633","https://openalex.org/W2003243598","https://openalex.org/W2005112390","https://openalex.org/W2024060531","https://openalex.org/W2035355147","https://openalex.org/W2039795745","https://openalex.org/W2039910065","https://openalex.org/W2047094503","https://openalex.org/W2071989194","https://openalex.org/W2085601491","https://openalex.org/W2098935637","https://openalex.org/W2103412498","https://openalex.org/W2106867122","https://openalex.org/W2114854276","https://openalex.org/W2117546628","https://openalex.org/W2130642985","https://openalex.org/W2133741724","https://openalex.org/W2137156898","https://openalex.org/W2144839430","https://openalex.org/W2146461854","https://openalex.org/W2158865579","https://openalex.org/W2168395296","https://openalex.org/W2169188831","https://openalex.org/W2170853664","https://openalex.org/W2171543585","https://openalex.org/W2172220707","https://openalex.org/W2189465200","https://openalex.org/W2293019624","https://openalex.org/W2412976325","https://openalex.org/W2490890137","https://openalex.org/W2995564009","https://openalex.org/W3022584652","https://openalex.org/W6628517261","https://openalex.org/W6629757243","https://openalex.org/W6679817081","https://openalex.org/W6687322159"],"related_works":["https://openalex.org/W1595177583","https://openalex.org/W3122721839","https://openalex.org/W4281399881","https://openalex.org/W2049527672","https://openalex.org/W2257455891","https://openalex.org/W1612626642","https://openalex.org/W1656875537","https://openalex.org/W1570877974","https://openalex.org/W2005695153","https://openalex.org/W1986055680"],"abstract_inverted_index":{"Modern":[0],"data":[1,29,200],"analytical":[2,35],"tasks":[3],"often":[4],"witness":[5],"very":[6],"wide":[7,32,57],"tables,":[8],"from":[9],"a":[10,15,49,63,173,180],"few":[11,16],"hundred":[12],"columns":[13,41,61,140],"to":[14,89,97,104,146],"thousand.":[17],"While":[18],"it":[19],"is":[20],"commonly":[21],"agreed":[22],"that":[23,138,171,189],"column":[24,74,102,114,118,121,132,135,156,166,181],"stores":[25,115],"are":[26],"an":[27,100,126,160],"appropriate":[28],"format":[30],"for":[31,83,113,165],"tables":[33,58],"and":[34,120,168,178,201],"workloads,":[36],"the":[37,60,84,90,150,155,192,206,209],"physical":[38],"order":[39,129],"of":[40,86,130,208],"has":[42],"not":[43],"been":[44],"investigated.":[45],"Column":[46,123],"ordering":[47,75,119,124,136,182],"plays":[48],"critical":[50],"role":[51],"in":[52,56,62,137,212],"I/O":[53,106,194],"performance,":[54],"because":[55],"accessing":[59],"single":[64],"horizontal":[65],"partition":[66],"may":[67,141],"involve":[68],"multiple":[69,144],"disk":[70,80],"seeks.":[71],"An":[72],"optimal":[73,101,128],"will":[76],"incur":[77],"minimal":[78],"cumulative":[79],"seek":[81],"costs":[82],"set":[85],"queries":[87],"applied":[88],"data.":[91],"In":[92],"this":[93],"paper,":[94],"we":[95,109],"aim":[96],"find":[98],"such":[99],"layout":[103],"maximize":[105],"performance.":[107,195],"Specifically,":[108],"study":[110],"two":[111],"problems":[112],"on":[116,154],"HDFS:":[117],"duplication.":[122],"seeks":[125],"approximately":[127],"columns;":[131],"duplication":[133],"complements":[134],"some":[139],"be":[142],"duplicated":[143],"times":[145],"reduce":[147],"contention":[148],"among":[149],"queries'":[151],"diverse":[152,213],"requirements":[153],"order.":[157],"We":[158],"consider":[159],"actual":[161],"fine-grained":[162],"cost":[163],"model":[164],"accesses":[167],"propose":[169],"algorithms":[170,211],"take":[172],"query":[174,203],"workload":[175],"as":[176],"input":[177],"output":[179],"strategy":[183],"with":[184],"or":[185],"without":[186],"storage":[187],"redundancy":[188],"significantly":[190],"improves":[191],"overall":[193],"Experimental":[196],"results":[197],"over":[198],"real-life":[199],"production":[202],"workloads":[204],"confirm":[205],"effectiveness":[207],"proposed":[210],"settings.":[214]},"counts_by_year":[{"year":2026,"cited_by_count":1},{"year":2024,"cited_by_count":3},{"year":2023,"cited_by_count":3},{"year":2022,"cited_by_count":3},{"year":2021,"cited_by_count":3},{"year":2020,"cited_by_count":4},{"year":2019,"cited_by_count":4},{"year":2018,"cited_by_count":7},{"year":2017,"cited_by_count":1}],"updated_date":"2026-03-17T09:09:15.849793","created_date":"2025-10-10T00:00:00"}