{"id":"https://openalex.org/W3119296476","doi":"https://doi.org/10.1109/acit50332.2020.9300119","title":"A Framework for Improving Data Quality in Data Warehouse: A Case Study","display_name":"A Framework for Improving Data Quality in Data Warehouse: A Case Study","publication_year":2020,"publication_date":"2020-11-28","ids":{"openalex":"https://openalex.org/W3119296476","doi":"https://doi.org/10.1109/acit50332.2020.9300119","mag":"3119296476"},"language":"en","primary_location":{"id":"doi:10.1109/acit50332.2020.9300119","is_oa":false,"landing_page_url":"https://doi.org/10.1109/acit50332.2020.9300119","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2020 21st International Arab Conference on Information Technology (ACIT)","raw_type":"proceedings-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/A5009015512","display_name":"Taghrid Z. Ali","orcid":null},"institutions":[{"id":"https://openalex.org/I4210161365","display_name":"Libyan Academy","ror":"https://ror.org/05s3qq987","country_code":"LY","type":"education","lineage":["https://openalex.org/I4210161365"]}],"countries":["LY"],"is_corresponding":true,"raw_author_name":"Taghrid Z. Ali","raw_affiliation_strings":["Higher Institute for Engineering, Libya"],"affiliations":[{"raw_affiliation_string":"Higher Institute for Engineering, Libya","institution_ids":["https://openalex.org/I4210161365"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5112597771","display_name":"Tawfig M. Abdelaziz","orcid":null},"institutions":[{"id":"https://openalex.org/I4210153362","display_name":"Libyan International Medical University","ror":"https://ror.org/04ftkte05","country_code":"LY","type":"education","lineage":["https://openalex.org/I4210153362"]}],"countries":["LY"],"is_corresponding":false,"raw_author_name":"Tawfig M. Abdelaziz","raw_affiliation_strings":["Faculty of Information Technology, Libyan International Medical University, Libya"],"affiliations":[{"raw_affiliation_string":"Faculty of Information Technology, Libyan International Medical University, Libya","institution_ids":["https://openalex.org/I4210153362"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5046131441","display_name":"Abdelsalam M. Maatuk","orcid":"https://orcid.org/0000-0001-9133-8389"},"institutions":[{"id":"https://openalex.org/I31439502","display_name":"University of Benghazi","ror":"https://ror.org/03fh7t044","country_code":"LY","type":"education","lineage":["https://openalex.org/I31439502"]}],"countries":["LY"],"is_corresponding":false,"raw_author_name":"Abdelsalam M. Maatuk","raw_affiliation_strings":["Faculty of Information Technology, University of Benghazi, Libya"],"affiliations":[{"raw_affiliation_string":"Faculty of Information Technology, University of Benghazi, Libya","institution_ids":["https://openalex.org/I31439502"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5021699212","display_name":"Salwa Elakeili","orcid":null},"institutions":[{"id":"https://openalex.org/I31439502","display_name":"University of Benghazi","ror":"https://ror.org/03fh7t044","country_code":"LY","type":"education","lineage":["https://openalex.org/I31439502"]}],"countries":["LY"],"is_corresponding":false,"raw_author_name":"Salwa M. Elakeili","raw_affiliation_strings":["Faculty of Information Technology, University of Benghazi, Libya"],"affiliations":[{"raw_affiliation_string":"Faculty of Information Technology, University of Benghazi, Libya","institution_ids":["https://openalex.org/I31439502"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":4,"corresponding_author_ids":["https://openalex.org/A5009015512"],"corresponding_institution_ids":["https://openalex.org/I4210161365"],"apc_list":null,"apc_paid":null,"fwci":0.7181,"has_fulltext":false,"cited_by_count":6,"citation_normalized_percentile":{"value":0.75846501,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":97},"biblio":{"volume":null,"issue":null,"first_page":"1","last_page":"8"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11719","display_name":"Data Quality and Management","score":0.9991000294685364,"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.9991000294685364,"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.9750999808311462,"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/T11614","display_name":"Cloud Data Security Solutions","score":0.9728999733924866,"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-warehouse","display_name":"Data warehouse","score":0.946271538734436},{"id":"https://openalex.org/keywords/data-quality","display_name":"Data quality","score":0.7387863397598267},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.6650837063789368},{"id":"https://openalex.org/keywords/dimensional-modeling","display_name":"Dimensional modeling","score":0.6434323191642761},{"id":"https://openalex.org/keywords/quality","display_name":"Quality (philosophy)","score":0.6110334396362305},{"id":"https://openalex.org/keywords/data-science","display_name":"Data science","score":0.5113961100578308},{"id":"https://openalex.org/keywords/obstacle","display_name":"Obstacle","score":0.48440009355545044},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.4707998037338257},{"id":"https://openalex.org/keywords/field","display_name":"Field (mathematics)","score":0.4623919725418091},{"id":"https://openalex.org/keywords/process","display_name":"Process (computing)","score":0.44091635942459106},{"id":"https://openalex.org/keywords/business-intelligence","display_name":"Business intelligence","score":0.4322524964809418},{"id":"https://openalex.org/keywords/data-governance","display_name":"Data governance","score":0.4278859794139862},{"id":"https://openalex.org/keywords/process-management","display_name":"Process management","score":0.36091965436935425},{"id":"https://openalex.org/keywords/engineering","display_name":"Engineering","score":0.1514405608177185},{"id":"https://openalex.org/keywords/operations-management","display_name":"Operations management","score":0.12375342845916748}],"concepts":[{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.946271538734436},{"id":"https://openalex.org/C24756922","wikidata":"https://www.wikidata.org/wiki/Q1757694","display_name":"Data quality","level":3,"score":0.7387863397598267},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.6650837063789368},{"id":"https://openalex.org/C143008350","wikidata":"https://www.wikidata.org/wiki/Q3432172","display_name":"Dimensional modeling","level":2,"score":0.6434323191642761},{"id":"https://openalex.org/C2779530757","wikidata":"https://www.wikidata.org/wiki/Q1207505","display_name":"Quality (philosophy)","level":2,"score":0.6110334396362305},{"id":"https://openalex.org/C2522767166","wikidata":"https://www.wikidata.org/wiki/Q2374463","display_name":"Data science","level":1,"score":0.5113961100578308},{"id":"https://openalex.org/C2776650193","wikidata":"https://www.wikidata.org/wiki/Q264661","display_name":"Obstacle","level":2,"score":0.48440009355545044},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.4707998037338257},{"id":"https://openalex.org/C9652623","wikidata":"https://www.wikidata.org/wiki/Q190109","display_name":"Field (mathematics)","level":2,"score":0.4623919725418091},{"id":"https://openalex.org/C98045186","wikidata":"https://www.wikidata.org/wiki/Q205663","display_name":"Process (computing)","level":2,"score":0.44091635942459106},{"id":"https://openalex.org/C2767350","wikidata":"https://www.wikidata.org/wiki/Q6662173","display_name":"Business intelligence","level":2,"score":0.4322524964809418},{"id":"https://openalex.org/C196879817","wikidata":"https://www.wikidata.org/wiki/Q872685","display_name":"Data governance","level":4,"score":0.4278859794139862},{"id":"https://openalex.org/C195094911","wikidata":"https://www.wikidata.org/wiki/Q14167904","display_name":"Process management","level":1,"score":0.36091965436935425},{"id":"https://openalex.org/C127413603","wikidata":"https://www.wikidata.org/wiki/Q11023","display_name":"Engineering","level":0,"score":0.1514405608177185},{"id":"https://openalex.org/C21547014","wikidata":"https://www.wikidata.org/wiki/Q1423657","display_name":"Operations management","level":1,"score":0.12375342845916748},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"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/C176217482","wikidata":"https://www.wikidata.org/wiki/Q860554","display_name":"Metric (unit)","level":2,"score":0.0},{"id":"https://openalex.org/C17744445","wikidata":"https://www.wikidata.org/wiki/Q36442","display_name":"Political science","level":0,"score":0.0},{"id":"https://openalex.org/C199539241","wikidata":"https://www.wikidata.org/wiki/Q7748","display_name":"Law","level":1,"score":0.0},{"id":"https://openalex.org/C202444582","wikidata":"https://www.wikidata.org/wiki/Q837863","display_name":"Pure mathematics","level":1,"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/C138885662","wikidata":"https://www.wikidata.org/wiki/Q5891","display_name":"Philosophy","level":0,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1109/acit50332.2020.9300119","is_oa":false,"landing_page_url":"https://doi.org/10.1109/acit50332.2020.9300119","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2020 21st International Arab Conference on Information Technology (ACIT)","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[{"id":"https://metadata.un.org/sdg/9","score":0.6299999952316284,"display_name":"Industry, innovation and infrastructure"}],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":12,"referenced_works":["https://openalex.org/W1585267848","https://openalex.org/W1610496399","https://openalex.org/W1996893448","https://openalex.org/W2118829196","https://openalex.org/W2130966700","https://openalex.org/W2134592632","https://openalex.org/W2335083633","https://openalex.org/W2810047978","https://openalex.org/W4212865778","https://openalex.org/W6632444494","https://openalex.org/W6636177537","https://openalex.org/W6679480879"],"related_works":["https://openalex.org/W2369215403","https://openalex.org/W2587054594","https://openalex.org/W3119296476","https://openalex.org/W2901826185","https://openalex.org/W2742521120","https://openalex.org/W2362581214","https://openalex.org/W2120841359","https://openalex.org/W4248501364","https://openalex.org/W2901498424","https://openalex.org/W2189235061"],"abstract_inverted_index":{"Nowadays,":[0],"the":[1,7,26,58,65,70,75,83,86,91,95,111,123,136,149,155],"development":[2],"of":[3,9,23,29,60,85,126,138,151],"data":[4,10,32,35,47,61,71,87,96,112,127,143,156],"warehouses":[5,36],"shows":[6],"importance":[8],"quality":[11,28,128,144],"in":[12,34,69,94,103,109,135],"business":[13],"success.":[14],"Data":[15,41],"warehouse":[16,72,97],"projects":[17],"fail":[18],"for":[19,57,148],"many":[20],"reasons,":[21],"one":[22],"which":[24,110],"is":[25,37,106,129,145],"low":[27,124],"data.":[30],"High-quality":[31],"achievement":[33],"a":[38,54,146],"persistent":[39],"challenge.":[40],"cleaning":[42,62,88],"aims":[43],"at":[44],"finding,":[45],"correcting":[46],"errors":[48],"and":[49,81],"inconsistencies.":[50],"This":[51],"paper":[52],"presents":[53],"general":[55],"framework":[56,76],"implementation":[59,84,137],"according":[63],"to":[64,90,132],"scientific":[66],"principles":[67],"followed":[68],"field,":[73],"where":[74,142],"offers":[77],"guidelines":[78],"that":[79,122],"define":[80],"facilitate":[82],"process":[89],"enterprises":[92],"interested":[93],"field.":[98],"The":[99,119],"research":[100],"methodology":[101],"used":[102],"this":[104],"study":[105,120],"qualitative":[107],"research,":[108],"are":[113],"collected":[114],"through":[115],"system":[116],"analyst":[117],"interviews.":[118],"concluded":[121],"level":[125],"an":[130],"obstacle":[131],"any":[133],"progress":[134],"modern":[139],"technological":[140],"projects,":[141],"prerequisite":[147],"success":[150],"its":[152],"business,":[153],"including":[154],"warehouse.":[157]},"counts_by_year":[{"year":2025,"cited_by_count":2},{"year":2023,"cited_by_count":3},{"year":2021,"cited_by_count":1}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}