International Business Machines Corporation

Valerio Bellizia

Stefano Sidoti

Nicola Milanese

Jeffrey Owen Kephart

Bernardo Pastorelli

Diana Joyce Hellman

Wayne B Riley

Josephine F Bayang

James K MacKenzie

Stephen Viselli

Michael Gaertner

Dillon H Ginley

Attila Kollar

Srinivasarao Siddabattini

Luigi Pichetti

Marco Secchi

A method, system, apparatus, and a computer program product are provided for optimizing database query plans generated from a received database query at a database management system by monitoring a global cost estimation function for one or more steps of the received database query to identify a first low-performing cost metric and collaboratively optimizing a query plan for the database query by comparing differences between the first low-performing cost metric and a second cost metric at an additional database management system, thereby generating an optimized query plan for the database management system that may be stored at the database management system along with corresponding information identifying a reason for rewriting the optimized query plan.

Method and system for collaborative and dynamic query optimization in a DBMS network

A method is provided for managing memory allocation in a database. The method determines a preferred statement among defined statements with defined sizes of objects. The defined statements include (i) a stored statement defined to allocate the objects and stored in the database wherein each of the objects have a stored size, and (ii) alternative stored statements that provide an alternative of the stored statement defined to allocate the objects with alternative sizes lower than stored sizes. The preferred statement has defined sizes compliant to actual sizes according to preference criterion. The method invokes the preferred statement for execution in place of the stored statement when different. The method stores a new statement, having new sizes compliant to actual sizes according to alternate criterion, responsive to unfulfilling a condition based on comparing defined sizes of the preferred statement with actual sizes.

Dynamic management of memory allocation in a database

An embodiment of the invention includes a database server system comprising a storage arrangement for storing at least one database and at least one processor operable for receiving a database request over a computer network and accessing the storage arrangement. The processor is further operable for carrying out a monitoring task. The monitoring task determines whether a monitoring description has been stored into the database by the database request. Furthermore, the monitoring task performs a monitoring operation which is specified in the monitoring description. The monitoring operation yields at least one result value. The monitoring task submits a monitoring result request in order to insert the at least one result value into the database. The invention also relates to a computer program product and to a method for performing a monitoring operation on a database server system.

Database server system monitoring

A method is provided for managing memory allocation in a database. The method determines a preferred statement among defined statements with defined sizes of objects. The defined statements include (i) a stored statement defined to allocate the objects and stored in the database wherein each of the objects have a stored size, and (ii) alternative stored statements that provide an alternative implementation of the stored statement defined to allocate the objects with alternative sizes lower than stored sizes. The preferred statement has defined sizes compliant to actual sizes according to preference criterion based on comparing defined and actual sizes. The method invokes the preferred statement for execution in place of the stored statement when different. The method stores a new statement, having new sizes compliant to actual sizes according to alternate criterion, responsive to unfullfilling a condition based on comparing defined sizes of the preferred statement with actual sizes.

A solution for managing a computing system comprising a plurality of client computing machines to be managed and at least one server computing machine for controlling the managing of the client computing machines, wherein each client computing machine has at least one of a plurality of roles in a deployment infrastructure for deploying management data from said at least one server computing machine to the client computing machines. A corresponding method comprises monitoring one or more operative parameters of each client computing machine against one or more reference policies, detecting a non-compliance of the operative parameters to the reference policies, and changing the role of at least one of the client computing machines in response to the non-compliance of the operative parameters to the reference policies for restoring a compliance thereto.

Management of a computing system with dynamic change of roles

Power usage is estimated in a computing environment by automatically detecting hardware configuration information by use of a software agent that is translated into power consumption information for implementing a plurality of power estimation models for efficient power consumption and utilization.

Estimating power usage in a computing environment

A method for managing memory allocation in a database receives an invocation of a stored statement defined to allocate objects, each with a stored size. The method determines an actual size relating to the invocation and determines a preferred statement among defined statements with defined object sizes. The defined statements include the stored statement and alternative stored statements that provide an alternative implementation of the stored statement defined to allocate the objects with alternative sizes lower than stored sizes. The preferred statement has defined sizes compliant to actual sizes according to preference criterion based on comparing defined and actual sizes. The method invokes the preferred statement for execution in place of the stored statement when different. The method stores a new statement, having new sizes compliant to actual sizes according to alternate criterion, responsive to unfullfilling a condition based on comparing defined sizes of the preferred statement with actual sizes.

Growing community of inventors

Carpineto Romano, Italy

Valerio Bellizia