CN106561031A - Network data exchange method based on WEB - Google Patents
Network data exchange method based on WEB Download PDFInfo
- Publication number
- CN106561031A CN106561031A CN201510637252.XA CN201510637252A CN106561031A CN 106561031 A CN106561031 A CN 106561031A CN 201510637252 A CN201510637252 A CN 201510637252A CN 106561031 A CN106561031 A CN 106561031A
- Authority
- CN
- China
- Prior art keywords
- data
- module
- xml
- database
- package module
- 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
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/02—Protocols based on web technology, e.g. hypertext transfer protocol [HTTP]
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/80—Information retrieval; Database structures therefor; File system structures therefor of semi-structured data, e.g. markup language structured data such as SGML, XML or HTML
- G06F16/83—Querying
-
- 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/50—Network services
- H04L67/56—Provisioning of proxy services
- H04L67/565—Conversion or adaptation of application format or content
Landscapes
- Engineering & Computer Science (AREA)
- Computer Networks & Wireless Communication (AREA)
- Signal Processing (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a network data interactive method based on WEB. According to the network data interactive method based on WEB, with the target of achieving data exchange in a heterogeneous environment, and based on XML and a Java technology, a solution of heterogeneous data exchange used among enterprises is constructed.
Description
Technical field
A kind of network data exchange method based on WEB relates generally to Computer Database exploitation aspect field.
Background technology
Computer technology is developed rapidly, the appearance of particularly Internet and www so that the information-based and digital Construction process of entire society greatly speeds up.Enterprise, in order to obtain survival and development under increasingly keen competition and challenge, all carries out one after another respective informatization to adapt to informationization, digitlization process.During informatization, each functional department of enterprises all constructs numerous operation systems according to self-demand, and these systems adopt data base administration data mostly.But unfortunately, most of business enterprice sector does not carry out unified planning at its informatization initial stage, so that adopting different hardware platforms under different times, varying environment, the operation system that different operating system or different database technologys are set up is often separate application system.In routine duties, due to the distribution of geographic area, one work usually needs the business datum collaboration in multiple department service systems to process just can be completed, but do not have a set of good data exchange, shared mechanism between these departments, so as to bring inconvenience to the management of these departments and other routine works, and greatly reduce operating efficiency.
How to obtain and management business data from scattered application system database each other; realize that the resource between various Database Systems merges and shared; how the resource that have built up is protected; the database that all departments have used how is made full use of to have become enterprise's problem demanding prompt solution, while whether this system development also become based on heterogeneous database is successfully crucial.
How to obtain and management business data from scattered application system database each other; realize that the resource between various Database Systems merges and shared; how the resource that have built up is protected; the database that all departments have used how is made full use of to have become enterprise's problem demanding prompt solution, while whether this system development also become based on heterogeneous database is successfully crucial.
In order to change above-mentioned situation, generally there are two kinds of methods, one kind is to abolish existing heterogeneous system, according to unified each operation system of standard whole body reconstruction；Another kind is each integrated isomerous system by the system integration.Different systems are treated, enterprise can be in different ways：The system of old, operational excellence, can adopt integrated scheme, application system integration to together；System that is new, falling behind can be rebuild according to unified standard.But, in the long run, it is not the good scheme of feasibility that new business system is rebuild in unified planning, because along with the extension of business, previous unified planning may not adapt to new development need, previous new business system can also be changed into old system of today.This means that one system of needs to help them to carry out data message integration, so that system resource can be fully utilized.
XML is used as an emerging markup language towards Internet applications, it develop rapidly make its own Jing become data represent and information exchange de facto standards, the appearance of XML technology simultaneously brings hope to data exchange, and it causes the extensive concern of industry with advantage the characteristics of its own and in terms of data exchange.One of maximum purposes of XML is exactly the exchange intermediary as different pieces of information library storage system on network.There are many different operating system platforms and the data for storing by different way on network at present, XML provides general data representation format, and then there is provided the shortcut that data in～bar different medium are exchanged.The method realizes the data exchange between heterogeneous database using XML.
The content of the invention
Retrieved without the application materials found with regard to this system aspects by national patent.
For legacy switching systems in the deficiency of the aspects such as extensibility, reusability, using new XML technology is compared in current field of data exchange favorable expandability, a highly versatile based on XML is proposed.Efficiently, healthy and strong, easy-to-use data transfer, switching plane, analyzes with reference to more than, and the overall framework for selecting system is hub-and-spoke configuration.
Data exchange between each application system is by XML as the medium for exchanging, XML format is converted to firstly the need of the data to be exchanged, it is then delivered to switching centre's node, data are sent in target database after switching centre's node processing, so as to complete the data transfer between disparate databases.In the present system, data switching center is crucial, and it couples the popular relevant database such as SQL Server, Oracle, Sybase
Come, but be not to form a unified database.Access to any database is all carried out by an interface subscribed, and is needed the user of data and need not be faced the details of concrete database and data source, it is only necessary to tells data switching center several pick patterns that it is wanted.
XML is possible to preferably overcome the shortcomings of the method for interchanging data of traditional approach for isomeric data data exchange.It is realizing the data exchange between source database and target database using XML as medium based on the isomeric data data exchange of XML.Good versatility and flexibility are had based on the data exchange of XML.
Because relational database is presently the most wide variety of database, therefore the data exchange between main research isomeric relationship database herein.The main difficulty that isomeric relationship database data is exchanged is a lack of an effective common data model Unify legislation relation schema and relation.The appearance of XML solves well this problem.Plain text, the platform-independent of XML meets first the professional platform independence solved required for isomeric relationship data source；The powerful structural and good contrary opinion sexual satisfaction of the XML needs of the structure of relationship between expression database and various constraints；XML excellent interactivity brings conveniently for conversion so that data are easy to manipulate；The autgmentability that is easy to of XML allows application to further expand：Formatting for XML allows the result changed out to have more forms of expression.Therefore, XML completely can be used as the common data model of isomeric relationship database conversion.At present, XML technology gradually starts the data exchange for being applied to heterogeneous database, and the standard of in fact data exchange is had become, changing isomeric relationship database and also provide convenience with the integrated conversion of other data types into relational database with XML as common data model.
For the versatility and reusability of strengthening system, modularized design, mainly database connection module are carried out to system；Data extraction module；Data package module；XML sending modules；XML receiver modules；Data analysis module；Data conversion mould；Data load-on module.
(1) database connection module：The module realizes the connection with various databases according to the requirement of user.
(2) data extraction module：The module is realized extracting the data that certain condition is met in source database according to demand, and carry it is honest and just go out beam data be converted to XML format.
(3) data package module：In view of data in transmitting procedure safety issue, so needing first to be encrypted data before data transmission.Data package module is encrypted first to XML data, and then the data for having processed are packaged according to the call format of receiving terminal and the rule of concrete business datum.
(4) XML sending modules：The module is responsible for that XML data is sent to specified destination by various host-host protocols.
(5) XML receiver modules：The module is responsible for the XML data that receiving end/sending end sends.
(6) data analysis module：The data that recipient receives all be through sender encapsulation data, data analysis module be responsible for receive data decapsulation, and data are decrypted solution process obtain XML format data.
(7) data conversion module：The module realizes a kind of XML document to the conversion between another kind of XML document by using XSLT files.
(8) data load-on module：After conversion and being sent to the data Cun Chudao target database at target database end.
Concrete operations are flow path switch analysis of the data from source database to target database：
(1) first the data source of data exchange is participated in by calling database connection module connection according to user's request.
(2) system by data extraction module need participate in exchange data extract from source database and according to certain rule shellfish IJ the data conversion extracted from database into XML format file.
(3) data package module is called, XML data is encrypted, and the call format and concrete business rule according to data switching center's data encapsulation carries out SOAP encapsulation the XML data for processing, and the attribute (destination address, data type etc.) of correlation is added in SOAP.
(4) system calls the data is activation that data transmission blocks were processed (3rd) step by certain method and agreement (such as SOAP+HXTP) to data switching center.
(5) data switching center receives the data that source database end sends over by calling data reception module, then system recall data analysis module incoming data are decapsulated, decryption processing, so as to obtain the data of XML format.
(6) data switching center receives system after the data that source database end is transmitted and can check and send the data pattern of data type with the presence or absence of source database end on server, if do not had, just the XMLSchema of incoming data is passed the data pattern of data type as sender, and proceed to (8th) step.
(7) if there is the data pattern of sender's forward data, whether the data for then being transmitted with the data pattern checking meet the structure of pattern defined, if do not met, the data pattern of incoming data is extracted, and this pattern is transmitted into the data pattern of data type as sender.
(8) with the presence or absence of the conventional data pattern of sender's incoming data type on systems inspection server, if it does not exist, then the data pattern of sender and is proceeded to step (11) as the conventional data pattern of the data type.
(9) if it is present whether checking conventional data pattern is consistent with the data pattern of sender, if unanimously, step (11) is proceeded to.
(10) if inconsistent, check server on the presence or absence of corresponding XSLT (4.5.1 section introduce) document, if it is present with the XSLT documents sender's transmission come XML document be converted to general XML format document.
If it does not, generating an XSLT document by mapping relations, then non-universal XML document is completed to the conversion of general XML document with the XSLT documents.
(11) systems inspection target database end whether there is on the server the data pattern for wanting exchange data type, if it does not exist, then return information " target database end does not have log-on data switch type ".If it is present checking whether the data pattern is consistent with general data pattern, if consistent, step (12) is gone to, if inconsistent, check for corresponding XSLT documents.If it is present general XML document to be converted to the XML document for meeting target database end data pattern with the XSLT documents；If it does not, generating an XSLT document by mapping relations, general XML document is converted to the XML document for meeting target database end data pattern with the XSLT documents.
(12) system calls data package module that the XML data that (11st) step is obtained is encrypted and SOAP encapsulation, and association attributes is added in SOAP.
(13) system call again data transmission blocks by certain method and agreement the data is activation after process to target database end.
(14) target database end calls data reception module to receive the data that data switching center sends, and calls data of the data analysis module to receiving to be analyzed process.
(15) target database end calls data load-on module that the data of XML format are loaded in target database.
Claims (8)
1. a kind of network data exchange method based on WEB is mainly database connection module；Data extraction module；Data package module；XML sending modules；XML receiver modules；Data analysis module；Data conversion mould；Data load-on module.
2. according to claim 1 database connection module：The module realizes the connection with various databases according to the requirement of user.
3. according to claim 1 data extraction module：The module is realized extracting the data that certain condition is met in source database according to demand, and carry it is honest and just go out beam data be converted to XML format.
4. according to claim 1 data package module：In view of data in transmitting procedure safety issue, so needing first to be encrypted data before data transmission;
Data package module is encrypted first to XML data, and then the data for having processed are packaged according to the call format of receiving terminal and the rule of concrete business datum.
5. according to claim 1 data package module XML sending modules：The module is responsible for that XML data is sent to specified destination by various host-host protocols.
6. according to claim 1 data package module XML receiver modules：The module is responsible for the XML data that receiving end/sending end sends.
7. according to claim 1 data package module data analysis module：The data that recipient receives all be through sender encapsulation data, data analysis module be responsible for receive data decapsulation, and data are decrypted solution process obtain XML format data.
8. according to claim 1 data package module data conversion module：The module realizes a kind of XML document to the conversion between another kind of XML document by using XSLT files.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510637252.XA CN106561031A (en) | 2015-10-05 | 2015-10-05 | Network data exchange method based on WEB |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510637252.XA CN106561031A (en) | 2015-10-05 | 2015-10-05 | Network data exchange method based on WEB |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN106561031A true CN106561031A (en) | 2017-04-12 |
Family
ID=58485175
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201510637252.XA Pending CN106561031A (en) | 2015-10-05 | 2015-10-05 | Network data exchange method based on WEB |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN106561031A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107301250A (en) * | 2017-07-27 | 2017-10-27 | 南京南瑞集团公司 | A kind of Various database cooperates with backup method |
-
2015
- 2015-10-05 CN CN201510637252.XA patent/CN106561031A/en active Pending
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107301250A (en) * | 2017-07-27 | 2017-10-27 | 南京南瑞集团公司 | A kind of Various database cooperates with backup method |
| CN107301250B (en) * | 2017-07-27 | 2020-06-26 | 南京南瑞集团公司 | Multi-source database collaborative backup method |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| JP7463544B2 (en) | Blockchain message processing method, apparatus, computer device, and computer program | |
| CN106776780B (en) | Data exchange and sharing method and system in cloud environment | |
| CN106850788B (en) | Integrated framework and integrated approach towards multi-source heterogeneous geographic information resources | |
| CN100456682C (en) | Cluster communication system and method for establishing discussing cluster | |
| US20020143644A1 (en) | Connection tool for connecting analytical applications to electronic document sources | |
| CN1233801A (en) | Message broker apparatus, method and computer program product | |
| WO2009082961A1 (en) | Information processing method, system, and information consolidation device | |
| RU2008108838A (en) | ACCESSIBILITY DATA SERVICE | |
| CN102006245B (en) | Date exchanging and sharing platform | |
| CN102833080A (en) | Process-to-process communication method of application software and system | |
| CN109377220B (en) | Block chain-based media data transaction method and system and computer storage medium | |
| CN101739421A (en) | XML-based data integration information exchange platform | |
| CN101211360A (en) | System and method for processing a plurality of data form of report forms data source | |
| CN111491037A (en) | Communication method with object storage server through SFTP data stream | |
| WO2009121286A1 (en) | Method, system, device and terminal for batch processing xml documents | |
| CN105763424B (en) | A kind of literal information processing method and device | |
| CN103092982B (en) | Based on the information service system of multi views business model | |
| WO2011143947A1 (en) | Method and system for realizing application of machine-to-machine/man terminal based on groups | |
| WO2012116579A1 (en) | Information feedback method and corresponding server | |
| WO2017107652A1 (en) | Data access method, device and system | |
| CN103179018A (en) | Method and server for realizing cross-language communication | |
| CN106561031A (en) | Network data exchange method based on WEB | |
| CN112559472B (en) | File transmission method, device, computer equipment and storage medium | |
| CN106130695A (en) | A kind of data transmission method and system | |
| CN105550185A (en) | Network data exchange system based on JAVA and XML |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| WD01 | Invention patent application deemed withdrawn after publication |
Application publication date: 20170412 |
|
| WD01 | Invention patent application deemed withdrawn after publication |