US 12,393,556 B2
Method and system for providing database management as a service
Gaurav Sanghi, Frisco, TX (US)
Assigned to JPMORGAN CHASE BANK, N.A., New York, NY (US)
Filed by JPMorgan Chase Bank, N.A., New York, NY (US)
Filed on May 3, 2023, as Appl. No. 18/142,741.
Prior Publication US 2024/0370411 A1, Nov. 7, 2024
Int. Cl. G06F 16/21 (2019.01); G06F 16/23 (2019.01)
CPC G06F 16/21 (2019.01) [G06F 16/2358 (2019.01)] 20 Claims
OG exemplary drawing
 
1. A method for providing database management as a service, the method being implemented by at least one processor, the method comprising:
implementing, by the at least one processor, a metadata driven framework engine to perform operations comprising:
onboarding at least one application to access a corresponding configuration file and a metadata table;
parsing the configuration file and the metadata table to identify at least one constraint that governs a database activity for the at least one application and a database that corresponds to the at least one application;
identifying at least one database procedure based on the at least one constraint;
configuring at least one parameter of the database based on the at least one constraint, the at least one parameter defining at least one property of the database activity;
automatically initiating, using the identified at least one database procedure, a direct control of the database activity for the at least one application based on the configured at least one parameter;
monitoring at least one health characteristic of the database when the database activity is automatically initiated;
automatically determining a condition of the database based on a result of the monitoring, the condition including an error condition comprising an identification of an obsolete data object in the database;
minimizing a production failure and a risk associated with a missing service level agreement by performing at least one different action at an optimal time window to perform at least one maintenance activity on the metadata driven framework engine,
wherein the performing at least one different action is associated with the database activity that corresponds to the at least one maintenance activity and includes the performing at least one different action on same database objects based on a usage of a database object at different time periods;
generating a report comprising at least one from among an audit and a log table recording a status of the performing at least one different action in maintaining the metadata driven framework engine; and
updating the metadata driven framework engine upon receiving an updated configuration file by repeating the operations for the performing at least one different action in maintaining the metadata driven framework engine.