Parallel partition-wise insert sub-select
US11157565B2 · kind B2 · utility
Assignee
Inventors
Key dates
| Filing date | Apr 4, 2019 |
| Grant date | Oct 26, 2021 |
| Priority date | — |
| Expiry date | Jan 16, 2040 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/9032
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
A system includes reception of a database query, the query comprising a first query statement to insert rows of a source table into a target table, generation a second query statement and a third query statement based on the first query statement, the second query statement to insert rows of a first partition of the source table into the target table and the third query statement to insert rows of a second partition of the source table into the target table, generation of a first query operator executable to perform the second query statement, generation of a second query operator executable to perform the third query statement, transmission of the first executable query operator to a second database server node storing the first partition of the source table, and transmission of the second executable query operator to a third database server node storing the second partition of the source table.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.