CN117851411A - Patient main index generation method and system - Google Patents

Patient main index generation method and system Download PDF

Info

Publication number
CN117851411A
CN117851411A CN202410245953.8A CN202410245953A CN117851411A CN 117851411 A CN117851411 A CN 117851411A CN 202410245953 A CN202410245953 A CN 202410245953A CN 117851411 A CN117851411 A CN 117851411A
Authority
CN
China
Prior art keywords
patient
main index
index number
information
patient information
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Granted
Application number
CN202410245953.8A
Other languages
Chinese (zh)
Other versions
CN117851411B (en
Inventor
李卓群
邓小宁
金剑
匡尚超
高玉乐
李永鑫
于锐信
赵倩
黄福新
华国
李凤荣
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
North Health Medical Big Data Technology Co ltd
Original Assignee
North Health Medical Big Data Technology Co ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by North Health Medical Big Data Technology Co ltd filed Critical North Health Medical Big Data Technology Co ltd
Priority to CN202410245953.8A priority Critical patent/CN117851411B/en
Publication of CN117851411A publication Critical patent/CN117851411A/en
Application granted granted Critical
Publication of CN117851411B publication Critical patent/CN117851411B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Landscapes

  • Medical Treatment And Welfare Office Work (AREA)

Abstract

The invention belongs to the field of medical big data, and particularly provides a patient main index generation method and system, comprising the following steps: constructing a source database; traversing a source database aiming at a preset main index matching rule, and obtaining detection information for each piece of traversed patient information based on the current main index matching rule; judging whether the detected information is empty: if yes, judging the patient information currently traversed, namely judging whether the target patient information has a patient main index number or not, if yes, not processing, and if not, generating the patient main index number for the target patient information and recording the generation time; if not, judging whether the target patient information has the patient main index number: if so, judging whether the detected information contains the patient information with earlier generation time, if so, updating the main index number of the target patient information by using the main index number of the patient with the earliest generation time in the detected information, otherwise, not updating the main index number of the target patient information. The invention is used for improving the integrity and reliability of the information query result of the patient.

Description

Patient main index generation method and system
Technical Field
The invention belongs to the field of medical big data, and particularly relates to a patient main index generation method and system.
Background
In general, systems between medical institutions and in hospitals are operated independently, basic information of patients is repeatedly existed in each medical institution and in the system in the hospital, when one patient performs business processing in a plurality of systems, the system needs to repeatedly input various information of the patient, and data of other systems cannot be known. Only through fuzzy matching can query, the operation efficiency is low, and the satisfaction degree of patients is also low. However, there are cases where information is inconsistent between medical institutions and in systems within hospitals, where patient information cannot be communicated. For example, in an outpatient system, if a review patient is newly presented with a medical record because the patient does not carry a primary medical record, the system may be caused to reassign the outpatient number to the patient. Or when the patient changes the hospital to visit, the new hospital can not see the record of the previous hospital.
The patient information is simply queried after the patient information of all related medical institutions and medical systems in hospitals are simply mixed, so that the following problems can occur: first, data inconsistency: patient information may have inconsistencies in different medical systems and medical institutions, such as name spelling differences, date of birth errors, etc., and query inaccuracy is very easily caused by simple mashup; second, repeat recording: the simple mashup of the obtained information, multiple records in the system may be mistakenly associated to the same patient, or one patient may have multiple different records, which often results in redundancy and confusion of data, resulting in inaccurate queries; third, missing data: if the patient information is incomplete or missing before the mixing, after the simple mixing, the part of the patient information is still incomplete or missing, which can affect the integrity and reliability of the query result. This is a disadvantage of the prior art.
Disclosure of Invention
Aiming at the defects in the prior art, the invention provides a method and a system for generating a main index of a patient so as to solve the technical problems.
In a first aspect, the present invention provides a method for generating a patient primary index, comprising:
s1, collecting patient information of a target database of a target medical institution, and constructing a source database;
s2, traversing each piece of patient information in the source database according to a preset main index matching rule, and executing the following steps for each piece of traversed patient information:
s21, based on the current main index matching rule, detecting each piece of patient information matched with the currently traversed patient information in the source database, and marking the patient information as detected information;
s22, judging whether the detected information is empty:
if yes, judging whether the patient information currently traversed has the patient main index number or not: if the patient main index number exists, the treatment is not performed; if the patient main index number does not exist, generating a patient main index number for the currently traversed patient information and recording the generation time;
if not, judging whether the patient information currently traversed has the patient main index number or not:
if the patient information currently traversed has the patient main index number, judging whether the patient information with the patient main index number earlier than the generation time of the patient main index number of the patient information currently traversed exists in the detected information, if so, updating the patient main index number of the patient information currently traversed by using the patient main index number with the earliest generation time in the detected information, and if not, not updating the patient main index number of the patient information currently traversed;
if the currently traversed patient information does not have the patient main index number, judging whether the patient information with the patient main index number exists in the detected information, if so, using the patient main index number with the earliest generation time in the detected information as the patient main index number of the currently traversed patient information, if not, generating a patient main index number for the currently traversed patient information, and recording the generation time.
Further, step S2 further includes:
when generating a patient main index number for the currently traversed patient information, respectively adding the generated patient main index number and the generation time of the patient main index number into a source database correspondingly;
and when updating the patient main index number of the currently traversed patient information, respectively adding the updated patient main index number and the generation time of the updated patient main index number to the source database correspondingly.
Further, the number of the preset main index matching rules is at least one; different priorities are assigned to different primary index matching rules.
Further, the preset main index matching rule includes:
the first main index matching rule, the second main index matching rule and the third main index matching rule;
the first main index matching rule has a higher priority than the second main index matching rule; the second main index matching rule has a higher priority than the third main index matching rule.
Further, the first main index matching rule, the second main index matching rule and the third main index matching rule are respectively different preset matching fields for matching patient information.
Further, the method further comprises:
periodically collecting each piece of patient information added in the target database into the source database;
each piece of patient information added in the source database is traversed, and step S21 is performed on each piece of patient information traversed.
In a second aspect, the present invention provides a patient primary index generation system, the system comprising:
the database construction module is used for gathering patient information of a target database of the target medical institution and constructing a source database;
the information traversing module is used for traversing each piece of patient information in the source database aiming at a preset main index matching rule;
the information detection module is used for detecting each piece of patient information matched with the currently traversed patient information in the source database based on the current main index matching rule, and recording the detected information as the detected information;
the main index generation module is used for judging whether the detected information is empty or not: if yes, judging whether the patient information currently traversed has the patient main index number or not: if the patient main index number exists, the treatment is not performed; if the patient main index number does not exist, generating a patient main index number for the currently traversed patient information and recording the generation time; if not, judging whether the patient information currently traversed has the patient main index number or not: if the patient information currently traversed has the patient main index number, judging whether the patient information with the patient main index number earlier than the generation time of the patient main index number of the patient information currently traversed exists in the detected information, if so, updating the patient main index number of the patient information currently traversed by using the patient main index number with the earliest generation time in the detected information, and if not, not updating the patient main index number of the patient information currently traversed; if the currently traversed patient information does not have the patient main index number, judging whether the patient information with the patient main index number exists in the detected information, if so, using the patient main index number with the earliest generation time in the detected information as the patient main index number of the currently traversed patient information, if not, generating a patient main index number for the currently traversed patient information, and recording the generation time.
Further, the system further comprises:
the task management module is used for setting a target medical institution and a target database;
the patient information inquiry module is used for inquiring the patient information by using the patient main index number;
and the main index number query module is used for users to query the main index number of the patient by using the keywords.
Further, the system further comprises:
the first module is used for respectively adding the generated patient main index number and the generation time of the patient main index number into the source database when the main index generation module generates the patient main index number for the currently traversed patient information each time;
and the second module is used for respectively adding the updated patient main index number and the generation time of the updated patient main index number to the source database when the main index generation module updates the patient main index number of the currently traversed patient information.
Further, the system further comprises:
the increment module is used for periodically gathering each piece of patient information added in the target database into the source database;
the increment traversing module is used for traversing each piece of patient information added in the source database and calling the main index generating module for each piece of traversed patient information.
The invention has the beneficial effects that:
the method comprises the steps of firstly collecting patient information of a target database of a target medical institution to construct a source database, traversing each piece of patient information in the source database, obtaining detection information based on a preset main index matching rule for each piece of traversed patient information, judging whether the patient information currently traversed has a patient main index number if the detection information is empty, if so, not performing processing, and if not, generating the patient main index number for the patient main index number and recording the generation time of the patient main index number generated for the patient main index number; if the detected information is not empty, judging whether the patient information currently traversed has a patient main index number or not: if so, judging whether the detected information contains the patient information with earlier generation time, if so, updating the patient main index number by using the patient main index number with the earliest generation time, and if not, not updating the patient main index number; if not, judging whether the patient main index number exists in the detected information, if so, using the patient main index number with the earliest generation time as the patient main index number, and if not, generating the patient main index number and recording the generation time. Based on the main index number generated by the invention, the combination of patient information of patients in different medical systems and different medical institutions is facilitated, and then the problem of missed patient information caused by inconsistent, missing and repeated recording of information of patients in different medical systems and different medical institutions is avoided.
According to the invention, each piece of patient information added in the target database of the target medical institution can be collected into the source database at regular intervals, each piece of patient information added in the source database can be traversed, and the related patient main index generation steps are executed on each piece of traversed patient information, so that the combination between the newly added information record in the target database of the target medical institution and the stock data in the source database of the patient is facilitated, the timeliness and the integrity of the updating of the patient information in the source database are facilitated to a certain extent, and the integrity of the subsequent patient information query is facilitated to be ensured.
In addition, the invention has reliable design principle, simple structure and very wide application prospect.
Drawings
In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings that are required to be used in the description of the embodiments or the prior art will be briefly described below, and it will be obvious to those skilled in the art that other drawings can be obtained from these drawings without inventive effort.
FIG. 1 is a schematic flow chart of a method of one embodiment of the invention.
FIG. 2 is a schematic block diagram of a system of one embodiment of the present invention.
Detailed Description
In order to make the technical solution of the present invention better understood by those skilled in the art, the technical solution of the present invention will be clearly and completely described below with reference to the accompanying drawings in the embodiments of the present invention, and it is apparent that the described embodiments are only some embodiments of the present invention, not all embodiments. All other embodiments, which can be made by those skilled in the art based on the embodiments of the present invention without making any inventive effort, shall fall within the scope of the present invention.
Unless defined otherwise, all technical and scientific terms used herein have the same meaning as commonly understood by one of ordinary skill in the art to which this invention belongs. The terminology used herein in the description of the invention is for the purpose of describing particular embodiments only and is not intended to be limiting of the invention.
The patient main index generation method provided by the embodiment of the invention is executed by the computer equipment, and correspondingly, the patient main index system is operated in the computer equipment.
FIG. 1 is a schematic flow chart of a method of one embodiment of the invention. Wherein the execution subject of fig. 1 may be a patient primary index generation system. The order of the steps in the flow chart may be changed and some may be omitted according to different needs.
As shown in fig. 1, the method includes:
collecting patient information of a target database of a target medical institution, and constructing a source database;
traversing each piece of patient information in the source database aiming at a preset main index matching rule, and executing the following steps for each piece of traversed patient information:
based on the current main index matching rule, each piece of patient information matched with the currently traversed patient information in the source database is detected and recorded as detected information;
judging whether the detected information is empty:
if yes, judging whether the patient information currently traversed has the patient main index number or not: if the patient main index number exists, the treatment is not performed; if the patient main index number does not exist, generating a patient main index number for the currently traversed patient information and recording the generation time;
if not, judging whether the patient information currently traversed has the patient main index number or not: if the patient information currently traversed has the patient main index number, judging whether the patient information with the patient main index number earlier than the generation time of the patient main index number of the patient information currently traversed exists in the detected information, if so, updating the patient main index number of the patient information currently traversed by using the patient main index number with the earliest generation time in the detected information, and if not, not updating the patient main index number of the patient information currently traversed; if the currently traversed patient information does not have the patient main index number, judging whether the patient information with the patient main index number exists in the detected information, if so, using the patient main index number with the earliest generation time in the detected information as the patient main index number of the currently traversed patient information, if not, generating a patient main index number for the currently traversed patient information, and recording the generation time.
In order to facilitate understanding of the present invention, the principle of the patient primary index generation method of the present invention is used in conjunction with the procedure of the patient primary index in the embodiment, and the patient primary index generation method provided by the present invention is further described below.
Specifically, the patient main index generation method comprises the following steps:
s1, collecting patient information of a target database of a target medical institution, and constructing a source database.
Each piece of patient information includes:
patient identification number, name, gender, date of birth, phone number, home address, medical facility code of the medical facility where the patient is located, medical facility name, and medical facility original patient ID.
The medical institution's original patient ID, an identification code generated for the patient by the medical institution that is visiting the patient. The patient visits by this code.
Prior to step S1, the method further comprises:
1) Setting a target medical institution. The method specifically comprises the following steps: a medical institution code, a medical institution name, and a medical institution description of the target medical institution are entered.
The target medical institution is a medical institution that needs to collect patient information.
The number of target medical institutions may be one or a plurality. And in particular can be set by those skilled in the art according to the actual circumstances.
2) Setting a target database, and inputting information such as the name, the database type, the IP address, the port number, the connection name, the connection password and the like of the target database.
The target database is a database in the target medical institution where patient information needs to be aggregated.
One or more target databases may be provided for the same target medical facility.
S2, traversing each piece of patient information in the source database according to a preset main index matching rule, and executing the following steps for each piece of traversed patient information:
s21, based on the current main index matching rule, detecting each piece of patient information matched with the currently traversed patient information in the source database, and marking the patient information as detected information;
s22, judging whether the detected information is empty:
if yes, judging whether the patient information currently traversed has the patient main index number or not: if the patient main index number exists, the treatment is not performed; if the patient main index number does not exist, generating a patient main index number for the currently traversed patient information and recording the generation time;
if not, judging whether the patient information currently traversed has the patient main index number or not: if the patient information currently traversed has the patient main index number, judging whether the patient information with the patient main index number earlier than the generation time of the patient main index number of the patient information currently traversed exists in the detected information, if so, updating the patient main index number of the patient information currently traversed by using the patient main index number with the earliest generation time in the detected information, and if not, not updating the patient main index number of the patient information currently traversed; if the currently traversed patient information does not have the patient main index number, judging whether the patient information with the patient main index number exists in the detected information, if so, using the patient main index number with the earliest generation time in the detected information as the patient main index number of the currently traversed patient information, if not, generating a patient main index number for the currently traversed patient information, and recording the generation time.
Specifically, traversal (Traversal) refers to sequentially accessing each piece of patient information along a preset search route.
When generating a patient main index number for the currently traversed patient information, respectively adding the generated patient main index number and the generation time of the patient main index number into a source database correspondingly;
and when updating the patient main index number of the currently traversed patient information, respectively adding the updated patient main index number and the generation time of the updated patient main index number to the source database correspondingly.
The number of the preset main index matching rules is at least one; different priorities are assigned to different primary index matching rules.
The preset main index matching rule comprises the following steps: the first, second and third main index matching rules.
The first main index matching rule has a higher priority than the second main index matching rule; the second main index matching rule has a higher priority than the third main index matching rule.
The first main index matching rule, the second main index matching rule and the third main index matching rule are respectively preset different matching fields for matching patient information.
Optionally, the matching field of the first main index matching rule is an identity card number and a name;
the matching fields of the second main index matching rule are name, birth date, gender and contact phone;
the matching field of the third main index matching rule is the medical facility code and the original patient ID within the medical facility.
Taking the main index matching rule as an example, the step S2 specifically includes:
traversing each piece of patient information in the source database, and executing the following steps for each piece of traversed patient information: based on the first main index matching rule, each piece of patient information matched with the currently traversed patient information in the source database is detected and recorded as detected information, and then step S22 is executed;
traversing each piece of patient information in the source database, and executing the following steps for each piece of traversed patient information: based on the second main index matching rule, each piece of patient information matched with the currently traversed patient information in the source database is detected and recorded as detected information, and then step S22 is executed;
traversing each piece of patient information in the source database, and executing the following steps for each piece of traversed patient information: based on the third main index matching rule, each piece of patient information in the source database, which matches the currently traversed patient information, is detected as detected information, and then step S22 is performed.
Taking the first main index matching rule as an example, detecting patient information matched with the currently traversed patient information in the source database, namely detecting each piece of patient information with the same identification card number and name as those in the currently traversed patient information in the source database.
Illustratively, the method further comprises: and setting matching fields of the first main index matching rule, the second main index matching rule and the third main index matching rule.
In specific implementation, the user can set the matching fields of the first main index matching rule, the second main index matching rule and the third main index matching rule according to actual conditions.
Specifically, the setting of the main index matching rule includes:
setting a main index matching rule, and inputting a priority sequence number and a matching field of the main index matching rule.
It should be noted that, according to the specific usage scenario and requirement of the medical institution, the matching field of the main index matching rule may be set, for example: if a medical institution uses the ID card number and the name to inquire the information of the patient, a main index matching rule can be set, and the matching field of the main index matching rule is the ID card number and the name.
Optionally, the method further comprises:
periodically collecting each piece of patient information added in a target database of a target medical institution into a source database;
each piece of patient information added in the source database is traversed, and step S21 is performed on each piece of patient information traversed.
Specifically, in this embodiment, each piece of patient information newly added in all relevant target databases is periodically collected in the source database, and each time after each piece of patient information newly added in all relevant target databases is collected in the source database, each piece of patient information added in the source database is traversed, and step S21 is performed on each piece of traversed patient information.
In addition, it should be noted that, each piece of patient information newly added in all the target databases may be collected into the source database periodically, each piece of patient information added in the source database is traversed periodically, and step S21 may be executed for each piece of patient information traversed.
The time intervals for aggregating patient information into the source database and for traversing the increased patient information in the source database may be set by those skilled in the art depending on the circumstances.
As an exemplary embodiment of the present invention, step S1 is preceded by:
setting a matching factor.
In particular implementations, the matching factor may be set based on the field name of the target database of the target medical facility, e.g., the following matching factors may be set: patient identification number, name, gender, date of birth, telephone number, home address, etc.
The set matching factor may be a part of the field of the source database, or may be identical to the field of the source database, but may not include content other than the field of the source database.
And the set matching factors are used for a user to select matching fields of the main index matching rule according to the specific use scene and the requirements of the medical institution.
In some embodiments, the patient primary indexing system 200 may include a plurality of functional modules comprised of computer program segments. The computer program of the various program segments in the patient master index system 200 may be stored in a memory of a computer device and executed by at least one processor to perform the functions of the patient master index (described in detail with respect to fig. 1).
In this embodiment, the patient primary indexing system 200 may be divided into a plurality of functional modules according to the functions performed thereby, as shown in fig. 2. The functional module may include: a database construction module 210, an information traversal module 220, an information detection module 230, and a master index generation module 240. The module referred to in the present invention refers to a series of computer program segments capable of being executed by at least one processor and of performing a fixed function, stored in a memory. In the present embodiment, the functions of the respective modules will be described in detail in the following embodiments.
A database construction module 210, configured to aggregate patient information of a target database of a target medical institution, and construct a source database;
the information traversing module 220 is configured to traverse each piece of patient information in the source database for a preset main index matching rule;
the information detection module 230 is configured to detect, for each piece of patient information traversed by the information traversing module 220, each piece of patient information in the source database that matches the currently traversed patient information based on the current main index matching rule, and record the detected information;
the main index generation module 240 is configured to determine whether the detected information is null: if yes, judging whether the patient information currently traversed has the patient main index number or not: if the patient main index number exists, the treatment is not performed; if the patient main index number does not exist, generating a patient main index number for the currently traversed patient information and recording the generation time; if not, judging whether the patient information currently traversed has the patient main index number or not: if the patient information currently traversed has the patient main index number, judging whether the patient information with the patient main index number earlier than the generation time of the patient main index number of the patient information currently traversed exists in the detected information, if so, updating the patient main index number of the patient information currently traversed by using the patient main index number with the earliest generation time in the detected information, and if not, not updating the patient main index number of the patient information currently traversed; if the currently traversed patient information does not have the patient main index number, judging whether the patient information with the patient main index number exists in the detected information, if so, using the patient main index number with the earliest generation time in the detected information as the patient main index number of the currently traversed patient information, if not, generating a patient main index number for the currently traversed patient information, and recording the generation time.
Optionally, as an embodiment of the present invention, the system 200 further includes:
the task management module is used for setting a target medical institution and a target database;
the patient information inquiry module is used for inquiring the patient information by using the patient main index number;
and the main index number query module is used for users to query the main index number of the patient by using the keywords.
The key word may be any one of a patient identification number, name, sex, birth date, telephone number, home address, medical institution code of a medical institution where the patient is visiting, medical institution name, and original patient ID of the medical institution.
Optionally, as an embodiment of the present invention, the system 200 further includes:
the first module is used for respectively adding the generated patient main index number and the generation time of the patient main index number into the source database when the main index generation module generates the patient main index number for the currently traversed patient information each time;
and the second module is used for respectively adding the updated patient main index number and the generation time of the updated patient main index number to the source database when the main index generation module updates the patient main index number of the currently traversed patient information.
Optionally, as an embodiment of the present invention, the system 200 further includes:
the increment module is used for periodically gathering each piece of patient information added in the target database into the source database;
the increment traversing module is used for traversing each piece of patient information newly added in the source database and calling the main index generating module for each piece of traversed patient information.
Optionally, as an embodiment of the present invention, the system 200 further includes:
and the priority setting unit is used for setting a main index matching rule and priority thereof.
For example, the primary index matching rule may be set as a first primary index matching rule, a second primary index matching rule, and a third primary index matching rule. And setting the priority of the first main index matching rule, the second main index matching rule and the third main index matching rule to be 1, 2 and 3 in sequence. The first main index matching rule has a higher priority than the second main index matching rule, and the second main index matching rule has a higher priority than the third main index matching rule.
Optionally, setting the primary index matching rule includes setting a matching field of each primary index matching rule correspondingly.
For example, the matching field of the first main index matching rule may be set as an identification card number and a name; matching fields of the second main index matching rule can be set to be name, birth date, gender and contact phone; the matching field of the third primary index matching rule may be set to the medical facility code and the original patient ID within the medical facility.
In particular, the matching field of each main index matching rule can be set by those skilled in the art according to the actual situation.
In addition, the invention has reliable design principle, simple structure and very wide application prospect. The technical effects achieved by this embodiment may be referred to above, and will not be described herein.
It will be apparent to those skilled in the art that the techniques of embodiments of the present invention may be implemented in software plus a necessary general purpose hardware platform. Based on such understanding, the technical solution in the embodiments 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 such as a U-disc, a mobile hard disc, a Read-Only Memory (ROM), a random access Memory (RAM, random Access Memory), a magnetic disk or an optical disk, etc. various media capable of storing program codes, including several instructions for causing a computer terminal (which may be a personal computer, a server, or a second terminal, a network terminal, etc.) to execute all or part of the steps of the method described in the embodiments of the present invention.
The same or similar parts between the various embodiments in this specification are referred to each other. In particular, for system embodiments, since they are substantially similar to method embodiments, the description is relatively simple, as far as reference is made to the description in the method embodiments.
In the several embodiments provided by the present invention, it should be understood that the disclosed systems and methods may be implemented in other ways. For example, the system embodiments described above are merely illustrative, e.g., the division of the modules is merely a logical function division, and there may be additional divisions when actually implemented, e.g., multiple modules or components may be combined or integrated into another system, or some features may be omitted or not performed. Alternatively, the coupling or direct coupling or communication connection shown or discussed with respect to each other may be through some interface, indirect coupling or communication connection of systems or modules, electrical, mechanical, or other form.
The modules described as separate components may or may not be physically separate, and components shown as modules may or may not be physical modules, i.e., may be located in one place, or may be distributed over a plurality of network modules. Some or all of the modules may be selected according to actual needs to achieve the purpose of the solution of this embodiment.
In addition, each functional module in each embodiment of the present invention may be integrated into one processing module, or each module may exist alone physically, or two or more modules may be integrated into one module.
According to the invention, each piece of patient information added in the target database of the target medical institution can be collected into the source database at regular intervals, each piece of patient information added in the source database can be traversed, and the related patient main index generation steps are executed on each piece of traversed patient information, so that the combination between the newly added information record in the target database of the target medical institution and the stock data in the source database of the patient is facilitated, the timeliness and the integrity of the updating of the patient information in the source database are facilitated to a certain extent, and the integrity of the subsequent patient information query is facilitated to be ensured.
In addition, the "user" referred to in the present specification may be medical staff (for example, staff at a hospital registration place) of a medical institution, medical data administration staff, or the like.
Although the present invention has been described in detail by way of preferred embodiments with reference to the accompanying drawings, the present invention is not limited thereto. Various equivalent modifications and substitutions may be made in the embodiments of the present invention by those skilled in the art without departing from the spirit and scope of the present invention, and it is intended that all such modifications and substitutions be within the scope of the present invention/be within the scope of the present invention as defined by the appended claims. Therefore, the protection scope of the present invention shall be subject to the protection scope of the claims.

