WO2020093721A1 - Data processing method and apparatus, device and storage medium - Google Patents

Abstract

A data processing method and apparatus, a device, and a storage medium. The method comprises: acquiring at least two data tables from an information management system of at least one hospital (S101), the data tables comprising a first data table and a second data table; determining the types of the first data table and the second data table (S102); if the type of the first data table matches that of the second data table, combining the first data table with the second data table to obtain a target data table (S103); correcting data in the target data table according to the attribute characteristics of the data in the target data table to obtain a corrected target data table (S104), so that medical data query efficiency is improved.

Description

Data processing method, device, equipment and storage medium

This application requires the priority of the Chinese patent application filed on November 07, 2018 in the Chinese Patent Office with the application number 201811323417.6 and the application name as "a data processing method, device, equipment and storage medium", the entire content of which is cited by reference Incorporated in this application.

Technical field

This application relates to the medical technology field, and in particular, to a data processing method, device, equipment, and storage medium.

Background technique

By establishing an information management system, medical care can store various data tables, such as drug attribute information data tables, drug price data tables, consultation data tables and insurance data tables, etc., which can achieve data sharing between various hospitals or within hospitals. . However, due to the lack of management of the data tables in the hospital's information management system, it is not convenient for data query. For example, when a doctor wants to query the attribute information such as the origin or date of production of drug A, and the price of drug A, The doctor needs to first open the drug attribute information data table, and then open the drug price data table, so as to obtain the data to be queried. It can be seen that during the query, it is necessary to switch between multiple data tables, which is not convenient for data query.

Summary of the invention

Embodiments of the present application provide a data processing method, device, equipment, and storage medium, and improve the efficiency of medical data query by combining data tables.

In a first aspect, an embodiment of the present application provides a data processing method. The method includes:

Acquiring at least two data tables from the information management system of at least one hospital, the at least two data tables including a first data table and a second data table;

Determine the types of the first data table and the second data table;

When the type of the first data table matches the type of the second data table, merge the first data table and the second data table to obtain a target data table;

Correcting the data in the target data table according to the attribute characteristics of the data in the target data table to obtain the corrected target data table, the attribute characteristics of the data in the target data table include any one of the following or Multiple items: data field information, data format information, and the number of data occurrences.

In a second aspect, an embodiment of the present application provides a data processing apparatus, including:

An obtaining module, configured to obtain at least two data tables from the information management system of at least one hospital, the at least two data tables including a first data table and a second data table;

A determining module, configured to determine the types of the first data table and the second data table;

A merging module, configured to merge the first data table and the second data table to obtain a target data table when the type of the first data table matches the type of the second data table;

A correction module, configured to perform correction processing on the data in the target data table according to the attribute characteristics of the data in the target data table to obtain a corrected target data table, and the attribute characteristics of the data in the target data table include Any one or more of the following: data field information, data format information, and the number of times the data appears.

In a third aspect, an embodiment of the present application provides a medical management device including: a processor, a processor, and a memory, where the processor and the memory are connected to each other; wherein, the memory stores one or more than one Instructions, the one or more instructions are adapted to be loaded by the processor and execute the following steps: obtaining at least two data tables from the information management system of at least one hospital, the at least two data tables including the first data table and A second data table; determining the types of the first data table and the second data table; when the type of the first data table matches the type of the second data table, the first data table Merging with the second data table to obtain a target data table; correcting the data in the target data table according to the attribute characteristics of the data in the target data table to obtain the corrected target data table, the target data The attribute characteristics of the data in the table include any one or more of the following: field information of the data, data format information, and the number of times the data appears.

According to a fourth aspect, an embodiment of the present application provides a computer-readable storage medium, including: the computer-readable storage medium stores one or more instructions, the one or more instructions are suitable for being loaded and executed by a processor The following steps: obtaining at least two data tables from the information management system of at least one hospital, the at least two data tables including a first data table and a second data table; determining the first data table and the second data table Type; when the type of the first data table matches the type of the second data table, merge the first data table and the second data table to obtain a target data table; according to the target data table The attribute characteristics of the data in the data are corrected to the data in the target data table to obtain the corrected target data table. The attribute characteristics of the data in the target data table include any one or more of the following: fields of data Information, data format information, and the number of times the data appears.

In the embodiment of the present application, when querying medical data, there is no need to switch back and forth between multiple data tables, which improves the convenience of querying medical data and the efficiency of querying medical data; and by correcting the target data table, it is obtained The corrected target data table can save the storage space of the medical management equipment, and further improve the efficiency of querying medical data.

BRIEF DESCRIPTION

In order to more clearly explain the embodiments of the present application or the technical solutions in the prior art, the following will briefly introduce the drawings required in the embodiments. Obviously, the drawings in the following description are only some of the applications For the embodiment, for those of ordinary skill in the art, without paying any creative labor, other drawings may be obtained based on these drawings.

1 is a schematic flowchart of a data processing method provided by an embodiment of the present application;

2 is a schematic flowchart of a data processing method according to another embodiment of the present application;

3 is a schematic structural diagram of a data processing device according to an embodiment of the present application;

4 is a schematic structural diagram of a medical management device according to another embodiment of the present application.

detailed description

The technical solutions in the embodiments of the present application will be described clearly and completely below with reference to the drawings in the embodiments of the present application. Obviously, the described embodiments are part of the embodiments of the present application, but not all of the embodiments. Based on the embodiments in the present application, all other embodiments obtained by a person of ordinary skill in the art without creative work fall within the protection scope of the present application.

The example of the present application may be executed by a medical management device, and the medical management device may refer to a device such as an intelligent terminal, a server, a computer, or a medical service terminal. The example of the present application can be applied to the medical data management scenario. In one embodiment, the embodiment of the present application can be applied to implement information management between multiple hospitals. Taking the implementation of information management between two hospitals as an example, the medical The management device can obtain the medical-related data table (identified as data table 1) from the hospital Y1 information management system, the medical-related data table 2 from the hospital Y1 information management system, and obtain the data table 1 and data The type of Table 2, when the type of data table 1 (ie the first data table) matches the type of data table 2 (ie the second data table), for example, the types of data table 1 and data table 2 are both consultation data tables, Or both are drug data sheets, merge data sheet 1 and data sheet 2 to obtain the target data sheet, and correct the target data sheet to obtain the corrected target data sheet, such as deleting duplicate data in the target data sheet 3. Add the default field and the data corresponding to the default field to obtain the corrected data table. Through this target data table, you can query the medical data of at least two hospitals. Information management between hospitals, when doctors or patients need to query information, there is no need to switch back and forth between the information management systems of multiple hospitals, which improves the convenience of querying medical data and the efficiency of querying medical data, for example, patients It is necessary to compare the charge price of a drug in hospital Y1 and hospital Y2. The doctor can directly query the charge price of the drug in the two hospitals from the corrected data table. And by correcting the target data table, the storage space of the medical management device can be saved, and the efficiency of querying medical data can be further improved.

In another embodiment, the embodiments of the present application may be applied to information management within a hospital. For example, a medical management device may obtain at least two data tables from the information management system of the hospital Y3. Taking two data tables as an example Note that if the acquired data table is data table 3 (ie the first data table) and data table 4 (ie the second data table), the type of data table 3 and data table 4 acquired by the medical management device, for example, data table 3 is The consultation data table, data table 4 is the medical insurance reimbursement data table. Because the consultation data table and the medical insurance reimbursement data table both include the identity information of the patient, there are the same field information in data table 3 and data table 4 to determine the type of data table 3 Match the data table 4 type, merge data table 3 and data table 4 to obtain the target data table, and correct the target data table to obtain the corrected target data table, such as deleting duplicate data in the target data table, Add the default field and the data corresponding to the default field to obtain the corrected data table, through which the medical data in at least two data tables can be queried Data realizes the internal information management of the hospital. When doctors or patients need to query information, there is no need to switch between multiple data tables, which improves the convenience of querying medical data and the efficiency of querying medical data. For example, patients need When inquiring the consultation information and medical insurance reimbursement information, you can directly query the consultation information and medical insurance reimbursement information in the corrected data table. And by correcting the target data table, the storage space of the medical management device can be saved, and the efficiency of querying medical data can be further improved.

Please refer to FIG. 1, which is a schematic flowchart of a data processing method provided in an embodiment of the present application. The method in the embodiment of the present application may be performed by the medical management device mentioned above. In this embodiment, the data processing method includes the following steps.

S101. Acquire at least two data tables from an information management system of at least one hospital, where the at least two data tables include a first data table and a second data table.

In order to achieve information management between multiple hospitals, that is, to achieve medical data sharing between hospitals, medical management equipment can obtain at least two data tables from the information management system of multiple hospitals, or, in order to achieve medical data within the hospital Effective management, medical management equipment can obtain at least two data tables from a hospital ’s information relationship system, where the hospital ’s information management system includes multiple data tables, including, for example, consultation data tables, medical insurance reimbursement data tables, medicines Data sheets, medical consumables data sheets or doctor basic information data sheets, etc.

In one embodiment, when the medical management device acquires at least two data tables from the information management systems of multiple hospitals, in order to implement information management for a hospital in a certain area, the medical management device may be subordinate to the hospital in the same area The information management system obtains at least two data tables, specifically, obtains the address information of multiple hospitals, selects the hospitals belonging to the target area based on the address information of the multiple hospitals, and obtains at least two from the information management system of the hospitals in the target area Data table, for example, in order to analyze the medicine information in the area A, the medical management device can filter out the hospitals belonging to the area A based on the address information of multiple hospitals, and obtain at least two from the information management system of the hospital in the area A Drug data sheet.

In another embodiment, in order to achieve information management for hospitals at the same level, the medical management device may obtain the level information of multiple hospitals, and screen out the hospitals belonging to the target level according to the level information of the multiple hospitals, and the sub-level belongs to the target Obtain at least two data tables in the information management system of the hospital of the same level. For example, in order to share the case of a third-level A-level hospital, the hospital management equipment can screen out the hospitals belonging to the third-level A-level hospital based on the information of multiple hospitals. Two medical data sheets.

In one embodiment, in order to improve data security, the medical management device can authenticate the user when acquiring the data table. Specifically, a request to obtain the data table is sent to the hospital information management system, and the request carries user information. In order for the hospital information management system to judge whether the user has the authority to obtain the data table based on the user information, receive the verified information sent by the hospital information management system, and enter the hospital information management system to obtain at least two data tables. The user information may be Refers to the account information of the user's login to the hospital's information management system, the user's face image or the device identification of the medical management device, etc.

In one embodiment, in order to realize automatic management of the data table of the hospital, the medical management device may monitor the number of data tables of the information management system of the hospital. When the data of the information management system of the hospital is expressed to a preset number, Obtain at least two data tables from the hospital's information management system for orderly management of the data tables in the hospital's information management system. The preset number can be set manually by the user or according to the storage capacity of the medical management device Dynamically set.

S102. Determine the types of the first data table and the second data table.

