Encrypted Table Query Partitioning Against Frequency Analysis

Resolve Bottlenecks,
Find Innovative Solutions
Generate Solutions

Solution Overview

Problem

Existing data table query methods using deterministic encryption are vulnerable to frequency analysis attacks, leading to potential leaks of plaintext data due to the exposure of encrypted data frequency statistics.

Innovation Solution

The method involves converting a data table query request into multiple sub-table query requests, randomly transmitting these requests to a server, and generating query results that obscure statistical analysis, thereby obfuscating the frequency of encrypted data appearance.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Reliability

If deterministic encryption algorithm is used to encrypt data in data table, then data security is improved, but frequency analysis attack vulnerability increases

Engineering Contradiction:
Improvedata securityVSAvoidfrequency analysis attack vulnerability
Core Design Contradiction:
ReliabilityVSObject-affected harmful factors

Solution Approach 1:

The patent divides the data table into multiple data sub-tables based on attribute values, and sends multiple query requests to query these sub-tables. This segmentation approach prevents frequency analysis attacks by distributing data across multiple tables, making it difficult for attackers to analyze frequency patterns of encrypted data.

Inventive Principle:
Principle #1Segmentation

Solution Approach 2:

The patent introduces a random number generator as an intermediary to generate random numbers for obfuscating query request transmission sequences and query result transmission sequences. This intermediary mechanism prevents attackers from predicting the order of data transmission, thereby mitigating frequency analysis attacks while maintaining data security.

Inventive Principle:
Principle #24Intermediary (Mediator)

2Productivity

If hash-join method is used to query data in multiple data tables, then query efficiency is improved, but frequency information leakage increases

Engineering Contradiction:
Improvequery efficiencyVSAvoidfrequency information leakage
Core Design Contradiction:
ProductivityVSLoss of information

Solution Approach 1:

The patent segments the data tables into multiple sub-tables and queries them separately using multiple query requests. This segmentation prevents frequency information leakage while maintaining query efficiency by processing data in smaller, manageable units rather than joining entire tables.

Inventive Principle:
Principle #1Segmentation

Solution Approach 2:

The patent creates multiple copies of query requests with different transmission sequences and sends them to query the data sub-tables. These copies include random obfuscation that prevents frequency analysis while ensuring all necessary data is retrieved for accurate query results.

Inventive Principle:
Principle #26Copying

3Reliability

If multiple query requests are sent to query data sub-tables, then query completeness is improved, but transmission sequence predictability increases

Engineering Contradiction:
Improvequery completenessVSAvoidtransmission sequence predictability
Core Design Contradiction:
ReliabilityVSObject-affected harmful factors

Solution Approach 1:

The patent dynamically generates random numbers for each query request transmission sequence using a random number generator. This dynamic approach ensures that the transmission sequence is unpredictable and changes with each query operation, preventing frequency analysis attacks while maintaining query completeness.

Inventive Principle:
Principle #15Dynamics

Solution Approach 2:

The patent uses a random number generator as an intermediary to introduce randomness into the query request transmission sequences. This intermediary mechanism ensures that even though multiple queries are sent, their sequences remain unpredictable and cannot be used for frequency analysis.

Inventive Principle:
Principle #24Intermediary (Mediator)

Data Source

PatentUS20250355854A1Method for querying a data table and apparatus, storage medium, and electronic device
Publication Date: 2025.11.20 TENCENT TECHNOLOGY (SHENZHEN) CO LTD
  • US20250355854A1 patent drawing
  • US20250355854A1 patent drawing
  • US20250355854A1 patent drawing

AI summary

This application discloses a method for querying a data table. The method includes acquiring a data table query request to query a second data table on a server for attribute values of a second attribute matching attribute values of a first attribute in a first data table on the server; converting the data table query request into a first group of data sub-table query requests requesting to query a second group of data sub-tables for attribute values of the second attribute matching attribute values of the first attribute in a first group of data sub-tables; generating a second group of data sub-table query requests; and transmitting the first group of data sub-table query requests and the second group of data sub-table query requests to the server, and acquiring a first group of query results and a second group of query results from the server.