Computer system, method for conserving power, and computer

A computer system, comprising:

• a database server configured to execute a database management system;
• and
• a storage apparatus, which is connected to the database server via a network, and is configured to store data managed by the database management system,
• the database server comprising:
• an interface connected to the network;
• a plurality of arithmetic devices connected to the interface;
• and
• a main memory device connected to the plurality of arithmetic devices,
• the main memory device being configured to store the database management system,
• the database management system being configured to have an arithmetic device power saving function for switching between a sleep mode for reducing power consumption of the plurality of arithmetic devices and an active mode for enabling processing of the data,
• the storage apparatus comprising:
• a storage unit configured to store data managed by the database management system;
• and
• a control unit configured to control read and write of the data stored in the storage unit,
• the storage unit being configured to have a volume to be created and provided to the database server as a storage area for reading and writing the data,
• the main memory device being configured to hold power consumption information on the volume created in the storage unit,
• the database management system being configured to be executed by the plurality of arithmetic devices, to thereby:
• receive a query for reading or writing data stored in the storage apparatus;
• analyze the received query to create one or more execution plans;
• identify a volume for reading and writing data based on the created one or more execution plans;
• calculate power consumption for each of the created one or more execution plans based on power consumption information on the identified volume;
• select an execution plan for which the calculated power consumption satisfies a predetermined threshold value from the created one or more execution plans;
• execute processing for instructing the control unit to read or write data based on the selected execution plan;
• select one arithmetic device from the plurality of arithmetic devices and allocate processing being executed by the selected one arithmetic device to another arithmetic device that is different from the selected one arithmetic device;
• and
• transfer, when processing is not executed by the selected one arithmetic device, a mode of the selected one arithmetic device from the active mode to the sleep mode.

A computer system, comprising:

• a database server configured to execute a database management system;
• and
• a storage apparatus, which is connected to the database server via a network, and is configured to store data managed by the database management system,
• the database server comprising:
• an interface connected to the network;
• an arithmetic device connected to the interface;
• and
• a plurality of main memory devices connected to the arithmetic device,
• the plurality of main memory devices being configured to store the database management system,
• the database management system being configured to have a main memory device power saving function for switching between a sleep mode for reducing power consumption of the plurality of main memory devices and an active mode for enabling storage of the data,
• the storage apparatus comprising:
• a storage unit configured to store data managed by the database management system;
• and
• a control unit configured to control read and write of the data stored in the storage unit,
• the storage unit being configured to have a volume to be created and provided to the database server as a storage area for reading and writing the data,
• the plurality of main memory devices being configured to hold power consumption information on the volume created in the storage unit,
• the database management system being configured to be executed by the arithmetic device, to thereby:
• receive a query for reading or writing data stored in the storage apparatus;
• analyze the received query to create one or more execution plans;
• identify a volume for reading and writing data based on the created one or more execution plans;
• calculate power consumption for each of the created one or more execution plans based on power consumption information on the identified volume;
• select an execution plan for which the calculated power consumption satisfies a predetermined threshold value from the created one or more execution plans;
• execute processing for instructing the control unit to read or write data based on the selected execution plan;
• select one main memory device from the plurality of main memory devices and allocate data stored in the selected one main memory device to another main memory device that is different from the selected one main memory device;
• and
• transfer, when data is not stored in the selected one main memory device, a mode of the selected one main memory device from the active mode to the sleep mode.

A computer system, comprising:

• a database server configured to execute a database management system;
• and
• a storage apparatus, which is connected to the database server via a network, and is configured to store data managed by the database management system,
• the database server comprising:
• an interface connected to the network;
• an arithmetic device connected to the interface;
• and
• a main memory device connected to the arithmetic device,
• the main memory device being configured to store the database management system,
• the storage apparatus comprising:
• a storage unit configured to store data managed by the database management system;
• and
• a control unit configured to control read and write of the data stored in the storage unit,
• the control unit being configured to have a storage power saving function for switching between a sleep mode for reducing power consumption of the storage apparatus and an active mode for enabling read and write of the data,
• the storage unit being configured to have a plurality of volumes to be created and provided to the database server as a storage area for reading and writing the data,
• the main memory device being configured to hold power consumption information on the plurality of volumes created in the storage unit,
• the database management system being configured to be executed by the arithmetic device, to thereby:
• receive a query for reading or writing data stored in the storage apparatus;
• analyze the received query to create an execution plan;
• instruct the control unit to read or write data based on the created execution plan;
• read, when a query for reading data stored in the plurality of volumes in a distributed manner is received, data from the plurality of volumes storing the data to be read, without reading the data from a part of the plurality of volumes;
• and
• transfer a mode of the unread part of the plurality of volumes from the active mode to the sleep mode.

A power saving method for a computer system,

• the computer system comprising:
• a database server configured to execute a database management system;
• and
• a storage apparatus, which is connected to the database server via a network, and is configured to store data managed by the database management system,
• the database server comprising:
• an interface connected to the network;
• an arithmetic device connected to the interface;
• and
• a main memory device connected to the arithmetic device,
• the main memory device being configured to store the database management system,
• the storage apparatus comprising:
• a storage unit configured to store data managed by the database management system;
• and
• a control unit configured to control read and write of the data stored in the storage unit,
• the control unit being configured to have a power saving function for switching between a sleep mode for reducing power consumption of the storage apparatus and an active mode for enabling read and write of the data,
• the storage unit being configured to have a volume to be created and provided to the database server as a storage area for reading and writing the data,
• the main memory device being configured to hold power consumption information on the volume created in the storage unit,
• the power saving method, which is executed by the arithmetic device, comprising:
• receiving a query for reading or writing data stored in the storage apparatus;
• analyzing the received query to create one or more execution plans;
• identifying a volume for reading and writing data based on the created one or more execution plans;
• calculating power consumption for each of the created one or more execution plans based on power consumption information on the identified volume;
• selecting an execution plan for which the calculated power consumption satisfies a predetermined threshold value from the created one or more execution plans;
• and
• instructing the control unit to read or write data based on the selected execution plan.

A computer, which is connected to a storage apparatus configured to store data, and is configured to execute a database management system configured to manage the data, the computer comprising:

• an interface connected to the storage apparatus;
• an arithmetic device connected to the interface;
• and
• a main memory device connected to the arithmetic device,
• the main memory device being configured to store the database management system,
• the storage apparatus being configured to have a power saving function for switching between a sleep mode for reducing power consumption and an active mode for enabling read and write of the data,
• the storage apparatus being configured to provide a volume, which is a storage area for reading and writing the data,
• the main memory device being configured to hold power consumption information on the volume provided by the storage apparatus,
• the arithmetic device being configured to:
• receive a query for reading or writing data stored in the storage apparatus;
• analyze the received query to create one or more execution plans;
• identify a volume for reading and writing data based on the created one or more execution plans;
• calculate power consumption for each of the created one or more execution plans based on power consumption information on the identified volume;
• select an execution plan for which the calculated power consumption satisfies a predetermined threshold value from the created one or more execution plans;
• and
• instruct the storage apparatus to read or write data based on the selected execution plan.