Snowflake inc. (20240232019). REGRESSION MITIGATION USING MULTIPLE STORED PROCEDURES simplified abstract

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 20240232019 titled 'REGRESSION MITIGATION USING MULTIPLE STORED PROCEDURES

Simplified Explanation: The patent application describes a method for updating a table with detected regressions in database code, determining the root cause and impact of the regression, and deciding whether to perform mitigation based on the impact.

Key Features and Innovation:

  • Updating a table with detected regressions in database code.
  • Performing stored procedures to determine root cause and impact of regressions.
  • Making a decision on whether to perform mitigation based on the impact.

Potential Applications: This technology can be applied in software development, database management, and quality assurance processes.

Problems Solved:

  • Efficiently identifying and addressing regressions in database code.
  • Streamlining the process of determining root causes and impacts of regressions.
  • Making informed decisions on whether to perform mitigation based on the impact of regressions.

Benefits:

  • Improved database code quality.
  • Faster resolution of regressions.
  • Enhanced decision-making in addressing database code issues.

Commercial Applications: The technology can be used in software development companies, database management firms, and quality assurance departments to enhance the efficiency and effectiveness of regression detection and resolution processes.

Questions about the Technology: 1. How does the method determine the root cause of detected regressions? 2. What factors are considered when deciding whether to perform mitigation of the detected regression?

Frequently Updated Research: Stay updated on the latest advancements in database regression detection and resolution techniques to ensure the continued relevance and effectiveness of this technology.


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.