Patent · US Active

Determination of query operator execution location

US11157500B2 · kind B2 · utility

1Cited by
1References
18Claims
0Family size

Assignee

Inventors

Key dates

Filing dateApr 3, 2019
Grant dateOct 26, 2021
Priority date
Expiry dateJan 10, 2040

Classification

  • Technology area (CPC G)Physics
  • CPC primaryG06F16/24537
  • WIPO fieldComputer technology
  • WIPO sectorElectrical engineering

Abstract

A system includes determination of a first partition-wise operation on a first database table partition of a first table located at a first server node and a first database table partition of a second table located at a second server node, determination of a first cost to execute the first partition-wise operation on the first server node, and a second cost to execute the first partition-wise operation on the second server node, determination of a second partition-wise operation on a result of the first partition-wise operation, determination of a third cost to execute the second partition-wise operation on the first server node based on the first cost and the second cost, and a fourth cost to execute the second partition-wise operation on the second server node based on the first cost and the second cost, determination of one of the first server node and the second server node to execute the second partition-wise operation based on the third cost and the fourth cost, and determination of one of the first server node and the second server node to execute the first partition-wise operation based on the third cost and the fourth cost.

Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.