专利快速检索-快速检索全球专利，免费商用专利数据库-IPRDB

1. 发明授权

US07590646B2 System and method for segmented evaluation of database queries 失效
公开(公告)号：US07590646B2
公开(公告)日：2009-09-15
申请号：US10829595
申请日：2004-04-22
申请人： Cesar A. Galinda-Legaria , Goetz Graefe , Milind M. Joshi , Ross T. Bunker
发明人： Cesar A. Galinda-Legaria , Goetz Graefe , Milind M. Joshi , Ross T. Bunker
IPC分类号： G06F17/30
CPC分类号： G06F17/30501 , G06F17/3046 , G06F17/30466 , G06F17/30498 , Y10S707/99933 , Y10S707/99943
摘要： A method of satisfying a database query includes evaluating certain joins on a per-segment basis. An expression tree is produced for the query, and the expression tree is evaluated to identify joins whose operands are two instances of the same relation and whose join predicate conjunctively includes an equality comparison between two instances of the same column. When such a join is identified, it may be evaluated by segmenting the operand relation according to the columns that are compared for equality in the predicate. The join is then evaluated by performing the join operation separately on each segment. Segments may be spooled separately, thereby exploiting the efficiencies obtained by spooling even where the entire relation is too large to fit in the spool. Execution iterators are provided for spooling successive segments and for applying the join to the spooled segment.

2. 发明授权

US06748392B1 System and method for segmented evaluation of database queries 失效
标题翻译：数据库查询分段评估的系统和方法
公开(公告)号：US06748392B1
公开(公告)日：2004-06-08
申请号：US09800379
申请日：2001-03-06
申请人： Cesar A. Galindo-Legaria , Goetz Graefe , Milind M. Joshi , Ross T. Bunker
发明人： Cesar A. Galindo-Legaria , Goetz Graefe , Milind M. Joshi , Ross T. Bunker
IPC分类号： G06F1730
CPC分类号： G06F17/30501 , G06F17/3046 , G06F17/30466 , G06F17/30498 , Y10S707/99933 , Y10S707/99943
摘要： A method of satisfying a database query includes evaluating certain joins on a per-segment basis. An expression tree is produced for the query, and the expression tree is evaluated to identify joins whose operands are two instances of the same relation and whose join predicate conjunctively includes an equality comparison between two instances of the same column. When such a join is identified, it may be evaluated by segmenting the operand relation according to the columns that are compared for equality in the predicate. The join is then evaluated by performing the join operation separately on each segment. Segments may be spooled separately, thereby exploiting the efficiencies obtained by spooling even where the entire relation is too large to fit in the spool. Execution iterators are provided for spooling successive segments and for applying the join to the spooled segment.
摘要翻译：满足数据库查询的方法包括基于每个段来评估某些联接。为查询生成表达式树，并且对表达式树进行评估，以标识其操作数是相同关系的两个实例的连接，并且其连接谓词连接地包含同一列的两个实例之间的等效比较。当识别出这样的连接时，可以通过根据在谓词中的相等性进行比较的列分割操作数关系来评估操作数关系。然后通过在每个段上分别执行连接操作来评估连接。分段可以单独地卷绕，从而利用即使在整个关系太大而不能装入卷轴的情况下通过卷绕获得的效率。提供执行迭代器用于假脱机连续的段并将连接应用到假脱机段。

3. 发明授权

US07599953B2 System and method for segmented evaluation of database queries 失效
标题翻译：数据库查询分段评估的系统和方法
公开(公告)号：US07599953B2
公开(公告)日：2009-10-06
申请号：US10998761
申请日：2004-11-29
申请人： Cesar A. Galindo-Legaria , Goetz Graefe , Milind M. Joshi , Ross T. Bunker
发明人： Cesar A. Galindo-Legaria , Goetz Graefe , Milind M. Joshi , Ross T. Bunker
IPC分类号： G06F17/30
CPC分类号： G06F17/30501 , G06F17/3046 , G06F17/30466 , G06F17/30498 , Y10S707/99933 , Y10S707/99943
摘要： A method of satisfying a database query includes evaluating certain joins on a per-segment basis. An expression tree is produced for the query, and the expression tree is evaluated to identify joins whose operands are two instances of the same relation and whose join predicate conjunctively includes an equality comparison between two instances of the same column. When such a join is identified, it may be evaluated by segmenting the operand relation according to the columns that are compared for equality in the predicate. The join is then evaluated by performing the join operation separately on each segment. Segments may be spooled separately, thereby exploiting the efficiencies obtained by spooling even where the entire relation is too large to fit in the spool. Execution iterators are provided for spooling successive segments and for applying the join to the spooled segment.
摘要翻译：满足数据库查询的方法包括基于每个段来评估某些联接。为查询生成表达式树，并且对表达式树进行评估，以标识其操作数是相同关系的两个实例的连接，并且其连接谓词连接地包含同一列的两个实例之间的等效比较。当识别出这样的连接时，可以通过根据在谓词中的相等性进行比较的列分割操作数关系来评估操作数关系。然后通过在每个段上分别执行连接操作来评估连接。分段可以单独地卷绕，从而利用即使在整个关系太大而不能装入卷轴的情况下通过卷绕获得的效率。提供执行迭代器用于假脱机连续的段并将连接应用到假脱机段。

4. 发明授权

US07627866B2 Systems and methods for dynamic application patching 有权
标题翻译：用于动态应用程序修补的系统和方法
公开(公告)号：US07627866B2
公开(公告)日：2009-12-01
申请号：US11012767
申请日：2004-12-15
申请人： Ross T. Bunker , Roger B. Weber , Lawrence A. Jones
发明人： Ross T. Bunker , Roger B. Weber , Lawrence A. Jones
IPC分类号： G06F9/44
CPC分类号： G06F8/65
摘要： A system and method to update a patch index such that one or more properties in the patch index are associated with the patch, wherein the patch includes one or more components for the target software system; updating a class path at run-time for the target software system such that the patch associated with each one of the one or more properties supersedes prior patches for the same property; and wherein a component can include a class.
摘要翻译：一种用于更新补丁索引的系统和方法，使得所述补丁索引中的一个或多个属性与所述补丁相关联，其中所述补丁包括用于所述目标软件系统的一个或多个组件; 在运行时更新目标软件系统的类路径，使得与一个或多个属性中的每一个相关联的修补程序取代相同属性的先前修补程序; 并且其中组件可以包括类。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式