US 11,734,116 B1
Infrastructure for automating rollout of database changes
Vlad Bunescu, Morgan Hill, CA (US); Yan Huang, Bellevue, WA (US); Jaeha Lee, Redmond, WA (US); Shiyu Qu, Bellevue, WA (US); and Jiaqi Yan, Menlo Park, CA (US)
Assigned to Snowflake Inc., Bozeman, MT (US)
Filed by Snowflake Inc., Bozeman, MT (US)
Filed on Dec. 1, 2022, as Appl. No. 18/60,848.
Int. Cl. G06F 11/14 (2006.01); G06F 16/21 (2019.01); G06F 11/34 (2006.01)
CPC G06F 11/1433 (2013.01) [G06F 11/3414 (2013.01); G06F 16/213 (2019.01); G06F 2201/80 (2013.01)] 30 Claims
OG exemplary drawing
 
1. A system comprising:
at least one hardware processor; and
at least one memory storing instructions that cause the at least one hardware processor to perform operations comprising:
detecting a change in database code of a database resulting in changed database code, the change in the database code including a parameter rollout for at least one parameter setting of the database;
monitoring execution of a query associated with the change in the database code, the query using the at least one parameter setting;
detecting a regression in the changed database code based on the monitoring;
performing impact analysis to determine a scope of impact of the regression on at least another query using the at least one parameter setting; and
determining whether to perform a rollback of the change in the database code or perform mitigation based on the scope of impact.