Method and System for Centralized Control of Database Applications

• US 20110270857A1
• Filed: 04/30/2010
• Published: 11/03/2011
• Est. Priority Date: 04/30/2010
• Status: Active Grant

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Ostler, Paul A., Bommireddipalli, Vijay R., Horman, Randall W., Brodsky, Stephen A., Chang, David W., Dawra, Anshul, Leung, Tony K.
• Granted Patent: US 9,129,000 B2
• Time in Patent Office: Days
• US Class Current: 707/758
• 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 computer-implemented method of controlling database applications comprising:

retrieving application specific property information for a database application from a data repository, wherein said database application provides access to a database system; and

applying said retrieved application specific property information to said database application to control operation of said database application.

2. The method of claim 1, wherein said application specific property information includes one or more properties associated with a query language execution model of said database application to control execution of query language statements.

3. The method of claim 2, wherein said application specific property information includes optimized query language statements for execution, and said applying said application specific property information includes binding said optimized query language statements to said database system in response to said application specific property information indicating static execution of said query language statements.

4. The method of claim 2, wherein said application specific property information includes optimized query language statements for execution, and said applying said application specific property information includes intercepting and replacing query language statements of said database application with said optimized query language statements in response to said application specific property information indicating replacement of said query language statements.

5. The method of claim 2, wherein said application specific property information includes an indication of at least one query language statement permitted for execution to control operation of said database application.

6. The method of claim 2, wherein said application specific property information includes an indication of at least one query language statement prohibited from execution to control operation of said database application.

7. The method of claim 2, wherein said application specific property information includes an indication of query language statements to be batched for execution to control operation of said database application.

8. The method of claim 1, wherein said database application includes a program stack with a plurality of layers to access said database system, and wherein said application specific property information includes one or more properties associated with at least one layer of said program stack to control operation of said database application.

9. The method of claim 1, wherein said application specific property information includes a number of connections to control actions of the database application based on the number of connections to said database system.

10. The method of claim 1, wherein said application specific property information includes a number of connections to control the number of connections to said database system maintained by said database application.

11. The method of claim 1, wherein said retrieving said application specific property information includes:

determining the presence of updated application specific property information for said database application; and

retrieving said updated application specific property information from said data repository.

12. The method of claim 1, wherein said data repository stores application specific property information for a plurality of database applications, and wherein said retrieving said application specific property information includes:

retrieving application specific property information for each database application from said data repository based on respective identifiers.

13. The method of claim 12, wherein at least two of said database applications reside on different computer systems.

14. The method of claim 1, wherein said application specific property information includes a profile to authenticate a corresponding user to enforce rules on database objects.

15. The method of claim 1, wherein said database application is associated with a plurality of configurations each stored in said data repository and including said application specific property information to configure said database application for a corresponding desired operation.

16. The method of claim 1, wherein said retrieving said application specific property information includes:

intercepting executed query language statements of said database application and providing performance information pertaining to execution of those statements; and

associating said executed query language statements with optimized query language statements for execution based on a relation of said performance information to a threshold, wherein said application specific property information includes said optimized query language statements.

17. A system for controlling database applications comprising:

a computer system including a database application to provide access to a database system, wherein said computer system further includes at least one processor configured to;

request retrieval of application specific property information for said database application from a data repository; and

apply said retrieved application specific property information to said database application to control operation of said database application.

18. The system of claim 17, wherein said application specific property information includes one or more properties associated with a query language execution model of said database application to control execution of query language statements.

19. The system of claim 18, wherein said application specific property information includes optimized query language statements for execution, and said optimized query language statements are bound to said database system in response to said application specific property information indicating static execution of said query language statements.

20. The system of claim 18, wherein said application specific property information includes optimized query language statements for execution, and said at least one processor is further configured to intercept and replace query language statements of said database application with said optimized query language statements in response to said application specific property information indicating replacement of said query language statements.

21. The system of claim 18, wherein said application specific property information includes an indication of at least one query language statement permitted for execution to control operation of said database application.

22. The system of claim 18, wherein said application specific property information includes an indication of at least one query language statement prohibited from execution to control operation of said database application.

23. The system of claim 18, wherein said application specific property information includes an indication of query language statements to be batched for execution to control operation of said database application.

24. The system of claim 17, wherein said database application includes a program stack with a plurality of layers to access said database system, and wherein said application specific property information includes one or more properties associated with at least one layer of said program stack to control operation of said database application.

25. The system of claim 17, wherein said application specific property information includes a number of connections to control actions of the database application based on the number of connections to said database system.

26. The system of claim 17, wherein said application specific property information includes a number of connections to control the number of connections to said database system maintained by said database application.

