17874806. AUTOMATED VALIDATION OF DATABASE DEPLOYMENTS simplified abstract (Dell Products L.P.)

From WikiPatents
Jump to navigation Jump to search

AUTOMATED VALIDATION OF DATABASE DEPLOYMENTS

Organization Name

Dell Products L.P.

Inventor(s)

Jahangeer Pasha Mohammed of Milton (CA)

Mohammadi Begum of Hyderabad (IN)

AUTOMATED VALIDATION OF DATABASE DEPLOYMENTS - A simplified explanation of the abstract

This abstract first appeared for US patent application 17874806 titled 'AUTOMATED VALIDATION OF DATABASE DEPLOYMENTS

Simplified Explanation

The patent application describes methods, apparatus, and processor-readable storage media for automated validation of database deployments. It involves obtaining database scripts associated with one or more database objects, parsing the scripts to identify object information, generating a validation script with validation queries based on the identified object information, and executing the validation script to validate changes in the database resulting from the execution of the database scripts.

  • The invention automates the validation process for database deployments.
  • It parses database scripts to extract object information associated with the scripts.
  • It generates a validation script with validation queries based on the extracted object information.
  • The validation script is executed to validate changes made to the database during the execution of the database scripts.

Potential applications of this technology:

  • Database management and deployment automation tools.
  • Software development and testing environments.
  • Continuous integration and deployment systems.

Problems solved by this technology:

  • Manual validation of database deployments can be time-consuming and error-prone.
  • Ensuring the consistency and correctness of database changes can be challenging.
  • Tracking and validating changes made to databases during deployment can be complex.

Benefits of this technology:

  • Automation of the validation process reduces human effort and potential errors.
  • Object information extraction and validation script generation streamline the validation process.
  • Ensures the accuracy and consistency of database changes during deployment.


Original Abstract Submitted

Methods, apparatus, and processor-readable storage media for automated validation of database deployments are provided herein. An example computer-implemented method includes obtaining database scripts to be executed on at least one database, wherein each database script is associated with one or more database objects; parsing respective ones of the database scripts to identify object information corresponding to the one or more database objects associated with the corresponding database script; automatically generating a validation script comprising one or more validation queries for respective ones of the one or more database objects associated with a corresponding one of the database scripts, wherein each validation query is based at least in part on the identified object information of the corresponding database object; and initiating an execution of the validation script to validate one or more changes of the at least one database resulting from an execution of the database scripts.