Bank of America Corporation

Rakesh Shah

Anant Bondalapati Sharma

Badelal Rameshwar Prasad Yadav

Thangaraju Nachimuthu

Sivasankar Sivasalam

Rama Krishna Venkata Gandi

A separate, central server operating in a system including one or more database server machines and a graphical user interface displayed on a user's computer is disclosed and provides a technological improvement. In one example, computer-readable instructions are stored in computer memory on this shutdown control server. A user, such as a database administrator, may access the shutdown control server to initiate the shutdown, reboot, and/or restart of database services on one or more separate database servers. At least one advantage of such an arrangement is that the shutdown control server provides plug-and-play capabilities that may allow one or more database servers of one or more different database types to concurrently connect to the shutdown control server.

Database shutdown and restart stability optimizer

An apparatus includes a memory and a processor. The processor collects from a database server, statistics indicating a performance of the server. The processor applies to the statistics, a machine learning algorithm configured to identify, based in part on the statistics, one or more issues affecting the performance of the database server. Applying the machine learning algorithm includes applying to the statistics, a regression algorithm trained to identify one or more candidate issues. Applying the machine learning algorithm also includes applying to the one or more candidate issues, a classification algorithm trained to classify each candidate issue as an issue of the one or more issues or a false positive. The processor additionally generates a script that, when executed, remediates the candidate issues of the one or more candidate issues classified by the classification algorithm as the issues of the one or more issues. The processor further executes the script.

Self-learning database issue remediation tool

A disaster recovery tool includes a server monitoring engine, a configuration engine, a security engine, and a runtime engine. The server monitoring engine detects a production server and determines that a disaster recovery server should be created for the production server. The configuration engine compares database configuration files for the production server and the disaster recovery server and copies the database configuration file for the production server to the disaster recovery server. The security engine compares user logins and file sharing credentials of the production server and the disaster recovery server and copies the user login and file sharing credential of the production server to the disaster recovery server. The runtime engine compares database jobs and schedules of the production server and the disaster recovery server and copies the database job and schedule of the production server to the disaster recovery server.

Growing community of inventors

Mumbai, India

Rakesh Shah