Systems and Methods for Use in Validating Data in Connection With Data Queries
AssigneeMastercard International Incorporated
InventorsChinmay Sharad Sagade, Sanchit Kaushik, Srinivas Kosaraju
Life of this patent
Estimating the term…
Abstract
Systems and methods are provided for loading data in connection with testing an application, based on a hierarchical framework. An exemplary method includes receiving a data query from a requestor, identifying a dependency of the data query on a data structure, and determining whether said data structure is annotated with a poor quality indicator. The exemplary method further includes providing a warning to the requestor when the data structure is annotated with the poor quality indicator, thereby informing the requestor of a potential quality issuer with a report relying on the data structure query.
Claims16
A computer-implemented method for use in providing a warning for poor quality data in connection with a data query for such data from a requestor, the method comprising:
- receiving, by a computing device, a data query from a requestor;
- identifying, by the computing device, a dependency of the data query on a data structure included in a data warehouse;
- determining, by the computing device, whether said data structure is annotated with a poor quality indicator;
- and
- providing, by the computing device, a warning to the requestor when the data structure is annotated with the poor quality indicator, thereby informing the requestor of a potential quality issue with a report relying on the data query.
A non-transitory computer-readable storage media including executable instructions for providing warnings for data queries dependent on poor quality data, which, when executed by at least one processor, cause the at least one processor to:
- identify a dependency of a data query on a data structure;
- determine whether the data structure, upon which the data query is dependent, is annotated with a poor quality indicator;
- and
- notify a requestor of the data query when the data structure is annotated with the poor quality indicator, prior to submitting the data query to a warehouse associated with the data structure.
A system for use in providing a warning for poor quality data in connection with a data query for such data from a requestor, the system comprising:
- a data warehouse including multiple data structures, each of the multiple data structures including transaction data associated with at least one financial institution;
- and
- a query analyzer coupled to the data warehouse and configured to:
- receive a data query from a requestor directed to the data warehouse;
- identify each dependency of the data query on at least one of the multiple data structures included in the data warehouse;
- and
- provide a warning to the requestor when one or more of the at least one of the multiple data structures is annotated with a poor quality indicator, thereby informing the requestor of a potential quality issue with relying on the data query.
Dependencies are inferred from the claim text.