{"id":"https://openalex.org/W2972560380","doi":"https://doi.org/10.4018/ijdwm.2019100103","title":"A Comparative Study of Data Cleaning Tools","display_name":"A Comparative Study of Data Cleaning Tools","publication_year":2019,"publication_date":"2019-09-13","ids":{"openalex":"https://openalex.org/W2972560380","doi":"https://doi.org/10.4018/ijdwm.2019100103","mag":"2972560380"},"language":"en","primary_location":{"id":"doi:10.4018/ijdwm.2019100103","is_oa":false,"landing_page_url":"https://doi.org/10.4018/ijdwm.2019100103","pdf_url":null,"source":{"id":"https://openalex.org/S53932126","display_name":"International Journal of Data Warehousing and Mining","issn_l":"1548-3924","issn":["1548-3924","1548-3932"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320424","host_organization_name":"IGI Global","host_organization_lineage":["https://openalex.org/P4310320424"],"host_organization_lineage_names":["IGI Global"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"International Journal of Data Warehousing and Mining","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/A5023729569","display_name":"Samson Oni","orcid":null},"institutions":[{"id":"https://openalex.org/I79272384","display_name":"University of Maryland, Baltimore County","ror":"https://ror.org/02qskvh78","country_code":"US","type":"education","lineage":["https://openalex.org/I79272384"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"Samson Oni","raw_affiliation_strings":["University of Maryland Baltimore County, USA"],"affiliations":[{"raw_affiliation_string":"University of Maryland Baltimore County, USA","institution_ids":["https://openalex.org/I79272384"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5100438515","display_name":"Zhiyuan Chen","orcid":"https://orcid.org/0000-0002-6984-7248"},"institutions":[{"id":"https://openalex.org/I79272384","display_name":"University of Maryland, Baltimore County","ror":"https://ror.org/02qskvh78","country_code":"US","type":"education","lineage":["https://openalex.org/I79272384"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Zhiyuan Chen","raw_affiliation_strings":["University of Maryland Baltimore County, USA"],"affiliations":[{"raw_affiliation_string":"University of Maryland Baltimore County, USA","institution_ids":["https://openalex.org/I79272384"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5031483502","display_name":"S. Hoban","orcid":null},"institutions":[{"id":"https://openalex.org/I79272384","display_name":"University of Maryland, Baltimore County","ror":"https://ror.org/02qskvh78","country_code":"US","type":"education","lineage":["https://openalex.org/I79272384"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Susan Hoban","raw_affiliation_strings":["University of Maryland, Baltimore County, USA"],"affiliations":[{"raw_affiliation_string":"University of Maryland, Baltimore County, USA","institution_ids":["https://openalex.org/I79272384"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5070492345","display_name":"Onimi Jademi","orcid":null},"institutions":[{"id":"https://openalex.org/I79272384","display_name":"University of Maryland, Baltimore County","ror":"https://ror.org/02qskvh78","country_code":"US","type":"education","lineage":["https://openalex.org/I79272384"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Onimi Jademi","raw_affiliation_strings":["University of Maryland, Baltimore County, USA"],"affiliations":[{"raw_affiliation_string":"University of Maryland, Baltimore County, USA","institution_ids":["https://openalex.org/I79272384"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":4,"corresponding_author_ids":["https://openalex.org/A5023729569"],"corresponding_institution_ids":["https://openalex.org/I79272384"],"apc_list":null,"apc_paid":null,"fwci":1.1883,"has_fulltext":false,"cited_by_count":14,"citation_normalized_percentile":{"value":0.81435832,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":98},"biblio":{"volume":"15","issue":"4","first_page":"48","last_page":"65"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11719","display_name":"Data Quality and Management","score":0.9980999827384949,"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.9980999827384949,"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/T11891","display_name":"Big Data and Business Intelligence","score":0.9901000261306763,"subfield":{"id":"https://openalex.org/subfields/1404","display_name":"Management Information Systems"},"field":{"id":"https://openalex.org/fields/14","display_name":"Business, Management and Accounting"},"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.9660000205039978,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8301966786384583},{"id":"https://openalex.org/keywords/data-science","display_name":"Data science","score":0.6311259269714355},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.47324877977371216}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8301966786384583},{"id":"https://openalex.org/C2522767166","wikidata":"https://www.wikidata.org/wiki/Q2374463","display_name":"Data science","level":1,"score":0.6311259269714355},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.47324877977371216}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.4018/ijdwm.2019100103","is_oa":false,"landing_page_url":"https://doi.org/10.4018/ijdwm.2019100103","pdf_url":null,"source":{"id":"https://openalex.org/S53932126","display_name":"International Journal of Data Warehousing and Mining","issn_l":"1548-3924","issn":["1548-3924","1548-3932"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320424","host_organization_name":"IGI Global","host_organization_lineage":["https://openalex.org/P4310320424"],"host_organization_lineage_names":["IGI Global"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"International Journal of Data Warehousing and Mining","raw_type":"journal-article"},{"id":"pmh:oai:RePEc:igg:jdwm00:v:15:y:2019:i:4:p:48-65","is_oa":false,"landing_page_url":"https://services.igi-global.com/resolvedoi/resolve.aspx?doi=10.4018/IJDWM.2019100103","pdf_url":null,"source":{"id":"https://openalex.org/S4306401271","display_name":"RePEc: Research Papers in Economics","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I77793887","host_organization_name":"Federal Reserve Bank of St. Louis","host_organization_lineage":["https://openalex.org/I77793887"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":16,"referenced_works":["https://openalex.org/W1551385575","https://openalex.org/W1610496399","https://openalex.org/W1971518725","https://openalex.org/W2064766209","https://openalex.org/W2089634871","https://openalex.org/W2102568991","https://openalex.org/W2121649921","https://openalex.org/W2127767383","https://openalex.org/W2131576956","https://openalex.org/W2133297572","https://openalex.org/W2151763080","https://openalex.org/W2405680777","https://openalex.org/W2522336998","https://openalex.org/W2748073839","https://openalex.org/W4250102289","https://openalex.org/W4285719527"],"related_works":["https://openalex.org/W2748952813","https://openalex.org/W2390279801","https://openalex.org/W2358668433","https://openalex.org/W2376932109","https://openalex.org/W2001405890","https://openalex.org/W2382290278","https://openalex.org/W2478288626","https://openalex.org/W4391913857","https://openalex.org/W2350741829","https://openalex.org/W2530322880"],"abstract_inverted_index":{"In":[0],"the":[1,29,48,89,115],"information":[2],"era,":[3],"data":[4,11,32,49,59,66,93,105,111],"is":[5,34,71],"crucial":[6],"in":[7,77],"decision":[8,24],"making.":[9],"Most":[10],"sets":[12,112],"contain":[13],"impurities":[14],"that":[15],"need":[16],"to":[17,74],"be":[18,26,56,122],"weeded":[19],"out":[20],"before":[21],"any":[22],"meaningful":[23],"can":[25],"made":[27],"from":[28],"data.":[30],"Hence,":[31],"cleaning":[33,67,106],"essential":[35],"and":[36,45,53,86,113],"often":[37],"takes":[38],"more":[39],"than":[40],"80":[41],"percent":[42],"of":[43,47,65,101,118],"time":[44],"resources":[46],"analyst.":[50],"Adequate":[51],"tools":[52,68,91,107],"techniques":[54],"must":[55],"used":[57,104],"for":[58,92],"cleaning.":[60,94],"There":[61],"exist":[62],"a":[63,98],"lot":[64],"but":[69],"it":[70],"unclear":[72],"how":[73],"choose":[75,88],"them":[76],"various":[78],"situations.":[79],"This":[80,95],"research":[81,116],"aims":[82],"at":[83],"helping":[84],"researchers":[85],"organizations":[87],"right":[90],"article":[96],"conducts":[97],"comparative":[99],"study":[100],"four":[102],"commonly":[103],"on":[108,125],"two":[109],"real":[110],"answers":[114],"question":[117],"which":[119],"tool":[120],"will":[121],"useful":[123],"based":[124],"different":[126],"scenario.":[127]},"counts_by_year":[{"year":2025,"cited_by_count":3},{"year":2023,"cited_by_count":5},{"year":2022,"cited_by_count":3},{"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"}