Using Metadata Analysis and Base Analysis Techniques in Data Qualities Framework for Data Warehouses

Azwa Abdul Aziz, Md Yazid Mohd Saman and Mohd Pouzi Hamzah

American Journal of Economics and Business Administration, 2011, vol. 3, issue 1, 112-119

Abstract: Information provided by any applications systems in organization is vital in order to obtain a decision. Due to this factor, the quality of data provided by Data Warehouse (DW) is really important for organization to produce the best solution for their company to move forwards. DW is complex systems that have to deliver highly-aggregated, high quality data from heterogeneous sources to decision makers. It involves a lot of integration of sources system to support business operations. Problem statement: Many of DW projects are failed because of Data Quality (DQ) problems. DQ issues become a major concern over decade. Approach: This study proposes a framework for implementing DQ in DW system architecture using Metadata Analysis Technique and Base Analysis Technique. Those techniques perform comparison between target values and current values gain from the systems. A prototype using PHP is develops to support Base Analysis Techniques. Then a sample schema from Oracle database is used to study differences between applying the framework or not. The prototype is demonstrated to the selected organizations to identify whether it will help to reduce DQ problems. Questionnaires have been given to respondents. Results: The result show user interested in applying DQ processes in their organizations. Conclusion/Recommendation: The implementation of the framework suggested in real situation need to be conducted to obtain more accurate result.

Keywords: Data Warehouse (DW); Data Quality (DQ); metadata Analysis; DQ dimension (search for similar items in EconPapers)
Date: 2011
References: View references in EconPapers View complete reference list from CitEc
Citations:

Downloads: (external link)
https://thescipub.com/pdf/ajebasp.2011.112.119.pdf (application/pdf)
https://thescipub.com/abstract/ajebasp.2011.112.119 (text/html)

Related works:
This item may be available elsewhere in EconPapers: Search for items with the same title.

Export reference: BibTeX RIS (EndNote, ProCite, RefMan) HTML/Text

Persistent link: https://EconPapers.repec.org/RePEc:abk:jajeba:ajebasp.2011.112.119

DOI: 10.3844/ajebasp.2011.112.119

Access Statistics for this article

More articles in American Journal of Economics and Business Administration from Science Publications
Bibliographic data for series maintained by Jeffery Daniels ().