Automated metadata validation
AssigneeTeradata US, Inc.
InventorsMark William Coley, Michael Chaves, Mark Christopher Bush, Susan Jamie Borofsky, Michael J. Brown
Life of this patent
Estimating the term…
Abstract
An application includes a variety of metadata and operations that may process the metadata. Selective portions of the metadata are identified and various combinations of available operations are automatically generated for the selective metadata. Each generated operation is then individually validated for syntax and semantics, without actually executing the operation.
Claims11
A machine-implemented method to validate metadata embodied as instruction, the instructions when executed by a machine perform the method of
- receiving, on the machine, a request to validate metadata within an application while the application is processing on the machine and wherein the request is received within a version of the application that is executing on the machine, wherein the request is an option of the application itself;
- acquiring, on the machine, the metadata associated with the request;
- generating, on the machine, search operations for the application for which the metadata can be associated with;
- and
- validating, on the machine, the operations having the metadata before the operations are processed, and wherein the operations are data store search queries in a data store query language, and wherein the metadata is selectively identified based on configuration parameters supplied as a profile and combinations include permutations of the operations that can be generated in response to values assigned to the metadata to define a finite set of specific operation instances, and wherein the metadata identifies a name for a database table and a field of that database table for which the search queries are to be conducted using the values assigned to the database table and the field.
A machine-implemented method to validate metadata embodied as instructions, the instructions when executed by a machine perform the method of:
- identifying, on the machine, search operations for an application which can process metadata as SQL search queries against a database, wherein the operations are categorized in response to metadata types for the metadata that the operations can process;
- acquiring, on the machine, the metadata, wherein the metadata is selectively identified based on configuration parameters supplied as a profile, and wherein the metadata identifies names for database tables and fields for those database tables;
- generating, on the machine, combinations of the operations having portions of the metadata, wherein the combinations include permutations of the operations that can be generated in response to values assigned to the metadata to define a finite set of specific operation instances;
- and
- validating, on the machine, the combinations for syntax and semantics, without executing the operations to produce a compilation of validation errors for the combinations by processing a database explain plan operation for each of the combinations of the operations against the database.
Dependencies are inferred from the claim text.