×

IN-MEMORY CURSOR DURATION TEMP TABLES

  • US 20170116266A1
  • Filed: 09/16/2016
  • Published: 04/27/2017
  • 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 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;

    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;

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

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

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