CN101729381B - Data dynamic customizing and exchanging system and method based on external system - Google Patents
Data dynamic customizing and exchanging system and method based on external system Download PDFInfo
- Publication number
- CN101729381B CN101729381B CN2008102016579A CN200810201657A CN101729381B CN 101729381 B CN101729381 B CN 101729381B CN 2008102016579 A CN2008102016579 A CN 2008102016579A CN 200810201657 A CN200810201657 A CN 200810201657A CN 101729381 B CN101729381 B CN 101729381B
- Authority
- CN
- China
- Prior art keywords
- data
- database
- module
- receiving
- transmitting terminal
- 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
Landscapes
- Storage Device Security (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses data dynamic customizing and exchanging system and method based on an external system. The data dynamic customizing and exchanging system comprises a data capturing module, a sending-end data processing module and a sending-end data transmitting module of a data sending unit as well as a receiving-end data transmitting module and a receiving-end data processing module of a data receiving unit. The data dynamic customizing and exchanging system and method based on the external system can realize the free customization for the data capture of a target database because the data capturing module is provided with configuration files (xml and sql), thereby enhancing the flexibility and the efficiency of the data capture; and besides, the sending-end data processing module protects data exchange through a digital certificate so that the safety of the data exchange is ensured, and the secrecy is greatly enhanced.
Description
Technical field
The present invention relates to field of data exchange, more particularly, relate to a kind of Data Dynamic customization and switching system and method based on external system.
Background technology
In the present field of data exchange, client usually will be carried out exchanges data with the database that data source is provided in a distant place, such as in user vehicle big customer standards service system item, just need carry out exchanges data with the database of machining center.But solution all can not well solve at present.
Present solution generally is to set up to share ftp server, and there are many shortcomings in this scheme:
1, FTP plaintext transmission, Information Security is not enough;
2, data uncompressed, efficiency of transmission is not high;
3, many accounts of FTP share directory, file operation is uncontrollable;
4, switch log has no way of searching, and can not review.
So press for a kind of technical scheme is provided, this scheme can be set up and machining center ENCRYPTION FOR DATA BASE data exchange channel, the exchanges data of crossing over the internet, and also the data of obtaining can freely customize.
Summary of the invention
The present invention aims to provide a kind of Data Dynamic customization and switching system and method based on external system, can realize that the data of free customized type obtain, and realizes the enciphered data exchange.
On the one hand, the present invention provides a kind of Data Dynamic customization and switching system based on external system, comprising:
Data transmission unit is obtained data of database that data source is provided and to client output, is further comprised,
Data capture module; Be connected and according to the predetermined regular said data of database that grasps that is provided with the said database of data source that provides; Wherein, The predetermined rule that is provided with is meant, disposes some task and sql configuration files that trigger according to the different timing specification by the config.xml configuration file of data capture module configuration and obtains said data of database according to said task timing automatic, and save as document form;
The transmitting terminal data processing module receives the data of said data capture module and carries out data compression, encryption and protocol packing successively;
Transmitting terminal data relay module receives the packing data that said transmitting terminal data processing module is exported;
Data Receiving unit, input connect said data transmission unit, and output connects said client, further comprise,
Receiving terminal data relay module is connected and receives the packing data of its transfer with said transmitting terminal data relay module;
The receiving terminal data processing module receives the packing data of said receiving terminal data relay module transfer, carries out successively that agreement unpacks, data decryption and decompress(ion), the data after handling is exported to the client of connection.
Said transmitting terminal data processing module is encrypted data through the PKI of digital certificate, and said receiving terminal data processing module is deciphered data through the private key of digital certificate.
Said transmitting terminal data relay module connects the go forward side by side line data exchange of said receiving terminal data relay module through the internet; Said transmitting terminal data relay module and said receiving terminal data processing module transit module are all registered the work compound agreement, wherein comprise both sides' Data Receiving address.
On the other hand, the present invention provides a kind of Data Dynamic customization and switching method based on external system, comprising:
Data sending step, obtain data of database that data source is provided and, further comprise to client output:
A, grasp the said data of database that data source is provided according to the predetermined rule that is provided with; Wherein, The predetermined rule that is provided with is meant; Dispose some task and sql configuration files that trigger according to the different timing specification by the config.xml configuration file of data capture module configuration and obtain said data of database, and save as document form according to said task timing automatic;
B, the data of said extracting are carried out data compression, encryption and protocol packing successively;
C, send the data of said step b packing to the recipient;
The Data Receiving step receives the data that above-mentioned c step is sent, and further comprises:
To the data that receive carry out successively that agreement unpacks, data decryption and decompress(ion).
Said step b encrypts data through the PKI of digital certificate, and said Data Receiving step is deciphered data through the private key of digital certificate.
The data receiver of said step c and data receiver all register the work compound agreement, wherein comprise both sides' Data Receiving address.
Adopt Data Dynamic customization and switching system and the method based on external system of the present invention; Because the present invention is provided with configuration file config.xml and sql; Configuration file config.xml is provided with some triggering according to the different timing specification of tasks; Said sql configuration file obtains the data of target database and saves as document form according to said task timing automatic; So can realize freely customizing, increase flexibility and efficient that data are obtained to what the data of target database were obtained; Transmitting terminal data processing module of the present invention is in addition encrypted data through the PKI of digital certificate; Then during transfer of data to client; The receiving terminal data processing module of said invention is deciphered data through the private key of digital certificate; So just can guarantee the fail safe of exchanges data, its confidentiality is improved greatly.
Description of drawings
Fig. 1 shows the structural principle sketch map of system according to the invention;
Fig. 2 shows the workflow diagram of system according to the invention;
Fig. 3 shows the schematic flow sheet of the method for the invention.
Embodiment
Referring to Fig. 1 and Fig. 2, the frame of broken lines among Fig. 1 has shown a kind of Data Dynamic customization and switching system based on external system of the present invention, comprising:
Above-mentioned config.xml configuration file of data capture module 11 configurations and being constructed as follows of sql configuration file:
The config.xml configuration file:
<?xml?version="1.0"encoding="UTF-8"?>
<JobManager
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<MshParameters>
<mshClientURLStr>http://localhost:8081/msh/services/FileExchange
Client</mshClientURLStr>
<encryptionFlag>true</encryptionFlag>
<fromPartyId>ahbaosteel</fromPartyId>
<toPartyId>BGGM</toPartyId>
</MshParameters>
<Jobs>
<ExpDbDataJob>
<name>test?job</name>
<group>default?group</group>
<cronExpression>0/60****?</cronExpression>
<sqlStr>d:\\baostar\\sql_file\\GetMaterialInfo.sql</sqlStr>
<expFileName>d:\\baostar\\output_file\\job1</expFileName>
<fieldSeparator>~|</fieldSeparator>
<dbUrl>jdbc:oracle:thin:10.90.104.54:1521:bmmis</dbUrl>
<userName>bm</userName>
<password>password</password>
</ExpDbDataJob>
</Jobs>
</JobManager>
The GetMaterialInfo.sql configuration file:
select
a.rkfs?as?inputType,
a.username?as?inputOperatePerson,
a.mjh?as?coilNo,
b.pmmc?as?productDesc,
a.hdas?thick,
a.kdas?width,
a.cd?as?length,
a.jz?as?weightNet,
a.mz?as?weightGross
from?wm004a,
mt009b
where?to_char(a.rkrq,′yyyymmddhh24miss′)>=
to_char(sysdate,′yyyymmdd′)||′070000′
and?to_char(a.rkrq,′yyyymmddhh24miss′)<
to_char(sysdate,′yyyymmdd′)||′120000′
Said configuration file config.xml is provided with some triggering according to the different timing specification of tasks, and said sql configuration file obtains said data of database and saves as document form according to said task timing automatic.
Referring to Fig. 2; Fig. 2 is the workflow diagram of one embodiment of system according to the invention; This embodiment is the exchanges data of machining center database 30 and client 40 (application system platform); Data capture module 11 is an extracting data application automatically; Transmitting terminal data processing module 12 and receiving terminal data processing module 22 are MSHC (message service handler client); Transmitting terminal data relay module 13 and receiving terminal data relay module 21 are MSHS (message servicehandler server); Data capture module 11 among Fig. 2 is given transmitting terminal data processing module 12 through Web Service interface with the data passes that grabs; Transmitting terminal data processing module 12 passes to transmitting terminal data relay module 13 through the ebXML agreement with ciphered data as a result, and the form of transmitting terminal data relay module 13 through the public network transmission (like the internet etc.) be encrypted data transmission to receiving terminal data relay module 21, receiving terminal data relay module 21 through the ebXML agreement with encrypted data transmission to receiving terminal data processing module 22; Receiving terminal data processing module 22 decompresses immediately and deciphers, at last through transfer of data to the client 40 (application system platform) after Web Service interface will be deciphered.
Above-mentioned MSHC can send and accept message according to the sender and the recipient of appointment.When sending message, advanced line data compression (reducing the data traffic in the transmission) is encrypted data through PKI according to ca authentication then.When receiving message, earlier data are carried out the private key deciphering, and then carry out data decompression.In the above encryption system, follow public key encryption, the principle of private key deciphering.Different machining centers is issued the mathematic for business certificate.
The major function of above-mentioned MSHS is, receives the message that MSHC sends, and remains into database, waits for that MSHC takes this message away.To the transmitting-receiving daily record query function is provided.Can also carry out message between the MSHS; Need on two MSHS, to register simultaneously CPA (cooperation protocol agreement); Respectively the other side's receiver address (url) is filled in into; This embodiment is applicable to the scene of striding the internet, because internet network situation instability is guaranteed the normal transmission of message by the retransmission mechanism of shaking hands between the MSHS.
Referring to Fig. 3, the present invention also provides a kind of Data Dynamic customization and switching method 100 based on external system, comprising:
101, grasp database data.The rule that is provided with according to predetermined grasps the said data of database that data source is provided; This step realizes through configuration file config.xml and sql; Said configuration file config.xml is provided with some triggering according to the different timing specification of tasks, and said sql configuration file obtains said data of database and saves as document form according to said task timing automatic.
102, compress-encrypt data.Data to said extracting are carried out data compression, encryption and protocol packing successively, and cipher mode is through the PKI of digital certificate data to be encrypted.
103, send data.Be the data that the sending direction recipient sends said step 102 packing, data receiver and data receiver all register the work compound agreement, wherein comprise both sides' Data Receiving address.
104, deciphering decompressed data.To said data carry out successively that agreement unpacks, data decryption and decompress(ion), manner of decryption is through the private key of digital certificate data to be deciphered.
Said Data Dynamic customization customizes and switching system the same as or similar to said Data Dynamic with principle, embodiment and the implementation procedure of switching method 100, so repeat no more at this.
Those of ordinary skill in the art will be appreciated that; Above embodiment is used for explaining the present invention; And be not to be used as qualification of the present invention; As long as in connotation scope of the present invention, all will drop on claim scope of the present invention to variation, the modification of the above embodiment.
Claims (6)
1. Data Dynamic customization and switching system based on an external system is characterized in that, comprising:
Data transmission unit is obtained data of database that data source is provided and to client output, is further comprised,
Data capture module; Be connected and according to the predetermined regular said data of database that grasps that is provided with the said database of data source that provides; Wherein, The predetermined rule that is provided with is meant, disposes some task and sql configuration files that trigger according to the different timing specification by the config.xml configuration file of data capture module configuration and obtains said data of database according to said task timing automatic, and save as document form;
The transmitting terminal data processing module receives the data of said data capture module and carries out data compression, encryption and protocol packing successively;
Transmitting terminal data relay module receives the packing data that said transmitting terminal data processing module is exported;
Data Receiving unit, input connect said data transmission unit, and output connects said client, further comprise,
Receiving terminal data relay module is connected and receives the packing data of its transfer with said transmitting terminal data relay module;
The receiving terminal data processing module receives the packing data of said receiving terminal data relay module transfer, carries out successively that agreement unpacks, data decryption and decompress(ion), the data after handling is exported to the client of connection.
2. Data Dynamic customization as claimed in claim 1 and switching system is characterized in that said transmitting terminal data processing module is encrypted data through the PKI of digital certificate, and said receiving terminal data processing module is deciphered data through the private key of digital certificate.
3. Data Dynamic customization as claimed in claim 2 and switching system; It is characterized in that; Said transmitting terminal data relay module connects the go forward side by side line data exchange of said receiving terminal data relay module through the internet; Said transmitting terminal data relay module and said receiving terminal data relay module are all registered the work compound agreement, wherein comprise both sides' Data Receiving address.
4. Data Dynamic customization and switching method based on an external system is characterized in that, comprising:
Data sending step, obtain data of database that data source is provided and, further comprise to client output:
A, grasp the said data of database that data source is provided according to the predetermined rule that is provided with; Wherein, The predetermined rule that is provided with is meant; Dispose some task and sql configuration files that trigger according to the different timing specification by the config.xml configuration file of data capture module configuration and obtain said data of database, and save as document form according to said task timing automatic;
B, the data of said extracting are carried out data compression, encryption and protocol packing successively;
C, send the data of said step b packing to the recipient;
The Data Receiving step receives the data that above-mentioned c step is sent, and further comprises:
To the data that receive carry out successively that agreement unpacks, data decryption and decompress(ion).
5. Data Dynamic customization as claimed in claim 4 and switching method is characterized in that said step b encrypts data through the PKI of digital certificate, and said Data Receiving step is deciphered data through the private key of digital certificate.
6. Data Dynamic customization as claimed in claim 5 and switching method is characterized in that the data receiver of said step c and data receiver all register the work compound agreement, wherein comprise both sides' Data Receiving address.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN2008102016579A CN101729381B (en) | 2008-10-23 | 2008-10-23 | Data dynamic customizing and exchanging system and method based on external system |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN2008102016579A CN101729381B (en) | 2008-10-23 | 2008-10-23 | Data dynamic customizing and exchanging system and method based on external system |
Publications (2)
Publication Number | Publication Date |
---|---|
CN101729381A CN101729381A (en) | 2010-06-09 |
CN101729381B true CN101729381B (en) | 2012-01-11 |
Family
ID=42449632
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN2008102016579A Active CN101729381B (en) | 2008-10-23 | 2008-10-23 | Data dynamic customizing and exchanging system and method based on external system |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN101729381B (en) |
Families Citing this family (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN105551220A (en) * | 2015-12-29 | 2016-05-04 | 中冶南方工程技术有限公司 | Remote data acquisition method for dry dust removal of converter gas |
CN105551221B (en) * | 2015-12-29 | 2019-01-25 | 中冶南方工程技术有限公司 | A kind of remote data acquisition system of dry dedusting of converter |
CN105808348A (en) * | 2016-03-01 | 2016-07-27 | 浪潮软件股份有限公司 | Data service scheduling apparatus, system and method |
Citations (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20060036642A1 (en) * | 2001-03-14 | 2006-02-16 | Microsoft Corporation | Schemas for a notification platform and related information services |
CN1738309A (en) | 2004-08-20 | 2006-02-22 | 华为技术有限公司 | Data exchanging method |
CN101079889A (en) * | 2007-06-26 | 2007-11-28 | 中兴通讯股份有限公司 | Data transmission system and its transmission method |
-
2008
- 2008-10-23 CN CN2008102016579A patent/CN101729381B/en active Active
Patent Citations (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20060036642A1 (en) * | 2001-03-14 | 2006-02-16 | Microsoft Corporation | Schemas for a notification platform and related information services |
CN1738309A (en) | 2004-08-20 | 2006-02-22 | 华为技术有限公司 | Data exchanging method |
CN101079889A (en) * | 2007-06-26 | 2007-11-28 | 中兴通讯股份有限公司 | Data transmission system and its transmission method |
Also Published As
Publication number | Publication date |
---|---|
CN101729381A (en) | 2010-06-09 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
JP4813006B2 (en) | Secure packet-based data broadcasting architecture | |
CN102088441B (en) | Data encryption transmission method and system for message-oriented middleware | |
CN105376261B (en) | Encryption method and system for instant messaging message | |
CN101150595A (en) | A real time file transmission method, system and device | |
CN105792190B (en) | Data encryption, decryption and transmission method in communication system | |
CN106453391A (en) | Long repeating data encryption and transmission method and system | |
CN105610847B (en) | A method of support more switching node electronic government documents safe transmissions to exchange | |
CN102546597B (en) | The method that communicating terminal message encryption transmits, communicating terminal, server and system | |
CN112911588A (en) | Lightweight narrowband Internet of things secure transmission method and system | |
CN101729381B (en) | Data dynamic customizing and exchanging system and method based on external system | |
JP6391823B2 (en) | RDP data collection apparatus and method | |
CN109951378B (en) | File encryption transmission and sharing method in instant messaging | |
CN111884802A (en) | Media stream encryption transmission method, system, terminal and electronic equipment | |
CN109660568B (en) | Method, equipment and system for realizing network talkback security mechanism based on SRTP | |
CN102780702A (en) | System and method for document security transmission | |
WO2004068818A1 (en) | Improvements relating to security over a network | |
CN110022204A (en) | Divide the method for enhancing file security communications security based on content truly randomization | |
CN101262340A (en) | MMS encryption method and mobile terminal for transmitting and receiving encrypted MMS | |
CN103634313B (en) | Address list processing method and device, as well as mobile terminal | |
CN104243291A (en) | Instant messaging method and system thereof capable of guaranteeing safety of user communication content | |
EP2713576A1 (en) | Method and device for processing streaming media content | |
CN1327322A (en) | High speed copying protection method | |
CN103634276A (en) | Privacy protection method for instant communication messages | |
CN112261057A (en) | Encryption processing system for audio and video call | |
CN101426199B (en) | ZigBee wireless network data safe transmission system |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
C06 | Publication | ||
PB01 | Publication | ||
C10 | Entry into substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
C14 | Grant of patent or utility model | ||
GR01 | Patent grant | ||
EE01 | Entry into force of recordation of patent licensing contract |
Application publication date: 20100609 Assignee: SHANGHAI BAOHUA INTERNATIONAL TENDERING CO., LTD. Assignor: Shanghai Baosight Software Co., Ltd. Contract record no.: 2013310000085 Denomination of invention: Data dynamic customizing and exchanging system and method based on external system Granted publication date: 20120111 License type: Exclusive License Record date: 20130712 |
|
LICC | Enforcement, change and cancellation of record of contracts on the licence for exploitation of a patent or utility model |