Patent ID: 9092493
Filing Date: 2015-07-28
Classification: G06F

Abstract:
1. A computer system for validating data in a data warehouse comprising: one or more processors; one or more computer-readable memories; one or more computer-readable tangible storage devices; program instructions stored on at least one of the one or more computer-readable tangible storage devices for execution by at least one of the one or more processors via at least one of the one or more computer-readable memories to: dynamically generate one or more database queries to be performed on a target data warehouse and a baseline data warehouse based on warehouse model metadata for the target data warehouse and the baseline data warehouse, including: execute the one or more database queries against the target data warehouse and the baseline data warehouse to receive one or more data sets from the baseline data warehouse and one or more data sets from the target data warehouse; and compare the one or more data sets from the baseline data warehouse and the one or more data sets from the target data warehouse to validate target data in the target data warehouse against baseline data in the baseline data warehouse.