CN109460912A - Data processing method, device, storage medium and electronic equipment - Google Patents
Data processing method, device, storage medium and electronic equipment Download PDFInfo
- Publication number
- CN109460912A CN109460912A CN201811286320.2A CN201811286320A CN109460912A CN 109460912 A CN109460912 A CN 109460912A CN 201811286320 A CN201811286320 A CN 201811286320A CN 109460912 A CN109460912 A CN 109460912A
- Authority
- CN
- China
- Prior art keywords
- data
- sending request
- mode
- transmission
- preset
- 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.)
- Granted
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/06—Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
- G06Q10/063—Operations research, analysis or management
- G06Q10/0631—Resource planning, allocation, distributing or scheduling for enterprises or organisations
Abstract
The present invention provides a kind of data processing method, device, storage medium and electronic equipment.This method comprises: receiving the data sending request of the first system；The corresponding transmission mode of the data sending request is determined according to preset exchange standard；If the transmission mode is XML mode, according to the data sending request, the database for accessing the first system obtains data corresponding with the data sending request, and is sent to corresponding second system；If the transmission mode is WebService mode, then according to the data sending request, WebService service is called to obtain data corresponding with the data sending request from the first system, the data are converted according to preset data dictionary, and by the data transmission after conversion to corresponding second system.The embodiment of the present invention realizes the data interaction of ERP system and operation system.
Description
Technical field
The present invention relates to field of computer technology more particularly to a kind of data processing method, device, storage medium and electronics
Equipment.
Background technique
Enterprise Resources Plan (Enterprise Resource Planning, abbreviation ERP) system refers to foundation in information
In technical foundation, integrate information technology and advanced management thought, is enterprise staff and decision with the management thought of systematization
Layer provides the management platform of decision making approach.With the development of current informationization system, some grouping of the world economy hospitals can use ERP
System is managed.
In practical applications, the operation system of subordinate hospital needs to carry out data with grouping of the world economy hospital ERP system to dock.By
It is different in the standard of the existing each operation system of subordinate hospital, so that the data docking difficulty not between homologous ray is larger, it is inconvenient
Data interaction is carried out between each system.
Summary of the invention
The present invention provides a kind of data processing method, device, storage medium and electronic equipment, to realize ERP system and industry
The data interaction of business system.
In a first aspect, the present invention provides a kind of data processing method, comprising:
Receive the data sending request of the first system；
The corresponding transmission mode of the data sending request is determined according to preset exchange standard；
If the transmission mode accesses the data of the first system according to the data sending request for XML mode
Library obtains data corresponding with the data sending request, and is sent to corresponding second system；
If the transmission mode is WebService mode, according to the data sending request, WebService is called
Service obtains data corresponding with the data sending request from the first system, according to preset data dictionary to the number
According to being converted, and by the data transmission after conversion to corresponding second system.
In one embodiment of the invention, it if the transmission mode is XML mode, is asked according to data transmission
It asks, the database for accessing the first system obtains corresponding with data sending request data, and is sent to corresponding the
Two system, comprising:
According to the data sending request, the database for accessing the first system is obtained and the data sending request pair
The data answered, and intermediate database is written into the data；
By the data transmission in said write intermediate database to corresponding second system.
In one embodiment of the invention, if the transmission mode is WebService mode, according to the data
Request is sent, WebService service is called to obtain data corresponding with the data sending request, root from the first system
The data are converted according to preset data dictionary, and by the data transmission after conversion to corresponding second system, comprising:
According to the data sending request, calls WebService service to obtain from the first system and sent out with the data
Send request corresponding data, and intermediate database is written in the data；
Data in said write intermediate database are converted according to preset data dictionary, and according to preset friendship
Data after dehorn brigadier conversion are sent to corresponding second system after being packaged.
It is in one embodiment of the invention, described that the data are converted according to preset data dictionary, comprising:
The data are parsed according to the exchange standard, the data after parsing are carried out according to the data dictionary
Conversion, the exchange standard includes data format and transmission mode.
In one embodiment of the invention, the data are parsed according to the exchange standard, after parsing
Data are converted according to the data dictionary, comprising:
The corresponding data format for including according to the exchange standard parses the data；
It, will according to the data mapping relations between the first system and second system for including in the preset data dictionary
Data after the parsing are converted, wherein data mapping relations of the data mapping relations between not homologous ray.
In one embodiment of the invention, the data sending request includes: data content to be sent, the data
The title of the second system of the corresponding time range of content, the title of the first system of data to be sent, data to be received and institute
State the data format of data needed for second system.
In one embodiment of the invention, the method also includes:
According to the switch log of record, data transmission result information is determined；
The data transmission result information is fed back to the first system for initiating data sending request, the data transmission knot
Fruit information is used to indicate whether data transmission succeeds.
Second aspect, the present invention provide a kind of data processing equipment, comprising:
Receiving module, for receiving the data sending request of the first system；
Processing module, for determining the corresponding transmission mode of the data sending request according to preset exchange standard；
If the transmission mode is XML mode, the processing module is also used to according to the data sending request, access
The database of the first system obtains data corresponding with the data sending request, and is sent to corresponding second system；
If the transmission mode is WebService mode, the processing module is also used to be sent according to the data and ask
It asks, calls WebService service to obtain data corresponding with the data sending request from the first system, according to default
Data dictionary the data are converted, and by the data transmission after conversion to corresponding second system.
The third aspect, the embodiment of the present invention provide a kind of computer readable storage medium, are stored thereon with computer program,
Method described in any one of first aspect is realized when the computer program is executed by processor.
Fourth aspect, the embodiment of the present invention provide a kind of electronic equipment, comprising:
Processor；And memory, for storing the executable instruction of the processor；
Wherein, the processor is configured to execute described in any one of first aspect via the executable instruction is executed
Method.
Data processing method, device, storage medium and electronic equipment provided in an embodiment of the present invention, receive the first system
Data sending request；The corresponding transmission mode of the data sending request is determined according to preset exchange standard；If the transmission
Mode is XML mode, then according to the data sending request, the database for accessing the first system is obtained to be sent out with the data
It send request corresponding data, and is sent to corresponding second system；If the transmission mode is WebService mode, basis
The data sending request calls WebService service to obtain from the first system corresponding with the data sending request
Data convert the data according to preset data dictionary, and by the data transmission after conversion to corresponding second system
System realizes data docking and data interaction between each system.
Detailed description of the invention
The drawings herein are incorporated into the specification and forms part of this specification, and shows the implementation for meeting the disclosure
Example, and together with specification for explaining the principles of this disclosure.
Fig. 1 is the flow diagram of one embodiment of data processing method provided by the invention；
Fig. 2 is a kind of data interactive mode schematic diagram provided by the invention；
Fig. 3 is another data interactive mode schematic diagram provided by the invention；
Fig. 4 is the data acquisition service schematic diagram of one embodiment of data processing method provided by the invention；
Fig. 5 is the data analysis service schematic diagram of one embodiment of data processing method provided by the invention；
Fig. 6 is the serving data schematic diagram of one embodiment of data processing method provided by the invention；
Fig. 7 is the data packing service schematic diagram of one embodiment of data processing method provided by the invention；
Fig. 8 is the standard interface schematic diagram of one embodiment of method for interchanging data provided by the invention；
Fig. 9 is the structural schematic diagram of one embodiment of DEU data exchange unit provided by the invention；
Figure 10 is the structural schematic diagram of one embodiment of electronic equipment provided by the invention.
Through the above attached drawings, it has been shown that the specific embodiment of the disclosure will be hereinafter described in more detail.These attached drawings
It is not intended to limit the scope of this disclosure concept by any means with verbal description, but is by referring to specific embodiments
Those skilled in the art illustrate the concept of the disclosure.
Specific embodiment
Example embodiments are described in detail here, and the example is illustrated in the accompanying drawings.Following description is related to
When attached drawing, unless otherwise indicated, the same numbers in different drawings indicate the same or similar elements.Following exemplary embodiment
Described in embodiment do not represent all implementations consistent with this disclosure.On the contrary, they be only with it is such as appended
The example of the consistent device and method of some aspects be described in detail in claims, the disclosure.
Term " includes " in description and claims of this specification and the attached drawing and " having " and they appoint
What is deformed, it is intended that is covered and non-exclusive is included.Such as contain the process, method, system, production of a series of steps or units
Product or equipment are not limited to listed step or unit, but optionally further comprising the step of not listing or unit, or
Optionally further comprising the other step or units intrinsic for these process, methods, product or equipment.
Noun according to the present invention and scene are introduced first:
Data dictionary refers to that the set for the data content for needing to exchange between system and system and data mapping are closed
System.
Exchange standard refers to needing mode standard used by carrying out data exchange between system and system, comprising: each
Data format, transmission mode, transmission frequency and data content of a system etc., transmission mode is for example including XML mode
With WebService mode, wherein XML mode is to directly access the database the mode of table, and WebService mode is to call
The mode in WebService service access data library, WebService mode support Excel and XML data format.
The method of the embodiment of the present invention carries out data transmission applied to hospital's ERP system and other operation systems.Data pass
Defeated mode mainly has the following two kinds: XML mode and WebService mode.WebService mode supports Excel and two kinds of XML
Data format.
Fig. 1 is the flow diagram of one embodiment of data processing method provided by the invention.The executing subject of the present embodiment
For data processing equipment, which is arranged in the corresponding server of data switching center.As shown in Figure 1, the present embodiment provides
Method, comprising:
Step 101, the data sending request for receiving the first system.
Specifically, the first system sends data sending request to data switching center, the server of data switching center is connect
Receive the data sending request that the first system is sent.Data sending request is used to request to send to second system to data switching center
Data.May include: in the data sending request data content to be sent, the corresponding time range of the data content, to
The number of data needed for sending the title of the first system of data, the title of the second system of data to be received and the second system
According to format.The first system can be ERP system, and corresponding second system can be operation system or the first system is business system
System, corresponding second system are ERP system.
Step 102 determines the corresponding transmission mode of the data sending request according to preset exchange standard.
Specifically, after data switching center receives the data sending request of the first system, according to preset exchange standard
It determines the corresponding transmission mode of the data sending request, includes transmission mode, the corresponding data lattice of transmission mode in exchange standard
Formula, transmission frequency etc., transmission mode include: XML mode and WebService mode.
If step 103, the transmission mode are XML mode, according to the data sending request, first system is accessed
The database of system obtains data corresponding with the data sending request, and is sent to corresponding second system.
Specifically, the database that data switching center directly accesses the first system obtains if transmission mode is XML mode
Data corresponding with the data sending request, and it is sent to corresponding second system.
If step 104, the transmission mode are WebService mode, according to the data sending request, call
WebService service obtains data corresponding with the data sending request from the first system, according to preset data word
Allusion quotation converts the data, and by the data transmission after conversion to corresponding second system.
Specifically, data switching center is by calling WebService service if transmission mode is WebService mode
Data corresponding with the data sending request in the first system are obtained, and the data are carried out according to preset data dictionary
Conversion, and by the data transmission after conversion to corresponding second system.
Wherein, it after getting data in the first system, is needing to convert data according to preset data dictionary,
Preset data dictionary includes the data mapping relations between the data content and each system of definition, by including in data dictionary
Data mapping relations between the first system and second system convert data, then by the data transmission after conversion to
Two system.
Optionally, if the first system is operation system, the second system is ERP system, transfers data to the
After two system, it can also proceed as follows:
Determine whether to call the other applications of the second system to carry out business processing according to preset configuration information；
If so, the other applications is called to carry out business processing.
Specifically, the database of ERP system is written in the data transmission that will be obtained from operation system into ERP system
In after, determine whether to call the other applications of the ERP system to carry out business processing according to configuration information.For example, calling
The more new procedures of ERP system.
Optionally, can also include: after step 302 or step 303
According to the switch log of record, data transmission result information is determined；
The data transmission result information is fed back to the first system for initiating data sending request, the data transmission knot
Fruit information is used to indicate whether data transmission succeeds.
Specifically, recording switch log in data transfer procedure.For example, data transmission time started, success or failure
Record, end time etc.；According to the switch log of record, data transmission result information is determined；By data transmission result information, example
As the result information of success or failure feeds back to the first system.
The method of the present embodiment receives the data sending request of the first system；The data are determined according to preset exchange
It sends and requests corresponding transmission mode；If the transmission mode is XML mode, according to the data sending request, institute is accessed
The database for stating the first system obtains data corresponding with the data sending request, and is sent to corresponding second system；If
The transmission mode is WebService mode, then according to the data sending request, WebService is called to service from described
The first system obtains data corresponding with the data sending request, is turned according to preset data dictionary to the data
It changes, and by the data transmission after conversion to corresponding second system, the data docking and data realized between each system is handed over
Mutually.
On the basis of the above embodiments, further, if the transmission mode is XML mode, step 103 specifically can be with
It is accomplished in that
According to the data sending request, the database for accessing the first system is obtained asks with data transmission
Corresponding data are sought, and intermediate database is written into the data；
By the data transmission in said write intermediate database to corresponding second system.
Specifically, as shown in Fig. 2, the first system by data switching center send data sending request, to the second system
System sends data, and the first system is, for example, hospital information system (HospitalInformationSystem, abbreviation HIS) system
Or other systems, second system are, for example, ERP system, data switching center accesses the first system according to data sending request
Database obtains data corresponding with data sending request, and writes data into the intermediate database of data switching center,
Then the data transmission in intermediate database will be written to corresponding second system.Tu2Zhong data switching center and HIS system or
It is communicated between other systems by wired or wireless network.
Further, if the transmission mode is WebService mode, step 104 specifically can be real in the following way
It is existing:
According to the data sending request, calls WebService service to obtain from the first system and sent out with the data
Send request corresponding data, and intermediate database is written in the data；
Data in said write intermediate database are converted according to preset data dictionary, and according to preset friendship
Data after dehorn brigadier conversion are sent to corresponding second system after being packaged.
Specifically, as shown in figure 3, the first system by data switching center send data sending request, to the second system
System sends data, and the first system is, for example, ERP system, and second system is, for example, HIS system or other systems, data switching center
According to data sending request, WebService service is called to obtain data corresponding with data sending request from the first system, and
Intermediate database is write data into, then converts the data being written in intermediate database according to preset data dictionary,
And be sent to corresponding second system after the data after conversion being packaged according to preset exchange standard.Data are handed in Fig. 3
It is communicated between switching center9 and HIS system or other systems by wired or wireless network.
Wherein, data are converted according to preset data dictionary, comprising:
The data are parsed according to preset exchange standard, by the data after parsing according to the data dictionary into
Row conversion, the exchange standard includes data format and transmission mode.
Specifically, the data that data switching center will obtain from the first system, are solved according to preset exchange standard
Analysis, and the data after parsing are converted according to data dictionary, the data after being converted.
Further, the data are parsed according to preset exchange standard, by the data after parsing according to
Data dictionary is converted, and can be specifically accomplished in that
The corresponding data format for including according to the exchange standard parses the data；
According to the data mapping relations for including in the preset data dictionary, the data after the parsing are turned
It changes；Data mapping relations of the data mapping relations between not homologous ray.
Specifically, the data got are the data obtained from the first system, the respective counts for including according to exchange standard
The data got are parsed such as the data format of second system and the first system according to format, parsing obtains second system
The data that can be identified, then according to the data mapping relations for including in data dictionary, i.e., between the first system and second system
The corresponding data mapping relations of data content converted, the data after being converted.
Clinic income data instance is obtained from HIS system with ERP system, as shown in table 1, table 3-1, is obtained from HIS system
Clinic income data include MZ-05/emergency treatment rate per day Item Detail, MZ-06/emergency treatment rate per day payment detail.
If the data format of the first system is XML format, the data format of second system is EXCEL format, wherein can be by MZ-05
The corresponding data content of door/emergency treatment rate per day Item Detail is parsed into EXCEL format, then will according to data mapping relations
Data content needed for the corresponding data content of MZ-05/emergency treatment rate per day Item Detail is converted to ERP system, such as ERP
Data content needed for system is only business date in MZ-05/emergency treatment rate per day Item Detail, type of service, charge
Project code, quantity, total amount etc..
Further, be sent to corresponding second system after the data after conversion being packaged according to preset exchange standard
System, can specifically be accomplished in that
The corresponding data format that data after conversion include according to exchange standard is packaged the data, and will envelope
Data transmission after dress is to corresponding second system.
Specifically, if transmission mode is WebService mode, be encapsulated as Excel that WebService mode is supported and
XML data format.
Below by way of illustrating the detailed process of the above method:
Example one: data are sent to ERP system
Data are transmitted from the business application trigger data switching centre of ERP system to ERP system；Data switching center
The exchange standard configured in data exchange repository and data dictionary etc. are called by data acquisition service, exchange standard includes passing
Defeated frequency, transmission mode etc., data dictionary include the data mapping relations of ERP system and other systems；According in repository
Content checks whether and transferred data, the whether wrong item of audit log；Other operation systems are called according to exchange standard
Reading data service (such as WebService service) obtain data or directly access other operation system databases and read numbers
According to；Intermediate database is written after data mapping relations conversion in the data in data dictionary that will acquire；According in repository
Other information determine whether call ERP system other application program carry out business processing；Data transmission result information is returned
Back to other operation systems.
Wherein it is possible to pass through timed task automatic trigger data transmission.
Example two: data are sent to other operation systems
Data are sent by the business application trigger data switching centre of other operation systems；Data switching center passes through
Data acquisition service calls the exchange standard configured in data exchange repository and data dictionary etc., and exchange standard includes transmitting pin
Rate, transmission mode etc., data dictionary include the data mapping relations of ERP system and other systems；According to the content in repository,
It checks whether and had transferred data, the whether wrong item of audit log；Data are obtained from ERP system according to transmission mode；
In the data in data dictionary that will acquire after preset data mapping relations conversion, data packing service is called to be marked according to exchange
Standard is packaged, and recalls the write-in data service of other operation systems, and the data after encapsulation are returned to other operation systems.
Wherein, as shown in figure 4, data switching center provides data acquisition service, the basic procedure of the data acquisition service
It is as follows:
After receiving data sending request, record data transmission starts log, reads transmission mode, format, such as pass
Defeated mode is XML mode or WebService mode (i.e. calling WebService method of service)；Format refers to data lattice
Formula, such as WebService mode support two kinds of data formats of Excel and XML.Record reads data and starts log.If transmission side
Formula is XML mode, then directly reads data from the first system database, carries out data conversion according to data dictionary, record saves
Data start log, save the intermediate database of data to data switching centre；If transmission mode is WebService mode,
The service of the first system is called to read data, record saves data and starts log, and the parsing of data analysis service is called to save data
(being parsed according to exchange standard).Record saves end of data log.Other services are called to carry out subsequent processing, such as can be again
Further call the more new procedures of ERP system.Record the data transfer ends log.Result is transmitted to the first system returned data.
Wherein, the data analysis service of data switching center realizes that function is as follows: the data that second system is passed to are by friendship
Dehorn standard is parsed, and the data in data dictionary after parsing is converted, then the data after conversion are saved in centre
In database.Data analysis service process flow is as follows:
As shown in figure 5, parsing incoming parameter, incoming parameter includes the data content corresponding time after getting data
Range, systematic name, the data renewal time of initiating request etc., read exchange standard, parse data according to exchange standard, according to
Data dictionary carries out data conversion, deleting history data (data got), and the data after saving conversion return and save knot
Fruit (such as preservation result of success or failure).
Example three: data are sent to other operation systems
Data are sent from the business application trigger data switching centre of ERP system to other operation systems；Data are handed over
Switching center9 sends the exchange standard configured in service call data exchange repository and data dictionary etc., exchange standard by data
Including transmission frequency, transmission mode etc., data dictionary includes the data mapping relations of ERP system and other systems；According to configuration
Content in library, checks whether and had transferred, the whether wrong item of audit log；According to transmission mode from the industry of ERP system
Data are obtained in business database；In the data in data dictionary that will acquire after preset data mapping relations conversion, by exchange
Standard is packaged, and recalls other operation system write-in data services, the data after being passed to encapsulation；According to its in repository
His information determines whether that the other application program of ERP system is called to carry out business processing, such as calls the more new procedures of ERP system
It is handled；Data transmission result is returned into ERP system.
Wherein it is possible to pass through timed task automatic trigger data transmission.
Example four: data are sent to ERP operation system
Data are sent from the business application trigger data switching centre of other operation systems to ERP system；Data are handed over
Switching center9 sends the exchange standard configured in service call data exchange repository and data dictionary etc., exchange standard by data
Including transmission frequency, transmission mode etc., data dictionary includes the data mapping relations of ERP system and other systems；Call other
The reading data service of operation system obtains data, and the data for calling data analysis service to be passed to other business are marked by exchange
Standard is parsed, and the database of ERP system will be written after data conversion according to data dictionary；Or directly from the number of other systems
Data are obtained according to library, the database of ERP system will be written after data conversion according to data dictionary；According to other letters in repository
Breath determines whether that the other application program of ERP system is called to carry out business processing, such as the more new procedures of ERP system is called to carry out
Processing；Data transmission result is returned into other operation systems.
As shown in fig. 6, data switching center provides serving data, the basic procedure of the serving data is as follows:
After receiving data providing request, record data transmission starts log, reads transmission mode, format, such as pass
Defeated mode is XML mode or WebService mode (i.e. calling WebService method of service)；Format refers to data lattice
Formula, such as WebService mode support two kinds of data formats of Excel and XML.Record reads data and starts log.If transmission side
Formula is XML mode, then reads data from the first system database, carries out data conversion according to data dictionary, record saves data
Start log, saves the intermediate database of data to data switching centre；If transmission mode is WebService mode, call
The data packing service of second system is packaged data, and record saves data and starts log, calls the service of second system
Save data.Record saves end of data log.It calls other services to carry out subsequent processing, such as calls the update of ERP system
Program is updated processing.Record the data transfer ends log.Result is transmitted to the first system returned data.
Wherein, the data packing service of data switching center realizes that function is as follows: according to data sending request from database
Middle inquiry data convert the data in data dictionary inquired, then by the operation system for including in exchange standard
Data format is packaged, the data after returning to encapsulation.Data packing service process flow is as follows:
As shown in fig. 7, after getting data, parse incoming parameter, parameter include the corresponding time range of data content,
Systematic name, the data renewal time etc. for initiating request, data are inquired from database, the data in data dictionary that will be inquired
It is converted, reads exchange standard, then be packaged by exchange standard, the data after returning to encapsulation.
As shown in figure 8, by data switching center, hospital's ERP system, group's system (such as group OA system), third
Square Corporation system, hospital business system etc. realize data interaction.
The method of the embodiment of the present invention, all hospital ERP nuclear interface standardizings (realize ERP system and other business systems
The docking of system) after, greatly reduce the variation because of the access of different medical mechanism foreground service system, and influence ERP core wealth
Business supply chain system steady change.System development docking expense substantially reduces, and system O&M cost substantially reduces, and primary benefits take
With estimating:
1. scheme through the embodiment of the present invention is from 12 from the period that the tertiary hospitals of each isomery HIS product access
The exploitation of a man month drops to 3 man month exploitations, reduces 75% development amount and scheme cost.
2. scheme through the embodiment of the present invention effectively reduces O&M cost, each tertiary hospitals at least reduces two
Operation maintenance personnel, general headquarters at least save 50% operation maintenance personnel cost and link up cost.
The following are the data content for needing to exchange between system and system in the embodiment of the present invention, table 1 be ERP system with
The data content of HIS systems exchange, i.e., the data content exchanged between the ERP system for including in data dictionary and HIS system with
And data mapping relations.
Wherein, the corresponding financial system in one column of classification, supply chain system etc. are the subsystem for including, HIS system in ERP system
Corresponding one column of tables of data unite as the data table numbering in HIS system.It wherein, such as in MZ-05 include the specific of outpatient service charge
Project data includes the specific payment data of outpatient service charge in MZ-06.
The data content of 1 ERPXi Tong &HIS systems exchange of table
Table 2-1, table 2-2 are the data content that ERP system is exchanged with other systems.One column of table 2-1 interface indicates ERP system
With group's system interface.Wherein, table 2-1 is the data content of ERP system and group's systems exchange that data dictionary includes, such as
ERP system from group's OA system obtain approval module in data.
One column of table 2-2 interface indicates ERP system and Third Party Logistics System (or ERP synchrodata guiding system) interface,
The module of other systems indicates the module of corresponding Third Party Logistics System (or ERP synchrodata guiding system), other systems
Corresponding one column of tables of data is the data table numbering in Third Party Logistics System (or ERP synchrodata guiding system), such as GJ-
01 procurement data for including for procurement business in Third Party Logistics System.Wherein, table 2-2 is the ERP system that data dictionary includes
The data content exchanged with other systems, as ERP system from Third Party Logistics System obtain procurement business in include buying
Data.
The data content of table 2-1 ERP system & group systems exchange
The data content of the other systems exchanges of table 2-2 ERP system &
Table 3-1, table 3-2, table 3-3 are ERP system exchange standard corresponding with other external systems, wherein table 3-1 classification
One column indicates the data category of ERP system and HIS system, and tables of data indicates the tables of data of the data content provided；Table 3-2 classification
The system that one column indicates interaction, tables of data indicate the tables of data of the data content provided；One column of table 3-3 classification indicates system interaction
Table type, tables of data indicate provide data content tables of data.Wherein, between the system that table 3-1 includes for exchange standard
The contents such as transmission frequency, data content, if ERP system is from the door/Emergency Patients obtained in MZ-04 tables of data in HIS
Order data.Wherein, synchronizing frequency refers to transmission frequency in table 3-1.Table 3-2 and table 3-3 is similar with table 3-1, herein not
It repeats again.
The exchange standard of table 3-1 ERP and HIS system
The exchange standard of table 3-2 ERP and third party system
The exchange standard of table 3-3 ERP and the purchase existing ERP system of hospital
Further, the data of the basic dictionary in table 3-1 are handed over as ERP system and other external system interface data
Mutual basis, using ERP system basic coding as standard, other external systems must be real by internal contrast relationship according to this standard
The uniformity now encoded.
It further, include: that MZ-01 patient information, MZ-02/emergency treatment are registered in MZ. door/emergency treatment data in table 3-1
Data, MZ-03/Emergency Patients medical diagnosis on disease data, MZ-04/Emergency Patients order data etc. tables of data, MZ-05/urgency
Examine rate per day Item Detail etc..
Wherein, the corresponding data content of MZ-01 patient information includes: patient ID, name, gender, date of birth, identity card
Part type, social security card number, nationality, patient source, nationality, telephone number, hospital's unique identifier, uploads day at certificate coding
Fields such as (creation or updates) are distinguished in phase, operation.
Wherein, the MZ-02/emergency treatment corresponding data content of data of registering includes: patient ID, date of registering, flowing water of registering
Number, department's coding, emergency treatment department coding, doctor's coding, medical rank, visit type, hospital's unique identifier, upload the date etc.
Field.
Wherein, the corresponding data content of MZ-05/emergency treatment rate per day Item Detail includes: business date, service class
Type, patient code, patient's title, charging item coding, project category coding, opens branch room coding, opens the odd-numbered day transaction journal number
Phase opens Dan doctor and encodes unit price, quantity, total amount, closing date etc..
Medical rank refers to patient assessment's rank, comprising: 1 common, 2 associate chief physicians, 3 archiaters, 4 experts professor；Just
Examine the type that type refers to patient assessment, comprising: further consultation, 4 communities change the place of examination after 1 first visit, 2 outpatient service further consultations, 3 discharges.
ZY. include: in hospitalization data ZY-01 registration for hospitalization data, ZY-02 be hospitalized transfer from one department to another room record, ZY-03 it is every in hospital
Daily cost accounting data etc..
Wherein, the corresponding data content of ZY-01 registration for hospitalization data, comprising: business date, patient's coding, contact person, connection
It is people's phone, number of being hospitalized, department's coding of being hospitalized, record date, attending physician, admission date, discharge date, Settlement Date etc.
Field.
ZY. hospitalization data, YJ. Medical Laboratory data in table 3-1 is similar with MZ./emergency treatment data, no longer superfluous herein
It states.
Other tables of data are similar in table 3-2, table 3-2, and details are not described herein again.
Fig. 9 is the structure chart of one embodiment of data processing equipment provided by the invention, as shown in figure 9, the number of the present embodiment
According to processing unit, comprising:
Receiving module 131, for receiving the data sending request of the first system；
Processing module 132, for determining the corresponding transmission mode of the data sending request according to preset exchange standard；
If the transmission mode is XML mode, the processing module 132 is also used to according to the data sending request,
The database for accessing the first system obtains data corresponding with the data sending request, and is sent to corresponding second system
System；
If the transmission mode is WebService mode, the processing module 132 is also used to be sent out according to the data
Request is sent, WebService service is called to obtain data corresponding with the data sending request from the first system, according to
Preset data dictionary converts the data, and by the data transmission after conversion to corresponding second system.
Optionally, if the transmission mode is XML mode, the processing module 132 is specifically used for:
According to the data sending request, the database for accessing the first system is obtained asks with data transmission
Corresponding data are sought, and intermediate database is written into the data；
By the data transmission in said write intermediate database to corresponding second system.
Optionally, if the transmission mode is WebService mode, the processing module 132 is specifically used for:
According to the data sending request, calls WebService service to obtain from the first system and sent out with the data
Send request corresponding data, and intermediate database is written in the data；
Data in said write intermediate database are converted according to preset data dictionary, and according to preset friendship
Data after dehorn brigadier conversion are sent to corresponding second system after being packaged.
Optionally, the processing module 132, is specifically used for:
The data are parsed according to preset exchange standard, by the data after parsing according to the data dictionary into
Row conversion, the exchange standard includes data format and transmission mode.
Optionally, the processing module 132, is specifically used for:
The corresponding data format for including according to the exchange standard parses the data；
According to the data mapping relations for including in the preset data dictionary, the data after the parsing are turned
It changes；Data mapping relations of the data mapping relations between not homologous ray.
Optionally, the data sending request includes: data content to be sent, the corresponding time model of the data content
It encloses, number needed for the title of the second system of the title of the first system of data to be sent, data to be received and the second system
According to data format.
Optionally, the processing module 132, is also used to:
According to the switch log of record, data transmission result information is determined；
The data transmission result information is fed back to the first system for initiating data sending request, the data transmission knot
Fruit information is used to indicate whether data transmission succeeds.
The device of the present embodiment can be used for executing the technical solution of above method embodiment, realization principle and technology
Effect is similar, and details are not described herein again.
Figure 10 is the structure chart of electronic equipment embodiment provided by the invention, and as shown in Figure 10, which includes:
Processor 141, and, the memory 142 of the executable instruction for storage processor 141.
It optionally, further include communication interface 143, for being communicated with other equipment.
Wherein, processor 141 is configured to execute via the executable instruction is executed corresponding in preceding method embodiment
Method, specific implementation process may refer to preceding method embodiment, and details are not described herein again.
A kind of computer readable storage medium is also provided in the embodiment of the present invention, is stored thereon with computer program, it is described
Realize that corresponding method in preceding method embodiment, specific implementation process may refer to when computer program is executed by processor
Preceding method embodiment, it is similar that the realization principle and technical effect are similar, and details are not described herein again.
Those skilled in the art after considering the specification and implementing the invention disclosed here, will readily occur to its of the disclosure
Its embodiment.The present invention is directed to cover any variations, uses, or adaptations of the disclosure, these modifications, purposes or
Person's adaptive change follows the general principles of this disclosure and including the undocumented common knowledge in the art of the disclosure
Or conventional techniques.The description and examples are only to be considered as illustrative, and the true scope and spirit of the disclosure are by following
Claims are pointed out.
It should be understood that the present disclosure is not limited to the precise structures that have been described above and shown in the drawings, and
And various modifications and changes may be made without departing from the scope thereof.The scope of the present disclosure is only limited by appended claims
System.
Claims (10)
1. a kind of data processing method characterized by comprising
Receive the data sending request of the first system；
The corresponding transmission mode of the data sending request is determined according to preset exchange standard；
If the transmission mode is XML mode, according to the data sending request, the database for accessing the first system is obtained
Data corresponding with the data sending request are taken, and are sent to corresponding second system；
If the transmission mode is WebService mode, according to the data sending request, WebService service is called
Obtain corresponding with data sending request data from the first system, according to preset data dictionary to the data into
Row conversion, and by the data transmission after conversion to corresponding second system.
2. the method according to claim 1, wherein if the transmission mode is XML mode, according to the number
It is requested according to sending, the database for accessing the first system obtains data corresponding with the data sending request, and is sent to
Corresponding second system, comprising:
According to the data sending request, the database acquisition for accessing the first system is corresponding with the data sending request
Data, and intermediate database is written into the data；
By the data transmission in said write intermediate database to corresponding second system.
3. the method according to claim 1, wherein if the transmission mode is WebService mode, root
According to the data sending request, WebService service is called to obtain from the first system corresponding with the data sending request
Data, the data are converted according to preset data dictionary, and by the data transmission after conversion to corresponding second
System, comprising:
According to the data sending request, calls WebService service to obtain from the first system and asked with data transmission
Corresponding data are sought, and intermediate database is written into the data；
Data in said write intermediate database are converted according to preset data dictionary, and are marked according to preset exchange
Data after brigadier's conversion are sent to corresponding second system after being packaged.
4. method according to claim 1-3, which is characterized in that it is described according to preset data dictionary to described
Data are converted, comprising:
The data are parsed according to the exchange standard, the data after parsing are turned according to the data dictionary
It changes, the exchange standard includes data format and transmission mode.
5. according to the method described in claim 4, it is characterized in that, the data are parsed according to the exchange standard,
Data after parsing are converted according to the data dictionary, comprising:
The corresponding data format for including according to the exchange standard parses the data；
It, will be described according to the data mapping relations between the first system and second system for including in the preset data dictionary
Data after parsing are converted.
6. method according to claim 1-3, which is characterized in that
The data sending request includes: data content to be sent, the corresponding time range of the data content, number to be sent
According to the title of the first system, data to be received second system title and data needed for the second system data lattice
Formula.
7. method according to claim 1-3, which is characterized in that the method also includes:
According to the switch log of record, data transmission result information is determined；
The data transmission result information is fed back to the first system for initiating data sending request, the data transmission result letter
Breath is used to indicate whether data transmission succeeds.
8. a kind of data processing equipment characterized by comprising
Receiving module, for receiving the data sending request of the first system；
Processing module, for determining the corresponding transmission mode of the data sending request according to preset exchange standard；
If the transmission mode is XML mode, the processing module is also used to according to the data sending request, described in access
The database of the first system obtains data corresponding with the data sending request, and is sent to corresponding second system；
If the transmission mode is WebService mode, the processing module is also used to according to the data sending request,
WebService service is called to obtain data corresponding with the data sending request from the first system, according to preset number
The data are converted according to dictionary, and by the data transmission after conversion to corresponding second system.
9. a kind of computer readable storage medium, is stored thereon with computer program, which is characterized in that the computer program quilt
Claim 1-7 described in any item data processing methods are realized when processor executes.
10. a kind of electronic equipment characterized by comprising
Processor；And
Memory, for storing the executable instruction of the processor；
Wherein, the processor is configured to require 1-7 described in any item via executing the executable instruction and carry out perform claim
Data processing method.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811286320.2A CN109460912B (en) | 2018-10-31 | 2018-10-31 | Data processing method, data processing device, storage medium and electronic equipment |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811286320.2A CN109460912B (en) | 2018-10-31 | 2018-10-31 | Data processing method, data processing device, storage medium and electronic equipment |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN109460912A true CN109460912A (en) | 2019-03-12 |
| CN109460912B CN109460912B (en) | 2021-06-29 |
Family
ID=65609084
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201811286320.2A Active CN109460912B (en) | 2018-10-31 | 2018-10-31 | Data processing method, data processing device, storage medium and electronic equipment |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109460912B (en) |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110059302A (en) * | 2019-03-15 | 2019-07-26 | 平安城市建设科技(深圳)有限公司 | Data Date formatting method, device, equipment and readable storage medium storing program for executing |
| CN111737527A (en) * | 2020-06-29 | 2020-10-02 | 中国南方电网有限责任公司 | Data processing method and device for heterogeneous terminal, electronic equipment and storage medium |
| CN111813567A (en) * | 2019-08-08 | 2020-10-23 | 安徽水利开发股份有限公司 | Method and system for calling seal software interface in collaboration system |
| CN112511591A (en) * | 2020-10-30 | 2021-03-16 | 福建亿能达信息技术股份有限公司 | Method, device, equipment and medium for realizing hospital interface data interaction |
| CN112818064A (en) * | 2021-02-25 | 2021-05-18 | 平安普惠企业管理有限公司 | Multi-system data synchronization method, device, equipment and storage medium |
Citations (22)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20050165754A1 (en) * | 2004-01-14 | 2005-07-28 | Ramasamy Valliappan | Method and system for data retrieval from heterogeneous data sources |
| US20060085393A1 (en) * | 2004-09-30 | 2006-04-20 | Perillon Software, Inc. | Method and system for environmental, health, and safety compliance |
| CN1889110A (en) * | 2006-07-14 | 2007-01-03 | 中山大学 | Intelligent prompting system for weather and traffic state |
| CN101334872A (en) * | 2008-07-22 | 2008-12-31 | 北京航空航天大学 | Electronic government documents exchanging method based on web service |
| CN101739452A (en) * | 2009-12-17 | 2010-06-16 | 中国电力科学研究院 | Data exchange interface and realizing method thereof |
| CN101964739A (en) * | 2009-07-22 | 2011-02-02 | 中国移动通信集团公司 | Data transmission method, device and system |
| CN102111336A (en) * | 2011-03-04 | 2011-06-29 | 珠海众意软件科技有限公司 | Message switching equipment for networked settlement of social security and medical insurance |
| CN102271156A (en) * | 2011-07-20 | 2011-12-07 | 武汉爱迪智能工程有限公司 | Data sharing service system based on internet of things |
| US20120066670A1 (en) * | 2010-07-09 | 2012-03-15 | Mccarthy Christopher | Systems and Methods for Private Cloud Computing |
| CN102497451A (en) * | 2011-12-28 | 2012-06-13 | 用友软件股份有限公司 | Service processing system and service processing method |
| CN102567333A (en) * | 2010-12-15 | 2012-07-11 | 上海杉达学院 | Distributed heterogeneous data integration system |
| CN102609769A (en) * | 2011-01-19 | 2012-07-25 | 上海中信信息发展股份有限公司 | Data acquisition tool and data acquisition method |
| CN103383750A (en) * | 2012-05-04 | 2013-11-06 | 山西省电力公司阳泉供电公司 | Power grid summarized information organic integrated platform |
| CN103544561A (en) * | 2013-10-10 | 2014-01-29 | 广东电网公司电力科学研究院 | Method for realizing dynamic display of power transmission circuits, method for realizing operational maintenance of power transmission circuits and system for realizing management of power transmission circuits |
| CN104111998A (en) * | 2014-07-09 | 2014-10-22 | 江西理工大学 | Method and device for sorting coding and integrated exchange and management of heterogeneous data of enterprise |
| CN104156444A (en) * | 2014-08-14 | 2014-11-19 | 浪潮通用软件有限公司 | Data exchange method based on Web Service |
| CN104809553A (en) * | 2015-04-20 | 2015-07-29 | 广东工业大学 | Multi-source electronic commerce data processing platform and method for heterogeneous data |
| CN104851067A (en) * | 2015-06-08 | 2015-08-19 | 成都华唯科技有限责任公司 | Rehabilitation clinic diagnosis and treatment whole-process digital management system based on big data |
| CN105159951A (en) * | 2015-08-17 | 2015-12-16 | 成都中科大旗软件有限公司 | Open tourism multi-source heterogeneous data fusion method and system |
| CN105760532A (en) * | 2016-03-03 | 2016-07-13 | 江苏物联网研究发展中心 | Resource sharing system based on Web Service and resource sharing method based on Web Service |
| CN105760498A (en) * | 2016-02-22 | 2016-07-13 | 浪潮通用软件有限公司 | Achievement method of XML data and relational database matching |
| US20170011087A1 (en) * | 2015-07-06 | 2017-01-12 | Oracle International Corporation | Dynamically switching between data sources |
-
2018
- 2018-10-31 CN CN201811286320.2A patent/CN109460912B/en active Active
Patent Citations (22)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20050165754A1 (en) * | 2004-01-14 | 2005-07-28 | Ramasamy Valliappan | Method and system for data retrieval from heterogeneous data sources |
| US20060085393A1 (en) * | 2004-09-30 | 2006-04-20 | Perillon Software, Inc. | Method and system for environmental, health, and safety compliance |
| CN1889110A (en) * | 2006-07-14 | 2007-01-03 | 中山大学 | Intelligent prompting system for weather and traffic state |
| CN101334872A (en) * | 2008-07-22 | 2008-12-31 | 北京航空航天大学 | Electronic government documents exchanging method based on web service |
| CN101964739A (en) * | 2009-07-22 | 2011-02-02 | 中国移动通信集团公司 | Data transmission method, device and system |
| CN101739452A (en) * | 2009-12-17 | 2010-06-16 | 中国电力科学研究院 | Data exchange interface and realizing method thereof |
| US20120066670A1 (en) * | 2010-07-09 | 2012-03-15 | Mccarthy Christopher | Systems and Methods for Private Cloud Computing |
| CN102567333A (en) * | 2010-12-15 | 2012-07-11 | 上海杉达学院 | Distributed heterogeneous data integration system |
| CN102609769A (en) * | 2011-01-19 | 2012-07-25 | 上海中信信息发展股份有限公司 | Data acquisition tool and data acquisition method |
| CN102111336A (en) * | 2011-03-04 | 2011-06-29 | 珠海众意软件科技有限公司 | Message switching equipment for networked settlement of social security and medical insurance |
| CN102271156A (en) * | 2011-07-20 | 2011-12-07 | 武汉爱迪智能工程有限公司 | Data sharing service system based on internet of things |
| CN102497451A (en) * | 2011-12-28 | 2012-06-13 | 用友软件股份有限公司 | Service processing system and service processing method |
| CN103383750A (en) * | 2012-05-04 | 2013-11-06 | 山西省电力公司阳泉供电公司 | Power grid summarized information organic integrated platform |
| CN103544561A (en) * | 2013-10-10 | 2014-01-29 | 广东电网公司电力科学研究院 | Method for realizing dynamic display of power transmission circuits, method for realizing operational maintenance of power transmission circuits and system for realizing management of power transmission circuits |
| CN104111998A (en) * | 2014-07-09 | 2014-10-22 | 江西理工大学 | Method and device for sorting coding and integrated exchange and management of heterogeneous data of enterprise |
| CN104156444A (en) * | 2014-08-14 | 2014-11-19 | 浪潮通用软件有限公司 | Data exchange method based on Web Service |
| CN104809553A (en) * | 2015-04-20 | 2015-07-29 | 广东工业大学 | Multi-source electronic commerce data processing platform and method for heterogeneous data |
| CN104851067A (en) * | 2015-06-08 | 2015-08-19 | 成都华唯科技有限责任公司 | Rehabilitation clinic diagnosis and treatment whole-process digital management system based on big data |
| US20170011087A1 (en) * | 2015-07-06 | 2017-01-12 | Oracle International Corporation | Dynamically switching between data sources |
| CN105159951A (en) * | 2015-08-17 | 2015-12-16 | 成都中科大旗软件有限公司 | Open tourism multi-source heterogeneous data fusion method and system |
| CN105760498A (en) * | 2016-02-22 | 2016-07-13 | 浪潮通用软件有限公司 | Achievement method of XML data and relational database matching |
| CN105760532A (en) * | 2016-03-03 | 2016-07-13 | 江苏物联网研究发展中心 | Resource sharing system based on Web Service and resource sharing method based on Web Service |
Cited By (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110059302A (en) * | 2019-03-15 | 2019-07-26 | 平安城市建设科技(深圳)有限公司 | Data Date formatting method, device, equipment and readable storage medium storing program for executing |
| CN111813567A (en) * | 2019-08-08 | 2020-10-23 | 安徽水利开发股份有限公司 | Method and system for calling seal software interface in collaboration system |
| CN111813567B (en) * | 2019-08-08 | 2022-07-05 | 安徽建工集团股份有限公司 | Method and system for calling seal software interface in collaboration system |
| CN111737527A (en) * | 2020-06-29 | 2020-10-02 | 中国南方电网有限责任公司 | Data processing method and device for heterogeneous terminal, electronic equipment and storage medium |
| CN112511591A (en) * | 2020-10-30 | 2021-03-16 | 福建亿能达信息技术股份有限公司 | Method, device, equipment and medium for realizing hospital interface data interaction |
| CN112511591B (en) * | 2020-10-30 | 2024-04-05 | 福建亿能达信息技术股份有限公司 | Method, device, equipment and medium for realizing hospital interface data interaction |
| CN112818064A (en) * | 2021-02-25 | 2021-05-18 | 平安普惠企业管理有限公司 | Multi-system data synchronization method, device, equipment and storage medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CN109460912B (en) | 2021-06-29 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109460912A (en) | Data processing method, device, storage medium and electronic equipment | |
| US7438228B2 (en) | Systems and methods for managing electronic prescriptions | |
| EP1994484B1 (en) | Platform for interoperable healthcare data exchange | |
| US20080104104A1 (en) | Health integration platform schema | |
| US20060287890A1 (en) | Method and apparatus for organizing and integrating structured and non-structured data across heterogeneous systems | |
| CN109920522A (en) | A kind of residents ' health managed care big data platform | |
| US20030074234A1 (en) | Customer-centered pharmaceutical product and information distribution system | |
| US20080104615A1 (en) | Health integration platform api | |
| US20050209891A1 (en) | Method for consolidatin medical records through the world wide web | |
| US20150127384A1 (en) | Operating system | |
| US8271346B1 (en) | System to format and use electronically readable identification data strings, biometric data, matrix codes and other data to link and enroll users of products and services to roles and rights and fees and prices associated with research protocols linked to said products and services | |
| CA2425603A1 (en) | System for communication of health care data | |
| US8392219B1 (en) | Systems and methods for streamlined patient enrollment for one or more healthcare programs | |
| Cheng et al. | Healthcare services across China–on implementing an extensible universally unique patient identifier system | |
| CN101299265A (en) | Method and system for transferring health care data | |
| Gold et al. | The health record banking imperative: A conceptual model | |
| CN111080256A (en) | Internet medical platform framework | |
| CN114420240A (en) | Prescription management system based on artificial intelligence, big data and block chain | |
| US20210043319A1 (en) | Healthcare data cloud system, server and method | |
| CN102893302A (en) | Clinical payment network system and methods | |
| WO2022005453A1 (en) | System for process coordination and interoperability across different systems, platforms and/or businesses | |
| US10810550B1 (en) | System for process coordination and interoperability across different systems, platforms, and/or businesses | |
| Dhillon et al. | Blockchain in science | |
| Juneja et al. | Design and Development of a Novel Smart Card Model for Healthcare Information System | |
| US20140278538A1 (en) | Method to format and use matrix bar codes and other identification code conventions and tools to enroll end users of products and services into a data supply chain |
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 |