×

Parallel execution of queries with a recursive clause

  • US 10,678,792 B2
  • Filed: 09/16/2016
  • Issued: 06/09/2020
  • Est. Priority Date: 10/23/2015
  • Status: Active Grant
First Claim
Patent Images

1. A method comprising:

  • executing a query with a recursive clause wherein the executing includes;

    generating a temporary table for a first set of results, wherein the temporary table comprises a plurality of segments, each segment of said plurality of segments being associated with a respective process of a plurality of processes that execute database operations in parallel;

    indicating the first set of results are associated with a first iteration of the recursive clause; and

    for one or more additional iterations, each corresponding process of the plurality of processes performing in parallel with one or more other processes of the plurality processes;

    retrieving, from the temporary table, a set of results from a previous iteration based on an indication that associates the set of results with the previous iteration;

    performing one or more operations on the set of results from the previous iteration thereby generating a respective additional set of results;

    indicating the respective additional set of results is associated with a respective additional iteration;

    appending the respective additional set of results to a corresponding segment associated with said each corresponding process; and

    wherein said each corresponding process produced the respective additional set of results by performing, in parallel with the one or more other processes of the plurality processes, the one or more operations.

View all claims
  • 1 Assignment
Timeline View
Assignment View
    ×
    ×