摘要:
Techniques are described for estimating and managing memory compression for query processing. Embodiments of the invention may generally include receiving a query to be executed, ascertaining indicatory data about the retrieved data, and selectively compressing a portion of the data in memory according to the indicatory data. In one embodiment, the amount of compression performed during each query execution is recorded and outputted to assist in adjusting the selective compression process.
摘要:
Methods, articles of manufacture, and systems for providing access to a grid computing environment. In one environment, requests include resource specific criteria used to identify a particular grid resource to perform the request. In another embodiment, a request includes a queue criterion used to identify one of a plurality of queues on which the request is placed.
摘要:
The present invention generally relates to data processing, and more specifically to executing queries against a partitioned database. One embodiment provides a computer-implemented method of managing execution of a query against a partitioned database having a plurality of data partitions. The method comprises receiving a query having conditional filtering logic to restrict the data records in the partitioned database to a result set satisfying the conditional filtering logic. On the basis of an indication that only a subset of the result set is to be returned, a subset of data partitions is determined from the plurality of data partitions from which the subset of the result set can be retrieved. Then, the query is executed only against the subset of data partitions.
摘要:
Methods, articles of manufacture, and systems for providing access to a grid computing environment. In one environment, requests include resource specific criteria used to identify a particular grid resource to perform the request. In another embodiment, a request includes a queue criterion used to identify one of a plurality of queues on which the request is placed.
摘要:
Methods, articles of manufacture, and systems for providing access to a grid computing environment. In one environment, requests include resource specific criteria used to identify a particular grid resource to perform the request. In another embodiment, a request includes a queue criterion used to identify one of a plurality of queues on which the request is placed.
摘要:
Methods, articles of manufacture, and systems for providing access to a grid computing environment. In one environment, requests include resource specific criteria used to identify a particular grid resource to perform the request. In another embodiment, a request includes a queue criterion used to identify one of a plurality of queues on which the request is placed.
摘要:
Coordinating digital video recorder (‘DVR’) recording with a user's electronic calendar, including establishing, by the DVR on behalf of the user, a user profile on the DVR, where the user profile includes a network location for the user's electronic calendar, the user's electronic calendar is installed upon a remote device, and the remote device is connected for data communications through a data communications network to the DVR. Embodiment also include the DVR's tracking information describing at least one show watched by the user and making an electronic calendar entry on the user's electronic calendar in dependence upon the information describing the show.
摘要:
A system, method and article of manufacture for query execution management in a data processing system and, more particularly, for optimizing execution of queries that are repeatedly executed against one or more databases in a data processing system. One embodiment provides a method for optimizing execution of a query that is repeatedly issued from an issuing entity against a database. The method comprises executing the query against the database to obtain an initial query result, returning the initial query result to the issuing entity, and managing re-execution of the query. Managing the re-execution comprises storing the initial query result in a temporary query result data structure, executing a trigger procedure for tracking database changes, when the trigger procedure detects a database change, updating the temporary query result data structure on the basis of the detected database change, and when the query is re-executed against the database, returning the temporary query result data structure to the issuing entity as query result.
摘要:
The present invention generally relates to data processing and, more particularly, to managing operation of user-defined functions on a partitioned database. One embodiment provides a computer-implemented method for managing execution of a query against a partitioned database having a plurality of data partitions. The method comprises, for each of the plurality of data partitions, examining data of the data partition, and on the basis of examined data, implementing a modified form of a user-defined function on the data partition. The method further comprises executing the query referring to the user-defined function against the plurality of data partitions, wherein execution of the query on each data partition invokes execution of the respective modified form of the user-defined function against the data of the respective data partition.
摘要:
Techniques are described for estimating and managing energy consumption for query processing. Embodiments of the invention may generally receive a query to be executed and calculate an initial estimated energy consumption value for the received query. If the initial estimated energy consumption value does not exceed a threshold amount of energy, embodiments of the invention may submit the query for execution. Once execution of the query has begun, embodiments of the invention may calculate an updated estimated energy consumption value for the executing query, and if the updated value exceeds the threshold amount of energy, may halt the execution of the query.