{"id":"https://openalex.org/W3043159448","doi":"https://doi.org/10.1145/3395363.3397384","title":"Learning to detect table clones in spreadsheets","display_name":"Learning to detect table clones in spreadsheets","publication_year":2020,"publication_date":"2020-07-13","ids":{"openalex":"https://openalex.org/W3043159448","doi":"https://doi.org/10.1145/3395363.3397384","mag":"3043159448"},"language":"en","primary_location":{"id":"doi:10.1145/3395363.3397384","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3395363.3397384","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 29th ACM SIGSOFT International Symposium on Software Testing and Analysis","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/A5100647278","display_name":"Yakun Zhang","orcid":"https://orcid.org/0000-0001-5829-1371"},"institutions":[{"id":"https://openalex.org/I4210128818","display_name":"Institute of Software","ror":"https://ror.org/033dfsn42","country_code":"CN","type":"facility","lineage":["https://openalex.org/I19820366","https://openalex.org/I4210128818"]},{"id":"https://openalex.org/I19820366","display_name":"Chinese Academy of Sciences","ror":"https://ror.org/034t30j35","country_code":"CN","type":"funder","lineage":["https://openalex.org/I19820366"]}],"countries":["CN"],"is_corresponding":true,"raw_author_name":"Yakun Zhang","raw_affiliation_strings":["Institute of Software at Chinese Academy of Sciences, China"],"affiliations":[{"raw_affiliation_string":"Institute of Software at Chinese Academy of Sciences, China","institution_ids":["https://openalex.org/I4210128818","https://openalex.org/I19820366"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5023724495","display_name":"Wensheng Dou","orcid":"https://orcid.org/0000-0002-3323-0449"},"institutions":[{"id":"https://openalex.org/I4210128818","display_name":"Institute of Software","ror":"https://ror.org/033dfsn42","country_code":"CN","type":"facility","lineage":["https://openalex.org/I19820366","https://openalex.org/I4210128818"]},{"id":"https://openalex.org/I19820366","display_name":"Chinese Academy of Sciences","ror":"https://ror.org/034t30j35","country_code":"CN","type":"funder","lineage":["https://openalex.org/I19820366"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Wensheng Dou","raw_affiliation_strings":["Institute of Software at Chinese Academy of Sciences, China"],"affiliations":[{"raw_affiliation_string":"Institute of Software at Chinese Academy of Sciences, China","institution_ids":["https://openalex.org/I4210128818","https://openalex.org/I19820366"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5101518774","display_name":"Jiaxin Zhu","orcid":"https://orcid.org/0000-0002-0905-2355"},"institutions":[{"id":"https://openalex.org/I4210128818","display_name":"Institute of Software","ror":"https://ror.org/033dfsn42","country_code":"CN","type":"facility","lineage":["https://openalex.org/I19820366","https://openalex.org/I4210128818"]},{"id":"https://openalex.org/I19820366","display_name":"Chinese Academy of Sciences","ror":"https://ror.org/034t30j35","country_code":"CN","type":"funder","lineage":["https://openalex.org/I19820366"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Jiaxin Zhu","raw_affiliation_strings":["Institute of Software at Chinese Academy of Sciences, China"],"affiliations":[{"raw_affiliation_string":"Institute of Software at Chinese Academy of Sciences, China","institution_ids":["https://openalex.org/I4210128818","https://openalex.org/I19820366"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5064382429","display_name":"Liang Xu","orcid":"https://orcid.org/0000-0001-7400-3827"},"institutions":[{"id":"https://openalex.org/I4210166603","display_name":"Jinling Institute of Technology","ror":"https://ror.org/05em1gq62","country_code":"CN","type":"education","lineage":["https://openalex.org/I4210166603"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Liang Xu","raw_affiliation_strings":["Jinling Institute of Technology, China"],"affiliations":[{"raw_affiliation_string":"Jinling Institute of Technology, China","institution_ids":["https://openalex.org/I4210166603"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5018706393","display_name":"Zhiyong Zhou","orcid":"https://orcid.org/0000-0002-1546-7741"},"institutions":[{"id":"https://openalex.org/I19820366","display_name":"Chinese Academy of Sciences","ror":"https://ror.org/034t30j35","country_code":"CN","type":"funder","lineage":["https://openalex.org/I19820366"]},{"id":"https://openalex.org/I4210128818","display_name":"Institute of Software","ror":"https://ror.org/033dfsn42","country_code":"CN","type":"facility","lineage":["https://openalex.org/I19820366","https://openalex.org/I4210128818"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Zhiyong Zhou","raw_affiliation_strings":["Institute of Software at Chinese Academy of Sciences, China"],"affiliations":[{"raw_affiliation_string":"Institute of Software at Chinese Academy of Sciences, China","institution_ids":["https://openalex.org/I4210128818","https://openalex.org/I19820366"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5037779332","display_name":"Jun Wei","orcid":"https://orcid.org/0000-0002-1028-8509"},"institutions":[{"id":"https://openalex.org/I19820366","display_name":"Chinese Academy of Sciences","ror":"https://ror.org/034t30j35","country_code":"CN","type":"funder","lineage":["https://openalex.org/I19820366"]},{"id":"https://openalex.org/I4210128818","display_name":"Institute of Software","ror":"https://ror.org/033dfsn42","country_code":"CN","type":"facility","lineage":["https://openalex.org/I19820366","https://openalex.org/I4210128818"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Jun Wei","raw_affiliation_strings":["Institute of Software at Chinese Academy of Sciences, China"],"affiliations":[{"raw_affiliation_string":"Institute of Software at Chinese Academy of Sciences, China","institution_ids":["https://openalex.org/I4210128818","https://openalex.org/I19820366"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5100698319","display_name":"Dan Ye","orcid":"https://orcid.org/0000-0002-5725-8956"},"institutions":[{"id":"https://openalex.org/I4210128818","display_name":"Institute of Software","ror":"https://ror.org/033dfsn42","country_code":"CN","type":"facility","lineage":["https://openalex.org/I19820366","https://openalex.org/I4210128818"]},{"id":"https://openalex.org/I19820366","display_name":"Chinese Academy of Sciences","ror":"https://ror.org/034t30j35","country_code":"CN","type":"funder","lineage":["https://openalex.org/I19820366"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Dan Ye","raw_affiliation_strings":["Institute of Software at Chinese Academy of Sciences, China"],"affiliations":[{"raw_affiliation_string":"Institute of Software at Chinese Academy of Sciences, China","institution_ids":["https://openalex.org/I4210128818","https://openalex.org/I19820366"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5065763579","display_name":"Bo Yang","orcid":"https://orcid.org/0009-0008-1798-4268"},"institutions":[{"id":"https://openalex.org/I1456306","display_name":"North China University of Technology","ror":"https://ror.org/01nky7652","country_code":"CN","type":"education","lineage":["https://openalex.org/I1456306"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Bo Yang","raw_affiliation_strings":["North China University of Technology, China"],"affiliations":[{"raw_affiliation_string":"North China University of Technology, China","institution_ids":["https://openalex.org/I1456306"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":8,"corresponding_author_ids":["https://openalex.org/A5100647278"],"corresponding_institution_ids":["https://openalex.org/I19820366","https://openalex.org/I4210128818"],"apc_list":null,"apc_paid":null,"fwci":1.823,"has_fulltext":false,"cited_by_count":8,"citation_normalized_percentile":{"value":0.84884005,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":96},"biblio":{"volume":null,"issue":null,"first_page":"528","last_page":"540"},"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.9997000098228455,"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.9997000098228455,"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.988099992275238,"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"}},{"id":"https://openalex.org/T10260","display_name":"Software Engineering Research","score":0.9861999750137329,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"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/table","display_name":"Table (database)","score":0.8877434730529785},{"id":"https://openalex.org/keywords/clone","display_name":"clone (Java method)","score":0.8031395673751831},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.7531464099884033},{"id":"https://openalex.org/keywords/row","display_name":"Row","score":0.626242458820343},{"id":"https://openalex.org/keywords/copying","display_name":"Copying","score":0.586025059223175},{"id":"https://openalex.org/keywords/semantics","display_name":"Semantics (computer science)","score":0.46457988023757935},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.46317464113235474},{"id":"https://openalex.org/keywords/decision-table","display_name":"Decision table","score":0.4584367871284485},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.2753039598464966},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.26367849111557007}],"concepts":[{"id":"https://openalex.org/C45235069","wikidata":"https://www.wikidata.org/wiki/Q278425","display_name":"Table (database)","level":2,"score":0.8877434730529785},{"id":"https://openalex.org/C81089528","wikidata":"https://www.wikidata.org/wiki/Q5134986","display_name":"clone (Java method)","level":3,"score":0.8031395673751831},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7531464099884033},{"id":"https://openalex.org/C135598885","wikidata":"https://www.wikidata.org/wiki/Q1366302","display_name":"Row","level":2,"score":0.626242458820343},{"id":"https://openalex.org/C2779151265","wikidata":"https://www.wikidata.org/wiki/Q1156791","display_name":"Copying","level":2,"score":0.586025059223175},{"id":"https://openalex.org/C184337299","wikidata":"https://www.wikidata.org/wiki/Q1437428","display_name":"Semantics (computer science)","level":2,"score":0.46457988023757935},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.46317464113235474},{"id":"https://openalex.org/C172967692","wikidata":"https://www.wikidata.org/wiki/Q747762","display_name":"Decision table","level":3,"score":0.4584367871284485},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.2753039598464966},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.26367849111557007},{"id":"https://openalex.org/C86803240","wikidata":"https://www.wikidata.org/wiki/Q420","display_name":"Biology","level":0,"score":0.0},{"id":"https://openalex.org/C199539241","wikidata":"https://www.wikidata.org/wiki/Q7748","display_name":"Law","level":1,"score":0.0},{"id":"https://openalex.org/C111012933","wikidata":"https://www.wikidata.org/wiki/Q3137210","display_name":"Rough set","level":2,"score":0.0},{"id":"https://openalex.org/C54355233","wikidata":"https://www.wikidata.org/wiki/Q7162","display_name":"Genetics","level":1,"score":0.0},{"id":"https://openalex.org/C17744445","wikidata":"https://www.wikidata.org/wiki/Q36442","display_name":"Political science","level":0,"score":0.0},{"id":"https://openalex.org/C552990157","wikidata":"https://www.wikidata.org/wiki/Q7430","display_name":"DNA","level":2,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/3395363.3397384","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3395363.3397384","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 29th ACM SIGSOFT International Symposium on Software Testing and Analysis","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[{"display_name":"Decent work and economic growth","score":0.6399999856948853,"id":"https://metadata.un.org/sdg/8"}],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":53,"referenced_works":["https://openalex.org/W24922676","https://openalex.org/W1515921409","https://openalex.org/W1531418056","https://openalex.org/W1551326568","https://openalex.org/W1579695396","https://openalex.org/W1603920809","https://openalex.org/W1808011207","https://openalex.org/W1958332869","https://openalex.org/W2000784509","https://openalex.org/W2006499508","https://openalex.org/W2008085811","https://openalex.org/W2010598806","https://openalex.org/W2023424255","https://openalex.org/W2032655922","https://openalex.org/W2038340833","https://openalex.org/W2056108729","https://openalex.org/W2096491586","https://openalex.org/W2101234009","https://openalex.org/W2104301886","https://openalex.org/W2109545181","https://openalex.org/W2109943392","https://openalex.org/W2125283600","https://openalex.org/W2125513188","https://openalex.org/W2128782367","https://openalex.org/W2128888088","https://openalex.org/W2129386590","https://openalex.org/W2135473121","https://openalex.org/W2138756793","https://openalex.org/W2147373555","https://openalex.org/W2149684865","https://openalex.org/W2150704968","https://openalex.org/W2156400118","https://openalex.org/W2157532207","https://openalex.org/W2169917840","https://openalex.org/W2277934767","https://openalex.org/W2362126069","https://openalex.org/W2404721232","https://openalex.org/W2408009809","https://openalex.org/W2464636023","https://openalex.org/W2511803001","https://openalex.org/W2548596251","https://openalex.org/W2550378979","https://openalex.org/W2610500547","https://openalex.org/W2767717989","https://openalex.org/W2796264185","https://openalex.org/W2888184422","https://openalex.org/W2898098214","https://openalex.org/W2911964244","https://openalex.org/W2914121031","https://openalex.org/W3173700007","https://openalex.org/W4213086105","https://openalex.org/W4230392236","https://openalex.org/W4285719527"],"related_works":["https://openalex.org/W2588206991","https://openalex.org/W4308771405","https://openalex.org/W2355873265","https://openalex.org/W2963669501","https://openalex.org/W3080197661","https://openalex.org/W4318471783","https://openalex.org/W2760667490","https://openalex.org/W2991781269","https://openalex.org/W2681819862","https://openalex.org/W155677389"],"abstract_inverted_index":{"In":[0],"order":[1],"to":[2],"speed":[3],"up":[4],"spreadsheet":[5,13],"development":[6],"productivity,":[7],"end":[8],"users":[9,36],"can":[10,84],"create":[11],"a":[12,32,42],"table":[14,33,43,58,71,78,87,95],"by":[15],"copying":[16],"and":[17,30,49],"modifying":[18],"an":[19],"existing":[20,77],"one.":[21],"These":[22],"two":[23],"tables":[24,40],"share":[25],"the":[26,39,57,90],"similar":[27],"computational":[28],"semantics,":[29],"form":[31],"clone.":[34,59],"End":[35],"may":[37],"modify":[38],"in":[41,82],"clone,":[44],"e.g.,":[45],"adding":[46],"new":[47],"rows":[48],"deleting":[50],"columns,":[51],"thus":[52],"introducing":[53],"structure":[54,74,98],"changes":[55,99],"into":[56],"Our":[60],"empirical":[61],"study":[62],"on":[63],"real-world":[64],"spreadsheets":[65,83],"shows":[66],"that":[67],"about":[68],"58.5%":[69],"of":[70],"clones":[72,88,96],"involve":[73],"changes.":[75],"However,":[76],"clone":[79],"detection":[80],"approaches":[81],"only":[85],"detect":[86],"with":[89,97],"same":[91],"structures.":[92],"Therefore,":[93],"many":[94],"cannot":[100],"be":[101],"detected.":[102]},"counts_by_year":[{"year":2024,"cited_by_count":2},{"year":2023,"cited_by_count":1},{"year":2022,"cited_by_count":2},{"year":2021,"cited_by_count":2},{"year":2020,"cited_by_count":1}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}