Patent ID: 11880346
Assignee: BANK OF AMERICA CORPORATION
Field: Computer technology (Electrical engineering)
Classification: CPC G | IPC G

Claim 0:
1. A system for smart generation of data warehouse quality protocols, the system comprising:
a data source comprising a set of source attributes having a first data structure;
a data warehouse comprising target data obtained from one or more data sources, the target data comprising a set of target attributes, the target attributes having a second data structure and comprising a transformation of the source attributes;
a processor comprising an artificial intelligence (“AI”) model and configured to:
generate a source vector from each source attribute in the set of source attributes;
generate a target vector from each target attribute in the set of target attributes; and
determine a probability of correspondence between the source vector and each of the target vectors for input to the AI model;
using the AI model:
determine whether one of the target attributes is a transformation of a source attribute based at least in part on a probability of correspondence between the source vector generated from the source attribute and one of the target vector generated from the target attribute;
output a data quality metric for the source attribute based at least in part on a first parameter of the transformation;
output a data quality metric for the target attribute based at least in part on a second parameter of the transformation; and

validate the source attribute and the target attribute using the data quality metrics, wherein the data quality metrics comprise a ratio of data to errors and a number of empty values.