Quantile Data Sketches Using Compactor Hierarchy for Frequent Items

Resolve Bottlenecks,
Find Innovative Solutions
Generate Solutions

Solution Overview

Problem

Existing data sketching methods are suboptimal for processing streams containing frequent items and queries for quantiles, particularly in i.i.d. streams and tail quantiles, due to inefficient use of memory and error guarantees.

Innovation Solution

A compactor hierarchy-based data sketching method that aggregates data items across multiple levels, prioritizing frequent items and using weighted compaction to accurately estimate frequent item proportions while minimizing error for non-frequent items, allowing for efficient rank estimation and quantile computation.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Measurement precision

If KLL sketch is used for quantile computation, then space complexity matches the lower bound, but performance is suboptimal for streams containing frequent items and tail quantiles

Engineering Contradiction:
Improvequantile estimation accuracyVSAvoidprocessing efficiency for frequent items
Core Design Contradiction:
Measurement precisionVSProductivity

Solution Approach 1:

The patent segments the data stream processing into two distinct components: a frequent items sketch (Flux) that专门 handles frequent items, and a quantile sketch (KLL) that handles the rest of the data. This segmentation allows each component to be optimized for its specific function, resolving the contradiction by improving processing efficiency for frequent items while maintaining quantile estimation accuracy.

Inventive Principle:
Principle #1Segmentation

Solution Approach 2:

The patent dynamically adjusts the behavior of the system based on item frequency. By identifying frequent items and routing them through a specialized flux sketch while sending other items to the KLL sketch, the system adapts its processing path in real-time, improving overall productivity without sacrificing measurement precision.

Inventive Principle:
Principle #15Dynamics

2Measurement precision

If more memory is allocated for data sketching, then approximation error decreases, but memory space consumption increases

Engineering Contradiction:
Improveapproximation errorVSAvoidmemory space
Core Design Contradiction:
Measurement precisionVSQuantity of substance

Solution Approach 1:

The patent applies partial action by allocating memory resources selectively rather than uniformly. Instead of increasing memory for all data items, it focuses memory allocation on the flux sketch for frequent items and the KLL sketch for other items, achieving the required approximation error with minimal total memory consumption.

Inventive Principle:
Principle #16Partial or excessive action

Solution Approach 2:

The patent changes the parameter of memory allocation by introducing a frequency-based threshold that determines how memory is distributed. Frequent items receive dedicated memory in the flux sketch, while less frequent items use the KLL sketch's compressed representation, optimizing the balance between approximation error and memory usage.

Inventive Principle:
Principle #35Parameter changes

3Adaptability or versatility

If traditional sampling methods are used, then many questions about original data can be answered, but far more space is required to achieve the same approximation error

Engineering Contradiction:
Improvequery capabilityVSAvoidmemory space
Core Design Contradiction:
Adaptability or versatilityVSQuantity of substance

Solution Approach 1:

The patent segments the data processing into two specialized sketches: Flux for frequent items and KLL for other items. This segmentation maintains versatility in answering different types of queries while significantly reducing the total memory space required compared to traditional uniform sampling methods.

Inventive Principle:
Principle #1Segmentation

Solution Approach 2:

The patent changes the sampling parameter by applying frequency-based differentiation. Instead of uniform sampling across all data, it uses adaptive sampling where frequent items are tracked with higher precision in the flux sketch, allowing versatile query capabilities with reduced memory requirements.

Inventive Principle:
Principle #35Parameter changes

Data Source

PatentUS11403302B1Quantile data sketches based on frequent data items
Publication Date: 2022.08.02 TABLEAU SOFTWARE INC
  • US11403302B1 patent drawing
  • US11403302B1 patent drawing
  • US11403302B1 patent drawing

AI summary

Data items are aggregated in a quantile sketch according to a compactor hierarchy. A first number of data items are stored in a first buffer corresponding to a first (i.e., lowest) compaction level of the compactor hierarchy, and a top level number of data items are stored in a top buffer corresponding to a top compaction level of the compactor hierarchy. For a first subset of the first number of data items, each data item is already stored in the top buffer, and a weight of the respective data item stored in the top buffer is increased by 1. For a second subset of the first number of data items, each data item does not match any data item stored in the top buffer, and a second number of data items are selected from the second subset and stored in a second buffer of a second compaction level.