CN103235813A - Ufida financial core system and activity based costing system data synchronization method - Google Patents
Ufida financial core system and activity based costing system data synchronization method Download PDFInfo
- Publication number
- CN103235813A CN103235813A CN2013101466377A CN201310146637A CN103235813A CN 103235813 A CN103235813 A CN 103235813A CN 2013101466377 A CN2013101466377 A CN 2013101466377A CN 201310146637 A CN201310146637 A CN 201310146637A CN 103235813 A CN103235813 A CN 103235813A
- Authority
- CN
- China
- Prior art keywords
- data
- service
- ufida
- message
- xml
- 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
Images
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses an ufida financial core system and activity based costing system data synchronization method. Presently, data between an ufida financial core system and an activity based costing system cannot be integrated. The ufida financial core system and activity based costing system data synchronization method is based on the Web Service technology and is characterized in that one of the ufida financial core system and activity based costing system serving as a service provider issues service to a data service platform, the other one of ufida financial core system and activity based costing system serving as a service requester sends a service invoking request to the data service platform, the service provider packages and issues Web services and leads the Web services to be available, the service requester seeks service description from the data service platform and then sends the invoking request to the data service platform, the data service platform receives the invoking request and finds matched contents of the service provider and the service requester, finally the result is returned to the service requester with sharing data to be Extensible Makeup Language (EML) format information, and data synchronization between the ufida financial core system and the activity based costing system is completed. The ufida financial core system and activity based costing system data synchronization method solves the problem of data synchronization between the ufida financial core system and the activity based costing system, and improves data comprehensive utilization ratio.
Description
Technical field
The present invention relates to the data integration field based on Web Service technology, be specifically related to the method for data synchronization between UFSOFT's finance core system (being called for short the NC system) database and operating cost system (the being called for short the ABC system) database.
Background technology
In recent years, along with informationalized construction, a lot of enterprises are in the different periods of history, set up operation system based on disparate databases successively at different business demands, as application systems such as performance appraisal system, daily production report system, financial accounting system, the asset management system, general ledger systems, data representation form between the disparate databases varies, the existence that this just causes " information island " phenomenon causes can't carrying out active data communication between each operation system.For solving " information island " phenomenon that NC system and ABC system occur when mutual, raising aggregation of data utilization factor, one efficiently method of data synchronization press for.
At present, there is following problem in NC system and the ABC system data synchronization:
1) isomerism problem: because the NC system adopts the ORACLE database, the ABC system adopts SQL SERVER database, and the difference of these two databases makes its data representation format and grammer separately have great difference;
2) distributivity problem: the management ownership of NC system and ABC system is different, and the foundation of system data is dispersed on each network application node of enterprises;
3) autonomy problem: NC system and ABC system all have the characteristics of relative independentability, and the NC DSN can be revised the data form of expression and the grammer of native system arbitrarily under the situation of not notifying the ABC system.
Web Service(Web service) being a kind of distributed computing technique, is the Distributed Application assembly that meets industrywide standard, can be based on standard and the interoperability of technology between Internet realization application program of opening.Web Service issues and visits commercial application service by standard XML protocol and message format in network.Can place programmable element at the Web website by Web Service, issue can be satisfied the online application service of specific function, and can use various computing platforms, handheld device, household electrical appliance that it is dynamically searched, subscribes to and visits, greatly expand the function of application program, realized the dynamic Service of software.
Web Service is the up-to-date distributed computing technology of Microsoft that builds on SOA (service-oriented architecture) basis, component software (comprising object from different system, function etc.) can be issued as service.In brief, Web Service is the modularization business procedure of self-described, through Internet service logic is issued as service by programmable interface, and dynamically searches, subscribes to and use these services by the Internet agreement.
Summary of the invention
Fundamental purpose of the present invention is to provide the method for data synchronization between the disparate databases of a kind of NC of being used in system and ABC system, and the distributivity of shadow data, isomerism and autonomy improve the comprehensive utilization ratio of data.
In order to achieve the above object, technical scheme of the present invention is achieved in that
1, ISP (NC system or ABC system) encapsulates the data message in its database with the XML form, is means with Web Service technology, XML document is packaged into Web service is published to network;
2, service requester (ABC system or NC system) sends service invocation request to the ISP, and through authentication and secure match, the ISP transmits the XML document of corresponding data information to service requester;
3, after service requester obtains XML document, XML document is resolved, extract data message, and store these information into local data base.
The present invention proposes the method based on data sync between the NC system of Web Service and the ABC system, by feat of the professional platform independence of Web Service technology, easily structure property and high efficiency, adopt the inventive method, can realize the synchronous of data efficiently and accurately and communicate by letter.
Description of drawings
Fig. 1 is based on the method model of data sync between the database of Web Service.
Fig. 2 is based on method of data synchronization model overall workflow figure.
Embodiment
Core concept of the present invention is: be the technological means of data transmission with Web Service interface, wherein the document information of XML form is the respective transmissions content, and the agreement of XML message transmission institute foundation is Simple Object Access Protocol (SOAP).
Below in conjunction with accompanying drawing the present invention is described in further detail.
As shown in Figure 1, service-oriented business data method for synchronous architecture mainly is made up of ABC system, NC system and data, services platform three parts.The data, services platform is a virtual service register center, based on Web Service interface, has played the effect of core in this model.Wherein the data transmission between ABC system and the NC system all realizes by the data, services platform.It needs data in synchronization information to be packaged into Web service each by Web Service technology, is deployed in the data, services platform, calls for other node.Because the professional platform independence of Web Service technology, this model has its good extendability, and this model can add functional node arbitrarily and carry out data sync, and can not have any impact to former application system.
When shared data by the NC system synchronization during to the ABC system, at first the service describing of Web Service to be encapsulated as ISP's NC system, then the content of encapsulation is issued, make service available.Service requester ABC system at first will find service describing from the data, services platform, send call request to the data, services platform then, the data, services platform receives call request, find the content of ISP and service requester coupling, and call Web Service, to share data at last and give service requester with the XML format information return results of standard, so just finish the mutual of these three roles, finish the transmission of data simultaneously.
In like manner, when shared data are by the ABC system synchronization during to the NC system, the ABC system is exactly the ISP, and the NC system is as a side who receives data, i.e. service requester.The ABC system provides service, and is published to the data, services platform.The NC system is to the service of data, services platform request, and the data of data, services platform invoke coupling turn back to the NC system with the XML form.
So just finish the data sync between NC system and the ABC system database, can receive data, also distributing data.
This method is followed following process above-mentioned based on the method for synchronous between the database of web service, with the data instance in the ABC system synchronization NC system, sees accompanying drawing 2:
1. in NC system and ABC system, set up synchronization interface separately, when the user needs synchrodata, by the synchronization interface proposition synchronization request of ABC system.
2. the Web Service interface by the ABC system passes to the data, services platform with the synchronization request of ABC system.
3. after the data, services platform obtains synchronization request, the registration service that is provided by the NC system in synchronization request and the data, services platform is complementary, and notice NC system call related service.
4.NC system carries out the checking of identity to this synchronization request, after being proved to be successful, carries out and calls the service-seeking data accordingly, related data is carried out the encapsulation of XML form by the NC application system.
5. packaged XML type number is reportedly passed the Web Service interface of NC system.
6.ABC the system synchronization interface obtains the data of XML form by the Web Service interface that calls the NC system, behind the analyzing XML file, deposits data in local data base.
It is as follows that synchronization request in the step 2 namely passes to the process of data, services platform by Web Service interface:
1) service requester (ABC system) is created the soap message of a synchronous data requests, and the network address with this information and ISP offers the SOAP object together then, and SOAP object and http protocol carry out alternately, thereby soap message is sent to network.
2) by network soap message is sent to the SOAP object of ISP's (Web Service server), it is specific message object that soap message is responsible for the XML message conversion.
The step of in the step 5 packaged XML type number reportedly being passed Web Service interface is as follows:
1) Web Service server process after the solicited message, generate a soap message response, the soap message with response offers the SOAP object again, and sends to service requester.
2) response message is sent to the SOAP foundation structure of service requester, and is object in the target programmed language with the XML message conversion, and response message can be provided for the ABC system then.
The process of analyzing XML file is as follows in the step 6:
After the ABC system receives the shared data that pass over the XML form, according to the form of XML document, in internal memory, set up a virtual tables of data; And then to XML document from root node, from top to bottom each node is resolved, the corresponding data content that resolve to obtain is deposited in the virtual data table of interim foundation; Again data in the virtual data table are deposited in the local data base of ABC system.
In a word, the NC system that is based on Web Service and ABC system data synchronizing method that the present invention proposes, the ISP is published to the data, services platform with service, service requester is served to the data, services platform request, the data, services platform is according to mating the service of ISP and service requester, and the result is returned to service requester with the XML form.
Claims (1)
1. the method for data synchronization between UFSOFT finance core system and operating cost system is characterized in that this method may further comprise the steps:
(1) in UFSOFT's financial system and operating cost system, sets up synchronization interface respectively, when service requester needs synchrodata, propose synchronization request by synchronization interface;
(2) by Web Service interface, service requester passes to the data, services platform with synchronization request;
(3) after the data, services platform obtains synchronization request, the registration service that is provided by the ISP in synchronization request and the data, services platform is complementary, and the notification service supplier calls related service;
(4) ISP carries out the checking of identity to this synchronization request, after being proved to be successful, carries out and calls service accordingly, and data query carries out the encapsulation of XML form to related data by the ISP;
(5) packaged XML type number is reportedly passed ISP's Web Service interface;
(6) service requester obtains the data of XML form by the Web Service interface that calls the ISP and resolves, and will resolve the back data then and deposit local data base in;
Synchronization request is as follows by the process that Web Service interface passes to the data, services platform in the step (2):
1) service requester is created the soap message of a synchronous data requests, and the network address with this information and ISP offers the SOAP object together then, and SOAP object and http protocol carry out alternately, thereby soap message is sent to network;
2) by network soap message is sent to ISP's SOAP object, it is specific message object that soap message is responsible for the XML message conversion;
The step of in the step 5 packaged XML type number reportedly being passed Web Service interface is as follows:
1) Web Service server process after the solicited message, generate a soap message response, the soap message with response is provided for the SOAP object again, and sends to service requester;
2) response message is sent to the SOAP object of service requester, and is object in the target programmed language with the XML message conversion, and response message can be provided for service requester then;
The process of analyzing XML file is as follows in the step 6:
After service requester receives the shared data that pass over the XML form, according to the XML document form, in internal memory, set up a virtual tables of data; And then to XML document from root node, from top to bottom each node is resolved; Deposit in the virtual data table of interim foundation resolving the corresponding data content that obtains; Again the data in the virtual data table are deposited in the local data base of service requester.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2013101466377A CN103235813A (en) | 2013-04-25 | 2013-04-25 | Ufida financial core system and activity based costing system data synchronization method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2013101466377A CN103235813A (en) | 2013-04-25 | 2013-04-25 | Ufida financial core system and activity based costing system data synchronization method |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN103235813A true CN103235813A (en) | 2013-08-07 |
Family
ID=48883854
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN2013101466377A Pending CN103235813A (en) | 2013-04-25 | 2013-04-25 | Ufida financial core system and activity based costing system data synchronization method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN103235813A (en) |
Cited By (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104317915A (en) * | 2014-10-28 | 2015-01-28 | 用友软件股份有限公司 | Incidence relation based data fetching method and device |
| CN105631568A (en) * | 2014-10-30 | 2016-06-01 | 博世包装技术（杭州）有限公司 | Communication method and device |
| CN105700964A (en) * | 2016-02-23 | 2016-06-22 | 浪潮通用软件有限公司 | Method for achieving remote communication between heterogeneous software systems |
| CN109033474A (en) * | 2018-09-07 | 2018-12-18 | 国网陕西省电力公司物资公司 | A kind of method, apparatus and controlled terminal of extension Webservice interface calling |
| CN109120723A (en) * | 2018-10-24 | 2019-01-01 | 南京燚麒智能科技有限公司 | A kind of method for interchanging data and system based on http protocol |
| CN111241046A (en) * | 2020-01-14 | 2020-06-05 | 深圳震有科技股份有限公司 | Method for synchronizing texts between systems, storage medium and terminal equipment |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102567333A (en) * | 2010-12-15 | 2012-07-11 | 上海杉达学院 | Distributed heterogeneous data integration system |
| CN103051729A (en) * | 2013-01-14 | 2013-04-17 | 南京轨道交通系统工程有限公司 | Isomerous data synchronous implementation method |
-
2013
- 2013-04-25 CN CN2013101466377A patent/CN103235813A/en active Pending
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102567333A (en) * | 2010-12-15 | 2012-07-11 | 上海杉达学院 | Distributed heterogeneous data integration system |
| CN103051729A (en) * | 2013-01-14 | 2013-04-17 | 南京轨道交通系统工程有限公司 | Isomerous data synchronous implementation method |
Non-Patent Citations (3)
| Title |
|---|
| 张月琴 等: "一种异构数据库同步技术的研究与实现", 《微计算机信息》 * |
| 王玉标 等: "基于Web服务的异构数据库共享及同步机制", 《计算机工程与设计》 * |
| 覃章荣 等: "基于Web Service的异构数据库同步系统设计与实现", 《计算机技术与发展》 * |
Cited By (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104317915A (en) * | 2014-10-28 | 2015-01-28 | 用友软件股份有限公司 | Incidence relation based data fetching method and device |
| CN104317915B (en) * | 2014-10-28 | 2017-09-29 | 用友网络科技股份有限公司 | Data grab method and device based on incidence relation |
| CN105631568A (en) * | 2014-10-30 | 2016-06-01 | 博世包装技术（杭州）有限公司 | Communication method and device |
| CN105700964A (en) * | 2016-02-23 | 2016-06-22 | 浪潮通用软件有限公司 | Method for achieving remote communication between heterogeneous software systems |
| CN109033474A (en) * | 2018-09-07 | 2018-12-18 | 国网陕西省电力公司物资公司 | A kind of method, apparatus and controlled terminal of extension Webservice interface calling |
| CN109120723A (en) * | 2018-10-24 | 2019-01-01 | 南京燚麒智能科技有限公司 | A kind of method for interchanging data and system based on http protocol |
| CN111241046A (en) * | 2020-01-14 | 2020-06-05 | 深圳震有科技股份有限公司 | Method for synchronizing texts between systems, storage medium and terminal equipment |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN103235813A (en) | Ufida financial core system and activity based costing system data synchronization method | |
| CN104125208B (en) | Data transmission method and device | |
| CN103023933B (en) | A kind of log-on message Integrated Processing System and method | |
| CN105930446B (en) | A kind of telecom client label generating method based on Hadoop distributed computing technology | |
| CN104618433B (en) | A kind of service combining method based on eca rule | |
| CN101655943A (en) | Management method and system of enterprise application integrated working flow | |
| CN109739915B (en) | Cross-domain shared data model construction method | |
| CN103236967A (en) | Message-based real-time cooperative office system | |
| CN103188245A (en) | Fight game server system | |
| CN103546571A (en) | Platform-as-a-service (PaaS) realizing method and device | |
| CN112866421B (en) | Intelligent contract operation method and device based on distributed cache and NSQ | |
| Zhang et al. | Research on IOT RESTful web service asynchronous composition based on BPEL | |
| CN101808051A (en) | Application integration gateway and control method thereof | |
| KR102066802B1 (en) | Business processing method and device | |
| CN103078920A (en) | Online information verification system based on international electrotechnical commission (IEC) 61968 enterprise service bus (ESB) | |
| CN106027534A (en) | System for implementing financial message processing based on Netty | |
| CN103268230A (en) | Method used for constructing cloud computing information management platform capable of expanding service | |
| CN109104368A (en) | A kind of request connection method, device, server and computer readable storage medium | |
| CN107016031A (en) | A kind of data center's middleware system | |
| CN103699391A (en) | Web service transformation method from traditional web services to multi-dimensional semantic models | |
| CN110020243A (en) | Querying method, device, Internet of Things server and the storage medium of internet of things data | |
| CN108270621A (en) | Multi-cloud service management technology architecture and model based on MAS | |
| CN103092982A (en) | Information service system based on multiple-view business model | |
| CN104852964A (en) | Multifunctional server scheduling method | |
| CN104166581A (en) | Virtualization method for increment manufacturing device |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C02 | Deemed withdrawal of patent application after publication (patent law 2001) | ||
| WD01 | Invention patent application deemed withdrawn after publication |
Application publication date: 20130807 |