# US 2008/0301151 A1 · Computer system and database management method using the same

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

- Number: US 2008/0301151 A1
- Document ID: US20080301151A1
- Status: Published application
- Kind: A1
- Application number: 11/968,681
- Filed: 2008-01-03
- Published: 2008-12-04
- Earliest claimed: 2007-05-31
- Assignees: Hitachi, Ltd.
- Inventors: Hideomi Idei; Kazuhiko Mogi; Norifumi Nishikawa
- Web page: https://patentgrep.com/patent/US20080301151A1

## CPC

- G06F 16/24552: {Database cache management}
- G06F 16/24557: {Efficient disk access during query execution}
- G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N)

## Abstract

A pre-fetch server, which is connected to a DB server running a DBMS and to a storage apparatus storing DB data, stores information required for judging whether or not a pre-fetch is effective. Judgment on whether or not the pre-fetch will be effective is performed when a pre-fetch I/O is issued. If the pre-fetch server judges that the pre-fetch will be effective, it issues the pre-fetch I/O to the storage apparatus.

## Claims

### Claim 1

A computer system, comprising:
a computer that includes a database management program;
a storage apparatus that includes a database that can be accessed by the database management program;
a first circuit that issues, before the database management program accesses target data in the database, a command for commanding the storage apparatus to pre-fetch the target data from the database; and
a second circuit that judges the effectiveness of the command and provides the command to the storage apparatus if the judgment is positive.

### Claim 2 (depends on 1)

The computer system according to claim 1, wherein the second circuit judges whether or not the storage apparatus can pre-fetch the target data before the database management program accesses the target data.

### Claim 3 (depends on 2)

The computer system according to claim 2, wherein, if the storage apparatus cannot pre-fetch the target data before the database management program accesses the target data, the second circuit does not issue the command to the storage apparatus.

### Claim 4

A computer system, comprising:
a first computer that includes a database management program;
a storage apparatus that includes a database that can be accessed by the database management program, the storage apparatus connected to the first computer; and
a second computer that is connected to the first computer and the storage apparatus, the second computer issuing to the storage apparatus a command for commanding the storage apparatus to pre-fetch data in the database before the database management program accesses the data so that the storage apparatus receiving this command provides the pre-fetched data to the first computer,
wherein the second computer includes:
a first circuit that commands, when the first computer accesses the data in the database, the storage apparatus to pre-fetch the data stored in the database based on information about the access; and
a second circuit that judges, when the pre-fetch is commanded, whether or not the pre-fetch will be effective, and issues the command for the pre-fetch to the storage apparatus when the pre-fetch will be effective.

### Claim 5 (depends on 4)

The computer system according to claim 4, wherein:
the second circuit predicts a first required time—the time required until the pre-fetch of the pre-fetch target data is completed, and a second required time—the time required until the database management program accesses the pre-fetch target data; and
the second circuit compares the first required time and the second required time to judge the effectiveness of the pre-fetch.

### Claim 6 (depends on 5)

The computer system according to claim 5, wherein if the second circuit determines that the first required time is greater than the second required time, the second computer does not issue the command for the pre-fetch to the storage apparatus.

### Claim 7 (depends on 5)

The computer system according to claim 5, wherein the second circuit uses, for predicting the second required time required until the database management program accesses pre-fetch target data, the following information:
information about the history of access from the database management program to the database;
information about the current status of the pre-fetch target data; and
information about the required time until the pre-fetch is completed.

### Claim 8 (depends on 5)

The computer system according to claim 5, wherein the second circuit uses, for predicting the first required time required until the pre-fetch of the pre-fetch target data is completed, the following information:
information about the status of the pre-fetch target data; and
information about the required time required until the pre-fetch is completed.

### Claim 9 (depends on 4)

The computer system according to claim 4, wherein:
the first circuit commands, when the pre-fetch target data is identified, the pre-fetch in a reverse order of an order of access by the database management program; and
the second circuit judges the effect of the pre-fetch based on whether or not the database management program has accessed the pre-fetch target data.

### Claim 10

A database management method using a computer system that includes: a computer having a database management program; and a storage apparatus having a database that can be accessed by the database management program, the method comprising:
a first step of issuing to the storage apparatus a command for commanding the storage apparatus to pre-fetch target data from the database before the database management program accesses the target data in the database; and
a second step of judging the effectiveness of the command and providing the command to the storage apparatus if the judgment is positive.
