Unified Cardinality Estimation via Hash Buckets

Resolve Bottlenecks,
Find Innovative Solutions
Generate Solutions

Solution Overview

Problem

Traditional methods for estimating cardinality in big data are inefficient, requiring excessive computing resources and time, and are inaccurate across the full spectrum of cardinality values, necessitating multiple operations to compensate for inaccuracies.

Innovation Solution

The implementation of a full-spectrum cardinality estimation system that uses a single function to process compound data objects, generating hash values and populating buckets to determine unique objects, eliminating the need for subsequent processes and reducing overall computing cycles and processing times.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Measurement precision

If traditional linear-time methods are used to identify cardinality, then accuracy is maintained, but computing resources and processing time increase tremendously

Engineering Contradiction:
Improvecardinality estimation accuracyVSAvoidprocessing speed
Core Design Contradiction:
Measurement precisionVSProductivity

Solution Approach 1:

The patent replaces traditional mechanical linear-time comparison methods with a probabilistic hashing system. Instead of comparing data elements one-by-one, the system uses hash functions to transform data into fixed-size representations, enabling parallel processing and significantly reducing computational complexity while maintaining acceptable accuracy through statistical estimation.

Inventive Principle:
Principle #28Mechanics substitution (Replace mechanical system)

Solution Approach 2:

The patent changes the fundamental parameter of measurement from exact counting to probabilistic estimation. By accepting approximate results within a confidence interval, the system can use randomized algorithms and sampling techniques that require far fewer computational resources than exhaustive linear scanning, thus improving processing speed while maintaining sufficient measurement precision for practical applications.

Inventive Principle:
Principle #35Parameter changes

2Productivity

If newer approximation methods are used to reduce computing resources, then processing time decreases, but accuracy deteriorates for low-range and full-spectrum cardinalities

Engineering Contradiction:
Improveprocessing efficiencyVSAvoidcardinality estimation accuracy
Core Design Contradiction:
ProductivityVSMeasurement precision

Solution Approach 1:

The patent creates a universal cardinality estimation system that handles the full spectrum of cardinality ranges (low, mid, and high) through a single integrated approach. The system uses multiple data structures with different characteristics and automatically selects or combines them based on the observed data distribution, enabling accurate estimation across all ranges without requiring separate specialized algorithms for each cardinality regime.

Inventive Principle:
Principle #6Universality (Multi-functionality)

Solution Approach 2:

The patent employs a composite estimation approach that combines multiple data structures and estimation techniques into a unified system. By integrating different probabilistic counting methods and selecting the most appropriate one based on data characteristics, the system achieves robust accuracy across the full spectrum of cardinalities while maintaining high processing efficiency, similar to how composite materials combine different properties to achieve superior overall performance.

Inventive Principle:
Principle #40Composite materials

3Measurement precision

If successive operations are executed to compensate for inaccuracies, then measurement precision improves, but device complexity and processing time increase

Engineering Contradiction:
Improvecardinality estimation accuracyVSAvoidsystem operational complexity
Core Design Contradiction:
Measurement precisionVSDevice complexity

Solution Approach 1:

The patent performs preliminary analysis of data characteristics during the initial processing phase, such as estimating the scale and distribution of cardinalities. Based on this preliminary information, the system pre-selects the most appropriate data structures and estimation parameters, avoiding the need for multiple successive correction operations. This upfront preparation simplifies the overall system complexity while maintaining high accuracy.

Inventive Principle:
Principle #10Preliminary action

Solution Approach 2:

The patent incorporates feedback mechanisms that monitor the quality of cardinality estimates in real-time and dynamically adjust processing parameters. When the system detects that current estimation accuracy is insufficient, it automatically refines the estimation by adjusting sampling rates, hash function parameters, or data structure selections, rather than requiring multiple fixed successive operations. This adaptive feedback approach reduces system complexity by eliminating unnecessary operational steps.

Inventive Principle:
Principle #23Feedback

Data Source

PatentUS10983976B2Optimized full-spectrum cardinality estimation based on unified counting and ordering estimation techniques
Publication Date: 2021.04.20 YAHOO ASSETS LLC
  • US10983976B2 patent drawing
  • US10983976B2 patent drawing
  • US10983976B2 patent drawing

AI summary

Systems and methods are disclosed for optimizing full-spectrum cardinality approximations on big data by exploiting an underlying relationship between LogLog counting estimation techniques and order statistics-based estimation techniques. To accomplish the foregoing, a multiset of objects that each corresponds to one of a plurality of objects associated with a resource are obtained by a computing device. A compound data object is populated by the computing device with data that is derived based on generated hash values that correspond to each object in the obtained multiset. The populated compound data object is processed utilizing a processor with a full-spectrum unified estimation operation that can accurately determine a cardinality estimate for the obtained multiset, utilizing considerably less resources when compared to traditional and state of the art techniques. The determination is made by the computing device without the need to employ linear counting for low cardinalities, bias correction operations, or angular correction terms, all while offering decreased memory usage, simpler implementation, improved performance, and comparable or improved accuracy. An estimated number of unique objects in the obtained multiset can be determined by the computing device, and subsequently provided for display, communication to another computing device, or further manipulation.