CN111785342A - Medical data integration method and system based on data warehouse - Google Patents
Medical data integration method and system based on data warehouse Download PDFInfo
- Publication number
- CN111785342A CN111785342A CN202010672448.3A CN202010672448A CN111785342A CN 111785342 A CN111785342 A CN 111785342A CN 202010672448 A CN202010672448 A CN 202010672448A CN 111785342 A CN111785342 A CN 111785342A
- Authority
- CN
- China
- Prior art keywords
- data
- patient
- duty
- patients
- treatment
- 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.)
- Withdrawn
Links
Images
Classifications
-
- G—PHYSICS
- G16—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR SPECIFIC APPLICATION FIELDS
- G16H—HEALTHCARE INFORMATICS, i.e. INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR THE HANDLING OR PROCESSING OF MEDICAL OR HEALTHCARE DATA
- G16H10/00—ICT specially adapted for the handling or processing of patient-related medical or healthcare data
- G16H10/60—ICT specially adapted for the handling or processing of patient-related medical or healthcare data for patient-specific data, e.g. for electronic patient records
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/08—Logistics, e.g. warehousing, loading or distribution; Inventory or stock management
- G06Q10/087—Inventory or stock management, e.g. order filling, procurement or balancing against orders
- G06Q10/0875—Itemisation or classification of parts, supplies or services, e.g. bill of materials
-
- G—PHYSICS
- G16—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR SPECIFIC APPLICATION FIELDS
- G16H—HEALTHCARE INFORMATICS, i.e. INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR THE HANDLING OR PROCESSING OF MEDICAL OR HEALTHCARE DATA
- G16H40/00—ICT specially adapted for the management or administration of healthcare resources or facilities; ICT specially adapted for the management or operation of medical equipment or devices
- G16H40/20—ICT specially adapted for the management or administration of healthcare resources or facilities; ICT specially adapted for the management or operation of medical equipment or devices for the management or administration of healthcare resources or facilities, e.g. managing hospital staff or surgery rooms
-
- G—PHYSICS
- G16—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR SPECIFIC APPLICATION FIELDS
- G16H—HEALTHCARE INFORMATICS, i.e. INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR THE HANDLING OR PROCESSING OF MEDICAL OR HEALTHCARE DATA
- G16H50/00—ICT specially adapted for medical diagnosis, medical simulation or medical data mining; ICT specially adapted for detecting, monitoring or modelling epidemics or pandemics
- G16H50/70—ICT specially adapted for medical diagnosis, medical simulation or medical data mining; ICT specially adapted for detecting, monitoring or modelling epidemics or pandemics for mining of medical data, e.g. analysing previous cases of other patients
-
- G—PHYSICS
- G16—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR SPECIFIC APPLICATION FIELDS
- G16H—HEALTHCARE INFORMATICS, i.e. INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR THE HANDLING OR PROCESSING OF MEDICAL OR HEALTHCARE DATA
- G16H50/00—ICT specially adapted for medical diagnosis, medical simulation or medical data mining; ICT specially adapted for detecting, monitoring or modelling epidemics or pandemics
- G16H50/80—ICT specially adapted for medical diagnosis, medical simulation or medical data mining; ICT specially adapted for detecting, monitoring or modelling epidemics or pandemics for detecting, monitoring or modelling epidemics or pandemics, e.g. flu
Abstract
The invention discloses a medical data integration method and system based on a data warehouse, and relates to the field of S. The medical data integration method and system based on the data warehouse comprise the data warehouse, wherein the data warehouse comprises three modules, the first module is patient data, the second module is medical data, and the third module is article data. This medical data integration method and system based on data warehouse carries out the data integration including patient, medical personnel and article in the hospital through data warehouse, when providing reasonable diagnosis and treatment service for the patient, reasonable reposition of redundant personnel reduces patient's time of lining up, improves the resource utilization who all hospitals in this region simultaneously for the configuration of whole hospital personnel more tends to rationalize, and carry out data integration to all kinds of medicines and the equipment of hospital, avoid appearing the supply and demand relation mismatch of article.
Description
Technical Field
The invention relates to the technical field of medical data integration, in particular to a medical data integration method and system based on a data warehouse.
Background
Nowadays, with the development of science and technology, various diseases can be treated by medical means, but the population of the city is dense at present, each hospital has a large number of patients to receive treatment every day, and the hospital establishes different departments for distinguishing different types of patients, so that the patients can be treated quickly and orderly.
For some large-scale hospitals, various departments and departments are complicated and intricate, and various medical information and patient information cannot be integrated and combed in time, so that the supply and demand of the medical information and the patient are not matched, some departments are too busy, and some people with too many cold departments are wasted.
Disclosure of Invention
Technical problem to be solved
In view of the deficiencies of the prior art, the present invention provides a medical data integration method and system based on a data warehouse, so as to solve the problems proposed in the background art.
(II) technical scheme
In order to achieve the purpose, the invention is realized by the following technical scheme: a medical data integration method and system based on a data warehouse comprises the data warehouse, wherein the data warehouse comprises three modules, the first module is patient data, the second module is medical data, the third module is object data, the patient data can establish information intercommunication among a plurality of hospitals, and a patient can be better diagnosed and treated, the patient data comprises patient reception, case integration and subsequent tracking, the patient number of the hospitals is monitored in the whole process through the patient data monitoring module, the limit of the number of receivable patients can be calculated according to the scale of the hospitals, when the number of the patients exceeds the receivable range, the subsequent patients can be informed, the patients can be shunted to other hospitals to be treated as much as possible, the delay of excessive time of the patients is avoided, the case integration is to integrate all the patient reception data among the hospitals and share cases with each other, the diagnosis time is reduced by matching the same cases, doctors can communicate with each other through case integration, the diagnosis and treatment experience of the doctors is improved, the follow-up tracking is realized by filing the information of the patient, and the information of the patient can be synchronously updated when the patient goes to other hospitals for diagnosis and treatment, so that the follow-up condition of the patient can be known;
medical care data has contained personnel configuration, the state of arranging duty and information on duty, through personnel configuration data integration, can carry out medical personnel's increase and have assigned according to hospital scale and daily patient flow for the doctor-patient confession is moderate, can show the state information of the personnel on duty and the personnel on duty of not on duty of the day according to the state of arranging duty simultaneously, the information on duty can implement and know the on duty condition of each position and avoid the position to have nobody and the medical malpractice that causes, article data contains medicine, equipment and window, the medicine state of hospital is updated in real time in medicine data integration, and equipment data show the state of various consumptive type equipment and the non-consumptive type equipment of hospital simultaneously, and the window data can be opened in step, lets the patient know the state of the window of getting it filled and registering of hospital, avoids appearing the information difference and makes the supply to have the difference.
Preferably, the disease reception data includes hospital-wide disease data, department disease data and expert disease data, through whole disease reception data panel, know the disease quantity of whole hospital, the data is shared for each hospital in this area in step, then can shunt the patient, make things convenient for the patient in time to accept to diagnose, avoid extravagant patient diagnosis time delay treatment opportunity simultaneously, the patient reception data of each department can be disclosed to the patient simultaneously, let the patient know the condition of lining up of the own department, carry out the afternoon reposition of redundant personnel, avoid the overlength time to wait, simultaneously, through expert disease reception data, let the patient know the condition of lining up of expert's diagnosis, shunt to department of general practitioner when the patient condition is not serious and treat.
Preferably, the case integration comprises case entry, case summarization and case retrieval, patients are treated by treatment doctors, basic information and treatment conditions of the patients are integrated after treatment, the basic information and the treatment conditions are collected into an archive form for entry, the entered cases can be summarized, common typical cases are classified according to departments, meanwhile, special cases are stored separately, unknown cases which can not give diagnosis results also need to be stored separately, case consultation among multiple hospitals can be carried out simultaneously, treatment is carried out jointly, and the treatment accuracy of the patients is improved.
Preferably, the follow-up tracking comprises patient conditions, other treatments and final results, the patient conditions are tracked and known through the data integration platform when the patient is treated in the plurality of hospitals through a data warehouse which is built by the plurality of hospitals, the data of each hospital are intercommunicated, the patient condition can be synchronously treated when the patient is treated in the plurality of hospitals, the treatment information can be synchronously obtained when the patient is treated in the other hospitals, the results of each treatment are collected to form the final results, and the final results can be updated according to the condition that the patient receives the treatment each time.
Preferably, the staff configuration comprises nurses, doctors and experts, data analysis is carried out according to the treatment situations of the patients in each department in daily life, the flow rate of each department is known, the number of the nurses in each department is reasonably distributed, the number of the treating doctors can be increased for the departments with a large number of patients, and the number of the experts in corresponding specialties can be increased for the hospitals according to the characteristics and the professional strength of each hospital.
Preferably, the scheduling state comprises on-duty situations, vacation and rest announcement, the on-duty number of doctors in each department is known through data integration of the scheduling state, the data adjustment of the maximum receiving capacity of patients in the department of the hospital on the same day is carried out according to the on-duty number, the situation that the number of doctors and patients is not matched is avoided, meanwhile, physician data in the vacation state is integrated, when the emergency situation occurs in the hospital, the physicians in the vacation state can be called back emergently, meanwhile, the rest data of medical care personnel are integrated, main diagnosis and on-duty personnel on the same day are known, and the situation that a first person in charge cannot be found quickly in the occurring situation is avoided.
Preferably, the information on duty includes emergency treatment reception, ward patrol and security personnel, and through the data integration to emergency treatment reception personnel, understand the emergency treatment reception personnel quantity and the information of present day, conveniently handle the accuse to emergency, can call back the medical personnel of other states when the person on duty that emergency treatment received is not enough, the ward patrol is integrated through the ward patrol personnel information to every department every day, avoids the condition that the ward nobody looked over, conveniently seeks first person of responsibility in the problem simultaneously, and security personnel data integration can understand the person in charge on duty of security on duty of present day, conveniently in time notifies corresponding security person on duty when the situation appears, avoids appearing the accident and handles untimely and cause more personnel and equipment damage.
Preferably, the medicine data comprises data integration of the inventory quantity and the use quantity of the current medicines of the hospital, and the medicine data of different types are integrated, so that the medicine purchase quantity can be reasonably planned through the data, overdue waste caused by excessive medicine purchase is avoided, and treatment failure of a patient due to insufficient medicine quantity can be prevented.
Preferably, the equipment data include consumption type, ordinary equipment and main equipment, carry out data integration to the surplus condition of consumption type equipment, can in time purchase, avoid the equipment to exhaust to influence patient's treatment, integrate to the use data of ordinary equipment simultaneously, in time increase and decrease, and integrate to the use data of main equipment, know the in service behavior of this type of equipment, in time maintain and change when the main equipment breaks down.
Preferably, the window is including getting the medicine passageway, getting it filled and calling number and drugstore on duty, through getting it filled passageway data integration, knows each window of getting it filled's the condition of lining up, avoids the patient quantity of each window department to have great difference, and reasonable reposition of redundant personnel reduces patient's time of lining up, can remind the patient in time to get it filled through getting it filled and calling number simultaneously, knows the running state of drugstore to drugstore on duty condition simultaneously, avoids appearing the window unmanned on duty, and the condition that the influence patient got it filled appears.
The invention provides a medical data integration method and system based on a data warehouse, which have the following beneficial effects:
1. according to the medical data integration method and system based on the data warehouse, the data warehouse is established among all hospitals in the area, patient data can be shared among the hospitals, patient reception conditions of the hospitals can be known, when the number of patients reaches the hospital reception limit, the patients can be recommended to the nearest similar departments of the hospitals, queuing waiting time of the patients is reduced, meanwhile, through patient reception data integration, basic information and diagnosis and treatment conditions of the patients are documented and input after diagnosis and treatment are finished, case consultation among the hospitals can be carried out, diagnosis and treatment are carried out together, diagnosis and treatment accuracy of the patients is improved, follow-up treatment conditions of the patients through shared information, and reasonable diagnosis and treatment services are provided for the patients.
2. According to the medical data integration method and system based on the data warehouse, the number of medical staff in each department is reasonably configured through the medical data module, the condition that the supplies and the demands of doctors and patients are not equal is avoided, the number of workers in each department on duty is known aiming at the daily scheduling state, the maximum receiving capacity of patients in the department on the same day of the hospital is adjusted according to the number, the actual condition is met, the operators on duty in each department and department on the same day are known through the media duty information data integration, the responsible personnel are timely found when dealing with the emergency, the first responsible person is conveniently found when the problem occurs, and the configuration of the personnel in the whole hospital tends to be more reasonable according to the system.
3. This medical data integration method and system based on data warehouse, through article data integration module, know all medicines of this hospital, the state of equipment and window, the purchasing personnel of being convenient for carry out in time the purchase to consumption type article, carry out the adjustment of purchase quantity and class next time according to the in service behavior simultaneously, the supply and demand relation of avoiding appearing the article is unmatched, can analyze out the morbidity and the propagation condition of this period to some infectivity and influenza nature diseases according to some conventional medicines simultaneously, the integration to window operation data simultaneously, avoid the patient quantity of each window department to have great difference, the reasonable reposition of redundant personnel, reduce patient's queuing time.
Drawings
FIG. 1 is a system diagram of a main body frame according to the present invention;
figure 2 is a system diagram of a patient data module of the present invention;
FIG. 3 is a system diagram of a healthcare data module according to the present invention;
FIG. 4 is a system diagram of an item data module of the present invention.
Detailed Description
The embodiment of the invention provides a medical data integration method and a system based on a data warehouse, as shown in figures 1-4, the medical data integration method comprises the steps that the data warehouse comprises three modules, the first module is patient data, the second module is medical data, the third module is article data, the patient data can establish information intercommunication among a plurality of hospitals, a patient can be conveniently diagnosed and treated, the patient data comprises patient reception, case integration and subsequent tracking, the patient number of the hospitals is monitored in the whole process through the patient data monitoring module, the limit of the number of the receivable patients can be calculated according to the scale of the hospitals, when the number of the patients exceeds the receivable range, the subsequent patients can be informed, the patients can be distributed to other hospitals to be treated as much as possible, the delay of excessive time of the patients is avoided, case integration is realized by integrating all the patient reception data among the hospitals, the cases are shared with each other, the diagnosis time is reduced by matching the same cases, doctors can mutually communicate through case integration, the diagnosis and treatment experience of the doctors is improved, the follow-up tracking is realized by filing the information of patients, the information of the patients can be synchronously updated when the patients go to other hospitals for diagnosis and treatment, so as to know the follow-up condition of the patients, the medical care data comprises personnel configuration, a shift state and duty information, the medical care data can be integrated through the personnel configuration data, the medical care personnel can be added according to the scale of the hospitals and the daily patient flow, so that the patient supply ratio is moderate, the state information of the personnel on duty and the personnel not on duty on the day can be displayed according to the shift state, the duty information can be used for knowing the shift condition of each post, so as to avoid medical accidents caused by the absence of the post, the article data comprises medicines, instruments and windows, and the medicine data is integrated to update the medicine state of the hospitals in real, meanwhile, the equipment data display states of various consumable equipment and non-consumable equipment of the hospital, and meanwhile, the window data can be synchronously opened, so that the patient can know states of the medicine taking and registration windows of the hospital, and the difference of supply caused by the poor information is avoided.
Furthermore, the patient reception data comprises patient data of all hospitals, department patient data and expert patient data, the number of patients in the whole hospital is known through the whole patient reception data panel, the data is synchronously shared by all hospitals in the area, then the patient can be shunted, the patient can conveniently receive the diagnosis and treatment in time, meanwhile, the delay of treatment opportunity caused by the delay of the treatment time of the patient is avoided, meanwhile, the patient reception data of all departments can be published for the patient, the patient can know the queuing condition of the department where the patient is located, the shunting at noon and afternoon is carried out, the overlong time waiting is avoided, meanwhile, the patient can know the queuing condition of the expert treatment through the expert patient reception data, the patient can be shunted to the department of a general doctor in the department when the condition of the patient is not serious, meanwhile, the case integration comprises the recording of cases, the case collection and the case retrieval, the patient is received by the doctor, after the diagnosis and treatment are finished, the basic information and the diagnosis and treatment conditions of a patient are integrated, the basic information and the diagnosis and treatment conditions are collected into an archive form for entry, the entered cases can be summarized, common typical cases are classified according to departments, meanwhile, special cases are stored separately, unknown cases which can not give diagnosis results also need to be stored separately, case consultation among a plurality of hospitals can be carried out simultaneously, diagnosis and treatment are carried out together, the diagnosis and treatment accuracy of the patient is improved, further, the follow-up tracking comprises the patient conditions, other treatments and final results, the data of all hospitals are intercommunicated through a data warehouse which is built together by the plurality of hospitals, when the patient is diagnosed and treated in the plurality of hospitals, the tracking and understanding of the patient conditions can be carried out through the data integration platform, when the patient is diagnosed and treated in other hospitals, the diagnosis and treatment information can be synchronized, and the results of each diagnosis and treatment are collected, a final result is formed and updated for each treatment the patient receives.
More specifically, the personnel configuration comprises nurses, doctors and experts, data analysis is carried out according to the treatment situations of the patients in each department daily, the flow of each department is known, the number of the nurses in each department is reasonably distributed, the number of the treating doctors can be increased for departments with more treatment people, the number of the experts in corresponding departments can be increased for the hospitals according to the characteristics and the professional strength of each hospital, the scheduling state comprises on-duty situations, vacation and rest notice, the on-duty number of the doctors in each department is known through data integration of the scheduling state, the data adjustment of the maximum receiving capacity of the patients in the department on the same day of the hospital is carried out according to the on-duty situations, the situations that the numbers of the doctors and the patients are not matched are avoided, meanwhile, the data integration of the doctors in the vacation state is carried out, when the emergency situation occurs in the hospital, the doctors in the vacation state can be called back urgently, meanwhile, the integration is carried out aiming at the rest data of the medical staff, the main diagnosis and the on-duty staff on the day are known, the situation that the first person of responsibility cannot be found quickly in the occurrence situation is avoided, the on-duty information comprises emergency call reception, ward patrol and security staff, the quantity and the information of the emergency call reception staff on the day are known through the data integration of the emergency call reception staff, the handling and the control on the emergency situation are convenient, the medical staff in other states can be called back when the on-duty staff for the emergency call reception is insufficient, the ward patrol is realized by integrating the information of the ward patrol staff of each department every day, the situation that the ward is not checked by people is avoided, the first person of responsibility can be found conveniently in the occurrence situation, the data integration of the security staff can be known the person of security on-duty on the day, and the corresponding security staff can be informed in time when the situation occurs conveniently, avoid accident processing untimely and cause more personnel and equipment damage.
More specifically, the medicine data comprises data integration for the inventory quantity and the use quantity of the current medicines of the hospital, and simultaneously, the medicine data of different types is integrated, the medicine purchase quantity can be reasonably planned through the data, overdue waste caused by excessive medicine purchase is avoided, simultaneously, the situation that patients cannot receive treatment in time caused by insufficient medicine quantity is avoided, the morbidity and the propagation condition of infectious and influenza diseases in the time period can be analyzed according to some conventional medicines, so that the data can be shared to epidemic prevention departments, the propagation of large-scale serious epidemic diseases is avoided, further, the equipment data comprises consumption type equipment, common equipment and large-scale equipment, the data integration is carried out for the surplus condition of the consumption type equipment, the purchase can be carried out in time, the condition that the equipment is exhausted to influence the treatment of the patients is avoided, and simultaneously, the use data of the common equipment is integrated, increase and decrease in time, and use data to the main equipment integrates, know the in service behavior of this type of equipment, in time maintain and change when the main equipment breaks down, it is further, the window is including getting it filled the passageway, it calls number and drugstore on duty to get it filled, through getting it filled passageway data integration, know the condition of lining up of each window of getting it filled, avoid the patient quantity of each window department to have great difference, rationally shunt, reduce patient's queuing time, can remind the patient in time to get it filled through getting it filled and calling number simultaneously, know the running state of drugstore to the drugstore on duty condition simultaneously, avoid the window unmanned on duty, the condition that influences the patient and get it filled appears.
The working principle is as follows: the invention discloses a medical data integration method and a system based on a data warehouse, the system is based on the data warehouse, the data warehouse is commonly established among all hospitals in the area, wherein patient data can be shared among all the hospitals, medical care data and article data are internal data in a single hospital, the patient receiving condition of each hospital can be known through patient data sharing, the patient receiving condition is respectively calculated aiming at the whole hospital and each department, when the number of patients reaches the admissible limit of the hospital, the patients can be recommended to the nearest similar departments of the hospital, the queuing time of the patients is reduced, meanwhile, the patients are received by a doctor, the basic information and the diagnosis and treatment condition of the patients are integrated after the treatment is finished, the patient is collected into a file form for entry, meanwhile, the case can be summarized for the entered cases, and the common typical cases are classified according to the departments, meanwhile, special cases are independently stored, but unknown cases which can not give diagnosis results also need to be independently stored, case consultation among multiple hospitals can be performed simultaneously, diagnosis and treatment accuracy of a patient is improved, follow-up treatment conditions of the patient are tracked through shared information, and reasonable diagnosis and treatment services are provided for the patient;
the medical care data is used for data integration in the hospital, the quantity of medical care personnel in each department is reasonably configured through data analysis to avoid the condition that the supplies and the demands of doctors and patients are not equal, the on-duty quantity of doctors in each department is known aiming at the daily scheduling state, the data adjustment of the maximum receiving quantity of patients in the department on the same day of the hospital is carried out according to the on-duty quantity, the actual condition is met, the on-duty personnel in each department and department on the same day are known through the on-duty information data integration of media, the responsible personnel are timely found when dealing with the emergency, the first responsible person is conveniently found when the problem occurs, and the configuration of the personnel in the whole hospital tends to be more reasonable according to the system;
simultaneously through article data integration module, know all medicines of this hospital, the state of equipment and window, the purchasing staff of being convenient for carries out in time purchase to the consumption article, carry out the adjustment of purchase quantity and article class next time according to the in service behavior simultaneously, the supply and demand relation of avoiding appearing the article is unmatched, simultaneously can separate out the morbidity and the propagation condition of this period to some infectivity and influenza nature diseases according to some conventional medicines, simultaneously to the integration of window operation data, avoid the patient quantity of each window department to have great difference, the reasonable reposition of redundant personnel, reduce patient's queuing time.
The foregoing shows and describes the general principles and broad features of the present invention and advantages thereof. It will be understood by those skilled in the art that the present invention is not limited to the embodiments described above, which are described in the specification and illustrated only to illustrate the principle of the present invention, but that various changes and modifications may be made therein without departing from the spirit and scope of the present invention, which fall within the scope of the invention as claimed. The scope of the invention is defined by the appended claims and equivalents thereof.
Claims (10)
1. A medical data integration method and system based on a data warehouse comprises the data warehouse and is characterized in that: the data warehouse comprises three modules, wherein the first module is patient data, the second module is medical data, the third module is article data, the patient data can establish information intercommunication among a plurality of hospitals and facilitate patients to be better diagnosed and treated, the patient data comprises patient reception, case integration and follow-up tracking, the patient number of the hospitals is monitored in the whole process through the patient data monitoring module, the limit of the number of receivable patients can be calculated according to the hospital scale, when the number of the patients exceeds the receivable range, the follow-up patients can be informed, the patients are shunted to other hospitals to be treated as far as possible, excessive time of the patients is avoided being delayed, the case integration is realized by integrating all patient reception data among the hospitals, the patient reception data are shared with each other, the diagnosis time is reduced by matching the same cases, and doctors can communicate with each other through case integration, the diagnosis and treatment experience of doctors is improved, the follow-up tracking can synchronously update the information of the patients when the patients go to other hospitals for diagnosis and treatment by filing the information of the patients so as to know the follow-up conditions of the patients;
medical care data has contained personnel configuration, the state of arranging duty and information on duty, through personnel configuration data integration, can carry out medical personnel's increase and have assigned according to hospital scale and daily patient flow for the doctor-patient confession is moderate, can show the state information of the personnel on duty and the personnel on duty of not on duty of the day according to the state of arranging duty simultaneously, the information on duty can implement and know the on duty condition of each position and avoid the position to have nobody and the medical malpractice that causes, article data contains medicine, equipment and window, the medicine state of hospital is updated in real time in medicine data integration, and equipment data show the state of various consumptive type equipment and the non-consumptive type equipment of hospital simultaneously, and the window data can be opened in step, lets the patient know the state of the window of getting it filled and registering of hospital, avoids appearing the information difference and makes the supply to have the difference.
2. The medical data integration method and system based on the data warehouse of claim 1, wherein: the disease reception data includes hospital-wide disease data, department disease data and expert disease data, through whole disease reception data panel, know the disease quantity of whole hospital, the data is shared in step and is given each hospital in this region, then can shunt the patient, make things convenient for the patient in time to accept to diagnose, avoid extravagant patient diagnosis time delay treatment opportunity simultaneously, the patient reception data of each department can be disclosed the patient simultaneously, let the patient know the condition of lining up of own place department, the noon is shunted about carrying out, avoid the overlength time to wait, simultaneously, receive the data through expert disease, let the patient know the condition of lining up of expert's diagnosis, shunt to department of general practitioner of department to diagnose when the patient condition is not serious.
3. The medical data integration method and system based on the data warehouse of claim 1, wherein: the case integration comprises case input, case induction and case retrieval, a doctor treats patients, after diagnosis and treatment, basic information and diagnosis and treatment conditions of the patients are integrated, the basic information and the diagnosis and treatment conditions are integrated and input in an archive form, simultaneously, the input cases can be summarized, common typical cases are classified according to departments, meanwhile, special cases are stored separately, unknown cases which can not give diagnosis results need to be stored separately, case consultation among multiple hospitals can be carried out simultaneously, diagnosis and treatment are carried out together, and diagnosis and treatment accuracy of the patients is improved.
4. The medical data integration method and system based on the data warehouse of claim 1, wherein: the follow-up tracking comprises patient conditions, other treatments and final results, the data warehouse is built by a plurality of hospitals, the data of each hospital are communicated, when the patient makes a diagnosis and treatment in the plurality of hospitals, the tracking of the patient conditions can be realized through the data integration platform, when the patient makes a diagnosis and treatment in the other hospitals, the patient can synchronously make a diagnosis and treatment information, the results of each diagnosis and treatment are collected to form the final results, and the final results can be updated according to the condition that the patient receives the diagnosis and treatment each time.
5. The medical data integration method and system based on the data warehouse of claim 1, wherein: the personnel configuration comprises nurses, doctors and experts, data analysis is carried out according to the treatment conditions of the patients in each department in daily life, the flow of each department is known, the number of the nurses in each department is reasonably distributed, the number of the treating doctors can be increased for the departments with more treatment personnel, and the number of the experts in corresponding specialties can be increased for the hospitals according to the characteristics and professional strength of each hospital.
6. The medical data integration method and system based on the data warehouse of claim 1, wherein: the scheduling state comprises the on duty condition, vacation and scheduling notice, the number of doctors in each department on duty is known through data integration of the scheduling state, the data adjustment of the maximum receiving capacity of patients in the department of the hospital on the same day is carried out according to the number of doctors in each department, the situation that the number of doctors and patients is not matched is avoided according to the data adjustment, meanwhile, the integration is carried out on doctor data in the vacation state, when the emergency situation of the hospital occurs, the doctors in the vacation state can be called back urgently, meanwhile, the scheduling data of medical workers are integrated, the main diagnosis and treatment and the staff on duty on the same day are known, and the situation that a first person in charge cannot be found out quickly in the occurrence situation is avoided.
7. The medical data integration method and system based on the data warehouse of claim 1, wherein: information on duty includes emergency call admission, ward patrol and security personnel, through the data integration to emergency call admission personnel, knows emergency call admission personnel quantity and the information of present day, conveniently carries out the control to emergency, can call back the medical personnel of other states when the person on duty of emergency call admission is not enough, the ward patrol is integrated through the ward patrol personnel information to every administrative or technical offices of every day, avoids the condition that the ward nobody looked over, conveniently seeks first person of responsibility in the problem of appearing simultaneously, and security personnel data integration can know the person in charge on duty of present day security, conveniently in time infories corresponding security person on duty when the situation appears, avoids appearing the accident and handles untimely and cause more personnel and equipment damage.
8. The medical data integration method and system based on the data warehouse of claim 1, wherein: the medicine data contain and carry out data integration to the inventory quantity and the use quantity of this hospital's present medicine, integrate to the medicine data of different categories simultaneously, can carry out rational planning to medicine purchase quantity through the data, avoid appearing medicine purchase and lead to overdue extravagant, avoid appearing medicine quantity not enough simultaneously and lead to the patient can not in time accept the treatment, and can separate out this period according to some conventional medicines and to some infectivity and influenza nature disease's morbidity and propagation condition, can give epidemic prevention department with this data sharing, avoid appearing the propagation of large-scale serious epidemic disease.
9. The medical data integration method and system based on the data warehouse of claim 1, wherein: the equipment data include consumption type, ordinary equipment and main equipment, carry out data integration to the surplus condition of consumption type equipment, can in time purchase, avoid the equipment to exhaust to influence patient's treatment, integrate to the use data of ordinary equipment simultaneously, in time increase and decrease, and integrate to the use data of main equipment, know the in service behavior of this type of equipment, in time maintain and change when the main equipment breaks down.
10. The medical data integration method and system based on the data warehouse of claim 1, wherein: the window is including getting the medicine passageway, getting it filled and calling number and drugstore on duty, through getting it filled passageway data integration, knows each window of getting it filled's the condition of lining up, avoids the patient quantity of each window department to have great difference, rationally shunts, reduces patient's time of lining up, can remind the patient in time to get it filled through getting it filled and calling number simultaneously, knows the running state of drugstore to the drugstore on duty condition simultaneously, avoids appearing the window unmanned on duty, and the condition that the influence patient got it filled appears.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010672448.3A CN111785342A (en) | 2020-07-14 | 2020-07-14 | Medical data integration method and system based on data warehouse |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010672448.3A CN111785342A (en) | 2020-07-14 | 2020-07-14 | Medical data integration method and system based on data warehouse |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN111785342A true CN111785342A (en) | 2020-10-16 |
Family
ID=72767612
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202010672448.3A Withdrawn CN111785342A (en) | 2020-07-14 | 2020-07-14 | Medical data integration method and system based on data warehouse |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111785342A (en) |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112817945A (en) * | 2021-03-03 | 2021-05-18 | 江苏汇鑫融智软件科技有限公司 | Medical heterogeneous system data warehouse construction method based on ESB |
| CN113192614A (en) * | 2021-04-22 | 2021-07-30 | 广州中康数字科技有限公司 | Medical information management system based on big data |
| CN113643825A (en) * | 2021-06-25 | 2021-11-12 | 合肥工业大学 | Medical case knowledge base construction method and system based on clinical key characteristic information |
-
2020
- 2020-07-14 CN CN202010672448.3A patent/CN111785342A/en not_active Withdrawn
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112817945A (en) * | 2021-03-03 | 2021-05-18 | 江苏汇鑫融智软件科技有限公司 | Medical heterogeneous system data warehouse construction method based on ESB |
| CN113192614A (en) * | 2021-04-22 | 2021-07-30 | 广州中康数字科技有限公司 | Medical information management system based on big data |
| CN113192614B (en) * | 2021-04-22 | 2024-02-13 | 广州中康数字科技有限公司 | Medical information management system based on big data |
| CN113643825A (en) * | 2021-06-25 | 2021-11-12 | 合肥工业大学 | Medical case knowledge base construction method and system based on clinical key characteristic information |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN111785342A (en) | Medical data integration method and system based on data warehouse | |
| CN108986897B (en) | Medical resource optimization matching method and system for emergency rescue | |
| CN110322953A (en) | A kind of intelligence is accompanied the patient to see a doctor system and its method of accompanying the patient to see a doctor | |
| US5065315A (en) | System and method for scheduling and reporting patient related services including prioritizing services | |
| Steadman | Boundary spanners: A key component for the effective interactions of the justice and mental health systems | |
| US20180314802A1 (en) | System and method and graphical interface for performing predictive analysis and prescriptive remediation of patient flow and care delivery bottlenecks within emergency departments and hospital systems | |
| US20070156456A1 (en) | System for Monitoring Healthcare Related Activity In A Healthcare Enterprise | |
| CN109448865B (en) | ICU Clinical Decision Support Systems | |
| CA2470027A1 (en) | Management systems and methods | |
| Li et al. | Application of intelligent nursing information system in emergency nursing management | |
| Walker et al. | Strategies for improving patient throughput in an acute care setting resulting in improved outcomes: a systematic review | |
| WO2016108772A1 (en) | Nursing information management system | |
| US20090276277A1 (en) | Optimized Appointment Scheduling Method | |
| CN112509681A (en) | Intelligent medical service system based on big data | |
| CN115588495A (en) | Method and system for intelligently scheduling workload based on personnel in region | |
| CN101346722A (en) | Clinical workflow management and decision system and method | |
| US20210118555A1 (en) | System and method and graphical interface for performing predictive analysis and prescriptive remediation of patient flow and care delivery bottlenecks within emergency departments and hospital systems | |
| CN109785916A (en) | A kind of clinical path system based on information for hospital platform | |
| JP3979148B2 (en) | Medical appointment management method and medical appointment management program | |
| CN113096820A (en) | Epidemic disease and emergency treatment integrated management method and device | |
| Moeke et al. | On the performance of small-scale living facilities in nursing homes: A simulation approach | |
| CN116862031A (en) | Bed reservation system | |
| Stafford Jr et al. | Managerial analysis and decision-making in outpatient health clinics | |
| US20050197544A1 (en) | System and method for indexing emergency department crowding | |
| de Oliveira et al. | An integrated emergency care delivery system for major events |
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 | ||
| WW01 | Invention patent application withdrawn after publication |
Application publication date: 20201016 |
|
| WW01 | Invention patent application withdrawn after publication |