Medical data supplementing method and device

A medical data and matching field technology, applied in the computer field, can solve problems such as the inability to effectively use a large amount of data, the inconvenience of scientific research on medical data, and the unrecorded medical ID, etc., to achieve the effects of reducing data calculations, safe type conversion, and avoiding errors

Active Publication Date: 2018-07-24
YIDU CLOUD (BEIJING) TECH CO LTD
2 Cites 1 Cited by

AI-Extracted Technical Summary

Problems solved by technology

In the process of extracting data by ETL, due to the system defects of metadata itself, some data fields may be missing. If the missing data fields are very important, a large amount of data may not be effectively utilized.
[0003] For example, in the actual medical system, inspection (including pathology, radiation, echocardiography, etc.) data and laboratory test (blood tes...
View more

Method used

According to the method for supplementing medical data in this example embodiment, on the one hand, the medical data to be supplemented in the described slave table is supplemented, and the described slave table is further improved, so that the medical data recorded from the table can be achieved purpose of use. On the other hand, converting the set of distributed Row objects of the main table into a set of distributed Java objects facilitates the processing of various structured or unstructured data, and type conversion is relatively safe. On the other hand, the collection of the distributed Java objects is aggregated according to the public key, and a large collection is divided into several small collections, which reduces the amount of data calculation for the next step of information matching, thereby improving efficiency; and can avoid the following An error occurred while matching step information.
In the present embodiment, described aggregation can be GroupBy, means grouping according to certain rule, and its effect is to divide a data set into several small regions by certain rule, then for several small regions Perform data processing. The collection of distributed Java objects is grouped according to the public key—patient ID information, and the primary key—patient ID information is filled in required information. The collection of distributed Java objects is div...
View more

Abstract

The invention relates to a medical data supplementing method and device. The method is used for supplementing medical data in a secondary list. To-be-supplemented medical data is an outer key of the secondary list and a primary key of a primary list. Additionally, the primary list and the secondary list share a public key. The primary list has a primary list matching field. The secondary list hasa secondary list matching field. The medical data supplementing method comprises the following steps: extracting the public key, the primary key, a collection for distributed Row objects of the primary list from the primary list, wherein the collection for distributed Row objects of the primary list is formed by the primary list matching field; converting the collection for distributed Row objectsof the primary list into a collection for distributed Java objects and representing the public key as a key for the collection for distributed Java objects; aggregating the collection for the distributed Java objects and correspondingly filling the primary key into information required; and supplementing to-be-supplemented medical data of the secondary list with information required through information required by a link of the public key and according to matching nature of the primary list matching field and the secondary list matching field. Therefore, the purpose of utilizing medical datarecorded by the secondary list is fulfilled.

Application Domain

Software designSpecial data processing applications

Technology Topic

Theoretical computer sciencePrimary Key +2

Image

  • Medical data supplementing method and device
  • Medical data supplementing method and device
  • Medical data supplementing method and device

Examples

  • Experimental program(1)

Example Embodiment

[0033] Example embodiments will now be described more fully with reference to the accompanying drawings. However, the example embodiments can be implemented in various forms, and should not be construed as being limited to the examples set forth herein; on the contrary, the provision of these embodiments makes the present disclosure more comprehensive and complete, and fully conveys the concept of the example embodiments To those skilled in the art. The described features, structures or characteristics can be combined in one or more embodiments in any suitable way. In the following description, many specific details are provided to give a sufficient understanding of the embodiments of the present disclosure. However, those skilled in the art will realize that the technical solutions of the present disclosure can be practiced without one or more of the specific details, or other methods, components, devices, steps, etc. can be used. In other cases, the known technical solutions are not shown or described in detail in order to avoid overwhelming the crowd and obscure all aspects of the present disclosure.
[0034] In addition, the drawings are only schematic illustrations of the present disclosure, and are not necessarily drawn to scale. The same reference numerals in the figures indicate the same or similar parts, and thus their repeated description will be omitted. Some of the block diagrams shown in the drawings are functional entities and do not necessarily correspond to physically or logically independent entities. These functional entities may be implemented in the form of software, or implemented in one or more hardware modules or integrated circuits, or implemented in different networks and/or processor devices and/or microcontroller devices.
[0035] This example embodiment first provides a method for supplementing medical data. The method for supplementing medical data supplements medical data from a slave table. The medical data to be supplemented is the foreign key of the slave table and the primary key of the master table, and the master table And the slave table holds a common key, the master table holds the matching field of the master table, and the slave table holds the matching field of the slave table; refer to figure 1 As shown, the medical data supplement method may include the following steps:
[0036] Step S1, extracting the public key, the primary key, and the matching field of the primary table from the primary table to form a set of distributed Row objects of the primary table.
[0037] Step S2: Convert the collection of distributed Row objects of the main table to a collection of distributed Java objects, and use the public key as the key of the collection of distributed Java objects.
[0038] Step S3: Aggregate the distributed collection of Java objects according to the public key, and fill in the required information with the primary key.
[0039] Step S4: Link the required information through the public key, and supplement the required information with the medical data to be supplemented in the secondary table according to the matching of the matching field of the primary table and the secondary table.
[0040] According to the medical data supplement method in this exemplary embodiment, on the one hand, the medical data to be supplemented in the slave table is supplemented, and the slave table is further improved, so that the medical data recorded in the slave table can be used. . On the other hand, converting the collection of distributed Row objects in the main table to a collection of distributed Java objects is convenient for processing various structured or unstructured data, and the type conversion is relatively safe. On the other hand, the distributed collection of Java objects is aggregated according to the public key, and a large collection is divided into several small collections to reduce the amount of data calculation for the next information matching, thereby improving efficiency; and it can avoid the following An error occurred when the information in one step was matched.
[0041] Hereinafter, the medical data supplement method in this exemplary embodiment will be further explained.
[0042] In step S1, the common key, the primary key, and the matching field of the primary table are extracted from the primary table to form a collection of distributed Row objects of the primary table.
[0043] In this embodiment, description is made by taking as an example the supplement of the ID information of the visit from the table. The main table records the visit ID information, patient ID information, visit time and basic information of the patient. Specifically, the visit ID information is information formed by a patient's one visit, for example, a series of actions such as registration, laboratory tests, and prescription (or injection) in an outpatient clinic will form a visit ID information; the visit ID information can be A series of numbers formed by the date of the patient's visit and the number of patients in the department visited. For example, the patient's third visit to surgery (department number B) on March 8, 2012 can form visit ID information It is 20120308B03. In addition, in other embodiments of the present disclosure, the consultation ID information may also be the number of patients in this hospital, that is, the consultation ID information of the 28561 patients in this hospital is 28561. The patient ID information can be the patient's name or ID number, or the patient's telephone number, or at the current stage, the patient's medical card number in the hospital, etc., and there is no special limitation here. The basic information of the patient may include information such as the patient's name, gender, age, or telephone number. The visit time can be the time for the patient to complete one visit. Generally, the outpatient visit is one day, such as June 8, 2013; the hospitalization can be multiple days, such as June 8, 2013 to June 15, 2013, etc., here There are no special restrictions, and it can be accurate to the hour if necessary.
[0044] In this embodiment, the slave table records patient ID information, examination time and examination information. Specifically, the examination time can be the time for the patient to complete an examination, which is generally accurate to the hour, for example, at 10 o'clock on June 8, 2013, and can be accurate to the minute if necessary. The inspection information may include inspection and inspection data that occurred during the inspection.
[0045] In this embodiment, the public key is patient ID information. The medical data to be supplemented is visit ID information, that is, the visit ID information is the foreign key of the secondary table and the primary key of the primary table. The matching field of the master table is the consultation time, and the matching field of the slave table is the examination time. The patient ID information, the consultation ID information and the consultation time are extracted from the main table to form a collection of distributed Row objects in the main table.
[0046] In step S2, the set of distributed Row objects in the main table is converted to a set of distributed Java objects, and the public key is used as the key of the set of distributed Java objects.
[0047] In this embodiment, the collection of distributed Row objects may be a DataFrame, and the collection of distributed Java objects may be an RDD, that is, the DataFrame of the main table is converted to an RDD. DataFrame cannot type conversion security check at compile time, and it can be determined at runtime whether there is a problem; and it is not friendly to object support. DataFrame memory stores row objects instead of custom objects. RDD can have many built-in function operations, such as group, map, filter, etc., to facilitate the processing of structured or unstructured data; and it can be object-oriented programming, directly stored java objects, and type conversion is also safe. Therefore, converting the collection of distributed Row objects in the main table to a collection of distributed Java objects is convenient for processing various structured or unstructured data, and the type conversion is relatively safe.
[0048] In step S3, the collection of distributed Java objects is aggregated according to the public key, and the primary key is filled in the required information.
[0049] In this embodiment, the aggregation can be GroupBy, which means grouping according to certain rules. Its function is to divide a data set into several small areas through certain rules, and then perform data processing on several small areas . Group the distributed collection of Java objects according to the public key—patient ID information, and fill in the required information with the primary key—patient ID information. That is, the collection of distributed Java objects is divided into several small areas according to the patient ID information, and the corresponding medical ID information is filled in the required information. With this design, a large set is divided into several small sets according to the patient ID information, which reduces the amount of data calculation for the next information matching, thereby improving efficiency; and can avoid errors in the next information matching.
[0050] In step S4, the required information is linked through the public key, and the required information is supplemented with the medical data to be supplemented in the slave table according to the matching of the matching field of the master table and the matching field of the slave table.
[0051] In this embodiment, the matching field of the master table is the consultation time, and the matching field of the slave table is the examination time. The matching between the matching field of the master table and the matching field of the slave table is the closeness of the visit time and the examination time. In the case that an examination is required after the consultation, the general examination time is after the consultation time, and the consultation time and the examination time are close. The patient ID information is linked to the consultation ID information, and the consultation ID information is added to the slave table according to the proximity of the consultation time and the examination time. For example, if you register on March 20, 2016 when you go to an outpatient clinic, you will usually complete the inspection on March 20, 2016, or complete the inspection and prescribe medication (or a few days after March 20, 2016). A series of actions, such as injections), generally does not exceed one week; therefore, the time for medical consultation is March 20, 2016, and the examination time can be March 20, 2016 or later than March 20, 2016. The closer the inspection time and the consultation time are, the higher the similarity will be. Choose the consultation ID information corresponding to the consultation time closest to the examination time and fill in the secondary form to complete the supplement to the secondary form. Of course, in other embodiments of the present disclosure, the main table matching field may also be the recorded visit time set in the visit ID information; further judgments may also be made in combination with the diagnosis information, which is not specifically limited here.
[0052] Further, the medical data supplement method may further include: after extracting the common key, the primary key, and the matching field from the main table, deleting the row where the common key is a space string or an empty string. In this embodiment, since the space string or the empty string has no meaning, the row where the common key is the space string or the empty string is deleted.
[0053] In addition, although the various steps of the method of the present disclosure are described in a specific order in the drawings, this does not require or imply that these steps must be performed in the specific order, or that all the steps shown must be performed to achieve the desired result. Additionally or alternatively, some steps may be omitted, multiple steps may be combined into one step for execution, and/or one step may be decomposed into multiple steps for execution, etc.
[0054] Further, this exemplary embodiment also provides a medical data supplement device corresponding to the above medical data supplement method. Supplement the medical data to the slave table. The medical data to be supplemented is the foreign key of the slave table and the primary key of the master table, and the master table and the slave table hold a common key, the master table holds the matching fields of the master table, and the slave table holds There are matching fields from the table. Reference figure 2 As shown, the medical data supplement device may include: a public key, foreign key, and main table matching field extraction unit 1, a main table conversion unit 2, a distributed Java object aggregation unit 3, and a medical data supplement unit 4 to be supplemented . among them:
[0055] The common key, foreign key, and main table matching field extraction unit 1 may be used to extract the common key, the primary key, and the main table matching field from the main table to form a distributed set of Row objects of the main table.
[0056] The main table conversion unit 2 may be used to convert the set of distributed Row objects of the main table into a set of distributed Java objects, and use the public key as the key of the set of distributed Java objects .
[0057] The collection and aggregation unit 3 of distributed Java objects can be used to aggregate the collection of distributed Java objects according to the public key, and fill in the required information correspondingly with the primary key.
[0058] The medical data supplement unit 4 to be supplemented may be used to link the required information through the public key, and supplement the required information to the slave table according to the matching between the matching field of the master table and the matching field of the slave table. The medical data to be supplemented.
[0059] In this exemplary embodiment, the master table records medical visit ID information, patient ID information, medical visit time, and basic patient information; the secondary table records patient ID information, examination time, and examination information.
[0060] In this exemplary embodiment, the medical data to be supplemented is consultation ID information, the public key is patient ID information, the master table matching field is the consultation time, and the slave table matching field is the examination time.
[0061] In this exemplary embodiment, the matching between the matching field of the master table and the matching field of the slave table is the closeness of the visit time to the examination time.
[0062] In this exemplary embodiment, the medical data supplement device may further include:
[0063] The space string or empty string deleting unit can be used to delete the row where the common key is the space string or empty string after extracting the common key, the primary key, and the matching field from the main table.
[0064] The specific details of each module in the above medical data supplement device have been described in detail in the corresponding virtual object motion control method, so it will not be repeated here.
[0065] It should be noted that although several modules or units of the device for action execution are mentioned in the above detailed description, this division is not mandatory. In fact, according to the embodiments of the present disclosure, the features and functions of two or more modules or units described above may be embodied in one module or unit. Conversely, the features and functions of a module or unit described above can be further divided into multiple modules or units to be embodied.
[0066] Through the description of the above embodiments, those skilled in the art can easily understand that the example embodiments described here can be implemented by software, or can be implemented by combining software with necessary hardware. Therefore, the technical solution according to the embodiments of the present disclosure can be embodied in the form of a software product, which can be stored in a non-volatile storage medium (can be a CD-ROM, U disk, mobile hard disk, etc.) or on the network , Including several instructions to make a computing device (which may be a personal computer, a server, a mobile terminal, or a network device, etc.) execute the method according to the embodiments of the present disclosure.
[0067] image 3 A schematic diagram of an electronic device 400 according to an exemplary embodiment of the present disclosure is shown. For example, the electronic device 400 may be provided as a server. Reference image 3 The electronic device 400 includes a processing component 422, which further includes one or more processors, and a memory resource represented by the memory 432, for storing instructions executable by the processing component 422, such as application programs. The application program stored in the memory 432 may include one or more modules each corresponding to a set of instructions. In addition, the processing component 422 is configured to execute instructions to perform the aforementioned method.
[0068] The electronic device 400 may also include a power supply component 426 configured to perform power management of the electronic device 400, a wired or wireless network interface 450 configured to connect the electronic device 400 to a network, and an input output (I/O) interface 458 . The electronic device 400 can operate based on an operating system stored in the memory 432, such as WindowsServerTM, Mac OS XTM, UnixTM, LinuxTM, FreeBSDTM or the like.
[0069] Those skilled in the art will easily think of other embodiments of the present disclosure after considering the description and practicing the invention disclosed herein. This application is intended to cover any variations, uses, or adaptive changes of the present disclosure. These variations, uses, or adaptive changes follow the general principles of the present disclosure and include common knowledge or conventional technical means in the technical field not disclosed in the present disclosure. . The description and the embodiments are only regarded as exemplary, and the true scope and spirit of the present disclosure are pointed out by the appended claims.

