{"id":"https://openalex.org/W143151647","doi":"https://doi.org/10.3233/978-1-60750-588-4-1122","title":"The Impact of a Growing Minority Population on Identification of Duplicate Records in an Enterprise Data Warehouse","display_name":"The Impact of a Growing Minority Population on Identification of Duplicate Records in an Enterprise Data Warehouse","publication_year":2010,"publication_date":"2010-01-01","ids":{"openalex":"https://openalex.org/W143151647","doi":"https://doi.org/10.3233/978-1-60750-588-4-1122","mag":"143151647","pmid":"https://pubmed.ncbi.nlm.nih.gov/20841858"},"language":"en","primary_location":{"id":"doi:10.3233/978-1-60750-588-4-1122","is_oa":false,"landing_page_url":"https://doi.org/10.3233/978-1-60750-588-4-1122","pdf_url":null,"source":{"id":"https://openalex.org/S4210179765","display_name":"Studies in health technology and informatics","issn_l":"0926-9630","issn":["0926-9630","1879-8365"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310318577","host_organization_name":"IOS Press","host_organization_lineage":["https://openalex.org/P4310318577"],"host_organization_lineage_names":["IOS Press"],"type":"book series"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Studies in Health Technology and Informatics","raw_type":"book-chapter"},"type":"article","indexed_in":["crossref","pubmed"],"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/A5037435182","display_name":"Scott L. DuVall","orcid":"https://orcid.org/0000-0002-4898-3865"},"institutions":[{"id":"https://openalex.org/I223532165","display_name":"University of Utah","ror":"https://ror.org/03r0ha626","country_code":"US","type":"education","lineage":["https://openalex.org/I223532165"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"DuVall Scott L.","raw_affiliation_strings":["Department of Biomedical Informatics, University of Utah, Salt Lake City, UT, USA. scott.duvall@utah.edu"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Department of Biomedical Informatics, University of Utah, Salt Lake City, UT, USA. scott.duvall@utah.edu","institution_ids":["https://openalex.org/I223532165"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5037111300","display_name":"Alison Fraser","orcid":"https://orcid.org/0000-0003-1681-698X"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Fraser Alison M.","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5071197369","display_name":"Richard A. Kerber","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Kerber Richard A.","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5024435238","display_name":"Geraldine P. Mineau","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Mineau Geraldine P.","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"last","author":{"id":"https://openalex.org/A5070286540","display_name":"Alun Thomas","orcid":"https://orcid.org/0000-0001-5650-7044"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Thomas Alun","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":5,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":7.4947,"has_fulltext":false,"cited_by_count":14,"citation_normalized_percentile":{"value":0.96855198,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":90,"max":98},"biblio":{"volume":"160","issue":"Pt 2","first_page":"1122","last_page":"6"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11719","display_name":"Data Quality and Management","score":0.9983000159263611,"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.9983000159263611,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/record-linkage","display_name":"Record linkage","score":0.7392843961715698},{"id":"https://openalex.org/keywords/linkage","display_name":"Linkage (software)","score":0.7217190861701965},{"id":"https://openalex.org/keywords/medical-record","display_name":"Medical record","score":0.6384857892990112},{"id":"https://openalex.org/keywords/data-warehouse","display_name":"Data warehouse","score":0.6384272575378418},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.6006683707237244},{"id":"https://openalex.org/keywords/identification","display_name":"Identification (biology)","score":0.5424668192863464},{"id":"https://openalex.org/keywords/set","display_name":"Set (abstract data type)","score":0.5345228314399719},{"id":"https://openalex.org/keywords/resource","display_name":"Resource (disambiguation)","score":0.5286439061164856},{"id":"https://openalex.org/keywords/population","display_name":"Population","score":0.5096404552459717},{"id":"https://openalex.org/keywords/health-records","display_name":"Health records","score":0.4675038754940033},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.4668391942977905},{"id":"https://openalex.org/keywords/process","display_name":"Process (computing)","score":0.4547833502292633},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.4120331108570099},{"id":"https://openalex.org/keywords/data-set","display_name":"Data set","score":0.41124388575553894},{"id":"https://openalex.org/keywords/data-science","display_name":"Data science","score":0.4089411497116089},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.3831712603569031},{"id":"https://openalex.org/keywords/health-care","display_name":"Health care","score":0.3761441111564636},{"id":"https://openalex.org/keywords/medicine","display_name":"Medicine","score":0.2457103729248047},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.08630058169364929},{"id":"https://openalex.org/keywords/biology","display_name":"Biology","score":0.08168110251426697}],"concepts":[{"id":"https://openalex.org/C142210648","wikidata":"https://www.wikidata.org/wiki/Q1266546","display_name":"Record linkage","level":3,"score":0.7392843961715698},{"id":"https://openalex.org/C31266012","wikidata":"https://www.wikidata.org/wiki/Q6554340","display_name":"Linkage (software)","level":3,"score":0.7217190861701965},{"id":"https://openalex.org/C195910791","wikidata":"https://www.wikidata.org/wiki/Q1324077","display_name":"Medical record","level":2,"score":0.6384857892990112},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.6384272575378418},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.6006683707237244},{"id":"https://openalex.org/C116834253","wikidata":"https://www.wikidata.org/wiki/Q2039217","display_name":"Identification (biology)","level":2,"score":0.5424668192863464},{"id":"https://openalex.org/C177264268","wikidata":"https://www.wikidata.org/wiki/Q1514741","display_name":"Set (abstract data type)","level":2,"score":0.5345228314399719},{"id":"https://openalex.org/C206345919","wikidata":"https://www.wikidata.org/wiki/Q20380951","display_name":"Resource (disambiguation)","level":2,"score":0.5286439061164856},{"id":"https://openalex.org/C2908647359","wikidata":"https://www.wikidata.org/wiki/Q2625603","display_name":"Population","level":2,"score":0.5096404552459717},{"id":"https://openalex.org/C3019952477","wikidata":"https://www.wikidata.org/wiki/Q1324077","display_name":"Health records","level":3,"score":0.4675038754940033},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.4668391942977905},{"id":"https://openalex.org/C98045186","wikidata":"https://www.wikidata.org/wiki/Q205663","display_name":"Process (computing)","level":2,"score":0.4547833502292633},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.4120331108570099},{"id":"https://openalex.org/C58489278","wikidata":"https://www.wikidata.org/wiki/Q1172284","display_name":"Data set","level":2,"score":0.41124388575553894},{"id":"https://openalex.org/C2522767166","wikidata":"https://www.wikidata.org/wiki/Q2374463","display_name":"Data science","level":1,"score":0.4089411497116089},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.3831712603569031},{"id":"https://openalex.org/C160735492","wikidata":"https://www.wikidata.org/wiki/Q31207","display_name":"Health care","level":2,"score":0.3761441111564636},{"id":"https://openalex.org/C71924100","wikidata":"https://www.wikidata.org/wiki/Q11190","display_name":"Medicine","level":0,"score":0.2457103729248047},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.08630058169364929},{"id":"https://openalex.org/C86803240","wikidata":"https://www.wikidata.org/wiki/Q420","display_name":"Biology","level":0,"score":0.08168110251426697},{"id":"https://openalex.org/C55493867","wikidata":"https://www.wikidata.org/wiki/Q7094","display_name":"Biochemistry","level":1,"score":0.0},{"id":"https://openalex.org/C99454951","wikidata":"https://www.wikidata.org/wiki/Q932068","display_name":"Environmental health","level":1,"score":0.0},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.0},{"id":"https://openalex.org/C126838900","wikidata":"https://www.wikidata.org/wiki/Q77604","display_name":"Radiology","level":1,"score":0.0},{"id":"https://openalex.org/C50522688","wikidata":"https://www.wikidata.org/wiki/Q189833","display_name":"Economic growth","level":1,"score":0.0},{"id":"https://openalex.org/C104317684","wikidata":"https://www.wikidata.org/wiki/Q7187","display_name":"Gene","level":2,"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/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.0},{"id":"https://openalex.org/C59822182","wikidata":"https://www.wikidata.org/wiki/Q441","display_name":"Botany","level":1,"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":[{"descriptor_ui":"D003625","descriptor_name":"Data Collection","qualifier_ui":null,"qualifier_name":null,"is_major_topic":false},{"descriptor_ui":"D003625","descriptor_name":"Data Collection","qualifier_ui":null,"qualifier_name":null,"is_major_topic":false},{"descriptor_ui":"D003625","descriptor_name":"Data Collection","qualifier_ui":null,"qualifier_name":null,"is_major_topic":false},{"descriptor_ui":"D006801","descriptor_name":"Humans","qualifier_ui":null,"qualifier_name":null,"is_major_topic":false},{"descriptor_ui":"D006801","descriptor_name":"Humans","qualifier_ui":null,"qualifier_name":null,"is_major_topic":false},{"descriptor_ui":"D006801","descriptor_name":"Humans","qualifier_ui":null,"qualifier_name":null,"is_major_topic":false},{"descriptor_ui":"D008498","descriptor_name":"Medical Record Linkage","qualifier_ui":"Q000379","qualifier_name":"methods","is_major_topic":false},{"descriptor_ui":"D008498","descriptor_name":"Medical Record Linkage","qualifier_ui":"Q000379","qualifier_name":"methods","is_major_topic":false},{"descriptor_ui":"D008498","descriptor_name":"Medical Record Linkage","qualifier_ui":"Q000379","qualifier_name":"methods","is_major_topic":false},{"descriptor_ui":"D008498","descriptor_name":"Medical Record Linkage","qualifier_ui":"Q000592","qualifier_name":"standards","is_major_topic":false},{"descriptor_ui":"D008498","descriptor_name":"Medical Record Linkage","qualifier_ui":"Q000592","qualifier_name":"standards","is_major_topic":false},{"descriptor_ui":"D008498","descriptor_name":"Medical Record Linkage","qualifier_ui":"Q000592","qualifier_name":"standards","is_major_topic":false},{"descriptor_ui":"D008913","descriptor_name":"Minority Groups","qualifier_ui":null,"qualifier_name":null,"is_major_topic":true},{"descriptor_ui":"D008913","descriptor_name":"Minority Groups","qualifier_ui":null,"qualifier_name":null,"is_major_topic":true},{"descriptor_ui":"D008913","descriptor_name":"Minority Groups","qualifier_ui":null,"qualifier_name":null,"is_major_topic":true},{"descriptor_ui":"D016208","descriptor_name":"Databases, Factual","qualifier_ui":null,"qualifier_name":null,"is_major_topic":false},{"descriptor_ui":"D016208","descriptor_name":"Databases, Factual","qualifier_ui":null,"qualifier_name":null,"is_major_topic":false},{"descriptor_ui":"D016208","descriptor_name":"Databases, Factual","qualifier_ui":null,"qualifier_name":null,"is_major_topic":false},{"descriptor_ui":"D016347","descriptor_name":"Medical Records Systems, Computerized","qualifier_ui":"Q000592","qualifier_name":"standards","is_major_topic":false},{"descriptor_ui":"D016347","descriptor_name":"Medical Records Systems, Computerized","qualifier_ui":"Q000592","qualifier_name":"standards","is_major_topic":false},{"descriptor_ui":"D016347","descriptor_name":"Medical Records Systems, Computerized","qualifier_ui":"Q000592","qualifier_name":"standards","is_major_topic":false}],"locations_count":2,"locations":[{"id":"doi:10.3233/978-1-60750-588-4-1122","is_oa":false,"landing_page_url":"https://doi.org/10.3233/978-1-60750-588-4-1122","pdf_url":null,"source":{"id":"https://openalex.org/S4210179765","display_name":"Studies in health technology and informatics","issn_l":"0926-9630","issn":["0926-9630","1879-8365"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310318577","host_organization_name":"IOS Press","host_organization_lineage":["https://openalex.org/P4310318577"],"host_organization_lineage_names":["IOS Press"],"type":"book series"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Studies in Health Technology and Informatics","raw_type":"book-chapter"},{"id":"pmid:20841858","is_oa":false,"landing_page_url":"https://pubmed.ncbi.nlm.nih.gov/20841858","pdf_url":null,"source":{"id":"https://openalex.org/S4306525036","display_name":"PubMed","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I1299303238","host_organization_name":"National Institutes of Health","host_organization_lineage":["https://openalex.org/I1299303238"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Studies in health technology and informatics","raw_type":null}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":0,"referenced_works":[],"related_works":["https://openalex.org/W2099525665","https://openalex.org/W2487032012","https://openalex.org/W2211355040","https://openalex.org/W2808916796","https://openalex.org/W2176311362","https://openalex.org/W3012491082","https://openalex.org/W3211905090","https://openalex.org/W1936317645","https://openalex.org/W4310568775","https://openalex.org/W2178148352"],"abstract_inverted_index":{"Patient":[0],"medical":[1,45],"records":[2,14,25,42,77,111,149],"are":[3,197],"often":[4],"fragmented":[5],"across":[6],"disparate":[7],"healthcare":[8],"databases,":[9],"potentially":[10],"resulting":[11],"in":[12,43,167,171,191,223,238],"duplicate":[13,24,41,76,96,240],"that":[15,110,230],"may":[16],"be":[17,27,163,183,214],"detrimental":[18],"to":[19,51,64,187,218],"health":[20],"care":[21],"services.":[22],"These":[23,180],"can":[26,162,213,235],"found":[28,48],"through":[29],"a":[30,38,44,144,157],"process":[31,159],"called":[32],"record":[33],"linkage.":[34],"This":[35,206],"paper":[36,207],"describes":[37,208],"set":[39,94],"of":[40,95,143],"data":[46,99,168,172,178],"warehouse":[47],"by":[49,165,201],"linking":[50],"an":[52,79,215],"external":[53,80,103,177,228],"resource":[54],"containing":[55],"family":[56],"history":[57],"and":[58,70,90,101,119,174,196,220,226],"vital":[59],"records.":[60,241],"Our":[61],"objective":[62],"was":[63,137],"investigate":[65],"the":[66,93,98,102,108,141],"impact":[67],"database":[68],"characteristics":[69,118],"linkage":[71,120,155,204,224],"methods":[72,121],"have":[73,115],"on":[74,176],"identifying":[75],"using":[78],"resource.":[81,104],"Frequency":[82],"counts":[83,131],"were":[84,122,127,150],"made":[85],"for":[86,106],"demographic":[87],"field":[88],"values":[89],"compared":[91],"between":[92,132],"records,":[97],"warehouse,":[100],"Considerations":[105],"understanding":[107],"relationship":[109],"labeled":[112],"as":[113,152],"duplicates":[114],"with":[116],"dataset":[117],"identified.":[123],"Several":[124],"noticeable":[125],"patterns":[126],"identified":[128,151],"where":[129,160],"frequency":[130,210],"sets":[133],"deviated":[134],"from":[135],"what":[136],"expected":[138],"including":[139],"how":[140,209,227],"growth":[142],"minority":[145],"population":[146],"affected":[147,164],"which":[148],"duplicates.":[153],"Record":[154],"is":[156],"complex":[158],"results":[161,192,225],"subtleties":[166],"characteristics,":[169],"changes":[170,181],"trends,":[173],"reliance":[175],"sources.":[179],"should":[182],"taken":[184],"into":[185],"account":[186],"ensure":[188],"any":[189],"anomalies":[190,222],"describe":[193],"real":[194],"effects":[195],"not":[198],"artifacts":[199],"caused":[200],"datasets":[202],"or":[203],"methods.":[205],"count":[211],"analysis":[212],"effective":[216],"way":[217],"detect":[219],"resolve":[221],"resources":[229],"provide":[231],"additional":[232],"contextual":[233],"information":[234],"prove":[236],"useful":[237],"discovering":[239]},"counts_by_year":[{"year":2024,"cited_by_count":1},{"year":2023,"cited_by_count":1},{"year":2018,"cited_by_count":1},{"year":2015,"cited_by_count":1},{"year":2014,"cited_by_count":1},{"year":2013,"cited_by_count":4},{"year":2012,"cited_by_count":4}],"updated_date":"2026-06-11T09:08:48.828518","created_date":"2025-10-10T00:00:00"}