Diagnosing changes in application behavior based on database usage
View Patent ↗Applications that utilize a database are managed through the use of meta-metadata. The database contains multiple database objects. Each database object has metadata that describes one or more operational characteristics of that database object. Each metadata has an associated meta-metadata, which describes a variance to the metadata. An application program is provided access to one or more database objects. If a change in behavior occurs for the application program that has accessed the database objects, the meta-metadata for the accessed database objects is correlated with the application program accessing the database objects.
1. A method for managing applications that utilize a database, the method comprising:
a processor of a data processing system executing code that performs the functions of:
defining a plurality of metadata that describe operational characteristics of a database object;
defining a meta-metadata for each metadata in the plurality of metadata, wherein the meta-metadata describes a metadata variance for each metadata in the plurality of metadata;
providing, to a first application program, access to the database object; and
correlating a change in a behavior of the first application program with the meta-metadata when the first application program accesses the database object.
2. The method of claim 1 , further comprising:
diagnosing a cause of the change in application behavior of the first application program, wherein the cause is based on the meta-metadata.
3. The method of claim 1 , further comprising:
identifying a second application program that is executing whenever the change in application behavior to the first application occurs in conjunction with the meta-metadata; and
modifying a fault-diagnosis routine based on identifying the second application program executing, wherein the fault-diagnosis routine identifies a feature of the database object that caused the change in the behavior of the first application program.
4. The method of claim 1 , further comprising:
identifying a computer resource that is being utilized whenever the change in application behavior to the first application occurs in conjunction with the meta-metadata; and
modifying a fault-diagnosis routine based on identifying the computer resource that is being utilized, wherein the fault-diagnosis routine identifies a feature of the database object that caused the change in the behavior of the first application program.
5. The method of claim 4 , wherein the computer resource is a memory in a client computer that is executing the first application.
6. The method of claim 4 , wherein the computer resource is a processor that is executing the first application.
7. The method of claim 1 , wherein the operational characteristic of the database object describes a size growth of the database object.
8. The method of claim 7 , wherein the metadata variance is a rate of change of the size growth of the database object, and wherein the meta-metadata describes the rate of change of the size growth of the database object.
9. The method of claim 1 , wherein the operational characteristic of the database object describes a frequency of serial accesses of data in the database object.
10. The method of claim 9 , wherein the metadata variance is a rate of change of the frequency of serial access of data in the database object, and wherein the meta-metadata describes the rate of change of the frequency of serial accesses of data in the database object.
11. The method of claim 1 , wherein the operational characteristic of the database object describes a frequency of indexed accesses of data in the database object.
12. The method of claim 11 , wherein the metadata variance is a rate of change of the frequency of indexed accesses of data in the database object, and wherein the meta-metadata describes the rate of change of the frequency of indexed accesses of data in the database object.
13. The method of claim 1 , further comprising:
in response to correlating the change in the behavior of the first application program with the meta-metadata, capturing a plurality of meta-metadata for the database object; and
in response to detecting a change in a behavior of a second application program when the second application program accesses the database object, predicting a cause of the change in the behavior of the second application program based on the captured plurality of meta-metadata for the database object.
14. The method of claim 1 , wherein the database object is a database table.
15. A system comprising:
a processor;
a data bus coupled to the processor;
a memory coupled to the data bus; and
a computer-usable medium embodying computer program code, the computer program code comprising instructions executable by the processor and configured for managing applications that utilize a database by performing the steps of:
defining a plurality of metadata that describe operational characteristics of a database object;
defining a meta-metadata for each metadata in the plurality of metadata, wherein the meta-metadata describes a metadata variance for each metadata in the plurality of metadata;
providing, to a first application program, access to the database object; and
correlating a change in a behavior of the first application program with the meta-metadata when the first application program accesses the database object.
16. The system of claim 15 , wherein the instructions are further configured for:
diagnosing a cause of the change in application behavior of the first application program, wherein the cause is based on the meta-metadata.
17. A computer-readable storage medium embodying computer program code for managing applications that utilize a database, the computer program code comprising computer executable instructions configured for:
defining a plurality of metadata that describe operational characteristics of a database object;
defining a meta-metadata for each metadata in the plurality of metadata, wherein the meta-metadata describes a metadata variance for each metadata in the plurality of metadata;
providing, to a first application program, access to the database object; and
correlating a change in a behavior of the first application program with the meta-metadata when the first application program accesses the database object.
18. The computer-readable storage medium of claim 17 , wherein the computer executable instructions are further configured for:
diagnosing a cause of the change in application behavior of the first application program, wherein the cause is based on the meta-metadata.
19. The computer-readable storage medium of claim 17 , wherein the computer-usable medium is a component of a remote server, and wherein the computer executable instructions are deployable to a client computer from the remote server.
20. The computer-readable storage medium of claim 17 , wherein the computer executable instructions are capable of being provided by a service provider to a customer on an on-demand basis.