-
公开(公告)号:US20180081910A1
公开(公告)日:2018-03-22
申请号:US15273077
申请日:2016-09-22
Applicant: Bank of America Corporation
IPC: G06F17/30
CPC classification number: G06F16/21 , G06F16/22 , G06F16/2379
Abstract: 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.
-
公开(公告)号:US20210209076A1
公开(公告)日:2021-07-08
申请号:US16736608
申请日:2020-01-07
Applicant: Bank of America Corporation
Inventor: Rama Krishna Venkata Gandi , Thangaraju Nachimuthu , Rakesh Shah , Anant Bondalapati Sharma , Sivasankar Sivasalam
Abstract: 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.
-
公开(公告)号:US20200019537A1
公开(公告)日:2020-01-16
申请号:US16579378
申请日:2019-09-23
Applicant: Bank of America Corporation
Abstract: 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.
-
公开(公告)号:US10459894B2
公开(公告)日:2019-10-29
申请号:US15273077
申请日:2016-09-22
Applicant: Bank of America Corporation
Abstract: 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.
-
公开(公告)号:US10374906B2
公开(公告)日:2019-08-06
申请号:US15672535
申请日:2017-08-09
Applicant: Bank of America Corporation
Inventor: Anant Bondalapati Sharma , Rohit Kumar Jain , Sasidhar Purushothaman
IPC: H04L12/24 , H04L12/26 , H04L12/911 , G06F9/455
Abstract: An apparatus includes a scanner and a cloud engine. The scanner determines that a first cloud environment is of a first type and that a second cloud environment is of a second type that is different from the first type. The cloud engine selects a first tool and a second tool. The cloud engine also sets a first parameter and a first configuration for the first tool and a second parameter and a second configuration for the second tool. The cloud engine further receives a first alert that a security vulnerability in the first cloud environment has been detected and a second alert that resource consumption in the second cloud environment has exceeded a threshold. The cloud engine communicates a first solution to resolve the security vulnerability in the first cloud environment and a second solution to lower resource consumption in the second cloud environment.
-
公开(公告)号:US10255138B2
公开(公告)日:2019-04-09
申请号:US15238859
申请日:2016-08-17
Applicant: BANK OF AMERICA CORPORATION
Abstract: 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.
-
公开(公告)号:US11520754B2
公开(公告)日:2022-12-06
申请号:US16579378
申请日:2019-09-23
Applicant: Bank of America Corporation
Abstract: 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.
-
公开(公告)号:US20170103100A1
公开(公告)日:2017-04-13
申请号:US14881623
申请日:2015-10-13
Applicant: BANK OF AMERICA CORPORATION
CPC classification number: G06F16/2365 , G06F11/0709 , G06F11/0766 , G06F11/079 , G06F11/1448 , G06F16/21 , G06F16/2455 , G06F2201/80 , H04L67/10
Abstract: The present invention provides for multidimensional automated database administration, such that, multiple database scripts can be deployed and executed across multiple database servers and the multiple databases stored therein. In addition, the present invention manages the sequence/order in which the scripts are automatically deployed/executed and provides for automated tracking of execution results including error tracking on a per script basis. Additionally, the invention can be deployed in a distributed network allowing for cross domain connectivity to the database servers for the purpose of executing the database scripts without requiring deployment of server-side script deployment agents.
-
公开(公告)号:US20170032000A1
公开(公告)日:2017-02-02
申请号:US14810558
申请日:2015-07-28
Applicant: Bank of America Corporation
CPC classification number: G06F16/25
Abstract: An apparatus stores a schedule indicating when a job is scheduled to execute. The apparatus receives a request to execute a first job and determines from the schedule that a second job is scheduled to execute during the execution of the first job. The apparatus estimates a first amount of memory to be consumed by the first job and a second amount of memory to be consumed by the second job, and determines whether a sum of the first amount and the second amount exceeds an amount of free memory. The apparatus determines a table that the first job accesses, and determines whether the table is accessed by the second job. The apparatus communicates a message indicating a period of time to wait before executing the first job if the sum exceeds the amount of free memory or if the table is accessed during by the second job.
Abstract translation: 设备存储指示作业被调度执行何时的调度。 该装置接收执行第一作业的请求,并从该调度确定在执行第一作业期间第二作业被调度为执行。 该装置估计第一作业要消耗的第一存储量和第二作业要消耗的第二存储量,并且确定第一数量和第二数量之和是否超过空闲存储量。 该装置确定第一作业访问的表,并确定该表是否被第二作业访问。 如果总和超过可用存储器的量,或者如果在第二作业期间访问了表,则该设备传送指示在执行第一作业之前等待的时间段的消息。
-
公开(公告)号:US11379442B2
公开(公告)日:2022-07-05
申请号:US16736608
申请日:2020-01-07
Applicant: Bank of America Corporation
Inventor: Rama Krishna Venkata Gandi , Thangaraju Nachimuthu , Rakesh Shah , Anant Bondalapati Sharma , Sivasankar Sivasalam
Abstract: 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.
-
-
-
-
-
-
-
-
-