Claims (10)

1. A method of generating a patient primary index, comprising the steps of:
s1, collecting patient information of a target database of a target medical institution, and constructing a source database;
s2, traversing each piece of patient information in the source database according to a preset main index matching rule, and executing the following steps for each piece of traversed patient information:
s21, based on the current main index matching rule, detecting each piece of patient information matched with the currently traversed patient information in the source database, and marking the patient information as detected information;
s22, judging whether the detected information is empty:
if yes, judging whether the patient information currently traversed has the patient main index number or not: if the patient main index number exists, the treatment is not performed; if the patient main index number does not exist, generating a patient main index number for the currently traversed patient information and recording the generation time;
if not, judging whether the patient information currently traversed has the patient main index number or not:
if the patient information currently traversed has the patient main index number, judging whether the patient information with the patient main index number earlier than the generation time of the patient main index number of the patient information currently traversed exists in the detected information, if so, updating the patient main index number of the patient information currently traversed by using the patient main index number with the earliest generation time in the detected information, and if not, not updating the patient main index number of the patient information currently traversed;
if the currently traversed patient information does not have the patient main index number, judging whether the patient information with the patient main index number exists in the detected information, if so, using the patient main index number with the earliest generation time in the detected information as the patient main index number of the currently traversed patient information, if not, generating a patient main index number for the currently traversed patient information, and recording the generation time.
2. The method according to claim 1, wherein step S2 further comprises:
when generating a patient main index number for the currently traversed patient information, respectively adding the generated patient main index number and the generation time of the patient main index number into a source database correspondingly;
and when updating the patient main index number of the currently traversed patient information, respectively adding the updated patient main index number and the generation time of the updated patient main index number to the source database correspondingly.
3. The method of claim 1, wherein the number of preset primary index matching rules is at least one; different priorities are assigned to different primary index matching rules.
4. The method of claim 3, wherein the preset master index matching rules include a first master index matching rule, a second master index matching rule, and a third master index matching rule;
the first main index matching rule has a higher priority than the second main index matching rule; the second main index matching rule has a higher priority than the third main index matching rule.
5. The method of claim 4, wherein the first, second, and third main index matching rules are respectively different preset matching fields for matching patient information.
6. The method according to any one of claims 1-5, wherein the method further comprises:
periodically collecting each piece of patient information added in the target database into the source database;
each piece of patient information added in the source database is traversed, and step S21 is performed on each piece of patient information traversed.
7. A patient primary index generation system, the system comprising:
the database construction module is used for gathering patient information of a target database of the target medical institution and constructing a source database;
the information traversing module is used for traversing each piece of patient information in the source database aiming at a preset main index matching rule;
the information detection module is used for detecting each piece of patient information matched with the currently traversed patient information in the source database based on the current main index matching rule, and recording the detected information as the detected information;
the main index generation module is used for judging whether the detected information is empty or not: if yes, judging whether the patient information currently traversed has the patient main index number or not: if the patient main index number exists, the treatment is not performed; if the patient main index number does not exist, generating a patient main index number for the currently traversed patient information and recording the generation time; if not, judging whether the patient information currently traversed has the patient main index number or not: if the patient information currently traversed has the patient main index number, judging whether the patient information with the patient main index number earlier than the generation time of the patient main index number of the patient information currently traversed exists in the detected information, if so, updating the patient main index number of the patient information currently traversed by using the patient main index number with the earliest generation time in the detected information, and if not, not updating the patient main index number of the patient information currently traversed; if the currently traversed patient information does not have the patient main index number, judging whether the patient information with the patient main index number exists in the detected information, if so, using the patient main index number with the earliest generation time in the detected information as the patient main index number of the currently traversed patient information, if not, generating a patient main index number for the currently traversed patient information, and recording the generation time.
8. The system of claim 7, wherein the system further comprises:
the task management module is used for setting a target medical institution and a target database;
the patient information inquiry module is used for inquiring the patient information by using the patient main index number;
and the main index number query module is used for a user to query the main index number of the patient by using the keywords.
9. The system of claim 7, wherein the system further comprises:
the first module is used for respectively adding the generated patient main index number and the generation time of the patient main index number into the source database when the main index generation module generates the patient main index number for the currently traversed patient information each time;
and the second module is used for respectively adding the updated patient main index number and the generation time of the updated patient main index number to the source database when the main index generation module updates the patient main index number of the currently traversed patient information.
10. The system according to any one of claims 7-9, wherein the system further comprises:
the increment module is used for periodically gathering each piece of patient information added in the target database into the source database;
the increment traversing module is used for traversing each piece of patient information added in the source database and calling the main index generating module for each piece of traversed patient information.
CN202410245953.8A 2024-03-05 2024-03-05 Patient main index generation method and system Active CN117851411B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202410245953.8A CN117851411B (en) 2024-03-05 2024-03-05 Patient main index generation method and system

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202410245953.8A CN117851411B (en) 2024-03-05 2024-03-05 Patient main index generation method and system

