{"id":"https://openalex.org/W2117565756","doi":"https://doi.org/10.1007/s10515-014-0167-x","title":"Model inference for spreadsheets","display_name":"Model inference for spreadsheets","publication_year":2014,"publication_date":"2014-09-02","ids":{"openalex":"https://openalex.org/W2117565756","doi":"https://doi.org/10.1007/s10515-014-0167-x","mag":"2117565756"},"language":"en","primary_location":{"id":"doi:10.1007/s10515-014-0167-x","is_oa":false,"landing_page_url":"https://doi.org/10.1007/s10515-014-0167-x","pdf_url":null,"source":{"id":"https://openalex.org/S4210177399","display_name":"Automated Software Engineering","issn_l":"0928-8910","issn":["0928-8910","1573-7535"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319900","host_organization_name":"Springer Science+Business Media","host_organization_lineage":["https://openalex.org/P4310319900","https://openalex.org/P4310319965"],"host_organization_lineage_names":["Springer Science+Business Media","Springer Nature"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Automated Software Engineering","raw_type":"journal-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"http://repositorio.inesctec.pt/handle/123456789/5416","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/I83558840","display_name":"Universidade Nova de Lisboa","ror":"https://ror.org/02xankh89","country_code":"PT","type":"education","lineage":["https://openalex.org/I83558840"]},{"id":"https://openalex.org/I4210125590","display_name":"Institute for Systems Engineering and Computers","ror":"https://ror.org/033wn8m60","country_code":"PT","type":"nonprofit","lineage":["https://openalex.org/I4210125590"]}],"countries":["PT"],"is_corresponding":true,"raw_author_name":"J\u00e1come Cunha","raw_affiliation_strings":["Department of Informatics, HASLab/INESC Tec & Universidade Nova de Lisboa, Lisbon, Portugal"],"affiliations":[{"raw_affiliation_string":"Department of Informatics, HASLab/INESC Tec & Universidade Nova de Lisboa, Lisbon, Portugal","institution_ids":["https://openalex.org/I83558840","https://openalex.org/I4210125590"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5078733350","display_name":"Martin Erwig","orcid":"https://orcid.org/0000-0002-7471-4554"},"institutions":[{"id":"https://openalex.org/I131249849","display_name":"Oregon State University","ror":"https://ror.org/00ysfqy60","country_code":"US","type":"education","lineage":["https://openalex.org/I131249849"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Martin Erwig","raw_affiliation_strings":["School of EECS, Oregon State University, Corvallis, OR, USA","School of EECS, Oregon State University, Corvallis, USA#TAB#"],"affiliations":[{"raw_affiliation_string":"School of EECS, Oregon State University, Corvallis, OR, USA","institution_ids":["https://openalex.org/I131249849"]},{"raw_affiliation_string":"School of EECS, Oregon State University, Corvallis, USA#TAB#","institution_ids":["https://openalex.org/I131249849"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5075244092","display_name":"Jorge Mendes","orcid":"https://orcid.org/0000-0002-7977-9453"},"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"]},{"id":"https://openalex.org/I4210125590","display_name":"Institute for Systems Engineering and Computers","ror":"https://ror.org/033wn8m60","country_code":"PT","type":"nonprofit","lineage":["https://openalex.org/I4210125590"]}],"countries":["PT"],"is_corresponding":false,"raw_author_name":"Jorge Mendes","raw_affiliation_strings":["Department of Informatics, HASLab/INESC Tec & Universidade do Minho, Braga, Portugal","Department of Informatics, HASLab/INESC Tec & Universidade do Minho, Braga, Portugal#TAB#"],"affiliations":[{"raw_affiliation_string":"Department of Informatics, HASLab/INESC Tec & Universidade do Minho, Braga, Portugal","institution_ids":["https://openalex.org/I99682543","https://openalex.org/I4210125590"]},{"raw_affiliation_string":"Department of Informatics, HASLab/INESC Tec & Universidade do Minho, Braga, Portugal#TAB#","institution_ids":["https://openalex.org/I99682543"]}]},{"author_position":"last","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"]},{"id":"https://openalex.org/I4210125590","display_name":"Institute for Systems Engineering and Computers","ror":"https://ror.org/033wn8m60","country_code":"PT","type":"nonprofit","lineage":["https://openalex.org/I4210125590"]}],"countries":["PT"],"is_corresponding":false,"raw_author_name":"Jo\u00e3o Saraiva","raw_affiliation_strings":["Department of Informatics, HASLab/INESC Tec & Universidade do Minho, Braga, Portugal","Department of Informatics, HASLab/INESC Tec & Universidade do Minho, Braga, Portugal#TAB#"],"affiliations":[{"raw_affiliation_string":"Department of Informatics, HASLab/INESC Tec & Universidade do Minho, Braga, Portugal","institution_ids":["https://openalex.org/I99682543","https://openalex.org/I4210125590"]},{"raw_affiliation_string":"Department of Informatics, HASLab/INESC Tec & Universidade do Minho, Braga, Portugal#TAB#","institution_ids":["https://openalex.org/I99682543"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":4,"corresponding_author_ids":["https://openalex.org/A5042720932"],"corresponding_institution_ids":["https://openalex.org/I4210125590","https://openalex.org/I83558840"],"apc_list":{"value":2290,"currency":"EUR","value_usd":2890},"apc_paid":null,"fwci":2.7055,"has_fulltext":false,"cited_by_count":25,"citation_normalized_percentile":{"value":0.9040201,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":90,"max":99},"biblio":{"volume":"23","issue":"3","first_page":"361","last_page":"392"},"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/T11875","display_name":"Statistics Education and Methodologies","score":0.9824000000953674,"subfield":{"id":"https://openalex.org/subfields/2613","display_name":"Statistics and Probability"},"field":{"id":"https://openalex.org/fields/26","display_name":"Mathematics"},"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.8462451696395874},{"id":"https://openalex.org/keywords/consistency","display_name":"Consistency (knowledge bases)","score":0.6209998726844788},{"id":"https://openalex.org/keywords/set","display_name":"Set (abstract data type)","score":0.5528728365898132},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.5312884449958801},{"id":"https://openalex.org/keywords/inference","display_name":"Inference","score":0.5042649507522583},{"id":"https://openalex.org/keywords/reverse-engineering","display_name":"Reverse engineering","score":0.5025103092193604},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.47609150409698486},{"id":"https://openalex.org/keywords/class","display_name":"Class (philosophy)","score":0.43314114212989807},{"id":"https://openalex.org/keywords/encode","display_name":"ENCODE","score":0.42800039052963257},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.42700257897377014},{"id":"https://openalex.org/keywords/software-engineering","display_name":"Software engineering","score":0.4025166630744934},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.18494239449501038}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8462451696395874},{"id":"https://openalex.org/C2776436953","wikidata":"https://www.wikidata.org/wiki/Q5163215","display_name":"Consistency (knowledge bases)","level":2,"score":0.6209998726844788},{"id":"https://openalex.org/C177264268","wikidata":"https://www.wikidata.org/wiki/Q1514741","display_name":"Set (abstract data type)","level":2,"score":0.5528728365898132},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.5312884449958801},{"id":"https://openalex.org/C2776214188","wikidata":"https://www.wikidata.org/wiki/Q408386","display_name":"Inference","level":2,"score":0.5042649507522583},{"id":"https://openalex.org/C207850805","wikidata":"https://www.wikidata.org/wiki/Q269608","display_name":"Reverse engineering","level":2,"score":0.5025103092193604},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.47609150409698486},{"id":"https://openalex.org/C2777212361","wikidata":"https://www.wikidata.org/wiki/Q5127848","display_name":"Class (philosophy)","level":2,"score":0.43314114212989807},{"id":"https://openalex.org/C66746571","wikidata":"https://www.wikidata.org/wiki/Q1134833","display_name":"ENCODE","level":3,"score":0.42800039052963257},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.42700257897377014},{"id":"https://openalex.org/C115903868","wikidata":"https://www.wikidata.org/wiki/Q80993","display_name":"Software engineering","level":1,"score":0.4025166630744934},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.18494239449501038},{"id":"https://openalex.org/C104317684","wikidata":"https://www.wikidata.org/wiki/Q7187","display_name":"Gene","level":2,"score":0.0},{"id":"https://openalex.org/C55493867","wikidata":"https://www.wikidata.org/wiki/Q7094","display_name":"Biochemistry","level":1,"score":0.0},{"id":"https://openalex.org/C185592680","wikidata":"https://www.wikidata.org/wiki/Q2329","display_name":"Chemistry","level":0,"score":0.0}],"mesh":[],"locations_count":4,"locations":[{"id":"doi:10.1007/s10515-014-0167-x","is_oa":false,"landing_page_url":"https://doi.org/10.1007/s10515-014-0167-x","pdf_url":null,"source":{"id":"https://openalex.org/S4210177399","display_name":"Automated Software Engineering","issn_l":"0928-8910","issn":["0928-8910","1573-7535"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319900","host_organization_name":"Springer Science+Business Media","host_organization_lineage":["https://openalex.org/P4310319900","https://openalex.org/P4310319965"],"host_organization_lineage_names":["Springer Science+Business Media","Springer Nature"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Automated Software Engineering","raw_type":"journal-article"},{"id":"pmh:oai:repositorio.inesctec.pt:123456789/5416","is_oa":true,"landing_page_url":"http://repositorio.inesctec.pt/handle/123456789/5416","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":"","raw_type":"journal article"},{"id":"pmh:oai:repositorium.sdum.uminho.pt:1822/33782","is_oa":true,"landing_page_url":"http://hdl.handle.net/1822/33782","pdf_url":null,"source":{"id":"https://openalex.org/S4306401240","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":"journal article"},{"id":"pmh:oai:repositorium.uminho.pt:1822/33782","is_oa":true,"landing_page_url":"https://hdl.handle.net/1822/33782","pdf_url":null,"source":null,"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":"info:eu-repo/semantics/article"}],"best_oa_location":{"id":"pmh:oai:repositorio.inesctec.pt:123456789/5416","is_oa":true,"landing_page_url":"http://repositorio.inesctec.pt/handle/123456789/5416","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":"","raw_type":"journal article"},"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":41,"referenced_works":["https://openalex.org/W74554238","https://openalex.org/W180578187","https://openalex.org/W1502384207","https://openalex.org/W1515921409","https://openalex.org/W1529704888","https://openalex.org/W1537955876","https://openalex.org/W1571097741","https://openalex.org/W1575391024","https://openalex.org/W1578962373","https://openalex.org/W1650869244","https://openalex.org/W1783768447","https://openalex.org/W1795952373","https://openalex.org/W1797766883","https://openalex.org/W1958332869","https://openalex.org/W1967598580","https://openalex.org/W1969600276","https://openalex.org/W1970665021","https://openalex.org/W1987048250","https://openalex.org/W2004176798","https://openalex.org/W2006426998","https://openalex.org/W2060404275","https://openalex.org/W2066044245","https://openalex.org/W2084119909","https://openalex.org/W2084671376","https://openalex.org/W2086856784","https://openalex.org/W2109545181","https://openalex.org/W2115822498","https://openalex.org/W2120407951","https://openalex.org/W2126634149","https://openalex.org/W2127237677","https://openalex.org/W2146405864","https://openalex.org/W2159433976","https://openalex.org/W2165043113","https://openalex.org/W2166955459","https://openalex.org/W2185907055","https://openalex.org/W2988119170","https://openalex.org/W3087962165","https://openalex.org/W3122827791","https://openalex.org/W3140037879","https://openalex.org/W3148828430","https://openalex.org/W4285719527"],"related_works":["https://openalex.org/W2468279273","https://openalex.org/W2354198838","https://openalex.org/W1989130879","https://openalex.org/W2103419012","https://openalex.org/W2363831530","https://openalex.org/W2363845219","https://openalex.org/W2988126442","https://openalex.org/W1974414866","https://openalex.org/W2381057835","https://openalex.org/W1789649838"],"abstract_inverted_index":{"Many":[0],"errors":[1],"in":[2,23,89],"spreadsheet":[3,46,78,140,183,201],"formulas":[4],"can":[5,17],"be":[6,40,51,218],"avoided":[7],"if":[8],"spreadsheets":[9,32,155,226],"are":[10,127,145],"built":[11],"automatically":[12,66],"from":[13,43,70,76,136],"higher-level":[14],"models":[15],"that":[16,65,120],"encode":[18],"and":[19,47,61,174,184,210],"enforce":[20],"consistency":[21],"constraints":[22],"the":[24,36,54,77,121,130,137,182],"generated":[25],"spreadsheets.":[26,71,106],"Employing":[27],"this":[28,87],"strategy":[29],"for":[30],"legacy":[31,225],"is":[33,197],"difficult,":[34],"because":[35,204],"model":[37,149],"has":[38,118],"to":[39,80,129,148,181,200,217,220],"reverse":[41],"engineered":[42],"an":[44,111,207],"existing":[45,48],"data":[49],"must":[50],"transferred":[52],"into":[53],"new":[55],"model-generated":[56],"spreadsheet.":[57],"We":[58,84],"have":[59,85,94,109,166],"developed":[60,132,195],"implemented":[62],"a":[63,102,169,188,198,212,221],"technique":[64,73,88,126],"infers":[67],"relational":[68,143,172],"schemas":[69,144,173],"This":[72],"uses":[74],"particularities":[75],"realm":[79],"create":[81],"better":[82],"schemas.":[83],"evaluated":[86],"two":[90],"ways:":[91],"first,":[92],"we":[93,108,165],"demonstrated":[95],"its":[96],"applicability":[97],"by":[98,124,133],"using":[99],"it":[100,186,205],"on":[101],"set":[103],"of":[104,191,224],"real-world":[105],"Second,":[107],"run":[110],"empirical":[112],"study":[113,117],"with":[114,227],"users.":[115],"The":[116,194],"shown":[119],"results":[122],"produced":[123],"our":[125],"comparable":[128],"ones":[131],"experts":[134],"starting":[135],"same":[138],"(legacy)":[139],"data.":[141],"Although":[142],"very":[146],"useful":[147],"data,":[150],"they":[151,158],"do":[152,159],"not":[153,160],"fit":[154],"well,":[156],"as":[157],"allow":[161],"expressing":[162],"layout.":[163],"Thus,":[164],"also":[167],"introduced":[168],"mapping":[170],"between":[171],"ClassSheets.":[175],"A":[176],"ClassSheet":[177],"controls":[178],"further":[179],"changes":[180],"safeguards":[185],"against":[187],"large":[189],"class":[190],"formula":[192],"errors.":[193],"tool":[196],"contribution":[199],"(reverse)":[202],"engineering,":[203],"fills":[206],"important":[208],"gap":[209],"allows":[211],"promising":[213],"design":[214],"method":[215],"(ClassSheets)":[216],"applied":[219],"huge":[222],"collection":[223],"minimal":[228],"effort.":[229]},"counts_by_year":[{"year":2025,"cited_by_count":1},{"year":2024,"cited_by_count":2},{"year":2023,"cited_by_count":1},{"year":2021,"cited_by_count":3},{"year":2020,"cited_by_count":4},{"year":2019,"cited_by_count":6},{"year":2018,"cited_by_count":2},{"year":2017,"cited_by_count":1},{"year":2016,"cited_by_count":1},{"year":2015,"cited_by_count":4}],"updated_date":"2026-04-06T07:47:59.780226","created_date":"2016-06-24T00:00:00"}