Method and Apparatus of Collecting and Reporting Database Application Incompatibilities
AssigneeBank of America Corporation
InventorsDeepak Gaikwad, Lai Fai Wong, Muthuraj Kumaresan
Life of this patent
Estimating the term…
Abstract
Some aspects disclosed herein are directed to, for example, a system and method of detecting database application incompatibilities. Systems and methods described herein may format traces, collect data, store the data, and/or provide one or more user interface which allows an end user to quickly and easily identify affected statements, such as structured query language (SQL) statements, for remediation action(s).
Claims20
A method comprising:
- initiating, by a computing device, one or more traces configured to detect instances of incompatible data occurring in an application;
- monitoring, by the one or more traces, for instances of incompatible data occurring in the application;
- detecting, by the computing device and via the one or more traces, an instance of incompatible data occurring in the application;
- in response to detecting the instance of the incompatible data occurring in the application, determining a statement type of the instance of the incompatible data occurring in the application;
- based on the determined statement type, retrieving a statement associated with the instance of the incompatible data occurring in the application;
- and
- sending, by the computing device, application identification details and the statement associated with the instance of the incompatible data occurring in the application for storage in a database.
An apparatus, comprising:
- a processor;
- and
- memory storing computer-executable instructions that, when executed by the processor, cause the apparatus to:
- initiate one or more traces configured to detect instances of incompatible data occurring in an application;
- monitor, by the one or more traces, for instances of incompatible data occurring in the application;
- detect, via the one or more traces, an instance of incompatible data occurring in the application;
- in response to detecting the instance of the incompatible data occurring in the application, determine a statement type of the instance of the incompatible data occurring in the application;
- based on the determined statement type, retrieve a statement associated with the instance of the incompatible data occurring in the application;
- and
- send application identification details and the statement associated with the instance of the incompatible data occurring in the application for storage in a database.
One or more non-transitory computer-readable medium having instructions stored thereon that, when executed by one or more computing devices, cause the one or more computing devices to:
- initiate one or more traces configured to detect instances of incompatible data occurring in an application;
- monitor, by the one or more traces, for instances of incompatible data occurring in the application;
- detect, via the one or more traces, an instance of incompatible data occurring in the application;
- in response to detecting the instance of the incompatible data occurring in the application, determine a statement type of the instance of the incompatible data occurring in the application;
- based on the determined statement type, retrieve a statement associated with the instance of the incompatible data occurring in the application;
- and
- send application identification details and the statement associated with the instance of the incompatible data occurring in the application for storage in a database.
Dependencies are inferred from the claim text.