18618273. REGRESSION MITIGATION USING MULTIPLE STORED PROCEDURES simplified abstract (Snowflake Inc.)

From WikiPatents
Jump to navigation Jump to search

REGRESSION MITIGATION USING MULTIPLE STORED PROCEDURES

Organization Name

Snowflake Inc.

Inventor(s)

Vlad Bunescu of Morgan Hill CA (US)

Yan Huang of Bellevue WA (US)

Jaeha Lee of Redmond WA (US)

Shiyu Qu of Bellevue WA (US)

Jiaqi Yan of Menlo CA (US)

REGRESSION MITIGATION USING MULTIPLE STORED PROCEDURES - A simplified explanation of the abstract

This abstract first appeared for US patent application 18618273 titled 'REGRESSION MITIGATION USING MULTIPLE STORED PROCEDURES

The method described in the abstract involves updating a table with a detected regression associated with database code, determining the root cause and impact of the regression, and deciding whether to perform mitigation based on the impact.

  • The method involves updating a table with a detected regression associated with database code.
  • A first stored procedure is performed to determine the root cause of the detected regression.
  • A second stored procedure is performed to determine the impact of the regression based on the root cause.
  • A decision is made on whether to perform mitigation of the detected regression based on the impact.

Potential Applications: - Database management systems - Software development - Quality assurance processes

Problems Solved: - Efficiently identifying and addressing regressions in database code - Streamlining the root cause analysis process - Improving decision-making regarding regression mitigation

Benefits: - Enhanced database performance - Increased efficiency in software development - Improved overall quality of database code

Commercial Applications: Title: "Database Regression Detection and Mitigation Method" This technology can be utilized by software development companies, database management firms, and quality assurance teams to streamline regression detection and mitigation processes, ultimately leading to improved database performance and software quality.

Questions about Database Regression Detection and Mitigation Method: 1. How does this method improve the efficiency of regression detection and mitigation processes? 2. What are the potential implications of using this technology in software development projects?

Frequently Updated Research: Stay updated on the latest advancements in database regression detection and mitigation methods to ensure optimal performance and efficiency in software development processes.


Original Abstract Submitted

A method includes updating, by at least one hardware processor, a table with a detected regression associated with database code of a database. A first stored procedure is performed to determine a root cause of the detected regression. A second stored procedure is performed to determine an impact of the detected regression based at least on the root cause. A determination is made on whether to perform mitigation of the detected regression based on the impact.