CN109977170A - The synchronous method and system of network data inside and outside a kind of government affairs - Google Patents
The synchronous method and system of network data inside and outside a kind of government affairs Download PDFInfo
- Publication number
- CN109977170A CN109977170A CN201910214212.2A CN201910214212A CN109977170A CN 109977170 A CN109977170 A CN 109977170A CN 201910214212 A CN201910214212 A CN 201910214212A CN 109977170 A CN109977170 A CN 109977170A
- Authority
- CN
- China
- Prior art keywords
- data
- government affairs
- synchronous
- outside
- network data
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
- 238000000034 method Methods 0.000 title claims abstract description 34
- 230000001360 synchronised effect Effects 0.000 title claims abstract description 31
- 238000012217 deletion Methods 0.000 claims abstract description 12
- 230000037430 deletion Effects 0.000 claims abstract description 12
- 230000008676 import Effects 0.000 claims abstract description 4
- 238000004590 computer program Methods 0.000 claims description 6
- 230000004048 modification Effects 0.000 claims description 6
- 238000012986 modification Methods 0.000 claims description 6
- 238000003780 insertion Methods 0.000 claims description 4
- 230000037431 insertion Effects 0.000 claims description 4
- 238000012545 processing Methods 0.000 claims 1
- 238000002955 isolation Methods 0.000 abstract description 3
- 238000007726 management method Methods 0.000 description 3
- 239000007787 solid Substances 0.000 description 2
- 238000013459 approach Methods 0.000 description 1
- 230000005540 biological transmission Effects 0.000 description 1
- 238000013500 data storage Methods 0.000 description 1
- 238000011161 development Methods 0.000 description 1
- 238000010586 diagram Methods 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 230000007246 mechanism Effects 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 239000013307 optical fiber Substances 0.000 description 1
- 210000000056 organ Anatomy 0.000 description 1
- 230000008569 process Effects 0.000 description 1
- 239000004065 semiconductor Substances 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q50/00—Information and communication technology [ICT] specially adapted for implementation of business processes of specific business sectors, e.g. utilities or tourism
- G06Q50/10—Services
- G06Q50/26—Government or public services
Landscapes
- Business, Economics & Management (AREA)
- Tourism & Hospitality (AREA)
- Marketing (AREA)
- Primary Health Care (AREA)
- Health & Medical Sciences (AREA)
- Economics (AREA)
- General Health & Medical Sciences (AREA)
- Human Resources & Organizations (AREA)
- Development Economics (AREA)
- Educational Administration (AREA)
- Strategic Management (AREA)
- Physics & Mathematics (AREA)
- General Business, Economics & Management (AREA)
- General Physics & Mathematics (AREA)
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention belongs to government network data sharing field, disclose the method and system that network data is synchronous inside and outside a kind of government affairs, the government affairs intranet and extranet method of data synchronization includes: creation trigger, will it is newly-increased, update, deletion business automatically records；Create timed task, time recording data；Can also be according to management system, artificial timing executes batch program export or corresponds to and imports in outer net.The present invention, which realizes, allows progress data between the system being deployed in physical isolation network to synchronize, and takes full advantage of the characteristic of database trigger, records the complete change procedure of data, it is synchronous that data are easily carried out with the mode imported and exported.The synchronous method of network data is easy inside and outside present invention offer government affairs, easy to implement, data consistency is strong, realizes the synchronization of inter-system data, reduces and repeats typing, improves working efficiency.
Description
Technical field
The invention belongs to a kind of synchronous method of network data inside and outside government network data sharing field more particularly to government affairs and
System.
Background technique
Government intranet is Party and government offices' office service network of concerning security matters, is physically isolated with Internet, is meeting work
Under the premise of demand, coverage area is as few as possible, interconnects to upper with National Electrical government intranet.Government affairs outer net is that government externally takes
The business private network of business is isolated with Internet by firewall logic, is mainly used for organ's access Internet, is issued political affairs
Mansion public information accepts, feeds back public's request and operational safety rank does not need business in government private network operation.
But with E-Government, E-government, government itself information-based operation system etc. development, government with from status
Branch mechanism, extraneous relevant unit's information exchange outer net interconnect and just become more necessary；The purpose of Network Isolation be in order to
Safety comprising internal network, and the purpose of the network interconnection is the carry out data exchange of convenience and high-efficiency；According to government network management
Requirement, it is necessary to ensure that Intranet containing state secret information is perfectly safe, then being implemented on network physical isolation
Electronic government affairs system, the data exchange between intranet and extranet system are the demands that the builder of each system can encounter.
General intranet and extranet data exchange ways have snapshot, timestamp method.Snapshot be in database storage object again certain
The instant image at one moment.It, can be by its current image by defining a snapshot or using similar approach for synchronization object
Content as more latest copy.In fact, all synchronization schemes all will impliedly use it.Timestamp method is to need synchronization
Each table adds a timestamp field, and original application system records each record modification time in the column.This method
The operational efficiency of original application is not influenced, but needs to do original system biggish adjustment, and cannot capture those simultaneously
It is non-to be changed by operation data caused by application system, it is also difficult to handle the recording synchronism of deletion.
In conclusion problem of the existing technology is:
In the prior art, timestamp method needs to do original system biggish adjustment, and cannot capture those and not be
Changed by operation data caused by application system, it is also difficult to handle the recording synchronism of deletion.
Summary of the invention
In view of the problems of the existing technology, the present invention provides a kind of synchronous method of network data inside and outside government affairs and it is
System,
The invention is realized in this way a kind of synchronous method of network data inside and outside government affairs, the network data side of synchronization inside and outside government affairs
Method includes:
Using database trigger characteristic, the variation of data is recorded, and variation is transmitted to other databases；
It is automatic to execute defined SQL statement using the variation of table in capture source database, completely retain application system pair
Modification, insertion or deletion that table issues act the final influence on table data.
It specifically includes:
Step 1: corresponding I table (newly-increased table, containing update) and (deletion of D table are established to the synchronous table of generation system needs
Table), by creating trigger to traffic table, increases newly or I table, deletion record write-in D table and old record is written from I table in more new business
It deletes；
Step 1: creation timed task, timing export the data of I table and D table；Or it according to management system, manually periodically holds
The export of row batch program or corresponding importing；
Step 3: it is preferential to execute D table handling when importeding into other networks, then execute I table handling；It imports successfully,
Remove I table, the D table of source database；Failure is imported, checks reason until importing successfully.
Another object of the present invention is to provide in a kind of government affairs for implementing the method that network data is synchronous inside and outside the government affairs
Outer network data synchronous control system.
Another object of the present invention is to provide network data synchronous computer program inside and outside a kind of government affairs, inside and outside the government affairs
Network data synchronous computer program realizes the method that network data is synchronous inside and outside the government affairs.
Another object of the present invention is to provide a kind of terminal, the terminal, which is carried, realizes claim 1~2 any one
The controller of the synchronous method of network data inside and outside the government affairs.
Another object of the present invention is to provide a kind of computer readable storage mediums, including instruction, when it is in computer
When upper operation, so that computer executes the method that network data is synchronous inside and outside the government affairs.
In conclusion advantages of the present invention and good effect are as follows:
The present invention provides that the method that network data is synchronous inside and outside government affairs is easy, easy to implement, data consistency is strong, realizes and is
The synchronization of data between system reduces and repeats typing, improves working efficiency.
Using the variation of table in capture source database, the automatic defined SQL statement of execution completely to retain answers the present invention
The modification, insertion or the deletion that are issued with system on table act the final influence on table data.
The present invention utilizes database trigger characteristic, records the variation of data, and variation is transmitted to other databases.Touching
The main function of hair device is exactly that it can be realized the complicated referential integrity and data that cannot be guaranteed by major key and external key
Consistency.In addition to this, trigger also strengthens many functions such as constraint, tracking variation, cascade operation.Exactly utilize trigger
These powerful functions, can come realize database variation capture.
Detailed description of the invention
Fig. 1 is the Method And Principle schematic diagram that network data is synchronous inside and outside government affairs provided in an embodiment of the present invention；
Fig. 2 is method of data synchronization flow chart provided in an embodiment of the present invention.
Specific embodiment
In order to make the objectives, technical solutions, and advantages of the present invention clearer, with reference to embodiments, to the present invention
It is further elaborated.It should be appreciated that the specific embodiments described herein are merely illustrative of the present invention, it is not used to
Limit the present invention.
In the prior art, timestamp method needs to do original system biggish adjustment, and cannot capture those and not be
Changed by operation data caused by application system, it is also difficult to handle the recording synchronism of deletion.
In order to solve the above technical problems, being described in detail below with reference to scheme to application principle of the invention.
As Figure 1-Figure 2, government affairs intranet and extranet method of data synchronization provided in an embodiment of the present invention includes:
S101: needing synchronous table to establish corresponding I table (newly-increased table, containing update) and D table (deleting table) to generation system,
By creating trigger to traffic table, increases newly or I table is written in more new business, D table is written in deletion record and old record is deleted from I table
It removes；
S102: creation timed task, timing export the data of I table and D table；Or according to management system, artificial timing is executed
Batch program export or corresponding importing；
S103: it is preferential to execute D table handling when importeding into other networks, then execute I table handling；It imports successfully, clearly
Except the I table of source database, D table；Failure is imported, checks reason until importing successfully.
Using the variation of table in capture source database, the automatic defined SQL statement of execution completely to retain answers the present invention
The modification, insertion or the deletion that are issued with system on table act the final influence on table data.
The present invention utilizes database trigger characteristic, records the variation of data, and variation is transmitted to other databases.Touching
The main function of hair device is exactly that it can be realized the complicated referential integrity and data that cannot be guaranteed by major key and external key
Consistency.In addition to this, trigger also strengthens many functions such as constraint, tracking variation, cascade operation.Exactly utilize trigger
These powerful functions, can come realize database variation capture.
In embodiments of the present invention, the present invention provides a kind of government affairs for implementing the method that network data is synchronous inside and outside the government affairs
Inside and outside network data synchronous control system.
In the above-described embodiments, can come wholly or partly by software, hardware, firmware or any combination thereof real
It is existing.When using entirely or partly realizing in the form of a computer program product, the computer program product include one or
Multiple computer instructions.When loading on computers or executing the computer program instructions, entirely or partly generate according to
Process described in the embodiment of the present invention or function.The computer can be general purpose computer, special purpose computer, computer network
Network or other programmable devices.The computer instruction may be stored in a computer readable storage medium, or from one
Computer readable storage medium is transmitted to another computer readable storage medium, for example, the computer instruction can be from one
A web-site, computer, server or data center pass through wired (such as coaxial cable, optical fiber, Digital Subscriber Line (DSL)
Or wireless (such as infrared, wireless, microwave etc.) mode is carried out to another web-site, computer, server or data center
Transmission).The computer-readable storage medium can be any usable medium or include one that computer can access
The data storage devices such as a or multiple usable mediums integrated server, data center.The usable medium can be magnetic Jie
Matter, (for example, floppy disk, hard disk, tape), optical medium (for example, DVD) or semiconductor medium (such as solid state hard disk Solid
State Disk (SSD)) etc..
The foregoing is merely illustrative of the preferred embodiments of the present invention, is not intended to limit the invention, all in essence of the invention
Made any modifications, equivalent replacements, and improvements etc., should all be included in the protection scope of the present invention within mind and principle.
Claims (6)
1. a kind of synchronous method of network data inside and outside government affairs, which is characterized in that the government affairs intranet and extranet method of data synchronization includes:
Using database trigger characteristic, the variation of data is recorded, and variation is transmitted to other databases；
Automatic to execute defined SQL statement using the variation of table in capture source database, the complete application system that retains sends out table
Modification, insertion or deletion out acts the variation to table data.
2. the synchronous method of network data inside and outside government affairs as described in claim 1, which is characterized in that network data inside and outside the government affairs
Synchronous method includes:
Step 1: needing synchronous table to establish corresponding I table and D table to generation system, by creating trigger to traffic table, newly
Increase or I table is written in more new business, D table is written in deletion record and old record is deleted from I table；
Step 2: creation timed task, timing export the data of I table and D table；Or according to management system, artificial timing, which executes, to be criticized
Processing routine export or corresponding importing；
Step 3: it is preferential to execute D table handling when importeding into other networks, then execute I table handling；It imports successfully, removes
I table, the D table of source database；Failure is imported, checks reason until importing successfully.
3. netting index inside and outside a kind of government affairs for implementing the method that network data is synchronous inside and outside government affairs described in claim 1~2 any one
According to synchronous control system.
4. network data synchronous computer program inside and outside a kind of government affairs, which is characterized in that network data synchronometer is calculated inside and outside the government affairs
Machine program realizes the method that network data is synchronous inside and outside government affairs described in claim 1~2 any one.
5. a kind of terminal, which is characterized in that the terminal, which is carried, realizes government affairs intranet and extranet described in claim 1~2 any one
The controller of the synchronous method of data.
6. a kind of computer readable storage medium, including instruction, when run on a computer, so that computer is executed as weighed
Benefit requires the method that network data is synchronous inside and outside government affairs described in 1-2 any one.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910214212.2A CN109977170A (en) | 2019-03-20 | 2019-03-20 | The synchronous method and system of network data inside and outside a kind of government affairs |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910214212.2A CN109977170A (en) | 2019-03-20 | 2019-03-20 | The synchronous method and system of network data inside and outside a kind of government affairs |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN109977170A true CN109977170A (en) | 2019-07-05 |
Family
ID=67079726
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910214212.2A Pending CN109977170A (en) | 2019-03-20 | 2019-03-20 | The synchronous method and system of network data inside and outside a kind of government affairs |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109977170A (en) |
Cited By (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110602165A (en) * | 2019-08-08 | 2019-12-20 | 数字广东网络建设有限公司 | Government affair data synchronization method, device, system, computer equipment and storage medium |
| CN112381695A (en) * | 2020-10-27 | 2021-02-19 | 广州市中智软件开发有限公司 | Electronic government affair interaction system |
| CN113032354A (en) * | 2021-03-31 | 2021-06-25 | 广东电网有限责任公司 | Data sharing and real-time high-frequency interaction method between internal and external network applications |
| CN113342845A (en) * | 2021-06-23 | 2021-09-03 | 乐刷科技有限公司 | Data synchronization method, computer device and readable storage medium |
| CN114637614A (en) * | 2022-03-30 | 2022-06-17 | 西安热工研究院有限公司 | Trigger-based unit event synchronization method, system, equipment and storage medium |
| CN114650124A (en) * | 2020-12-18 | 2022-06-21 | 中国联合网络通信集团有限公司 | Synchronization method and device for data transmission |
Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102411598A (en) * | 2011-07-29 | 2012-04-11 | 株洲南车时代电气股份有限公司 | Method and system for realizing data consistency |
| CN102609645A (en) * | 2012-01-19 | 2012-07-25 | 北京工业大学 | Website data tampering preventing method based on network isolation structure |
| CN102662946A (en) * | 2012-02-20 | 2012-09-12 | 北京地拓科技发展有限公司 | Method and system for automatically monitoring record changes in database |
| CN103077196A (en) * | 2012-12-25 | 2013-05-01 | 宁波公众信息产业有限公司 | Access method from public network WEB (World Wide Web) to intranet database |
| CN104572672A (en) * | 2013-10-15 | 2015-04-29 | 北大方正集团有限公司 | Heterogeneous database synchronization method and application system |
| CN104699760A (en) * | 2015-02-11 | 2015-06-10 | 安徽继远电网技术有限责任公司 | Data synchronization method used for heterogeneous system and based on safety isolation |
| US9760453B2 (en) * | 2012-06-28 | 2017-09-12 | Microsoft Technology Licensing, Llc | Two-tier failover service for data disaster recovery |
-
2019
- 2019-03-20 CN CN201910214212.2A patent/CN109977170A/en active Pending
Patent Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102411598A (en) * | 2011-07-29 | 2012-04-11 | 株洲南车时代电气股份有限公司 | Method and system for realizing data consistency |
| CN102609645A (en) * | 2012-01-19 | 2012-07-25 | 北京工业大学 | Website data tampering preventing method based on network isolation structure |
| CN102662946A (en) * | 2012-02-20 | 2012-09-12 | 北京地拓科技发展有限公司 | Method and system for automatically monitoring record changes in database |
| US9760453B2 (en) * | 2012-06-28 | 2017-09-12 | Microsoft Technology Licensing, Llc | Two-tier failover service for data disaster recovery |
| CN103077196A (en) * | 2012-12-25 | 2013-05-01 | 宁波公众信息产业有限公司 | Access method from public network WEB (World Wide Web) to intranet database |
| CN104572672A (en) * | 2013-10-15 | 2015-04-29 | 北大方正集团有限公司 | Heterogeneous database synchronization method and application system |
| CN104699760A (en) * | 2015-02-11 | 2015-06-10 | 安徽继远电网技术有限责任公司 | Data synchronization method used for heterogeneous system and based on safety isolation |
Cited By (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110602165A (en) * | 2019-08-08 | 2019-12-20 | 数字广东网络建设有限公司 | Government affair data synchronization method, device, system, computer equipment and storage medium |
| CN110602165B (en) * | 2019-08-08 | 2022-09-06 | 数字广东网络建设有限公司 | Government affair data synchronization method, device, system, computer equipment and storage medium |
| CN112381695A (en) * | 2020-10-27 | 2021-02-19 | 广州市中智软件开发有限公司 | Electronic government affair interaction system |
| CN114650124A (en) * | 2020-12-18 | 2022-06-21 | 中国联合网络通信集团有限公司 | Synchronization method and device for data transmission |
| CN114650124B (en) * | 2020-12-18 | 2023-10-03 | 中国联合网络通信集团有限公司 | Synchronization method and device for data transmission |
| CN113032354A (en) * | 2021-03-31 | 2021-06-25 | 广东电网有限责任公司 | Data sharing and real-time high-frequency interaction method between internal and external network applications |
| CN113342845A (en) * | 2021-06-23 | 2021-09-03 | 乐刷科技有限公司 | Data synchronization method, computer device and readable storage medium |
| CN113342845B (en) * | 2021-06-23 | 2024-02-20 | 乐刷科技有限公司 | Data synchronization method, computer device and readable storage medium |
| CN114637614A (en) * | 2022-03-30 | 2022-06-17 | 西安热工研究院有限公司 | Trigger-based unit event synchronization method, system, equipment and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109977170A (en) | The synchronous method and system of network data inside and outside a kind of government affairs | |
| JP7330596B2 (en) | BLOCKCHAIN DATA ARCHIVING METHOD, BLOCKCHAIN DATA ARCHIVING DEVICE, ELECTRONIC DEVICE, AND COMPUTER PROGRAM | |
| CN112000741B (en) | Internal and external network data exchange system, method, device, computer equipment and medium | |
| WO2018093094A1 (en) | Data replacation technique in database management system | |
| RU2767149C2 (en) | Method and configuration for automated testing system | |
| WO2018133662A1 (en) | Data redistribution method and apparatus, and database cluster | |
| US8793456B2 (en) | Automated migration to a new target volume via merged bitmaps to maintain consistency | |
| EP3575968A1 (en) | Method and device for synchronizing active transaction lists | |
| US11144405B2 (en) | Optimizing database migration in high availability and disaster recovery computing environments | |
| JPH04217036A (en) | Data processing method | |
| JP2005303993A (en) | System and method for credential roaming | |
| CN107688611B (en) | Saltstack-based Redis key value management system and method | |
| WO2017088705A1 (en) | Data processing method and device | |
| KR101922044B1 (en) | Recovery technique of data intergrity with non-stop database server redundancy | |
| US11468087B1 (en) | System and method for bi-directional replication of data objects in a heterogeneous storage environment | |
| CN109144785A (en) | Method and apparatus for Backup Data | |
| CN105577841A (en) | File synchronization method, device, client, server side and device | |
| JP2016521427A (en) | Method, device and system for peer-to-peer data replication and method, device and system for master node switching | |
| US20160124955A1 (en) | Dual overlay query processing | |
| CN105446831A (en) | Server-Free backup method in conjunction with SAN | |
| JP2015035020A (en) | Storage system, storage control device, and control program | |
| CN110389859A (en) | Method, equipment and computer program product for copied chunks | |
| CN107580032A (en) | Data processing method, device and equipment | |
| WO2024103898A1 (en) | Database cluster management method and apparatus | |
| CN111176904B (en) | Method, system, equipment and medium for data backup under private cloud architecture |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20190705 |