Multi-platform data synchronization method and system based on multi-link and dynamic regulation and control strategy

Through the data synchronization method of multi-link and dynamic regulation strategies, the problems of network reliability and policy rigidity in traditional technologies are solved, high availability and flexible cross-platform data transmission are achieved, and operation and maintenance complexity and cost are reduced.

CN120434259AInactive Publication Date: 2025-08-05LICHU BUSINESS
View PDF 5 Cites 0 Cited by

Patent Information

Application Number
CN202510935044.1
Authority / Receiving Office
CN · China
Patent Type
Applications(China)
Current Assignee / Owner
Filing Date
2025-07-08
Publication Date
2025-08-05
Estimated Expiration
Not applicable · inactive patent

AI Technical Summary

Technical Problem

Traditional data synchronization technology faces insufficient network reliability and rigid policy defects, resulting in data loss, synchronization delay and repeated adaptation development.

Method used

Using multi-link and dynamic regulation strategies, by configuring the Appkey of the terminal platform and TempNo of the data push template on the central platform, executable SQL query statements are generated, dynamically selecting the communication link for data transmission, and multiple data push templates are configured to meet the needs of different platforms.

Benefits of technology

It realizes high availability at the network level and flexibility of cross-platform data transmission, reduces the cost of data loss and repeated adaptation development, and improves the availability and operation and maintenance efficiency of the system.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN120434259A_ABST
    Figure CN120434259A_ABST
Patent Text Reader

Abstract

The invention provides a multi-platform data synchronization method and system based on multiple links and a dynamic regulation and control strategy. The method comprises the following steps: configuring an Appkey of each terminal platform and TempNo of each data push template on a central platform; the method comprises the following steps: receiving a combination key of Appkey and TempNo reported by a terminal platform, retrieving a corresponding data push template in a rule template library according to TempNo, injecting characteristic parameters of the terminal platform into an SQL query statement template defined in the data push template, generating an executable SQL query statement, executing to obtain original data to generate a synchronous data packet, and sending the synchronous data packet to the terminal platform; and the corresponding communication link is dynamically selected to push the synchronous data packet to the corresponding terminal platform. According to the invention, a multi-communication-link parallel transmission and intelligent preferential selection mechanism is established, so that high availability of the network layer is ensured; and a plurality of data pushing templates are configured to be bound with the terminal platform, so that cross-platform data transmission can be realized.
Need to check novelty before this filing date? Find Prior Art

Description

Technical Field

[0001] The present invention relates to the field of communications, and more specifically, to a multi-platform data synchronization method and system based on multiple links and dynamic control strategies. Background Art

[0002] With the surge in demand for data interaction between distributed systems and multiple platforms, traditional data synchronization technologies face two core challenges: Insufficient network reliability: Synchronization mechanisms that rely on a single communication link (such as HTTP persistent connections) are prone to data loss and synchronization delays when experiencing network jitter, congestion, or link failures, seriously impacting system availability.

[0003] Strategy rigidity flaw: Fixed data synchronization strategies (such as full polling and static priority scheduling) are difficult to adapt to the differentiated requirements of different platforms for data format, synchronization frequency, field filtering, etc., forcing developers to frequently customize and develop adaptation modules, significantly increasing R&D costs and operation and maintenance complexity. Summary of the Invention

[0004] In response to the technical problems existing in the prior art, the present invention provides a multi-platform data synchronization method and system based on multi-link and dynamic control strategies, which can solve the synchronization interruption and data integrity problems caused by network fluctuations and single point failures, and eliminate the problem of repeated adaptation and development caused by platform differences.

[0005] According to a first aspect of the present invention, a multi-platform data synchronization method based on multiple links and dynamic control strategies is provided, comprising: Configure the unique identifier Appkey for each terminal platform and the unique identifier TempNo for each data push template on the central platform; Receive the combination key of Appkey and TempNo reported by any terminal platform, and retrieve the corresponding data push template in the rule template library according to TempNo in the combination key, wherein the data push template defines an SQL query statement template; Injecting characteristic parameters of the terminal platform into the SQL query statement template to generate an executable SQL query statement; Execute the generated SQL query statement to obtain original data, process the fields in the original data according to the processing rules, and generate a synchronization data packet based on the processed fields; Pushing the synchronization data packet to the terminal platform corresponding to the Appkey in the combination key through a communication link; There are multiple communication links. When pushing the synchronization data packet to the terminal platform, a corresponding communication link is selected according to a dynamic selection strategy, and the synchronization data packet is pushed to the terminal platform through the selected communication link.

