文章基本信息

标题：Using Metadata Analysis and Base Analysis Techniques in Data Qualities Framework for Data Warehouses
本地全文：下载
作者：Aziz, Azwa Abdul ; Saman, Md Yazid Mohd ; Hamzah, Mohd Pouzi 等
期刊名称：American Journal of Economics and Business Administration
印刷版ISSN：1945-5488
电子版ISSN：1945-5496
出版年度：2011
卷号：3
期号：1
页码：112-119
DOI：10.3844/ajebasp.2011.112.119
出版社：Science Publications
摘要：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.
关键词：Data Warehouse (DW); Data Quality (DQ); metadata Analysis; DQ dimension