- Patent Title: Parallel processing of queries with inverse distribution function
-
Application No.: US15375023Application Date: 2016-12-09
-
Publication No.: US10366082B2Publication Date: 2019-07-30
- Inventor: Qingyuan Kong , Huagang Li , Sankar Subramanian
- Applicant: Oracle International Corporation
- Applicant Address: US CA Redwood Shores
- Assignee: Oracle International Corporation
- Current Assignee: Oracle International Corporation
- Current Assignee Address: US CA Redwood Shores
- Agency: Hickman Palermo Becker Bingham LLP
- Main IPC: G06F17/30
- IPC: G06F17/30 ; G06F16/2453 ; G06F16/242 ; G06F16/28 ; G06F16/35

Abstract:
Techniques are described for parallel processing of database queries with an inverse distribution function by a database management system (DBMS). To improve the execution time of a query with an inverse distribution function, the data set referenced in the inverse distribution function is range distributed among parallel processes that are spawned and managed by a query execution coordinator process (QC), in an embodiment. The parallel executing processes sort each range of the data set in parallel, while the QC determines the location(s) of inverse distribution function values based on the count of values in each range of the data set. The QC requests the parallel processes to produce to the next stage of parallel processes the values at the location(s) in the sorted ranges. The next stage of parallel processes computes the inverse distribution function based on the produced values. Techniques are also described for parallel executing of queries that may additionally include another inverse distribution function, one or more non-distinct aggregate functions and one or more distinct aggregate functions.
Public/Granted literature
- US20180165335A1 PARALLEL PROCESSING OF QUERIES WITH INVERSE DISTRIBUTION FUNCTION Public/Granted day:2018-06-14
Information query