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

1. 发明授权

US09165032B2 Allocation of resources for concurrent query execution via adaptive segmentation 有权
公开(公告)号：US09165032B2
公开(公告)日：2015-10-20
申请号：US11986599
申请日：2007-11-21
申请人： Robert M Wehrmeister , Awny K Al-Omari , Subbarao Kakarlamudi , Zbigniew Omanski , Kashif A Siddiqui , Hansjorg Zeller , Peter Friedenbach
发明人： Robert M Wehrmeister , Awny K Al-Omari , Subbarao Kakarlamudi , Zbigniew Omanski , Kashif A Siddiqui , Hansjorg Zeller , Peter Friedenbach
IPC分类号： G06F7/00 , G06F17/30
CPC分类号： G06F17/30445 , G06F17/30545
摘要： An enterprise data warehouse or business intelligence system having a plurality of processors and memory resources. The system includes at least a database server, a workload management system, a query compiler, and a query executor. The database server configured to receive a database query from an application at a database client system. The query compiler configured to prepare the execution plan for the query and compute the number of executive server processes (ESPs) in each ESP layer of the query. The workload management system is configured to generate an affinity value, and the query executor is configured to execute the query. As disclosed herein, placement of the executive server process layers of the query onto processors of the computing system is determined using the affinity value. Other embodiments, aspects and features are also disclosed.

2. 发明授权

US08812484B2 System and method for outer joins on a parallel database management system 有权
标题翻译：并行数据库管理系统中的外连接的系统和方法
公开(公告)号：US08812484B2
公开(公告)日：2014-08-19
申请号：US13383775
申请日：2010-03-30
申请人： Awny K Al-Omari , QiFan Chen
发明人： Awny K Al-Omari , QiFan Chen
IPC分类号： G06F7/00 , G06F17/30
CPC分类号： G06F17/30445
摘要： There is provided a computer-executable method of executing an outer join on a parallel database management system. An exemplary method comprises receiving an outer skewed values list (SVL). The outer SVL may comprise values that are indicated to be skewed. The exemplary method further comprises receiving an inner SVL. The inner SVL may comprise values that are indicated to be skewed. Additionally, the exemplary method comprises partitioning the outer table and the inner table across a plurality of join instances, based on the outer SVL and the inner SVL. A missing skew value is identified. The missing skewed value may be a value of the inner SVL that is not found in the inner table. The outer join is performed using the plurality of join instances, based on the missing skewed value.
摘要翻译：提供了一种在并行数据库管理系统上执行外连接的计算机可执行方法。一种示例性方法包括接收外偏斜值列表（SVL）。外部SVL可以包括指示为倾斜的值。该示例性方法还包括接收内部SVL。内部SVL可以包括指示为倾斜的值。此外，示例性方法包括基于外部SVL和内部SVL跨多个连接实例划分外部桌子和内部桌子。识别出缺失的偏移值。缺少的偏斜值可能是在内部表中未找到的内部SVL的值。基于丢失的偏斜值，使用多个连接实例来执行外连接。

3. 发明授权

US08190598B2 Skew-based costing for database queries 有权
标题翻译：数据库查询的基于偏倚的成本计算
公开(公告)号：US08190598B2
公开(公告)日：2012-05-29
申请号：US12261058
申请日：2008-10-30
申请人： Awny K Al-Omari , Ramakumar Kosuru , Renu Varshneya , Robert L. Wall
发明人： Awny K Al-Omari , Ramakumar Kosuru , Renu Varshneya , Robert L. Wall
IPC分类号： G06F17/30
CPC分类号： G06F17/30433 , G06F17/30445
摘要： One embodiment is a method that determines skew to predict costs for query plans for a database query. The method selects a query plan that accounts for the skew to evenly distribute processing load among multiple processors and then executes the query with the selected query plan.
摘要翻译：一个实施例是确定倾斜以预测数据库查询的查询计划的成本的方法。该方法选择考虑偏差的查询计划，以平均分配多个处理器之间的处理负载，然后使用所选查询计划执行查询。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式