×

In-memory cursor duration temp tables

  • US 10,452,655 B2
  • Filed: 09/16/2016
  • Issued: 10/22/2019
  • Est. Priority Date: 10/23/2015
  • Status: Active Grant
First Claim
Patent Images

1. A method of processing a query on a multi-node database system against a shared database, the method comprising:

  • assigning multiple threads on each node of a plurality of nodes of said multi-node database system for processing the query, said multiple threads including a plurality of writer threads and a plurality of reader threads;

    wherein for each node of said multi-node database system;

    one or more respective writer threads from said plurality of writer threads run on said each node, andone or more respective reader threads from said plurality of reader threads run on said each node;

    creating an in-memory temporary table for storing intermediate results generated for said query, wherein a memory of each node of said multi-node database system stores a respective local in-memory temporary table part of said in-memory temporary table;

    on each node of said multi-node database system, the one or more respective writer threads writing to the respective local in-memory temporary table part of said each node;

    on each node of said multi-node database system, generating a respective data structure based on the respective local in-memory temporary table part of said each node; and

    on each node of said multi-node database system, based on the respective data structure of, said each node, the one or more respective reader threads of said each node reading from the respective local in-memory temporary table part of said each node.

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