Resource allocation method for a physical computer used by a back end server including calculating database resource cost based on SQL process type

• US 8,209,697 B2
• Filed: 01/30/2008
• Issued: 06/26/2012
• Est. Priority Date: 07/03/2007
• Status: Expired due to Fees

• Current Assignee: Hitachi, Ltd.
• Original Assignee: Hitachi, Ltd.
• Inventors: Narita, Masaaki, Ito, Akira, Ooshima, Sansei, Hara, Norihiro, Kobayashi, Kazuhito
• Primary Examiner(s): HUISMAN, DAVID J
• Application Number:
  US12/022,547
• Publication Number:
  US 20090013325A1
• Time in Patent Office: 1,609 Days
• Field of Search: None
• US Class Current: 718/104
• CPC Class Codes: G06F 16/24532 of parallel queries
• CPC Class Codes: G06F 9/5077 Logical partitioning of resources; Management or configuration of virtualized resources specific details on emulation or internal functioning of virtual machines G06F9/455

Abstract

A resource allocation method, a resource allocation program, and a resource allocation apparatus in which a request reception server subjects an inputted SQL to a syntax analysis. At least one SQL process is extracted from the input SQL, and a resource cost of a database required by a BES (Back End Server) to perform the SQL process for each of one or more process types contained in the SQL process is calculated. Further, an allocation ratio is determined for allocating the resource of a request executing server to a virtualized server in accordance with a resource cost ratio required by each of the BES to execute the SQL process. Additionally, requests are made for execution of the respective BES on the virtualized server to which the resource has been allocated so as to execute the SQL process.

Claims

1. A resource allocation method for a physical computer used by a Back End Server (BES) executed in a virtual computer operating on resources of the physical computer when processing an inputted Structured Query Language (SQL) request based on a database stored in an accessible storage device, wherein an access to the database to be subjected to SQL processes is of a shared everything type architecture in which the BES can process the database, the method comprising steps of:

subjecting the inputted SQL request to a syntax analysis and extracting a plurality of SQL processes from the inputted SQL request,

calculating, for each of one or more process types contained in the extracted SQL processes and one or more BESs, a resource cost of a database required by the one or more BESs to perform the extracted SQL processes for which an executing BES of the one or more BESs is determined,

deciding an allocation ratio for allocating the resources of the physical computer to the virtual computer in accordance with a resource cost ratio of each of the one or more BESs required to execute the extracted SQL processes,

selecting one of the one or more BESs which has a highest allocation ratio in the decided allocation ratios as an executing BES for the extracted SQL processes for which an executing BES of the one or more BESs is not determined, and

requesting for execution of the selected one of the one or more BESs on the virtual computer to which the resources have been allocated so as to execute the extracted SQL processes,

wherein if the process type of the extracted SQL processes is a condition judgment, the step of calculating the resource cost of the database required by the one or more BESs includes multiplying the number of database cases to be subjected to the extracted SQL processes by a hit rate corresponding to the type of a predicate contained in an SQL command of the extracted SQL processes corresponding to the condition judgment, and by a predetermined coefficient.

2. The resource allocation method as claimed in claim 1, wherein the step of calculating the resource cost of the database required by the one or more BESs is followed by a step of calculating a resource cost of each of the virtual computer and other virtual computers executing the one or more BESs connected to the database required by the one or more BESs in accordance with the resource cost of the database required by the one or more BESs.

3. The resource allocation method as claimed in claim 1, wherein if the process type of the extracted SQL processes is a scan, the step of calculating the resource cost of the database required by the one or more BESs includes multiplying the number of database cases to be subjected to the extracted SQL processes by a predetermined coefficient.

4. The resource allocation method as claimed in claim 1, wherein if the process type of the extracted SQL processes is a join, the step of calculating the resource cost of the database required by the one or more BESs includes multiplying the number of database cases to be subjected to the extracted SQL processes by a predetermined coefficient.

5. The resource allocation method as claimed in claim 1, wherein the resources of the physical computer allocated to the virtual computer is includes a central processing unit (CPU) of the physical computer.

6. The resource allocation method as claimed in claim 1, wherein the resources of the physical computer allocated to the virtual computer is are memory resources of the physical computer.