Invention Grant
US07693816B2 Computer system, computer, data access method and database system
有权
计算机系统,计算机,数据访问方法和数据库系统
- Patent Title: Computer system, computer, data access method and database system
- Patent Title (中): 计算机系统,计算机,数据访问方法和数据库系统
-
Application No.: US11048290Application Date: 2005-01-31
-
Publication No.: US07693816B2Publication Date: 2010-04-06
- Inventor: Kaokazu Nemoto , Norifumi Nishikawa , Kazuhiko Mogi
- Applicant: Kaokazu Nemoto , Norifumi Nishikawa , Kazuhiko Mogi
- Applicant Address: JP Tokyo
- Assignee: Hitachi, Ltd.
- Current Assignee: Hitachi, Ltd.
- Current Assignee Address: JP Tokyo
- Agency: Townsend and Townsend and Crew LLP
- Priority: JPP2004-318471 20041101
- Main IPC: G06F7/00
- IPC: G06F7/00 ; G06F17/00

Abstract:
There is a program for transmitting a prefetch command to a database management system (DBMS) so that access data of the DBMS can be prefetched to a storage. The DBMS is able to generate an access plan conscious of prefetch and to access database (DB). The DBMS is, however, unable to recognize that a prefetch command program is halted and it cannot generate an access plan at a proper I/O cost. Database management system servers 1, 2, . . . monitor a prefetch program of a management server 5, understands that the prefetch program is halted and it can optimize an execution plan to access storage apparatus 3, 4, . . . by using an I/O cost changed when the prefetch program is halted.
Public/Granted literature
- US20060106759A1 Computer system, computer, data access method and database system Public/Granted day:2006-05-18
Information query