US 2022/0092069 A1 · METHOD FOR USING A SEMATIC MODEL TO TRANSFORM SQL AGAINST A RELATIONAL TABLE TO ENABLE PERFORMANCE IMPROVEMENTS

Abstract

Herein, a computer stores metadata that defines an analytic view that is based on organizing operation(s) that respectively specify organizing column(s) of organizing table(s), including a join operation that specifies a dimension column of a dimension table and a join column of a fact table. An original query is received that does not reference the analytic view. The original query specifies at least one organizing operation that is identical, somewhat similar, or compatible to an organizing operation on which the analytic view is based. Based on that at least one organizing operation that the original query specifies and the metadata that defines the particular analytic view, the original query is determined to satisfy rewrite criterion(s). In response to determining that the original query satisfies the rewrite criteria, a rewritten query that references the analytic view is generated based on the original query that does not reference the analytic view.

Claims20

Dependent claims

A method comprising:

storing metadata that defines a particular analytic view that is based on one or more organizing operations that respectively specify one or more organizing columns of one or more organizing tables, wherein said one or more organizing operations contains a join operation that specifies a dimension column of a dimension table and a join column of a fact table;
receiving an original query that does not reference the particular analytic view, wherein the original query specifies at least one organizing operation of said one or more organizing operations on which the particular analytic view is based;
determining, based on said at least one organizing operation that the original query specifies and said metadata that defines the particular analytic view, that the original query satisfies one or more rewrite criteria;
generating, in response to said determining that the original query satisfies the one or more rewrite criteria, a rewritten query that references the particular analytic view based on the original query that does not reference the particular analytic view.

1 more element

One or more non-transitory computer-readable media storing instructions that, when executed by one or more processors, cause:

storing metadata that defines a particular analytic view that is based on one or more organizing operations that respectively specify one or more organizing columns of one or more organizing tables, wherein said one or more organizing operations contains a join operation that specifies a dimension column of a dimension table and a join column of a fact table;
receiving an original query that does not reference the particular analytic view, wherein the original query specifies at least one organizing operation of said one or more organizing operations on which the particular analytic view is based;
determining, based on said at least one organizing operation that the original query specifies and said metadata that defines the particular analytic view, that the original query satisfies one or more rewrite criteria;
generating, in response to said determining that the original query satisfies the one or more rewrite criteria, a rewritten query that references the particular analytic view based on the original query that does not reference the particular analytic view.

1 more element

Dependencies are inferred from the claim text.

Method for using a sematic model to transform sql against a relational table to enable performance improvements

Life of this patent

Method for using a sematic model to transform sql against a relational table to enable performance improvements

Life of this patent

Abstract

Claims20