OPERATION ANALYTIC REPOSITORY CENTRAL MONITORING SYSTEM

• US 20160196294A1
• Filed: 01/01/2015
• Published: 07/07/2016
• Est. Priority Date: 01/01/2015
• Status: Active Application

• Current Assignee: Bank of America Corp.
• Original Assignee: Bank of America Corp.
• Inventors: Tilekar, Ulhas Shashikant
• Granted Patent: US 10,282,441 B2
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/215 Improving data quality; Data cleansing, e.g. de-duplication, removing invalid entries or correcting typographical errors
• CPC Class Codes: G06F 16/2308 Concurrency control transaction processing G06F9/466
• CPC Class Codes: G06F 16/2365 Ensuring data consistency and integrity
• CPC Class Codes: G06F 21/31 User authentication
• CPC Class Codes: G06F 21/604 Tools and structures for managing or administering access control systems
• CPC Class Codes: G06Q 10/063 Operations research, analysis or management

Abstract

Embodiments of the invention are directed to systems, methods and computer program products for use in financial systems, where messages are automatically generated based on message templates. An exemplary apparatus is configured to access one or more databases within an operation analytic repository having data stored therein; store in the at least one database, for a predetermined time period, for analysis; process, for at least one of the databases, a proactive action whereby the proactive action implements an ongoing health assessment of the data stored within the at least one database; and in response to receiving indication of an issue within at least one of databases, provide a reactive action whereby the reactive action determines one or more steps necessary to correct the issue.

Claims

1. An apparatus for use in operation analytic repository database monitoring, whereby the apparatus automatically monitors and provides corrective actions for detected issues, the apparatus comprising:

an electronic storage device;

a computing processor; and

a module stored in the electronic storage device, said module comprising instruction code executable by one or more computing processors, and configured to cause the one or more computing processors to;

access one or more databases within an operation analytic repository;

store data in the at least one database, for a predetermined time period, for analysis;

process, for at least one of the databases, a proactive action whereby the proactive action implements an ongoing health assessment of the data stored within the at least one database; and

in response to receiving indication of an issue within at least one of databases, provide a reactive action whereby the reactive action determines one or more steps necessary to resolve the issue.

2. The apparatus of claim 1, wherein processing the proactive action comprises the module being configured to cause one or more computing processors run at least one monitoring script on the at least one database.

3. The apparatus of claim 2, wherein running the monitoring script on the at least one database may further comprise the module being configured to cause one or more computing processors to receive, based on an analysis of the script, indication of a potential issue within at least one of databases.

4. The apparatus of claim 3, wherein receiving indication of the potential issue with the at least one database may further comprise the module being configured to cause one or more computing processors to notify at least one party of the potential issue within the at least one of database.

5. The apparatus of claim 3, wherein receiving indication of the potential issue with the at least one database may further comprise the module being configured to cause one or more computing processors to determine to automatically correct the potential issue within the at least one of database.

6. The apparatus of claim 1, wherein accessing one or more databases within the operation analytic repository may further comprise the module being configured to cause one or more computing processors to:

receive one or more authentication credentials; and

prior to granting access to the one or more databases within the operation analytic repository, authenticate a user'"'"'s identity based at least in part on validating the one or more authentication credentials.

7. The apparatus of claim 1, wherein the module is configured to cause one or more computing processors to:

provide a central monitoring tool, and wherein the central monitoring tool comprises an interface such that information related to the one or more databases within the operation analytic repository is simultaneously displayed within the central monitoring tool;

fetch data from the one or more databases within the operation analytic repository for presentation within the central monitoring tool; and

present the fetched data from the one or more databases within the operation analytic repository.

8. The apparatus of claim 1, wherein storing the at least a portion of the data stored within the at least one database may further comprise the module being configured to cause one or more computing processors to analyze the data stored on periodic, semi-periodic, or continuous basis.

9. The apparatus of claim 1, wherein analyzing the stored data may further comprise the module being configured to cause one or more computing processors to:

monitor the stored data;

identify one or more parameters for improvement within the stored data;

determine whether or not the one or more parameters for improvement within the stored data are necessary; and

in response to determining the one or more parameters for improvement within the stored data are necessary, implementing at least one action to improve data within the at least one database.

10. The apparatus of claim 1, wherein the module is configured to cause one or more computing processors to maintain a record log of indications of an issue within the at least one of databases.

11. The apparatus of claim 1, wherein the module is configured to cause one or more computing processors to:

analyze an indication of an issue within the at least one of databases; and

determine, based on the results of the analysis, whether or not the issue can be resolved by the system.

12. The apparatus of claim 11, wherein the module is configured to cause one or more computing processors to in response to determining the issue can be resolved by the system, implementing the one or more steps necessary to resolve the issue.

13. The apparatus of claim 11, wherein the module is configured to cause one or more computing processors to in response to determining the issue cannot be resolved by the system, determining to automatically escalate the issue to a third party system or entity for resolution.

14. The apparatus of claim 1, wherein the module is configured to cause one or more computing processors to:

receive a threshold value for determining whether or not a potential issue exists, wherein a value above the threshold indicates that a potential issue exists, and wherein a value below the threshold indicates that a potential issue does not exist; and

determine, based on the threshold hold value, whether or not a potential issue exists.

15. A computer implemented method for use in operation analytic repository database monitoring, whereby the method comprises automatically monitoring and providing corrective actions for detected issues, the method comprising:

accessing one or more databases within an operation analytic repository;

storing datain the at least one database, for a predetermined time period, for analysis;

processing, for at least one of the databases, a proactive action whereby the proactive action implements an ongoing health assessment of the data stored within the at least one database; and

in response to receiving indication of an issue within at least one of databases, providing a reactive action whereby the reactive action determines one or more steps necessary to correct the issue.

16. The method of claim 15, wherein receiving indication of the potential issue with the at least one database further comprising determining to automatically correct the potential issue within the at least one of database.

17. The method of claim 15 further comprising:

analyzing an indication of an issue within the at least one of the databases; and

determining, based on the results of the analysis, whether or not the issue can be resolved by a system.

18. A computer program product for use in operation analytic repository database monitoring, whereby the computer program product automatically monitors and provides corrective actions for detected issues, the computer program product comprising:

a non-transitory computer-readable medium comprising a set of codes for causing a computer to;

access one or more databases within an operation analytic repository;

store data in the at least one database, for a predetermined time period, for analysis;

process, for at least one of the databases, a proactive action whereby the proactive action implements an ongoing health assessment of the data stored within the at least one database; and

in response to receiving indication of an issue within at least one of databases, provide a reactive action whereby the reactive action determines one or more steps necessary to correct the issue.

19. The computer program product of claim 18, the computer program product further comprising a set of codes for causing a computer to determine to automatically correct the potential issue within the at least one of database.

20. The computer program product of claim 18, the computer program product further comprising a set of codes for causing a computer to:

analyze an indication of an issue within the at least one of databases; and

determine, based on the results of the analysis, whether or not the issue can be resolved by the system.