Measuring Data Quality in Analytical Projects
Measuring and assuring data quality in analytical projects are considered very important issues and overseeing their benefits may cause serious consequences for the efficiency of organizations. Data profiling and data cleaning are two essential activities in a data quality process, along with data i...
Main Authors: | , , , |
---|---|
Format: | Article |
Language: | English |
Published: |
Bucharest University of Economic Studies
2014-05-01
|
Series: | Database Systems Journal |
Subjects: | |
Online Access: | http://dbjournal.ro/archive/15/15_2.pdf |
_version_ | 1827882167317823488 |
---|---|
author | Anca Ioana ANDREESCU Anda BELCIU Alexandra FLOREA Vlad DIACONITA |
author_facet | Anca Ioana ANDREESCU Anda BELCIU Alexandra FLOREA Vlad DIACONITA |
author_sort | Anca Ioana ANDREESCU |
collection | DOAJ |
description | Measuring and assuring data quality in analytical projects are considered very important issues and overseeing their benefits may cause serious consequences for the efficiency of organizations. Data profiling and data cleaning are two essential activities in a data quality process, along with data integration, enrichment and monitoring. Data warehouses require and provide extensive support for data cleaning. These loads and renew continuously huge amounts of data from a variety of sources, so the probability that some of the sources contain "dirty data" is great. Also, analytics tools offer, to some extent, facilities for assessing and assuring data quality as a built in support or by using their proprietary programming languages. This paper emphasizes the scope and relevance of a data quality measurement in analytical projects by the means of two intensively used tools such as Oracle Warehouse Builder and SAS 9.3. |
first_indexed | 2024-03-12T18:52:35Z |
format | Article |
id | doaj.art-6d99a117f9ab489f8f7851e21647b6e6 |
institution | Directory Open Access Journal |
issn | 2069-3230 2069-3230 |
language | English |
last_indexed | 2024-03-12T18:52:35Z |
publishDate | 2014-05-01 |
publisher | Bucharest University of Economic Studies |
record_format | Article |
series | Database Systems Journal |
spelling | doaj.art-6d99a117f9ab489f8f7851e21647b6e62023-08-02T07:07:32ZengBucharest University of Economic StudiesDatabase Systems Journal2069-32302069-32302014-05-01V11525Measuring Data Quality in Analytical ProjectsAnca Ioana ANDREESCU0Anda BELCIU1Alexandra FLOREA2Vlad DIACONITA3Bucharest Academy of Economic StudiesBucharest Academy of Economic StudiesBucharest Academy of Economic StudiesBucharest Academy of Economic StudiesMeasuring and assuring data quality in analytical projects are considered very important issues and overseeing their benefits may cause serious consequences for the efficiency of organizations. Data profiling and data cleaning are two essential activities in a data quality process, along with data integration, enrichment and monitoring. Data warehouses require and provide extensive support for data cleaning. These loads and renew continuously huge amounts of data from a variety of sources, so the probability that some of the sources contain "dirty data" is great. Also, analytics tools offer, to some extent, facilities for assessing and assuring data quality as a built in support or by using their proprietary programming languages. This paper emphasizes the scope and relevance of a data quality measurement in analytical projects by the means of two intensively used tools such as Oracle Warehouse Builder and SAS 9.3.http://dbjournal.ro/archive/15/15_2.pdfData QualityData ProfilingAnalytical Tools |
spellingShingle | Anca Ioana ANDREESCU Anda BELCIU Alexandra FLOREA Vlad DIACONITA Measuring Data Quality in Analytical Projects Database Systems Journal Data Quality Data Profiling Analytical Tools |
title | Measuring Data Quality in Analytical Projects |
title_full | Measuring Data Quality in Analytical Projects |
title_fullStr | Measuring Data Quality in Analytical Projects |
title_full_unstemmed | Measuring Data Quality in Analytical Projects |
title_short | Measuring Data Quality in Analytical Projects |
title_sort | measuring data quality in analytical projects |
topic | Data Quality Data Profiling Analytical Tools |
url | http://dbjournal.ro/archive/15/15_2.pdf |
work_keys_str_mv | AT ancaioanaandreescu measuringdataqualityinanalyticalprojects AT andabelciu measuringdataqualityinanalyticalprojects AT alexandraflorea measuringdataqualityinanalyticalprojects AT vladdiaconita measuringdataqualityinanalyticalprojects |