Steven M Long

US Patent:

8019795, Sep 13, 2011

Filed:

Dec 5, 2007

Appl. No.:

11/951323

Inventors:

Andrew Anderson - Bellevue WA, US
Kanmin Zhang - Bellevue WA, US
Steven Long - Bellevue WA, US
Joseph Heiniger - Redmond WA, US
Ashutosh Badwe - Redmond WA, US

Assignee:

Microsoft Corporation - Redmond WA

International Classification:

G06F 17/30

US Classification:

707803, 707600, 707687, 707690, 707697, 707703, 358 113

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.