Loading [MathJax]/extensions/TeX/ieeemacros.js
Generation of Data Warehouse Design Test Cases | IEEE Conference Publication | IEEE Xplore

Generation of Data Warehouse Design Test Cases


Abstract:

There are several data warehouse lifecycle for Relational database. However, most design modeling agrees on Conceptual schema, Logical schema, and Physical schema. This p...Show More

Abstract:

There are several data warehouse lifecycle for Relational database. However, most design modeling agrees on Conceptual schema, Logical schema, and Physical schema. This paper presents an approach to generating test cases for data warehouse design tests, including the level of conceptual, logical, and physical. The test cases contain SQL statements for verifying some certain predefined aspects. The minimum edit distance component is also available for correcting the garbled terms found in the SQL. The implemented system would enhance the quality of target data as well as lessen the rework. In particular, the presented approach would reduce the number of defects injected in detailed designed prior to entering the ETL phase. This leads to less rework for preprocessing target data at the ETL phase.
Date of Conference: 24-27 August 2015
Date Added to IEEE Xplore: 08 October 2015
ISBN Information:
Conference Location: Kuala Lumpur, Malaysia

References

References is not available for this document.