Relational database management system including monster transaction detection and handling

A non-transitory computer readable medium storing instructions for causing a computer system to perform operations of:

• identifying a currently occurring monster transaction in a database using a database management system (DBMS) for the database;
• estimating a time required to end and rollback the currently occurring monster transaction using a learned rollback time estimation process, the learned rollback time estimation process including applying a rollback time estimation regression model learned on historical monster transactions;
• estimating a time required to complete the currently occurring monster transaction using a learned time to completion estimation process, the learned time to completion estimation process including applying a completion time estimation regression model learned on historical monster transactions;
• and
• generating a prompt identifying the monster transaction, the estimated time required to end and rollback the currently occurring monster transaction and the estimated time required to complete the currently occurring monster transaction.

A computer system comprising:

• at least one client computer having a processor set and a non-transitory memory, the non-transitory memory storing a monster transaction identification and handling module configure to cause the processor set to perform operations of:
• identifying a currently occurring monster transaction in a database using a database management system (DBMS) for the database;
• estimating a time required to end and rollback the currently occurring monster transaction using a learned rollback time estimation process, the learned rollback time estimation process including applying a rollback time estimation regression model learned on historical monster transactions;
• estimating a time required to complete the currently occurring monster transaction using a learned time to completion estimation process, the learned time to completion estimation process including applying a completion time estimation regression model learned on historical monster transactions;
• and
• generating a prompt identifying the monster transaction, the estimated time required to end and rollback the currently occurring monster transaction and the estimated time required to complete the currently occurring monster transaction.