{"id":"https://openalex.org/W4404181059","doi":"https://doi.org/10.14778/3685800.3685861","title":"Utopia: Automatic Pivot Table Assistant","display_name":"Utopia: Automatic Pivot Table Assistant","publication_year":2024,"publication_date":"2024-08-01","ids":{"openalex":"https://openalex.org/W4404181059","doi":"https://doi.org/10.14778/3685800.3685861"},"language":"en","primary_location":{"id":"doi:10.14778/3685800.3685861","is_oa":false,"landing_page_url":"https://doi.org/10.14778/3685800.3685861","pdf_url":null,"source":{"id":"https://openalex.org/S4210226185","display_name":"Proceedings of the VLDB Endowment","issn_l":"2150-8097","issn":["2150-8097"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the VLDB Endowment","raw_type":"journal-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/A5029144793","display_name":"Whanhee Cho","orcid":"https://orcid.org/0000-0003-2069-4508"},"institutions":[{"id":"https://openalex.org/I223532165","display_name":"University of Utah","ror":"https://ror.org/03r0ha626","country_code":"US","type":"education","lineage":["https://openalex.org/I223532165"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"Whanhee Cho","raw_affiliation_strings":["University of Utah, Salt Lake City, Utah, USA"],"affiliations":[{"raw_affiliation_string":"University of Utah, Salt Lake City, Utah, USA","institution_ids":["https://openalex.org/I223532165"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5087503380","display_name":"Anna Fariha","orcid":"https://orcid.org/0000-0002-5275-7844"},"institutions":[{"id":"https://openalex.org/I223532165","display_name":"University of Utah","ror":"https://ror.org/03r0ha626","country_code":"US","type":"education","lineage":["https://openalex.org/I223532165"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Anna Fariha","raw_affiliation_strings":["University of Utah, Salt Lake City, Utah, USA"],"affiliations":[{"raw_affiliation_string":"University of Utah, Salt Lake City, Utah, USA","institution_ids":["https://openalex.org/I223532165"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":["https://openalex.org/A5029144793"],"corresponding_institution_ids":["https://openalex.org/I223532165"],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":false,"cited_by_count":0,"citation_normalized_percentile":{"value":0.20398097,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":"17","issue":"12","first_page":"4305","last_page":"4308"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11714","display_name":"Multimodal Machine Learning Applications","score":0.961899995803833,"subfield":{"id":"https://openalex.org/subfields/1707","display_name":"Computer Vision and Pattern Recognition"},"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/T11714","display_name":"Multimodal Machine Learning Applications","score":0.961899995803833,"subfield":{"id":"https://openalex.org/subfields/1707","display_name":"Computer Vision and Pattern Recognition"},"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/T10603","display_name":"Smart Grid Energy Management","score":0.9150999784469604,"subfield":{"id":"https://openalex.org/subfields/2208","display_name":"Electrical and Electronic Engineering"},"field":{"id":"https://openalex.org/fields/22","display_name":"Engineering"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/table","display_name":"Table (database)","score":0.7165090441703796},{"id":"https://openalex.org/keywords/utopia","display_name":"Utopia","score":0.5946002006530762},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.4725235104560852},{"id":"https://openalex.org/keywords/engineering-drawing","display_name":"Engineering drawing","score":0.351756751537323},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.34144139289855957},{"id":"https://openalex.org/keywords/computer-graphics","display_name":"Computer graphics (images)","score":0.3390886187553406},{"id":"https://openalex.org/keywords/art","display_name":"Art","score":0.22731941938400269},{"id":"https://openalex.org/keywords/engineering","display_name":"Engineering","score":0.22702538967132568},{"id":"https://openalex.org/keywords/art-history","display_name":"Art history","score":0.17375007271766663}],"concepts":[{"id":"https://openalex.org/C45235069","wikidata":"https://www.wikidata.org/wiki/Q278425","display_name":"Table (database)","level":2,"score":0.7165090441703796},{"id":"https://openalex.org/C2775944640","wikidata":"https://www.wikidata.org/wiki/Q131156","display_name":"Utopia","level":2,"score":0.5946002006530762},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.4725235104560852},{"id":"https://openalex.org/C199639397","wikidata":"https://www.wikidata.org/wiki/Q1788588","display_name":"Engineering drawing","level":1,"score":0.351756751537323},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.34144139289855957},{"id":"https://openalex.org/C121684516","wikidata":"https://www.wikidata.org/wiki/Q7600677","display_name":"Computer graphics (images)","level":1,"score":0.3390886187553406},{"id":"https://openalex.org/C142362112","wikidata":"https://www.wikidata.org/wiki/Q735","display_name":"Art","level":0,"score":0.22731941938400269},{"id":"https://openalex.org/C127413603","wikidata":"https://www.wikidata.org/wiki/Q11023","display_name":"Engineering","level":0,"score":0.22702538967132568},{"id":"https://openalex.org/C52119013","wikidata":"https://www.wikidata.org/wiki/Q50637","display_name":"Art history","level":1,"score":0.17375007271766663}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.14778/3685800.3685861","is_oa":false,"landing_page_url":"https://doi.org/10.14778/3685800.3685861","pdf_url":null,"source":{"id":"https://openalex.org/S4210226185","display_name":"Proceedings of the VLDB Endowment","issn_l":"2150-8097","issn":["2150-8097"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the VLDB Endowment","raw_type":"journal-article"}],"best_oa_location":null,"sustainable_development_goals":[{"id":"https://metadata.un.org/sdg/4","display_name":"Quality Education","score":0.6499999761581421}],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":7,"referenced_works":["https://openalex.org/W2587580284","https://openalex.org/W2970641574","https://openalex.org/W3156636935","https://openalex.org/W3187846328","https://openalex.org/W4379390733","https://openalex.org/W4386128178","https://openalex.org/W4389523621"],"related_works":["https://openalex.org/W2107252084","https://openalex.org/W2496523032","https://openalex.org/W2796012734","https://openalex.org/W2529069304","https://openalex.org/W1532381672","https://openalex.org/W2359643047","https://openalex.org/W3209165130","https://openalex.org/W2619349061","https://openalex.org/W2562072674","https://openalex.org/W2067803813"],"abstract_inverted_index":{"Data":[0],"summarization":[1],"is":[2,19,54,140],"required":[3],"to":[4,13,22,119,121,206,233],"comprehend":[5],"large":[6],"datasets,":[7],"and":[8,30,44,62,82,107,111,132,171,189,198,203],"aggregations":[9],"are":[10,34,73],"effective":[11,219],"ways":[12],"summarize":[14],"data.":[15],"A":[16,154],"pivot":[17,32,105,162,177,220],"table":[18,153,221],"a":[20,76,141,148],"mechanism":[21],"aggregate":[23,45],"numerical":[24],"attributes":[25,29,58,116,170,188],"grouped":[26],"by":[27,183],"categorical":[28],"spreadsheet":[31,52,161,238],"tables":[33,178],"particularly":[35],"suitable":[36],"for":[37,101],"novices,":[38],"where":[39],"they":[40],"can":[41,85],"rearrange,":[42],"group,":[43],"data":[46,53,97,165,195,228],"using":[47],"intuitive":[48],"interfaces.":[49],"However,":[50],"real-world":[51],"often":[55],"disorganized,":[56],"with":[57],"having":[59],"multiple":[60,71],"values":[61],"synonymous":[63,134,172,208],"variants.":[64,173],"For":[65],"instance,":[66],"in":[67,88,109,235],"the":[68,158,191],"IMDb":[69],"data,":[70],"genres":[72],"stored":[74],"as":[75,168],"comma-separated":[77],"value":[78],"(\"Action,":[79],"Comedy,":[80],"Drama\")":[81],"\"Science":[83],"Fiction\"":[84],"be":[86],"represented":[87],"various":[89],"ways:":[90],"\"Sci-Fi\",":[91],"\"scifi\",":[92],"\"Technological":[93],"Fiction\",":[94],"etc.":[95],"Such":[96],"issues":[98,166],"pose":[99],"barriers":[100],"novices":[102,225],"while":[103,230],"constructing":[104],"tables,":[106,163],"result":[108],"noisy":[110],"incomprehensible":[112],"summarization.":[113],"Parsing":[114],"multi-valued":[115,169,187],"forces":[117],"users":[118],"resort":[120],"external":[122,242],"tools":[123,243],"(Power":[124],"Query)":[125],"or":[126,244],"methods":[127],"(Python),":[128],"requiring":[129,180,241],"additional":[130,181,245],"expertise;":[131],"consolidating":[133],"variants":[135],"demand":[136],"manual":[137],"effort,":[138],"which":[139],"tedious":[142,227],"task.":[143],"We":[144,213],"introduce":[145],"Utopia,":[146],"an":[147],"UTO":[149],"matic":[150],"PI":[151],"vot":[152],"ssistant":[155],"that":[156],"extends":[157],"functionality":[159],"of":[160],"overcoming":[164],"such":[167],"Utopia":[174,217],"helps":[175],"construct":[176],"without":[179,240],"expertise":[182],"(1)":[184],"automatically":[185],"detecting":[186],"organizing":[190],"values,":[192],"achieving":[193],"implicit":[194],"normalization":[196],",":[197],"(2)":[199],"leveraging":[200],"SimCSE":[201],"embeddings":[202],"K-Means":[204],"clustering":[205],"consolidate":[207],"variants,":[209],"enabling":[210],"semantic":[211],"aggregation.":[212],"will":[214],"demonstrate":[215],"how":[216],"enables":[218],"construction,":[222],"relieving":[223],"technical":[224],"from":[226],"preprocessing":[229],"allowing":[231],"them":[232],"remain":[234],"their":[236],"familiar":[237],"environment,":[239],"expertise.":[246]},"counts_by_year":[],"updated_date":"2025-12-27T23:08:20.325037","created_date":"2025-10-10T00:00:00"}