CN111125200A - HL7 message processing method and system based on database query - Google Patents
HL7 message processing method and system based on database query Download PDFInfo
- Publication number
- CN111125200A CN111125200A CN201911101665.0A CN201911101665A CN111125200A CN 111125200 A CN111125200 A CN 111125200A CN 201911101665 A CN201911101665 A CN 201911101665A CN 111125200 A CN111125200 A CN 111125200A
- Authority
- CN
- China
- Prior art keywords
- message
- sending
- receiving
- state
- modifying
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/248—Presentation of query results
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
- G06F16/252—Integrating or interfacing systems involving database management systems between a Database Management System and a front-end application
-
- G—PHYSICS
- G16—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR SPECIFIC APPLICATION FIELDS
- G16H—HEALTHCARE INFORMATICS, i.e. INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR THE HANDLING OR PROCESSING OF MEDICAL OR HEALTHCARE DATA
- G16H10/00—ICT specially adapted for the handling or processing of patient-related medical or healthcare data
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- General Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Health & Medical Sciences (AREA)
- Computational Linguistics (AREA)
- Public Health (AREA)
- Primary Health Care (AREA)
- Medical Informatics (AREA)
- Health & Medical Sciences (AREA)
- Epidemiology (AREA)
- Medical Treatment And Welfare Office Work (AREA)
Abstract
The embodiment of the invention provides a database query-based HL7 message processing method and a system, wherein the HL7 message processing method comprises the following steps: inquiring a medical system view table to be sent, inserting an inquiry result into an HL7 message sending table, sending an HL7 message, and modifying a sending state corresponding to an HL7 message sending table; when receiving HL7 message, recording in HL7 message receiving list, returning receiving result, and modifying checking state of the view table; the method is characterized in that the diagram is created based on a medical system to be sent, the HL7 message sending and receiving functions are added on the basis of not changing the functions and modules of the original system, and the interconnection and intercommunication between the diagram and other medical software information systems with HL7 message sending and receiving functions are realized.
Description
Technical Field
The embodiment of the invention relates to the technical field of information processing, in particular to a database query-based HL7 message processing method and system.
Background
In the field of medical health, network technology is an important method for solving the problem of integration of different functions and technologies in a computer integration process, and is also a trend of modernized medical information integration. The HL7(Health Level 7) standardized Health information transmission protocol is a protocol for electronic transmission between different applications in the medical field. HL7 has collected the standard format that different manufacturers used to design the interface between the application software, has reduced the cost of hospital information system interconnection, has improved the degree of data information sharing between the hospital information system.
However, the function of transmitting or receiving HL7 messages is not supported because some medical software information systems are developed earlier or for some reason.
Therefore, how to provide an HL7 message processing scheme based on database query, which can add HL7 message sending and receiving functions on the basis of not changing original system functions and modules, and implement interconnection and intercommunication with other medical software information systems having HL7 message sending and receiving functions is a technical problem to be urgently solved by technical personnel in the field.
Disclosure of Invention
Therefore, the embodiment of the invention provides an HL7 message processing method and system based on database query, which can increase the HL7 message sending and receiving functions on the basis of not changing the original system functions and modules, and realize interconnection and intercommunication with other medical software information systems with HL7 message sending and receiving functions.
In order to achieve the above object, the embodiments of the present invention provide the following technical solutions:
in a first aspect, an embodiment of the present invention provides an HL7 message processing method based on a database query, including:
inquiring a medical system view table to be sent, inserting an inquiry result into an HL7 message sending table, sending an HL7 message, and modifying a sending state corresponding to an HL7 message sending table;
when receiving HL7 message, recording in HL7 message receiving list, returning receiving result, and modifying checking state of the view table;
the view chart is created based on the medical system to be sent.
Preferably, the modifying the sending state corresponding to the HL7 message sending table includes:
receiving a sending result, and modifying a sending state corresponding to an HL7 message sending table according to the sending result;
when the opposite side refuses to receive the HL7 message, the message is not sent any more, and when the sending fails, the message is sent again;
and if the transmission is successful, the transmission is not carried out any more, and the transmission result in the view table is modified.
Preferably, when receiving the HL7 message, recording in an HL7 message receiving table, and returning a receiving result, and modifying the checking state of the view table, includes:
when receiving HL7 message, inserting an HL7 message receiving record in an HL7 message receiving table;
modifying the view table, and modifying the HL7 message modification receiving state in an HL7 message receiving table according to the result of modifying the view table;
the results of modifying the view table are returned to the HL7 messaging system.
Preferably, the view name and field meaning of the view table correspond to existing data of the medical system to be sent.
Preferably, the modifying the sending state corresponding to the HL7 message sending table includes:
inquiring data in the view table within a certain period of time in an ascending order, and inserting the inquiry result into an HL7 message sending table;
recording a sending state as a non-sending state in the HL7 message sending table, marking the sending state as 0, and setting the sending times as 0;
organizing into correct HL7 message format, sending HL7 message, modifying HL7 message sending table to send state as sent state, and marking as 1, and sending times as 1.
Preferably, when the opposite party refuses to receive the HL7 message, the message is not sent any more, and when the sending fails, the message is sent again; if the transmission is successful, the transmission is not transmitted any more, and the transmission result in the view table is modified, including:
after the HL7 message is sent, the message is waited to return, and after the message returns, the returned HL7 message is analyzed;
if the returned result is successful, modifying the transmission state of the HL7 message transmission table into a transmission success state, comparing the transmission success state with 2, and modifying the corresponding field in the view table;
and if the returned result fails, retransmitting the HL7 message, modifying the transmission times of an HL7 message transmission table to be 2, repeatedly transmitting the HL7 message until the preset times of failure are not transmitted, and modifying the corresponding field of the view table.
Preferably, when receiving the HL7 message, recording in an HL7 message receiving table, and returning a receiving result, and modifying the checking state of the view table, includes:
after receiving the HL7 message, analyzing fields in the HL7 message;
creating a piece of information in an HL7 message receiving table according to the received message field, and recording the message receiving state as a received state, wherein the received state is marked as 1;
the view table is modified according to the received content.
Preferably, when receiving the HL7 message, recording in an HL7 message receiving table, and returning a receiving result, and modifying the checking state of the view table, includes:
if the modification is successful, the message receiving state of the modified HL7 message receiving table is a modification success state and is marked as 2;
if the modification fails, the receiving state of the modified HL7 message receiving table is a modification failure state which is marked as 3;
the results of modifying the view table are returned to the HL7 messaging system.
In a second aspect, an embodiment of the present invention provides an HL7 message processing system based on a database query, including:
the HL7 message sending module is used for inquiring the medical system view chart to be sent, inserting the inquiry result into an HL7 message sending table, sending an HL7 message and modifying the sending state corresponding to the HL7 message sending table;
an HL7 message receiving module, which is used for recording in an HL7 message receiving table after receiving the HL7 message, returning a receiving result and modifying the checking state of the view table;
the view chart is created based on the medical system to be sent.
In a third aspect, an embodiment of the present invention provides an HL7 message processing apparatus based on a database query, including:
a memory for storing a computer program;
a processor adapted to carry out the steps of the database query based HL7 message processing method according to any one of the first aspects above when said computer program is executed.
In a fourth aspect, an embodiment of the present invention provides a computer-readable storage medium, on which a computer program is stored, where the computer program, when executed by a processor, implements the steps of the database query based HL7 message processing method according to any one of the first aspects.
The embodiment of the invention provides an HL7 message processing method based on database query, which comprises the following steps: inquiring a medical system view table to be sent, inserting an inquiry result into an HL7 message sending table, sending an HL7 message, and modifying a sending state corresponding to an HL7 message sending table; when receiving HL7 message, recording in HL7 message receiving list, returning receiving result, and modifying checking state of the view table; the method is characterized in that the diagram is created based on a medical system to be sent, the HL7 message sending and receiving functions are added on the basis of not changing the functions and modules of the original system, and the interconnection and intercommunication between the diagram and other medical software information systems with HL7 message sending and receiving functions are realized.
The method and the system for processing the HL7 message based on the database query provided by the embodiment of the invention have the beneficial effects, and are not described in detail herein.
Drawings
In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings used in the description of the embodiments or the prior art will be briefly described below. It should be apparent that the drawings in the following description are merely exemplary, and that other embodiments can be derived from the drawings provided by those of ordinary skill in the art without inventive effort.
The structures, ratios, sizes, and the like shown in the present specification are only used for matching with the contents disclosed in the specification, so as to be understood and read by those skilled in the art, and are not used to limit the conditions that the present invention can be implemented, so that the present invention has no technical significance, and any structural modifications, changes in the ratio relationship, or adjustments of the sizes, without affecting the effects and the achievable by the present invention, should still fall within the range that the technical contents disclosed in the present invention can cover.
Fig. 1 is a flowchart of an HL7 message processing method based on database query according to an embodiment of the present invention;
fig. 2 is a flow chart illustrating modification of a sending table state of an HL7 message processing method based on database query according to an embodiment of the present invention;
fig. 3 is a receiving table state modification flowchart of an HL7 message processing method based on database query according to an embodiment of the present invention;
fig. 4 is a flowchart illustrating a status flag of an HL7 message processing method based on database query according to an embodiment of the present invention;
fig. 5 is a flowchart of modifying a view of an HL7 message processing method based on a database query according to an embodiment of the present invention;
fig. 6 is a flowchart of a receive status flag of an HL7 message processing method based on database query according to an embodiment of the present invention;
fig. 7 is a specific flowchart of modification of a receiving table of an HL7 message processing method based on database query according to an embodiment of the present invention;
fig. 8 is a schematic diagram illustrating an HL7 message processing system based on database query according to an embodiment of the present invention;
fig. 9 is a schematic application diagram of an HL7 message processing system based on database query according to an embodiment of the present invention;
FIG. 10 is a functional diagram of the HL7 messaging module of FIG. 9;
FIG. 11 is a functional diagram of the HL7 message receiving module of FIG. 9;
fig. 12 is a schematic structural diagram of an HL7 message processing device based on database query according to an embodiment of the present invention.
Detailed Description
The present invention is described in terms of particular embodiments, other advantages and features of the invention will become apparent to those skilled in the art from the following disclosure, and it is to be understood that the described embodiments are merely exemplary of the invention and that it is not intended to limit the invention to the particular embodiments disclosed. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
Referring to fig. 1, fig. 2, fig. 3, fig. 4, fig. 5, fig. 6, and fig. 7, fig. 1 is a flowchart of an HL7 message processing method based on database query according to an embodiment of the present invention; fig. 2 is a flow chart illustrating modification of a sending table state of an HL7 message processing method based on database query according to an embodiment of the present invention; fig. 3 is a receiving table state modification flowchart of an HL7 message processing method based on database query according to an embodiment of the present invention; fig. 4 is a flowchart illustrating a status flag of an HL7 message processing method based on database query according to an embodiment of the present invention; fig. 5 is a flowchart of modifying a view of an HL7 message processing method based on a database query according to an embodiment of the present invention; fig. 6 is a flowchart of a receive status flag of an HL7 message processing method based on database query according to an embodiment of the present invention; fig. 7 is a specific flowchart of a receiving table modification of an HL7 message processing method based on database query according to an embodiment of the present invention.
In a specific implementation manner of the present invention, an embodiment of the present invention provides an HL7 message processing method based on database query, including:
step S11: inquiring a medical system view table to be sent, inserting an inquiry result into an HL7 message sending table, sending an HL7 message, and modifying a sending state corresponding to an HL7 message sending table;
step S12: when receiving HL7 message, recording in HL7 message receiving list, returning receiving result, and modifying checking state of the view table;
the view chart is created based on the medical system to be sent.
In the embodiment of the present invention, the method provided in the embodiment of the present invention is applied to a medical system to be sent, and the medical system to be sent cannot support the HL7 health information transmission protocol, so that when the medical system capable of supporting the HL7 health information transmission protocol communicates with each other, mutual identification cannot be performed, and by using the method provided in the embodiment of the present invention, the HL7 message sending and receiving functions can be added on the basis of not changing the original system functions and modules, so as to achieve interconnection and intercommunication with other medical software information systems having the HL7 message sending and receiving functions.
In particular, in order to modify the transmission status corresponding to the HL7 messaging table, the following steps may be implemented:
step S21: receiving a sending result, and modifying a sending state corresponding to an HL7 message sending table according to the sending result;
step S22: when the opposite side refuses to receive the HL7 message, the message is not sent any more, and when the sending fails, the message is sent again;
step S23: and if the transmission is successful, the transmission is not carried out any more, and the transmission result in the view table is modified.
That is, a view table based on an information system to be sent can be created first, an HL7 message sending table is created in an HL7 message processing system database, the view table of the medical system to be sent is inquired according to date and time, the inquiry result is inserted into an HL7 message sending table, an HL7 message is sent, the sending state of the HL7 message is modified, the sending result is waited for, the sending state of the sending table is modified according to the sending result, if the sending fails, the sending is not carried out again if the sending is refused by the opposite side, and if the sending fails, the sending is; if the transmission is successful and no longer transmitted, the transmission result in the view table is modified, and of course, the number of transmissions may be set, for example, 5 times.
Further, in order to realize that when receiving the HL7 message, the message is recorded in an HL7 message receiving table, and the receiving result is returned, and the checking state of the view table is modified, the following steps can be carried out:
step S31: when receiving HL7 message, inserting an HL7 message receiving record in an HL7 message receiving table;
step S32: modifying the view table, and modifying the HL7 message modification receiving state in an HL7 message receiving table according to the result of modifying the view table;
step S33: the results of modifying the view table are returned to the HL7 messaging system.
That is, an HL7 message receiving table may be created first, after receiving an HL7 message, an HL7 message receiving record is inserted into the HL7 message receiving table, the view table is modified, the HL7 message modification receiving state is modified in the HL7 message receiving table according to the result of modifying the view table, and the result of modifying the view table is returned to the HL7 message sending system.
It is worth noting that the view name and field meaning of the view corresponds to the existing data of the medical system to be sent. Specifically, a correct view table can be created before software runs according to the correspondence between the set view table name and field meaning and the existing data of the medical system to be sent.
Further, in order to modify the transmission status corresponding to the HL7 messaging table, the following steps may be performed:
step S41: inquiring data in the view table within a certain period of time in an ascending order, and inserting the inquiry result into an HL7 message sending table;
step S42: recording a sending state as a non-sending state in the HL7 message sending table, marking the sending state as 0, and setting the sending times as 0;
step S43: organizing into correct HL7 message format, sending HL7 message, modifying HL7 message sending table to send state as sent state, and marking as 1, and sending times as 1.
That is to say, in the software development process of the method provided by the present invention, an HL7 message sending table is created, when software runs, data in a view table in a certain period of time is queried in an ascending order, a query result is inserted into an HL7 message sending table, a sending state is recorded as 0 (unsent), the number of sending times is recorded as 0, and the sending time is organized into a correct HL7 message format, an HL7 message is sent, a sending state in the HL7 message sending table is modified as 1 (sent), the number of sending times is 1, of course, other marks may also be used for marking.
In addition, in the concrete implementation, when the opposite side refuses to receive the HL7 message, the message is not sent any more, and when the sending fails, the message is sent again; if the transmission is successful and the transmission result in the view table is modified, the following steps can be implemented:
step S51: after the HL7 message is sent, the message is waited to return, and after the message returns, the returned HL7 message is analyzed;
step S52: if the returned result is successful, modifying the transmission state of the HL7 message transmission table into a transmission success state, comparing the transmission success state with 2, and modifying the corresponding field in the view table;
step S53: and if the returned result fails, retransmitting the HL7 message, modifying the transmission times of an HL7 message transmission table to be 2, repeatedly transmitting the HL7 message until the preset times of failure are not transmitted, and modifying the corresponding field of the view table.
That is, after the HL7 message is sent, the message is waited to be returned, after the message is returned, the HL7 message is analyzed, the result is returned successfully, the sending state of the HL7 message sending table is modified to be 2 (the sending is successful), and the corresponding field in the view table is modified; and returning a result of failure, retransmitting the HL7 message, modifying the transmission times of the HL7 message transmission table to be 2, repeating the result until the result is failed five times, no longer transmitting the result, and modifying the corresponding field of the view table.
It should be noted that, after receiving the HL7 message, the following steps may be implemented, which may be recorded in an HL7 message receiving table, and return the receiving result to modify the checking state of the view table:
step S61: after receiving the HL7 message, analyzing fields in the HL7 message;
step S62: creating a piece of information in an HL7 message receiving table according to the received message field, and recording the message receiving state as a received state, wherein the received state is marked as 1;
step S63: the view table is modified according to the received content.
Specifically, in order to implement the above steps, an HL7 message receiving table is created in the software development process, after receiving an HL7 message, a field in an HL5 message is parsed, a piece of information is created in an HL7 message receiving table according to the received message field, the message receiving state is recorded as 1 (received), and a view table is modified according to the received content.
Finally, after receiving the HL7 message, recording in an HL7 message receiving table, returning a receiving result, and modifying the checking state of the view table, specifically, modifying and marking the state of the message receiving table, specifically, the following steps may be performed:
step S71: if the modification is successful, the message receiving state of the modified HL7 message receiving table is a modification success state and is marked as 2;
step S72: if the modification fails, the receiving state of the modified HL7 message receiving table is a modification failure state which is marked as 3;
step S73: the results of modifying the view table are returned to the HL7 messaging system.
The embodiment of the invention provides an HL7 message processing method based on database query, which adds HL7 message sending and receiving functions on the basis of not changing the functions and modules of the original system and realizes the interconnection and intercommunication with other medical software information systems with HL7 message sending and receiving functions.
In addition, it should be noted that the foregoing HL7 message processing method based on database query may also be used for communication between two HIS databases that do not support HL7 messages, that is, the two HIS databases interact by converting their own received and transmitted information into HL7 messages, and a sending module and a receiving module of the HIS databases are asynchronous, which is actually two services, and after sending a message, the receiving module does not need to wait for the message to return, and after receiving the message, and when analyzing the message, the receiving module can determine whether the message is a return sent or another message according to a field.
Referring to fig. 8, fig. 8 is a schematic diagram illustrating an HL7 message processing system based on database query according to an embodiment of the present invention.
An embodiment of the present invention provides an HL7 message processing system 800 based on database query, including:
an HL7 message sending module 810, configured to query a medical system view table to be sent, insert the query result into an HL7 message sending table, send an HL7 message, and modify a sending state corresponding to the HL7 message sending table;
an HL7 message receiving module 820, configured to record in an HL7 message receiving table after receiving the HL7 message, return a receiving result, and modify a checking state of the view table;
the view chart is created based on the medical system to be sent.
Referring to fig. 9, fig. 10, and fig. 11, fig. 9 is a schematic application diagram of an HL7 message processing system based on database query according to an embodiment of the present invention; FIG. 10 is a functional diagram of the HL7 messaging module of FIG. 9; fig. 11 is a functional diagram of the HL7 message receiving module in fig. 9.
Specifically, in this embodiment, only views can be used in the medical system 1 to perform information transfer, while the medical systems 2, 3, and 4 … … can use HL7 messages to perform communication, and the HL7 message processing system provided in this embodiment of the present invention can implement information transfer between the medical system 1 and other medical systems supporting the HL7 protocol. Specifically, reference may be made to the description of the HL7 message processing method based on database query in any of the above embodiments, which is not repeated here.
It should be noted that, the medical system in the embodiment of the present invention may include: several relatively large medical systems, such as HIS/PACS/LIS/RIS, may of course also include some smaller medical systems for departments, or other medical systems.
Referring to fig. 12, fig. 12 is a schematic structural diagram of an HL7 message processing apparatus based on database query according to an embodiment of the present invention.
An embodiment of the present invention provides an HL7 message processing apparatus 1200 based on database query, including:
a memory 1210 for storing a computer program;
a processor 1220, configured to implement the steps of the database query based HL7 message processing method according to any one of the above embodiments when the computer program is executed.
Embodiments of the present invention provide a computer-readable storage medium, on which a computer program is stored, where the computer program, when executed by a processor, implements the steps of the database query based HL7 message processing method according to any one of the embodiments.
As will be appreciated by one skilled in the art, embodiments of the present application may be provided as a method, system, or computer program product. Accordingly, the present application may take the form of an entirely hardware embodiment, an entirely software embodiment or an embodiment combining software and hardware aspects. Furthermore, the present application may take the form of a computer program product embodied on one or more computer-usable storage media (including, but not limited to, disk storage, CD-ROM, optical storage, and the like) having computer-usable program code embodied therein.
The present application is described with reference to flowchart illustrations and/or block diagrams of methods, apparatus (systems), and computer program products according to embodiments of the application. It will be understood that each flow and/or block of the flow diagrams and/or block diagrams, and combinations of flows and/or blocks in the flow diagrams and/or block diagrams, can be implemented by computer program instructions. These computer program instructions may be provided to a processor of a general purpose computer, special purpose computer, embedded processor, or other programmable data processing apparatus to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing apparatus, create means for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be stored in a computer-readable memory that can direct a computer or other programmable data processing apparatus to function in a particular manner, such that the instructions stored in the computer-readable memory produce an article of manufacture including instruction means which implement the function specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be loaded onto a computer or other programmable data processing apparatus to cause a series of operational steps to be performed on the computer or other programmable apparatus to produce a computer implemented process such that the instructions which execute on the computer or other programmable apparatus provide steps for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
In a typical configuration, a computing device includes one or more processors (CPUs), input/output interfaces, network interfaces, and memory. The memory may include forms of volatile memory in a computer readable medium, Random Access Memory (RAM) and/or non-volatile memory, such as Read Only Memory (ROM) or flash memory (flash RAM). The memory is an example of a computer-readable medium.
Computer-readable media, including both non-transitory and non-transitory, removable and non-removable media, may implement information storage by any method or technology. The information may be computer readable instructions, data structures, modules of a program, or other data. Examples of computer storage media include, but are not limited to, phase change memory (PRAM), Static Random Access Memory (SRAM), Dynamic Random Access Memory (DRAM), other types of Random Access Memory (RAM), Read Only Memory (ROM), Electrically Erasable Programmable Read Only Memory (EEPROM), flash memory or other memory technology, compact disc read only memory (CD-ROM), Digital Versatile Discs (DVD) or other optical storage, magnetic cassettes, magnetic tape magnetic disk storage or other magnetic storage devices, or any other non-transmission medium that can be used to store information that can be accessed by a computing device. As defined herein, a computer readable medium does not include a transitory computer readable medium such as a modulated data signal and a carrier wave.
It should also be noted that the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or apparatus. Without further limitation, an element defined by the phrase "comprising an … …" does not exclude the presence of other identical elements in the process, method, article, or apparatus that comprises the element.
Although the invention has been described in detail above with reference to a general description and specific examples, it will be apparent to one skilled in the art that modifications or improvements may be made thereto based on the invention. Accordingly, such modifications and improvements are intended to be within the scope of the invention as claimed.
Claims (10)
1. A HL7 message processing method based on database query is characterized by comprising the following steps:
inquiring a medical system view table to be sent, inserting an inquiry result into an HL7 message sending table, sending an HL7 message, and modifying a sending state corresponding to an HL7 message sending table;
when receiving HL7 message, recording in HL7 message receiving list, returning receiving result, and modifying checking state of the view table;
the view chart is created based on the medical system to be sent.
2. A HL7 message processing method according to claim 1,
the modification of the sending state corresponding to the HL7 message sending table comprises the following steps:
receiving a sending result, and modifying a sending state corresponding to an HL7 message sending table according to the sending result;
when the opposite side refuses to receive the HL7 message, the message is not sent any more, and when the sending fails, the message is sent again;
and if the transmission is successful, the transmission is not carried out any more, and the transmission result in the view table is modified.
3. A HL7 message processing method according to claim 1,
when receiving HL7 message, recording in HL7 message receiving table, and returning the receiving result, modifying the checking state of the view table, including:
when receiving HL7 message, inserting an HL7 message receiving record in an HL7 message receiving table;
modifying the view table, and modifying the HL7 message modification receiving state in an HL7 message receiving table according to the result of modifying the view table;
the results of modifying the view table are returned to the HL7 messaging system.
4. A HL7 message processing method according to claim 2,
and the view chart name and the field meaning of the view chart correspond to the existing data of the medical system to be sent.
5. A HL7 message processing method according to claim 2,
the modification of the sending state corresponding to the HL7 message sending table comprises the following steps:
inquiring data in the view table within a certain period of time in an ascending order, and inserting the inquiry result into an HL7 message sending table;
recording a sending state as a non-sending state in the HL7 message sending table, marking the sending state as 0, and setting the sending times as 0;
organizing into correct HL7 message format, sending HL7 message, modifying HL7 message sending table to send state as sent state, and marking as 1, and sending times as 1.
6. A HL7 message processing method according to claim 2,
when the opposite side refuses to receive the HL7 message, the message is not sent any more, and when the sending fails, the message is sent again; if the transmission is successful, the transmission is not transmitted any more, and the transmission result in the view table is modified, including:
after the HL7 message is sent, the message is waited to return, and after the message returns, the returned HL7 message is analyzed;
if the returned result is successful, modifying the transmission state of the HL7 message transmission table into a transmission success state, comparing the transmission success state with 2, and modifying the corresponding field in the view table;
and if the returned result fails, retransmitting the HL7 message, modifying the transmission times of an HL7 message transmission table to be 2, repeatedly transmitting the HL7 message until the preset times of failure are not transmitted, and modifying the corresponding field of the view table.
7. A HL7 message processing method according to claim 1,
when receiving HL7 message, recording in HL7 message receiving table, and returning the receiving result, modifying the checking state of the view table, including:
after receiving the HL7 message, analyzing fields in the HL7 message;
creating a piece of information in an HL7 message receiving table according to the received message field, and recording the message receiving state as a received state, wherein the received state is marked as 1;
the view table is modified according to the received content.
8. A HL7 message processing method according to claim 1,
when receiving HL7 message, recording in HL7 message receiving table, and returning the receiving result, modifying the checking state of the view table, including:
if the modification is successful, the message receiving state of the modified HL7 message receiving table is a modification success state and is marked as 2;
if the modification fails, the receiving state of the modified HL7 message receiving table is a modification failure state which is marked as 3;
the results of modifying the view table are returned to the HL7 messaging system.
9. An HL7 message processing system based on database query, comprising:
the HL7 message sending module is used for inquiring the medical system view chart to be sent, inserting the inquiry result into an HL7 message sending table, sending an HL7 message and modifying the sending state corresponding to the HL7 message sending table;
an HL7 message receiving module, which is used for recording in an HL7 message receiving table after receiving the HL7 message, returning a receiving result and modifying the checking state of the view table;
the view chart is created based on the medical system to be sent.
10. An HL7 message processing device based on database query, comprising:
a memory for storing a computer program;
a processor for implementing the steps of the database query based HL7 message processing method according to any one of claims 1 to 8 when executing the computer program.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911101665.0A CN111125200A (en) | 2019-11-12 | 2019-11-12 | HL7 message processing method and system based on database query |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911101665.0A CN111125200A (en) | 2019-11-12 | 2019-11-12 | HL7 message processing method and system based on database query |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN111125200A true CN111125200A (en) | 2020-05-08 |
Family
ID=70495216
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201911101665.0A Pending CN111125200A (en) | 2019-11-12 | 2019-11-12 | HL7 message processing method and system based on database query |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111125200A (en) |
Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101052041A (en) * | 2007-05-10 | 2007-10-10 | 浙江大学 | Integrating engine of medical information |
| CN101083582A (en) * | 2007-06-22 | 2007-12-05 | 华中科技大学 | Heterogeneous medical information integrated system based on HL7 agent server |
| CA2678128A1 (en) * | 2007-02-14 | 2008-08-21 | The General Hospital Corporation | Medical laboratory report message gateway |
| CN102819676A (en) * | 2012-07-31 | 2012-12-12 | 成都金盘电子科大多媒体技术有限公司 | Information exchange platform system and information exchange communicating method for hospital |
| CN103139042A (en) * | 2011-11-25 | 2013-06-05 | 深圳市蓝韵网络有限公司 | Method and system for processing HL7 messages on basis of file management |
| US20150278973A1 (en) * | 2014-03-28 | 2015-10-01 | Mckesson Financial Holdings | Method and apparatus for providing improved generation of healthcare messages |
| CN106600499A (en) * | 2016-12-23 | 2017-04-26 | 北京蓝海医信科技有限公司 | Hospital information integration method based on bus form |
| CN110021413A (en) * | 2019-03-01 | 2019-07-16 | 医利捷(上海)信息科技有限公司 | A kind of information for hospital integrated system |
-
2019
- 2019-11-12 CN CN201911101665.0A patent/CN111125200A/en active Pending
Patent Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CA2678128A1 (en) * | 2007-02-14 | 2008-08-21 | The General Hospital Corporation | Medical laboratory report message gateway |
| CN101052041A (en) * | 2007-05-10 | 2007-10-10 | 浙江大学 | Integrating engine of medical information |
| CN101083582A (en) * | 2007-06-22 | 2007-12-05 | 华中科技大学 | Heterogeneous medical information integrated system based on HL7 agent server |
| CN103139042A (en) * | 2011-11-25 | 2013-06-05 | 深圳市蓝韵网络有限公司 | Method and system for processing HL7 messages on basis of file management |
| CN102819676A (en) * | 2012-07-31 | 2012-12-12 | 成都金盘电子科大多媒体技术有限公司 | Information exchange platform system and information exchange communicating method for hospital |
| US20150278973A1 (en) * | 2014-03-28 | 2015-10-01 | Mckesson Financial Holdings | Method and apparatus for providing improved generation of healthcare messages |
| CN106600499A (en) * | 2016-12-23 | 2017-04-26 | 北京蓝海医信科技有限公司 | Hospital information integration method based on bus form |
| CN110021413A (en) * | 2019-03-01 | 2019-07-16 | 医利捷(上海)信息科技有限公司 | A kind of information for hospital integrated system |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN101316226B (en) | Method, device and system for acquiring resources | |
| CN110032599B (en) | Data structure reading and updating method and device, and electronic equipment | |
| CN109670081B (en) | Method and device for processing service request | |
| CN102203736A (en) | Method and device for calling open application programming interface (openapi) | |
| RU2382402C2 (en) | Flexible context control for listing sessions using context exchange | |
| CN111506579A (en) | Method, program and equipment for generating intelligent contract code | |
| US10462258B2 (en) | Resource download method, electronic device, and apparatus | |
| CN111277983A (en) | RFID middleware, publish-subscribe system and data transmission method | |
| CN108805587A (en) | A kind of customer information processing method, device, medium and electronic equipment | |
| CN113743712A (en) | Automatic generation and association method, system and storage medium for electronic operation rules of medicines | |
| CN104021216A (en) | Message proxy server and information publish subscription method and system | |
| CN111125200A (en) | HL7 message processing method and system based on database query | |
| CN116974999A (en) | Electronic document signing method and device, electronic device and storage medium | |
| CN110059091B (en) | Index construction method, device, client, server and system | |
| CN107463618B (en) | Index creating method and device | |
| CN111177093A (en) | Method, device and medium for sharing scientific and technological resources | |
| CN116233164A (en) | Method, apparatus, storage medium and processor for collecting device data | |
| CN114510636A (en) | Product data query method and device based on identification analysis and storage medium | |
| CN111159192B (en) | Big data based data warehousing method and device, storage medium and processor | |
| US7743386B2 (en) | Context objects for accessing message content | |
| CN109600403B (en) | Method and device for sending information | |
| CN113609220A (en) | Data sharing method and device based on service chain cooperation | |
| CN108228145A (en) | Data processing method, system and the mobile equipment of mixed type application program | |
| US20060026125A1 (en) | Accessing entity data from a UDDI registry | |
| CN111652580A (en) | Method and device for processing data of nodes |
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 |