The medical management device may determine the type of the first data table according to the name of the first data table and / or the field information in the first data table and / or the data in the first data table, etc. Similarly, according to the second The name of the data table and / or the field information in the second data table and / or the data in the second data table, etc. determine the type of the second data table. The types of data sheets include medicines, visits, charges, or identity information, etc. The data sheets of medicines include inventory medicine data sheets or sales medicine data sheets, etc. The visit data sheets include hospitalization data sheets or discharge data sheets, etc. The charge data table includes a treatment cost data table or a medical reimbursement data table, etc., and the identity information data table includes a patient identity information data table, a doctor identity information data table, etc.

S103. When the type of the first data table matches the type of the second data table, merge the first data table and the second data table to obtain a target data table.

Compare the type of the first data table with the type of the second data table, and when the type of the first data table is the same as or similar to the type of the second data table, determine the type of the first data table and the type of the second data table The types match, and the first data table and the second data table are merged in a row merge manner or a column merge manner to obtain a target data table. In one embodiment, combining the first data table and the second data in a row merge manner to obtain the target data table includes: obtaining the arrangement of the field information of the first data table and the second data table, when the first data table The field information is arranged in a row arrangement, and the field information in the second data table is arranged in a column, then the field information arrangement in the second data table and the data arrangement in the second data table are adjusted. Obtain the adjusted second data table, and add the adjusted second data table to the first data table to obtain the target data table. For example, the first data table and the second data table are drug data tables. As shown in Table 1, the field information of the first data table includes the name of the drug, the code of the drug, the manufacturer of the drug, and the production batch of the drug. The field information of the table is arranged in rows; as shown in Table 2, the field information of the second data table includes the name of the drug, the code of the drug, the manufacturer of the drug, the production batch of the drug, the field information of the second data table It is arranged in a column arrangement, and the field information arrangement and data arrangement of the second data table are adjusted to obtain an adjusted second data table, and the adjusted second data table is added to the first data table The target data table is obtained in. The target data table is shown in Table 3. The field information of the target data packet is arranged in a column arrangement.

Table 1

Drug Name	Drug Code	Pharmaceutical manufacturers	Production batch of drugs	Number of drugs
A	10	D1	P1	20 boxes
…	…	…	…	…

Table 2

Drug Name	B	…
Drug Code	11	…
Pharmaceutical manufacturers	D2	…
Production batch of drugs	P2	…
Number of drugs	10 pcs	…

table 3

Drug Name	Drug Code	Pharmaceutical manufacturers	Production batch of drugs	Number of drugs
A	10	D1	P1	20 boxes
B	10	D2	P2	10 pcs
…	…	…	…	…

Table 4

Drug Name	B	A	…
Drug Code	11	10	…
Pharmaceutical manufacturers	D2	D1	…
Production batch of drugs	P2	P1	…
Number of drugs	10 pcs	20 boxes	…

In an embodiment, combining the first data table and the second data in a column merge manner to obtain the target data table includes: obtaining the arrangement of the field information of the first data table and the second data table, when the first data table The field information is arranged in a row, and the field information in the second data table is arranged in a column. Then, the field information in the first data table and the data in the first data table are adjusted. Obtain the adjusted first data table, and add the adjusted first data table to the second data table to obtain the target data table. For example, the first data table is the above table 1, the second data table is the above table 2, the field information of the first data table is arranged in a row arrangement; the field information of the second data table is arranged in a column arrangement, Adjust the arrangement of the field information of the first data table and the arrangement of the data to obtain the adjusted first data table, add the adjusted first data table to the second data table to obtain the target data table, the target The data table is shown in Table 4. The field information of the target data packet is arranged in a column arrangement.

S104. Perform correction processing on the data in the target data table according to the attribute characteristics of the data in the target data table to obtain the corrected target data table. The attribute characteristics of the data in the target data table include any one or more of the following: data Field information, data format information, and the number of times the data appears.

In order to further optimize the management data table, the medical management device can correct the data in the target data table according to the attribute characteristics of the target data table to obtain the corrected target data table. Specifically, the medical management device can adjust the data in the target data table. The attribute characteristics determine the abnormal data in the target data table, such as erroneous data, default data, worthless data, repeated data, malformed data, etc., and correct the abnormal data to obtain the corrected target data table. Valueless data refers to data that has no direct or indirect relationship to medical research. For example, the patient's mother tongue is included in the consultation data table, and the patient's mother tongue does not have practical significance for case analysis. Therefore, the patient's mother tongue is worthless data. Wrong data refers to data with incorrect text or data that does not have a matching relationship with other data, for example, patient information (such as ID number) in the medical information table and patient information (such as ID number) in the medical insurance data table ) Does not match, indicating that the patient information in the consultation information table and / or the patient identification information in the medical insurance data table is wrong data; another example, the administration method of a drug in the consultation data table and the drug in the drug data table A mismatch in the administration method indicates that the administration method of a drug in the consultation data table and / or the administration method of the drug in the drug data table is wrong data.

In one embodiment, the medical management device may share the corrected target data table to at least one hospital information management system or user terminal. For example, the medical management device may send the corrected target data table to the first The information management system of the hospital corresponding to one data table and the information management system of the hospital corresponding to the second data table can realize the sharing of medical data between hospitals.

In the embodiment of the present application, there is no need to switch back and forth between multiple data tables, which improves the convenience of querying medical data and the efficiency of querying medical data; and by correcting the target data table, the corrected target data is obtained Table can save the storage space of medical management equipment, and further improve the efficiency of querying medical data.

Please refer to FIG. 2, which is a schematic flowchart of another data processing method provided by an embodiment of the present application. The method of the embodiment of the present application may be performed by the medical management device mentioned above. In this embodiment, the data processing method includes the following steps.

S201. Acquire at least two data tables from the information management system of at least one hospital, where the at least two data tables include a first data table and a second data table.

S202. Acquire the name of the first data table and the name of the second data table.

S203. Determine the type of the first data table according to the name of the first data table, and determine the type of the second data table according to the name of the second data table.

Steps S202 to S203, the medical management device can determine the type of the data table according to the name of the data table. Specifically, the medical management device can obtain the name of the first data table and the name of the second data table, and determine it according to the name of the first data table The type of the first data table, and the type of the second data table is determined according to the name of the second data table. For example, when the name of the first data table is a medicine data table, it indicates that the type of the first data table is a medicine data table, and when the name of the second data table is a medical expense data table, it indicates that the second data table is charge data table.

In one embodiment, determining the type of the data table includes: acquiring the field information of the first data table and the field information in the second data table, determining the type of the first data table according to the field information in the first data table and according to the first The field information of the second data table determines the type of the second data table.

The medical management device can determine the type of the data table according to the field information of the data table, specifically, obtain the field information of the first data table and the field information in the second data table, and determine the first data according to the field information in the first data table The type of the table and the type of the second data table are determined according to the field information of the second data table. For example, when it is detected that the field information in the first data table includes the name of the drug, the place of origin of the drug, the batch of the drug, etc. The first data table is a medicine data table. When the field information of the second data includes medical reimbursement expenses, insured persons and reimbursement time information, the second data table is determined to be a charge data table.

In one embodiment, the medical management device stores a mapping relationship between the field information and the type of the data table, and obtains the type of data according to the mapping relationship. Specifically, the medical management device may use the field information of the first data table and the field The mapping relationship between the information and the data table type determines the type of the first data table. Similarly, the medical management device can determine the type of the second data table using the field information of the second data table and the mapping relationship between the field information and the type of the data table.

S204. When the type of the first data table matches the type of the second data table, merge the first data table and the second data table to obtain a target data table.

S205. Perform correction processing on the data in the target data table according to the attribute characteristics of the data in the target data table to obtain the corrected target data table. The attribute characteristics of the data in the target data table include any one or more of the following: data Field information, data format information, and the number of times the data appears.

In one embodiment, the attribute characteristics of the data include field information of the data; step S205 includes: obtaining field information of all data in the target data table, the field information includes multiple fields, and each field corresponds to multiple data ; According to the mapping relationship between the data table type and the field, determine the target field corresponding to the type of the target data table, when the field information does not include the target field, add the target field not included in the target data table; according to the field Mapping relationship with data, obtain a plurality of data corresponding to the unincluded target field from the database of the information management system, and add the multiple data to the position corresponding to the unincluded target field in the target data table to obtain Corrected target data table.

In order to ensure the integrity of the data table, the medical management device can determine whether the necessary fields are missing in the target data table, and make corresponding processing according to the judgment result. Specifically, obtain the field information of all the data in the target data table, according to the fields and data Mapping relationship, from the database of the information management system, when the field information does not include the target field, indicating that the target data table lacks the necessary fields, add the target field in the target data table; according to the mapping relationship between the field and the data Obtain multiple data corresponding to the target field from the database of the information management system, add the multiple data to the position corresponding to the target field in the target data table, and obtain the corrected target data table. The target field is determined according to the type of the target data table. For example, the target data table is a drug data table. The necessary fields of the target data table include the drug name, drug code, drug manufacturer, and drug production batch. The target data table may also include non-essential fields, such as the different name of the drug or the image of the drug.

In one embodiment, the target data table includes first data and second data. The first data and the second data belong to the same field. The attribute characteristics of the data include the format information of the data. Step S205 includes: acquiring the first data. The format information and the format information of the second data, when the format information of the first data does not match the format information of the second data, the second data in the target data table is adjusted according to the format information of the first data to obtain a correction process After the target data table; or, when the format of the first data and the format of the second data are inconsistent, adjust the first data in the target data table according to the format information of the second data to obtain the corrected target data table .

In order to unify the format of the data in the target data table, the medical management device can normalize the format of the data table. Specifically, the format information of the first data and the format information of the second data are obtained when the first data When the format information of the data and the format information of the second data do not match, it indicates that the format of the first data is inconsistent with the format of the second data. According to the format information of the first data, the second data in the target data table is adjusted to obtain a correction After the target data table; or, when the format of the first data and the format of the second data are inconsistent, adjust the first data in the target data table according to the format information of the second data to obtain the corrected target data table .

For example, the first data is time information, the format of the first data is 18-08-08, the second data is time information, the format of the second data is 2018-08-09, it can be seen that the format of the first data The information does not match the format information of the second data. Adjust the first data according to the format information of the second data to obtain the adjusted first data. The adjusted first data is 2018-08-08. Replaces the first data in the target data table to obtain the corrected target data table.

In one embodiment, when the format information of the first data does not match the format information of the second data, the standard format corresponding to the first data and the second data is acquired, and the format of the first data and the second data is adjusted to the standard The format is the target data table after correction processing. The standard format may refer to a format with a frequency of use greater than a preset frequency or a recognized format.

In one embodiment, the format information may refer to a unit of measurement. Specifically, the unit of measurement for the first data and the second data is obtained. When the unit of measurement for the first data is not consistent with the unit of measurement for the second data, the The unit of measurement adjusts the first data to obtain the corrected target data table, or adjusts the second data according to the unit of measurement of the first data to obtain the corrected target data table. For example, the first data is the number of medicines, the first data is 2 boxes, the second data is also the number of medicines, and the second data is 10, the measurement unit (box) of the first data and the measurement of the second data The unit (branch) is different. Adjust the second data according to the measurement unit of the first data to obtain the corrected target data table. For example, the second data corresponds to 5 medicines / box, and the second data corresponds to 2 medicines. , So the second data is adjusted to 2 boxes.

