Deriving metrics from queries
AssigneeMicroStrategy Incorporated
InventorsYi Luo, Ananya Ojha, Zhili Cheng, Dongping Liang
Life of this patent
Estimating the term…
Abstract
Methods, systems, apparatus, and computer-readable media for deriving data elements from queries. In some implementations, a query is received, and one or more computers determine that the query involves an operation that satisfies one or more criteria. In response data is saved that indicates a derived data element corresponding to the operation. The one or more computers provide data causing a representation of the derived data element to be presented, such as data causing an interactive control representing the derived data element to be presented on a user interface.
Claims20
A method performed by one or more computers, the method comprising:
- storing, by the one or more computers, data indicating a predetermined set of data processing operations for evaluating queries;
- receiving, by the one or more computers, a query;
- identifying, by the one or more computers, a data processing operation used to generate a response to the query and one or more data objects on which the identified data processing operation is applied to generate the response to the query;
- determining, by the one or more computers, that the data processing operation is included in the predetermined set of data processing operations;
- and
- in response to determining that the identified data processing operation is included in the predetermined set of data processing operations:
- generating, by the one or more computers, a data element definition for a derived data element based on the identified data processing operation and the identified one or more data objects, wherein the derived data element represents a type of data that results from performing the identified data processing operation on the identified one or more data objects;
- and
- updating, by the one or more computers, an interface area on a user interface to display an interactive element that represents the derived data element.
A system comprising:
- one or more computers;
- and
- one or more computer-readable media storing instructions that, when executed by the one or more computers, cause the one or more computers to perform operations comprising:
- storing, by the one or more computers, data indicating a predetermined set of data processing operations for evaluating queries;
- receiving, by the one or more computers, a query;
- identifying, by the one or more computers, a data processing operation used to generate a response to the query and one or more data objects on which the identified data processing operation is applied to generate the response to the query;
- determining, by the one or more computers, that the data processing operation is included in the predetermined set of data processing operations;
- and
- in response to determining that the identified data processing operation is included in the predetermined set of data processing operations:
- generating, by the one or more computers, a data element definition for a derived data element based on the identified data processing operation and the identified one or more data objects, wherein the derived data element represents a type of data that results from performing the identified data processing operation on the identified one or more data objects;
- and
- updating, by the one or more computers, an interface area on a user interface to display an interactive element that represents the derived data element.
One or more non-transitory computer-readable media storing instructions that, when executed by one or more computers, cause the one or more computers to perform operations comprising:
- storing, by the one or more computers, data indicating a predetermined set of data processing operations for evaluating queries;
- receiving, by the one or more computers, a query;
- identifying, by the one or more computers, a data processing operation used to generate a response to the query and one or more data objects on which the identified data processing operation is applied to generate the response to the query;
- determining, by the one or more computers, that the data processing operation is included in the predetermined set of data processing operations;
- and
- in response to determining that the identified data processing operation is included in the predetermined set of data processing operations:
- generating, by the one or more computers, a data element definition for a derived data element based on the identified data processing operation and the identified one or more data objects, wherein the derived data element represents a type of data that results from performing the identified data processing operation on the identified one or more data objects;
- and
- updating, by the one or more computers, an interface area on a user interface to display an interactive element that represents the derived data element.
Dependencies are inferred from the claim text.