[0006] According to a second aspect of the present invention, there is provided a multi-platform data synchronization system based on multi-links and dynamic control strategies, comprising a central platform and multiple terminal platforms; The central platform includes: Configuration module, used to configure the unique identifier Appkey of each terminal platform and the unique identifier TempNo of each data push template; A retrieval module is configured to receive a combination of AppKey and TempNo reported by any terminal platform, and retrieve a corresponding data push template in a rule template library according to TempNo in the combination key, wherein the data push template defines an SQL query statement template; A generation module, configured to inject characteristic parameters of the terminal platform into the SQL query statement template to generate an executable SQL query statement; An execution module, configured to execute the generated SQL query statement, obtain raw data, process fields in the raw data according to processing rules, and generate a synchronization data packet based on the processed fields; A push module, configured to push the synchronization data packet to the terminal platform corresponding to the AppKey in the combination key through a communication link; There are multiple communication links. When pushing the synchronization data packet to the terminal platform, a corresponding communication link is selected according to a dynamic selection strategy, and the synchronization data packet is pushed to the terminal platform through the selected communication link.

[0007] The present invention provides a multi-platform data synchronization method and system based on multi-link and dynamic control strategies. The method and system configure the Appkey of each terminal platform and the TempNo of each data push template on the central platform; receive the combination key of Appkey and TempNo reported by the terminal platform, retrieve the corresponding data push template in the rule template library according to TempNo, inject the characteristic parameters of the terminal platform into the SQL query statement template defined in the data push template, generate an executable SQL query statement, execute the query statement to obtain the original data to generate a synchronization data packet, and dynamically select the corresponding communication link to push the synchronization data packet to the corresponding terminal platform. The present invention establishes a multi-communication link parallel transmission and intelligent optimization mechanism to ensure high availability of the network layer; and configures multiple data push templates to be bound to the terminal platform to realize cross-platform data transmission. BRIEF DESCRIPTION OF THE DRAWINGS

[0008] Figure 1 A flowchart of a multi-platform data synchronization method based on multi-links and dynamic control strategies provided by an embodiment of the present invention; Figure 2 Schematic diagram of data interaction of a multi-platform data synchronization method based on multi-links and dynamic control strategy according to an embodiment of the present invention; Figure 3 A structural diagram of a multi-platform data synchronization system based on multiple links and dynamic control strategies provided by an embodiment of the present invention. DETAILED DESCRIPTION

[0009] In order to make the purpose, technical solutions and advantages of the embodiments of the present invention clearer, the technical solutions in the embodiments of the present invention will be clearly and completely described below in conjunction with the drawings in the embodiments of the present invention. Obviously, the described embodiments are part of the embodiments of the present invention, not all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without making creative work are within the scope of protection of the present invention. In addition, the technical features in the various embodiments or single embodiments provided by the present invention can be arbitrarily combined with each other to form a feasible technical solution. This combination is not restricted by the sequence of steps and / or structural composition mode, but must be based on the ability of ordinary technicians in this field to implement it. When the combination of technical solutions is contradictory or cannot be implemented, it should be deemed that such a combination of technical solutions does not exist and is not within the scope of protection required by the present invention.

[0010] Figure 1 The present invention provides a multi-platform data synchronization method based on multi-link and dynamic control strategy flow chart, such as Figure 1 As shown, the method includes: Step 1: Configure the unique identifier Appkey of each terminal platform and the unique identifier TempNo of each data push template on the central platform.

[0011] It is understandable that the embodiment of the present invention includes a central platform and multiple terminal platforms. Each terminal platform communicates with the central platform in a two-way manner. The central platform is mainly used to manage the multiple terminal platforms.

[0012] Specifically, unique identification information of each terminal platform is created on the central platform, and a 16-bit Appkey is generated to represent the identification information of the terminal platform.

[0013] AppKey is created by the central platform and is generated according to the following rules: year, month, day + four-digit random string + daily reset auto-increment number (yyyyMMddxxxx0001, yyyyMMddxxxx0002...).

[0014] Create a data push template on the central platform and configure the unique identification information TempNo for each data push template. In the embodiment of the present invention, the TempNo configured by the central platform for each data push template is 32 bits. Each data push template defines a dynamic SQL query statement template.

