Database management system for controlling power consumption of storage system

• US 20080172424A1
• Filed: 01/11/2008
• Published: 07/17/2008
• Est. Priority Date: 06/01/2007
• Status: Active Grant

• Current Assignee: Hitachi, Ltd.
• Original Assignee: Hitachi, Ltd.
• Inventors: Kawamura, Nobuo
• Granted Patent: US 8,001,163 B2
• Time in Patent Office: Days
• US Class Current: 707/204
• CPC Class Codes: G06F 3/0625 Power saving in storage systems
• CPC Class Codes: G06F 3/0634 by changing the state or mode of one or more devices
• CPC Class Codes: G06F 3/065 Replication mechanisms
• CPC Class Codes: G06F 3/0689 Disk arrays, e.g. RAID, JBOD
• CPC Class Codes: Y02D 10/00 Energy efficient computing, e.g. low power processors, power management or thermal management

Abstract

When performing access relating to a first type storage device among a plurality of storage devices in the storage system, the database management system specifies a second type storage device that stores a backup of data that are stored in the first type storage device if an error relating to the access is detected and issues a power conservation cancellation instruction to cancel the power conservation of the second type storage device.

Claims

1. A database management system that runs on a computer connected to a storage system having a plurality of storage devices, comprising:

an access module that performs access relating to a first type storage device among the plurality of storage devices;

a storage device specifying module that specifies a second type storage device, among the plurality of storage devices, that stores a backup of data that are stored in the first type storage device in cases where an error relating to the access is detected; and

a power consumption control module that issues a power conservation cancellation instruction to cancel the power conservation for the specified second type storage device.

2. The database management system according to claim 1, wherein

the first type storage device includes a DB storage device for storing DB data which are elements constituting the database;

and

the second type storage device includes a backup DB storage device which is a backup destination for the DB data in the DB storage device.

3. The database management system according to claim 2,

wherein

the first type storage device further includes a log storage device that stores log data which represent a log relating to access to the database;

and

the second type storage device further includes an archive log storage device in which an archive of log data that are stored in the log storage device is stored.

4. The database management system according to claim 3,

wherein

a plurality of log storage devices are associated with log buffer provided in a storage resource in the computer,

the database management system further comprising:

a log swap module that executes swap processing that includes processing to swap a target log storage device which is an access destination for log data stored in the log buffer from a first log storage device to a second log storage device among the plurality of log storage devices and processing to write the log data stored in the first log storage device to the archive log storage device, and wherein

the access module is constituted to temporarily store the log data in the log buffer and store the log data which are stored in the log buffer in the target log storage device, and

the power consumption control module issues a power conservation cancellation instruction to cancel the power conservation of the second log storage device and the archive log storage device before the start of the swap processing.

5. The database management system according to claim 4, wherein, prior to the start of subsequent swap processing, the power consumption control module issues a power conservation cancellation instruction to cancel power conservation of the storage device which is the second type storage device in the subsequent swap processing following the current swap processing.

6. The database management system according to claim 2, further comprising a backup module that backs up data that are stored in the DB storage device to a backup DB storage device that is selected from the plurality of storage devices, wherein

the power consumption control module issues a power conservation cancellation instruction to cancel the power conservation of the backup DB storage device prior to the start of the backup of data from the DB storage device to the backup storage device and issues a power conservation instruction to conserve the power of the backup DB storage device after the backup is complete.

7. The database management system according to claim 6, wherein

the plurality of storage devices are each logical storage devices that are formed on a RAID group constituted by two or more physical storage devices;

and

the power consumption control module does not issue a power conservation instruction to the backup DB logical storage device if it is not possible to cancel the power conservation of another logical storage device that exists in the RAID group in which the backup DB logical storage device exists.

8. The database management system according to claim 2, further comprising a restore module that restores a database using data that are stored in a backup DB storage device that is selected from the plurality of storage devices, wherein

the power consumption control module issues a power conservation instruction to conserve the power of the backup DB storage device after a restore that utilizes the data stored in the backup DB storage device is complete.

9. The database management system according to claim 8, wherein the selected backup DB storage device in which the data read during the restore are stored is a backup DB storage device which constitutes the target of the power conservation cancellation due to a power conservation cancellation instruction that is issued by the power consumption control module.

10. The database management system according to claim 8, wherein

the plurality of storage devices are each logical storage devices that are formed on a RAID group constituted by two or more physical storage devices, and

the power consumption control module does not issue a power conservation instruction to the backup DB logical storage device if it is not possible to cancel the power conservation of another logical storage device that exists in the RAID group in which the backup DB logical storage device exists.

11. The database management system according to claim 1, wherein

the plurality of storage devices are each logical storage devices that are formed on a RAID group constituted by two or more physical storage devices, and

the first type storage device and second type storage device are not mixed as the two or more storage devices that exist in one RAID group.

12. A computer system, comprising:

a storage system comprising a plurality of storage devices; and

a computer comprising a database management system, wherein

the computer comprises;

an access module that performs access relating to a first type storage device among the plurality of storage devices;

a storage device specifying module that specifies a second type storage device, among the plurality of storage devices, that stores a backup of data that are stored in the first type storage device in cases where an error relating to the access is detected; and

a power consumption control module that issues a power conservation cancellation instruction for canceling the power conservation of the specified second type storage device, and

the storage system comprises;

an interface module that receives the power conservation cancellation instruction; and

a power control module that, in response to the power conservation cancellation instruction, cancels the power conservation of the second type storage device specified by the power conservation cancellation instruction.

13. The computer system according to claim 12, wherein

the plurality of storage devices are each logical storage devices that are formed on a RAID group constituted by two or more physical storage devices,

the power conservation cancellation instruction is designated by the logical storage device, and

the power control module cancels the power conservation of all of the physical storage devices pertaining to the logical storage devices designated by the power conservation cancellation instruction.

14. A computer that executes a database management system connected to a storage system having a plurality of storage devices, comprising:

an access module that performs access relating to a first type storage device among the plurality of storage devices;

a storage device specifying module that specifies a second type storage device, among the plurality of storage devices, that stores a backup of data that are stored in the first type storage device in cases where an error relating to the access is detected; and

a power consumption control module that issues a power conservation cancellation instruction to cancel the power conservation for the specified second type storage device.

15. A power control method that is executed by a computer system having:

a storage system having a plurality of storage devices; and

a computer having a database management system,

the method comprising;

a step in which the database management system performs access relating to a first type storage device among the plurality of storage devices and, when an error relating to the access is detected, specifies a second type storage device among the plurality of storage devices that stores a backup of the data that are stored in the first type storage device;

a step in which the computer issues a power conservation cancellation instruction to cancel the power conservation of the specified second type storage device; and

a step in which the storage system cancels the power conservation of the second type storage device specified by the power conservation cancellation instruction.