{"id":"https://openalex.org/W2159433976","doi":"https://doi.org/10.1109/vlhcc.2009.5295255","title":"Discovery-based edit assistance for spreadsheets","display_name":"Discovery-based edit assistance for spreadsheets","publication_year":2009,"publication_date":"2009-09-01","ids":{"openalex":"https://openalex.org/W2159433976","doi":"https://doi.org/10.1109/vlhcc.2009.5295255","mag":"2159433976"},"language":"en","primary_location":{"id":"doi:10.1109/vlhcc.2009.5295255","is_oa":false,"landing_page_url":"https://doi.org/10.1109/vlhcc.2009.5295255","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2009 IEEE Symposium on Visual Languages and Human-Centric Computing (VL/HCC)","raw_type":"proceedings-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"http://hdl.handle.net/1822/36478","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5042720932","display_name":"J\u00e1come Cunha","orcid":"https://orcid.org/0000-0002-4713-3834"},"institutions":[{"id":"https://openalex.org/I99682543","display_name":"University of Minho","ror":"https://ror.org/037wpkx04","country_code":"PT","type":"education","lineage":["https://openalex.org/I99682543"]}],"countries":["PT"],"is_corresponding":true,"raw_author_name":"Jacome Cunha","raw_affiliation_strings":["Departamento de Inform\u00e1tica, Universidade do Minho, Portugal"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Departamento de Inform\u00e1tica, Universidade do Minho, Portugal","institution_ids":["https://openalex.org/I99682543"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5087190575","display_name":"Jo\u00e3o Saraiva","orcid":"https://orcid.org/0000-0002-5686-7151"},"institutions":[{"id":"https://openalex.org/I99682543","display_name":"University of Minho","ror":"https://ror.org/037wpkx04","country_code":"PT","type":"education","lineage":["https://openalex.org/I99682543"]}],"countries":["PT"],"is_corresponding":false,"raw_author_name":"Joao Saraiva","raw_affiliation_strings":["Departamento de Inform\u00e1tica, Universidade do Minho, Portugal"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Departamento de Inform\u00e1tica, Universidade do Minho, Portugal","institution_ids":["https://openalex.org/I99682543"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5049830358","display_name":"Joost Visser","orcid":"https://orcid.org/0000-0003-0158-3095"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Joost Visser","raw_affiliation_strings":["Software Improvement Group, Netherlands"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Software Improvement Group, Netherlands","institution_ids":[]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":3,"corresponding_author_ids":["https://openalex.org/A5042720932"],"corresponding_institution_ids":["https://openalex.org/I99682543"],"apc_list":null,"apc_paid":null,"fwci":5.6872,"has_fulltext":false,"cited_by_count":22,"citation_normalized_percentile":{"value":0.9628026,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":89,"max":98},"biblio":{"volume":null,"issue":null,"first_page":"233","last_page":"237"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T13197","display_name":"Spreadsheets and End-User Computing","score":0.9998999834060669,"subfield":{"id":"https://openalex.org/subfields/1712","display_name":"Software"},"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/T13197","display_name":"Spreadsheets and End-User Computing","score":0.9998999834060669,"subfield":{"id":"https://openalex.org/subfields/1712","display_name":"Software"},"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.9496999979019165,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8590289950370789},{"id":"https://openalex.org/keywords/schema","display_name":"Schema (genetic algorithms)","score":0.6211464405059814},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.5174099206924438},{"id":"https://openalex.org/keywords/database-schema","display_name":"Database schema","score":0.48797839879989624},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.4632941484451294},{"id":"https://openalex.org/keywords/redundancy","display_name":"Redundancy (engineering)","score":0.4290688633918762},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.357957124710083},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.348782479763031},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.2103726863861084},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.08284196257591248}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8590289950370789},{"id":"https://openalex.org/C52146309","wikidata":"https://www.wikidata.org/wiki/Q7431116","display_name":"Schema (genetic algorithms)","level":2,"score":0.6211464405059814},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.5174099206924438},{"id":"https://openalex.org/C30775581","wikidata":"https://www.wikidata.org/wiki/Q632285","display_name":"Database schema","level":3,"score":0.48797839879989624},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.4632941484451294},{"id":"https://openalex.org/C152124472","wikidata":"https://www.wikidata.org/wiki/Q1204361","display_name":"Redundancy (engineering)","level":2,"score":0.4290688633918762},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.357957124710083},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.348782479763031},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.2103726863861084},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.08284196257591248}],"mesh":[],"locations_count":4,"locations":[{"id":"doi:10.1109/vlhcc.2009.5295255","is_oa":false,"landing_page_url":"https://doi.org/10.1109/vlhcc.2009.5295255","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2009 IEEE Symposium on Visual Languages and Human-Centric Computing (VL/HCC)","raw_type":"proceedings-article"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.158.873","is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.158.873","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://alfa.di.uminho.pt/~jacome/down/vl-hcc09.pdf","raw_type":"text"},{"id":"pmh:oai:repositorium.sdum.uminho.pt:1822/36478","is_oa":true,"landing_page_url":"http://hdl.handle.net/1822/36478","pdf_url":null,"source":{"id":"https://openalex.org/S4306400354","display_name":"Reposit\u00f3riUM (Universidade do Minho)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I99682543","host_organization_name":"University of Minho","host_organization_lineage":["https://openalex.org/I99682543"],"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":"","raw_type":"conference paper"},{"id":"pmh:oai:repositorium.uminho.pt:1822/36478","is_oa":true,"landing_page_url":"https://hdl.handle.net/1822/36478","pdf_url":null,"source":{"id":"https://openalex.org/S4306402433","display_name":"Portuguese National Funding Agency for Science, Research and Technology (RCAAP Project by FCT)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"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":"conference paper"}],"best_oa_location":{"id":"pmh:oai:repositorium.sdum.uminho.pt:1822/36478","is_oa":true,"landing_page_url":"http://hdl.handle.net/1822/36478","pdf_url":null,"source":{"id":"https://openalex.org/S4306400354","display_name":"Reposit\u00f3riUM (Universidade do Minho)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I99682543","host_organization_name":"University of Minho","host_organization_lineage":["https://openalex.org/I99682543"],"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":"","raw_type":"conference paper"},"sustainable_development_goals":[{"score":0.8100000023841858,"id":"https://metadata.un.org/sdg/16","display_name":"Peace, Justice and strong institutions"}],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":22,"referenced_works":["https://openalex.org/W1497542708","https://openalex.org/W1551326568","https://openalex.org/W1575391024","https://openalex.org/W1584239167","https://openalex.org/W1667690396","https://openalex.org/W1970665021","https://openalex.org/W2006426998","https://openalex.org/W2080901110","https://openalex.org/W2084119909","https://openalex.org/W2107686020","https://openalex.org/W2119723190","https://openalex.org/W2125223317","https://openalex.org/W2135473121","https://openalex.org/W2138709157","https://openalex.org/W2173934156","https://openalex.org/W2185907055","https://openalex.org/W2396777345","https://openalex.org/W2988119170","https://openalex.org/W3127391999","https://openalex.org/W3148954569","https://openalex.org/W4232172855","https://openalex.org/W6634863115"],"related_works":["https://openalex.org/W2031508292","https://openalex.org/W2079588361","https://openalex.org/W2460926837","https://openalex.org/W1545286006","https://openalex.org/W52829598","https://openalex.org/W2774489303","https://openalex.org/W2336519490","https://openalex.org/W2748090995","https://openalex.org/W223556604","https://openalex.org/W2356754926"],"abstract_inverted_index":{"Spreadsheets":[0],"can":[1,64],"be":[2,65],"viewed":[3],"as":[4],"a":[5,92],"highly":[6],"flexible":[7],"end-users":[8],"programming":[9,22,26],"environment":[10],"which":[11,87],"enjoys":[12],"wide-spread":[13],"adoption.":[14],"But":[15],"spreadsheets":[16,36],"lack":[17,31],"many":[18],"of":[19,24,32,47,61,81,91],"the":[20,30,79,107,129],"structured":[21],"concepts":[23],"regular":[25],"paradigms.":[27],"In":[28,52],"particular,":[29],"data":[33,48,63,85],"structures":[34],"in":[35,128],"may":[37],"lead":[38],"spreadsheet":[39,62,72,108,122],"users":[40],"to":[41,67,71,109],"cause":[42],"redundancy,":[43],"loss,":[44],"or":[45],"corruption":[46],"during":[49],"edit":[50,69],"actions.":[51],"this":[53,97],"paper,":[54],"we":[55],"demonstrate":[56],"how":[57],"implicit":[58],"structural":[59],"properties":[60],"exploited":[66],"offer":[68,110],"assistance":[70],"users.":[73],"Our":[74],"approach":[75],"is":[76],"based":[77],"on":[78],"discovery":[80,120],"functional":[82],"dependencies":[83],"among":[84],"items":[86],"allow":[88],"automatic":[89],"reconstruction":[90],"relational":[93],"database":[94],"schema.":[95],"From":[96],"schema,":[98],"new":[99],"formulas":[100],"and":[101,116,121,131],"visual":[102],"objects":[103],"are":[104,124],"embedded":[105],"into":[106],"features":[111],"for":[112],"auto-completion,":[113],"guarded":[114],"deletion,":[115],"controlled":[117],"insertion.":[118],"Schema":[119],"enhancement":[123],"carried":[125],"out":[126],"automatically":[127],"background":[130],"do":[132],"not":[133],"disturb":[134],"normal":[135],"user":[136],"experience.":[137]},"counts_by_year":[{"year":2021,"cited_by_count":1},{"year":2016,"cited_by_count":1},{"year":2014,"cited_by_count":5},{"year":2013,"cited_by_count":2},{"year":2012,"cited_by_count":5}],"updated_date":"2026-05-19T08:33:51.333923","created_date":"2025-10-10T00:00:00"}