| CPC G06F 16/213 (2019.01) [G06F 11/3428 (2013.01); G06F 16/2358 (2019.01); G06F 16/24542 (2019.01); G06N 5/025 (2013.01); G06N 20/00 (2019.01)] | 22 Claims |
|
1. A database change management system comprising:
a processor;
a non-transitory, computer-readable medium storing computer-executable code, said computer-executable code comprising instructions for:
accessing a set of changes to a database schema, a set of pre-change performance data and a set of post-change performance data, the set of changes indicative of one or more of a plurality of respective database schema change types, the plurality of respective database schema change types comprising adding a column, dropping a column, adding a table, and changing a data type;
correlating the set of pre-change performance data and the set of post-change performance data to the set of changes to the database schema to generate a set of correlated performance data for the set of changes to the database schema;
generating database change numeric representations from the set of changes to the database schema and the set of correlated performance data, each database change numeric representation generated as a correlated change record comprising a representation of a database schema change type indicating a type of database schema change and a piece of correlated performance data;
processing the database change numeric representations using a machine learning model to identify a change pattern having a strong correlation to a database change impact corresponding to the piece of correlated performance data, the change pattern including a first database schema change type indicating the type of database schema change from the plurality of respective database schema change types;
based on the change pattern, automatically generating a rule that applies to the first database schema change type; and
updating a database change deployment system with the rule.
|