US 12,248,478 B2
Method and apparatus for federated data query, electronic device, and computer-readable storage medium
Xiaoliang Fan, Shenzhen (CN); Jie Jiang, Shenzhen (CN); Yong Cheng, Shenzhen (CN); Chen Hou, Shenzhen (CN); Yuhong Liu, Shenzhen (CN); Peng Chen, Shenzhen (CN); and Yangyu Tao, Shenzhen (CN)
Assigned to TENCENT TECHNOLOGY (SHENZHEN) COMPANY LIMITED, Shenzhen (CN)
Filed by TENCENT TECHNOLOGY (SHENZHEN) COMPANY LIMITED, Shenzhen (CN)
Filed on Jun. 15, 2023, as Appl. No. 18/335,424.
Application 18/335,424 is a continuation of application No. PCT/CN2022/107690, filed on Jul. 25, 2022.
Claims priority of application No. 202110994560.3 (CN), filed on Aug. 27, 2021.
Prior Publication US 2023/0325389 A1, Oct. 12, 2023
Int. Cl. G06F 16/248 (2019.01); G06F 16/2453 (2019.01); G06F 16/2455 (2019.01); H04L 9/32 (2006.01)
CPC G06F 16/24558 (2019.01) [G06F 16/24537 (2019.01); G06F 16/24542 (2019.01); G06F 16/248 (2019.01); H04L 9/32 (2013.01)] 15 Claims
OG exemplary drawing
 
1. A method for federated data query, executed by a first electronic device and comprising:
using, by the first electronic device, a joint query statement corresponding to a federated data query to obtain at least one operator containing a joint query operator, comprising:
parsing the joint query statement to obtain a syntax relation structure; and
determining, according to the syntax relation structure, a substructure corresponding to a preset joint operational character and a preset screening key character as the joint query operator;
obtaining, from a preset metadatabase containing operation permissions of records of data tables previously registered by the first electronic device, a preset data table permission corresponding to a first data table name according to the first data table name corresponding to the preset joint operational character in the joint query operator; the first data table name being a table name of a first data table of the first electronic device, and the preset data table permission indicating whether data content corresponding to the first data table name is allowed to participate in federated data queries;
obtaining, from the preset metadatabase, a preset field permission corresponding to a first intersecting field name according to the first intersecting field name contained in an equi-join condition corresponding to the preset screening key character, the preset field permission indicating whether data content corresponding to the first intersecting field name is allowed to participate in federated data queries;
in response to that at least one of the preset data table permission or the preset field permission does not meet a preset joint query permission condition, generating a warning and ending execution of the joint query operator;
in response to that both the preset data table permission and the preset field permission meet the preset joint query permission condition, transforming the joint query operator to a first joint security operator;
determining first data for intersection on the first electronic device by executing the first joint security operator;
receiving second data for intersection from a second electronic device involved in the federated data query;
performing joint computing on the first data for intersection and the second data for intersection in a form of a ciphertext to obtain a joint data table; and
determining a federated data query result corresponding to the at least one operator based on the joint data table.