摘要:
A management system manages a plurality of data units constituting schemas of a database in a storage device, which includes a plurality of first storage device sets having a plurality of storage areas. An ordered schema constituted of the plurality of data units having order properties defining respective orders is included in the schemas. When a second storage device set, which is a set of one or more second storage devices and in which each of the storage areas is a free storage area, is added to the first storage device set, the management system migrates two or more data units not consecutive in the order among a plurality of data units stored in the plurality of storage areas in the first storage device set respectively from at least the one first storage device set to the free storage areas of the second storage device set.
摘要:
A management system manages a plurality of data units constituting schemas of a database in a storage device, which includes a plurality of first storage device sets having a plurality of storage areas. An ordered schema constituted of the plurality of data units having order properties defining respective orders is included in the schemas. When a second storage device set, which is a set of one or more second storage devices and in which each of the storage areas is a free storage area, is added to the first storage device set, the management system migrates two or more data units not consecutive in the order among a plurality of data units stored in the plurality of storage areas in the first storage device set respectively from at least the one first storage device set to the free storage areas of the second storage device set.
摘要:
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.
摘要:
Provided is a computer system including: a computer running as a DB server; a storage system including a plurality of disk drives for storing data; and a management module, in which: at least one of the plurality of disk drives stores data of a DB schema written by the computer; the management module specifies the DB schema to be accessed based on a received query, transmits, to the storage system, an instruction to copy at least a portion of the data of the specified DB schema from the disk drive to a memory, and transmits, to the storage system, an instruction to control an rpm of the disk drive that stores the data of the specified DB schema; and the storage system controls the rpm of the disk drive based on the instruction. Accordingly, power consumption of the storage system can be reduced even if installed disks increase in number.
摘要:
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.
摘要:
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.
摘要:
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.
摘要:
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.
摘要:
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.
摘要:
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.