PUM

no PUM

Description & Claims & Application Information

We can also present the details of the Description, Claims and Application information to help users get a comprehensive understanding of the technical details of the patent, such as background art, summary of invention, brief description of drawings, description of embodiments, and other original content. On the other hand, users can also determine the specific scope of protection of the technology through the list of claims; as well as understand the changes in the life cycle of the technology with the presentation of the patent timeline. Login to view more.

Similar technology patents

Whole body movement planning method and system of robot

ActiveCN111571588AReduce the amount of data calculationImprove the efficiency of whole body motion planning
Owner:深圳国信泰富科技有限公司

Data query method and device, computer equipment and storage medium

PendingCN111400556AReduce the amount of data calculationrun fast
Owner:上海数据发展科技有限责任公司

Sharpened broadband beam forming method and device based on two-stage delay

InactiveCN112731360AReduce the amount of data calculationfast signal processing
Owner:北京星天科技有限公司

Sound recognition method and automatic control method of range hood using sound recognition method

ActiveCN110631064AReduce the amount of data calculationreduce storage
Owner:NINGBO FOTILE KITCHEN WARE CO LTD

Gesture recognition method, device, equipment and storage medium based on electromyographic signals

ActiveCN113688802BRemove misjudgment resultsReduce the amount of data calculation
Owner:JIHUA LAB

Classification and recommendation of technical efficacy words

  • Reduce the amount of data calculation

Spectral calibration method for swept source optical coherence tomography (SS-OCT) system

ActiveCN106949966AReduce complexity and costReduce the amount of data calculation
Owner:SHANGHAI INST OF OPTICS & FINE MECHANICS CHINESE ACAD OF SCI

Unmanned aerial vehicle flight path generation method and device, computer device and storage medium

ActiveCN110599583AReduce the amount of data calculationReduce computing time
Owner:MOUTONG SCI & TECH CO LTD

Wave length measurement method based on spatial adjacent wave height data dependency

ActiveCN107101619AImprove measurement accuracyReduce the amount of data calculation
Owner:OCEAN UNIV OF CHINA

Cloud platform service creating method and system

InactiveCN105897826Areduce complexityReduce the amount of data calculation
Owner:LETV CLOUD COMPUTING CO LTD

Position information acquisition method and device, terminal and storage medium

PendingCN110162658AReduce the amount of data calculation
Owner:GUANGDONG XIAOTIANCAI TECH CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products