{"id":"https://openalex.org/W2167486417","doi":"https://doi.org/10.1145/1978942.1979313","title":"A spreadsheet-based user interface for managing plural relationships in structured data","display_name":"A spreadsheet-based user interface for managing plural relationships in structured data","publication_year":2011,"publication_date":"2011-05-07","ids":{"openalex":"https://openalex.org/W2167486417","doi":"https://doi.org/10.1145/1978942.1979313","mag":"2167486417"},"language":"en","primary_location":{"id":"doi:10.1145/1978942.1979313","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1978942.1979313","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the SIGCHI Conference on Human Factors in Computing Systems","raw_type":"proceedings-article"},"type":"conference-paper","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"http://hdl.handle.net/1721.1/63075","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5035069592","display_name":"Eirik Bakke","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":"Eirik Bakke","raw_affiliation_strings":["Massachusetts Institute of Technology, Cambridge, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Massachusetts Institute of Technology, Cambridge, USA","institution_ids":["https://openalex.org/I63966007"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5028448267","display_name":"David R. Karger","orcid":"https://orcid.org/0000-0002-0024-5847"},"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":"David Karger","raw_affiliation_strings":["Massachusetts Institute of Technology, Cambridge, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Massachusetts Institute of Technology, Cambridge, USA","institution_ids":["https://openalex.org/I63966007"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5000689705","display_name":"Rob Miller","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":"Rob Miller","raw_affiliation_strings":["Massachusetts Institute of Technology, Cambridge, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Massachusetts Institute of Technology, Cambridge, USA","institution_ids":["https://openalex.org/I63966007"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":[],"corresponding_institution_ids":["https://openalex.org/I63966007"],"apc_list":null,"apc_paid":null,"fwci":null,"has_fulltext":false,"cited_by_count":26,"citation_normalized_percentile":null,"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":"2541","last_page":"2550"},"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.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/T10317","display_name":"Advanced Database Systems and Queries","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/T11106","display_name":"Data Management and Algorithms","score":0.9940000176429749,"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/T10799","display_name":"Data Visualization and Analytics","score":0.9930999875068665,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8618004322052002},{"id":"https://openalex.org/keywords/usability","display_name":"Usability","score":0.6229356527328491},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.5967849493026733},{"id":"https://openalex.org/keywords/plural","display_name":"Plural","score":0.5771516561508179},{"id":"https://openalex.org/keywords/database-schema","display_name":"Database schema","score":0.5485081672668457},{"id":"https://openalex.org/keywords/schema","display_name":"Schema (genetic algorithms)","score":0.5450220108032227},{"id":"https://openalex.org/keywords/row","display_name":"Row","score":0.49253425002098083},{"id":"https://openalex.org/keywords/software","display_name":"Software","score":0.4243479371070862},{"id":"https://openalex.org/keywords/table","display_name":"Table (database)","score":0.4243384003639221},{"id":"https://openalex.org/keywords/user-interface","display_name":"User interface","score":0.4138178825378418},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.38631707429885864},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.3852617144584656},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.3254479169845581},{"id":"https://openalex.org/keywords/human\u2013computer-interaction","display_name":"Human\u2013computer interaction","score":0.27424225211143494},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.24879488348960876}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8618004322052002},{"id":"https://openalex.org/C170130773","wikidata":"https://www.wikidata.org/wiki/Q216378","display_name":"Usability","level":2,"score":0.6229356527328491},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.5967849493026733},{"id":"https://openalex.org/C2779835924","wikidata":"https://www.wikidata.org/wiki/Q146786","display_name":"Plural","level":2,"score":0.5771516561508179},{"id":"https://openalex.org/C30775581","wikidata":"https://www.wikidata.org/wiki/Q632285","display_name":"Database schema","level":3,"score":0.5485081672668457},{"id":"https://openalex.org/C52146309","wikidata":"https://www.wikidata.org/wiki/Q7431116","display_name":"Schema (genetic algorithms)","level":2,"score":0.5450220108032227},{"id":"https://openalex.org/C135598885","wikidata":"https://www.wikidata.org/wiki/Q1366302","display_name":"Row","level":2,"score":0.49253425002098083},{"id":"https://openalex.org/C2777904410","wikidata":"https://www.wikidata.org/wiki/Q7397","display_name":"Software","level":2,"score":0.4243479371070862},{"id":"https://openalex.org/C45235069","wikidata":"https://www.wikidata.org/wiki/Q278425","display_name":"Table (database)","level":2,"score":0.4243384003639221},{"id":"https://openalex.org/C89505385","wikidata":"https://www.wikidata.org/wiki/Q47146","display_name":"User interface","level":2,"score":0.4138178825378418},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.38631707429885864},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.3852617144584656},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.3254479169845581},{"id":"https://openalex.org/C107457646","wikidata":"https://www.wikidata.org/wiki/Q207434","display_name":"Human\u2013computer interaction","level":1,"score":0.27424225211143494},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.24879488348960876},{"id":"https://openalex.org/C41895202","wikidata":"https://www.wikidata.org/wiki/Q8162","display_name":"Linguistics","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":5,"locations":[{"id":"doi:10.1145/1978942.1979313","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1978942.1979313","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the SIGCHI Conference on Human Factors in Computing Systems","raw_type":"proceedings-article"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.207.9667","is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.207.9667","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://www.mit.edu/%7Eebakke/research/related_worksheets_chi2011.pdf","raw_type":"text"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.208.287","is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.208.287","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://groups.csail.mit.edu/haystack/documents/papers/2011/related_worksheets_chi2011.pdf","raw_type":"text"},{"id":"pmh:oai:dspace.mit.edu:1721.1/63075","is_oa":true,"landing_page_url":"http://hdl.handle.net/1721.1/63075","pdf_url":null,"source":{"id":"https://openalex.org/S4306400425","display_name":"DSpace@MIT (Massachusetts Institute of Technology)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I63966007","host_organization_name":"Massachusetts Institute of Technology","host_organization_lineage":["https://openalex.org/I63966007"],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by-nc","license_id":"https://openalex.org/licenses/cc-by-nc","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"Thesis"},{"id":"pmh:oai:dspace.mit.edu:1721.1/72375","is_oa":true,"landing_page_url":"http://hdl.handle.net/1721.1/72375","pdf_url":null,"source":{"id":"https://openalex.org/S4306400425","display_name":"DSpace@MIT (Massachusetts Institute of Technology)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I63966007","host_organization_name":"Massachusetts Institute of Technology","host_organization_lineage":["https://openalex.org/I63966007"],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by-nc-sa","license_id":"https://openalex.org/licenses/cc-by-nc-sa","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"MIT web domain","raw_type":"http://purl.org/eprint/type/ConferencePaper"}],"best_oa_location":{"id":"pmh:oai:dspace.mit.edu:1721.1/63075","is_oa":true,"landing_page_url":"http://hdl.handle.net/1721.1/63075","pdf_url":null,"source":{"id":"https://openalex.org/S4306400425","display_name":"DSpace@MIT (Massachusetts Institute of Technology)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I63966007","host_organization_name":"Massachusetts Institute of Technology","host_organization_lineage":["https://openalex.org/I63966007"],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by-nc","license_id":"https://openalex.org/licenses/cc-by-nc","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"Thesis"},"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":13,"referenced_works":["https://openalex.org/W761923450","https://openalex.org/W2018223116","https://openalex.org/W2021589354","https://openalex.org/W2058797051","https://openalex.org/W2103219113","https://openalex.org/W2130914060","https://openalex.org/W2131932522","https://openalex.org/W2144192824","https://openalex.org/W2150704968","https://openalex.org/W2160382748","https://openalex.org/W2160801510","https://openalex.org/W2232207765","https://openalex.org/W2945526390"],"related_works":["https://openalex.org/W2153455914","https://openalex.org/W325713583","https://openalex.org/W4375869232","https://openalex.org/W1501673548","https://openalex.org/W4309137527","https://openalex.org/W2512945146","https://openalex.org/W2460926837","https://openalex.org/W2031508292","https://openalex.org/W2079588361","https://openalex.org/W2000469556"],"abstract_inverted_index":{"A":[0],"key":[1],"feature":[2],"of":[3,122],"relational":[4,65],"database":[5,26,66],"applications":[6,67],"is":[7,17],"managing":[8],"\\emph{plural}":[9],"relationships---one-to-many":[10],"and":[11,63,88,107],"many-to-many---between":[12],"entities.":[13],"However,":[14],"since":[15],"it":[16,109],"often":[18],"infeasible":[19],"to":[20,38,44,56,73,127],"adopt":[21],"or":[22,135],"develop":[23],"a":[24,97,103,111],"new":[25],"application":[27],"for":[28],"any":[29],"given":[30],"schema":[31],"at":[32],"hand,":[33],"information":[34],"workers":[35],"instead":[36],"turn":[37],"spreadsheets,":[39],"which":[40],"lend":[41],"themselves":[42],"poorly":[43],"schemas":[45],"requiring":[46],"multiple":[47],"related":[48,82],"entity":[49],"sets.":[50],"In":[51],"this":[52],"paper,":[53],"we":[54],"propose":[55],"reduce":[57],"the":[58,70,75,90,133],"cost-usability":[59],"gap":[60],"between":[61,79],"spreadsheets":[62],"tailor-made":[64],"by":[68],"extending":[69],"spreadsheet":[71],"paradigm":[72],"let":[74],"user":[76,113],"establish":[77],"relationships":[78],"rows":[80],"in":[81,143],"worksheets":[83],"as":[84,86,96,138],"well":[85],"view":[87],"navigate":[89],"hierarchical":[91],"cell":[92],"structure":[93],"that":[94],"arises":[95],"result.":[98],"We":[99],"present":[100],"Related":[101],"Worksheets,":[102],"spreadsheet-like":[104],"prototype":[105],"application,":[106],"evaluate":[108],"with":[110,132],"screencast-based":[112],"study":[114],"on":[115,148],"36":[116],"Mechanical":[117],"Turk":[118],"workers.":[119],"First-time":[120],"users":[121],"our":[123],"software":[124],"were":[125],"able":[126],"solve":[128],"lookup-type":[129],"query":[130],"tasks":[131],"same":[134],"higher":[136],"accuracy":[137],"subjects":[139],"using":[140],"Microsoft":[141],"Excel,":[142],"one":[144],"case":[145],"40%":[146],"faster":[147],"average.":[149]},"counts_by_year":[{"year":2025,"cited_by_count":2},{"year":2023,"cited_by_count":1},{"year":2022,"cited_by_count":1},{"year":2021,"cited_by_count":1},{"year":2020,"cited_by_count":1},{"year":2019,"cited_by_count":1},{"year":2018,"cited_by_count":4},{"year":2016,"cited_by_count":6},{"year":2015,"cited_by_count":1},{"year":2014,"cited_by_count":3},{"year":2013,"cited_by_count":4}],"updated_date":"2026-07-14T23:27:15.235271","created_date":"2025-10-10T00:00:00"}