Invention Grant
- Patent Title: Parallel execution of merge operations
-
Application No.: US16195903Application Date: 2018-11-20
-
Publication No.: US10885029B2Publication Date: 2021-01-05
- Inventor: Shuo Li , Ping Liang , Bing Qing Sun , Xiaobo Wang , Xin Ying Yang
- Applicant: International Business Machines Corporation
- Applicant Address: US NY Armonk
- Assignee: International Business Machines Corporation
- Current Assignee: International Business Machines Corporation
- Current Assignee Address: US NY Armonk
- Agency: Cantor Colburn LLP
- Agent Richard Wilhelm
- Main IPC: G06F16/22
- IPC: G06F16/22 ; G06F16/2453

Abstract:
Aspects include a method that includes receiving a structured query language (SQL) database command at a processing device configured to manage a table space of a relational database, the database command including a merge statement. The method also includes identifying a group of target records from the database command, and associating each target record with one of a plurality of portions of the table space, and in response to determining that the group of target records is associated with more than one portion of the table space, sorting the target records into a plurality of sub-groups, each sub-group associated with a different portion of the table space. The method further includes generating a sub-task associated with each sub-group, the sub-task prescribing aspects of performing the merge operation using an associated sub-group respective sub-group, and performing all of the sub-tasks on the memory space in parallel.
Public/Granted literature
- US20190087459A1 PARALLEL EXECUTION OF MERGE OPERATIONS Public/Granted day:2019-03-21
Information query