US 11,531,664 B2 · Stand in tables

Abstract

A method for pre-utilizing tables before refresh includes selecting a query for execution in a data analytics application and identifying a table specified by the query, for instance a materialized table. Another operation includes computing an encoding, such as a hash value, for at least one portion of the identified table. Another operation includes comparing the computed encoding to a pre-stored encoding for the at least one portion of the identified table. On the condition that the computed encoding is identical to the pre-stored encoding, the operations include utilizing the identified table in executing the query in lieu of re-materializing the identified table. Otherwise, on the condition that the computed encoding differs from the pre-stored encoding, the operations include re-materializing the identified table before returning the results of the query.

Claims12

Dependent claims

A computer-implemented method that, when executed by data processing hardware, causes the data processing hardware to perform operations comprising:

selecting a query of a database for execution in a data analytics application;
identifying a table specified by the query, the identified table storing cached results;
computing an encoding for at least one portion of the identified table;
determining whether the computed encoding for the at least one portion of the identified table is identical to a pre-stored encoding;
when the computed encoding is identical to the pre-stored encoding, utilizing the identified table in executing the query;
and
when the computed encoding is not identical to the pre-stored encoding:
updating the identified table by caching a result of the query of the database to the identified table;
and
returning, using the updated identified table, a result of the query.

7 more elements

A data processing system comprising:

a host computing platform comprising one or more computers, each comprising memory and at least one processor;
and
a pre-utilization module comprising computer program instructions enabled, while executing in the host computing platform, to perform operations comprising:
selecting a query of a database for execution in a data analytics application;
identifying a table specified by the query, the identified table storing cached results;
computing an encoding for at least one portion of the identified table;
determining whether the computed encoding for the at least one portion of the identified table is identical to a pre-stored encoding;
when the computed encoding is identical to the pre-stored encoding, utilizing the identified table in executing the query;
and
when the computed encoding is not identical to the pre-stored encoding:
updating the identified table by caching a result of the query of the database to the identified table;
and
returning, using the updated identified table, a result of the query.

10 more elements

A computer program product including a computer readable storage medium having program instructions embodied therewith, the program instructions executable by a device to cause the device to perform operations comprising:

selecting a query of a database for execution in a data analytics application;
identifying a table specified by the query;
computing an encoding for at least one portion of the identified table, the identified table storing cached results;
determining whether the computed encoding for the at least one portion of the identified table is identical to a pre-stored encoding;
when the computed encoding is identical to the pre-stored encoding, utilizing the identified table in executing the query;
and
when the computed encoding is not identical to the pre-stored encoding:
updating the identified table by caching a result of the query of the database to the identified table;
and
returning, using the updated identified table, a result of the query.

7 more elements

Dependencies are inferred from the claim text.

Stand in tables

Life of this patent

Stand in tables

Life of this patent

Abstract

Claims12