{"id":"https://openalex.org/W4384129370","doi":"https://doi.org/10.1145/3597926.3598122","title":"Data Constraint Mining for Automatic Reconciliation Scripts Generation","display_name":"Data Constraint Mining for Automatic Reconciliation Scripts Generation","publication_year":2023,"publication_date":"2023-07-12","ids":{"openalex":"https://openalex.org/W4384129370","doi":"https://doi.org/10.1145/3597926.3598122"},"language":"en","primary_location":{"id":"doi:10.1145/3597926.3598122","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3597926.3598122","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 32nd ACM SIGSOFT International Symposium on Software Testing and Analysis","raw_type":"proceedings-article"},"type":"conference-paper","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/A5101930341","display_name":"Tianxiao Wang","orcid":"https://orcid.org/0009-0004-0242-2861"},"institutions":[{"id":"https://openalex.org/I45928872","display_name":"Alibaba Group (China)","ror":"https://ror.org/00k642b80","country_code":"CN","type":"company","lineage":["https://openalex.org/I45928872"]},{"id":"https://openalex.org/I76130692","display_name":"Zhejiang University","ror":"https://ror.org/00a2xv884","country_code":"CN","type":"education","lineage":["https://openalex.org/I76130692"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Tianxiao Wang","raw_affiliation_strings":["Zhejiang University, China / Alibaba-Zhejiang University Joint Institute of Frontier Technologies, China"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Zhejiang University, China / Alibaba-Zhejiang University Joint Institute of Frontier Technologies, China","institution_ids":["https://openalex.org/I45928872","https://openalex.org/I76130692"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5100622018","display_name":"Zhi Chen","orcid":"https://orcid.org/0000-0002-4385-1484"},"institutions":[{"id":"https://openalex.org/I45928872","display_name":"Alibaba Group (China)","ror":"https://ror.org/00k642b80","country_code":"CN","type":"company","lineage":["https://openalex.org/I45928872"]},{"id":"https://openalex.org/I76130692","display_name":"Zhejiang University","ror":"https://ror.org/00a2xv884","country_code":"CN","type":"education","lineage":["https://openalex.org/I76130692"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Chen Zhi","raw_affiliation_strings":["Zhejiang University, China / Alibaba-Zhejiang University Joint Institute of Frontier Technologies, China"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Zhejiang University, China / Alibaba-Zhejiang University Joint Institute of Frontier Technologies, China","institution_ids":["https://openalex.org/I45928872","https://openalex.org/I76130692"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5064918684","display_name":"Xiaoqun Zhou","orcid":null},"institutions":[{"id":"https://openalex.org/I45928872","display_name":"Alibaba Group (China)","ror":"https://ror.org/00k642b80","country_code":"CN","type":"company","lineage":["https://openalex.org/I45928872"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Xiaoqun Zhou","raw_affiliation_strings":["Alibaba Group, China"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Alibaba Group, China","institution_ids":["https://openalex.org/I45928872"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5101350170","display_name":"Wu Jinjie","orcid":null},"institutions":[{"id":"https://openalex.org/I45928872","display_name":"Alibaba Group (China)","ror":"https://ror.org/00k642b80","country_code":"CN","type":"company","lineage":["https://openalex.org/I45928872"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Jinjie Wu","raw_affiliation_strings":["Alibaba Group, China"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Alibaba Group, China","institution_ids":["https://openalex.org/I45928872"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5069353502","display_name":"Jianwei Yin","orcid":"https://orcid.org/0000-0003-4703-7348"},"institutions":[{"id":"https://openalex.org/I76130692","display_name":"Zhejiang University","ror":"https://ror.org/00a2xv884","country_code":"CN","type":"education","lineage":["https://openalex.org/I76130692"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Jianwei Yin","raw_affiliation_strings":["Zhejiang University, China"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Zhejiang University, China","institution_ids":["https://openalex.org/I76130692"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5055284175","display_name":"Shuiguang Deng","orcid":"https://orcid.org/0000-0001-5015-6095"},"institutions":[{"id":"https://openalex.org/I45928872","display_name":"Alibaba Group (China)","ror":"https://ror.org/00k642b80","country_code":"CN","type":"company","lineage":["https://openalex.org/I45928872"]},{"id":"https://openalex.org/I76130692","display_name":"Zhejiang University","ror":"https://ror.org/00a2xv884","country_code":"CN","type":"education","lineage":["https://openalex.org/I76130692"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Shuiguang Deng","raw_affiliation_strings":["Zhejiang University, China / Alibaba-Zhejiang University Joint Institute of Frontier Technologies, China"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Zhejiang University, China / Alibaba-Zhejiang University Joint Institute of Frontier Technologies, China","institution_ids":["https://openalex.org/I45928872","https://openalex.org/I76130692"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":null,"has_fulltext":false,"cited_by_count":1,"citation_normalized_percentile":null,"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":"1119","last_page":"1130"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11719","display_name":"Data Quality and Management","score":0.9979000091552734,"subfield":{"id":"https://openalex.org/subfields/1803","display_name":"Management Science and Operations Research"},"field":{"id":"https://openalex.org/fields/18","display_name":"Decision Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},"topics":[{"id":"https://openalex.org/T11719","display_name":"Data Quality and Management","score":0.9979000091552734,"subfield":{"id":"https://openalex.org/subfields/1803","display_name":"Management Science and Operations Research"},"field":{"id":"https://openalex.org/fields/18","display_name":"Decision Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},{"id":"https://openalex.org/T10101","display_name":"Cloud Computing and Resource Management","score":0.996999979019165,"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"}},{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9966999888420105,"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/scripting-language","display_name":"Scripting language","score":0.8622627258300781},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8013847470283508},{"id":"https://openalex.org/keywords/margin","display_name":"Margin (machine learning)","score":0.5288565754890442},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.5076819658279419},{"id":"https://openalex.org/keywords/constraint","display_name":"Constraint (computer-aided design)","score":0.49793052673339844},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.48650068044662476},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.41502779722213745},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.27450746297836304},{"id":"https://openalex.org/keywords/machine-learning","display_name":"Machine learning","score":0.1353321373462677},{"id":"https://openalex.org/keywords/engineering","display_name":"Engineering","score":0.08191084861755371}],"concepts":[{"id":"https://openalex.org/C61423126","wikidata":"https://www.wikidata.org/wiki/Q187432","display_name":"Scripting language","level":2,"score":0.8622627258300781},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8013847470283508},{"id":"https://openalex.org/C774472","wikidata":"https://www.wikidata.org/wiki/Q6760393","display_name":"Margin (machine learning)","level":2,"score":0.5288565754890442},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.5076819658279419},{"id":"https://openalex.org/C2776036281","wikidata":"https://www.wikidata.org/wiki/Q48769818","display_name":"Constraint (computer-aided design)","level":2,"score":0.49793052673339844},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.48650068044662476},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.41502779722213745},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.27450746297836304},{"id":"https://openalex.org/C119857082","wikidata":"https://www.wikidata.org/wiki/Q2539","display_name":"Machine learning","level":1,"score":0.1353321373462677},{"id":"https://openalex.org/C127413603","wikidata":"https://www.wikidata.org/wiki/Q11023","display_name":"Engineering","level":0,"score":0.08191084861755371},{"id":"https://openalex.org/C78519656","wikidata":"https://www.wikidata.org/wiki/Q101333","display_name":"Mechanical engineering","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/3597926.3598122","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3597926.3598122","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 32nd ACM SIGSOFT International Symposium on Software Testing and Analysis","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[{"id":"https://openalex.org/G5151241140","display_name":null,"funder_award_id":"U20A20173","funder_id":"https://openalex.org/F4320321001","funder_display_name":"National Natural Science Foundation of China"},{"id":"https://openalex.org/G5604630631","display_name":null,"funder_award_id":"62125206","funder_id":"https://openalex.org/F4320321001","funder_display_name":"National Natural Science Foundation of China"}],"funders":[{"id":"https://openalex.org/F4320321001","display_name":"National Natural Science Foundation of China","ror":"https://ror.org/01h0zpd94"}],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":33,"referenced_works":["https://openalex.org/W760598031","https://openalex.org/W1973751060","https://openalex.org/W1979769287","https://openalex.org/W2041713059","https://openalex.org/W2044901139","https://openalex.org/W2092317965","https://openalex.org/W2110908283","https://openalex.org/W2112129552","https://openalex.org/W2149706766","https://openalex.org/W2165014243","https://openalex.org/W2241277057","https://openalex.org/W2337392435","https://openalex.org/W2740924709","https://openalex.org/W2767715425","https://openalex.org/W2794555255","https://openalex.org/W2803707184","https://openalex.org/W2899573209","https://openalex.org/W2901725080","https://openalex.org/W2947704387","https://openalex.org/W2963054422","https://openalex.org/W3037244434","https://openalex.org/W3081970771","https://openalex.org/W3089552543","https://openalex.org/W3106169594","https://openalex.org/W3152398171","https://openalex.org/W3183134251","https://openalex.org/W4225519466","https://openalex.org/W4229458497","https://openalex.org/W4239887527","https://openalex.org/W4284714035","https://openalex.org/W4289765664","https://openalex.org/W4318350273","https://openalex.org/W4318541617"],"related_works":["https://openalex.org/W2046765700","https://openalex.org/W4384345686","https://openalex.org/W2357937784","https://openalex.org/W2547618384","https://openalex.org/W4394391052","https://openalex.org/W2145834781","https://openalex.org/W2577782152","https://openalex.org/W262455470","https://openalex.org/W4242899858","https://openalex.org/W2356327704"],"abstract_inverted_index":{"Fund":[0],"loss":[1,34],"is":[2,21,53],"an":[3],"increasingly":[4],"critical":[5],"problem":[6],"caused":[7],"by":[8,35,149],"the":[9,24,54,72,78,137,147,189],"misbehavior":[10],"of":[11,23,50,76,80,160,191],"software,":[12],"especially":[13,165],"in":[14,29,128,156,178,194],"fintech":[15],"and":[16,31,45,67,74,83,105,124,158,162,176,180],"e-commerce":[17],"platforms.":[18],"Data":[19],"reconciliation":[20,37,51,84,107,126],"one":[22],"most":[25],"commonly":[26],"used":[27],"approaches":[28],"detecting":[30],"preventing":[32],"fund":[33],"executing":[36],"scripts":[38,52,85,108,127],"on":[39,89,136],"data":[40,55,81,100,104,168],"storage":[41],"systems":[42],"(e.g.,":[43],"database":[44],"cache":[46],"systems).":[47],"The":[48,140],"core":[49],"constraints,":[56],"which":[57],"can":[58,111],"be":[59],"expressed":[60],"as":[61],"implications":[62],"with":[63],"two":[64],"parts:":[65],"preconditions":[66,119],"assertions.":[68],"However,":[69],"due":[70],"to":[71,98,187],"complexity":[73],"diversity":[75],"business,":[77],"construction":[79],"constraints":[82,101],"usually":[86],"heavily":[87],"relies":[88],"business":[90,103],"experts.":[91],"To":[92],"this":[93],"end,":[94],"we":[95,181],"propose":[96],"AutoReconciler":[97],"mine":[99,112],"from":[102],"generate":[106,125],"automatically.":[109],"It":[110],"assertions":[113],"via":[114,120],"enhanced":[115],"symbolic":[116],"regression,":[117],"discover":[118],"association":[121],"rule":[122],"mining,":[123],"SQL":[129],"form.":[130],"We":[131],"have":[132],"performed":[133],"extensive":[134],"experiments":[135],"synthesized":[138],"data.":[139],"result":[141],"shows":[142],"that":[143],"our":[144,192],"approach":[145],"outperforms":[146],"baseline":[148],"a":[150],"large":[151],"margin":[152],"(an":[153],"average":[154],"improvement":[155],"precision":[157],"recall":[159],"22.1%":[161],"51.6%,":[163],"respectively),":[164],"for":[166],"complex":[167],"constraints.":[169],"Our":[170],"solution":[171,193],"has":[172],"been":[173],"implemented,":[174],"deployed,":[175],"adopted":[177],"production,":[179],"conducted":[182],"several":[183],"case":[184],"studies":[185],"further":[186],"confirm":[188],"benefits":[190],"industrial":[195],"scenarios.":[196]},"counts_by_year":[{"year":2023,"cited_by_count":1}],"updated_date":"2026-07-14T23:27:15.235271","created_date":"2025-10-10T00:00:00"}