Patent ID: 11966371
Assignee: WELLS FARGO BANK, N.A.
Field: Computer technology (Electrical engineering)
Classification: CPC G | IPC G

Claim 2:
3. A computer program product for automated data dictionary validation, the computer program product comprising at least one non-transitory computer-readable storage medium storing software instructions that, when executed, cause an apparatus to:
automatically generate a data dictionary based on one or more reference term tokens of a database query, wherein automatically generating the data dictionary comprises:—
parsing, by the data dictionary generation circuitry, the database query, and
identifying, by the data dictionary generation circuitry and based on the parsing of the database query, the one or more reference term tokens; and

validate the data dictionary, wherein validating the data dictionary includes:
generating, based on the database query and the data dictionary, a skeleton query, wherein generating the skeleton query comprises:
identifying a set of native term tokens in the database query, wherein the one or more native term tokens are native to a programming language used to generate the database query,
removing the set of native term tokens from the database query, and
removing a respective reference term token from the database query based on an identification of the respective reference term token in the data dictionary;

determining whether the skeleton query is empty, and
determining, based on the skeleton query, a validation status of the data dictionary, wherein the validation status indicates a successful validation of the data dictionary in an instance in which the skeleton query is determined to be empty and an unsuccessful validation of the data dictionary in an instance in which the skeleton query comprises at least one of the one or more reference term tokens; and

cause presentation of the validation status.