Invention Grant
- Patent Title: Parallelizing SQL user defined transformation functions
-
Application No.: US15114913Application Date: 2014-03-10
-
Publication No.: US10885031B2Publication Date: 2021-01-05
- Inventor: Qiming Chen , Maria G. Castellanos , Meichun Hsu , Sharad Singhal
- Applicant: Hewlett Packard Enterprise Development LP
- Applicant Address: US TX Houston
- Assignee: Hewlett Packard Enterprise Development LP
- Current Assignee: Hewlett Packard Enterprise Development LP
- Current Assignee Address: US TX Houston
- International Application: PCT/US2014/022879 WO 20140310
- International Announcement: WO2015/137919 WO 20150917
- Main IPC: G06F16/24
- IPC: G06F16/24 ; G06F16/2453 ; G06F16/2455

Abstract:
Example embodiments relate to parallelizing structured query language (SQL) user defined transformation functions. In example embodiments, a subquery of a query is received from a query engine, where each of the subqueries is associated with a distinct magic number in a magic table. A user defined transformation function that includes local, role-based functionality may then be executed, where the magic number triggers parallel execution of the user defined transformation function. At this stage, the results of the user defined transformation function are sent to the query engine, where the query engine unions the results with other results that are obtained from the other database nodes.
Public/Granted literature
- US20160342653A1 PARALLELIZING SQL USER DEFINED TRANSFORMATION FUNCTIONS Public/Granted day:2016-11-24
Information query