Method and System for Centralized Control of Database Applications

• US 20150347524A1
• Filed: 08/10/2015
• Published: 12/03/2015
• Est. Priority Date: 04/30/2010
• Status: Active Grant

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Bommireddipalli, Vijay R., Brodsky, Stephen A., Chang, David W., Dawra, Anshul, Horman, Randall W., Leung, Tony K., Ostler, Paul A.
• Granted Patent: US 9,679,017 B2
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/217 Database tuning G06F16/2282 takes precedence; database performance monitoring G06F11/3409
• CPC Class Codes: G06F 16/23 Updating
• CPC Class Codes: G06F 16/2453 Query optimisation
• CPC Class Codes: G06F 16/24564 Applying rules; Deductive queries
• CPC Class Codes: G06F 16/24575 using context
• CPC Class Codes: G06F 16/252 between a Database Management System and a front-end application
• CPC Class Codes: G06F 16/284 Relational databases
• CPC Class Codes: G06F 21/62 Protecting access to data via a platform, e.g. using keys or access control rules
• CPC Class Codes: H04L 67/10 in which an application is distributed across nodes in the network software deployment G06F8/60; multiprogramming arrangements G06F9/46

Abstract

According to one embodiment of the present invention, a system enables control of database applications. The system comprises a computer system including a database application to provide access to a database system, and at least one processor. The computer system requests retrieval of application specific property information for the database application from a data repository, and applies the retrieved application specific property information to the database application to control operation of the database application. Embodiments of the present invention further include a method and computer program product for controlling database applications in substantially the same manner described above.

Claims

1. A method comprising:

storing, at a first network connected device, application specific information for each of a plurality of applications, wherein the application specific information controls access of the plurality of applications to one or more databases;

receiving, at the first network connected device, a request from a second network connected device for application specific information for one of the plurality of applications;

wherein the one of the plurality of applications executes on the second network connected device;

monitoring, at the first network connected device, access of the one or more databases by the one of the plurality of applications executing on the second network connected device, wherein the one of the plurality of applications accesses the one or more databases without an application gateway;

updating, at the first network connected device, the application specific information for the one of the plurality of applications in response to the monitoring; and

providing the updated application specific information to the second network connected device.

2. The method of claim 1, wherein monitoring access of the one or more databases by the one of the plurality of applications comprises receiving a file from the second network connected device, wherein the file comprises a query language statement.

3. The method of claim 1, wherein monitoring access of the one or more databases by the one of the plurality of applications comprises receiving information from the one or more databases.

4. The method of claim 1, wherein monitoring access of the one or more databases by the one of the plurality of applications comprises monitoring an execution time of a query language statement.

5. The method of claim 1, wherein providing the updated application specific information to the second network connected device comprises receiving a query for the updated application specific information from the second network connected device, and sending the updated application specific information to the second network connected device in response to the query.

6. The method of claim 1, wherein updating the application specific information in response to the monitoring comprises optimizing query language in response to a query language statement failing to meet a predetermined performance threshold.

7. The method of claim 1, wherein updating the application specific information in response to the monitoring comprises determining a number of connections the one of the applications uses to access the one or more databases.

8. An apparatus comprising:

a network interface;

a memory; and

a processor, wherein the processor is configured to;

store, in the memory, application specific information for each of a plurality of applications, wherein the application specific information controls access of the plurality of applications to one or more databases;

receive, over the network interface, a request from a network connected device for application specific information for one of the plurality of applications, wherein the one of the plurality of applications executes on the network connected device;

monitor access of the one or more databases by the one of the plurality of applications executing on the second network connected device, wherein the one of the plurality of applications accesses the one or more databases without an application gateway;

update, in the memory, the application specific information for the one of the plurality of applications in response to the monitoring; and

provide, via the network interface, the updated application specific information to the network connected device.

9. The apparatus of claim 8, wherein the processor is configured to monitor access of the one or more databases by the one of the plurality of applications by receiving a file, via the network interface from the network connected device, wherein the file comprises a query language statement.

10. The apparatus of claim 8, wherein the processor is configured to monitor access of the one or more databases by the one of the plurality of applications by receiving, via the network interface, information from the one or more databases.

11. The apparatus of claim 8, wherein the processor is configured to monitor access of the one or more databases by the one of the plurality of applications by monitoring an execution time of a query language statement.

12. The apparatus of claim 8, wherein the processor is configured to provide the updated application specific information to the network connected device in response to receiving a query for the updated application specific information from the network connected device, and sending, via the network interface, the updated application specific information to the network connected device in response to the query.

13. The apparatus of claim 8, wherein the processor is configured to update the application specific information by optimizing query language in response to a query language statement failing to meet a predetermined performance threshold.

14. The apparatus of claim 8, wherein the processor is configured to update the application specific information by determining a number of connections the one of the applications uses to access the one or more databases.

15. A computer program product for controlling a database application comprising:

a computer readable storage medium having computer readable program code embodied therewith, the computer readable program code comprising computer readable program code configured to cause a processor to;

store, in a memory, application specific information for each of a plurality of applications, wherein the application specific information controls access of the plurality of applications to one or more databases;

receive, over a network interface, a request from a network connected device for application specific information for one of the plurality of applications, wherein the one of the plurality of applications executes on the network connected device;

monitor access of the one or more databases by the one of the plurality of applications executing on the second network connected device, wherein the one of the plurality of applications accesses the one or more databases without an application gateway;

update, in the memory, the application specific information for the one of the plurality of applications in response to the monitoring; and

provide, via the network interface, the updated application specific information to the network connected device.

16. The computer program product of claim 15, wherein the computer readable program code configured to monitor access of the one or more databases is further configured to receive a file, via the network interface from the network connected device, wherein the file comprises a query language statement.

17. The computer program product of claim 15, wherein the computer readable program code configured to monitor access of the one or more databases is further configured to receive, via the network interface, information from the one or more databases.

18. The computer program product of claim 15, wherein the computer readable program code configured to monitor access of the one or more databases is further configured to monitor an execution time of a query language statement.

19. The computer program product of claim 15, wherein the computer readable program code configured to provide the updated application specific information to the network connected device is further configured to receive a query for the updated application specific information from the network connected device, and send, via the network interface, the updated application specific information to the network connected device in response to the query.

20. The computer program product of claim 15, wherein the computer readable program code configured to provide the updated application specific information to the network connected device is configured to update the application specific information by determining a number of connections the one of the applications uses to access the one or more databases.