SYSTEM AND METHOD FOR AUTOMATICALLY AND EFFICIENTLY VALIDATING DATABASE OBJECTS

摘要

A system and computer-implemented method for validating one or more database objects is provided. The system comprises an application, residing on one or more client devices, configured to establish a connection with a validation module and scan one or more databases connected to the validation module. Further, the validation module comprises a schema look-up module configured to identify one or more database objects from the one or more scanned databases. The validation module further comprises a parameterization module to facilitate selection of a validation mode and provide one or more input parameters based on the selected validation mode. Furthermore, the validation module comprises an execution engine configured to execute the one or more identified database objects using the one or more provided input parameters and generate validation results. In addition, the validation module comprises a reporting module configured to generate one or more validation reports using the generated validation results.

主权项

1. A system for validating one or more database objects, the system comprising:
an application, residing on one or more client devices, configured to establish a connection with a validation module and further configured to scan one or more databases connected to the validation module; and the validation module comprising: a schema look-up module configured to identify one or more database objects from the one or more scanned databases; a parameterization module configured to facilitate selection of a validation mode and further configured to provide one or more input parameters based on the selected validation mode; an execution engine configured to execute the one or more identified database objects using the one or more provided input parameters and generate validation results, wherein the generated validation results comprise execution status of each of the one or more executed database objects; and a reporting module configured to generate one or more validation reports using the generated validation results.