Database provisioning and management systems and methods

A non-transitory, computer-readable storage medium comprising instructions recorded thereon, wherein the instructions when executed by at least one data processor of a system, cause the system to:

• access a request to provision one or more databases for a software application;
• select a database to be provisioned from a set of generated database recommendations based on at least one parameter,
• wherein the at least one parameter relates to a type of data to be hosted by the database, software code for the software application, or an amount of data to be hosted by the database;
• generate the selected database using software code retrieved from a repository;
• manage the generated database based on a stored representation of the generated database in an inventory of databases;
• compile a report, using a monitoring agent, to notify a user about at least two of:
• system utilization, capacity trending, errors, or availability of the generated database;
• receive monitoring data for the generated database;
• and
• use a machine learning model to predict, based on the monitoring data, a need to adjust at least one resource for the generated database, the at least one resource including a storage capacity, a processing capacity, or both,
• wherein the machine learning model is trained on historical monitoring data including historical performance data and usage data for multiple generated databases,
• wherein the historical performance data includes buffer cache statistics or wait event statistics, and
• wherein the usage data includes one or more of:
• a threshold amount of reads from new or unknown users, a threshold amount of reads during a predetermined time period, or database access from an out-of-range IP address.

A method comprising:

• accessing a request to provision one or more databases for a software application;
• selecting a database to be provisioned from a set of generated database recommendations based on at least one parameter,
• wherein the at least one parameter relates to a type of data to be hosted by the database, software code for the software application, or an amount of data to be hosted by the database;
• generating the selected database using software code retrieved from a repository,
• managing the generated database based on a stored representation of the generated database in an inventory of databases;
• compiling a report, using a monitoring agent, to notify a user about at least two of:
• system utilization, capacity trending, errors, or availability of the generated database;
• receiving monitoring data for the generated database;
• and
• using a machine learning model to predict, based on the monitoring data, a need to adjust at least one resource for the generated database, the at least one resource including a storage capacity, a processing capacity, or both,
• wherein the machine learning model is trained on historical monitoring data including historical performance data and usage data for multiple generated databases,
• wherein the historical performance data includes buffer cache statistics or wait event statistics, and
• wherein the usage data includes one or more of:
• a threshold amount of reads from new or unknown users, a threshold amount of reads during a predetermined time period, or database access from an out-of-range IP address.