In one embodiment, in order to realize the standardization of drug prices, the characteristic information of the data includes price information, and the target data table includes third data. The third data is the drug price data, and the third data is obtained. When the price is greater than the preset price, the price of the drug in multiple regions or the prices of multiple hospitals is obtained, and the average price is obtained according to the obtained price, and the average price is replaced with the third data in the target data table, after correction processing Target data sheet.

In one embodiment, the target data table includes data of the target object, and the attribute characteristics of the data include the number of occurrences of the data; Step S205 includes: obtaining the number of occurrences of the target data of the target object, the target data being the target object's Any one of the data, when the number of occurrences of the target data is greater than the first value, delete the second value target data of the target data table to obtain the corrected target data table, the second value is based on the first value And the number of occurrences of the target data is determined.

In order to avoid redundant data in the target data table, the medical management device can delete duplicate data. Specifically, obtain the number of times the target data of the target object appears. When the number of times the target data appears is greater than the first value, it indicates the target data table If there is duplicate data in the data, you can delete the second value target data of the target data table to obtain the corrected target data table. The second value is determined according to the first value and the number of times the target data appears. The specific content represented by the target object in different data tables is inconsistent. For example, in the drug data table, the target object may refer to a certain medicine, and in the identity information, the target object may refer to a certain patient.

For example, in order to ensure the security of the data, the same multiple target data can be retained in the data table, for example, two target data can be retained. For example, if the target data appears 4 times, delete 2 from the target data table Target data, and retain 2 target data to get the corrected target data table, the reason for retaining multiple target data is that when a certain target data is wrong, it can still be obtained from the corrected target data table Correct target data.

In one embodiment, the attribute characteristics of the data include the field information and format information of the data; step S205 includes: acquiring the field information and format information of the target data in the target data table, the target data being the data in the data table Any data; determine the first type of the target data according to the field information of the target data; determine the second type of the target data according to the format information of the target data; when the first type and the first When the two types are different, the target data is corrected according to the field information of the target data to obtain a corrected target data table.

The medical management equipment can correct the wrong data in the target data table. Specifically, obtain the field information and format information of the target data in the target data table, and determine the first type of target data according to the field information of the target data; The format information determines the second type of target data; when the first type is different from the second type, it indicates that the target data has an error, and the target data is corrected according to the field information of the target data to obtain the corrected target data table. For example, the field information of the target data obtained is the hospital address, and the format information of the target data is obtained. The format information of the target data is XXX hospital. According to the format information of the target data, the first type of target data is determined to be the address class. The format information of the data determines that the second type of the target data is the name class. The first type is different from the second type. According to the field information of the target data, the address of the hospital is obtained, and the target data is replaced with the address of the hospital. Target data sheet.

In one embodiment, after step S205, it further includes: receiving an instruction to share the corrected target data table to the target hospital's information management system. The target hospital's information management system is any of at least one hospital's information management system The hospital's information management system shares the corrected target data table to the target hospital's information management system according to the instructions.

The medical management device receives the instruction to share the corrected target data table to the target hospital's information management system, and shares the corrected processed target data table to the target hospital's information management system according to the instruction, which can data sharing.

In the embodiment of the present application, there is no need to switch back and forth between multiple data tables, which improves the convenience of querying medical data and the efficiency of querying medical data; and by correcting the target data table, the corrected target data is obtained Table can save the storage space of medical management equipment, and further improve the efficiency of querying medical data.

Please refer to FIG. 3, which is a schematic structural diagram of a data processing apparatus provided by an embodiment of the present application. The apparatus of the embodiment of the present application may be in the medical management device mentioned above. In this embodiment, the data processing device includes:

The obtaining module 301 is configured to obtain at least two data tables from the information management system of at least one hospital, where the at least two data tables include a first data table and a second data table.

The determining module 302 is configured to determine the types of the first data table and the second data table.

The merging module 303 is configured to merge the first data table and the second data table to obtain a target data table when the type of the first data table matches the type of the second data table.

The correction module 304 is configured to perform correction processing on the data in the target data table according to the attribute characteristics of the data in the target data table to obtain the corrected target data table, and the attribute characteristics of the data in the target data table Include any one or more of the following: data field information, data format information, and the number of times the data appears.

Optionally, the determining module 302 is specifically configured to acquire the name of the first data table and the name of the second data table; determine the type of the first data table according to the name of the first data table, and Determine the type of the second data table according to the name of the second data table; or, obtain the field information of the first data table and the field information in the second data table; according to the first data table The field information in determines the type of the first data table and determines the type of the second data table according to the field information of the second data table.

Optionally, the attribute characteristics of the data include field information of the data; the correction module 303 is specifically used to obtain field information of all data in the target data table. The field information includes multiple fields, each Corresponding to each data; according to the mapping relationship between the data table type and the field, determine the target field corresponding to the type of the target data table, when the field information does not include the target field, add the unincluded to the target data table The target field, the target field is determined according to the type of the target data table; according to the mapping relationship between the field and the data, a plurality of data corresponding to the target field are obtained from the database of the information management system, Adding the plurality of data to the position corresponding to the target field in the target data table to obtain the corrected target data table.

Optionally, the target data table includes first data and second data, the first data and the second data belong to the same field, and the attribute characteristics of the data include format information of the data; the correction module 303 , Specifically used to obtain the format information of the first data and the format information of the second data; when the format information of the first data does not match the format information of the second data, according to the first The format information of the data adjusts the second data in the target data table to obtain the corrected target data table; or, when the format information of the first data does not match the format information of the second data , Adjust the first data in the target data table according to the format information of the second data to obtain the corrected target data table.

