×

Materializing internal computations in-memory to improve query performance

  • US 10,366,083 B2
  • Filed: 05/04/2016
  • Issued: 07/30/2019
  • Est. Priority Date: 07/29/2015
  • Status: Active Grant
First Claim
Patent Images

1. A method comprising:

  • receiving, by a database server instance, a query;

    responsive to receiving the query, identifying, by the database server instance, a set of computations for evaluation during execution of the query;

    wherein the set of computations includes a first computation;

    responsive to identifying the set of computations, evaluating the first computation, by the database server instance, to obtain a first set of computation results for the first computation;

    after evaluating the first computation, materializing, by the database server instance, within an in-memory unit, the first set of computation results for use during execution of another query,wherein the in-memory unit includes a materialized results area,wherein the materialized results area stores a set of bit-vectors derived from evaluating predicate evaluations and a set of columns derived from non-predicate evaluations, andwherein the in-memory unit stores;

    a first pointer for allocating space for bit-vector result sets, anda second pointer for allocating space for result sets derived from non-predicate evaluations; and

    storing, by the database server instance, within the in-memory unit, mapping data that maps a set of metadata values associated with the first computation to the first set of computation results;

    using, by the database server instance, the first set of computation results, which were materialized within the in-memory unit, to answer a subsequently-received query that involves the first computation.

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