Abstract: A disk rotation control part for controlling the rotations of a plurality of disk devices is provided. The configuration is such that a disk of a disk device for which an access will not be generated is rotated at a second rate of speed, which is faster than 0, and slower than a first rate of speed, which is the rotation speed at access time. DB management information comprises information denoting which DB schema inside a DB is stored in which location. The disk rotation control part, based on a query plan of a query received by the DBMS, and DB management information, specifies the storage location of a DB schema to be accessed when this query is processed, and rotates a disk of the disk device comprising the specified storage location at a first rate of speed.

Abstract: A database (DB) server in which a database management system (DBMS) operates and a prefetch server connected to a storage device storing DB data are provided with an acquiring unit for acquiring information on a storage location on the storage device of a DB schema managed by the DBMS, information on DB processing executed by the DBMS, and information on an access to DB data made when the DBMS executes the DB processing, from the DB server, a predictor for predicting data to be read out on the basis of the acquired information, and a prefetch instructing unit for providing the storage device with an instruction to prefetch the corresponding data. Having received the prefetch instruction, the storage device reads out specified data onto a cache memory.

Abstract: In the present invention, there is provided means which sets priorities of DB data for each management unit, means which copies data from a primary site to a secondary site in an order of the data priorities, and means which, when a disaster has occurred in the primary site and recovery of a DB is performed in the secondary site, performs recovery of data in the order of the data priorities to sequentially bring the data to a usable state.

Abstract: A database system includes a center server and local servers. The center server includes a replication requesting unit, a data consolidating unit including a center DB freeze requesting unit and a center DB freeze release requesting unit, a replication source managing table and a data consolidation completion notifying unit. Each of the local servers includes a local DB freeze requesting unit, a remote volume split requesting unit, a remote volume split completion notifying unit and a local DB freeze release requesting unit. The center server permits replications of local DB's in local storage subsystems to be created in the center storage subsystem and accesses shadow images of the replications to give a consolidated access to the plurality of local DB's.

Abstract: A data conversion job used for data conversion is separated into a data conversion server job for executing conversion processing on a data conversion server and a storage job for instructing a copy of a table on a storage device. Then, the storage job is executed to instruct the storage device to copy the table. The data conversion server job is executed only for fields that need to be converted, and thereby data conversion is performed for the copied table. This makes it possible to reduce a load of the data conversion server when converting data of a database, and also to enable a designer of a data conversion job to easily design the data conversion job.

Abstract: A database system includes a center server and local servers. The center server includes a replication requesting unit, a data consolidating unit including a center DB freeze requesting unit and a center DB freeze release requesting unit, a replication source managing table and a data consolidation completion notifying unit. Each of the local servers includes a local DB freeze requesting unit, a remote volume split requesting unit, a remote volume split completion notifying unit and a local DB freeze release requesting unit. The center server permits replications of local DB's in local storage subsystems to be created in the center storage subsystem and accesses shadow images of the replications to give a consolidated access to the plurality of local DB's.

Abstract: In a system in which a DB is built in a virtualization environment, a management server obtains DB processing information such as a DB processing execution plan and a degree of processing priority from a DBMS, predicts data to be accessed in the near future and the order of such accesses based on the information, instructs to read into caches of storage devices data to be accessed in the near future based on the prediction results, and reads the data that will be accessed in the nearest future into a cache memory within the management server.

Abstract: There is a strong demand for facilitation of management of storage region for DB data is required in a computer system combining an apparatus having the DBMS and virtualization function and software. In order to realize such requirement, the requirements for system management regarding a newly created DB and the information about the function to be set for the DB data are given to a system management server. The system management server detects a data structure of DB from such information and sends independently instructions to virtualization apparatuses to create virtual volumes or the like to which the data of each data structure is stored separately and set the function to the virtual volume as required. Thereafter, the system management server also issues an instruction to the DBMS to create a DB to store the data of data structure to the corresponding virtual volume.

Abstract: In a computer system with a DBMS running thereon, management of the performance of a storage apparatus is executed by using a performance indicator provided by a user job so as to simplify the management of the performance. For this reason, a management server employed in the computer system monitors an operating state of each system element, a response time onto a job and other information. A method for estimating a processing time is given to the management server, which issues a setting modification command based on an estimated processing time.

Abstract: In a system in which a DB is built in a virtualization environment, a management server obtains DB processing information such as a DB processing execution plan and a degree of processing priority from a DBMS, predicts data to be accessed in the near future and the order of such accesses based on the information, instructs to read into caches of storage devices data to be accessed in the near future based on the prediction results, and reads the data that will be accessed in the nearest future into a cache memory within the management server.

