Method and apparatus for optimizing queries in a logically partitioned computer system
View Patent ↗A database query optimizer for a computer system having dynamically configurable logical partitions generates an optimized query strategy which is dependent on a logical partition configuration. When the query is executed, the configuration of the logical partition in which the query is executed is compared to the logical partition configuration for which the query was optimized. If the configurations are different, a new query can be automatically generated. Optimizing database queries to the current system configuration of a dynamic, logically partitioned system potentially offers greater efficiency in the execution of database queries for complex, logically partitioned systems.
1. A computer system, comprising:
a plurality of central processing units;
a memory;
a logical partitioning mechanism supporting a plurality of defined logical partitions of said computer system, each logical partition having a respective processor resource assignment, wherein each task executing in said computer system is assigned to a respective one of said logical partitions and restricted to using only the processor resources which are allocated to the respective logical partition by its respective processor resource assignment, and wherein the definition of said logical partitions are dynamically altered;
a database;
a database management system for managing said database, wherein said database management system:
(a) performs query optimization of a database query for said database to produce a first search strategy, said first search strategy being dependent on a first processor resource assignment;
(b) responsive to invoking said first query search strategy for execution, compares said first processor resource assignment with a second processor resource assignment associated with a logical partition of execution at the time said first search strategy is invoked for execution; and
(c) depending on the results of said comparison performed in (b), automatically constructs a second search strategy dependent on said second processor resource assignment;
wherein said first processor resource assignment is the processor resource assignment for a logical partition with which said database query is associated at the time said database management system performs query optimization of said database query for said database to produce said first search strategy, said database management system automatically determining said processor resource assignment for said logical partition with which said database query is associated, wherein said respective processor resource assignment of each partition comprises a respective number of virtual processors of each partition, said respective number being an integer, and wherein said logical partitioning mechanism supports the definition of at least one set of processors which is shared by a set of said logical partitions, said set of said logical partitions containing at least two partitions, said respective processor resource assignment of each partition of said set of partitions including said set of processors.
2. The computer system of claim 1 , wherein said database management system saves said first search strategy in a persistent object for later execution, said persistent object including said first processor resource assignment.