Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Multi-party data joint query method and device, server and storage medium

A technology of data federation and query method, applied in the field of data processing, can solve problems such as slow query response time

Pending Publication Date: 2020-07-07
BAIDU ONLINE NETWORK TECH (BEIJIBG) CO LTD
View PDF7 Cites 8 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, under the premise of ensuring the security of the query data, the existing traditional query methods will continue to reduce the query efficiency as the amount of data increases, and the query response time will become slower and slower, which urgently needs to be improved.

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Multi-party data joint query method and device, server and storage medium
  • Multi-party data joint query method and device, server and storage medium
  • Multi-party data joint query method and device, server and storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0038] Figure 2A It is a flow chart of a multi-party data joint query method provided in Embodiment 1 of the present invention, Figure 2B A schematic diagram of a logical execution plan obtained by parsing the multi-party joint query statement provided in Embodiment 1 of the present invention; Figure 2C A schematic diagram of an optimized logic execution plan provided by Embodiment 1 of the present invention. This embodiment is applicable to the case of performing joint query on multi-party data, for example, the case of performing joint query on multi-party private data. The method can be executed by the management party's multi-party data joint query device or server provided by the embodiment of the present invention, and the device can be implemented by means of hardware and / or software. Among them, the management party can be a management party server that provides data query services, which can generate data query instructions for different data providers after anal...

Embodiment 2

[0057] Figure 3A It is a flowchart of a multi-party data joint query method provided in Embodiment 2 of the present invention, and 3B is a schematic diagram of a physical execution plan marked with an operator tag type provided in Embodiment 2 of the present invention. The method is further optimized on the basis of the above-mentioned embodiments, and specifically provides an introduction of obtaining the physical execution plan of each provider by processing according to the provider to which each node in the logical execution plan belongs. Such as Figure 3A-3B As shown, the method may include:

[0058] S301. Analyze the multi-party joint query statement to obtain a logical execution plan.

[0059] S302. Generate physical execution plans of each provider respectively according to the logical execution plan.

[0060] Exemplarily, according to the logical execution plan, generating the physical execution plan of each provider may be: according to the logical execution pla...

Embodiment 3

[0071] Figure 4 It is a flow chart of a multi-party data joint query method provided by Embodiment 3 of the present invention. This embodiment can be applied to after the management party in each of the above embodiments generates a query instruction of the provider and sends it to each provider, each provider How the party performs data query according to the received query instruction. The method can be executed by the provider's multi-party data joint query device or server provided in the embodiment of the present invention, and the device can be implemented in the form of hardware and / or software. Such as Figure 4 As shown, it specifically includes the following steps:

[0072] S401. Receive the query instruction from the local provider issued by the management party, wherein the query instruction is determined by the management party in the following manner: analyze the multi-party joint query statement to obtain a logical execution plan; process according to the pro...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

The embodiment of the invention discloses a multi-party data joint query method and device, a server and a storage medium. The multi-party data joint query method executed by a management party comprises: analyzing a multi-party joint query statement to obtain a logic execution plan; processing according to a provider to which each node belongs in the logic 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 each provider, the query instruction being used for indicating each provider to cooperatively perform query. According to the technical scheme of the embodiment of the invention, the multi-party computing method for protecting the data security of the provider is realized, and the data query efficiency is improved on the premise of ensuring the security of the query data.

Description

technical field [0001] The embodiments of the present invention relate to the technical field of data processing, and in particular to a multi-party data joint query method, device, server and storage medium. Background technique [0002] With the rapid development of Internet technology, enterprises need to share data. Usually, the data shared between enterprises is very important data, such as user ID card information, mobile phone number and bank card number. Therefore, it is very important to protect the security of query data while querying shared data between enterprises. However, under the premise of ensuring the security of the query data, the existing traditional query methods will continue to reduce the query efficiency as the amount of data increases, and the query response time will become slower and slower, which urgently needs to be improved. Contents of the invention [0003] The embodiment of the present invention provides a multi-party data joint query m...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
IPC IPC(8): G06F16/2453G06F16/2455G06F21/62
CPCG06F21/6227G06F16/2453G06F16/24542G06F16/2471G06F16/2282G06F16/244G06F16/24554
Inventor 冯智张宇张森
Owner BAIDU ONLINE NETWORK TECH (BEIJIBG) CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products