# US 2008/0313498 A1 · Diagnosing Changes in Application Behavior Based on Database Usage

> Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt

- Number: US 2008/0313498 A1
- Document ID: US20080313498A1
- Status: Published application
- Kind: A1
- Application number: 11/763,500
- Filed: 2007-06-15
- Published: 2008-12-18
- Earliest claimed: 2007-06-15
- Assignees: International Business Machines Corporation
- Inventors: Derek M. Jennings
- Web page: https://patentgrep.com/patent/US20080313498A1

## CPC

- G06F 16/217: {Database tuning (G06F16/2282 takes precedence; database performance monitoring G06F11/3409)}
- G06F 11/0727: {in a storage system, e.g. in a DASD or network based storage system (drivers for digital recording or reproducing units G06F3/06; circuits for error detection or correction within digital recording or reproducing units G11B20/18; for distributed storage of data in networks, e.g. transport arrangements for network file system [NFS], storage area networks [SAN] or network attached storage [NAS], H04L67/1097)}
- G06F 11/3409: {for performance assessment}
- G06F 11/3452: {Performance evaluation by statistical analysis}
- G06F 16/27: Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
- G06F 11/079: {Root cause analysis, i.e. error or fault diagnosis (in a hardware test environment G06F11/22; in a software test environment G06F11/36)}
- G06F 11/0793: {Remedial or corrective actions (recovery from an exception in an instruction pipeline G06F9/3861; by retry G06F11/1402; for recovering from a failure of a protocol instance or entity H04L69/40)}
- G06F 2201/80: Database-specific techniques
- G06F 2201/87: Monitoring of transactions
- G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N)

## Abstract

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.

## Claims

### Claim 1

A method for managing applications that utilize a database, the method comprising:
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.

### Claim 2 (depends on 1)

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.

### Claim 3 (depends on 1)

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.

### Claim 4 (depends on 1)

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.

### Claim 5 (depends on 4)

The method of claim 4, wherein the computer resource is a memory in a client computer that is executing the first application.

### Claim 6 (depends on 4)

The method of claim 4, wherein the computer resource is a processor that is executing the first application.

### Claim 7 (depends on 1)

The method of claim 1, wherein the operational characteristic of the database object describes a size growth of the database object.

### Claim 8 (depends on 7)

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.

### Claim 9 (depends on 1)

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.

### Claim 10 (depends on 9)

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.

### Claim 11 (depends on 1)

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.

### Claim 12 (depends on 11)

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.

### Claim 13 (depends on 1)

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.

### Claim 14 (depends on 1)

The method of claim 1, wherein the database object is a database table.

### Claim 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.

### Claim 16 (depends on 15)

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.

### Claim 17

A computer-readable 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.

### Claim 18 (depends on 17)

The computer-readable 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.

### Claim 19 (depends on 17)

The computer-readable 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.

### Claim 20 (depends on 17)

The computer-readable 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.
