{"id":"https://openalex.org/W2394811972","doi":"https://doi.org/10.1145/3035918.3035925","title":"QFix: Diagnosing Errors through Query Histories","display_name":"QFix: Diagnosing Errors through Query Histories","alternate_titles":[],"publication_year":2017,"publication_date":"2017-05-09","ids":{"openalex":"https://openalex.org/W2394811972","doi":"https://doi.org/10.1145/3035918.3035925","mag":"2394811972"},"language":"en","primary_location":{"id":"doi:10.1145/3035918.3035925","doi":"https://doi.org/10.1145/3035918.3035925","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3035918.3035925","pdf_url":null,"source":{"id":"https://openalex.org/S4393915683","display_name":"ACM SIGMOD International Conference on Management of Data (SIGMOD)","issn_l":"0730-8078","issn":["0730-8078"],"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":["norway-1"],"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":"conference"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2017 ACM International Conference on Management of Data","raw_type":"proceedings-article"},"parent_works":[],"lineage":["https://openalex.org/W2394811972"],"child_works_count":0,"type":"conference-paper","is_traditional":true,"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/A5100767225","display_name":"Xiaolan Wang","orcid":"https://orcid.org/0000-0002-2293-5160","observed_orcids":["https://orcid.org/0000-0002-2293-5160"]},"institutions":[{"id":"https://openalex.org/I24603500","display_name":"University of Massachusetts Amherst","ror":"https://ror.org/0072zz521","country_code":"US","type":"education","lineage":["https://openalex.org/I24603500"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Xiaolan Wang","raw_affiliation_strings":["University of Massachusetts, Amherst, MA, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Massachusetts, Amherst, MA, USA","institution_ids":["https://openalex.org/I24603500"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5019048013","display_name":"Alexandra Meliou","orcid":"https://orcid.org/0000-0001-7346-6002","observed_orcids":["https://orcid.org/0000-0001-7346-6002"]},"institutions":[{"id":"https://openalex.org/I24603500","display_name":"University of Massachusetts Amherst","ror":"https://ror.org/0072zz521","country_code":"US","type":"education","lineage":["https://openalex.org/I24603500"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Alexandra Meliou","raw_affiliation_strings":["University of Massachusetts, Amherst, MA, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Massachusetts, Amherst, MA, USA","institution_ids":["https://openalex.org/I24603500"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5049016095","display_name":"Eugene Wu","orcid":"https://orcid.org/0000-0003-4254-6688","observed_orcids":["https://orcid.org/0000-0003-4254-6688"]},"institutions":[{"id":"https://openalex.org/I78577930","display_name":"Columbia University","ror":"https://ror.org/00hj8s172","country_code":"US","type":"education","lineage":["https://openalex.org/I78577930"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Eugene Wu","raw_affiliation_strings":["Columbia University, New York City, NY, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Columbia University, New York City, NY, USA","institution_ids":["https://openalex.org/I78577930"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":3.0486,"has_fulltext":false,"cited_by_count":38,"citation_normalized_percentile":{"value":0.93420057,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":91,"max":98},"biblio":{"volume":null,"issue":null,"first_page":"1369","last_page":"1384"},"is_retracted":false,"is_pulled":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11719","display_name":"Data Quality and Management","score":0.8598999977111816,"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"}},"topics":[{"id":"https://openalex.org/T11719","display_name":"Data Quality and Management","score":0.8598999977111816,"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.10830000042915344,"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/T10260","display_name":"Software Engineering Research","score":0.0034000000450760126,"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/data-quality","display_name":"data quality","score":0.6650000214576721},{"id":"https://openalex.org/keywords/data-errors","display_name":"data errors","score":0.5799999833106995},{"id":"https://openalex.org/keywords/error-propagation","display_name":"error propagation","score":0.7409999966621399},{"id":"https://openalex.org/keywords/data-cleaning","display_name":"data cleaning","score":0.6169999837875366},{"id":"https://openalex.org/keywords/data-discrepancies","display_name":"data discrepancies","score":0.37700000405311584},{"id":"https://openalex.org/keywords/data-correctness","display_name":"data correctness","score":0.47999998927116394},{"id":"https://openalex.org/keywords/error-detection","display_name":"error detection","score":0.5120000243186951}],"concepts":[{"id":"https://openalex.org/C55439883","wikidata":"https://www.wikidata.org/wiki/Q360812","display_name":"Correctness","level":2,"score":0.8340507745742798},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7921494245529175},{"id":"https://openalex.org/C14036430","wikidata":"https://www.wikidata.org/wiki/Q3736076","display_name":"Function (biology)","level":2,"score":0.5908465385437012},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.4551905691623688},{"id":"https://openalex.org/C195487862","wikidata":"https://www.wikidata.org/wiki/Q850210","display_name":"Revenue","level":2,"score":0.4147419035434723},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.2683049440383911},{"id":"https://openalex.org/C10138342","wikidata":"https://www.wikidata.org/wiki/Q43015","display_name":"Finance","level":1,"score":0.07646778225898743},{"id":"https://openalex.org/C78458016","wikidata":"https://www.wikidata.org/wiki/Q840400","display_name":"Evolutionary biology","level":1,"score":0.0},{"id":"https://openalex.org/C86803240","wikidata":"https://www.wikidata.org/wiki/Q420","display_name":"Biology","level":0,"score":0.0},{"id":"https://openalex.org/C162324750","wikidata":"https://www.wikidata.org/wiki/Q8134","display_name":"Economics","level":0,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/3035918.3035925","doi":"https://doi.org/10.1145/3035918.3035925","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3035918.3035925","pdf_url":null,"source":{"id":"https://openalex.org/S4393915683","display_name":"ACM SIGMOD International Conference on Management of Data (SIGMOD)","issn_l":"0730-8078","issn":["0730-8078"],"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":["norway-1"],"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":"conference"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2017 ACM International Conference on Management of Data","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[],"study_designs":[],"awards":[{"id":"https://openalex.org/G1576246179","display_name":"CAREER: Reverse Data Management: Reverse-Engineering Data Transformations to Understand, Diagnose, and Manipulate Data","funder_award_id":"1453543","funder_id":"https://openalex.org/F4320306076","funder_display_name":"National Science Foundation"},{"id":"https://openalex.org/G8231386676","display_name":"III: Small: Collaborative Research: The Package Query Paradigm","funder_award_id":"1421322","funder_id":"https://openalex.org/F4320306076","funder_display_name":"National Science Foundation"}],"funders":[{"id":"https://openalex.org/F4320306076","display_name":"National Science Foundation","ror":"https://ror.org/021nxhr62"}],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":74,"referenced_works":["https://openalex.org/W169198699","https://openalex.org/W596083649","https://openalex.org/W1551438051","https://openalex.org/W1552694902","https://openalex.org/W1610496399","https://openalex.org/W1983178058","https://openalex.org/W2000809552","https://openalex.org/W2004489140","https://openalex.org/W2006455928","https://openalex.org/W2007682403","https://openalex.org/W2008138653","https://openalex.org/W2008806832","https://openalex.org/W2010997912","https://openalex.org/W2013463306","https://openalex.org/W2014328192","https://openalex.org/W2022171653","https://openalex.org/W2022953760","https://openalex.org/W2023052779","https://openalex.org/W2024834471","https://openalex.org/W2026080429","https://openalex.org/W2038639056","https://openalex.org/W2039548475","https://openalex.org/W2044102377","https://openalex.org/W2044469685","https://openalex.org/W2046298800","https://openalex.org/W2047182010","https://openalex.org/W2048864522","https://openalex.org/W2049505431","https://openalex.org/W2062340526","https://openalex.org/W2063103859","https://openalex.org/W2064766209","https://openalex.org/W2066875914","https://openalex.org/W2074663022","https://openalex.org/W2087183379","https://openalex.org/W2088958550","https://openalex.org/W2098961002","https://openalex.org/W2099454382","https://openalex.org/W2100115937","https://openalex.org/W2102843095","https://openalex.org/W2103219113","https://openalex.org/W2106106289","https://openalex.org/W2106895292","https://openalex.org/W2107966677","https://openalex.org/W2110411158","https://openalex.org/W2112840274","https://openalex.org/W2115010808","https://openalex.org/W2118388899","https://openalex.org/W2118978333","https://openalex.org/W2127685175","https://openalex.org/W2128420091","https://openalex.org/W2133409729","https://openalex.org/W2133986470","https://openalex.org/W2136931788","https://openalex.org/W2137775416","https://openalex.org/W2138729760","https://openalex.org/W2140007372","https://openalex.org/W2151763080","https://openalex.org/W2164334663","https://openalex.org/W2167541073","https://openalex.org/W2169585110","https://openalex.org/W2171332293","https://openalex.org/W2240667924","https://openalex.org/W2261544779","https://openalex.org/W2293299776","https://openalex.org/W2295333720","https://openalex.org/W2402668406","https://openalex.org/W2421097601","https://openalex.org/W2544486974","https://openalex.org/W2554303125","https://openalex.org/W2625773614","https://openalex.org/W2741236518","https://openalex.org/W2915903792","https://openalex.org/W4246215794","https://openalex.org/W4250102289"],"related_works":["https://openalex.org/W2952551828","https://openalex.org/W2000809552","https://openalex.org/W2039548475","https://openalex.org/W2948434003","https://openalex.org/W4400909558","https://openalex.org/W2746437214","https://openalex.org/W2078132546","https://openalex.org/W1488893975","https://openalex.org/W2544486974","https://openalex.org/W1545761598"],"abstract_inverted_index":{"Data-driven":[0],"applications":[1,49],"rely":[2],"on":[3,89],"the":[4,45,54,71,95,103],"correctness":[5],"of":[6,26,41,79,102],"their":[7],"data":[8,16,35,46,55],"to":[9,24],"function":[10],"properly":[11],"and":[12,21,30,50,67,99],"effectively.":[13],"Errors":[14],"in":[15],"can":[17,38,56,63],"be":[18],"incredibly":[19],"costly":[20],"disruptive,":[22],"leading":[23],"loss":[25],"revenue,":[27],"incorrect":[28],"conclusions,":[29],"misguided":[31],"policy":[32],"decisions.":[33],"While":[34],"cleaning":[36],"tools":[37],"purge":[39],"datasets":[40],"many":[42],"errors":[43,66,105],"before":[44],"is":[47],"used,":[48],"users":[51],"interacting":[52],"with":[53],"introduce":[57],"new":[58],"errors.":[59],"Subsequent":[60],"valid":[61],"updates":[62],"obscure":[64],"these":[65,80],"propagate":[68],"them":[69],"through":[70],"dataset":[72],"causing":[73],"more":[74],"discrepancies.":[75],"Even":[76],"when":[77],"some":[78],"discrepancies":[81],"are":[82,85],"discovered,":[83],"they":[84],"often":[86],"corrected":[87],"superficially,":[88],"a":[90],"case-by-case":[91],"basis,":[92],"further":[93],"obscuring":[94],"true":[96],"underlying":[97],"cause,":[98],"making":[100],"detection":[101],"remaining":[104],"harder.":[106]},"cited_by_api_url":"https://api.openalex.org/works?filter=cites:W2394811972","counts_by_year":[{"year":2026,"cited_by_count":3},{"year":2025,"cited_by_count":4},{"year":2024,"cited_by_count":3},{"year":2023,"cited_by_count":3},{"year":2022,"cited_by_count":2},{"year":2021,"cited_by_count":3},{"year":2020,"cited_by_count":7},{"year":2019,"cited_by_count":7},{"year":2018,"cited_by_count":3},{"year":2017,"cited_by_count":3}],"updated_date":"2026-11-18T13:11:19.462570","created_date":"2016-06-24T00:00:00"}
