The Proposal of Data Warehouse Validation
The Proposal of Data Warehouse Validation作者机构:Institute of Applied lnJormatics Automation and Mathematics Faculty of Materials Science and Technology Slovak University of Technology Trnava 91724 Slovakia
出 版 物:《Computer Technology and Application》 (计算机技术与应用(英文版))
年 卷 期:2011年第2卷第8期
页 面:650-657页
学科分类:080903[工学-微电子学与固体电子学] 12[管理学] 1201[管理学-管理科学与工程(可授管理学、工学学位)] 0809[工学-电子科学与技术(可授工学、理学学位)] 08[工学]
主 题:Data warehouse test case testing activities methodology validation UML (unified modeling language).
摘 要:The analysis of relevant standards and guidelines proved the lack of information on actions and activities concerning data warehouse testing. The absence of the complex data warehouse testing methodology seems to be crucial particularly in the phase of the data warehouse implementation. The aim of this article is to suggest basic data warehouse testing activities as a final part of data warehouse testing methodology. The testing activities that must be implemented in the process of the data warehouse testing can be split into four logical units regarding the multidimensional database testing, data pump testing, metadata and OLAP (Online Analytical Processing) testing. Between main testing activities can be included: revision of the multidimensional database scheme, optimizing of fact tables number, problem of data explosion, testing for correctness of aggregation and summation of data etc.