CN108616603B - Method and system for synchronizing internal and external network data - Google Patents
Method and system for synchronizing internal and external network data Download PDFInfo
- Publication number
- CN108616603B CN108616603B CN201810461487.1A CN201810461487A CN108616603B CN 108616603 B CN108616603 B CN 108616603B CN 201810461487 A CN201810461487 A CN 201810461487A CN 108616603 B CN108616603 B CN 108616603B
- Authority
- CN
- China
- Prior art keywords
- file
- intranet
- equipment
- database
- displayed
- 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.)
- Active
Links
Images
Classifications
-
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04L—TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
- H04L67/00—Network arrangements or protocols for supporting network services or applications
- H04L67/01—Protocols
- H04L67/10—Protocols in which an application is distributed across nodes in the network
- H04L67/1095—Replication or mirroring of data, e.g. scheduling or transport for data synchronisation between network nodes
Landscapes
- Engineering & Computer Science (AREA)
- Computer Networks & Wireless Communication (AREA)
- Signal Processing (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention relates to an internal and external network data synchronization method and a system, wherein the method comprises the following steps: the extranet equipment analyzes and extracts file information of the file and stores the file information into a database table, if the file contains an accessory file, the accessory file is backed up to a first path, the file name of the accessory file is recorded into the position corresponding to the file name field in the table, the accessory file is moved to a second path, otherwise, the file is deleted, a record newly added in the table is exported, stored and sent to the intranet equipment, and the accessory file in the second path is sent to the intranet equipment; the intranet equipment respectively stores the received recorded file and the received attachment file into the database and the fourth path; and the extranet and the intranet equipment respectively display according to the information stored in the table corresponding to the file to be displayed in the corresponding database. The invention reduces the transmission quantity of the files, improves the transmission efficiency, reduces the file analysis quantity in the intranet equipment, and improves the data synchronization efficiency between the intranet equipment and the intranet equipment.
Description
Technical Field
The invention relates to the field of data synchronization, in particular to a method and a system for synchronizing internal and external network data.
Background
With the development of science and technology, the security of data information is more and more important, and because different application systems have different requirements in terms of security management, the application systems need to be deployed in physical areas with different security levels, the important application systems are located in an area with a high security level, namely an intranet, and the general application systems are located in an area with a low security level, namely an extranet.
Because of the high security requirement of the intranet, the communication between the intranet and many external networks is limited, for example, an intranet and an intranet, a service system in the intranet needs to be connected to the extranet through a gatekeeper, and the extranet can be connected to the intranet without the gatekeeper.
When the extranet equipment and the intranet equipment need to synchronously display the same file information from the extranet, the extranet equipment needs to firstly analyze and extract the file, then transmit the file to the intranet equipment, and then the content equipment analyzes and extracts the file again, so that the synchronization of the file and the information on the two equipment is achieved. When the number of files is large or large, it takes a lot of time and resources to transmit the files and repeatedly analyze and extract the information of the files again, so that the efficiency is low.
Disclosure of Invention
In view of the above problems, the present invention aims to provide an intranet and extranet data synchronization method and system, which greatly reduce the transmission amount of files, improve the transmission efficiency, reduce the file analysis amount in intranet equipment, and effectively improve the data synchronization efficiency between the intranet and extranet equipment by combining the database information synchronization and the file synchronization.
The specific scheme is as follows:
an internal and external network data synchronization method comprises the following steps:
s100: the external network equipment analyzes the received file, extracts file information and inputs the file information into a table corresponding to the file in a database of the external network equipment according to classification;
s200: judging whether the file contains an attachment file, if so, entering S300, otherwise, deleting the file, and entering S400;
s300: backing up the attachment file to a first path of the external network equipment, inputting the file name of the attachment file into a position corresponding to a file name field in the form, and moving the attachment file to a second path of the external network equipment;
s400: exporting newly added records in a database table corresponding to the files, generating the records into record files, storing the record files under a third path of the external network equipment, and sending the record files to the internal network equipment;
s500: judging whether a newly added accessory file exists in the second path, if so, sending the newly added accessory file to the intranet equipment;
s600: the intranet equipment imports the received record file into a database corresponding to the intranet equipment, and if an accessory file is received, the received accessory file is stored under a fourth path of the intranet equipment;
s700: and the extranet equipment and the intranet equipment display according to the information stored in the table corresponding to the file to be displayed in the corresponding database.
Further, the judging mode of the attachment file comprises judging through a file suffix name and judging through a path where the file is located.
Further, step S700 specifically includes: the external network equipment judges whether the content at the position corresponding to the file name field in the table corresponding to the file to be displayed in the database of the external network equipment is empty, if not, the accessory file acquired from the first path according to the corresponding table content is displayed together with other information stored in the table corresponding to the file to be displayed in the database, and if the content is empty, only the other information stored in the table corresponding to the file to be displayed in the database is displayed; and the intranet equipment judges whether the content of the corresponding position of the file name field in the table corresponding to the file to be displayed in the database of the intranet equipment is empty, if not, the accessory file acquired from the fourth path according to the corresponding table content is displayed together with other information stored in the table corresponding to the file to be displayed in the database, and if so, only the other information stored in the table corresponding to the file to be displayed in the database is displayed.
An intranet and extranet data synchronization system comprises an intranet device and an extranet device, wherein the intranet device and the extranet device respectively comprise a processor, a memory and computer programs which are respectively stored in the memory and respectively run on the processor, and the processors of the intranet device and the extranet device respectively execute the computer programs to realize the steps of the method of the embodiment of the invention.
According to the technical scheme, the method greatly reduces the transmission quantity of the files, improves the transmission efficiency, reduces the file analysis quantity in the intranet equipment and effectively improves the data synchronization efficiency between the intranet equipment and the extranet equipment by combining the synchronization of the database information synchronization attachment files.
Drawings
Fig. 1 is a schematic flow chart according to a first embodiment of the present invention.
Detailed Description
To further illustrate the various embodiments, the invention provides the accompanying drawings. The accompanying drawings, which are incorporated in and constitute a part of this disclosure, illustrate embodiments of the invention and, together with the description, serve to explain the principles of the embodiments. Those skilled in the art will appreciate still other possible embodiments and advantages of the present invention with reference to these figures.
The invention will now be further described with reference to the accompanying drawings and detailed description.
The first embodiment is as follows:
referring to fig. 1, the present invention provides an intranet and extranet data synchronization method, which includes the following steps:
s100: and the external network equipment analyzes the received file, extracts file information and inputs the file information into a table corresponding to the file in a database of the external network equipment according to classification.
The file information is information representing file content and characteristics, and is different according to different file types, and the type of the specifically extracted file information may be determined according to an actual application scenario, for example, when the file is a chat record file, the file information is account information, a chat record, chat time, and the like, and when the file is a clipboard file, the file information is file content and modification time of the file, and the like.
The file information is classified and input into a database table, for example, the file information content of the chat record file is account information, chat records and chat time, a chat record table is established in the database, first, second and third table columns corresponding to the account information, the chat records and the chat time are arranged in the table, and the file content is stored in the corresponding position.
The import and export of the database file are realized by executing database operation statements.
S200: and judging whether the file contains an attachment file, if so, entering S300, otherwise, deleting the file, and entering S400.
The judging mode of the attachment file comprises the following steps:
(1) judging by a file suffix name, and judging attachment files by files of audio, picture, video and other types;
(2) determine by the path the file is on, for example: files downloaded from the network are stored in a specific path, and the files in the path are judged to be attachment files.
S300: backing up the attachment file to a first path of the external network equipment, inputting the file name of the attachment file into a position corresponding to a file name field in the form, and moving the attachment file to a second path of the external network equipment;
s400: exporting newly added records in a database table corresponding to the files, generating the records into record files, storing the record files under a third path of the external network equipment, and sending the record files to the internal network equipment;
s500: judging whether a newly added accessory file exists in the second path, if so, sending the newly added accessory file to the intranet equipment;
s600: the intranet equipment imports the received record file into a database corresponding to the intranet equipment, and if an accessory file is received, the received accessory file is stored under a fourth path of the intranet equipment;
s700: and the extranet equipment and the intranet equipment display according to the information stored in the table corresponding to the file to be displayed in the corresponding database.
The embodiment specifically comprises the following steps:
the external network equipment judges whether the content at the position corresponding to the file name field in the table corresponding to the file to be displayed in the database of the external network equipment is empty, if not, the accessory file acquired from the first path according to the corresponding table content is displayed together with other information stored in the table corresponding to the file to be displayed in the database, and if the content is empty, only the other information stored in the table corresponding to the file to be displayed in the database is displayed;
and the intranet equipment judges whether the content of the corresponding position of the file name field in the table corresponding to the file to be displayed in the database of the intranet equipment is empty, if not, the accessory file acquired from the fourth path according to the corresponding table content is displayed together with other information stored in the table corresponding to the file to be displayed in the database, and if so, only the other information stored in the table corresponding to the file to be displayed in the database is displayed.
The functions of the databases contained in the intranet equipment and the extranet equipment are the same, the extranet equipment and the intranet equipment can display files to be displayed through a display device, and the display device can be an existing program such as a browser or a software program for setting a value for a specific file.
According to the embodiment of the invention, the file information of the file is extracted and recorded into the corresponding table of the database through the external network equipment, then only the file of the attachment file in the file and the recording file of the database table are transmitted to the internal network equipment, the internal network equipment does not need to analyze and extract the file information again, but directly restores the information displayed on the external network equipment according to the corresponding information in the database table, so that the file and information synchronization of the external network equipment and the internal network equipment is realized, and the data synchronization efficiency between the internal network equipment and the external network equipment is effectively improved.
Example two:
the invention further provides an intranet and extranet data synchronization system, which comprises an intranet device and an extranet device, wherein the intranet device and the extranet device both comprise a processor, a memory and a computer program which is stored in the memory and can run on the processor, the steps in the above method embodiment of the first embodiment of the invention are realized when the processor executes the computer program, and the first path, the second path, the third path and the fourth path in the above mode embodiment are the first path, the second path, the third path and the fourth path which are arranged on the memory.
Further, as an executable scheme, the intranet and extranet data synchronization terminal device may be a computing device such as a desktop computer, a notebook, a palm computer, and a cloud server. The intranet and extranet data synchronization terminal equipment can comprise, but is not limited to, a processor and a memory. It will be understood by those skilled in the art that the above-mentioned composition structure of the intranet and extranet data synchronization terminal device is only an example of the intranet and extranet data synchronization terminal device, and does not constitute a limitation of the intranet and extranet data synchronization terminal device, and may include more or less components than the above, or combine some components, or different components.
Further, as an executable solution, the Processor may be a Central Processing Unit (CPU), other general purpose Processor, a Digital Signal Processor (DSP), an Application Specific Integrated Circuit (ASIC), an off-the-shelf Programmable Gate Array (FPGA) or other Programmable logic device, a discrete Gate or transistor logic device, a discrete hardware component, and the like. The general processor may be a microprocessor or the processor may be any conventional processor, and the processor is a control center of the intranet and extranet data synchronization terminal device, and various interfaces and lines are used to connect various parts of the whole intranet and extranet data synchronization terminal device.
The memory can be used for storing the computer program and/or the module, and the processor realizes various functions of the internal and external network data synchronization terminal equipment by running or executing the computer program and/or the module stored in the memory and calling the data stored in the memory. The memory can mainly comprise a program storage area and a data storage area, wherein the program storage area can store an operating system and an application program required by at least one function; the storage data area may store data created according to the use of the mobile phone, and the like. In addition, the memory may include high speed random access memory, and may also include non-volatile memory, such as a hard disk, a memory, a plug-in hard disk, a Smart Media Card (SMC), a Secure Digital (SD) Card, a Flash memory Card (Flash Card), at least one magnetic disk storage device, a Flash memory device, or other volatile solid state storage device.
While the invention has been particularly shown and described with reference to a preferred embodiment, it will be understood by those skilled in the art that various changes in form and detail may be made therein without departing from the spirit and scope of the invention as defined by the appended claims.
Claims (4)
1. A method for synchronizing internal and external network data is characterized in that: the method comprises the following steps:
s100: the external network equipment analyzes the received file, extracts file information and inputs the file information into a table corresponding to the file in a database of the external network equipment according to classification;
s200: judging whether the file contains an attachment file, if so, entering S300, otherwise, deleting the file, and entering S400;
s300: backing up the attachment file to a first path of the external network equipment, inputting the file name of the attachment file into a position corresponding to a file name field in the form, and moving the attachment file to a second path of the external network equipment;
s400: exporting newly added records in a database table corresponding to the files, generating the records into record files, storing the record files under a third path of the external network equipment, and sending the record files to the internal network equipment;
s500: judging whether a newly added accessory file exists in the second path, if so, sending the newly added accessory file to the intranet equipment;
s600: the intranet equipment imports the received record file into a database corresponding to the intranet equipment, and if an accessory file is received, the received accessory file is stored under a fourth path of the intranet equipment;
s700: and the extranet equipment and the intranet equipment are respectively displayed according to the information stored in the table corresponding to the file to be displayed in the corresponding database.
2. The intranet and extranet data synchronization method of claim 1, wherein: the judging mode of the attachment file comprises judging through a file suffix name and judging through a path where the file is located.
3. The intranet and extranet data synchronization method of claim 1, wherein: step S700 specifically includes: the external network equipment judges whether the content at the position corresponding to the file name field in the table corresponding to the file to be displayed in the database of the external network equipment is empty, if not, the accessory file acquired from the first path according to the corresponding table content is displayed together with other information stored in the table corresponding to the file to be displayed in the database, and if the content is empty, only the other information stored in the table corresponding to the file to be displayed in the database is displayed; and the intranet equipment judges whether the content of the corresponding position of the file name field in the table corresponding to the file to be displayed in the database of the intranet equipment is empty, if not, the accessory file acquired from the fourth path according to the corresponding table content is displayed together with other information stored in the table corresponding to the file to be displayed in the database, and if so, only the other information stored in the table corresponding to the file to be displayed in the database is displayed.
4. An intranet and extranet data synchronization system, characterized by: including intranet equipment and extranet equipment, intranet equipment and extranet equipment all include: a processor, a memory and a computer program respectively stored in the memory and respectively running on the processor, wherein the processors of the intranet device and the extranet device respectively execute the computer program to realize the steps of the method according to claims 1-3.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810461487.1A CN108616603B (en) | 2018-05-15 | 2018-05-15 | Method and system for synchronizing internal and external network data |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810461487.1A CN108616603B (en) | 2018-05-15 | 2018-05-15 | Method and system for synchronizing internal and external network data |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN108616603A CN108616603A (en) | 2018-10-02 |
| CN108616603B true CN108616603B (en) | 2021-11-02 |
Family
ID=63663387
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201810461487.1A Active CN108616603B (en) | 2018-05-15 | 2018-05-15 | Method and system for synchronizing internal and external network data |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN108616603B (en) |
Families Citing this family (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111130990A (en) * | 2019-11-22 | 2020-05-08 | 李子乾 | Mobile comprehensive office system |
| CN111478943A (en) * | 2020-03-06 | 2020-07-31 | 上海数据交易中心有限公司 | Cross-local area network file storage method and system, storage medium and terminal |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101587480A (en) * | 2008-05-21 | 2009-11-25 | 鸿富锦精密工业（深圳）有限公司 | System and method for distributed storage of Notes file |
| CN104883404A (en) * | 2015-06-04 | 2015-09-02 | 上海斐讯数据通信技术有限公司 | Network based file cloud synchronization method |
| CN106407214A (en) * | 2015-08-02 | 2017-02-15 | 郑建锋 | Distributed storage method and system |
| CN107579971A (en) * | 2017-08-31 | 2018-01-12 | 上海欣方智能系统有限公司 | A kind of intranet and extranet method for interchanging data based on security platform |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| TWI613556B (en) * | 2013-01-28 | 2018-02-01 | 通用儀器公司 | Selective data synchronization and transfer to remote distributed database servers |
-
2018
- 2018-05-15 CN CN201810461487.1A patent/CN108616603B/en active Active
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101587480A (en) * | 2008-05-21 | 2009-11-25 | 鸿富锦精密工业（深圳）有限公司 | System and method for distributed storage of Notes file |
| CN104883404A (en) * | 2015-06-04 | 2015-09-02 | 上海斐讯数据通信技术有限公司 | Network based file cloud synchronization method |
| CN106407214A (en) * | 2015-08-02 | 2017-02-15 | 郑建锋 | Distributed storage method and system |
| CN107579971A (en) * | 2017-08-31 | 2018-01-12 | 上海欣方智能系统有限公司 | A kind of intranet and extranet method for interchanging data based on security platform |
Also Published As
| Publication number | Publication date |
|---|---|
| CN108616603A (en) | 2018-10-02 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110008045B (en) | Method, device and equipment for aggregating microservices and storage medium | |
| CN109359118B (en) | Data writing method and device | |
| CN108616603B (en) | Method and system for synchronizing internal and external network data | |
| CN113392158A (en) | Service data processing method and device and data center | |
| CN114510930B (en) | Method, device, electronic equipment and medium for auditing operation document | |
| CN103246729A (en) | Method and system for processing multi-media files of android mobile terminal | |
| CN102132267B (en) | Dynamic metadata | |
| CN111324576B (en) | Recording data storage method and device, storage medium and terminal equipment | |
| CN110865981A (en) | File access method for mobile terminal and mobile terminal thereof | |
| CN111046393B (en) | Vulnerability information uploading method and device, terminal equipment and storage medium | |
| CN113726838B (en) | File transmission method, device, equipment and storage medium | |
| CN112035471B (en) | Transaction processing method and computer equipment | |
| US9659041B2 (en) | Model for capturing audit trail data with reduced probability of loss of critical data | |
| CN107168648B (en) | File storage method and device and terminal | |
| CN110968471A (en) | Program crash problem reporting method, storage medium, electronic device and system | |
| CN112667338B (en) | Business line display control method and device, electronic equipment and storage medium | |
| CN108459928B (en) | Related data association visualization method, terminal device and storage medium | |
| CN113868479A (en) | Method and device for processing service data | |
| CN110908958B (en) | File processing method, device, terminal and storage medium | |
| CN110554915A (en) | Information processing method and device, computer storage medium and terminal | |
| CN114519039B (en) | Data online management method and device, terminal equipment and storage medium | |
| CN113377716B (en) | File acquisition method, electronic equipment, chip and storage medium | |
| CN113641966B (en) | Application integration method, system, equipment and medium | |
| CN104850626A (en) | Method and apparatus for displaying album as search result | |
| CN114443568A (en) | Telegram series application data analysis method, terminal device and storage medium |
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 | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |