Back to results
US 2008/0301151 A1Published application
Computer system and database management method using the same
AssigneeHitachi, Ltd.
InventorsHideomi Idei, Kazuhiko Mogi, Norifumi Nishikawa
Life of this patent
Estimating the term…
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.
Claims10
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.
2 more elements
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.
5 more elements
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.
2 more elements
Dependencies are inferred from the claim text.