US 11,989,179 B2
Techniques of heterogeneous hardware execution for SQL analytic queries for high volume data processing
Shasank Kisan Chavan, Menlo Park, CA (US); Garret F. Swart, Palo Alto, CA (US); and Weiwei Gong, Belmont, CA (US)
Assigned to Oracle International Corporation, Redwood Shores, CA (US)
Filed by Oracle International Corporation, Redwood Shores, CA (US)
Filed on Aug. 25, 2022, as Appl. No. 17/895,445.
Application 17/895,445 is a continuation of application No. 17/015,580, filed on Sep. 9, 2020, granted, now 11,429,604.
Claims priority of provisional application 62/898,460, filed on Sep. 10, 2019.
Prior Publication US 2022/0405282 A1, Dec. 22, 2022
Int. Cl. G06F 16/2453 (2019.01); G06F 16/901 (2019.01); G06N 20/00 (2019.01); G06N 5/04 (2023.01)
CPC G06F 16/24537 (2019.01) [G06F 16/24542 (2019.01); G06F 16/9024 (2019.01); G06N 20/00 (2019.01); G06N 5/04 (2013.01)] 20 Claims
OG exemplary drawing
 
1. A method comprising:
generating a query plan for a database statement that references a plurality of columns in a set of relational tuples, wherein the query plan includes a hardware-independent rotate operator;
executing the query plan, wherein executing the query plan includes rotating, by a graphical processing unit (GPU), the plurality of columns; and
generating and sending a response for the database statement that is based on said rotating the plurality of columns;
wherein the method is performed by one or more computers.
 
8. The method of claim 1 further comprising:
detecting that an output format of an upstream operator needs conversion to a format selected from the group consisting of: an input format of a downstream operator and an output file format; and
selecting, in response to said detecting, the hardware-independent rotate operator.