Multi-party Data Joint Query Method for Secure Distributed Analysis
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
As data sharing between enterprises increases, existing query methods face challenges in maintaining data security while ensuring query efficiency, with response times lengthening as data volume grows.
Innovation Solution
A multi-party data joint query method that analyzes a joint query sentence to generate a logical execution plan, optimizes it, and converts it into a physical execution plan for each provider, allowing cooperative data querying while protecting metadata security.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Productivity
If data sharing between enterprises is increased to improve query efficiency, then productivity improves, but data security deteriorates
Solution Approach 1:
The patent segments the data query process into multiple independent nodes distributed across different enterprises. Each node processes local data independently and returns results, avoiding centralized data collection. This segmentation enables multi-party joint querying while maintaining data security, as no single enterprise gains access to complete sensitive datasets from all parties.
2Productivity
If data volume is increased to improve analysis capability, then productivity improves, but response time increases
Solution Approach 1:
The patent divides large-scale data analysis into segmented query operations across multiple nodes. Each node processes a portion of the data locally and returns results independently, enabling parallel processing. This approach maintains high analysis capability by leveraging distributed data volumes while reducing overall response time through concurrent execution rather than sequential centralized processing.
Solution Approach 2:
The patent implements partial action by allowing each node to process and return results for its local data portion independently, rather than waiting for complete data aggregation. This enables earlier partial results to be obtained and utilized, improving response time while maintaining the ability to perform comprehensive analysis across all distributed data nodes.
Data Source
AI summary
The present disclosure provides a multi-party data joint query method, a device, a server and a storage medium. The multi-party data joint query method executed by a manager includes: analyzing a multi-party joint query sentence to obtain a logical execution plan; processing the logical execution plan according to providers of respective nodes in the logical execution plan to obtain a physical execution plan of each provider; and generating a query instruction of each provider according to the physical execution plan of each provider, and sending the query instruction to respective provider. The query instruction is configured to instruct the providers to perform a query cooperatively.