US 12,292,899 B2
Method for scheduling multi-node cluster of K-DB database, device, and medium thereof
Qili Ren, Jiangsu (CN); Yankui Du, Jiangsu (CN); and Benshuai Wei, Jiangsu (CN)
Assigned to INSPUR SUZHOU INTELLIGENT TECHNOLOGY CO., LTD., Jiangsu (CN)
Appl. No. 18/028,367
Filed by INSPUR SUZHOU INTELLIGENT TECHNOLOGY CO., LTD., Jiangsu (CN)
PCT Filed Sep. 29, 2021, PCT No. PCT/CN2021/121916
§ 371(c)(1), (2) Date Mar. 24, 2023,
PCT Pub. No. WO2022/134727, PCT Pub. Date Jun. 30, 2022.
Claims priority of application No. 202011554037.0 (CN), filed on Dec. 24, 2020.
Prior Publication US 2024/0311391 A1, Sep. 19, 2024
Int. Cl. G06F 16/27 (2019.01); G06F 9/48 (2006.01)
CPC G06F 16/27 (2019.01) [G06F 9/4881 (2013.01)] 20 Claims
OG exemplary drawing
 
1. A method for scheduling a multi-node cluster of K-DB database, comprising following steps:
connecting an application terminal and a scheduler to a cluster of a K-DB database through a service extranet, and connecting respective database nodes in the cluster of the database to each other through an intranet;
in response to that an application request is received by the scheduler, determining whether the request is a table query, and in response to that the request is the table query, determining whether the request is a multi-table-joint query;
in response to that the request is the multi-table-joint query, determining tables to be queried in the request, and determining respective database nodes having a highest table version;
determining types of change values of the respective tables according to types of latest-update operations of the respective tables, and calculating amount of updated data of the respective tables according to the types of the change values; and
selecting a database node, the amount of updated data of which is the smallest, from the respective database nodes having the highest table version, as a computing node, synchronizing the tables of other database nodes having the highest table version to the computing node, and executing the multi-table-joint query by the computing node,
wherein the determining the respective database nodes having the highest table version, comprises: obtaining a version number of the table from information recorded in the scheduler, wherein each time a modifying operation is performed on the data of the table, the version of the table is added by one.