27. The system of claim 17, wherein said at least one processor is further configured to:

periodically request retrieval of updated application specific property information for said database application from said data repository.

28. The system of claim 17, wherein said data repository stores application specific property information for a plurality of database applications, wherein said system further includes a plurality of computer systems each including a database application and at least one processor configured to:

retrieve application specific property information for a corresponding database application from said data repository based on an identifier.

29. The system of claim 17, further including:

a control system in communication with said data repository and including at least one processor configured to;

receive a request from said computer system and retrieve said application specific property information for said database application from said data repository based on an identifier; and

provide said retrieved application specific property information to said computer system.

30. The system of claim 17, further including:

a control system in communication with said data repository and including at least one processor configured to;

determine the presence of updated application specific property information for said database application; and

retrieve said updated application specific property information for said database application from said data repository and provide said updated application specific property information to said computer system.

31. The system of claim 17, wherein said application specific property information includes a profile to authenticate a corresponding user to enforce rules on database objects.

32. The system of claim 17, wherein said database application is associated with a plurality of configurations each stored in said data repository and including said application specific property information to configure said database application for a corresponding desired operation.

33. The system of claim 17, wherein said at least one processor is further configured to:

intercept executed query language statements of said database application and provide performance information pertaining to execution of those statements; and

associate said executed query language statements with optimized query language statements for execution based on a relation of said performance information to a threshold, wherein said application specific property information includes said optimized query language statements.

34. A computer program product for controlling database applications 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;

request retrieval of application specific property information for said database application from a data repository; and

apply said retrieved application specific property information to said database application to control operation of said database application.

35. The computer program product of claim 34, wherein said application specific property information includes one or more properties associated with a query language execution model of said database application to control execution of query language statements.

36. The computer program product of claim 35, wherein said application specific property information includes optimized query language statements for execution, and said applying said application specific property information includes binding said optimized query language statements to said database system in response to said application specific property information indicating static execution of said query language statements.

37. The computer program product of claim 35, wherein said application specific property information includes optimized query language statements for execution, and said applying said application specific property information includes intercepting and replacing query language statements of said database application with said optimized query language statements in response to said application specific property information indicating replacement of said query language statements.

38. The computer program product of claim 35, wherein said application specific property information includes an indication of at least one query language statement permitted for execution to control operation of said database application.

39. The computer program product of claim 35, wherein said application specific property information includes an indication of at least one query language statement prohibited from execution to control operation of said database application.

40. The computer program product of claim 35, wherein said application specific property information includes an indication of query language statements to be batched for execution to control operation of said database application.

41. The computer program product of claim 34, wherein said database application includes a program stack with a plurality of layers to access said database system, and wherein said application specific property information includes one or more properties associated with at least one layer of said program stack to control operation of said database application.

42. The computer program product of claim 34, wherein said application specific property information includes a number of connections to control actions of the database application based on the number of connections to said database system.

43. The computer program product of claim 34, wherein said application specific property information includes a number of connections to control the number of connections to said database system maintained by said database application.

44. The computer program product of claim 34, wherein said computer readable program code is further configured to:

periodically request retrieval of updated application specific property information for said database application from said data repository.

45. The computer program product of claim 34, wherein said data repository stores application specific property information for a plurality of database applications, wherein said computer readable program code includes computer readable program code configured to enable each of a plurality of computer systems each including a database application and at least one processor to:

retrieve application specific property information for a corresponding database application from said data repository based on an identifier.

46. The computer program product of claim 34, wherein said computer readable program code includes computer readable program code configured to enable a control system in communication with said data repository to:

receive a request and retrieve said application specific property information for said database application from said data repository based on an identifier; and

provide said retrieved application specific property information to configure said database application.

47. The computer program product of claim 34, wherein said computer readable program code includes computer readable program code configured to enable a control system in communication with said data repository to:

determine the presence of updated application specific property information for said database application; and

retrieve said updated application specific property information for said database application from said data repository and provide said updated application specific property information to configure said database application.

48. The computer program product of claim 34, wherein said application specific property information includes a profile to authenticate a corresponding user to enforce rules on database objects.

49. The computer program product of claim 34, wherein said database application is associated with a plurality of configurations each stored in said data repository and including said application specific property information to configure said database application for a corresponding desired operation.

50. The computer program product of claim 34, wherein said computer readable program code includes computer readable program code configured to:

intercept executed query language statements of said database application and provide performance information pertaining to execution of those statements; and

associate said executed query language statements with optimized query language statements for execution based on a relation of said performance information to a threshold, wherein said application specific property information includes said optimized query language statements.