[0015] In an embodiment of the present invention, a terminal platform and a data push template can be bound. One terminal platform can be bound to multiple data push templates. One data push template can be bound to multiple terminal platforms, thus realizing arbitrary binding between terminal platforms and data push templates.

[0016] Step 2: Receive the combination key of Appkey and TempNo reported by any terminal platform, and retrieve the corresponding data push template in the rule template library according to TempNo in the combination key, wherein the data push template defines an SQL query statement template.

[0017] It is understood that the central platform receives the AppKey and TempNo combination key and the characteristic parameters of each terminal platform reported by each terminal platform. Based on the TempNo identification information of the data push template in the combination key, the central platform retrieves the corresponding data push template from the rule template library and obtains the SQL query statement template defined in the data push template. For example, the SQL query statement template is SELECT {fields} FROM {table} WHERE update_time > {last_sync_time}.

[0018] Step 3: Inject the characteristic parameters of the terminal platform into the SQL query statement template to generate an executable SQL query statement.

[0019] It is understandable that after finding the SQL query statement template in the rule template library, the terminal platform characteristic parameters (such as the field name to be filtered in fields and the source data table name corresponding to table) are injected into the template to generate executable differentiated SQL statements.

[0020] Example: When AppKey=CRM, TempNo=T002, the parsing template generates: Sql- SELECT user_id, order_amount@mask, address FROM crm_orders WHERE update_time > '2024-02-20 14:00:00' Step 4: execute the generated SQL query statement to obtain original data, process the fields in the original data according to the processing rules, and generate a synchronization data packet based on the processed fields.

[0021] It is understandable that when executing the generated executable SQL query statement and querying the original data from the database, the fields of the queried original data need to be processed. For example, if sensitive information is involved, the AES-256 encryption algorithm is used for processing.

[0022] Different terminal platforms may require different formats. Therefore, the original data format needs to be converted to the format required by the target terminal platform according to the requirements of the terminal platform. For example, e-commerce platforms require JSON nested structures, and ERP systems require XML flattening. After the central platform obtains the data required by the target terminal platform, it converts the data into JSON / XML format. Then, based on the processed data fields, a synchronization data packet is generated and a metadata header is attached. For example: Json- { "header": { "app_key": "CRM", "temp_no": "T002", "seq_id": "20240220140300_001" }, "body": [ {"user_id": 1001, "order_amount": "ENC(7xTq...)", "address": "XX CityXX District"} ] } Step 5: Push the synchronization data packet to the terminal platform corresponding to the Appkey in the combination key through a communication link.

[0023] It is understandable that after a synchronization data packet is generated according to the retrieved data field, the synchronization data packet is pushed to the target terminal platform via a communication link.

[0024] There are multiple communication links. When pushing the synchronization data packet to the terminal platform, a corresponding communication link is selected according to a dynamic selection strategy, and the synchronization data packet is pushed to the terminal platform through the selected communication link.

[0025] In some embodiments of the present invention, pushing the synchronization data packet to the terminal platform corresponding to the AppKey in the combination key via a communication link further includes: The abnormality type in the transmission process of pushing the synchronization data packet to the terminal platform is monitored.

[0026] It is understandable that when the central platform pushes the generated synchronization data packet to the target terminal platform, various abnormal situations may occur during the transmission process. The embodiment of the present invention takes corresponding measures according to different abnormality types, mainly including the following abnormality types: If the current communication link times out continuously for a predetermined number of times, switching to another communication link to transmit the synchronization data packet; If the terminal platform returns a message that the data verification fails, the abnormal data packet is cached locally on the central platform; If the calling frequency of the terminal platform exceeds the preset frequency, the calling frequency of the terminal platform is reduced.

[0027] Specifically, during the synchronous data packet transmission process, abnormal situations will be monitored in real time, and different abnormality types will be monitored. The different abnormality types are shown in Table 1: Table 1 Exception types and strategies adopted .

[0028] For abnormal data packets, the abnormal data packets are written to the local transaction log table, and the key status information of each abnormal data packet is recorded as follows: Sql- INSERT INTO sync_fail_log (seq_id, app_key, temp_no, error_code, raw_data, retry_count) VALUES ('20240220140300_001', 'CRM', 'T002', 'ERR_NET_TIMEOUT', '0x8A3F...',0) Generate breakpoint identification information for each abnormal data packet, and the structure of the breakpoint identification information is: [AppKey]_[TempNo]_[data generation timestamp]_[number of retries].

