US 8,019,795 B2 · Data warehouse test automation framework

Abstract

Various technologies and techniques are disclosed for providing a data warehouse test automation framework system. A data generation module is provided that is operable to generate data scenarios that ensure specific logic is being validated against a data warehouse. A data validation module is provided that has data validation blocks that provide a framework for validating data completeness and data integrity of a data warehouse. The data validation blocks are represented by query templates that provide specifications for how queries that perform the validating of the data completeness and the data integrity should be structured. Dimensions in the data warehouse are modeled using an object oriented programming syntax.

Claims17

Dependent claims

A data warehouse test automation framework system comprising:

a processing unit coupled to a memory, the processing unit configured to execute the following computer-executable modules stored in the memory:
a data generation module that is operable to generate source data comprising data scenarios that ensure specific logic is being validated against a data warehouse, at least one data scenario comprising valid and invalid data inserted into source data, the data generation module further operable to pre-process the data inserted into the source data by marking data as either valid or invalid;
and
a data validation module with one or more query templates that are operable to provide specifications for checking destination data in the data warehouse to ensure that the destination data is being properly populated from the generated source data by comparing an expected behavior based on the marked data against an actual warehouse behavior.

1 more element

Dependencies are inferred from the claim text.

Data warehouse test automation framework

Life of this patent

Data warehouse test automation framework

Life of this patent

Abstract

Claims17