Optionally, the target data table includes data of the target object, and the attribute characteristics of the data include the number of occurrences of the data; the correction module 303 is specifically configured to obtain the number of occurrences of the target data of the target object, the target The data is any one of the data of the target object; when the number of occurrences of the target data is greater than the first value, the second value of the target data table and the target data are deleted to obtain the corrected target In the data table, the second value is determined according to the first value and the number of occurrences of the target data.

Optionally, the attribute characteristics of the data include field information and format information of the data; the correction module 303 is specifically used to obtain field information and format information of the target data in the target data table, and the target data is the data Any data in the table; determine the first type of the target data according to the field information of the target data; determine the second type of the target data according to the format information of the target data; when the first type is The second types are different, and the target data is corrected according to the field information of the target data to obtain a target data table after correction processing.

Optionally, the receiving module 305 is configured to receive an instruction to share the corrected target data table to an information management system of a target hospital, where the information management system of the target hospital is the information management system of the at least one hospital Any hospital information management system.

Optionally, the sharing module 306 is configured to share the corrected target data table to the target hospital information management system according to the instruction.

In the embodiment of the present application, by combining the first data table and the second data table of the matching type into the target data table, information management between hospitals or internal information management of the hospital can be realized. When querying medical data, no Need to switch back and forth between multiple data tables, which improves the convenience of querying medical data and the efficiency of querying medical data; and by correcting the target data table to obtain the corrected target data table, it can save medical management equipment The storage space further improves the efficiency of querying medical data.

Please refer to FIG. 4, which is a schematic structural diagram of a medical management device according to an embodiment of the present application. As shown in the figure, the medical management device in this embodiment may include: one or more processors 401; one or more inputs Device 402, one or more output devices 403 and memory 404. The processor 401, the input device 402, the output device 403, and the memory 404 are connected via a bus 405.

The processor 401 may be a central processing unit (Central Processing Unit, CPU), the processor may also be other general-purpose processors, digital signal processors (Digital Signal Processor, DSP), application specific integrated circuits (Application Specific Integrated Circuit, ASIC ), Ready-made programmable gate array (Field-Programmable GateArray, FPGA) or other programmable logic devices, discrete gate or transistor logic devices, discrete hardware components, etc. The general-purpose processor may be a microprocessor or the processor may be any conventional processor or the like.

