Invention Grant
US08812484B2 System and method for outer joins on a parallel database management system
有权
并行数据库管理系统中的外连接的系统和方法
- Patent Title: System and method for outer joins on a parallel database management system
- Patent Title (中): 并行数据库管理系统中的外连接的系统和方法
-
Application No.: US13383775Application Date: 2010-03-30
-
Publication No.: US08812484B2Publication Date: 2014-08-19
- Inventor: Awny K Al-Omari , QiFan Chen
- Applicant: Awny K Al-Omari , QiFan Chen
- Applicant Address: US TX Houston
- Assignee: Hewlett-Packard Development Company, L.P.
- Current Assignee: Hewlett-Packard Development Company, L.P.
- Current Assignee Address: US TX Houston
- International Application: PCT/US2010/029205 WO 20100330
- International Announcement: WO2011/123096 WO 20111006
- Main IPC: G06F7/00
- IPC: G06F7/00 ; G06F17/30

Abstract:
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.
Public/Granted literature
- US20120117056A1 SYSTEM AND METHOD FOR OUTER JOINS ON A PARALLEL DATABASE MANAGEMENT SYSTEM Public/Granted day:2012-05-10
Information query