Generation of Data Warehouse Design Test Cases

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.