ACTIVE MEMORY EXPANSION AND RDBMS META DATA AND TOOLING
    91.
    发明申请
    ACTIVE MEMORY EXPANSION AND RDBMS META DATA AND TOOLING 失效
    主动内存扩展和RDBMS元数据和工具

    公开(公告)号:US20120109908A1

    公开(公告)日:2012-05-03

    申请号:US12914063

    申请日:2010-10-28

    IPC分类号: G06F7/00

    CPC分类号: G06F17/30289

    摘要: 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.

    摘要翻译: 描述了用于估计和管理用于查询处理的存储器压缩的技术。 本发明的实施例通常可以包括接收要执行的查询,确定关于检索到的数据的指示性数据,以及根据指示数据选择性地压缩存储器中的一部分数据。 在一个实施例中,记录和输出在每个查询执行期间执行的压缩量以帮助调整选择压缩处理。

    Managing execution of a query against selected data partitions of a partitioned database
    93.
    发明授权
    Managing execution of a query against selected data partitions of a partitioned database 失效
    管理针对分区数据库的选定数据分区的查询执行

    公开(公告)号:US07962442B2

    公开(公告)日:2011-06-14

    申请号:US11468966

    申请日:2006-08-31

    IPC分类号: G06F7/00

    CPC分类号: G06F17/30545 G06F17/30979

    摘要: 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.

    摘要翻译: 本发明一般涉及数据处理,更具体地涉及对分区数据库执行查询。 一个实施例提供了一种计算机实现的对具有多个数据分区的分区数据库执行查询的方法。 该方法包括接收具有条件过滤逻辑的查询,以将分区数据库中的数据记录限制为满足条件过滤逻辑的结果集。 基于仅返回结果集的子集的指示,从可从中检索结果集的子集的多个数据分区确定数据分区的子集。 然后,仅针对数据分区子集执行查询。

    Coordinating digital video recorder ('DVR') recording with a user's electronic calendar
    97.
    发明申请
    Coordinating digital video recorder ('DVR') recording with a user's electronic calendar 审中-公开
    使用用户的电子日历协调数字录像机(“DVR”)录音

    公开(公告)号:US20080091718A1

    公开(公告)日:2008-04-17

    申请号:US11548777

    申请日:2006-10-12

    IPC分类号: G06F17/00

    摘要: 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.

    摘要翻译: 使用用户的电子日历协调数字录像机(“DVR”)记录,包括代表用户由DVR建立DVR上的用户简档,其中用户简档包括用户电子日历的网络位置, 用户的电子日历安装在远程设备上,并且远程设备被连接用于通过数据通信网络进行数据通信到DVR。 实施例还包括DVR的跟踪信息,描述至少一个由用户观看的节目,并根据描述节目的信息在用户的电子日历上制作电子日历条目。

    Data query system load optimization
    98.
    发明授权
    Data query system load optimization 失效
    数据查询系统负载优化

    公开(公告)号:US07127449B2

    公开(公告)日:2006-10-24

    申请号:US10645740

    申请日:2003-08-21

    IPC分类号: G06F17/30

    摘要: 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.

    摘要翻译: 一种用于数据处理系统中的查询执行管理的系统,方法和制品,更具体地说,用于优化对数据处理系统中的一个或多个数据库重复执行的查询的执行。 一个实施例提供了一种用于优化从发布实体针对数据库重复发出的查询的执行的方法。 该方法包括对数据库执行查询以获得初始查询结果,将初始查询结果返回给发布实体,并管理查询的重新执行。 管理重新执行包括将初始查询结果存储在临时查询结果数据结构中,当触发过程检测数据库改变时,执行跟踪数据库更改的触发过程,基于检测到的更新临时查询结果数据结构 数据库更改,当对数据库重新执行查询时,将临时查询结果数据结构作为查询结果返回给发行实体。

    Method and system for managing operation of a user-defined function on a partitioned database
    99.
    发明授权
    Method and system for managing operation of a user-defined function on a partitioned database 有权
    用于管理分区数据库上用户定义函数的操作的方法和系统

    公开(公告)号:US08799266B2

    公开(公告)日:2014-08-05

    申请号:US11468926

    申请日:2006-08-31

    IPC分类号: G06F17/30 G06F15/16

    CPC分类号: G06F17/30471

    摘要: 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.

    摘要翻译: 本发明一般涉及数据处理,更具体地涉及在分区数据库上管理用户定义的功能的操作。 一个实施例提供了一种用于管理针对具有多个数据分区的分区数据库的查询执行的计算机实现的方法。 该方法包括对于多个数据分区中的每一个,检查数据分区的数据,并且基于被检查的数据,在数据分区上实现用户定义函数的修改形式。 所述方法还包括针对所述多个数据分区执行参考用户定义的功能的查询,其中在每个数据分区上的查询的执行根据相应数据的数据调用用户定义函数的相应修改形式的执行 划分。

    Estimating and managing energy consumption for query processing
    100.
    发明授权
    Estimating and managing energy consumption for query processing 失效
    估算和管理查询处理能耗

    公开(公告)号:US08447776B2

    公开(公告)日:2013-05-21

    申请号:US12871123

    申请日:2010-08-30

    IPC分类号: G06F17/30

    摘要: 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.

    摘要翻译: 描述了用于估计和管理查询处理能耗的技术。 本发明的实施例通常可以接收要执行的查询,并且计算接收到的查询的初始估计能量消耗值。 如果初始估计的能量消耗值不超过能量的阈值量,则本发明的实施例可以提交执行查询。 一旦查询的执行开始,本发明的实施例可以计算执行查询的更新的估计能量消耗值,并且如果更新的值超过阈值的能量量,则可以停止查询的执行。