Back to results
US 11,687,436 B2Granted
Auto insights into data changes
AssigneeSnowflake Inc.
InventorsChristian Kleinerman, Christopher F. Pouliot, Jacobus J. P. Van Ryswyck
Life of this patent
Estimating the term…
Abstract
Techniques described herein can monitor various data metrics. The auto-insight techniques can further detect and rank data segments that contributed to, or counteracted, shifts in data and detect when such shifts occurred. Thus, the techniques described herein can detect and identify root causes in shifts in different metrics. The techniques include pruning and ranking causes to identify the root causes and identify non-relevant factors, as well.
Claims24
A method comprising:
- detecting a change in metric representative of a key performance indicator in a network-based data system;
- executing, by a processor, an input query to identify a root cause for the detected change generating an initial set of results including a plurality of data segments based on the detected change;
- pruning the initial set of results to generate a pruned set of results, the pruning including for each data segment of the plurality of data segments:
- generating one or more parent segments for the respective data segment, wherein the data segment includes a plurality of dimensions and each parent segment removes a different dimension of the plurality of dimensions,
- calculating a range of growth for the respective data segment and a range of growth by each of the parent segments,
- comparing the growth of the respective data segment and the range of growth by each of the parent segments, and
- selecting the respective data segment based on the comparison;
- generating an output table based on the pruned set of results.
5 more elements
A machine-storage medium embodying instructions that, when executed by a machine, cause the machine to perform operations comprising:
- detecting a change in metric representative of a key performance indicator in a network-based data system;
- executing an input query to identify a root cause for the detected change generating an initial set of results including a plurality of data segments based on the detected change;
- pruning the initial set of results to generate a pruned set of results, the pruning including for each data segment of the plurality of data segments:
- generating one or more parent segments for the respective data segment, wherein the data segment includes a plurality of dimensions and each parent segment removes a different dimension of the plurality of dimensions,
- calculating a range of growth for the respective data segment and a range of growth by each of the parent segments,
- comparing the growth of the respective data segment and the range of growth by each of the parent segments, and
- selecting the respective data segment based on the comparison;
- generating an output table based on the pruned set of results.
5 more elements
A system comprising:
- at least one hardware processor;
- and
- at least one memory storing instructions that, when executed by the at least one hardware processor, cause the at least one hardware processor to perform operations comprising:
- detecting a change in metric representative of a key performance indicator in a network-based data system;
- executing an input query to identify a root cause for the detected change generating an initial set of results including a plurality of data segments based on the detected change;
- pruning the initial set of results to generate a pruned set of results, the pruning including for each data segment of the plurality of data segments:
- generating one or more parent segments for the respective data segment, wherein the data segment includes a plurality of dimensions and each parent segment removes a different dimension of the plurality of dimensions,
- calculating a range of growth for the respective data segment and a range of growth by each of the parent segments,
- comparing the growth of the respective data segment and the range of growth by each of the parent segments, and
- selecting the respective data segment based on the comparison;
- generating an output table based on the pruned set of results.
8 more elements
Dependencies are inferred from the claim text.