CN113590883A - Method, system, device and storage medium for mapping medical information and database - Google Patents
Method, system, device and storage medium for mapping medical information and database Download PDFInfo
- Publication number
- CN113590883A CN113590883A CN202110914352.8A CN202110914352A CN113590883A CN 113590883 A CN113590883 A CN 113590883A CN 202110914352 A CN202110914352 A CN 202110914352A CN 113590883 A CN113590883 A CN 113590883A
- Authority
- CN
- China
- Prior art keywords
- medical information
- updating
- mapping
- document
- name
- 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
- 238000013507 mapping Methods 0.000 title claims abstract description 118
- 238000000034 method Methods 0.000 title claims abstract description 40
- 238000012986 modification Methods 0.000 claims description 23
- 230000004048 modification Effects 0.000 claims description 23
- 238000012790 confirmation Methods 0.000 claims description 16
- 238000010586 diagram Methods 0.000 description 8
- 238000012545 processing Methods 0.000 description 7
- 230000003287 optical effect Effects 0.000 description 3
- 238000005111 flow chemistry technique Methods 0.000 description 2
- 239000013307 optical fiber Substances 0.000 description 2
- 230000000644 propagated effect Effects 0.000 description 2
- 238000003491 array Methods 0.000 description 1
- 238000004891 communication Methods 0.000 description 1
- 201000010099 disease Diseases 0.000 description 1
- 208000037265 diseases, disorders, signs and symptoms Diseases 0.000 description 1
- 239000003814 drug Substances 0.000 description 1
- 230000006870 function Effects 0.000 description 1
- 239000000463 material Substances 0.000 description 1
- 230000002093 peripheral effect Effects 0.000 description 1
- 230000003252 repetitive effect Effects 0.000 description 1
- 238000011160 research Methods 0.000 description 1
- 239000004065 semiconductor Substances 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
- 230000001960 triggered effect Effects 0.000 description 1
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/80—Information retrieval; Database structures therefor; File system structures therefor of semi-structured data, e.g. markup language structured data such as SGML, XML or HTML
- G06F16/84—Mapping; Conversion
- G06F16/86—Mapping to a database
-
- 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/23—Updating
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Medical Treatment And Welfare Office Work (AREA)
Abstract
The invention provides a method, a system, equipment and a storage medium for mapping medical information and a database, wherein the method comprises the following steps: presetting a medical information mapping table, and prestoring a plurality of medical information names corresponding to medical information parameters and an updating path set; when the medical information name preset in the medical information mapping table is hit in the clause, the medical information parameter corresponding to the medical information name is automatically filled in the document after the medical information name, an updating path is generated at least based on the document name and the position of the medical information parameter in the document and is stored in an updating path set corresponding to the medical information name, and if the medical information parameter after filling is modified, the associated medical information mapping table and the document are modified. The invention can modify the medical information in a structured way, and automatically and uniformly update all the medical information names with modified parameters, thereby simplifying the step of data synchronization and improving the efficiency of updating structured document data.
Description
Technical Field
The invention relates to the field of questionnaire entry, in particular to a method, a system, equipment and a storage medium for mapping medical information and a database.
Background
The existing clinical data needs to extract effective information from unstructured cases recorded on paper materials and input the effective information into a case report form, and the data input of the case report form is the most painful problem of clinical coordinators at present, and the data volume is huge and the data is not standard.
Since the medical information names are not used in the various places in a standardized way, the same disease condition or data index can be used in different names in various hospitals or medicine researches, and therefore, the manual data can be only collated and summarized by experienced personnel. Even if the number of the input personnel is increased, when the number of cases is large, the information to be input is large, the workload is large, the manual input efficiency is low, and errors are easy to occur.
Accordingly, the present invention provides a method, system, device and storage medium for mapping medical information to a database.
Disclosure of Invention
The invention aims to provide a method, a system, equipment and a storage medium for mapping medical information and a database, overcomes the difficulties in the prior art, can modify the structure of the medical information, automatically and uniformly update the names of the medical information with modified parameters, simplifies the steps of data synchronization and improves the efficiency of updating the structured document data.
The embodiment of the invention provides a method for mapping medical information and a database, which comprises the following steps:
s110, presetting a medical information mapping table, wherein a plurality of medical information names are prestored in the medical information mapping table, and each medical information name corresponds to at least one medical information parameter and an update path set based on a plurality of documents;
s120, identifying the currently input current clause in the document, judging whether the name of the medical information preset in the medical information mapping table is hit, if so, executing the step S130, otherwise, returning to the step S120;
s130, automatically filling medical information parameters corresponding to the medical information names in the documents after the medical information names are filled, generating an updating path at least based on the document names and the positions of the medical information parameters in the documents, and storing the updating path into an updating path set corresponding to the medical information names;
s140, judging whether the medical information parameters are modified after filling, if so, executing a step S160, otherwise, returning to the step S120;
s160, updating the modified medical information parameter to a medical information parameter corresponding to the medical information name in the medical information mapping table; and
s170, updating the medical information parameters corresponding to the medical information names in all the documents based on the modified medical information parameters and the updated path set.
Preferably, the current clause is all characters between the current input cursor position in the document and the previous punctuation mark.
Preferably, in step S110, in the medical information mapping table, a mapping relationship is established among the medical information name, at least one alternative name, the medical information parameter, and an updated path set based on a plurality of documents;
in the step S120, the current clause currently input in the document is identified, and whether the name of the medical information preset in the medical information mapping table or the alternative name having a mapping relationship with the medical information name is hit is determined, if yes, the step S130 is executed, and if not, the step S120 is returned to.
Preferably, in step S110, in the medical information mapping table, the medical information name, the modification authority, the medical information parameter, and the update path set based on a plurality of documents establish a mapping relationship;
after step S140 and before step S160, the method further includes:
step S150, determining whether the authority of the user account performing the modification operation satisfies the modification authority corresponding to the medical information name, if so, executing step S160, otherwise, returning to step S120.
Preferably, the S140 includes:
s141, judging whether the medical information parameters are modified after filling, if so, executing a step S142, and if not, returning to the step S120;
s142, generating a confirmation box based on the position of the medical information parameter in the document, wherein the confirmation box comprises the data before the medical information parameter is modified and the data after the medical information parameter is modified, and the data is used for clicking confirmation of the user account;
and S143, judging whether the user account is confirmed within the preset time, if so, executing the step S160, otherwise, returning to the step S120.
Preferably, the step S170 includes:
s171, judging whether each document in the updating path set is online, if so, executing a step S172, and if not, executing a step S173;
s172, updating medical information parameters corresponding to the medical information names in all the documents on line, and ending;
s173, respectively generating an updating task for each offline document, and adding the updating task into the updating task queue, wherein the updating task comprises medical information parameters needing to be updated and related updating paths;
and S174, when the fact that the corresponding document in the update task queue is online is detected, triggering the update task, updating the medical information parameter corresponding to the medical information name in the document, and ending.
Preferably, each pair of the medical information name and medical information parameter in the document forms an XML component.
Preferably, the medical information parameter in the medical information mapping table is an SQL object type corresponding to the medical information parameter in the XML component in the document.
The embodiment of the present invention further provides a system for mapping medical information and a database, which is used for implementing the method for mapping medical information and a database, and the system for mapping medical information and a database includes:
the information mapping module is used for presetting a medical information mapping table, wherein a plurality of medical information names are prestored in the medical information mapping table, and each medical information name corresponds to at least one medical information parameter and an updating path set based on a plurality of documents;
the document identification module is used for identifying the current clause currently input in the document and judging whether the name of the medical information preset in the medical information mapping table is hit or not, if yes, the information filling module is executed, and if not, the information is returned to the document identification module;
the information filling module is used for automatically filling medical information parameters corresponding to the medical information names in the documents after the medical information names are filled in the documents, generating an updating path at least based on the document names and the positions of the medical information parameters in the documents, and storing the updating path into an updating path set corresponding to the medical information names;
the modification judgment module is used for judging whether the medical information parameters are modified after filling, if so, the mapping updating module is executed, and if not, the mapping updating module returns to the document identification module;
the mapping updating module is used for updating the medical information parameters corresponding to the medical information names in the medical information mapping table according to the modified medical information parameters; and
and the parameter updating module is used for updating the medical information parameters corresponding to the medical information names in all the documents based on the modified medical information parameters and the updated path set.
An embodiment of the present invention further provides a device for mapping medical information with a database, including:
a processor;
a memory having stored therein executable instructions of the processor;
wherein the processor is configured to perform the steps of the above-described method of medical information and database mapping via execution of the executable instructions.
Embodiments of the present invention also provide a computer-readable storage medium for storing a program that, when executed, performs the steps of the above-described method for mapping medical information to a database.
The invention aims to provide a method, a system, equipment and a storage medium for mapping medical information and a database, which can be used for structurally modifying the medical information, automatically and uniformly updating medical information names with modified parameters, simplify the step of data synchronization and improve the efficiency of updating structural document data.
Drawings
Other features, objects and advantages of the present invention will become more apparent upon reading of the following detailed description of non-limiting embodiments thereof, with reference to the accompanying drawings.
FIG. 1 is a flow chart of a method of medical information and database mapping of the present invention.
Fig. 2 to 6 are schematic diagrams illustrating the implementation process of the method for mapping medical information and database according to the present invention.
FIG. 7 is a block diagram of a system for medical information and database mapping of the present invention.
Fig. 8 is a schematic diagram of the structure of the medical information and database mapping apparatus of the present invention.
Fig. 9 is a schematic structural diagram of a computer-readable storage medium according to an embodiment of the present invention.
Detailed Description
Example embodiments will now be described more fully with reference to the accompanying drawings. Example embodiments may, however, be embodied in many different forms and should not be construed as limited to the embodiments set forth herein. Rather, these embodiments are provided so that this disclosure will be thorough and complete, and will fully convey the concept of example embodiments to those skilled in the art. The same reference numerals in the drawings denote the same or similar structures, and thus their repetitive description will be omitted.
FIG. 1 is a flow chart of a method of medical information and database mapping of the present invention. As shown in fig. 1, an embodiment of the present invention provides a method for mapping medical information with a database, including the following steps:
s110, presetting a medical information mapping table, wherein a plurality of medical information names are prestored in the medical information mapping table, and each medical information name corresponds to at least one medical information parameter and an updating path set based on a plurality of documents;
s120, identifying the current clause currently input in the document, judging whether a preset medical information name in a medical information mapping table is hit, if so, executing the step S130, otherwise, returning to the step S120;
s130, automatically filling medical information parameters corresponding to the medical information names in the document after the medical information names, generating an updating path at least based on the document names and the positions of the medical information parameters in the document, and storing the updating path into an updating path set corresponding to the medical information names;
s140, judging whether the filled medical information parameters are modified, if so, executing a step S160, otherwise, returning to the step S120;
s160, updating the modified medical information parameters into medical information parameters corresponding to medical information names in a medical information mapping table; and
and S170, updating the medical information parameters corresponding to the medical information names in all the documents based on the modified medical information parameters and the updated path set.
In a preferred embodiment, the clauses are all text in the document between the current input cursor position to the previous punctuation.
In a preferred embodiment, in step S110, in the medical information mapping table, a mapping relationship is established among a medical information name, at least one alternative name, medical information parameters, and an updated path set based on a plurality of documents;
in step S120, the current clause currently input in the document is identified, whether a medical information name preset in the medical information mapping table or an alternative name having a mapping relationship with the medical information name is hit is determined, if yes, step S130 is executed, and if not, step S120 is returned.
In a preferred embodiment, in step S110, in the medical information mapping table, the medical information name, the modification authority, the medical information parameter, and the updated path set based on several documents establish a mapping relationship;
after step S140 and before step S160, the method further includes:
and step S150, judging whether the authority of the user account for modification operation meets the modification authority corresponding to the medical information name, if so, executing step S160, otherwise, returning to step S120.
In a preferred embodiment, S140 includes:
s141, judging whether the filled medical information parameters are modified, if so, executing a step S142, otherwise, returning to the step S120;
s142, generating a confirmation box based on the position of the medical information parameter in the document, wherein the confirmation box comprises data before the medical information parameter is modified and data after the medical information parameter is modified, and the data is used for clicking and confirming the user account;
and S143, judging whether the confirmation operation of the user account is received within the preset time, if so, executing the step S160, otherwise, returning to the step S120.
In a preferred embodiment, step S170 includes:
s171, judging whether each document in the updating path set is online, if so, executing a step S172, otherwise, executing a step S173;
s172, updating medical information parameters corresponding to the medical information names in all the online documents, and ending;
s173, respectively generating an updating task for each offline document, and adding the updating task into an updating task queue, wherein the updating task comprises medical information parameters needing to be updated and related updating paths;
and S174, when the corresponding document in the update task queue is detected to be online, triggering the update task, updating the medical information parameter corresponding to the medical information name in the document, and ending.
In a preferred embodiment, each pair of a medical information name and a medical information parameter in the document forms an XML component.
In a preferred embodiment, the medical information parameters in the medical information mapping table are SQL object types corresponding to the medical information parameters in XML components in the document.
Fig. 2 to 6 are schematic diagrams illustrating the implementation process of the method for mapping medical information and database according to the present invention. As shown in fig. 2 to 6, the method for mapping medical information and database according to the present invention is implemented as follows:
as shown in fig. 2, a medical information mapping table 21 is preset in the server 2, and a plurality of medical information names ("AAA", "BBB", "CCC", etc.) are prestored in the medical information mapping table 21, where each medical information name corresponds to a medical information parameter, at least one candidate name, a modification authority, and an update path set 22 based on a plurality of documents. Wherein the medical information parameter of the medical information name "AAA" is "xxx", and the medical information name "AAA" and the medical information parameter are xxx corresponding to three update paths located in three different documents 12, 13, 14. The document 11 is a document which is operated again by the current user. Where documents 11, 12, 13 are online and document 14 is offline.
And identifying the currently input current clause 'AAA is' in the document 11, wherein the clause is all characters from the current input cursor position to the previous punctuation mark in the document. Taking the document 11 operated again by the current user as an example, as shown in fig. 3, if the medical information name "AAA" hits the medical information name preset in the medical information mapping table 21, the medical information parameter "xxx" corresponding to the medical information name "AAA" is automatically filled after the medical information name "AAA" in the document, and an update path is generated based on at least the document name and the medical information parameter at the position of the document 11 and stored in the update path set 22 corresponding to the medical information name.
As shown in fig. 4, when the medical information parameter is modified after the filling, it is determined whether the authority of the user account performing the modification operation satisfies the modification authority corresponding to the medical information name, in this embodiment, the authority of the user account satisfies the modification authority corresponding to the medical information name, a confirmation frame is generated based on the position of the medical information parameter in the document, and the confirmation frame includes the data before the medical information parameter is modified and the data after the medical information parameter is modified, so that the user account can click and confirm the data.
As shown in fig. 5, after the user confirms the modification operation, the modified medical information parameter is updated to the medical information parameter ("xxx" is changed to "WWW") corresponding to the medical information name "AAA" in the medical information mapping table 21; and updating the medical information parameters corresponding to the medical information names in all the documents 12 and 13 on line, and ending. And respectively generating an updating task 23 for the documents 14 which are not on line, and adding the updating task 23 into the updating task queue, wherein the updating task 23 comprises the medical information parameters which need to be updated and the related updating paths.
As shown in fig. 6, when it is detected that the corresponding document 14 in the update task queue is online, the update task 23 is triggered, the medical information parameter corresponding to the medical information name in the document is updated, and the update is completed, so that the medical information parameter corresponding to the medical information name in the document 11 is realized, the medical information mapping table 21 in the server 2 and the same medical information parameter in the associated documents 11, 12, and 13 are uniformly modified, the uniform update of the medical information names with all the parameters modified is realized automatically, the step of data synchronization is simplified, and the efficiency of updating the structured document data is improved.
FIG. 7 is a block diagram of a system for medical information and database mapping of the present invention. As shown in fig. 7, the system 5 for mapping medical information and a database of the present invention includes:
the information mapping module 51 presets a medical information mapping table, in which a plurality of medical information names are prestored, each medical information name corresponds to at least one medical information parameter and an update path set based on a plurality of documents.
The document identification module 52 identifies the current clause currently input in the document, and determines whether the name of the medical information preset in the medical information mapping table is hit, if yes, the information filling module 53 is executed, and if not, the document identification module 52 is returned.
The information filling module 53 automatically fills the medical information parameter corresponding to the medical information name in the document after the medical information name, generates an update path based on at least the document name and the position of the medical information parameter in the document, and stores the update path into the update path set corresponding to the medical information name.
And a modification judging module 54 for judging whether the filled medical information parameters are modified, if so, executing an authority judging module 55, and if not, returning to the document identifying module 52.
The authority judgment module 55 judges whether the authority of the user account for modification operation satisfies the modification authority corresponding to the medical information name, if so, the mapping update module 56 is executed, and if not, the mapping update module returns to the document identification module 52.
And the mapping updating module 56 is used for updating the medical information parameters corresponding to the medical information names in the medical information mapping table according to the modified medical information parameters. And
and the parameter updating module 57 updates the medical information parameters corresponding to the medical information names in all the documents based on the modified medical information parameters and the updated path set.
In a preferred embodiment, the current clause is all text in the document between the current input cursor position to the previous punctuation mark.
In a preferred embodiment, in the information mapping module 51, in the medical information mapping table, the medical information name, the at least one alternative name, the medical information parameter, and the updated path set based on the plurality of documents establish a mapping relationship.
In the document identification module 52, the current clause currently input in the document is identified, whether a medical information name preset in the medical information mapping table or an alternative name having a mapping relationship with the medical information name is hit is judged, if yes, the information filling module 53 is executed, and if not, the information is returned to the document identification module 52.
In a preferred embodiment, in the information mapping module 51, in the medical information mapping table, the medical information name, the modification authority, the medical information parameter, and the updated path set based on several documents establish a mapping relationship.
In a preferred embodiment, the modification judging module 54 judges whether the filled medical information parameter is modified, if so, a confirmation box is generated based on the position of the medical information parameter in the document, and the confirmation box includes the data before the medical information parameter is modified and the data after the medical information parameter is modified, so that the user account can click and confirm; if not, return to document identification module 52. And generating a confirmation box based on the position of the medical information parameter in the document, wherein the confirmation box comprises the data before the medical information parameter is modified and the data after the medical information parameter is modified, and the data is used for the user account to click and confirm. And judging whether the confirmation operation of the user account is received within the preset time, if so, executing the mapping updating module 56, and if not, returning to the document identification module 52.
In a preferred embodiment, in the parameter updating module 57, by determining whether each document in the update path set is online, if yes, updating the medical information parameters corresponding to the medical information names in all the online documents, and ending; and if not, respectively generating an updating task for each offline document, and adding the updating task into an updating task queue, wherein the updating task comprises medical information parameters needing to be updated and related updating paths. And when detecting that the corresponding document in the update task queue is online, triggering the update task, updating the medical information parameter corresponding to the medical information name in the document, and ending.
In a preferred embodiment, each pair of a medical information name and a medical information parameter in the document forms an XML component.
In a preferred embodiment, the medical information parameters in the medical information mapping table are SQL object types corresponding to the medical information parameters in XML components in the document.
The medical information and database mapping system can be used for structurally modifying medical information and automatically and uniformly updating medical information names with all parameters modified, simplifies the data synchronization step and improves the efficiency of updating structural document data.
The embodiment of the invention also provides equipment for mapping the medical information and the database, which comprises a processor. A memory having stored therein executable instructions of the processor. Wherein the processor is configured to perform the steps of the method of medical information to database mapping via execution of executable instructions.
As shown above, the system for mapping medical information and database according to the embodiment of the present invention can perform structured modification of medical information, and automatically implement unified update of medical information names with all parameters modified, thereby simplifying the steps of data synchronization and improving the efficiency of structured document data update.
As will be appreciated by one skilled in the art, aspects of the present invention may be embodied as a system, method or program product. Thus, various aspects of the invention may be embodied in the form of: an entirely hardware embodiment, an entirely software embodiment (including firmware, microcode, etc.) or an embodiment combining hardware and software aspects that may all generally be referred to herein as a "circuit," module "or" platform.
Fig. 8 is a schematic diagram of the structure of the medical information and database mapping apparatus of the present invention. An electronic device 600 according to this embodiment of the invention is described below with reference to fig. 8. The electronic device 600 shown in fig. 8 is only an example, and should not bring any limitation to the functions and the scope of use of the embodiments of the present invention.
As shown in fig. 8, the electronic device 600 is embodied in the form of a general purpose computing device. The components of the electronic device 600 may include, but are not limited to: at least one processing unit 610, at least one memory unit 620, a bus 630 connecting the different platform components (including the memory unit 620 and the processing unit 610), a display unit 640, etc.
Wherein the storage unit stores program code executable by the processing unit 610 to cause the processing unit 610 to perform steps according to various exemplary embodiments of the present invention described in the above-mentioned electronic prescription flow processing method section of the present specification. For example, processing unit 610 may perform the steps as shown in fig. 1.
The storage unit 620 may include readable media in the form of volatile memory units, such as a random access memory unit (RAM)6201 and/or a cache memory unit 6202, and may further include a read-only memory unit (ROM) 6203.
The memory unit 620 may also include a program/utility 6204 having a set (at least one) of program modules 6205, such program modules 6205 including, but not limited to: an operating system, one or more application programs, other program modules, and program data, each of which, or some combination thereof, may comprise an implementation of a network environment.
The electronic device 600 may also communicate with one or more external devices 700 (e.g., keyboard, pointing device, bluetooth device, etc.), with one or more devices that enable a user to interact with the electronic device 600, and/or with any devices (e.g., router, modem, etc.) that enable the electronic device 600 to communicate with one or more other computing devices. Such communication may occur via an input/output (I/O) interface 650. Also, the electronic device 600 may communicate with one or more networks (e.g., a Local Area Network (LAN), a Wide Area Network (WAN), and/or a public network such as the Internet) via the network adapter 660. The network adapter 660 may communicate with other modules of the electronic device 600 via the bus 630. It should be appreciated that although not shown in the figures, other hardware and/or software modules may be used in conjunction with the electronic device 600, including but not limited to: microcode, device drivers, redundant processing units, external disk drive arrays, RAID systems, tape drives, and data backup storage platforms, to name a few.
Embodiments of the present invention also provide a computer-readable storage medium for storing a program, and the steps of the method for mapping medical information and a database implemented when the program is executed. In some possible embodiments, the aspects of the present invention may also be implemented in the form of a program product comprising program code for causing a terminal device to perform the steps according to various exemplary embodiments of the present invention described in the above-mentioned electronic prescription flow processing method section of this specification, when the program product is run on the terminal device.
As shown above, the system for mapping medical information and database according to the embodiment of the present invention can perform structured modification of medical information, and automatically implement unified update of medical information names with all parameters modified, thereby simplifying the steps of data synchronization and improving the efficiency of structured document data update.
Fig. 9 is a schematic structural diagram of a computer-readable storage medium of the present invention. Referring to fig. 9, a program product 800 for implementing the above method according to an embodiment of the present invention is described, which may employ a portable compact disc read only memory (CD-ROM) and include program code, and may be run on a terminal device, such as a personal computer. However, the program product of the present invention is not limited in this regard and, in the present document, a readable storage medium may be any tangible medium that can contain, or store a program for use by or in connection with an instruction execution system, apparatus, or device.
The program product may employ any combination of one or more readable media. The readable medium may be a readable signal medium or a readable storage medium. A readable storage medium may be, for example, but not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any combination of the foregoing. More specific examples (a non-exhaustive list) of the readable storage medium include: an electrical connection having one or more wires, a portable disk, a hard disk, a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing.
A computer readable storage medium may include a propagated data signal with readable program code embodied therein, for example, in baseband or as part of a carrier wave. Such a propagated data signal may take many forms, including, but not limited to, electro-magnetic, optical, or any suitable combination thereof. A readable storage medium may also be any readable medium that is not a readable storage medium and that can communicate, propagate, or transport a program for use by or in connection with an instruction execution system, apparatus, or device. Program code embodied on a readable storage medium may be transmitted using any appropriate medium, including but not limited to wireless, wireline, optical fiber cable, RF, etc., or any suitable combination of the foregoing.
Program code for carrying out operations for aspects of the present invention may be written in any combination of one or more programming languages, including an object oriented programming language such as Java, C + + or the like and conventional procedural programming languages, such as the "C" programming language or similar programming languages. The program code may execute entirely on the user's computing device, partly on the user's device, as a stand-alone software package, partly on the user's computing device and partly on a remote computing device, or entirely on the remote computing device or server. In the case of a remote computing device, the remote computing device may be connected to the user computing device through any kind of network, including a Local Area Network (LAN) or a Wide Area Network (WAN), or may be connected to an external computing device (e.g., through the internet using an internet service provider).
In summary, the present invention is directed to a method, a system, a device, and a storage medium for mapping medical information with a database, which can modify the medical information in a structured manner, and automatically implement unified update of medical information names with all parameters modified, thereby simplifying the steps of data synchronization and improving the efficiency of updating structured document data.
The foregoing is a more detailed description of the invention in connection with specific preferred embodiments and it is not intended that the invention be limited to these specific details. For those skilled in the art to which the invention pertains, several simple deductions or substitutions can be made without departing from the spirit of the invention, and all shall be considered as belonging to the protection scope of the invention.
Claims (10)
1. A method of mapping medical information to a database, comprising the steps of:
s110, presetting a medical information mapping table, wherein a plurality of medical information names are prestored in the medical information mapping table, and each medical information name corresponds to at least one medical information parameter and an update path set based on a plurality of documents;
s120, identifying the currently input current clause in the document, judging whether the name of the medical information preset in the medical information mapping table is hit, if so, executing the step S130, otherwise, returning to the step S120;
s130, automatically filling medical information parameters corresponding to the medical information names in the documents after the medical information names are filled, generating an updating path at least based on the document names and the positions of the medical information parameters in the documents, and storing the updating path into an updating path set corresponding to the medical information names;
s140, judging whether the medical information parameters are modified after filling, if so, executing a step S160, otherwise, returning to the step S120;
s160, updating the modified medical information parameter to a medical information parameter corresponding to the medical information name in the medical information mapping table; and
s170, updating the medical information parameters corresponding to the medical information names in all the documents based on the modified medical information parameters and the updated path set.
2. The method for mapping medical information to a database according to claim 1, wherein in the step S110, in the medical information mapping table, the medical information name, at least one alternative name, medical information parameters, and an updated path set based on a plurality of documents establish a mapping relationship;
in the step S120, the current clause currently input in the document is identified, and whether the name of the medical information preset in the medical information mapping table or the alternative name having a mapping relationship with the medical information name is hit is determined, if yes, the step S130 is executed, and if not, the step S120 is returned to.
3. The method for mapping medical information to database according to claim 1, wherein in the step S110, in the medical information mapping table, the medical information name, the modification authority, the medical information parameter and the updated path set based on a plurality of documents establish a mapping relationship;
after step S140 and before step S160, the method further includes:
step S150, determining whether the authority of the user account performing the modification operation satisfies the modification authority corresponding to the medical information name, if so, executing step S160, otherwise, returning to step S120.
4. The method for mapping medical information to a database according to claim 3, wherein the step S140 comprises:
s141, judging whether the medical information parameters are modified after filling, if so, executing a step S142, and if not, returning to the step S120;
s142, generating a confirmation box based on the position of the medical information parameter in the document, wherein the confirmation box comprises the data before the medical information parameter is modified and the data after the medical information parameter is modified, and the data is used for clicking confirmation of the user account;
and S143, judging whether the user account is confirmed within the preset time, if so, executing the step S160, otherwise, returning to the step S120.
5. The method for mapping medical information to a database as claimed in claim 1, wherein the step S170 comprises:
s171, judging whether each document in the updating path set is online, if so, executing a step S172, and if not, executing a step S173;
s172, updating medical information parameters corresponding to the medical information names in all the documents on line, and ending;
s173, respectively generating an updating task for each offline document, and adding the updating task into the updating task queue, wherein the updating task comprises medical information parameters needing to be updated and related updating paths;
and S174, when the fact that the corresponding document in the update task queue is online is detected, triggering the update task, updating the medical information parameter corresponding to the medical information name in the document, and ending.
6. The method of medical information to database mapping according to claim 1, wherein each pair of the medical information name and medical information parameter in the document forms an XML component.
7. The method of medical information to database mapping according to claim 6, wherein the medical information parameters in the medical information mapping table are SQL object types corresponding to the medical information parameters in the XML component in the document.
8. A system for medical information and database mapping, for implementing the method of medical information and database mapping of claim 1, comprising:
the information mapping module is used for presetting a medical information mapping table, wherein a plurality of medical information names are prestored in the medical information mapping table, and each medical information name corresponds to at least one medical information parameter and an updating path set based on a plurality of documents;
the document identification module is used for identifying the current clause currently input in the document and judging whether the name of the medical information preset in the medical information mapping table is hit or not, if yes, the information filling module is executed, and if not, the information is returned to the document identification module;
the information filling module is used for automatically filling medical information parameters corresponding to the medical information names in the documents after the medical information names are filled in the documents, generating an updating path at least based on the document names and the positions of the medical information parameters in the documents, and storing the updating path into an updating path set corresponding to the medical information names;
the modification judgment module is used for judging whether the medical information parameters are modified after filling, if so, the mapping updating module is executed, and if not, the mapping updating module returns to the document identification module;
the mapping updating module is used for updating the medical information parameters corresponding to the medical information names in the medical information mapping table according to the modified medical information parameters; and
and the parameter updating module is used for updating the medical information parameters corresponding to the medical information names in all the documents based on the modified medical information parameters and the updated path set.
9. An apparatus for mapping medical information to a database, comprising:
a processor;
a memory having stored therein executable instructions of the processor;
wherein the processor is configured to perform the steps of the method of medical information to database mapping of any of claims 1 to 7 via execution of the executable instructions.
10. A computer-readable storage medium storing a program which, when executed by a processor, performs the steps of the method of mapping medical information to a database of any one of claims 1 to 7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110914352.8A CN113590883A (en) | 2021-08-10 | 2021-08-10 | Method, system, device and storage medium for mapping medical information and database |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110914352.8A CN113590883A (en) | 2021-08-10 | 2021-08-10 | Method, system, device and storage medium for mapping medical information and database |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN113590883A true CN113590883A (en) | 2021-11-02 |
Family
ID=78257111
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202110914352.8A Pending CN113590883A (en) | 2021-08-10 | 2021-08-10 | Method, system, device and storage medium for mapping medical information and database |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN113590883A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN117272953A (en) * | 2023-11-15 | 2023-12-22 | 明度智云(浙江)科技有限公司 | Automatic document information filling method, system and storage medium |
Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1705934A (en) * | 2002-10-17 | 2005-12-07 | 松下电器产业株式会社 | File-update apparatus |
| WO2013049854A1 (en) * | 2011-09-29 | 2013-04-04 | Eclinicalworks, Llc | Systems and methods for generating and updating electronic medical records |
| CN107357772A (en) * | 2017-07-04 | 2017-11-17 | 贵州小爱机器人科技有限公司 | List filling method, device and computer equipment |
| CN107798038A (en) * | 2017-05-05 | 2018-03-13 | 平安科技（深圳）有限公司 | Data response method and data response apparatus |
| CN109871705A (en) * | 2017-12-01 | 2019-06-11 | 中国移动通信集团广东有限公司 | A kind of database update method and system |
| CN110851413A (en) * | 2019-11-08 | 2020-02-28 | 深圳市元征科技股份有限公司 | Data synchronization method and device, electronic equipment and storage medium |
| CN112269690A (en) * | 2020-11-17 | 2021-01-26 | 珠海大横琴科技发展有限公司 | Data backup method and device |
-
2021
- 2021-08-10 CN CN202110914352.8A patent/CN113590883A/en active Pending
Patent Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1705934A (en) * | 2002-10-17 | 2005-12-07 | 松下电器产业株式会社 | File-update apparatus |
| WO2013049854A1 (en) * | 2011-09-29 | 2013-04-04 | Eclinicalworks, Llc | Systems and methods for generating and updating electronic medical records |
| CN107798038A (en) * | 2017-05-05 | 2018-03-13 | 平安科技（深圳）有限公司 | Data response method and data response apparatus |
| CN107357772A (en) * | 2017-07-04 | 2017-11-17 | 贵州小爱机器人科技有限公司 | List filling method, device and computer equipment |
| CN109871705A (en) * | 2017-12-01 | 2019-06-11 | 中国移动通信集团广东有限公司 | A kind of database update method and system |
| CN110851413A (en) * | 2019-11-08 | 2020-02-28 | 深圳市元征科技股份有限公司 | Data synchronization method and device, electronic equipment and storage medium |
| CN112269690A (en) * | 2020-11-17 | 2021-01-26 | 珠海大横琴科技发展有限公司 | Data backup method and device |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN117272953A (en) * | 2023-11-15 | 2023-12-22 | 明度智云(浙江)科技有限公司 | Automatic document information filling method, system and storage medium |
| CN117272953B (en) * | 2023-11-15 | 2024-03-12 | 明度智云(浙江)科技有限公司 | Automatic document information filling method, system and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US8667456B1 (en) | Cloud-based indexing for integrated development environments | |
| JP6033235B2 (en) | Formatting data by example | |
| EP3654201A1 (en) | Spark query method and system supporting trusted computing | |
| US20150222731A1 (en) | Computer, guide information providing method and recording medium | |
| US7500221B2 (en) | Filter-based comments in source code | |
| US9619449B2 (en) | Compact encoding of node locations | |
| US9201761B1 (en) | Debugging data format conversion | |
| CN112395843B (en) | PHP code-based service processing method, device and medium | |
| CN113158101A (en) | Visual page rendering method, device, equipment and storage medium | |
| CN115599386A (en) | Code generation method, device, equipment and storage medium | |
| CN113590883A (en) | Method, system, device and storage medium for mapping medical information and database | |
| US9495638B2 (en) | Scalable, rule-based processing | |
| CN108959454B (en) | Prompting clause specifying method, device, equipment and storage medium | |
| CN113885876A (en) | Parameter checking method, device, storage medium and computer system | |
| CN109284452A (en) | The online methods of exhibiting of electronic protocol, device, electronic equipment, storage medium | |
| CN112799760A (en) | Form rendering method and device | |
| CN112784588A (en) | Method, device, equipment and storage medium for marking text | |
| CN109684207B (en) | Method and device for packaging operation sequence, electronic equipment and storage medium | |
| CN111796833A (en) | Code language conversion method, system, equipment and storage medium | |
| CN113687827B (en) | Data list generation method, device and equipment based on widget and storage medium | |
| US20150339293A1 (en) | Document translation based on predictive use | |
| CN111447268B (en) | File structure conversion method, device, equipment and storage medium | |
| CN114547106A (en) | Data query method and device, storage medium and computer system | |
| CN108182628A (en) | Method, system, equipment and the storage medium that tourism places an order | |
| CN113591772B (en) | Method, system, equipment and storage medium for structured identification and input of medical information |
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 |