Publications (2)

Publication Number Publication Date
CN117851411A true CN117851411A (en) 2024-04-09
CN117851411B CN117851411B (en) 2024-05-10

Family

ID=90544365

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202410245953.8A Active CN117851411B (en) 2024-03-05 2024-03-05 Patient main index generation method and system

Country Status (1)

Country Link
CN (1) CN117851411B (en)

Citations (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN102103623A (en) * 2010-09-29 2011-06-22 长沙博为软件技术有限公司 Cross index identification method for health file sharing platforms
US20160328449A1 (en) * 2015-05-06 2016-11-10 Siemens Product Lifecycle Management Software Inc. Unified set-based traversal system
CN113688135A (en) * 2021-08-25 2021-11-23 四川互慧软件有限公司 Hospital information integration method based on patient main index technology
CN114741384A (en) * 2021-12-22 2022-07-12 深圳市巨鼎医疗股份有限公司 Patient information processing method and device and computer readable storage medium
CN115269613A (en) * 2022-09-27 2022-11-01 四川互慧软件有限公司 Patient main index construction method, system, equipment and storage medium
CN115374113A (en) * 2022-08-10 2022-11-22 恺恩泰(南京)科技有限公司 Patient main index data generation method, system and device

Patent Citations (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN102103623A (en) * 2010-09-29 2011-06-22 长沙博为软件技术有限公司 Cross index identification method for health file sharing platforms
US20160328449A1 (en) * 2015-05-06 2016-11-10 Siemens Product Lifecycle Management Software Inc. Unified set-based traversal system
CN113688135A (en) * 2021-08-25 2021-11-23 四川互慧软件有限公司 Hospital information integration method based on patient main index technology
CN114741384A (en) * 2021-12-22 2022-07-12 深圳市巨鼎医疗股份有限公司 Patient information processing method and device and computer readable storage medium
CN115374113A (en) * 2022-08-10 2022-11-22 恺恩泰(南京)科技有限公司 Patient main index data generation method, system and device
CN115269613A (en) * 2022-09-27 2022-11-01 四川互慧软件有限公司 Patient main index construction method, system, equipment and storage medium

Non-Patent Citations (2)

* Cited by examiner, † Cited by third party
Title
DONNA CREW 等: "Overcoming Challenges of Merging Multiple Patient Identification and Matching Systems:A Case Study", 《PERSPECT HEALTH INF MANAG》, 7 December 2020 (2020-12-07) *
林瑜 等: "医院信息系统患者主索引的设计与应用", 《信息与电脑(理论版)》, 30 September 2022 (2022-09-30) *

Also Published As

Publication number Publication date
CN117851411B (en) 2024-05-10

Similar Documents

Publication Publication Date Title
US10698922B2 (en) System and method for providing patient record synchronization in a healthcare setting
US8429220B2 (en) Data exchange among data sources
US7092956B2 (en) Deduplication system
CA2292494C (en) System and method for indexing information about entities from different information sources
US8515926B2 (en) Processing related data from information sources
US10572461B2 (en) Systems and methods for managing a master patient index including duplicate record detection
US20030233252A1 (en) System and method for providing a generic health care data repository
JP2012510687A (en) Mapping instances of datasets in the data management system
WO2008121700A1 (en) Method and system for managing entities
WO2018095299A1 (en) Time sequence data management method, device and apparatus
US20220005564A1 (en) Semantic search for a health information exchange
CN111143422B (en) Data retrieval method, data retrieval device, storage medium and electronic equipment
US20120158714A1 (en) Storage and searching of temporal entity information
CN110442791B (en) Data pushing method and system
CN103177066A (en) Analyzing and representing interpersonal relations
WO2023083237A1 (en) Graph data management
CN113688135A (en) Hospital information integration method based on patient main index technology
CN111899821A (en) Method for processing medical institution data, method and device for constructing database
CN113628707B (en) Method, device, equipment and storage medium for processing patient medical record data
CN117851411B (en) Patient main index generation method and system
CN110502529B (en) Data processing method, device, server and storage medium
KR101415528B1 (en) Apparatus and Method for processing data error for distributed system
EP3652669A1 (en) Systems and methods for compiling a database
CN116450887B (en) Hospital informatization equipment management system
CN111723146B (en) Method for monitoring database, management system and storage medium

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination
GR01 Patent grant
GR01 Patent grant