Abstract: In a computer system with a DBMS running thereon, management of the performance of a storage apparatus is executed by using a performance indicator provided by a user job so as to simplify the management of the performance. For this reason, a management server employed in the computer system monitors an operating state of each system element, a response time onto a job and other information. A method for estimating a processing time is given to the management server, which issues a setting modification command based on an estimated processing time.

Abstract: A prefetching program preliminarily executes acquisition of SQL statements which are executed repeatedly and an analysis of a content of such processing so as to grasp data to be fetched in advance. Immediately before executing the processing, starting of the processing is notified to the prefetching program. Based on a preliminary analysis result and a given cache amount, the prefetching program issues a setting of the cache amount and an instruction of a data prefetching method to a DBMS and a storage device. The prefetching program receives a report on completion of the processing and, thereafter, issues a request for releasing a cache allocated for the processing to the DBNS and other storage devices.

Abstract: In the present invention, a management server manages, as virtual data areas, the physical data areas that storage devices have. Moreover, the management server includes a unit. Based on an access request received from each server, the unit issues, to the corresponding storage devices, an instruction of reading out the data onto caches from disks. Also, each storage device, which has received the instruction, includes each unit for reading out the data onto each cache in accordance with the instruction.

Abstract: A database (DB) server in which a database management system (DBMS) operates and a prefetch server connected to a storage device storing DB data are provided with an acquiring unit for acquiring information on a storage location on the storage device of a DB schema managed by the DBMS, information on DB processing executed by the DBMS, and information on an access to DB data made when the DBMS executes the DB processing, from the DB server, a predictor for predicting data to be read out on the basis of the acquired information, and a prefetch instructing unit for providing the storage device with an instruction to prefetch the corresponding data. Having received the prefetch instruction, the storage device reads out specified data onto a cache memory.

Abstract: In the present invention, there is provided means which sets priorities of DB data for each management unit, means which copies data from a primary site to a secondary site in an order of the data priorities, and means which, when a disaster has occurred in the primary site and recovery of a DB is performed in the secondary site, performs recovery of data in the order of the data priorities to sequentially bring the data to a usable state.

Abstract: Even when an assignment request of storage areas exceeding unassigned areas is issued from a server, storage areas can be assigned to the server, so that storage areas in a storage pool can be utilized effectively. A management server connected to a plurality of servers and storage apparatuses to manage physical storage areas of the storage apparatuses used by the plurality of servers as virtual areas (storage pool) is responsive to an area assignment instruction of storage areas exceeding unassigned areas received from a server to release at least part of assignment areas of other servers to be assigned to the server which issued the area assignment instruction.

Abstract: In a computer system with a DBMS running thereon, management of the performance of a storage apparatus is executed by using a performance indicator provided by a user job so as to simplify the management of the performance. For this reason, a management server employed in the computer system monitors an operating state of each system element, a response time onto a job and other information. Pre-given information on a process such as a performance requirement the collected monitored information are used by the management server in issuing a command to change allocation of a processing amount to a port, an allocation of a cache area for data, the logical configuration of disc drives and other parameters in order to carry out the new process or in the case where a result of a judgment based on the monitored information indicates that tuning is necessary.

Abstract: A prefetching program preliminarily executes acquisition of SQL statements which are executed repeatedly and an analysis of a content of such processing so as to grasp data to be fetched in advance. Immediately before executing the processing, starting of the processing is notified to the prefetching program. Based on a preliminary analysis result and a given cache amount, the prefetching program issues a setting of the cache amount and an instruction of a data prefetching method to a DBMS and a storage device. The prefetching program receives a report on completion of the processing and, thereafter, issues a request for releasing a cache allocated for the processing to the DBNS and other storage devices.

Abstract: A data conversion job used for data conversion is separated into a data conversion server job for executing conversion processing on a data conversion server and a storage job for instructing a copy of a table on a storage device. Then, the storage job is executed to instruct the storage device to copy the table. The data conversion server job is executed only for fields that need to be converted, and thereby data conversion is performed for the copied table.

Abstract: In a system in which a DB is built in a virtualization environment, a management server obtains DB processing information such as a DB processing execution plan and a degree of processing priority from a DBMS, predicts data to be accessed in the near future and the order of such accesses based on the information, instructs to read into caches of storage devices data to be accessed in the near future based on the prediction results, and reads the data that will be accessed in the nearest future into a cache memory within the management server.