[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.