Method for synchronizing data between gatekeeper isolated databases

A data synchronization and database technology, applied in the database field, can solve problems such as troublesome conversion operations, data loss, and large export volume of EXCEL, and achieve the effect of ensuring safety and reliability

Pending Publication Date: 2021-11-02
ZHEJIANG SUPCON TECH
View PDF0 Cites 3 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] Using EXCEL data import, there are many interrelated business data in the manufacturing system, and the data synchronization directly through EXCEL has low fault tolerance, and it is easy to fail to realize business flow in the intelligent manufacturing system due to incomplete data import related to business documents.
Moreover, the import of EXCEL requires a large number of EXCEL export templates, and the export volume of EXCEL for large databases is large. At the same time, when importing, database deadlocks are likely to occur, which will lead to problems such as reduced efficiency of the intelligent manufacturing system.
[0005] Database import, there are many database products on the market. Two intelligent manufacturing systems isolated from each other by the same manufacturer through a network gateway may use different database management systems. Database import needs to convert the exported database files according to different databases, and the conversion operation is troublesome. and prone to data loss
There are also independent business processes in different intelligent manufacturing systems isolated by the gatekeeper. If you directly use the database to import, it is easy to overwrite the data generated by the respective business processes of the manufacturing system and cause data loss.

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
  • Method for synchronizing data between gatekeeper isolated databases
  • Method for synchronizing data between gatekeeper isolated databases
  • Method for synchronizing data between gatekeeper isolated databases

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0033] In order to facilitate those skilled in the art to better understand the present invention, the present invention will be described in further detail below in conjunction with the accompanying drawings and specific embodiments. The following is only exemplary and does not limit the protection scope of the present invention.

[0034] In order to better understand the technical solution of this application, some technical terms in this application are explained first.

[0035] Intelligent manufacturing system: a production information management system for the executive layer of the manufacturing enterprise workshop

[0036]SQLSERVER CDC: Change Data Capture (CDC for short), change data capture records the insert, update and delete activities of SQL Server tables. The operation of SQL Server will write logs, which is also the source of data captured by CDC. The source table with CDC enabled will insert data into the log table during insert, update, and delete activities....

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 invention discloses a method for synchronizing data between gatekeeper isolated databases, which comprises the following steps that: enabling the databases to monitor the data change of a data table and record the data change into a monitoring intermediate table or a data export table; based on the job scheduling and storage process, analyzing the data of the monitoring intermediate table into SQL statements, synchronizing the SQL statements into a data export table, and converting the data in the data export table into a first export file; storing the first export file to another system through isolated data exchange; and enabling the other system to convert the first exported file into an SQL statement based on job scheduling or manual operation, import the SQL statement and record import information, so that data synchronization is realized. According to the method for synchronizing the data between the gatekeeper isolated databases, the safety and reliability of the data are guaranteed, the method is adaptive to the relational databases in the market, import and export information is tracked, abnormal import is modified and executed again, and data deadlock caused by import of a large number of problematic SQL is avoided.

Description

technical field [0001] The invention relates to the field of databases, in particular to a method for synchronizing data between databases isolated by network gatekeepers. Background technique [0002] For product manufacturers that use key technologies, since the production data in the production process involves high-level commercial secrets or even state secrets, the intelligent manufacturing system is generally split into two independent systems, the private network and the industrial control network, through the network gateway. dimension. Among them, the private network manufacturing system is mainly responsible for the entry of confidential personnel information, secret-related production basic data and other secret-related workshop production data; the industrial control network manufacturing system is mainly responsible for the entry of official product production line production data and the internal business process flow data of the industrial control network ent...

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
Patent Type & Authority Applications(China)
IPC IPC(8): G06F16/23G06F16/27G06F16/28G06F21/62
CPCG06F16/2358G06F16/275G06F16/284G06F16/23G06F21/6227
Inventor 罗炜祥郑二磊张壹芬陈江义
Owner ZHEJIANG SUPCON TECH
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products