[0029] For abnormal data packets, certain strategies are adopted, such as retrying, switching communication links, or splitting transmission methods for retransmission.

[0030] In some embodiments of the present invention, taking corresponding measures according to different exception types includes: For the network jitter of the current communication link, retry to transmit the synchronization data packet multiple times, wherein the time interval of the first retry transmission is 2s, and the time interval of each subsequent retry transmission is interval = 2^n + rand(0,1), where n is the number of retry transmissions; For high-priority synchronization data packets, the synchronization data packets are transmitted through all available communication links at the same time. When one of the communication links transmits the synchronization data packet to the terminal platform first, the transmission of other communication links is terminated. When the size of the synchronization data packet exceeds the preset size, the synchronization data packet is divided into multiple data slices, and the multiple data slices are simultaneously transmitted to the terminal platform through different communication links, so that when the terminal platform receives the multiple data slices, the multiple data slices are reassembled after MD5 verification.

[0031] When switching a communication link, the communication link with the highest quality evaluation among multiple communication links is usually selected to transmit data. Specifically, when evaluating the communication quality of each communication link, the following two methods can be used to evaluate the communication quality of each communication link.

[0032] In an embodiment of the present invention, a method for evaluating the communication quality of each communication link is as follows: Real-time monitoring of the quality data of each communication link, including the RTT, packet loss rate and bandwidth utilization of the communication link; The quality score of each communication link is calculated using a weighted scoring algorithm based on the RTT, packet loss rate, and bandwidth occupancy of each communication link. The quality score calculation formula is: Score = 0.6 × (1 / RTT) + 0.3 × (1-packet loss rate) + 0.1 × remaining bandwidth; Switch to the communication link with the highest quality score to transmit the synchronization data packet.

[0033] First, the quality data of each communication link is monitored in real time. The code is as follows: class LinkMonitor: def __init__(self): self.links = { "link1": {"type": "5G", "ip": "192.168.1.1"}, "link2": {"type": "Wi-Fi", "ip": "192.168.1.2"} } def collect_metrics(self): for link in self.links: # Measuring RTT using ICMP / TCP ping rtt = self._ping_test(link["ip"]) # Test the packet loss rate by sending packets (send 100 1KB test packets) loss_rate = self._packet_loss_test(link["ip"], packets=100) # Get the remaining bandwidth (link device must support SNMP) bandwidth = self._get_available_bandwidth(link["ip"]) link["metrics"] = { "rtt": rtt, # milliseconds "loss_rate": loss_rate, # percentage "bandwidth": bandwidth # Mbps } def _ping_test(self, ip): # Example: Using Python's ping3 library import ping3 return ping3.ping(ip, unit='ms') Dynamic quality assessment and scoring are performed based on the quality data of each communication link. The code is as follows: class LinkEvaluator: def calculate_score(self, link_metrics, data_priority="NORMAL"): # Dynamic weight configuration weights = { "5G": {"rtt": 0.5, "loss": 0.3, "bw": 0.2}, "Wi-Fi": {"rtt": 0.4, "loss": 0.4, "bw": 0.2} } # Get the weight corresponding to the link type link_type = link_metrics["type"] w = weights.get(link_type, weights["Wi-Fi"]) # Business Priority Correction if data_priority == "HIGH": w["rtt"] ×= 1.2 # Standardized calculation (RTT is the inverse, packet loss rate is the complement) score = ( w["rtt"] × (1000 / max(1, link_metrics["rtt"])) + w["loss"] × (1 - link_metrics["loss_rate"] / 100) + w["bw"] × (link_metrics["bandwidth"] / 100) ) return score The score of each communication link is calculated by the above method. When multiple communication links can be selected at the same time, the communication link with the highest score can be considered for data transmission.

[0034] Another embodiment of the present invention selects a communication link to be switched. In some embodiments of the present invention, if the number of consecutive timeouts of the current communication link reaches a preset number, switching to another communication link to transmit the synchronization data packet includes: Collect historical quality data of each communication link, including RTT, packet loss rate, and bandwidth occupancy of the communication link; Calculate the quality score of each communication link based on the historical quality data of each communication link; Acquire a training data set, wherein the training data set includes a plurality of samples, each sample including quality data and a quality score of a communication link; Training the link quality prediction model based on the training data set to obtain a trained link quality prediction model; Based on the trained link quality prediction model, the stability of each communication link in the future set time period is predicted; Switch to the communication link with the best stability to transmit the synchronization data packet.

