Abstract: 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.

Abstract: Disclosed is a method and system for managing execution of processes on a cluster of processing devices by a supervising device. The method comprises receiving memory consumption information from each of a processing devices executing a plurality of processes. The method further comprises receiving information related to swapping of a new process from at least one processing device of the processing devices while memory available on the at least one processing device is insufficient to execute the new process. The method further comprises terminating either the new process being swapped or a process executing on the at least one processing device. The method further comprises instructing another processing device having sufficient memory available for execution of the new process being swapped or the process executing on the at least one processing device, whichever is terminated on the at least one processing device.

Abstract: 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.

Abstract: Disclosed is a method and system for managing execution of processes on a cluster of processing devices by a supervising device. The method comprises receiving memory consumption information from each of a processing devices executing a plurality of processes. The method further comprises receiving information related to swapping of a new process from at least one processing device of the processing devices while memory available on the at least one processing device is insufficient to execute the new process. The method further comprises terminating either the new process being swapped or a process executing on the at least one processing device. The method further comprises instructing another processing device having sufficient memory available for execution of the new process being swapped or the process executing on the at least one processing device, whichever is terminated on the at least one processing device.

Abstract: 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.

Abstract: 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.

Abstract: 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.

Abstract: 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.

Abstract: 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.

Abstract: 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.

Abstract: 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.

Abstract: 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.

Abstract: 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.

Abstract: 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.

Abstract: 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.

Abstract: 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.

Abstract: 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 unfulfilling a condition based on comparing defined sizes of the preferred statement with actual sizes.

Abstract: 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.

Abstract: 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.

Abstract: Embodiments of the present invention disclose a computer implemented method, computer program product, and system for determining rules for partitioning internet connection bandwidth. In one embodiment, in accordance with the present invention, the computer implemented method includes the steps of identifying static bandwidth partitioning policies that correspond to a cluster of users, wherein the static bandwidth partitioning policies are based on time schedules, quality of service requirements, an amount of internet connection bandwidth paid for by a user, and proportional quotas of internet connection bandwidth, identifying historical bandwidth usage data corresponding to the cluster of users, and determining bandwidth partitioning rules for the cluster of users based on the identified static bandwidth partitioning policies and identified historical bandwidth usage data.