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

1. 发明授权

US07676525B2 Efficient query processing of merge statement 有权
标题翻译：合并语句的高效查询处理
公开(公告)号：US07676525B2
公开(公告)日：2010-03-09
申请号：US11772495
申请日：2007-07-02
申请人： Stefano Stefani , Naveen Prakash , Craig S. Freedman , Marcel van der Holst
发明人： Stefano Stefani , Naveen Prakash , Craig S. Freedman , Marcel van der Holst
IPC分类号： G06F7/00
CPC分类号： G06F17/30365 , G06F17/30471
摘要： Disclosed are systems and methods for optimization and efficient processing of MERGE statements. MERGE allows performing a mix of inserts, updates, and deletes in a single statement, and introduces new challenges compared to legacy DML statements, where the kind of action to be performed is hard-coded and known at compile time. Such optimizations may include Halloween Protection detection for MERGE statements, optimized prevention of non-deterministic MERGE statements, in-place inserts for MERGE statements scanning the “Read Instance” of the target table, and optimized execution of MERGE statements seeking the “Read Instance” of the target table. Such optimizations may be fundamental in order to ensure proper performance and reliable processing times.
摘要翻译：公开了用于优化和有效处理MERGE语句的系统和方法。 MERGE允许在单个语句中执行插入，更新和删除的混合，并且与传统DML语句相比引入新的挑战，其中要执行的操作类型在编译时被硬编码和已知。这种优化可能包括MERGE语句的万圣节保护检测，非确定性MERGE语句的优化预防，扫描目标表的“读取实例”的MERGE语句的就地插入以及寻求“读取实例”的MERGE语句的优化执行的目标表。为了确保正确的性能和可靠的处理时间，这种优化可能是至关重要的。

2. 发明申请

US20090012980A1 Efficient Query Processing Of Merge Statement 有权
标题翻译：合并声明的高效查询处理
公开(公告)号：US20090012980A1
公开(公告)日：2009-01-08
申请号：US11772495
申请日：2007-07-02
申请人： Stefano Stefani , Naveen Prakash , Craig S. Freedman , Marcel van der Holst
发明人： Stefano Stefani , Naveen Prakash , Craig S. Freedman , Marcel van der Holst
IPC分类号： G06F7/06 , G06F17/30
CPC分类号： G06F17/30365 , G06F17/30471
摘要： Disclosed are systems and methods for optimization and efficient processing of MERGE statements. MERGE allows performing a mix of inserts, updates, and deletes in a single statement, and introduces new challenges compared to legacy DML statements, where the kind of action to be performed is hard-coded and known at compile time. Such optimizations may include Halloween Protection detection for MERGE statements, optimized prevention of non-deterministic MERGE statements, in-place inserts for MERGE statements scanning the “Read Instance” of the target table, and optimized execution of MERGE statements seeking the “Read Instance” of the target table. Such optimizations may be fundamental in order to ensure proper performance and reliable processing times.
摘要翻译：公开了用于优化和有效处理MERGE语句的系统和方法。 MERGE允许在单个语句中执行插入，更新和删除的混合，并且与传统DML语句相比引入新的挑战，其中要执行的操作类型在编译时被硬编码和已知。这种优化可能包括MERGE语句的万圣节保护检测，非确定性MERGE语句的优化预防，扫描目标表的“读取实例”的MERGE语句的就地插入以及寻求“读取实例”的MERGE语句的优化执行的目标表。为了确保正确的性能和可靠的处理时间，这种优化可能是至关重要的。

3. 发明授权

US07933894B2 Parameter-sensitive plans for structural scenarios 有权
标题翻译：结构场景参数敏感计划
公开(公告)号：US07933894B2
公开(公告)日：2011-04-26
申请号：US11763490
申请日：2007-06-15
申请人： Marc T. Friedman , Cesar A. Galindo-Legaria , Erik Ismert , Milind Madhukar Joshi , Naveen Prakash
发明人： Marc T. Friedman , Cesar A. Galindo-Legaria , Erik Ismert , Milind Madhukar Joshi , Naveen Prakash
IPC分类号： G06F17/30
CPC分类号： G06F17/30463
摘要： Systems and methods that generate specialized plans for compiling SQL queries. A plan generator component scans the query representation for parameter sensitive predicates and evaluates each predicate individually based on the parameter values. Accordingly, queries can be identified not only based on their structures, but also based on their parameter conditions. The specialized plans are more efficient for particular values, wherein queries that employ such values are optimally executed.
摘要翻译：生成用于编译SQL查询的专门计划的系统和方法。计划生成器组件扫描参数敏感谓词的查询表达式，并根据参数值分别评估每个谓词。因此，不仅可以基于它们的结构，而且还可以基于它们的参数条件来识别查询。特定计划对于特定值更有效，其中采用这些值的查询被最佳地执行。

4. 发明申请

US20080313131A1 PARAMETER-SENSITIVE PLANS FOR STRUCTURAL SCENARIOS 有权
标题翻译：结构场景的参数敏感计划
公开(公告)号：US20080313131A1
公开(公告)日：2008-12-18
申请号：US11763490
申请日：2007-06-15
申请人： Marc T. Friedman , Cesar A. Galindo-Legaria , Erik Ismert , Milind Madhukar Joshi , Naveen Prakash
发明人： Marc T. Friedman , Cesar A. Galindo-Legaria , Erik Ismert , Milind Madhukar Joshi , Naveen Prakash
IPC分类号： G06F17/30
CPC分类号： G06F17/30463
摘要： Systems and methods that generate specialized plans for compiling SQL queries. A plan generator component scans the query representation for parameter sensitive predicates and evaluates each predicate individually based on the parameter values. Accordingly, queries can be identified not only based on their structures, but also based on their parameter conditions. The specialized plans are more efficient for particular values, wherein queries that employ such values are optimally executed.
摘要翻译：生成用于编译SQL查询的专门计划的系统和方法。计划生成器组件扫描参数敏感谓词的查询表达式，并根据参数值分别评估每个谓词。因此，不仅可以基于它们的结构，而且还可以基于它们的参数条件来识别查询。特定计划对于特定值更有效，其中采用这些值的查询被最佳地执行。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式