{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2025,10,5]],"date-time":"2025-10-05T17:00:21Z","timestamp":1759683621033,"version":"3.37.3"},"reference-count":22,"publisher":"Oxford University Press (OUP)","issue":"7","license":[{"start":{"date-parts":[[2018,12,1]],"date-time":"2018-12-01T00:00:00Z","timestamp":1543622400000},"content-version":"vor","delay-in-days":0,"URL":"https:\/\/academic.oup.com\/journals\/pages\/open_access\/funder_policies\/chorus\/standard_publication_model"}],"funder":[{"DOI":"10.13039\/501100000266","name":"Engineering and Physical Sciences Research council","doi-asserted-by":"publisher","id":[{"id":"10.13039\/501100000266","id-type":"DOI","asserted-by":"publisher"}]}],"content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":[],"published-print":{"date-parts":[[2019,7,18]]},"abstract":"<jats:title>Abstract<\/jats:title>\n               <jats:p>Data wrangling is the process whereby data are cleaned and integrated for analysis. Data wrangling, even with tool support, is typically a labour intensive process. One aspect of data wrangling involves carrying out format transformations on attribute values, for example so that names or phone numbers are represented consistently. Recent research has developed techniques for synthesizing format transformation programs from examples of the source and target representations. This is valuable, but still requires a user to provide suitable examples, something that may be challenging in applications in which there are huge datasets or numerous data sources. In this paper, we investigate the automatic discovery of examples that can be used to synthesize format transformation programs. In particular, we propose two approaches to identifying candidate data examples and validating the transformations that are synthesized from them. The approaches are evaluated empirically using datasets from open government data.<\/jats:p>","DOI":"10.1093\/comjnl\/bxy118","type":"journal-article","created":{"date-parts":[[2018,11,8]],"date-time":"2018-11-08T07:33:12Z","timestamp":1541662392000},"page":"1044-1060","source":"Crossref","is-referenced-by-count":7,"title":["Towards Automatic Data Format Transformations: Data Wrangling at Scale"],"prefix":"10.1093","volume":"62","author":[{"given":"Alex","family":"Bogatu","sequence":"first","affiliation":[{"name":"School of Computer Science, University of Manchester, Manchester, UK"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Norman W","family":"Paton","sequence":"additional","affiliation":[{"name":"School of Computer Science, University of Manchester, Manchester, UK"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Alvaro A A","family":"Fernandes","sequence":"additional","affiliation":[{"name":"School of Computer Science, University of Manchester, Manchester, UK"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"ORCID":"https:\/\/orcid.org\/0000-0003-0377-9008","authenticated-orcid":false,"given":"Martin","family":"Koehler","sequence":"additional","affiliation":[{"name":"School of Computer Science, University of Manchester, Manchester, UK"}],"role":[{"role":"author","vocabulary":"crossref"}]}],"member":"286","published-online":{"date-parts":[[2018,12,1]]},"reference":[{"year":"2016","author":"Furche","key":"2019071809561103800_bxy118C1"},{"year":"2011","author":"Kandel","key":"2019071809561103800_bxy118C2"},{"year":"2011","author":"Gulwani","key":"2019071809561103800_bxy118C3"},{"key":"2019071809561103800_bxy118C4","doi-asserted-by":"crossref","first-page":"816","DOI":"10.14778\/2977797.2977807","article-title":"Blinkfill: Semi-supervised programming by example for syntactic string transformations","volume":"9","author":"Singh","year":"2016","journal-title":"Proc. VLDB Endowment"},{"year":"2017","author":"Bogatu","key":"2019071809561103800_bxy118C5"},{"year":"2016","author":"Papenbrock","key":"2019071809561103800_bxy118C6"},{"key":"2019071809561103800_bxy118C7","doi-asserted-by":"crossref","first-page":"334","DOI":"10.1007\/s007780100057","article-title":"A survey of approaches to automatic schema matching","volume":"10","author":"Rahm","year":"2001","journal-title":"VLDB J."},{"year":"2015","author":"Wu","key":"2019071809561103800_bxy118C8"},{"year":"2014","author":"Raza","key":"2019071809561103800_bxy118C9"},{"year":"2008","author":"Fan","key":"2019071809561103800_bxy118C10"},{"key":"2019071809561103800_bxy118C11","doi-asserted-by":"crossref","first-page":"7","DOI":"10.1145\/2854006.2854008","article-title":"Data quality: from theory to practice","volume":"44","author":"Fan","year":"2015","journal-title":"ACM SIGMOD Record"},{"year":"2013","author":"Chu","key":"2019071809561103800_bxy118C12"},{"key":"2019071809561103800_bxy118C13","doi-asserted-by":"crossref","first-page":"213","DOI":"10.1007\/s00778-011-0253-7","article-title":"Towards certain fixes with editing rules and master data","volume":"21","author":"Fan","year":"2012","journal-title":"VLDB J."},{"key":"2019071809561103800_bxy118C14","doi-asserted-by":"crossref","first-page":"Article No. 6","DOI":"10.1145\/1366102.1366103","article-title":"Conditional Functional Dependencies for Capturing Data Inconsistencies","volume":"33","author":"Fan","year":"2008","journal-title":"ACM TODS"},{"key":"2019071809561103800_bxy118C15","doi-asserted-by":"crossref","first-page":"279","DOI":"10.14778\/1952376.1952378","article-title":"Guided Data Repair","volume":"4","author":"Yakout","year":"2011","journal-title":"Proc. VLDB Endowment"},{"year":"2017","author":"Contreras-Ochando","key":"2019071809561103800_bxy118C16"},{"author":"Wu","key":"2019071809561103800_bxy118C17"},{"key":"2019071809561103800_bxy118C18","doi-asserted-by":"crossref","first-page":"1034","DOI":"10.14778\/3115404.3115409","article-title":"Auto-join: Joining tables by leveraging transformations","volume":"10","author":"Zhu","year":"2017","journal-title":"Proc. VLDB Endowment"},{"year":"2001","author":"Raman","key":"2019071809561103800_bxy118C19"},{"year":"2015","author":"Heer","key":"2019071809561103800_bxy118C20"},{"year":"2017","author":"Konstantinou","key":"2019071809561103800_bxy118C21"},{"year":"2017","author":"Koehler","key":"2019071809561103800_bxy118C22"}],"container-title":["The Computer Journal"],"original-title":[],"language":"en","link":[{"URL":"http:\/\/academic.oup.com\/comjnl\/article-pdf\/62\/7\/1044\/28952449\/bxy118.pdf","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2019,9,22]],"date-time":"2019-09-22T04:38:49Z","timestamp":1569127129000},"score":1,"resource":{"primary":{"URL":"https:\/\/academic.oup.com\/comjnl\/article\/62\/7\/1044\/5224764"}},"subtitle":[],"editor":[{"given":"Peter","family":"Wood","sequence":"additional","affiliation":[],"role":[{"role":"editor","vocabulary":"crossref"}]}],"short-title":[],"issued":{"date-parts":[[2018,12,1]]},"references-count":22,"journal-issue":{"issue":"7","published-online":{"date-parts":[[2018,12,1]]},"published-print":{"date-parts":[[2019,7,18]]}},"URL":"https:\/\/doi.org\/10.1093\/comjnl\/bxy118","relation":{},"ISSN":["0010-4620","1460-2067"],"issn-type":[{"type":"print","value":"0010-4620"},{"type":"electronic","value":"1460-2067"}],"subject":[],"published-other":{"date-parts":[[2019,7]]},"published":{"date-parts":[[2018,12,1]]}}}