CN113704250A - Data batch processing method suitable for medical data - Google Patents
Data batch processing method suitable for medical data Download PDFInfo
- Publication number
- CN113704250A CN113704250A CN202110805494.0A CN202110805494A CN113704250A CN 113704250 A CN113704250 A CN 113704250A CN 202110805494 A CN202110805494 A CN 202110805494A CN 113704250 A CN113704250 A CN 113704250A
- Authority
- CN
- China
- Prior art keywords
- data
- standard
- value
- processing method
- batch processing
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
- 238000003672 processing method Methods 0.000 title claims abstract description 23
- 238000013507 mapping Methods 0.000 claims abstract description 29
- 238000000034 method Methods 0.000 claims abstract description 17
- 238000007689 inspection Methods 0.000 claims abstract description 11
- 238000006243 chemical reaction Methods 0.000 claims description 7
- 238000000605 extraction Methods 0.000 claims description 3
- 238000012986 modification Methods 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 238000012545 processing Methods 0.000 description 2
- 230000007547 defect Effects 0.000 description 1
- 238000001514 detection method Methods 0.000 description 1
- 238000010606 normalization Methods 0.000 description 1
- 238000011160 research Methods 0.000 description 1
- 238000012360 testing method Methods 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- 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
Abstract
The application discloses a data batch processing method suitable for medical data, which comprises the following steps: extracting the inspection data of the source table into the target table at regular time; acquiring data of each large inspection item from the target table, and converting the data into standard data according to the mapping relation between the original hospital standard data and the platform standard data; and synchronizing the standard data of each large item into each large item standard table. The method has the advantages that the data batch processing method which is convenient for calculation and prediction of the inspection data and is suitable for medical data is provided.
Description
Technical Field
The application relates to the field of data processing, in particular to a data batch processing method suitable for medical data.
Background
With the advancement of medical internet, medical data is well preserved, but the efficiency of real research and utilization is not high due to the regional problem of hospitals.
One of the key problems is that regional medical data is stored according to own standards, and data of different standards cannot be coordinated and associated. Particularly, in the prior art, hospital inspection data is generally stored according to a certain examination item, so that data inspection and calculation cannot be performed quickly, and the data utilization rate is reduced.
Disclosure of Invention
In order to solve the defects of the prior art, the application provides a data batch processing method suitable for medical data, which comprises the following steps: extracting the inspection data of the source table into the target table at regular time; acquiring data of each large inspection item from the target table, and converting the data into standard data according to the mapping relation between the original hospital standard data and the platform standard data; and synchronizing the standard data of each large item into each large item standard table.
Further, the method for establishing the mapping relationship between the original hospital standard data and the platform standard data comprises the following steps: a unified reference standard for data standardization is established and defined as an international value range; making an academy reference standard for data standardization, and defining the academy reference standard as a local value range; mapping the international value range and the local value range to establish a conversion mapping relation; and converting the medical data input according to the local value range into standardized data according to the international value range according to the conversion mapping relation.
Further, the international value range is established by setting a national standard value and corresponding national standard value description.
Further, the national standard value at least comprises Arabic numerals and Chinese characters.
Further, the method for establishing the mapping relationship between the original hospital standard data and the platform standard data further comprises the following steps:
and editing or deleting the national standard value or the national standard value description corresponding to the national standard value.
Further, the method for establishing the mapping relationship between the original hospital standard data and the platform standard data further comprises the following steps:
and importing a table file with the national standard value and the national standard value description.
Further, the method for establishing the mapping relationship between the original hospital standard data and the platform standard data further comprises the following steps: and the local value domain is established by setting a local value and a corresponding local value description.
Further, the place value includes at least an arabic numeral and a chinese character.
Further, the method for establishing the mapping relationship between the original hospital standard data and the platform standard data further comprises the following steps: editing or deleting the place value or the place value description corresponding to the place value.
Further, the batch processing method for data suitable for medical data further comprises the following steps: and setting the time frequency of the check data of the timing extraction source table to the target table.
The application has the advantages that: a data batch processing method suitable for medical data is provided which facilitates the calculation and prediction of test data.
Drawings
The accompanying drawings, which are incorporated in and constitute a part of this application, serve to provide a further understanding of the application and to enable other features, objects, and advantages of the application to be more apparent. The drawings and their description illustrate the embodiments of the invention and do not limit it. In the drawings:
FIG. 1 is a schematic illustration of steps of a data batch processing method for medical data according to an embodiment of the present application;
FIG. 2 is an interface for normalization in a method for batch processing of data for medical data according to an embodiment of the present application.
Detailed Description
In order to make the technical solutions better understood by those skilled in the art, the technical solutions in the embodiments of the present application will be clearly and completely described below with reference to the drawings in the embodiments of the present application, and it is obvious that the described embodiments are only partial embodiments of the present application, but not all embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present application.
It should be noted that the embodiments and features of the embodiments in the present application may be combined with each other without conflict. The present application will be described in detail below with reference to the embodiments with reference to the attached drawings.
Referring to fig. 1, the data batch processing method applicable to medical data of the present application includes the following steps: extracting the inspection data of the source table into the target table at regular time; acquiring data of each large inspection item from the target table, and converting the data into standard data according to the mapping relation between the original hospital standard data and the platform standard data; and synchronizing the standard data of each large item into each large item standard table.
Referring to fig. 2, the method for establishing the mapping relationship between the original hospital standard data and the platform standard data includes the following steps: a unified reference standard for data standardization is established and defined as an international value range; making an academy reference standard for data standardization, and defining the academy reference standard as a local value range; mapping the international value range and the local value range to establish a conversion mapping relation; and converting the medical data input according to the local value range into standardized data according to the international value range according to the conversion mapping relation.
Further, the international value range is established by setting a national standard value and corresponding national standard value description.
Further, the national standard value includes at least an arabic numeral and a chinese character.
Further, the method for establishing the mapping relationship between the original hospital standard data and the platform standard data further comprises the following steps:
and editing or deleting the national standard value or the corresponding national standard value description.
Further, the method for establishing the mapping relationship between the original hospital standard data and the platform standard data further comprises the following steps:
and importing a table file with a national standard value and a national standard value description.
Further, the method for establishing the mapping relationship between the original hospital standard data and the platform standard data further comprises the following steps: the local value domain is established by setting a local value and a corresponding local value description.
Further, the local value includes at least an arabic numeral and a chinese character.
Further, the method for establishing the mapping relationship between the original hospital standard data and the platform standard data further comprises the following steps: editing or deleting the local value or the corresponding local value description.
Further, the batch processing method of data suitable for medical data further comprises the following steps: and setting the time frequency for extracting the check data of the source table into the target table at regular time.
The data standardization is realized by mapping a local value domain (representing the standardized data of the original hospital) and an international value domain (representing the standard of a platform), and then a dynamic extraction mode is adopted, so that the detection and the conversion of mass data are realized.
The above description is only a preferred embodiment of the present application and is not intended to limit the present application, and various modifications and changes may be made by those skilled in the art. Any modification, equivalent replacement, improvement and the like made within the spirit and principle of the present application shall be included in the protection scope of the present application.
Claims (10)
1. A data batch processing method suitable for medical data is characterized in that:
the data batch processing method suitable for the medical data comprises the following steps:
extracting the inspection data of the source table into the target table at regular time;
acquiring data of each large inspection item from the target table, and converting the data into standard data according to the mapping relation between the original hospital standard data and the platform standard data;
and synchronizing the standard data of each large item into each large item standard table.
2. The batch processing method of data applicable to medical data according to claim 1, characterized in that:
the method for establishing the mapping relation between the original hospital standard data and the platform standard data comprises the following steps:
a unified reference standard for data standardization is established and defined as an international value range;
making an academy reference standard for data standardization, and defining the academy reference standard as a local value range;
mapping the international value range and the local value range to establish a conversion mapping relation;
and converting the medical data input according to the local value range into standardized data according to the international value range according to the conversion mapping relation.
3. The batch processing method of data applicable to medical data according to claim 2, characterized in that:
and setting a national standard value and corresponding national standard value description when the international value domain is formulated.
4. The batch processing method of data applicable to medical data according to claim 3, wherein:
the national standard value at least comprises Arabic numerals and Chinese characters.
5. The batch processing method of data applicable to medical data according to claim 4, wherein:
the method for establishing the mapping relation between the original hospital standard data and the platform standard data further comprises the following steps:
and editing or deleting the national standard value or the national standard value description corresponding to the national standard value.
6. The batch processing method of data applicable to medical data according to claim 5, wherein:
the method for establishing the mapping relation between the original hospital standard data and the platform standard data further comprises the following steps:
and importing a table file with the national standard value and the national standard value description.
7. The batch processing method of data applicable to medical data according to claim 6, wherein:
the method for establishing the mapping relation between the original hospital standard data and the platform standard data further comprises the following steps:
and the local value domain is established by setting a local value and a corresponding local value description.
8. The batch processing method of data applicable to medical data according to claim 7, wherein:
the place value includes at least an arabic numeral and a chinese character.
9. The batch processing method of data applicable to medical data according to claim 8, wherein:
the method for establishing the mapping relation between the original hospital standard data and the platform standard data further comprises the following steps:
editing or deleting the place value or the place value description corresponding to the place value.
10. The batch processing method of data applicable to medical data according to claim 9, wherein:
the batch processing method of the data suitable for the medical data further comprises the following steps:
and setting the time frequency of the check data of the timing extraction source table to the target table.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110805494.0A CN113704250A (en) | 2021-07-16 | 2021-07-16 | Data batch processing method suitable for medical data |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110805494.0A CN113704250A (en) | 2021-07-16 | 2021-07-16 | Data batch processing method suitable for medical data |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN113704250A true CN113704250A (en) | 2021-11-26 |
Family
ID=78648753
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202110805494.0A Pending CN113704250A (en) | 2021-07-16 | 2021-07-16 | Data batch processing method suitable for medical data |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN113704250A (en) |
Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20020198739A1 (en) * | 2001-01-05 | 2002-12-26 | Lau Lee Min | Matching and mapping clinical data to a standard |
| US20070088559A1 (en) * | 2003-07-14 | 2007-04-19 | Suhung-Gwon Kim | Method for computerising and standardizing medical information |
| CN104156415A (en) * | 2014-07-31 | 2014-11-19 | 沈阳锐易特软件技术有限公司 | Mapping processing system and method for solving problem of standard code control of medical data |
| CN109189769A (en) * | 2018-08-14 | 2019-01-11 | 平安医疗健康管理股份有限公司 | Data standardization processing method, device, computer equipment and storage medium |
| CN112233746A (en) * | 2020-11-05 | 2021-01-15 | 克拉玛依市中心医院 | Method for automatically standardizing medical data |
| CN112700886A (en) * | 2020-12-30 | 2021-04-23 | 杭州依图医疗技术有限公司 | Medical data processing method and device and storage medium |
| CN112883157A (en) * | 2021-02-07 | 2021-06-01 | 武汉大学 | Method and device for standardizing multi-source heterogeneous medical data |
-
2021
- 2021-07-16 CN CN202110805494.0A patent/CN113704250A/en active Pending
Patent Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20020198739A1 (en) * | 2001-01-05 | 2002-12-26 | Lau Lee Min | Matching and mapping clinical data to a standard |
| US20070088559A1 (en) * | 2003-07-14 | 2007-04-19 | Suhung-Gwon Kim | Method for computerising and standardizing medical information |
| CN104156415A (en) * | 2014-07-31 | 2014-11-19 | 沈阳锐易特软件技术有限公司 | Mapping processing system and method for solving problem of standard code control of medical data |
| CN109189769A (en) * | 2018-08-14 | 2019-01-11 | 平安医疗健康管理股份有限公司 | Data standardization processing method, device, computer equipment and storage medium |
| CN112233746A (en) * | 2020-11-05 | 2021-01-15 | 克拉玛依市中心医院 | Method for automatically standardizing medical data |
| CN112700886A (en) * | 2020-12-30 | 2021-04-23 | 杭州依图医疗技术有限公司 | Medical data processing method and device and storage medium |
| CN112883157A (en) * | 2021-02-07 | 2021-06-01 | 武汉大学 | Method and device for standardizing multi-source heterogeneous medical data |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| TWI521363B (en) | Method, device and system for implementing incremental data extraction | |
| CN110990390B (en) | Data cooperative processing method, device, computer equipment and storage medium | |
| CN104778241A (en) | Report generation method and system | |
| CN111291049A (en) | Method, device, equipment and storage medium for creating table | |
| WO2022127057A1 (en) | Weather early warning text processing method, related apparatus and computer program product | |
| CN112636957A (en) | Early warning method and device based on log, server and storage medium | |
| CN105975446A (en) | Method and system for displaying word document content by modules in mobile phone terminal | |
| US20230016403A1 (en) | Method of processing triple data, method of training triple data processing model, device, and medium | |
| CN110995273A (en) | Data compression method, device, equipment and medium for power database | |
| CN113408251A (en) | Layout document processing method and device, electronic equipment and readable storage medium | |
| CN114416877A (en) | Data processing method, device and equipment and readable storage medium | |
| CN113704250A (en) | Data batch processing method suitable for medical data | |
| CN102402684A (en) | Method and device for determining type of certificate and method and device for translating certificate | |
| CN106934045B (en) | System and method for migration evaluation of database | |
| CN107688978A (en) | The method and device of sequence information is repeated for detecting | |
| CN114461665B (en) | Method, apparatus and computer program product for generating a statement transformation model | |
| CN115544065A (en) | Data blood relationship discovery method, system, equipment and storage medium | |
| CN103778210A (en) | Method and device for judging specific file type of file to be analyzed | |
| CN110955645B (en) | Big data integration processing method and system | |
| CN109828755B (en) | Electric power graph display method | |
| CN113158998A (en) | Method and device for identifying form of electrical design drawing based on morphological processing | |
| CN113593528B (en) | Training method and device of voice segmentation model, electronic equipment and storage medium | |
| CN113223689A (en) | Standardized configuration method suitable for medical data | |
| US9626417B1 (en) | System, method, and computer program for automatically converting characters from an ISO character set to a UTF8 character set in a database | |
| CN115760006B (en) | Data correction method, device, electronic equipment and storage medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination |