Method, system, medium and equipment for ensuring data consistency among systems in offline environment

Abstract

The invention provides a method, a system, a medium and equipment for ensuring data consistency among systems in an offline environment. The method comprises the following steps of: 1, exporting service data in a service platform system as a service data packet; 2, importing and analyzing a service data packet in the offline environment system to serve as service data of the offline environment system; 3, after the staged work is completed in the off-line environment system, exporting service data generated by the work as an off-line service data packet; and 4, importing the offline service data packet into the service platform system to ensure the consistency of service data between the service platform system and the offline environment system. According to the method, the data generated by system work in the offline environment is packaged, encrypted, exported and provided for the business platform system by utilizing the flexibility and expandability of the extensible markup language, so that the data in the offline environment can be safely synchronized into the business platform system, and the data consistency between systems is ensured.

Description

Technical Field

[0001] The present invention relates to the field of data processing technology, and in particular to a method, system, medium and device for ensuring data consistency between systems in an offline environment. Background Art

[0002] Currently, many systems are deployed in intranet or non-network environments. When data needs to be synchronized with external business platform systems, they can be synchronized through backup databases, hard disks, etc. However, this full data exchange often leads to resource waste and the export of invalid data, and even the leakage of important data, which will inevitably lose the accuracy and efficiency of synchronized data.

[0003] In the prior art (U.S. patent application number US11324847, which discloses "XML storage solution and data exchange file format structure"), this relational database management system with XML storage implementation can effectively transmit and verify data between computing devices, but it lacks the complexity and diversity of data structure, cannot include attachments, document styles and other contents, and cannot guarantee the security of business data. Summary of the invention

[0004] In view of the defects in the prior art, an object of the present invention is to provide a method, system, medium and device for ensuring data consistency between systems in an offline environment.

[0005] The method for ensuring data consistency between systems in an offline environment provided by the present invention includes: Step 1: Export the business data in the business platform system as a business data package; Step 2: Import and parse the business data package in the offline environment system as the business data of the offline environment system; Step 3: After completing the phased work in the offline environment system, export the business data generated by the work as an offline business data package; Step 4: Import the offline business data package into the business platform system to ensure the consistency of business data between the business platform system and the offline environment system. If the data of the two systems are inconsistent with the imported data package data, the imported data package data shall prevail for overwriting.

[0006] Preferably, step 1 includes: packaging and exporting the business data into a business data package, the business data package includes a structured file generated based on an extended markup language, and the structured file name is consistent with the business system unique identifier, so as to facilitate finding the corresponding file during parsing.

[0007] Preferably, step 2 includes: parsing the data structure of the business data packet, finding the data file with the same file name according to the unique identifier of the business system, identifying the document style, attachments, pictures and related relationship data according to the format of the data file, and importing the data into the offline environment system.

[0008] Preferably, the step 3 includes: selectively packaging and exporting the offline service data into an offline service data packet, and encrypting the offline service data packet by a preset encryption method; The step 4 includes: decrypting the offline service data packet by a preset decryption method, and parsing the offline service data packet by a preset parsing method to generate service data.

[0009] The system for ensuring data consistency between systems in an offline environment provided by the present invention includes: Module M1: Export the business data in the business platform system as business data packets; Module M2: import and parse the business data packet in the offline environment system as the business data of the offline environment system; Module M3: After completing the phased work in the offline environment system, the business data generated by the work is exported as an offline business data package; Module M4: Import the offline business data package into the business platform system to ensure the consistency of business data between the business platform system and the offline environment system. If the data of the two systems are inconsistent with the imported data package data, the imported data package data shall prevail for overwriting.

[0010] Preferably, the module M1 includes: packaging and exporting the business data into a business data package, wherein the business data package includes a structured file generated based on an extended markup language, and the structured file name is consistent with the business system unique identifier, so as to facilitate finding the corresponding file during parsing.

[0011] Preferably, the module M2 includes: parsing the data structure of the business data packet, finding the data file with the same file name according to the unique identifier of the business system, identifying the document style, attachments, pictures and related relationship data according to the format of the data file, and importing the data into the offline environment system.

[0012] Preferably, the module M3 comprises: selectively packaging and exporting the offline service data into an offline service data packet, and encrypting the offline service data packet by a preset encryption method; The module M4 includes: decrypting the offline service data packet by a preset decryption method, and parsing the offline service data packet by a preset parsing method to generate service data.

[0013] According to the computer-readable storage medium storing a computer program provided by the present invention, when the computer program is executed by a processor, the steps of the method for ensuring data consistency between systems in an offline environment are implemented.

[0014] The electronic device provided according to the present invention includes a memory, a processor, and a computer program stored in the memory and executable on the processor. When the computer program is executed by the processor, the steps of the method for ensuring data consistency between systems in an offline environment are implemented.

[0015] Compared with the prior art, the present invention has the following beneficial effects: (1) By adopting the method of data packet exchange, the problem of data synchronization between systems in an offline environment is solved; (2) By adopting the extended markup language, the complex and diverse system data export requirements are met, thereby solving the problem of diversified synchronization of system data; (3) By adopting the method of encryption and decryption in compressed packages, high security of data packets can be achieved. BRIEF DESCRIPTION OF THE DRAWINGS

[0016] Other features, objects and advantages of the present invention will become more apparent from the detailed description of non-limiting embodiments made with reference to the following drawings: Figure 1 Schematic diagram of the data packet exchange process; Figure 2 Schematic diagram of the data packet packing / unpacking process. DETAILED DESCRIPTION

[0017] The present invention is described in detail below in conjunction with specific embodiments. The following embodiments will help those skilled in the art to further understand the present invention, but are not intended to limit the present invention in any form. It should be noted that, for those of ordinary skill in the art, several changes and improvements can also be made without departing from the concept of the present invention. These all belong to the protection scope of the present invention.

[0018] Example 1 like Figure 1 The present invention provides a method for ensuring data consistency between systems in an offline environment, comprising the following steps: Step 1: Export the system business data in the business platform system as a business data package; Step 2: Import and parse the business data package in the offline environment system to obtain the offline system business data; Step 3: After completing the phased work in the offline environment system, export the offline system business data generated by the work as an offline business data package; Step 4: Import the offline business data package into the business platform system to ensure the consistency of business data between systems. If the data of the two systems are inconsistent with the imported data package data, the imported data package data shall prevail for overwriting.

[0019] The step 1 comprises: Package and export business data into business data packages. Business data packages contain specific structured files generated based on extended markup language. The structured file name is consistent with the unique identifier of the business system, which is convenient for finding the corresponding file during parsing. It can meet the export accuracy of various styles of documents, attachments, data, associations, etc.

[0020] The step 2 comprises: Step 2.1: Analyze the business data packet through a specific parsing method to generate business data.

[0021] Step 2.1.1: Parse the data structure of the data packet.

[0022] Step 2.1.2.: Find the data file with the same file name based on the unique identifier of the business system.

[0023] Step 2.1.3: Identify the document style, attachments, pictures and other data and related relationship data based on the format of the data file.

[0024] Step 2.2: Import the data into the offline environment system.

[0025] The step 3 comprises the following steps: Step 3.1: The offline service data can be selectively packaged and exported as an offline service data package.

[0026] Step 3.2: Encrypt the offline service data packet using a specific encryption method.

[0027] The step 4 comprises the following steps: Step 4.1: Decrypt the offline service data packet using a specific decryption method.

[0028] Step 4.2: Analyze the offline business data packet through a specific parsing method to generate business data.

[0029] like Figure 2 , use an independent password and add a specific salt to encrypt when compressing the data packet, and use a special and unconventional suffix. Decrypt the data packet through a specific decryption method, identify the special and unconventional data packet suffix file, and use an independent password plus a specific salt to decrypt when compressing the data packet.

[0030] Specifically, a company needs to regularly send internal financial statement data (i.e., offline business data) to remote branches for auditing. For security reasons, the company decides to use the following process to process this data.

[0031] The enterprise first uses the data packaging tool developed internally to select financial statement records within a specified time period from the database and convert them into a file in a standard format (such as CSV or JSON). This process may include operations such as data cleaning and formatting to ensure the integrity and consistency of the data. After completion, all selected financial statement data is integrated into a single file to form an offline business data package.

[0032] In order to protect the security of data during transmission, the enterprise uses AES-256 (Advanced Encryption Standard) to encrypt the offline business data packets generated above. The encryption process uses a key that is pre-generated and strictly kept by the enterprise's internal security management team. In addition, to further enhance security, a new initialization vector (IV) is generated for each encryption and saved together with the encrypted data, but the key is not transmitted with the data.

[0033] When the offline service data packet arrives at the remote branch, the branch technician uses the same AES-256 algorithm and the correct key obtained from the headquarters in advance to decrypt the data packet. During this process, the technician needs to enter the correct key and the initialization vector (IV) that matches the data packet to successfully restore the original data.

[0034] The decrypted data will be presented in the original standard format (such as CSV or JSON). Branch staff can use professional data analysis software or tools such as Excel, SQL Server, etc. to import these data for detailed analysis. This step may involve activities such as data verification, trend analysis, anomaly detection, etc. to support subsequent audit work.

[0035] Example 2 The present invention also provides a system for ensuring data consistency between systems in an offline environment. The system for ensuring data consistency between systems in an offline environment can be implemented by executing the process steps of the method for ensuring data consistency between systems in an offline environment. That is, those skilled in the art can understand the method for ensuring data consistency between systems in an offline environment as a preferred implementation of the system for ensuring data consistency between systems in an offline environment.

[0036] The system for ensuring data consistency between systems in an offline environment provided by the present invention includes: Module M1: Export the business data in the business platform system as business data packets; Module M2: import and parse the business data packet in the offline environment system as the business data of the offline environment system; Module M3: After completing the phased work in the offline environment system, the business data generated by the work is exported as an offline business data package; Module M4: Import the offline business data package into the business platform system to ensure the consistency of business data between the business platform system and the offline environment system. If the data of the two systems are inconsistent with the imported data package data, the imported data package data shall prevail for overwriting.

[0037] The module M1 includes: packaging and exporting business data into a business data package, wherein the business data package includes a structured file generated based on an extended markup language, and the structured file name is consistent with the business system unique identifier, so as to facilitate finding the corresponding file during parsing.

[0038] The module M2 includes: parsing the data structure of the business data packet, finding the data file with the same file name according to the unique identifier of the business system, identifying the document style, attachments, pictures and related relationship data according to the format of the data file, and importing the data into the offline environment system.

[0039] The module M3 includes: selectively packaging and exporting offline service data into offline service data packets, and encrypting the offline service data packets by a preset encryption method; The module M4 includes: decrypting the offline service data packet by a preset decryption method, and parsing the offline service data packet by a preset parsing method to generate service data.

[0040] Those skilled in the art know that, in addition to implementing the system, device and its various modules provided by the present invention in a purely computer-readable program code, it is entirely possible to implement the same program in the form of logic gates, switches, application-specific integrated circuits, programmable logic controllers and embedded microcontrollers by logically programming the method steps. Therefore, the system, device and its various modules provided by the present invention can be considered as a hardware component, and the modules included therein for implementing various programs can also be considered as structures within the hardware component; the modules for implementing various functions can also be considered as both software programs for implementing the method and structures within the hardware component.

[0041] The above describes the specific embodiments of the present invention. It should be understood that the present invention is not limited to the above specific embodiments, and those skilled in the art can make various changes or modifications within the scope of the claims, which does not affect the essence of the present invention. In the absence of conflict, the embodiments of the present application and the features in the embodiments can be combined with each other arbitrarily.

Claims

1. A method for ensuring data consistency between systems in an offline environment, characterized in that: include: Step 1: Export the business data in the business platform system as a business data package; Step 2: Import and parse the business data package in the offline environment system as the business data of the offline environment system; Step 3: After completing the phased work in the offline environment system, export the business data generated by the work as an offline business data package; Step 4: Import the offline business data package into the business platform system to ensure the consistency of business data between the business platform system and the offline environment system. If the data of the two systems are inconsistent with the imported data package data, the imported data package data shall prevail for overwriting.

2. The method for ensuring data consistency between systems in an offline environment according to claim 1, characterized in that: The step 1 includes: packaging and exporting the business data into a business data package, wherein the business data package includes a structured file generated based on an extended markup language, and the structured file name is consistent with the unique identifier of the business system, so as to facilitate finding the corresponding file during parsing.

3. The method for ensuring data consistency between systems in an offline environment according to claim 2, characterized in that: The step 2 includes: parsing the data structure of the business data packet, finding the data file with the same file name according to the unique identifier of the business system, identifying the document style, attachments, pictures and related relationship data according to the format of the data file, and importing the data into the offline environment system.

4. The method for ensuring data consistency between systems in an offline environment according to claim 1, characterized in that: The step 3 includes: selectively packaging and exporting the offline service data into an offline service data packet, and encrypting the offline service data packet by a preset encryption method; The step 4 includes: decrypting the offline service data packet by a preset decryption method, and parsing the offline service data packet by a preset parsing method to generate service data.

5. A system for ensuring data consistency between systems in an offline environment, characterized in that: include: Module M1: Export the business data in the business platform system as business data packets; Module M2: import and parse the business data packet in the offline environment system as the business data of the offline environment system; Module M3: After completing the phased work in the offline environment system, the business data generated by the work is exported as an offline business data package; Module M4: Import the offline business data package into the business platform system to ensure the consistency of business data between the business platform system and the offline environment system. If the data of the two systems are inconsistent with the imported data package data, the imported data package data shall prevail for overwriting.

6. The system for ensuring data consistency between systems in an offline environment according to claim 5, characterized in that: The module M1 includes: packaging and exporting business data into a business data package, wherein the business data package includes a structured file generated based on an extended markup language, and the structured file name is consistent with the business system unique identifier, so as to facilitate finding the corresponding file during parsing.

7. The system for ensuring data consistency between systems in an offline environment according to claim 6, characterized in that: The module M2 includes: parsing the data structure of the business data packet, finding the data file with the same file name according to the unique identifier of the business system, identifying the document style, attachments, pictures and related relationship data according to the format of the data file, and importing the data into the offline environment system.

8. The system for ensuring data consistency between systems in an offline environment according to claim 5, characterized in that: The module M3 includes: selectively packaging and exporting offline service data into offline service data packets, and encrypting the offline service data packets by a preset encryption method; The module M4 includes: decrypting the offline service data packet by a preset decryption method, and parsing the offline service data packet by a preset parsing method to generate service data.

9. A computer-readable storage medium storing a computer program, characterized in that: When the computer program is executed by a processor, the steps of the method for ensuring data consistency between systems in an offline environment according to any one of claims 1 to 4 are implemented.

10. An electronic device comprising a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein: When the computer program is executed by a processor, the steps of the method for ensuring data consistency between systems in an offline environment according to any one of claims 1 to 4 are implemented.

Images