CN109460912B - Data processing method, data processing device, storage medium and electronic equipment - Google Patents
Data processing method, data processing device, storage medium and electronic equipment Download PDFInfo
- Publication number
- CN109460912B CN109460912B CN201811286320.2A CN201811286320A CN109460912B CN 109460912 B CN109460912 B CN 109460912B CN 201811286320 A CN201811286320 A CN 201811286320A CN 109460912 B CN109460912 B CN 109460912B
- Authority
- CN
- China
- Prior art keywords
- data
- sending request
- mode
- dictionary
- transmission
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
Images
Classifications
-
- 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 invention provides a data processing method, a data processing device, a storage medium and electronic equipment. The method comprises the following steps: receiving a data transmission request of a first system; determining a transmission mode corresponding to the data sending request according to a preset exchange standard; if the transmission mode is an XML mode, accessing a database of the first system to acquire data corresponding to the data sending request according to the data sending request, and transmitting the data to a corresponding second system; if the transmission mode is the WebService mode, calling a WebService service to acquire data corresponding to the data sending request from the first system according to the data sending request, converting the data according to a preset data dictionary, and transmitting the converted data to a corresponding second system. The embodiment of the invention realizes the data interaction between the ERP system and the service system.
Description
Technical Field
The present invention relates to the field of computer technologies, and in particular, to a data processing method and apparatus, a storage medium, and an electronic device.
Background
An Enterprise Resource Planning (ERP) system is a management platform which is established on the basis of information technology, integrates information technology and advanced management ideas, and provides decision-making means for Enterprise employees and decision-making layers by using a systematized management idea. With the construction and development of the current informatization system, some group hospitals adopt an ERP system for management.
In practical application, the business system of the subordinate hospital needs to be in data connection with the ERP system of the clustered hospital. Because the standards of all the existing business systems of subordinate hospitals are different, the data docking difficulty among different systems is higher, and the data interaction among all the systems is inconvenient.
Disclosure of Invention
The invention provides a data processing method, a data processing device, a storage medium and electronic equipment, which are used for realizing data interaction between an ERP system and a service system.
In a first aspect, the present invention provides a data processing method, including:
receiving a data transmission request of a first system;
determining a transmission mode corresponding to the data sending request according to a preset exchange standard;
if the transmission mode is an XML mode, accessing a database of the first system to acquire data corresponding to the data sending request according to the data sending request, and transmitting the data to a corresponding second system;
if the transmission mode is the WebService mode, calling a WebService service to acquire data corresponding to the data sending request from the first system according to the data sending request, converting the data according to a preset data dictionary, and transmitting the converted data to a corresponding second system.
In an embodiment of the present invention, if the transmission mode is an XML mode, accessing the database of the first system to obtain data corresponding to the data sending request according to the data sending request, and transmitting the data to the corresponding second system, includes:
according to the data sending request, accessing a database of the first system to obtain data corresponding to the data sending request, and writing the data into an intermediate database;
and transmitting the data written into the intermediate database to a corresponding second system.
In an embodiment of the present invention, if the transmission mode is a WebService mode, invoking a WebService service to obtain data corresponding to the data sending request from the first system according to the data sending request, converting the data according to a preset data dictionary, and transmitting the converted data to a corresponding second system, where the method includes:
calling a WebService service to acquire data corresponding to the data sending request from the first system according to the data sending request, and writing the data into an intermediate database;
and converting the data written into the intermediate database according to a preset data dictionary, packaging the converted data according to a preset exchange standard, and transmitting the packaged data to a corresponding second system.
In an embodiment of the present invention, the converting the data according to a preset data dictionary includes:
and analyzing the data according to the exchange standard, and converting the analyzed data according to the data dictionary, wherein the exchange standard comprises a data format and a transmission mode.
In an embodiment of the present invention, parsing the data according to the exchange standard, and converting the parsed data according to the data dictionary includes:
analyzing the data according to the corresponding data format included in the exchange standard;
and converting the analyzed data according to a data mapping relation between a first system and a second system included in the preset data dictionary, wherein the data mapping relation is a data mapping relation between different systems.
In one embodiment of the present invention, the data transmission request includes: the method comprises the steps of sending data content to be sent, a time range corresponding to the data content, the name of a first system of the data to be sent, the name of a second system of the data to be received and the data format of the data required by the second system.
In one embodiment of the invention, the method further comprises:
determining data transmission result information according to the recorded exchange log;
and feeding back the data transmission result information to the first system initiating the data sending request, wherein the data transmission result information is used for indicating whether the data transmission is successful or not.
In a second aspect, the present invention provides a data processing apparatus comprising:
the receiving module is used for receiving a data sending request of a first system;
the processing module is used for determining a transmission mode corresponding to the data sending request according to a preset exchange standard;
if the transmission mode is an XML mode, the processing module is further used for accessing the database of the first system to acquire data corresponding to the data sending request according to the data sending request and transmitting the data to the corresponding second system;
if the transmission mode is the WebService mode, the processing module is further used for calling a WebService service to acquire data corresponding to the data sending request from the first system according to the data sending request, converting the data according to a preset data dictionary, and transmitting the converted data to a corresponding second system.
In a third aspect, the present invention provides a computer-readable storage medium, on which a computer program is stored, and when the computer program is executed by a processor, the computer program implements the method described in any one of the first aspect.
In a fourth aspect, an embodiment of the present invention provides an electronic device, including:
a processor; and a memory for storing executable instructions of the processor;
wherein the processor is configured to perform the method of any of the first aspects via execution of the executable instructions.
The data processing method, the data processing device, the storage medium and the electronic equipment provided by the embodiment of the invention receive a data sending request of a first system; determining a transmission mode corresponding to the data sending request according to a preset exchange standard; if the transmission mode is an XML mode, accessing a database of the first system to acquire data corresponding to the data sending request according to the data sending request, and transmitting the data to a corresponding second system; if the transmission mode is the WebService mode, calling a WebService service to acquire data corresponding to the data sending request from the first system according to the data sending request, converting the data according to a preset data dictionary, and transmitting the converted data to a corresponding second system, so that data butt joint and data interaction among the systems are realized.
Drawings
The accompanying drawings, which are incorporated in and constitute a part of this specification, illustrate embodiments consistent with the present disclosure and together with the description, serve to explain the principles of the disclosure.
FIG. 1 is a schematic flow chart diagram illustrating an embodiment of a data processing method according to the present invention;
FIG. 2 is a schematic diagram of a data interaction method provided by the present invention;
FIG. 3 is a schematic diagram of another data interaction method provided by the present invention;
FIG. 4 is a schematic diagram of a data acquisition service according to an embodiment of the data processing method provided in the present invention;
FIG. 5 is a schematic diagram of a data parsing service according to an embodiment of a data processing method provided in the present invention;
FIG. 6 is a schematic diagram of a data providing service according to an embodiment of the data processing method provided in the present invention;
FIG. 7 is a schematic diagram of a data encapsulation service according to an embodiment of the data processing method provided in the present invention;
FIG. 8 is a diagram illustrating a standardized interface of an embodiment of a data exchange method provided by the present invention;
FIG. 9 is a schematic structural diagram of an embodiment of a data exchange device provided in the present invention;
fig. 10 is a schematic structural diagram of an embodiment of an electronic device provided in the present invention.
With the foregoing drawings in mind, certain embodiments of the disclosure have been shown and described in more detail below. These drawings and written description are not intended to limit the scope of the disclosed concepts in any way, but rather to illustrate the concepts of the disclosure to those skilled in the art by reference to specific embodiments.
Detailed Description
Reference will now be made in detail to the exemplary embodiments, examples of which are illustrated in the accompanying drawings. When the following description refers to the accompanying drawings, like numbers in different drawings represent the same or similar elements unless otherwise indicated. The implementations described in the exemplary embodiments below are not intended to represent all implementations consistent with the present disclosure. Rather, they are merely examples of apparatus and methods consistent with certain aspects of the present disclosure, as detailed in the appended claims.
The terms "comprising" and "having," and any variations thereof, in the description and claims of this invention and the drawings described herein are intended to cover non-exclusive inclusions. For example, a process, method, system, article, or apparatus that comprises a list of steps or elements is not limited to only those steps or elements listed, but may alternatively include other steps or elements not listed, or inherent to such process, method, article, or apparatus.
First, the nouns and scenarios related to the present invention are introduced:
and the data dictionary refers to a collection of data contents and data mapping relations which need to be exchanged between systems.
The exchange standard refers to a standard mode adopted by systems needing data exchange, and comprises the following steps: the data format, transmission mode, transmission frequency, transmission data content and the like of each system are transmitted, the transmission mode comprises an XML mode and a WebService mode, wherein the XML mode is a mode of directly accessing a database table, the WebService mode is a mode of calling WebService service to access a database, and the WebService mode supports Excel and XML data formats.
The method provided by the embodiment of the invention is applied to data transmission between the hospital ERP system and other business systems. The data transmission modes mainly include the following two modes: XML mode and WebService mode. The WebService mode supports two data formats of Excel and XML.
Fig. 1 is a schematic flow chart of an embodiment of a data processing method provided in the present invention. The execution subject of the embodiment is a data processing device, and the device is arranged in a server corresponding to the data exchange center. As shown in fig. 1, the method provided by this embodiment includes:
Specifically, the first system sends a data sending request to the data switching center, and the server of the data switching center receives the data sending request sent by the first system. The data transmission request is used for requesting the data switching center to transmit data to the second system. The data transmission request may include: the method comprises the steps of sending data content to be sent, a time range corresponding to the data content, the name of a first system of the data to be sent, the name of a second system of the data to be received and the data format of the data required by the second system. The first system may be an ERP system, and the corresponding second system may be a business system, or the first system is a business system, and the corresponding second system is an ERP system.
And step 102, determining a transmission mode corresponding to the data sending request according to a preset exchange standard.
Specifically, after receiving a data sending request of a first system, a data exchange center determines a transmission mode corresponding to the data sending request according to a preset exchange standard, where the exchange standard includes the transmission mode, a data format corresponding to the transmission mode, a transmission frequency, and the like, and the transmission mode includes: XML mode and WebService mode.
And 103, if the transmission mode is an XML mode, accessing a database of the first system to acquire data corresponding to the data sending request according to the data sending request, and transmitting the data to a corresponding second system.
Specifically, if the transmission mode is an XML mode, the data exchange center directly accesses the database of the first system to obtain the data corresponding to the data sending request, and transmits the data to the corresponding second system.
And step 104, if the transmission mode is the WebService mode, calling a WebService service to acquire data corresponding to the data transmission request from the first system according to the data transmission request, converting the data according to a preset data dictionary, and transmitting the converted data to a corresponding second system.
Specifically, if the transmission mode is the WebService mode, the data exchange center acquires data corresponding to the data sending request in the first system by calling the WebService service, converts the data according to a preset data dictionary, and transmits the converted data to the corresponding second system.
After data is acquired from the first system, the data needs to be converted according to a preset data dictionary, the preset data dictionary comprises defined data content and data mapping relations among the systems, the data is converted according to the data mapping relations, included in the data dictionary, between the first system and the second system, and then the converted data is transmitted to the second system.
Optionally, if the first system is a business system and the second system is an ERP system, after the data is transmitted to the second system, the following operations may be performed:
determining whether to call other application programs of the second system for service processing according to preset configuration information; if yes, calling the other application programs to perform service processing.
Specifically, after data acquired from the business system is transmitted to the ERP system, that is, written in a database of the ERP system, it is determined whether to call other application programs of the ERP system for business processing according to the configuration information. For example, an update program of the ERP system is called.
Optionally, step 302 or step 303 may be followed by:
determining data transmission result information according to the recorded exchange log;
and feeding back the data transmission result information to the first system initiating the data sending request, wherein the data transmission result information is used for indicating whether the data transmission is successful or not.
Specifically, during the data transfer process, the exchange log is recorded. For example, data transfer start time, success or failure records, end time, etc.; determining data transmission result information according to the recorded exchange log; data transfer result information, such as success or failure result information, is fed back to the first system.
The method of the embodiment receives a data transmission request of a first system; determining a transmission mode corresponding to the data sending request according to preset exchange; if the transmission mode is an XML mode, accessing a database of the first system to acquire data corresponding to the data sending request according to the data sending request, and transmitting the data to a corresponding second system; if the transmission mode is the WebService mode, calling a WebService service to acquire data corresponding to the data sending request from the first system according to the data sending request, converting the data according to a preset data dictionary, and transmitting the converted data to a corresponding second system, so that data butt joint and data interaction among the systems are realized.
On the basis of the above embodiment, further, if the transmission mode is an XML mode, step 103 may be specifically implemented in the following manner:
according to the data sending request, accessing a database of the first system to acquire data corresponding to the data sending request, and writing the data into an intermediate database;
and transmitting the data written into the intermediate database to a corresponding second system.
Specifically, as shown in fig. 2, a first system sends a data sending request to a data exchange center, and sends data to a second system, where the first system is, for example, a Hospital Information System (HIS) system or other systems, the second system is, for example, an ERP system, and the data exchange center accesses a database of the first system to obtain data corresponding to the data sending request according to the data sending request, writes the data into an intermediate database of the data exchange center, and then transfers the data written into the intermediate database to the corresponding second system. In fig. 2, the data switching center communicates with the HIS system or other systems via a wired or wireless network.
Further, if the transmission mode is a WebService mode, step 104 may be specifically implemented by the following method:
calling a WebService service to acquire data corresponding to the data sending request from the first system according to the data sending request, and writing the data into an intermediate database;
and converting the data written into the intermediate database according to a preset data dictionary, packaging the converted data according to a preset exchange standard, and transmitting the packaged data to a corresponding second system.
Specifically, as shown in fig. 3, a first system sends a data sending request to a data exchange center, and sends data to a second system, where the first system is, for example, an ERP system, and the second system is, for example, an HIS system or other systems, and the data exchange center calls a WebService service to obtain data corresponding to the data sending request from the first system according to the data sending request, and writes the data in an intermediate database, then converts the data written in the intermediate database according to a preset data dictionary, and packages the converted data according to a preset exchange standard, and then transmits the data to the corresponding second system. In fig. 3, the data switching center communicates with the HIS system or other systems via a wired or wireless network.
Wherein, convert the data according to the data dictionary that predetermines, include:
and analyzing the data according to a preset exchange standard, and converting the analyzed data according to the data dictionary, wherein the exchange standard comprises a data format and a transmission mode.
Specifically, the data exchange center analyzes the data acquired from the first system according to a preset exchange standard, and converts the analyzed data according to the data dictionary to obtain converted data.
Further, the data is analyzed according to a preset exchange standard, and the analyzed data is converted according to the data dictionary, which can be specifically realized by the following method:
analyzing the data according to the corresponding data format included in the exchange standard;
converting the analyzed data according to a data mapping relation included in the preset data dictionary; the data mapping relation is a data mapping relation between different systems.
Specifically, the acquired data is data acquired from the first system, the acquired data is analyzed according to corresponding data formats included in the exchange standard, such as data formats of the second system and the first system, to obtain data that can be identified by the second system, and then the data is converted according to a data mapping relationship included in the data dictionary, that is, a data mapping relationship corresponding to data content between the first system and the second system, to obtain converted data.
Taking the example that the ERP system acquires the outpatient income data from the HIS system, as shown in table 1 and table 3-1, the outpatient income data acquired from the HIS system includes the details of MZ-05 house/emergency daily charge project and MZ-06 house/emergency daily charge payment. If the data format of the first system is XML format, the data format of the second system is EXCEL format, wherein the data content corresponding to the MZ-05 gate/emergency daily charging item details can be parsed into EXCEL format, and then the data content corresponding to the MZ-05 gate/emergency daily charging item details is converted into the data content required by the ERP system according to the data mapping relationship, for example, the data content required by the ERP system is only the service date, service type, charging item code, quantity, total amount, etc. in the MZ-05 gate/emergency daily charging item details.
Further, the converted data is encapsulated according to a preset exchange standard and then transmitted to a corresponding second system, which can be specifically realized by the following method:
and encapsulating the converted data according to a corresponding data format included by the exchange standard, and transmitting the encapsulated data to a corresponding second system.
Specifically, if the transmission mode is the WebService mode, the transmission mode is packaged into Excel and XML data formats supported by the WebService mode.
The specific processes of the above method are illustrated below by way of example:
example one: sending data to an ERP system
Triggering a data exchange center by a service application program of the ERP system to transmit data to the ERP system; the data exchange center calls an exchange standard, a data dictionary and the like configured in the data exchange configuration library through the data acquisition service, wherein the exchange standard comprises transmission frequency, transmission mode and the like, and the data dictionary comprises a data mapping relation between the ERP system and other systems; checking whether the data are called and whether the log has an error item according to the content in the configuration library; calling a data reading service (such as WebService service) of other business systems according to the exchange standard to acquire data or directly accessing databases of other business systems to read data; converting the acquired data according to the data mapping relation in the data dictionary and writing the converted data into an intermediate database; determining whether to call other application programs of the ERP system for service processing according to other information in the configuration library; and returning the data transmission result information to other service systems.
Wherein the data transfer can be triggered automatically by a timing task.
Example two: sending data to other business systems
Triggering the data exchange center to send data by the service application program of other service system; the data exchange center calls an exchange standard, a data dictionary and the like configured in the data exchange configuration library through the data acquisition service, wherein the exchange standard comprises transmission frequency, transmission mode and the like, and the data dictionary comprises a data mapping relation between the ERP system and other systems; checking whether the data are called and whether the log has an error item according to the content in the configuration library; acquiring data from an ERP system according to a transmission mode; and after the acquired data is converted according to a preset data mapping relation in the data dictionary, calling a data packaging service to package according to an exchange standard, calling a write-in data service of other business systems, and returning the packaged data to other business systems.
As shown in fig. 4, the data switching center provides a data acquisition service, and the basic flow of the data acquisition service is as follows:
after receiving the data sending request, recording a data transmission starting log, and reading a transmission mode and a format, for example, the transmission mode is an XML mode or a WebService mode (i.e. calling a WebService service mode); the format refers to a data format, for example, a WebService mode supports two data formats of Excel and XML. And recording a read data start log. If the transmission mode is an XML mode, directly reading data from a first system database, performing data conversion according to a data dictionary, recording and storing a data start log, and storing the data to a middle database of a data exchange center; if the transmission mode is the WebService mode, calling the service of the first system to read data, recording and saving a data start log, and calling a data analysis service to analyze and save the data (analyzing according to an exchange standard). And recording and saving a data end log. And calling other services for subsequent processing, such as further calling an updating program of the ERP system. And recording a data transmission end log. And returning the data transmission result to the first system.
The data analysis service of the data exchange center has the following functions: and analyzing the data transmitted by the second system according to the exchange standard, converting the analyzed data according to the data dictionary, and storing the converted data in the intermediate database. The data analysis service processing flow is as follows:
as shown in fig. 5, after data is acquired, incoming parameters are analyzed, where the incoming parameters include a time range corresponding to data content, a system name for initiating a request, data update time, and the like, an exchange standard is read, data is analyzed according to the exchange standard, data conversion is performed according to a data dictionary, historical data (i.e., acquired data) is deleted, the converted data is saved, and a saving result (e.g., a successful or failed saving result) is returned.
Example three: sending data to other business systems
Triggering the data exchange center to send data to other service systems by a service application program of the ERP system; the data exchange center calls an exchange standard, a data dictionary and the like configured in the data exchange configuration library through data sending service, wherein the exchange standard comprises transmission frequency, transmission mode and the like, and the data dictionary comprises a data mapping relation between the ERP system and other systems; checking whether the log has an error item or not according to the content in the configuration library, wherein the log is called; acquiring data from a service database of the ERP system according to the transmission mode; the obtained data is converted according to a preset data mapping relation in a data dictionary, then is packaged according to an exchange standard, and then other business systems are called to write data service, and the packaged data are transmitted; determining whether to call other application programs of the ERP system for service processing, for example, calling an update program of the ERP system for processing, according to other information in the configuration library; and returning the data transmission result to the ERP system.
Wherein the data transfer can be triggered automatically by a timing task.
Example four: sending data to an ERP business system
Triggering the data exchange center by the service application programs of other service systems to send data to the ERP system; the data exchange center calls an exchange standard, a data dictionary and the like configured in the data exchange configuration library through data sending service, wherein the exchange standard comprises transmission frequency, transmission mode and the like, and the data dictionary comprises a data mapping relation between the ERP system and other systems; calling a data reading service of other business systems to acquire data, calling a data analysis service to analyze data transmitted by other businesses according to an exchange standard, converting the data according to a data dictionary, and writing the converted data into a database of the ERP system; or directly acquiring data from the databases of other systems, converting the data according to the data dictionary, and writing the converted data into the database of the ERP system; determining whether to call other application programs of the ERP system for service processing, for example, calling an update program of the ERP system for processing, according to other information in the configuration library; and returning the data transmission result to other business systems.
As shown in fig. 6, the data switching center provides a data providing service, and the basic flow of the data providing service is as follows:
after receiving the data providing request, recording a data transmission start log, and reading a transmission mode and a format, for example, the transmission mode is an XML mode or a WebService mode (i.e., invoking a WebService service mode); the format refers to a data format, for example, a WebService mode supports two data formats of Excel and XML. And recording a read data start log. If the transmission mode is an XML mode, reading data from a first system database, performing data conversion according to a data dictionary, recording and storing a data start log, and storing the data to a middle database of a data exchange center; if the transmission mode is the WebService mode, calling a data packaging service of the second system to package the data, recording a data storage start log, and calling the service of the second system to store the data. And recording and saving a data end log. And calling other services for subsequent processing, such as calling an update program of the ERP system for update processing. And recording a data transmission end log. And returning the data transmission result to the first system.
The data encapsulation service of the data switching center has the following functions: and inquiring data from the database according to the data sending request, converting the inquired data according to the data dictionary, packaging according to the data format of the service system included in the exchange standard, and returning the packaged data. The data encapsulation service processing flow is as follows:
as shown in fig. 7, after the data is acquired, the incoming parameters are analyzed, the parameters include a time range corresponding to the data content, a system name for initiating a request, data update time, and the like, the data is queried from the database, the queried data is converted according to a data dictionary, the exchange standard is read, then the data is packaged according to the exchange standard, and the packaged data is returned.
As shown in fig. 8, a data exchange center, a hospital ERP system, a group system (such as a group OA system), a third party company system, a hospital business system, and the like implement data interaction.
According to the method provided by the embodiment of the invention, after all hospital ERP interfaces are standardized (namely, the connection between the ERP system and other service systems is realized), the influence on the stable change of an ERP core financial supply chain system caused by the access change of the front desk service systems of different medical institutions is greatly reduced. The system development and docking cost is greatly reduced, the system operation and maintenance cost is greatly reduced, and the main benefit cost is estimated:
1. the period of access from the three-level hospital of each heterogeneous HIS product is reduced from development of 12 persons per month to development of 3 persons per month by the scheme of the embodiment of the invention, and the development workload and the scheme cost are reduced by 75%.
2. The operation and maintenance cost is effectively reduced through the scheme of the embodiment of the invention, at least two operation and maintenance personnel are reduced for each three-level hospital, and the operation and maintenance personnel cost and the communication cost are saved by at least 50% for headquarters.
The following is data contents to be exchanged between the systems in the embodiment of the present invention, and table 1 is data contents exchanged between the ERP system and the HIS system, that is, data contents and data mapping relationships exchanged between the ERP system and the HIS system included in the data dictionary.
The financial system, the supply chain system and the like corresponding to the category column are subsystems included in the ERP system, and the data table column corresponding to the HIS system is a data table number in the HIS system. For example, MZ-05 includes specific item data for an out-patient charge, and MZ-06 includes specific payment data for an out-patient charge.
TABLE 1 ERP & HIS System exchanged data content
Tables 2-1 and 2-2 show the data contents exchanged between the ERP system and other systems. The column of the interface of table 2-1 represents the interface between the ERP system and the group system. The table 2-1 shows data contents exchanged between the ERP system and the group system included in the data dictionary, for example, the ERP system obtains data in the approval module from the group OA system.
The first column of the interface of table 2-2 represents the interface between the ERP system and the third-party logistics system (or ERP synchronous data export system), the modules of other systems represent the modules of the corresponding third-party logistics system (or ERP synchronous data export system), and the first column of the data table corresponding to other systems is the data table number in the third-party logistics system (or ERP synchronous data export system), for example, GJ-01 is the purchasing data included in the purchasing service in the third-party logistics system. Table 2-2 shows data contents exchanged between the ERP system included in the data dictionary and other systems, for example, the ERP system obtains purchasing data included in purchasing services from a third-party logistics system.
TABLE 2-1 ERP System & group System exchanged data content
TABLE 2-2 ERP SYSTEM & other systems exchanged data content
Tables 3-1, 3-2 and 3-3 are exchange standards corresponding to the ERP system and other external systems, wherein a column of a category of the tables 3-1 represents data categories of the ERP system and the HIS system, and a data table represents data tables of provided data contents; 3-2 Category one column represents an interactive system, the data sheet represents a data sheet of the provided data content; tables 3-3 Categories column represents the table type of system interaction and the data table represents the data table of the data content provided. Table 3-1 shows the contents of transmission frequency and transmission data content between systems included in the exchange standard, for example, the ERP system obtains the medical order data of the outpatient/emergency treatment patient in the MZ-04 data table from the HIS. Wherein, the synchronization frequency in table 3-1 refers to a transmission frequency. Tables 3-2 and 3-3 are similar to those in table 3-1 and will not be described herein.
TABLE 3-1 ERP and HIS systems exchange criteria
TABLE 3-2 ERP exchange criteria with third-party systems
TABLE 3-3 ERP exchange Standard with the existing ERP System of the acquisition Hospital
Further, the data of the basic dictionary in table 3-1 is used as the basis for interface data interaction between the ERP system and other external systems, and the basic code of the ERP system is used as a standard, and the other external systems must implement code uniformity through internal comparison according to the standard.
Further, MZ. clinic/emergency data in Table 3-1 include: MZ-01 patient information, MZ-02 clinic/emergency registration data, MZ-03 clinic/emergency patient disease diagnosis data, data tables such as MZ-04 clinic/emergency patient medical advice data, and the specification of MZ-05 clinic/emergency daily charge items.
Wherein, the data content corresponding to the MZ-01 patient information comprises: patient ID, name, gender, date of birth, identification document type, document code, social security card number, nationality, patient origin, nationality, contact phone, hospital unique identifier, upload date, operation differentiation (creation or update), etc.
Wherein, the data content corresponding to the MZ-02 clinic/emergency registration data comprises: patient ID, registration date, registration serial number, department code, emergency department code, doctor code, treatment level, treatment type, unique hospital identification code, upload date and other fields.
Wherein, the data content corresponding to the MZ-05 gate/emergency daily charge item detail comprises: service date, service type, transaction serial number, patient name, charging item code, item category code, billing department code, billing date, billing doctor code unit price, quantity, total amount, checkout date, etc.
Visit level refers to the patient's visit level, including: 1 common, 2 assistant chief physicians, 3 chief physicians and 4 professors; the visit type refers to the type of visit for the patient, including: 1 initial diagnosis, 2 out-patient follow-up diagnoses, 3 post-hospital follow-up diagnoses and 4 community referral diagnoses.
ZY. hospitalization data include: ZY-01 registration data, ZY-02 admission transfer record, ZY-03 daily charge billing data, etc.
Wherein, ZY-01 is inpatient the data content that the registration data corresponds, includes: date of service, patient code, contact phone, hospital number, department code, registration date, attending physician, date of admission, date of discharge, date of settlement, etc.
The ZY. hospital admission data and YJ. medical technical department data in Table 3-1 are similar to the MZ. clinic/emergency data and are not described in detail herein.
The other data tables in tables 3-2 and 3-2 are similar and will not be described again here.
Fig. 9 is a structural diagram of an embodiment of a data processing apparatus provided in the present invention, and as shown in fig. 9, the data processing apparatus of the embodiment includes:
a receiving module 131, configured to receive a data sending request of a first system;
a processing module 132, configured to determine, according to a preset switching standard, a transmission mode corresponding to the data sending request;
if the transmission mode is an XML mode, the processing module 132 is further configured to access the database of the first system to obtain data corresponding to the data sending request according to the data sending request, and transmit the data to a corresponding second system;
if the transmission mode is the WebService mode, the processing module 132 is further configured to call a WebService service to obtain data corresponding to the data sending request from the first system according to the data sending request, convert the data according to a preset data dictionary, and transmit the converted data to a corresponding second system.
Optionally, if the transmission mode is an XML mode, the processing module 132 is specifically configured to:
according to the data sending request, accessing a database of the first system to acquire data corresponding to the data sending request, and writing the data into an intermediate database;
and transmitting the data written into the intermediate database to a corresponding second system.
Optionally, if the transmission mode is a WebService mode, the processing module 132 is specifically configured to:
calling a WebService service to acquire data corresponding to the data sending request from the first system according to the data sending request, and writing the data into an intermediate database;
and converting the data written into the intermediate database according to a preset data dictionary, packaging the converted data according to a preset exchange standard, and transmitting the packaged data to a corresponding second system.
Optionally, the processing module 132 is specifically configured to:
and analyzing the data according to a preset exchange standard, and converting the analyzed data according to the data dictionary, wherein the exchange standard comprises a data format and a transmission mode.
Optionally, the processing module 132 is specifically configured to:
analyzing the data according to the corresponding data format included in the exchange standard;
converting the analyzed data according to a data mapping relation included in the preset data dictionary; the data mapping relation is a data mapping relation between different systems.
Optionally, the data sending request includes: the method comprises the steps of sending data content to be sent, a time range corresponding to the data content, the name of a first system of the data to be sent, the name of a second system of the data to be received and the data format of the data required by the second system.
Optionally, the processing module 132 is further configured to:
determining data transmission result information according to the recorded exchange log;
and feeding back the data transmission result information to the first system initiating the data sending request, wherein the data transmission result information is used for indicating whether the data transmission is successful or not.
The apparatus of this embodiment may be configured to implement the technical solutions of the above method embodiments, and the implementation principles and technical effects are similar, which are not described herein again.
Fig. 10 is a structural diagram of an embodiment of an electronic device provided in the present invention, and as shown in fig. 10, the electronic device includes:
a processor 141, and a memory 142 for storing executable instructions of the processor 141.
Optionally, a communication interface 143 is also included for communicating with other devices.
The processor 141 is configured to execute the corresponding method in the foregoing method embodiment by executing the executable instruction, and the specific implementation process thereof may refer to the foregoing method embodiment, which is not described herein again.
The embodiment of the present invention further provides a computer-readable storage medium, where a computer program is stored, and when the computer program is executed by a processor, the method in the foregoing method embodiment is implemented.
Other embodiments of the disclosure will be apparent to those skilled in the art from consideration of the specification and practice of the disclosure disclosed herein. This application is intended to cover any variations, uses, or adaptations of the disclosure following, in general, the principles of the disclosure and including such departures from the present disclosure as come within known or customary practice within the art to which the disclosure pertains. It is intended that the specification and examples be considered as exemplary only, with a true scope and spirit of the disclosure being indicated by the following claims.
It will be understood that the present disclosure is not limited to the precise arrangements described above and shown in the drawings and that various modifications and changes may be made without departing from the scope thereof. The scope of the present disclosure is limited only by the appended claims.
Claims (7)
1. A data processing method, comprising:
receiving a data transmission request of a first system;
determining a transmission mode corresponding to the data sending request according to a preset exchange standard;
if the transmission mode is an XML mode, accessing a database of the first system to acquire data corresponding to the data sending request according to the data sending request, and transmitting the data to a corresponding second system;
if the transmission mode is the WebService mode, calling a WebService service to acquire data corresponding to the data transmission request from the first system according to the data transmission request, converting the data according to a preset data dictionary, and transmitting the converted data to a corresponding second system;
the data transmission request includes: the method comprises the steps that data content to be sent, a time range corresponding to the data content, the name of a first system of data to be sent, the name of a second system of data to be received and the data format of data required by the second system are sent;
the WebService mode supports two data formats of Excel and XML;
if the first system is a business system and the second system is an ERP system, after the data is transmitted to the second system, the method further comprises the following steps:
determining whether to call other application programs of the ERP system for service processing according to the configuration information, if so, calling the other application programs for service processing;
the converting the data according to a preset data dictionary includes:
analyzing the data according to the exchange standard, and converting the analyzed data according to the data dictionary, wherein the exchange standard comprises a data format and a transmission mode;
analyzing the data according to the exchange standard, and converting the analyzed data according to the data dictionary, wherein the method comprises the following steps:
analyzing the data according to the corresponding data format included in the exchange standard;
and converting the analyzed data according to a data mapping relation between a first system and a second system in the preset data dictionary.
2. The method according to claim 1, wherein if the transmission mode is an XML mode, accessing a database of the first system according to the data transmission request to obtain data corresponding to the data transmission request, and transmitting the data to a corresponding second system, includes:
according to the data sending request, accessing a database of the first system to obtain data corresponding to the data sending request, and writing the data into an intermediate database;
and transmitting the data written into the intermediate database to a corresponding second system.
3. The method according to claim 1, wherein if the transmission mode is a WebService mode, invoking a WebService service to obtain data corresponding to the data transmission request from the first system according to the data transmission request, converting the data according to a preset data dictionary, and transmitting the converted data to a corresponding second system, includes:
calling a WebService service to acquire data corresponding to the data sending request from the first system according to the data sending request, and writing the data into an intermediate database;
and converting the data written into the intermediate database according to a preset data dictionary, packaging the converted data according to a preset exchange standard, and transmitting the packaged data to a corresponding second system.
4. The method according to any one of claims 1-3, further comprising:
determining data transmission result information according to the recorded exchange log;
and feeding back the data transmission result information to the first system initiating the data sending request, wherein the data transmission result information is used for indicating whether the data transmission is successful or not.
5. A data processing apparatus, comprising:
the receiving module is used for receiving a data sending request of a first system;
the processing module is used for determining a transmission mode corresponding to the data sending request according to a preset exchange standard;
if the transmission mode is an XML mode, the processing module is further used for accessing the database of the first system to acquire data corresponding to the data sending request according to the data sending request and transmitting the data to the corresponding second system;
if the transmission mode is the WebService mode, the processing module is further used for calling a WebService service to acquire data corresponding to the data sending request from the first system according to the data sending request, converting the data according to a preset data dictionary and transmitting the converted data to a corresponding second system;
the data transmission request includes: the method comprises the steps that data content to be sent, a time range corresponding to the data content, the name of a first system of data to be sent, the name of a second system of data to be received and the data format of data required by the second system are sent;
the WebService mode supports two data formats of Excel and XML;
if the first system is a business system and the second system is an ERP system, after the data is transmitted to the second system, the method further comprises the following steps:
determining whether to call other application programs of the ERP system for service processing according to the configuration information, if so, calling the other application programs for service processing;
the converting the data according to a preset data dictionary includes:
analyzing the data according to the exchange standard, and converting the analyzed data according to the data dictionary, wherein the exchange standard comprises a data format and a transmission mode;
analyzing the data according to the exchange standard, and converting the analyzed data according to the data dictionary, wherein the method comprises the following steps:
analyzing the data according to the corresponding data format included in the exchange standard;
and converting the analyzed data according to a data mapping relation between a first system and a second system in the preset data dictionary.
6. A computer-readable storage medium, on which a computer program is stored, which, when being executed by a processor, carries out the data processing method of any one of claims 1 to 4.
7. An electronic device, comprising:
a processor; and
a memory for storing executable instructions of the processor;
wherein the processor is configured to perform the data processing method of any of claims 1-4 via execution of the executable instructions.
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 CN109460912A (en) | 2019-03-12 |
| CN109460912B true 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) |
Families Citing this family (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 |
| 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 |
| 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 |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102567333A (en) * | 2010-12-15 | 2012-07-11 | 上海杉达学院 | Distributed heterogeneous data integration system |
| CN104156444A (en) * | 2014-08-14 | 2014-11-19 | 浪潮通用软件有限公司 | Data exchange method based on Web Service |
| CN104851067A (en) * | 2015-06-08 | 2015-08-19 | 成都华唯科技有限责任公司 | Rehabilitation clinic diagnosis and treatment whole-process digital management system based on big data |
| CN105760498A (en) * | 2016-02-22 | 2016-07-13 | 浪潮通用软件有限公司 | Achievement method of XML data and relational database matching |
Family Cites Families (18)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| SG153628A1 (en) * | 2004-01-14 | 2009-07-29 | Agency Science Tech & Res | 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 |
| CN1889110B (en) * | 2006-07-14 | 2012-03-21 | 中山大学 | Intelligent prompting system for weather and traffic state |
| CN101334872B (en) * | 2008-07-22 | 2011-12-07 | 北京航空航天大学 | Electronic government documents exchanging method based on web service |
| CN101964739B (en) * | 2009-07-22 | 2014-03-26 | 中国移动通信集团公司 | Data transmission method, device and system |
| CN101739452A (en) * | 2009-12-17 | 2010-06-16 | 中国电力科学研究院 | Data exchange interface and realizing method thereof |
| CN103380423B (en) * | 2010-07-09 | 2016-01-27 | 道富公司 | For the system and method for private cloud computing |
| 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 |
| CN102497451B (en) * | 2011-12-28 | 2014-06-18 | 用友软件股份有限公司 | 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 |
| CN104809553A (en) * | 2015-04-20 | 2015-07-29 | 广东工业大学 | Multi-source electronic commerce data processing platform and method for heterogeneous data |
| US11036752B2 (en) * | 2015-07-06 | 2021-06-15 | Oracle International Corporation | Optimizing incremental loading of warehouse data |
| CN105159951A (en) * | 2015-08-17 | 2015-12-16 | 成都中科大旗软件有限公司 | Open tourism multi-source heterogeneous data fusion method and system |
| CN105760532B (en) * | 2016-03-03 | 2020-02-14 | 江苏物联网研究发展中心 | Resource sharing system and method based on Web Service |
-
2018
- 2018-10-31 CN CN201811286320.2A patent/CN109460912B/en active Active
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102567333A (en) * | 2010-12-15 | 2012-07-11 | 上海杉达学院 | Distributed heterogeneous data integration system |
| CN104156444A (en) * | 2014-08-14 | 2014-11-19 | 浪潮通用软件有限公司 | Data exchange method based on Web Service |
| CN104851067A (en) * | 2015-06-08 | 2015-08-19 | 成都华唯科技有限责任公司 | Rehabilitation clinic diagnosis and treatment whole-process digital management system based on big data |
| CN105760498A (en) * | 2016-02-22 | 2016-07-13 | 浪潮通用软件有限公司 | Achievement method of XML data and relational database matching |
Also Published As
| Publication number | Publication date |
|---|---|
| CN109460912A (en) | 2019-03-12 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109460912B (en) | Data processing method, data processing device, storage medium and electronic equipment | |
| CA2716420C (en) | Third party information transfer | |
| US5832447A (en) | Automated system and method for providing real-time verification of health insurance eligibility | |
| US9076186B2 (en) | Opt-in collector system and method | |
| KR100750071B1 (en) | Method and system for sharing medical infomation | |
| US8688549B2 (en) | Methods and apparatus for complementing user entries associated with events of interest through context | |
| US20150199482A1 (en) | System and method for dynamic transactional data streaming | |
| US8930206B2 (en) | Medical care administration system and method | |
| US20140279807A1 (en) | Rules-based management system and method for processing medical information | |
| US8392219B1 (en) | Systems and methods for streamlined patient enrollment for one or more healthcare programs | |
| WO2003077183A2 (en) | System and method for providing a generic health care data repository | |
| CN110619555A (en) | Unified management method and device for order information, terminal equipment and medium | |
| US20020111829A1 (en) | Method and associated apparatus for electronic prescription handling | |
| KR102156197B1 (en) | Method and device for prividing medical information through prescription information | |
| WO2019127773A1 (en) | Method and apparatus for processing sales of insurance product, storage medium, and terminal | |
| CN111276236A (en) | Universal interface server for medical informatization industry | |
| US8538777B1 (en) | Systems and methods for providing patient medication history | |
| CN111653329A (en) | Resident electronic health card external connection service platform system | |
| US20120046969A1 (en) | Converting Medical Data to a Data Format for Exportation from a Brokerage System | |
| CN109754875A (en) | A kind of medical self-aided terminal, equipment, Cloud Server and system | |
| CN116032946A (en) | Cross-region synchronization method, device and medium for detection report | |
| US20140249836A1 (en) | Claim driven medical event systems and methods | |
| US20210335468A1 (en) | Electronic system for automatically recommendating pharmacy stores all suitable drug products and methods thereof | |
| CN107391936A (en) | A kind of ophthalmology image based on distributed website integrates and dissemination method | |
| US20230153796A1 (en) | Controlled environment facility maintained digital wallets for residents of controlled environment facilities |
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 |