Database management system for controlling power consumption of storage system

• US 8,001,163 B2
• Filed: 01/11/2008
• Issued: 08/16/2011
• Est. Priority Date: 06/01/2007
• Status: Expired due to Fees

• Current Assignee: Hitachi, Ltd.
• Original Assignee: Hitachi, Ltd.
• Inventors: Kawamura, Nobuo
• Primary Examiner(s): Corrielus; Jean M
• Application Number:
  US12/007,546
• Publication Number:
  US 20080172424A1
• Time in Patent Office: 1,313 Days
• Field of Search: 707/661, 707/741, 707/769, 707/812, 707/827, 711/161
• US Class Current: 707/812
• 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 coupled to a storage system, wherein the storage system includes

a plurality of storage devices,

a power control module that performs power control of the plurality of storage devices, and

an interface module that receives a power conservation instruction from the computer and transfers the power conservation instruction to the power control module, wherein the database management system comprises:

an access module that performs access of data stored in a first type storage device among the plurality of storage devices and detects a fault relating to the access;

a storage device specifying module that specifies a second type storage device, among the plurality of storage devices, that stores a backup corresponding to the data that are stored in the first type storage device when the access module detects a fault relating to the access of the data; 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 to the interface module of the storage system.

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 the power conservation of another logical storage device that exists in the RAID group in which the backup DB logical storage device exists cannot be canceled.

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 a 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 the power conservation of another logical storage device that exists in the RAID group in which the backup DB logical storage device exists cannot be canceled.

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. The database management system of claim 1, wherein when the access module detects a fault relating to the access of the data, the access module performs fault closure processing for a storage area for which the fault was produced.

13. A computer system, comprising:

a storage system comprising a plurality of storage devices, a power control module, and an interface module; and

a computer comprising a database management system, wherein the computer comprises;

an access module that performs access of data stored in a first type storage device among the plurality of storage devices and detects a fault relating to the access;

a storage device specifying module that specifies a second type storage device, among the plurality of storage devices, that stores a backup corresponding to data that are stored in the first type storage device when the access module detects a fault relating to the access of the data; 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 to the interface module of the storage system, and

wherein;

the interface module receives the power conservation cancellation instruction and transfers the power conservation cancellation instruction to the power control module; and

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

14. The computer system according to claim 13, 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.

15. A computer that executes a database management system coupled to a storage system, wherein the storage system includes

a plurality of storage devices,

a power control module that performs power control of the plurality of storage devices and

an interface module that receives a power conservation instruction and transfers the power conservation instruction to the power control module, the computer comprising:

an access module that performs access of data stored in a first type storage device among the plurality of storage devices and detects a fault relating to the access;

a storage device specifying module that specifies a second type storage device, among the plurality of storage devices, that stores a backup corresponding to data that are stored in the first type storage device when the access module detects a fault relating to the access of the data; 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 to the interface module of the storage system.

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

a storage system having a plurality of storage devices, a power control module and an interface module; and

a computer having a database management system,

the method comprising;

a step in which the database management system performs access of data stored in a first type storage device among the plurality of storage devices and, when a fault relating to the access is detected, specifies a second type storage device among the plurality of storage devices that stores a backup corresponding to 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;

a step in which the interface module of the storage system receives the power conservation cancellation instruction from the computer and transfers the power conservation cancellation instruction to the power control module of the storage system;

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