[0035] It is understandable that the quality score of each communication link can be calculated using a calculation formula, or the stability of each communication link in a certain future time period can be predicted using a prediction model based on historical data.

[0036] For example, obtain the quality data and stability of each communication link within the past 10 minutes. Based on the historical data, call the pre-trained LSTM model to predict the future stability of each communication link. The code is as follows: def _predict_stability(self, link): # Call the pre-trained LSTM model to predict future stability # Example: Forecast using historical 10-minute data history = link["history_metrics"][-10:] return lstm_model.predict(history) It is understood that when the central platform pushes synchronization data packets to the target terminal platform, if a transmission anomaly occurs, it can take the various measures mentioned above to handle it, such as retrying, switching communication links, or packet transmission. If data transmission still fails despite multiple retry strategies, manual intervention is required.

[0037] Among them, see Figure 2 The evaluation and switching of communication links can also be implemented by the DB database. For example, when the central platform pushes a synchronization data packet to the target terminal platform, the central platform can notify the DB database of any abnormalities. When the DB database receives the abnormality, it evaluates the communication quality of each communication link and allocates the communication link with better communication quality to transmit data.

[0038] The DB database can also monitor the quality data of each communication link in real time, evaluate the communication quality of each communication link based on the quality data, and then select the communication link with better communication quality for data transmission.

[0039] See also Figure 3 , a multi-platform data synchronization system based on multi-links and dynamic control strategies provided by an embodiment of the present invention, the system includes a central platform 31 and multiple terminal platforms 32; The central platform 31 includes: Configuration module 301, used to configure the unique identifier Appkey of each terminal platform and the unique identifier TempNo of each data push template; The retrieval module 302 is configured to receive a combination of AppKey and TempNo reported by any terminal platform, and retrieve a corresponding data push template in a rule template library according to TempNo in the combination, wherein the data push template defines an SQL query statement template; A generating module 303 is configured to inject characteristic parameters of the terminal platform into the SQL query statement template to generate an executable SQL query statement; An execution module 304 is configured to execute the generated SQL query statement, obtain raw data, process fields in the raw data according to processing rules, and generate a synchronization data packet based on the processed fields; Push module 305, used for pushing the synchronization data packet to the terminal platform corresponding to the Appkey in the combination key through a communication link; There are multiple communication links. When pushing the synchronization data packet to the terminal platform, a corresponding communication link is selected according to a dynamic selection strategy, and the synchronization data packet is pushed to the terminal platform through the selected communication link.

[0040] Among them, the multi-platform data synchronization system based on multi-link and dynamic control strategy provided by the embodiment of the present invention can also include a DB database 33. The DB database 33 can share some tasks of the central platform 301. The DB database 33 can monitor the communication quality of each communication link in real time. If the transmission of the synchronization data packet fails, it will switch to other communication links with better communication quality to retry the transmission of the synchronization data packet.

[0041] It can be understood that the multi-platform data synchronization system based on multi-links and dynamic control strategies provided by the present invention corresponds to the multi-platform data synchronization method based on multi-links and dynamic control strategies provided by the aforementioned embodiments. The relevant technical features of the multi-platform data synchronization system based on multi-links and dynamic control strategies can refer to the relevant technical features of the multi-platform data synchronization method based on multi-links and dynamic control strategies, which will not be repeated here.

[0042] The embodiment of the present invention provides a multi-platform data synchronization method and system based on multi-link and dynamic control strategies. The method configures the Appkey of each terminal platform and the TempNo of each data push template on the central platform; receives the combination key of Appkey and TempNo reported by the terminal platform, retrieves the corresponding data push template in the rule template library according to TempNo, injects the characteristic parameters of the terminal platform into the SQL query statement template defined in the data push template, generates an executable SQL query statement, executes the acquisition of raw data to generate a synchronization data packet, and dynamically selects the corresponding communication link to push the synchronization data packet to the corresponding terminal platform. The present invention establishes a multi-communication link parallel transmission and intelligent optimization mechanism to ensure high availability of the network layer; and configures multiple data push templates to be bound to the terminal platform to realize cross-platform data transmission.

