×

Accelerating queries using delayed value projection of enumerated storage

  • US 9,305,080 B2
  • Filed: 12/28/2006
  • Issued: 04/05/2016
  • Est. Priority Date: 12/28/2006
  • Status: Active Grant
First Claim
Patent Images

1. A method, comprising:

  • receiving a query that references a column within a table, wherein a column cell from the column contains an enumeration value, and wherein the column is associated with a lookup-table configured to translate the enumeration value into a column cell value corresponding to the column cell;

    generating a set of query processing steps that, when executed by one or more processors, provides a query result to the query;

    passing a projection of the column containing the enumeration value to a query processing step from the set of query processing steps;

    determining, prior to executing the query processing step, that a partial result that is generated within the query processing step using the enumeration value instead of the column cell value does not change the partial result;

    executing, in response to the determination that the partial result does not change, the query processing step using the enumeration value to produce the partial result; and

    delaying, in response to the determination that the partial result does not change, a translation of the enumeration value into the column cell value during execution of the set of query processing steps by passing the projection of the column containing the enumeration value to a subsequent query processing step from the set of query processing steps, wherein the translation is delayed until determining that a subsequent partial result that is generated within the subsequent processing step using the enumeration value is different from the subsequent partial result generated using the column value.

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