Data Cleaning Service for Data Warehouse: An Experimental Comparative Study on Local Data
UAD Journal Management System
View Archive InfoField | Value | |
Authentication Code |
dc |
|
Title Statement |
Data Cleaning Service for Data Warehouse: An Experimental Comparative Study on Local Data |
|
Added Entry - Uncontrolled Name |
Bramantoro, Arif; King Abdulaziz University Deanship of Scientific Research (DSR), King Abdulaziz University, Jeddah, Saudi Arabia. |
|
Uncontrolled Index Term |
data cleaning service; data warehouse; data quality; local data; |
|
Summary, etc. |
Data warehouse is a collective entity of data from various data sources. Data are prone to several complications and irregularities in data warehouse. Data cleaning service is non trivial activity to ensure data quality. Data cleaning service involves identification of errors, removing them and improve the quality of data. One of the common methods is duplicate elimination. This research focuses on the service of duplicate elimination on local data. It initially surveys data quality focusing on quality problems, cleaning methodology, involved stages and services within data warehouse environment. It also provides a comparison through some experiments on local data with different cases, such as different spelling on different pronunciation, misspellings, name abbreviation, honorific prefixes, common nicknames, splitted name and exact match. All services are evaluated based on the proposed quality of service metrics such as performance, capability to process the number of records, platform support, data heterogeneity, and price; so that in the future these services are reliable to handle big data in data warehouse. |
|
Publication, Distribution, Etc. |
Universitas Ahmad Dahlan 2018-04-01 00:00:00 |
|
Electronic Location and Access |
application/pdf http://journal.uad.ac.id/index.php/TELKOMNIKA/article/view/7669 |
|
Data Source Entry |
TELKOMNIKA (Telecommunication Computing Electronics and Control); Vol 16, No 2: April 2018 |
|
Language Note |
en |
|
Terms Governing Use and Reproduction Note |
Copyright (c) 2020 Universitas Ahmad Dahlan |
|