[0043] It should be noted that, in the above embodiments, the description of each embodiment has its own focus. For parts that are not described in detail in a certain embodiment, reference can be made to the relevant description of other embodiments.

[0044] Those skilled in the art will appreciate that embodiments of the present invention may be provided as methods, systems, or computer program products. Thus, the present invention may take the form of an entirely hardware embodiment, an entirely software embodiment, or an embodiment combining software and hardware aspects. Furthermore, the present invention may take the form of a computer program product implemented on one or more computer-usable storage media (including but not limited to magnetic disk storage, CD-ROM, optical storage, etc.) containing computer-usable program code.

[0045] The present invention is described with reference to flowcharts and / or block diagrams of methods, devices (systems), and computer program products according to embodiments of the present invention. It should be understood that each process and / or block in the flowcharts and / or block diagrams, as well as combinations of processes and / or blocks in the flowcharts and / or block diagrams, can be implemented by computer program instructions. These computer program instructions can be provided to a processor of a general-purpose computer, a special-purpose computer, an embedded computer, or other programmable data processing device to produce a machine, so that the instructions executed by the processor of the computer or other programmable data processing device generate instructions for implementing the processes in the flowcharts and / or block diagrams. Figure 1 a process or multiple processes and / or boxes Figure 1 A device that provides the functions specified in a block or multiple blocks.

[0046] These computer program instructions may also be stored in a computer readable memory that can direct a computer or other programmable data processing device to work in a specific manner, so that the instructions stored in the computer readable memory produce an article of manufacture comprising an instruction device, which implements the process Figure 1 a process or multiple processes and / or boxes Figure 1The function specified in one or more boxes.

[0047] These computer program instructions can also be loaded onto a computer or other programmable data processing device so that a series of operational steps are executed on the computer or other programmable device to produce a computer-implemented process, thereby providing the instructions executed on the computer or other programmable device for implementing the process. Figure 1 a process or multiple processes and / or boxes Figure 1 A step that specifies a function in one or more boxes.

[0048] Although the preferred embodiments of the present invention have been described, those skilled in the art may make additional changes and modifications to these embodiments once they have learned the basic creative concept. Therefore, the appended claims are intended to be interpreted as including the preferred embodiments and all changes and modifications that fall within the scope of the present invention.

[0049] Obviously, those skilled in the art may make various changes and modifications to the present invention without departing from the spirit and scope of the present invention. Thus, if such changes and modifications fall within the scope of the claims and their equivalents, the present invention is intended to include such changes and modifications.

Claims

1. A multi-platform data synchronization method based on multi-link and dynamic control strategy, characterized in that: include: Configure the unique identifier Appkey for each terminal platform and the unique identifier TempNo for each data push template on the central platform; Receive the combination key of Appkey and TempNo reported by any terminal platform, and retrieve the corresponding data push template in the rule template library according to TempNo in the combination key, wherein the data push template defines an SQL query statement template; Injecting characteristic parameters of the terminal platform into the SQL query statement template to generate an executable SQL query statement; Execute the generated SQL query statement to obtain original data, process the fields in the original data according to the processing rules, and generate a synchronization data packet based on the processed fields; Pushing the synchronization data packet to the terminal platform corresponding to the Appkey in the combination key through a communication link; There are multiple communication links. When pushing the synchronization data packet to the terminal platform, a corresponding communication link is selected according to a dynamic selection strategy, and the synchronization data packet is pushed to the terminal platform through the selected communication link.

2. The multi-platform data synchronization method according to claim 1, characterized in that: The AppKey and TempNo are in a many-to-many binding relationship.

3. The multi-platform data synchronization method according to claim 1, characterized in that: The step of executing the generated SQL query statement, obtaining raw data, and processing fields in the raw data according to processing rules includes: For sensitive fields, AES-256 encryption algorithm is used; According to the requirements of the terminal platform corresponding to the Appkey, the original data format is converted into the format required by the terminal platform; Generate a synchronization data packet based on the processed data fields.

