Disclosure of Invention
In order to solve the technical problems, the invention provides a medical record structured storage method and a medical record structured storage device, which can be used in a data storage server of an Internet hospital, can occupy less storage resources, has high query speed, and is convenient for an Internet doctor to analyze and check medical record data of a patient.
The invention provides the following technical scheme:
in one aspect, an embodiment of the present invention provides a method for storing medical records in a structured manner, including the following steps:
acquiring a check list, and extracting basic information and all check item information on the check list; the basic information comprises hospital information, patient information, examination list names, examination time and sample types; the all inspection item information comprises an inspection item name, inspection data and a data unit;
searching a corresponding inspection sheet template according to the basic information and all the inspection item information, and calling out the inspection sheet template if the inspection sheet template corresponding to the basic information and all the inspection item information exists; if not, creating a check list template corresponding to the basic information and all check item information, generating a check list template ID number corresponding to the check list template, and storing the check list template; the inspection sheet template comprises an information template and an integral inspection item template, wherein the input frames of the information template are in one-to-one correspondence with the basic information, and the input frames of the integral inspection item template are in one-to-one correspondence with the integral inspection item information;
and respectively storing the basic information and all the inspection item information into a database through the input frame of the information template and the input frame of the whole inspection item template.
The medical record structured storage method preferably creates an inspection sheet template corresponding to the basic information and all inspection item information, and includes:
searching a corresponding information template according to the basic information;
if the information template corresponding to the basic information exists, calling the information template; if the basic information does not exist, an information template corresponding to the basic information is created, and the created information template is stored;
searching a corresponding overall inspection item template according to the all inspection item information;
if the integral inspection item template corresponding to the whole inspection item information exists, calling the integral inspection item template; if not, creating an integral inspection item template corresponding to the whole inspection item information, and storing the created integral inspection item template;
and combining the information template and the whole inspection item template into an inspection sheet template.
The medical record structured storage method preferably creates an overall examination item template corresponding to the whole examination item information, including:
splitting the entire inspection item information into individual inspection item information;
searching corresponding independent inspection item templates according to the independent inspection item information;
if each piece of individual examination item information in the all pieces of examination item information has a corresponding individual examination item template, respectively calling the individual examination item templates respectively corresponding to the individual examination item information in the all pieces of examination item information;
and combining the individual examination item templates corresponding to the individual examination information items in the whole examination item information into an integral examination item template.
Further, the creating an overall inspection item template corresponding to the entire inspection item information further includes:
separating individual examination item information for which no corresponding individual examination item template exists from individual examination item information for which a corresponding individual examination item template exists if at least one individual examination item information among the entire examination item information does not exist;
respectively calling the individual inspection item templates corresponding to the individual inspection item information of the corresponding individual inspection item templates according to the individual inspection item information of the corresponding individual inspection item templates;
according to the individual inspection item information of the individual inspection item template without the correspondence, an individual inspection item template corresponding to the individual inspection item information of the individual inspection item template without the correspondence is created, and the created individual inspection item template is saved.
Preferably, the total inspection item information further includes: name shorthand, normal range value, check result.
In another aspect, an embodiment of the present invention further provides a medical record structured storage apparatus, which includes:
the acquisition module is used for acquiring the inspection list and extracting basic information and all inspection item information on the inspection list; the basic information comprises hospital information, patient information, examination list names, examination time and sample types; the all inspection item information comprises an inspection item name, inspection data and a data unit;
the searching module is used for searching the corresponding inspection sheet template according to the basic information and all the inspection item information, and calling out the inspection sheet template if the inspection sheet template corresponding to the basic information and all the inspection item information exists; if not, creating a check list template corresponding to the basic information and all check item information, generating a check list template ID number corresponding to the check list template, and storing the check list template; the inspection sheet template comprises an information template and an integral inspection item template, wherein the input frames of the information template are in one-to-one correspondence with the basic information, and the input frames of the integral inspection item template are in one-to-one correspondence with the integral inspection item information;
and the storage module is used for respectively storing the basic information and all the inspection item information into a database through the input frame of the information template and the input frame of the whole inspection item template.
The medical record structured storage device, preferably, the searching module includes:
the first searching unit is used for searching a corresponding information template according to the basic information;
the first calling unit is used for calling the information template corresponding to the basic information if the information template exists; if the basic information does not exist, an information template corresponding to the basic information is created, and the created information template is stored;
the second searching unit is used for searching the corresponding overall inspection item template according to the whole inspection item information;
a second retrieving unit, configured to retrieve an entire inspection item template corresponding to the entire inspection item information if the entire inspection item template exists; if not, creating an integral inspection item template corresponding to the whole inspection item information, and storing the created integral inspection item template;
and the merging unit is used for merging the information template and the whole inspection item template into an inspection single template.
The medical record structured storage device, preferably, the second retrieving unit includes:
a splitting subunit, configured to split the entire inspection item information into individual inspection item information;
the searching subunit is used for searching the corresponding independent inspection item templates according to the independent inspection item information;
a calling subunit, configured to, if each individual inspection item information in the all inspection item information has a corresponding individual inspection item template, respectively call the individual inspection item templates corresponding to the individual inspection item information in the all inspection items respectively;
and the merging subunit is used for merging the individual inspection item templates corresponding to the individual inspection information items in the whole inspection item information into an integral inspection item template.
Further, the second call unit further includes:
a separation subunit for separating the individual inspection item information for which no corresponding individual inspection item template exists from the individual inspection item information for which a corresponding individual inspection item template exists if at least one individual inspection item information for which no corresponding individual inspection item template exists in the total inspection item information;
the invoking subunit is further configured to invoke, according to the individual inspection item information of the individual inspection item template corresponding to the existence of the individual inspection item template, the individual inspection item templates corresponding to the individual inspection item information of the individual inspection item template corresponding to the existence of the individual inspection item template;
a creation subunit for creating, based on the individual inspection item information for which there is no corresponding individual inspection item template, an individual inspection item template corresponding to the individual inspection item information for which there is no corresponding individual inspection item template, and saving the created individual inspection item template.
Preferably, the total inspection item information further includes: name shorthand, normal range value, check result.
The medical record structured storage method of the embodiment of the invention can be used for a server side, and particularly can be used for a data storage server of an Internet hospital. The method can store the same type of inspection sheets into the database through the same inspection sheet template structure, and compared with the prior art that the inspection sheets are directly stored in the form of pictures, the embodiment of the invention can occupy less storage resources and has higher query speed; especially when internet doctors need to compare and analyze the examination sheets of the same type, all examination sheets using the examination sheet templates can be directly called according to the ID numbers on the examination sheet templates for analysis and viewing by the internet doctors.
Detailed Description
The following description of the embodiments of the present invention will be made more apparent and fully hereinafter with reference to the accompanying drawings, in which some, but not all embodiments of the invention are shown. All other embodiments, which can be made by those skilled in the art based on the embodiments of the invention without making any inventive effort, are intended to be within the scope of the invention.
The "first" and "second" in the embodiments of the present invention are only referred to as distinguishing, and are set for convenience of understanding, and are not limited in any way.
A method of structured storage of medical records as shown in fig. 1, comprising the steps of:
s101: acquiring a check list, and extracting basic information and all check item information on the check list; the basic information comprises hospital information, patient information, examination list names, examination time and sample types; the whole examination item information comprises an examination item name, examination data and a data unit.
The checklist may be in the form of a picture or document. The hospital information may include a hospital name, a hospital ID number (identification number for distinguishing different hospitals), etc., and the patient information may include information of a patient name, sex, identification number, age, etc. The examination order is obtained, typically from the corresponding hospital. The basic information and all the inspection item information on the inspection sheet can be extracted by a scanning method, and the text recognition is performed.
S102: searching a corresponding inspection sheet template according to the basic information and all the inspection item information, and calling out the inspection sheet template if the inspection sheet template corresponding to the basic information and all the inspection item information exists; if not, creating a check list template corresponding to the basic information and all check item information, generating a check list template ID number corresponding to the check list template, and storing the check list template; the inspection sheet template comprises an information template and an integral inspection item template, wherein the input frames of the information template are in one-to-one correspondence with the basic information, and the input frames of the integral inspection item template are in one-to-one correspondence with the integral inspection item information.
And searching a corresponding inspection sheet template according to the basic information and all the inspection item information, specifically searching a corresponding inspection template according to the basic item names of the basic information, all the inspection items of the inspection item information and auxiliary item names corresponding to the inspection items. For example: basic information of the check list: hospital name: guiyang first hospital, hospital ID number: 11107 patient name: pony, patient identification number: XXXX, check sheet name: blood routine, examination time: 2016 8 month 25 days, sample type: whole blood.
All the inspection item information of the inspection sheet includes (as in table 1):
TABLE 1
The basic item name in the examination list is as follows: hospital name, hospital ID number, patient name, patient identification number, checklist name, time of examination, sample type, the checklist item is: platelet distribution width, platelet volume, platelet average volume, platelet count, red blood cell volume distribution width, red blood cell volume, auxiliary term name corresponding to test term: check item name, name shorthand, check data, data unit.
The creation of the inspection sheet template corresponding to the basic information and all the inspection item information is carried out according to the basic item names of the basic information, the inspection items of all the inspection item information and the auxiliary item names corresponding to the inspection items.
The inspection sheet template ID numbers are identification information for distinguishing different inspection sheet templates, and each inspection sheet template has a unique ID number.
The step of storing the inspection sheet template refers to storing the newly-built inspection sheet template in a database in the form of a data structure, and is usually stored and managed through a relational database. The checklist templates in the database are maintained in a structured manner, and the checklists stored in the database are also typically maintained in a structured manner.
The input boxes of the information templates are in one-to-one correspondence with the basic information, namely the number of the basic information is the same as that of the input boxes of the information templates, and different basic information can only be input into the corresponding input boxes.
The input frames of the whole inspection item template are in one-to-one correspondence with all the inspection item information, namely the number of the all the inspection item information is the same as the number of the input frames of the whole inspection item template, and different inspection item information can only be input into the corresponding input frames.
The same type of checklist may use the same checklist template. The same type of checklist refers to a checklist in which the basic item names of the basic information and the checklist items of all the checklist item information are the same as the auxiliary item names corresponding to the checklist items. Such as:
the basic information on the first checklist includes: hospital name: guiyang, sixth Hospital, hospital ID number: 11112, patient name: king, sex: male, native place: guizhou Guiyang, check list name: blood routine, examination time: sample type 10 month 26 2016: whole blood.
All of the inspection item information of the first inspection sheet includes (as in table 2):
TABLE 2
The basic information on the second checklist includes: hospital name: guiyang, sixth Hospital, hospital ID number: 11112, patient name: xiao Li, sex: female, native place: guizhou Guiyang, check list name: blood routine, examination time: sample type at 2015, 9, 28 days: whole blood.
All of the inspection item information of the second inspection sheet includes (as in table 3):
TABLE 3 Table 3
The basic information on the third checklist includes: hospital name: guiyang second hospital, hospital ID number: 11108 patient name: xiao Dong, sex: female, native place: guizhou Guiyang, patient identification number: XXXX, check sheet name: blood routine, examination time: 28 days of 2017, 1 month, sample type: whole blood, examining doctor: zhang Mou.
All the inspection item information of the third inspection sheet includes (as in table 4):
TABLE 4 Table 4
The basic information on the fourth checklist includes: hospital name: guiyang second hospital, hospital ID number: 11108 patient name: small sheet, sex: female, native place: guizhou Guiyang, ID card number: XXXX, check sheet name: blood biochemistry, examination time: 25 days 5.2017, sample type: whole blood, examining doctor: li Mou.
All the inspection item information of the fourth inspection sheet includes (as in table 5):
TABLE 5
The basic information on the fifth checklist includes: hospital name: guiyang, sixth Hospital, hospital ID number: 11112, patient name: pony, sex: male, native place: guizhou Guiyang, check list name: blood biochemistry, examination time: 10.26 2017, sample type: whole blood.
All the inspection item information of the fifth inspection sheet includes (as in table 6):
TABLE 6
In the above-described inspection sheet: the basic item names, the checking items and the auxiliary item names corresponding to the checking items of the first checking sheet and the second checking sheet are the same, namely, the basic item names, the checking items and the auxiliary item names are respectively: hospital name, hospital ID number, patient name, gender, native site, exam sheet name, exam time, sample type, platelet distribution width, platelet volume, platelet average volume, platelet count, red blood cell volume distribution width, red blood cell volume, exam item name, name shorthand, exam data, data unit. So the first inspection sheet and the second inspection sheet are the same inspection sheet, and the same inspection sheet template can be used. The basic items required in the third checklist are more than in the first checklist: the patient identification card number and the examining doctor, therefore, the examination sheet and the first examination sheet do not belong to the same examination sheet, and the same examination sheet template cannot be used. The basic item names required in the fourth checklist are more than those in the first checklist: patient identification number, examining doctor, and auxiliary item names corresponding to examination items are also increased: the normal range and the inspection result are different, and the inspection items are not the same class of inspection sheets as the first inspection sheet, so that the same inspection sheet template cannot be used. Auxiliary item names corresponding to the inspection items of the fourth inspection sheet are more than those in the third inspection sheet: the normal range and the inspection result, and the inspection items are not the same, so the same inspection sheet template cannot be used as the third inspection sheet does not belong to the same class of inspection sheets. The fifth inspection sheet is different from the first inspection sheet in terms of inspection items, and therefore, the fifth inspection sheet does not belong to the same type of inspection sheet as the first inspection sheet, and the same inspection sheet template cannot be used. The fifth inspection sheet is more in the basic item names required in the third inspection sheet than in the third inspection sheet: the patient identification card number and the examination doctor have different examination items, so that the patient identification card number and the examination doctor do not belong to the same examination sheet and cannot use the same examination sheet template. The fifth inspection sheet is compared with the fourth inspection sheet, and the required basic item names in the fourth inspection sheet are more than those in the fifth inspection sheet: patient identification number, examining doctor, auxiliary item names corresponding to examination items of the fourth examination sheet are more than those of the fifth examination sheet: the normal range and the inspection result are not the same class of inspection sheets, and therefore the same inspection sheet template cannot be used.
S103: and respectively storing the basic information and all the inspection item information into a database through the input frame of the information template and the input frame of the whole inspection item template.
The basic information and all the inspection item information on the inspection sheet are input and stored in a database through the input frame of the information template and the input frame of the whole inspection item template, which can be specifically manually input or automatically input by a system.
The medical record structured storage method of the embodiment of the invention can be used for a server side, and particularly can be used for a data storage server of an Internet hospital. The method can store the same type of inspection sheets into the database through the same inspection sheet template structure, and compared with the prior art that the inspection sheets are directly stored in the form of pictures, the embodiment of the invention can occupy less storage resources and has higher query speed; especially when the internet doctor needs to compare and analyze the examination sheets of the same type, all examination sheets using the examination sheet template can be directly called according to the ID number on the examination sheet template, and the examination sheets are used for the internet doctor to analyze and view corresponding data.
Based on the medical record structured storage method shown in fig. 1, as shown in fig. 2, the creating of the examination sheet template corresponding to the basic information and all examination item information includes:
s201: and searching a corresponding information template according to the basic information.
The corresponding information template can be searched according to the basic item name of the basic information. Such as: the basic item names in the check list are as follows: the hospital name, the hospital ID number, the patient name, the patient identification card number, the examination order name, the examination time and the sample type can be extracted, and then the basic item names are compared with the information templates in the database one by one.
S202: if the information template corresponding to the basic information exists, calling the information template; if not, an information template corresponding to the basic information is created, and the created information template is stored.
And creating an information template corresponding to the basic information according to the basic item name of the basic information, and enabling the input frame of the newly created information template to be in one-to-one correspondence with the basic information.
S203: and searching a corresponding overall inspection item template according to the whole inspection item information.
Specifically, the corresponding whole inspection item template can be searched according to the inspection items of all the inspection item information and the auxiliary item names corresponding to the inspection items.
S204: if the integral inspection item template corresponding to the whole inspection item information exists, calling the integral inspection item template; if not, creating an integral inspection item template corresponding to the whole inspection item information, and storing the created integral inspection item template.
And creating an integral inspection item template corresponding to the all inspection item information according to the inspection items of the all inspection item information and auxiliary item names corresponding to the inspection items, and enabling an input frame of the newly created integral inspection item template to be in one-to-one correspondence with the all inspection item information.
S205: and combining the information template and the whole inspection item template into an inspection sheet template.
According to the embodiment of the invention, the information template and the integral inspection item template are searched respectively, and if the corresponding information template and the integral inspection item template exist in the database, the information template and the integral inspection item template are not required to be created and are directly combined; if not, creating respectively. The creation speed is increased, and the newly created templates can be directly called for use later.
Based on the medical record structured storage method shown in fig. 2, the creating an overall examination item template corresponding to the all examination item information includes:
s301: splitting the entire inspection item information into individual inspection item information;
s302: searching corresponding independent inspection item templates according to the independent inspection item information;
s303: if each piece of individual examination item information in the all pieces of examination item information has a corresponding individual examination item template, respectively calling the individual examination item templates respectively corresponding to the individual examination item information in the all pieces of examination item information;
s304: and combining the individual examination item templates corresponding to the individual examination information items in the whole examination item information into an integral examination item template.
In the embodiment of the invention, by searching the independent inspection item templates respectively, if the corresponding independent inspection item templates exist in the database, the independent inspection item templates are directly combined into the integral inspection item templates without creating, thereby increasing the creation speed.
Further, the creating an overall inspection item template corresponding to the entire inspection item information further includes:
s305: separating individual examination item information for which no corresponding individual examination item template exists from individual examination item information for which a corresponding individual examination item template exists if at least one individual examination item information among the entire examination item information does not exist;
s306: respectively calling the individual inspection item templates corresponding to the individual inspection item information of the corresponding individual inspection item templates according to the individual inspection item information of the corresponding individual inspection item templates;
s307: according to the individual inspection item information of the individual inspection item template without the correspondence, an individual inspection item template corresponding to the individual inspection item information of the individual inspection item template without the correspondence is created, and the created individual inspection item template is saved.
In the embodiment of the invention, the templates in the database can be fully utilized, the creation speed is increased, and the created new independent inspection item templates can be directly retrieved for use later by retrieving the independent inspection item templates corresponding to the independent inspection item information of the corresponding independent inspection item templates and creating the independent inspection item templates corresponding to the independent inspection item information of the independent inspection item templates.
Preferably, the total inspection item information further includes: name shorthand, normal range value, check result. Of course, some other information may be included to facilitate the internet doctor's analysis.
A medical record structured store as shown in fig. 3, comprising:
the acquisition module is used for acquiring the inspection list and extracting basic information and all inspection item information on the inspection list; the basic information comprises hospital information, patient information, examination list names, examination time and sample types; the all inspection item information comprises an inspection item name, inspection data and a data unit;
the searching module is used for searching the corresponding inspection sheet template according to the basic information and all the inspection item information, and calling out the inspection sheet template if the inspection sheet template corresponding to the basic information and all the inspection item information exists; if not, creating a check list template corresponding to the basic information and all check item information, generating a check list template ID number corresponding to the check list template, and storing the check list template; the inspection sheet template comprises an information template and an integral inspection item template, wherein the input frames of the information template are in one-to-one correspondence with the basic information, and the input frames of the integral inspection item template are in one-to-one correspondence with the integral inspection item information;
and the storage module is used for respectively and structurally storing the basic information and all the inspection item information into a database through the input frame of the information template and the input frame of the whole inspection item template.
The medical record structured storage device of the embodiment of the invention can be used for realizing the method shown in fig. 1, can be used for a server side, and can be particularly used for a data storage server of an Internet hospital. The device can structurally store the same type of inspection sheets into the database through the same inspection sheet template, and compared with the prior art that the inspection sheets are directly stored in the form of pictures, the embodiment of the invention can occupy less storage resources and has higher query speed; especially when internet doctors need to compare and analyze the examination sheets of the same type, all examination sheets using the examination sheet templates can be directly called according to the ID numbers on the examination sheet templates for analysis and viewing by the internet doctors.
Based on the medical record structured storage apparatus shown in fig. 3, as shown in fig. 4, the searching module includes:
the first searching unit is used for searching a corresponding information template according to the basic information;
the first calling unit is used for calling the information template corresponding to the basic information if the information template exists; if the basic information does not exist, an information template corresponding to the basic information is created, and the created information template is stored;
the second searching unit is used for searching the corresponding overall inspection item template according to the whole inspection item information;
a second retrieving unit, configured to retrieve an entire inspection item template corresponding to the entire inspection item information if the entire inspection item template exists; if not, creating an integral inspection item template corresponding to the whole inspection item information, and storing the created integral inspection item template;
and the merging unit is used for merging the information template and the whole inspection item template into an inspection single template.
Based on the medical record structured storage apparatus shown in fig. 4, as shown in fig. 5, the second retrieving unit includes:
a splitting subunit, configured to split the entire inspection item information into individual inspection item information;
the searching subunit is used for searching the corresponding independent inspection item templates according to the independent inspection item information;
a calling subunit, configured to, if each individual inspection item information in the all inspection item information has a corresponding individual inspection item template, respectively call the individual inspection item templates corresponding to the individual inspection item information in the all inspection items respectively;
and the merging subunit is used for merging the individual inspection item templates corresponding to the individual inspection information items in the whole inspection item information into an integral inspection item template.
Based on the medical record structured storage apparatus shown in fig. 5, as shown in fig. 6, the second retrieval unit further includes:
a separation subunit for separating the individual inspection item information for which no corresponding individual inspection item template exists from the individual inspection item information for which a corresponding individual inspection item template exists if at least one individual inspection item information for which no corresponding individual inspection item template exists in the total inspection item information;
the invoking subunit is further configured to invoke, according to the individual inspection item information of the individual inspection item template corresponding to the existence of the individual inspection item template, the individual inspection item templates corresponding to the individual inspection item information of the individual inspection item template corresponding to the existence of the individual inspection item template;
a creation subunit for creating, based on the individual inspection item information for which there is no corresponding individual inspection item template, an individual inspection item template corresponding to the individual inspection item information for which there is no corresponding individual inspection item template, and saving the created individual inspection item template.
Preferably, the total inspection item information further includes: name shorthand, normal range value, check result.
From the above description of the embodiments, it will be clear to those skilled in the art that the present invention may be implemented by means of software plus necessary general hardware platforms, but of course also by means of hardware, but in many cases the former is a preferred embodiment. Based on such understanding, the technical solution of the present invention may be embodied essentially or in a part contributing to the prior art in the form of a software product stored in a storage medium, comprising several instructions for causing a terminal device (which may be a mobile phone, a personal computer, a server, or a network device, etc.) to perform the method according to the embodiments of the present invention.
Those skilled in the art will appreciate that modules in an apparatus of an embodiment may be distributed in an apparatus of an embodiment as described in the embodiments, and that corresponding changes may be made in one or more apparatuses different from the present embodiment. The modules of the above embodiments may be integrated or may be separately deployed; can be combined into one module or be further split into a plurality of sub-modules.
The foregoing is merely a preferred embodiment of the present invention and it should be noted that modifications and adaptations to those skilled in the art may be made without departing from the principles of the present invention, which is also intended to be covered by the present invention.