Method and system for validating data
First Claim
Patent Images
1. A method for validating data, said method comprising:
- a processor of a data processing system generating warehouse data in a data warehouse by transforming source data in a data source into the warehouse data via an Extract-Transform-Load (ETL) transformation model;
said processor generating a data cube by transforming the warehouse data in the data warehouse into the data cube via an On-Line Analysis Processing (OLAP) transformation model;
said processor generating a report multi-dimensional data set (MDS1) from the data cube via a data cube query of the data cube;
said processor generating a reference multi-dimensional data set (S) from the source data via a source data query of the source data, said source data query corresponding to the data cube query; and
said processor performing a data validation based on a matching relationship between MDS1 and S.
1 Assignment
0 Petitions
Accused Products
Abstract
A method and system for validating data. Warehouse data is generated by transforming source data via an ETL transformation model. A data cube is generated by transforming the warehouse data via an OLAP transformation model. A report dataset (MDS1) is generated from the data cube. A reference dataset (S) is generated from the source data. A data validation is performed, the data validation being based on a matching relationship between MDS1 and S.
-
Citations
22 Claims
-
1. A method for validating data, said method comprising:
-
a processor of a data processing system generating warehouse data in a data warehouse by transforming source data in a data source into the warehouse data via an Extract-Transform-Load (ETL) transformation model; said processor generating a data cube by transforming the warehouse data in the data warehouse into the data cube via an On-Line Analysis Processing (OLAP) transformation model; said processor generating a report multi-dimensional data set (MDS1) from the data cube via a data cube query of the data cube; said processor generating a reference multi-dimensional data set (S) from the source data via a source data query of the source data, said source data query corresponding to the data cube query; and said processor performing a data validation based on a matching relationship between MDS1 and S. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11)
-
-
12. A data processing system comprising a processor and a computer readable memory unit coupled to the processor, said memory unit containing program code configured to be executed by the processor to implement a method for validating data, said method comprising:
-
said processor generating warehouse data in a data warehouse by transforming source data in a data source into the warehouse data via an Extract-Transform-Load (ETL) transformation model; said processor generating a data cube by transforming the warehouse data in the data warehouse into the data cube via an On-Line Analysis Processing (OLAP) transformation model; said processor generating a report multi-dimensional data set (MDS1) from the data cube via a data cube query of the data cube; said processor generating a reference multi-dimensional data set (S) from the source data via a source data query of the source data, said source data query corresponding to the data cube query; and said processor performing a data validation based on a matching relationship between MDS1 and S. - View Dependent Claims (13)
-
-
14. A computer program product, comprising a computer readable hardware storage device having a computer readable program code stored therein, said hardware storage device not being a signal, said computer readable program code configured to be executed by a processor of a data processing system to implement a method for validating data, said method comprising:
-
said processor generating warehouse data in a data warehouse by transforming source data in a data source into the warehouse data via an Extract-Transform-Load (ETL) transformation model; said processor generating a data cube by transforming the warehouse data in the data warehouse into the data cube via an On-Line Analysis Processing (OLAP) transformation model; said processor generating a report multi-dimensional data set (MDS1) from the data cube via a data cube query of the data cube; and said processor generating a reference multi-dimensional data set (S) from the source data via a source data query of the source data, said source data query corresponding to the data cube query; and said processor performing a data validation based on a matching relationship between MDS1 and S. - View Dependent Claims (15)
-
-
16. A method for validating data, said method comprising:
-
a processor of a data processing system generating warehouse data in a data warehouse by transforming source data in a data source into the warehouse data via an Extract-Transform-Load (ETL) transformation model; said processor generating a report multi-dimensional data set (MDS1) from the data warehouse via a data warehouse query of the data warehouse; said processor generating a reference multi-dimensional data set (S) from the source data via a source data query of the source data, said source data query corresponding to the data cube query; and said processor determining whether MDS1 matches S; wherein if said determining whether MDS1 matches S comprises determining that MDS1 does not match S, then the method further comprises said processor performing an ETL inverse transformation on MDS1 to generate an ETL multi-dimensional data set (MDS3) and said processor determining whether MDS3 matches S; wherein if said determining whether MDS1 matches S comprises determining that MDS1 does not match S and said determining whether MDS3 matches S comprises determining that MDS3 does not match S, then said processor determining whether MDS3 matches MDS1. - View Dependent Claims (17, 18, 19, 20, 21, 22)
-
Specification