4. The multi-platform data synchronization method according to claim 1, characterized in that: The step of pushing the synchronization data packet to the terminal platform corresponding to the AppKey in the combination key through a communication link further includes: monitoring anomalies in the transmission process of pushing the synchronization data packet to the terminal platform; Take appropriate measures according to different exception types; The measures taken according to the different types of abnormalities include: If the current communication link times out continuously for a predetermined number of times, switching to another communication link to transmit the synchronization data packet; If the terminal platform returns a message that the data verification fails, the abnormal data packet is cached locally on the central platform; If the calling frequency of the terminal platform exceeds the preset frequency, the calling frequency of the terminal platform is reduced.

5. The multi-platform data synchronization method according to claim 4, characterized in that: When an abnormal situation occurs during the transmission process, the abnormal data packet is written into the local transaction log table, and the key status information of each abnormal data packet is recorded, and breakpoint identification information is generated for each abnormal data packet. The structure of the breakpoint identification information is: [AppKey]_[TempNo]_[data generation timestamp]_[number of retries].

6. The multi-platform data synchronization method according to claim 4, characterized in that: The corresponding measures are taken according to different exception types, including: For the network jitter of the current communication link, retry to transmit the synchronization data packet multiple times, wherein the time interval of the first retry transmission is 2s, and the time interval of each subsequent retry transmission is interval = 2^n + rand(0,1), where n is the number of retry transmissions; For high-priority synchronization data packets, the synchronization data packets are transmitted simultaneously through all available communication links. When one of the communication links transmits the synchronization data packet to the terminal platform first, the transmission of other communication links is terminated. When the size of the synchronization data packet exceeds the preset size, the synchronization data packet is divided into multiple data slices, and the multiple data slices are simultaneously transmitted to the terminal platform through different communication links, so that when the terminal platform receives the multiple data slices, the multiple data slices are reassembled after MD5 verification.

7. The multi-platform data synchronization method according to claim 4, characterized in that: If the number of consecutive timeouts of the current communication link reaches a preset number, switching to another communication link to transmit the synchronization data packet includes: Real-time monitoring of the quality data of each communication link, including the RTT, packet loss rate and bandwidth utilization of the communication link; The quality score of each communication link is calculated based on the RTT, packet loss rate and bandwidth occupancy of each communication link. The quality score calculation formula is: Score = 0.6 × (1 / RTT) + 0.3 × (1-packet loss rate) + 0.1 × remaining bandwidth; Switch to the communication link with the highest quality score to transmit the synchronization data packet.

8. The multi-platform data synchronization method according to claim 4, characterized in that: If the number of consecutive timeouts of the current communication link reaches a preset number, switching to another communication link to transmit the synchronization data packet includes: Collect historical quality data of each communication link, including RTT, packet loss rate, and bandwidth occupancy of the communication link; Calculate the quality score of each communication link based on the historical quality data of each communication link; Acquire a training data set, wherein the training data set includes a plurality of samples, each sample including quality data and a quality score of a communication link; Training the link quality prediction model based on the training data set to obtain a trained link quality prediction model; Based on the trained link quality prediction model, the stability of each communication link in the future set time period is predicted; Switch to the communication link with the best stability to transmit the synchronization data packet.

9. A multi-platform data synchronization system based on multi-link and dynamic control strategy, characterized in that: Including central platform and multiple terminal platforms; The central platform includes: Configuration module, used to configure the unique identifier Appkey of each terminal platform and the unique identifier TempNo of each data push template; A retrieval module is configured to receive a combination of AppKey and TempNo reported by any terminal platform, and retrieve a corresponding data push template in a rule template library according to TempNo in the combination key, wherein the data push template defines an SQL query statement template; A generation module, configured to inject characteristic parameters of the terminal platform into the SQL query statement template to generate an executable SQL query statement; An execution module, configured to execute the generated SQL query statement, obtain raw data, process fields in the raw data according to processing rules, and generate a synchronization data packet based on the processed fields; A push module, configured to push the synchronization data packet to the terminal platform corresponding to the AppKey in the combination key through a communication link; There are multiple communication links. When pushing the synchronization data packet to the terminal platform, a corresponding communication link is selected according to a dynamic selection strategy, and the synchronization data packet is pushed to the terminal platform through the selected communication link.

Citation Information

Patent Citations

  • Data query method, cache server and terminal

    CN110134705A

  • Data processing method and system

    CN114996361A

  • Method and device for automatically generating SQL (structured query language) in query area

    CN117851437A

  • Cross-multilevel network structure data synchronization method and device, medium and equipment

    CN118890361A

  • Structured data processing method and device based on cloud mode, medium and equipment

    CN119621818A