The input device 402 may include a touch pad, a fingerprint sensor (for collecting user's fingerprint information and fingerprint direction information), a microphone, etc., the output device 403 may include a display (LCD, etc.), a speaker, etc. The output device 403 may output correction The processed target data table.

The memory 404 may include a read-only memory and a random access memory, and provide instructions and data to the processor 401. A part of the memory 404 may further include a non-volatile random access memory, the memory 404 is used to store a computer program, the computer program includes program instructions, and the processor 401 is used to execute the program instructions stored in the memory 404 to be used to execute a Data processing method, namely for performing the following operations: acquiring at least two data tables from an information management system of at least one hospital, the at least two data tables including a first data table and a second data table; determining the first Types of the data table and the second data table; when the type of the first data table matches the type of the second data table, merge the first data table and the second data table to obtain the target Data table; correcting the data in the target data table according to the attribute characteristics of the data in the target data table to obtain the corrected target data table, the attribute characteristics of the data in the target data table include any of the following One or more items: data field information, data format information, and the number of times the data appears.

Optionally, the processor 401 is used to execute the program instructions stored in the memory 404 for performing the following operations: acquiring the name of the first data table and the name of the second data table; according to the The name determines the type of the first data table, and determines the type of the second data table according to the name of the second data table; or, obtains the field information of the first data table and the second data table Field information in; determining the type of the first data table according to the field information in the first data table and determining the type of the second data table according to the field information in the second data table.

Optionally, the attribute characteristics of the data include field information of the data; the processor 401 is used to execute program instructions stored in the memory 404, and is used to perform the following operations: obtain field information of all data in the target data table, the Field information Multiple fields, one field corresponds to multiple data; according to the mapping relationship between the data table type and the field, determine the target field corresponding to the type of the target data table, when the field information of all data in the target data table The target field is not included in the target data table, and the target field that is not included is added to the target data table; according to the mapping relationship between the field and the data, a plurality of data corresponding to the target field are obtained from the database of the information management system , Add the plurality of data to the position corresponding to the target field in the target data table to obtain the corrected target data table.

Optionally, the target data table includes first data and second data, the first data and the second data belong to the same field, and the attribute characteristics of the data include format information of the data; the processor 401 Used to execute the program instructions stored in the memory 404 for performing the following operations: acquiring the format information of the first data and the format information of the second data; when the format information of the first data and the second data When the format information of does not match, adjust the second data in the target data table according to the format information of the first data to obtain a target data table after correction processing; or, when the format information of the first data When the format information of the second data does not match, the first data in the target data table is adjusted according to the format information of the second data to obtain a target data table after correction processing.

Optionally, the target data table includes data of the target object, and the attribute characteristics of the data include the number of occurrences of the data; the processor 401 is used to execute the program instructions stored in the memory 404, and is used to perform the following operations: obtain the The number of times the target data of the target object appears, and the target data is any one of the data of the target object; when the number of times the target data occurs is greater than the first value, the second value of the target data table is deleted Each of the target data, a target data table after correction processing is obtained, and the second value is determined according to the first value and the number of occurrences of the target data.

Optionally, the attribute characteristics of the data include field information and format information of the data; the processor 401 is used to execute program instructions stored in the memory 404, and is used to perform the following operations: obtain field information of target data in the target data table And format information, the target data is any data in the data table; determine the first type of the target data according to the field information of the target data; determine the target data according to the format information of the target data The second type; when the first type is different from the second type, correct the target data according to the field information of the target data to obtain a corrected target data table.

Optionally, the processor 401 is used to execute the program instructions stored in the memory 404 for performing the following operation: receiving an instruction to share the corrected target data table to the information management system of the target hospital, the target hospital ’s The information management system is an information management system of any hospital in the information management system of the at least one hospital; the target data table after the correction processing is shared with the information management system of the target hospital according to the instruction.

The processor 401, the input device 402, and the output device 403 described in the embodiments of the present application can execute the implementation manners described in the first and second embodiments of the data processing method provided by the embodiments of the present application, and can also be executed The implementation of the medical management device described in the embodiments of the present application will not be repeated here.

In the embodiment of the present application, by combining the first data table and the second data table of the matching type into the target data table, information management between hospitals or internal information management of the hospital can be realized. When querying medical data, no Need to switch back and forth between multiple data tables, which improves the convenience of querying medical data and the efficiency of querying medical data; and by correcting the target data table to obtain the corrected target data table, it can save medical management equipment The storage space further improves the efficiency of querying medical data.

An embodiment of the present application also provides a computer-readable storage medium, where the computer-readable storage medium stores a computer program, and the computer program includes program instructions, which are implemented by a processor as shown in FIG. 1 and FIG. 2 The data processing method shown in the embodiment.

In the several embodiments provided in this application, it should be understood that the disclosed control device and method may be implemented in other ways. For example, the device embodiments described above are schematic. For example, the division of the unit may be a logical function division. In actual implementation, there may be another division manner, for example, multiple units or components may be combined or may Integration into another system, or some features can be ignored, or not implemented. The above is only the specific implementation of this application, but the scope of protection of this application is not limited to this, any person skilled in the art can easily think of various equivalent modifications within the technical scope disclosed in this application Or replacement, these modifications or replacements should be covered within the scope of protection of this application. Therefore, the protection scope of the present application shall be subject to the protection scope of the claims.

Claims (20)

1. A data processing method, including:

   Acquiring at least two data tables from the information management system of at least one hospital, the at least two data tables including a first data table and a second data table;

   Determine the types of the first data table and the second data table;

   When the type of the first data table matches the type of the second data table, merge the first data table and the second data table to obtain a target data table;

   Correcting the data in the target data table according to the attribute characteristics of the data in the target data table to obtain the corrected target data table, the attribute characteristics of the data in the target data table include any one of the following or Multiple items: data field information, data format information, and the number of data occurrences.
2. The method according to claim 1, wherein the determining the types of the first data table and the second data table comprises:

   Obtain the name of the first data table and the name of the second data table; determine the type of the first data table according to the name of the first data table, and determine the name based on the name of the second data table Describe the type of the second data table; or,

   Obtain the field information of the first data table and the field information of the second data table; determine the type of the first data table according to the field information of the first data table and according to the second data table The field information of determines the type of the second data table.
3. The method according to claim 1 or 2, wherein the attribute characteristic of the data includes field information of the data;

   The correcting the data in the target data table according to the attribute characteristics of the data in the target data table to obtain the corrected target data table includes:

   Obtain field information of all data in the target data table, where the field information includes multiple fields, and each field corresponds to multiple data;

   According to the mapping relationship between the data table type and the field, determine the target field corresponding to the type of the target data table. When the field information of all data in the target data table does not include the target field, the target data Add the target field not included in the table;

   According to the mapping relationship between the field and the data, obtain a plurality of data corresponding to the unincluded target field from the database of the information management system, and add the plurality of data to the target data table. The corresponding position of the target field of the target data table is obtained after the correction process.
4. The method according to claim 1 or 2, wherein the target data table includes first data and second data, the first data and the second data belong to the same field, and the data Attribute characteristics include data format information;

   The correcting the data in the target data table according to the attribute characteristics of the data in the target data table to obtain the corrected target data table includes:

   Acquiring format information of the first data and format information of the second data;

   When the format information of the first data does not match the format information of the second data, the second data in the target data table is adjusted according to the format information of the first data to obtain the corrected Target data sheet; or,

   When the format information of the first data does not match the format information of the second data, the first data in the target data table is adjusted according to the format information of the second data to obtain the corrected Target data sheet.
5. The method according to claim 1 or 2, wherein the target data table includes data of a target object, and the attribute characteristic of the data includes the number of times the data appears;

   The correcting the data in the target data table according to the attribute characteristics of the data in the target data table to obtain the corrected target data table includes:

   Acquiring the number of occurrences of the target data of the target object, the target data being any one of the data of the target object;

   When the number of occurrences of the target data is greater than the first value, delete the second value of the target data table and the target data to obtain the corrected target data table, the second value is based on the first The value and the number of occurrences of the target data are determined.
6. The method according to claim 1 or 2, wherein the attribute characteristics of the data include field information and format information of the data;

   The correcting the data in the target data table according to the attribute characteristics of the data in the target data table to obtain the corrected target data table includes:

   Acquiring field information and format information of target data in the target data table, the target data is any data in the data table;

   Determine the first type of the target data according to the field information of the target data;

   Determine the second type of the target data according to the format information of the target data;

   When the first type is different from the second type, the target data is corrected according to the field information of the target data to obtain a corrected target data table.
7. The method according to claim 1 or 2, wherein the correction processing is performed on the data in the target data table according to the attribute characteristics of the data in the target data table to obtain the corrected target data table , Also includes:

   Receiving an instruction to share the corrected target data table to an information management system of a target hospital, the information management system of the target hospital is an information management system of any hospital in the information management system of the at least one hospital;

   Share the corrected target data table to the information management system of the target hospital according to the instruction.
8. The method according to claim 1, wherein the obtaining at least two data tables from the information management system of at least one hospital includes:

   Obtain the address information of multiple hospitals, and screen out the hospitals belonging to the target area based on the address information of the multiple hospitals;

   Obtain at least two data tables from the information management system of the hospital in the target area.
9. The method according to claim 1, wherein the obtaining at least two data tables from the information management system of at least one hospital includes:

   Obtain the rank information of multiple hospitals, and screen out the hospitals belonging to the target rank according to the rank information of the multiple hospitals;

   Acquire at least two data tables from the information management system of the hospital whose rank belongs to the target rank.
10. A data processing device, including:

    An obtaining module, configured to obtain at least two data tables from an information management system of at least one hospital, the at least two data tables including a first data table and a second data table;

    A determining module, configured to determine the types of the first data table and the second data table;

    A merging module, configured to merge the first data table and the second data table to obtain a target data table when the type of the first data table matches the type of the second data table;

    A correction module, configured to perform correction processing on the data in the target data table according to the attribute characteristics of the data in the target data table to obtain a corrected target data table, and the attribute characteristics of the data in the target data table include Any one or more of the following: data field information, data format information, and the number of times the data appears.
11. The apparatus according to claim 10, wherein the determining module is specifically configured to acquire the name of the first data table and the name of the second data table; determine according to the name of the first data table The type of the first data table, and determining the type of the second data table according to the name of the second data table; or, acquiring the field information of the first data table and the information in the second data table Field information; determine the type of the first data table according to the field information in the first data table and determine the type of the second data table according to the field information of the second data table.
12. The device according to claim 10 or 11, wherein the attribute characteristic of the data includes field information of the data;

    The correction module is specifically used to obtain field information of all data in the target data table, the field information includes multiple fields, each field corresponds to multiple data; according to the mapping relationship between the data table type and the field, it is determined When the target field corresponding to the type of the target data table does not include the target field in the field information of all data in the target data table, add the unincluded target field to the target data table; According to the mapping relationship between the field and the data, obtain a plurality of data corresponding to the unincluded target field from the database of the information management system, and add the plurality of data to the target data table. The corresponding position of the target field of the target data table is obtained after the correction process.
13. The device according to claim 10 or 11, wherein the target data table includes first data and second data, the first data and the second data belong to the same field, and the Attribute characteristics include data format information;

    The correction module is specifically used to obtain the format information of the first data and the format information of the second data; when the format information of the first data does not match the format information of the second data, according to The format information of the first data adjusts the second data in the target data table to obtain a corrected target data table; or, when the format information of the first data and the format of the second data When the information does not match, the first data in the target data table is adjusted according to the format information of the second data to obtain the corrected target data table.
14. The apparatus according to claim 10 or 11, wherein the target data table includes data of a target object, and the attribute characteristic of the data includes the number of times the data appears;

    The correction module is specifically used to obtain the number of occurrences of the target data of the target object, the target data is any one of the data of the target object; when the number of occurrences of the target data is greater than the first value , Delete the second value of the target data table and the target data to obtain a corrected target data table, the second value is determined according to the first value and the number of times the target data appears.
15. The device according to claim 10 or 11, wherein the attribute characteristics of the data include field information and format information of the data;

    The correction module is specifically used to obtain the field information and format information of the target data in the target data table, and the target data is any data in the data table; determine the field according to the field information of the target data The first type of target data; determining the second type of target data according to the format information of the target data; when the first type is different from the second type, according to the field information of the target data The target data is corrected to obtain a target data table after correction processing.
16. The device according to claim 10 or 11, wherein the device further comprises:

    A receiving module, configured to receive an instruction to share the corrected target data table to an information management system of a target hospital, the information management system of the target hospital is any hospital in the information management system of the at least one hospital Information management system;

    The sharing module is used for sharing the corrected target data table to the target hospital information management system according to the instruction.
17. A medical management device, comprising: a processor and a memory, the processor and the memory are interconnected; wherein the memory stores one or more instructions, the one or more instructions are suitable for The processor loads and executes the following steps: obtaining at least two data tables from the information management system of at least one hospital, the at least two data tables including a first data table and a second data table; determining the first data The type of the table and the second data table; when the type of the first data table matches the type of the second data table, merge the first data table and the second data table to obtain target data Table; correcting the data in the target data table according to the attribute characteristics of the data in the target data table to obtain the corrected target data table, the attribute characteristics of the data in the target data table include any of the following One or more items: data field information, data format information, and the number of times the data appears.
18. The device according to claim 17, wherein the processor is specifically configured to acquire the name of the first data table and the name of the second data table; determined according to the name of the first data table The type of the first data table, and determining the type of the second data table according to the name of the second data table; or, acquiring the field information of the first data table and the information in the second data table Field information; determine the type of the first data table according to the field information in the first data table and determine the type of the second data table according to the field information of the second data table.
19. The device according to claim 17 or 18, wherein the processor specifically obtains field information of all data in the target data table, the field information includes multiple fields, each field and multiple data Correspondence; according to the mapping relationship between the data table type and the field, determine the target field corresponding to the type of the target data table, when the field information of all data in the target data table does not include the target field, in the Add the unincluded target field to the target data table; according to the mapping relationship between the field and the data, obtain multiple data corresponding to the unincluded target field from the database of the information management system, and combine the multiple The data is added to the position corresponding to the target field not included in the target data table to obtain the corrected target data table.
20. A computer-readable storage medium, characterized in that the computer-readable storage medium stores one or more instructions, the one or more instructions are adapted to be loaded by a processor and execute any of claims 1-7 Item.

Images