{"id":"https://openalex.org/W2295468252","doi":"https://doi.org/10.14778/2856318.2856325","title":"Combining quantitative and logical data cleaning","display_name":"Combining quantitative and logical data cleaning","publication_year":2015,"publication_date":"2015-12-01","ids":{"openalex":"https://openalex.org/W2295468252","doi":"https://doi.org/10.14778/2856318.2856325","mag":"2295468252"},"language":"en","primary_location":{"id":"doi:10.14778/2856318.2856325","is_oa":false,"landing_page_url":"https://doi.org/10.14778/2856318.2856325","pdf_url":null,"source":{"id":"https://openalex.org/S4210226185","display_name":"Proceedings of the VLDB Endowment","issn_l":"2150-8097","issn":["2150-8097"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the VLDB Endowment","raw_type":"journal-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/A5012152797","display_name":"Nataliya Prokoshyna","orcid":null},"institutions":[{"id":"https://openalex.org/I185261750","display_name":"University of Toronto","ror":"https://ror.org/03dbr7087","country_code":"CA","type":"education","lineage":["https://openalex.org/I185261750"]}],"countries":["CA"],"is_corresponding":true,"raw_author_name":"Nataliya Prokoshyna","raw_affiliation_strings":["University of Toronto"],"affiliations":[{"raw_affiliation_string":"University of Toronto","institution_ids":["https://openalex.org/I185261750"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5035817202","display_name":"Jaroslaw Szlichta","orcid":"https://orcid.org/0000-0002-3382-2890"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Jaroslaw Szlichta","raw_affiliation_strings":["U. of Ontario Inst. of Tech"],"affiliations":[{"raw_affiliation_string":"U. of Ontario Inst. of Tech","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5061267570","display_name":"Fei Chiang","orcid":"https://orcid.org/0000-0003-4128-8074"},"institutions":[{"id":"https://openalex.org/I98251732","display_name":"McMaster University","ror":"https://ror.org/02fa3aq29","country_code":"CA","type":"education","lineage":["https://openalex.org/I98251732"]}],"countries":["CA"],"is_corresponding":false,"raw_author_name":"Fei Chiang","raw_affiliation_strings":["McMaster University"],"affiliations":[{"raw_affiliation_string":"McMaster University","institution_ids":["https://openalex.org/I98251732"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5022619313","display_name":"Ren\u00e9e J. Miller","orcid":"https://orcid.org/0000-0002-1484-4787"},"institutions":[{"id":"https://openalex.org/I185261750","display_name":"University of Toronto","ror":"https://ror.org/03dbr7087","country_code":"CA","type":"education","lineage":["https://openalex.org/I185261750"]}],"countries":["CA"],"is_corresponding":false,"raw_author_name":"Ren\u00e9e J. Miller","raw_affiliation_strings":["University of Toronto"],"affiliations":[{"raw_affiliation_string":"University of Toronto","institution_ids":["https://openalex.org/I185261750"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5088315797","display_name":"Divesh Srivastava","orcid":"https://orcid.org/0000-0002-7609-9217"},"institutions":[{"id":"https://openalex.org/I1283103587","display_name":"AT&T (United States)","ror":"https://ror.org/02bbd5539","country_code":"US","type":"company","lineage":["https://openalex.org/I1283103587"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Divesh Srivastava","raw_affiliation_strings":["AT&T Labs Research"],"affiliations":[{"raw_affiliation_string":"AT&T Labs Research","institution_ids":["https://openalex.org/I1283103587"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":5,"corresponding_author_ids":["https://openalex.org/A5012152797"],"corresponding_institution_ids":["https://openalex.org/I185261750"],"apc_list":null,"apc_paid":null,"fwci":16.8257,"has_fulltext":false,"cited_by_count":104,"citation_normalized_percentile":{"value":0.9925594,"is_in_top_1_percent":true,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":90,"max":100},"biblio":{"volume":"9","issue":"4","first_page":"300","last_page":"311"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11719","display_name":"Data Quality and Management","score":0.9994999766349792,"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.9994999766349792,"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/T10764","display_name":"Privacy-Preserving Technologies in Data","score":0.9962999820709229,"subfield":{"id":"https://openalex.org/subfields/1702","display_name":"Artificial Intelligence"},"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/T10538","display_name":"Data Mining Algorithms and Applications","score":0.9222000241279602,"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/computer-science","display_name":"Computer science","score":0.6791977882385254},{"id":"https://openalex.org/keywords/metric","display_name":"Metric (unit)","score":0.6603142023086548},{"id":"https://openalex.org/keywords/inference","display_name":"Inference","score":0.552074670791626},{"id":"https://openalex.org/keywords/functional-dependency","display_name":"Functional dependency","score":0.5504084229469299},{"id":"https://openalex.org/keywords/set","display_name":"Set (abstract data type)","score":0.5323154330253601},{"id":"https://openalex.org/keywords/distortion","display_name":"Distortion (music)","score":0.4974081814289093},{"id":"https://openalex.org/keywords/statistical-inference","display_name":"Statistical inference","score":0.47714850306510925},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.47179025411605835},{"id":"https://openalex.org/keywords/algorithm","display_name":"Algorithm","score":0.47105738520622253},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.45398348569869995},{"id":"https://openalex.org/keywords/dependency","display_name":"Dependency (UML)","score":0.4395422637462616},{"id":"https://openalex.org/keywords/quality","display_name":"Quality (philosophy)","score":0.4202575385570526},{"id":"https://openalex.org/keywords/data-quality","display_name":"Data quality","score":0.4192933440208435},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.27930814027786255},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.26574236154556274},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.23243007063865662}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.6791977882385254},{"id":"https://openalex.org/C176217482","wikidata":"https://www.wikidata.org/wiki/Q860554","display_name":"Metric (unit)","level":2,"score":0.6603142023086548},{"id":"https://openalex.org/C2776214188","wikidata":"https://www.wikidata.org/wiki/Q408386","display_name":"Inference","level":2,"score":0.552074670791626},{"id":"https://openalex.org/C26320393","wikidata":"https://www.wikidata.org/wiki/Q597053","display_name":"Functional dependency","level":3,"score":0.5504084229469299},{"id":"https://openalex.org/C177264268","wikidata":"https://www.wikidata.org/wiki/Q1514741","display_name":"Set (abstract data type)","level":2,"score":0.5323154330253601},{"id":"https://openalex.org/C126780896","wikidata":"https://www.wikidata.org/wiki/Q899871","display_name":"Distortion (music)","level":4,"score":0.4974081814289093},{"id":"https://openalex.org/C134261354","wikidata":"https://www.wikidata.org/wiki/Q938438","display_name":"Statistical inference","level":2,"score":0.47714850306510925},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.47179025411605835},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.47105738520622253},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.45398348569869995},{"id":"https://openalex.org/C19768560","wikidata":"https://www.wikidata.org/wiki/Q320727","display_name":"Dependency (UML)","level":2,"score":0.4395422637462616},{"id":"https://openalex.org/C2779530757","wikidata":"https://www.wikidata.org/wiki/Q1207505","display_name":"Quality (philosophy)","level":2,"score":0.4202575385570526},{"id":"https://openalex.org/C24756922","wikidata":"https://www.wikidata.org/wiki/Q1757694","display_name":"Data quality","level":3,"score":0.4192933440208435},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.27930814027786255},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.26574236154556274},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.23243007063865662},{"id":"https://openalex.org/C105795698","wikidata":"https://www.wikidata.org/wiki/Q12483","display_name":"Statistics","level":1,"score":0.0},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.0},{"id":"https://openalex.org/C138885662","wikidata":"https://www.wikidata.org/wiki/Q5891","display_name":"Philosophy","level":0,"score":0.0},{"id":"https://openalex.org/C111472728","wikidata":"https://www.wikidata.org/wiki/Q9471","display_name":"Epistemology","level":1,"score":0.0},{"id":"https://openalex.org/C21547014","wikidata":"https://www.wikidata.org/wiki/Q1423657","display_name":"Operations management","level":1,"score":0.0},{"id":"https://openalex.org/C162324750","wikidata":"https://www.wikidata.org/wiki/Q8134","display_name":"Economics","level":0,"score":0.0},{"id":"https://openalex.org/C2776257435","wikidata":"https://www.wikidata.org/wiki/Q1576430","display_name":"Bandwidth (computing)","level":2,"score":0.0},{"id":"https://openalex.org/C194257627","wikidata":"https://www.wikidata.org/wiki/Q211554","display_name":"Amplifier","level":3,"score":0.0},{"id":"https://openalex.org/C31258907","wikidata":"https://www.wikidata.org/wiki/Q1301371","display_name":"Computer network","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.14778/2856318.2856325","is_oa":false,"landing_page_url":"https://doi.org/10.14778/2856318.2856325","pdf_url":null,"source":{"id":"https://openalex.org/S4210226185","display_name":"Proceedings of the VLDB Endowment","issn_l":"2150-8097","issn":["2150-8097"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the VLDB Endowment","raw_type":"journal-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":25,"referenced_works":["https://openalex.org/W43035074","https://openalex.org/W1485156179","https://openalex.org/W1559169059","https://openalex.org/W1964786778","https://openalex.org/W1983170052","https://openalex.org/W1997952460","https://openalex.org/W2000809552","https://openalex.org/W2047745978","https://openalex.org/W2077518845","https://openalex.org/W2089206172","https://openalex.org/W2108132403","https://openalex.org/W2112129552","https://openalex.org/W2112840274","https://openalex.org/W2119803607","https://openalex.org/W2142472956","https://openalex.org/W2153531471","https://openalex.org/W2159100004","https://openalex.org/W2162449239","https://openalex.org/W2165528679","https://openalex.org/W2167333415","https://openalex.org/W2170712852","https://openalex.org/W2254589950","https://openalex.org/W2295468252","https://openalex.org/W2539033431","https://openalex.org/W2912031392"],"related_works":["https://openalex.org/W2392606101","https://openalex.org/W2072918301","https://openalex.org/W3162070149","https://openalex.org/W2489943546","https://openalex.org/W2385315033","https://openalex.org/W2362842011","https://openalex.org/W1845544376","https://openalex.org/W1839867872","https://openalex.org/W2085316814","https://openalex.org/W2048090520"],"abstract_inverted_index":{"Quantitative":[0],"data":[1,14,19,49,65,118,124,134],"cleaning":[2,20],"relies":[3],"on":[4],"the":[5,22,41,56,63,132,143,150,210,225],"use":[6],"of":[7,28,35,100,152,206,212,277],"statistical":[8,68,139,155,178,267],"methods":[9],"to":[10,46,84,107,121,137],"identify":[11,108,188],"and":[12,127,196,199],"repair":[13,158,173,248,271],"quality":[15,50,125],"problems":[16,24,51],"while":[17,55,273],"logical":[18,29,42],"tackles":[21],"same":[23],"using":[25,52,93,142,180],"various":[26],"forms":[27],"reasoning":[30],"over":[31,183],"declarative":[32],"dependencies.":[33],"Each":[34],"these":[36,77],"approaches":[37,79],"has":[38,66,175],"its":[39],"strengths:":[40],"approach":[43,58],"is":[44,159,219,250],"able":[45],"capture":[47],"subtle":[48],"sophisticated":[53],"dependencies,":[54,97],"quantitative":[57],"excels":[59],"at":[60],"ensuring":[61],"that":[62,102,130,149,174,224,239,242,260],"repaired":[64],"desired":[67],"properties.":[69],"We":[70,89,147,237],"propose":[71],"a":[72,98,123,154,171,176,194,264],"novel":[73],"framework":[74,92],"within":[75],"which":[76],"two":[78],"can":[80,243],"be":[81,122,244],"used":[82],"synergistically":[83],"combine":[85],"their":[86],"respective":[87],"strengths.":[88],"instantiate":[90],"our":[91,247,261],"(i)":[94],"metric":[95,117,207,229],"functional":[96,104],"type":[99],"dependency":[101],"generalizes":[103],"dependencies":[105],"(FDs)":[106],"inconsistencies":[109],"in":[110,116,234],"domains":[111],"where":[112],"only":[113],"large":[114],"differences":[115],"are":[119],"considered":[120],"problem,":[126],"(ii)":[128],"repairs":[129],"modify":[131],"inconsistent":[133],"so":[135],"as":[136,233],"minimize":[138],"distortion,":[140],"measured":[141],"Earth":[144],"Mover's":[145],"Distance.":[146],"show":[148,223],"problem":[151,227],"computing":[153],"distortion":[156,179,268],"minimal":[157,172],"NP-hard.":[160],"Given":[161],"this":[162],"complexity,":[163],"we":[164,192,222],"present":[165,193],"an":[166,200],"efficient":[167,201],"algorithm":[168,202,249],"for":[169,203,214,228],"finding":[170],"small":[177],"EMD":[181],"computation":[182],"semantically":[184,189],"related":[185,190],"attributes.":[186],"To":[187],"attributes,":[191],"sound":[195],"complete":[197],"axiomatization":[198],"testing":[204],"implication":[205],"FDs.":[208,236],"While":[209],"complexity":[211],"inference":[213,226],"some":[215],"other":[216],"FD":[217],"extensions":[218],"co-NP":[220],"complete,":[221],"FDs":[230],"remains":[231],"linear,":[232],"traditional":[235],"prove":[238],"every":[240],"instance":[241],"generated":[245],"by":[246],"set-minimal":[251],"(with":[252],"no":[253],"unnecessary":[254],"changes).":[255],"Our":[256],"experimental":[257],"evaluation":[258],"demonstrates":[259],"techniques":[262],"obtain":[263],"considerably":[265],"lower":[266],"than":[269],"existing":[270],"techniques,":[272],"achieving":[274],"similar":[275],"levels":[276],"efficiency.":[278]},"counts_by_year":[{"year":2025,"cited_by_count":4},{"year":2024,"cited_by_count":5},{"year":2023,"cited_by_count":3},{"year":2022,"cited_by_count":9},{"year":2021,"cited_by_count":11},{"year":2020,"cited_by_count":16},{"year":2019,"cited_by_count":14},{"year":2018,"cited_by_count":26},{"year":2017,"cited_by_count":8},{"year":2016,"cited_by_count":7},{"year":2015,"cited_by_count":1}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}