CN109597847B

CN109597847B - Medical data retrogradation method and device, storage medium and electronic terminal

Info

Publication number: CN109597847B
Application number: CN201811333510.5A
Authority: CN
Inventors: 王英杰
Original assignee: Golden Panda Ltd
Current assignee: Golden Panda Ltd
Priority date: 2018-11-09
Filing date: 2018-11-09
Publication date: 2021-03-09
Anticipated expiration: 2038-11-09
Also published as: CN109597847A

Abstract

The present disclosure relates to the field of data processing technologies, and in particular, to a medical data retrogradation method, a medical data retrogradation apparatus, a storage medium, and an electronic terminal. The method comprises the following steps: extracting data to be subsided in a target project database according to a preset field according to the first trigger information; converting the data to be rewound into a preset format and storing the data to be rewound into a preset temporary storage database; and extracting the data to be rewound from the preset temporary storage database according to second trigger information and storing the data to be rewound into a preset main database. According to the data storage method and device, the data to be refluxed are stored in the preset temporary storage database through setting during data refluxing processing, and the efficiency, flexibility and reliability of precipitation processing of the refluxed data are improved.

Description

Medical data retrogradation method and device, storage medium and electronic terminal

Technical Field

The present disclosure relates to the field of data processing technologies, and in particular, to a medical data retrogradation method, a medical data retrogradation apparatus, a storage medium, and an electronic terminal.

Background

Various scientific research and research projects are frequently carried out in the medical field, and the data of the research or the research projects are mostly derived from the collection of clinical medical data and contain valuable research value. In order to better and long-term use the clinical medical data or share the clinical medical data to other people for medical science research, the clinical medical data belonging to different projects needs to be quickly and effectively organized and integrated.

In the prior art, when clinical medical data are collated and integrated, a manual mode is mainly adopted, data of each scientific research project are exported to a general file (for example, Excel), and file data are imported to a designated main database in a manual mode. Meanwhile, the prior art also has certain defects, for example, misoperation is easy to occur in the process of manually processing data, so that data arrangement errors are caused, and the reliability is difficult to guarantee. Furthermore, the efficiency of manual data processing is also low.

It is to be noted that the information disclosed in the above background section is only for enhancement of understanding of the background of the present disclosure, and thus may include information that does not constitute prior art known to those of ordinary skill in the art.

Disclosure of Invention

The present disclosure aims to provide a medical data retrogradation method, a medical data retrogradation device, a storage medium, and an electronic terminal, so as to effectively avoid the problems of data errors and low efficiency that easily occur when the retrogradation data is manually processed in the prior art.

Additional features and advantages of the disclosure will be set forth in the detailed description which follows, or in part will be obvious from the description, or may be learned by practice of the disclosure.

According to a first aspect of the present disclosure, there is provided a medical data subsidence method, comprising:

extracting data to be subsided in a target project database according to a preset field according to the first trigger information;

converting the data to be rewound into a preset format and storing the data to be rewound into a preset temporary storage database;

and extracting the data to be rewound from the preset temporary storage database according to second trigger information and storing the data to be rewound into a preset main database.

In an exemplary embodiment of the present disclosure, the target project database includes patient data, and a project data dictionary for expressing a correspondence relationship between the patient data and preset fields;

the project data dictionary includes a plurality of preset fields.

In an exemplary embodiment of the present disclosure, the extracting the data to be rewound according to the preset field in the target item database includes:

and acquiring the patient data corresponding to the preset field according to the project data dictionary and taking the patient data as the data to be subsided.

In an exemplary embodiment of the present disclosure, when saving the data to be rewound to a preset staging database, the method further includes:

and storing the data to be rewound to a preset backup database, and updating a backup database index corresponding to the preset backup database according to the data to be rewound.

In an exemplary embodiment of the present disclosure, the master database includes patient data, a master database data dictionary for expressing correspondence between the patient data and preset fields, and a master database data index;

the master database dictionary comprises a plurality of preset fields, and the project data dictionary is a subset of the master database dictionary.

In an exemplary embodiment of the present disclosure, the extracting the data to be rewound from the preset staging database according to the second trigger information and saving the data to be rewound to a preset master database includes:

responding to second trigger information generated by checking the data to be rewound according to a preset rule, performing data fusion on the data to be rewound and the master database according to a preset field corresponding to the data to be rewound, and updating a data index of the master database; or

And responding to data error prompt information generated by checking the data to be rewound according to a preset rule, and correcting the data to be rewound.

In an exemplary embodiment of the present disclosure, the method further comprises:

creating a target project database, and acquiring a storage condition and a preset field of the target project database;

extracting patient data from a preset main database according to the preset admittance condition and the preset field and storing a preset backup database;

and extracting patient data from the preset backup database according to third trigger information and storing the patient data in the target project database.

According to a second aspect of the present disclosure, there is provided a medical data subsidence device comprising:

the data extraction module is used for extracting the data to be rewound in the target project database according to the first trigger information and the preset field;

the data temporary storage module is used for converting the data to be rewound into a preset format and storing the data to be rewound into a preset temporary storage database;

and the data merging module is used for extracting the data to be rewound from the preset temporary storage database according to second trigger information and storing the data to be rewound into a preset main database.

According to a third aspect of the present disclosure, there is provided a storage medium having stored thereon a computer program which, when executed by a processor, implements the medical data subsidence method described above.

According to a fourth aspect of the present disclosure, there is provided an electronic terminal comprising:

a processor; and

a memory for storing executable instructions of the processor;

wherein the processor is configured to perform the following via execution of the executable instructions:

In the medical data retrogradation method provided by one embodiment of the disclosure, data to be retrograded is extracted from a target project database through a preset field, and the data to be retrograded is stored in a preset temporary storage database; and when the trigger information is received, the data to be rewound is extracted from the preset temporary storage database and is stored in a preset main database, so that the medical data or scientific research project data can be rapidly reflowed. The data to be refluxed is stored in the preset temporary storage database by setting during data reflux processing, so that the efficiency, flexibility and reliability of precipitation processing of the refluxed data are improved.

It is to be understood that both the foregoing general description and the following detailed description are exemplary and explanatory only and are not restrictive of the disclosure.

Drawings

The accompanying drawings, which are incorporated in and constitute a part of this specification, illustrate embodiments consistent with the present disclosure and together with the description, serve to explain the principles of the disclosure. It is to be understood that the drawings in the following description are merely exemplary of the disclosure, and that other drawings may be derived from those drawings by one of ordinary skill in the art without the exercise of inventive faculty.

Fig. 1 schematically illustrates a method schematic of a medical data subsidence method in an exemplary embodiment of the disclosure;

FIG. 2 schematically illustrates a method of creating a database of target items in an exemplary embodiment of the disclosure;

fig. 3 schematically illustrates a composition diagram of a medical data sink device in an exemplary embodiment of the present disclosure;

fig. 4 schematically illustrates another schematic view of a medical data sink device in an exemplary embodiment of the present disclosure;

fig. 5 schematically illustrates yet another schematic diagram of a medical data sink device in an exemplary embodiment of the present disclosure.

Detailed Description

Example embodiments will now be described more fully with reference to the accompanying drawings. Example embodiments may, however, be embodied in many different forms and should not be construed as limited to the examples set forth herein; rather, these embodiments are provided so that this disclosure will be thorough and complete, and will fully convey the concept of example embodiments to those skilled in the art. The described features, structures, or characteristics may be combined in any suitable manner in one or more embodiments.

The example embodiment first provides a medical data subsidence method, which can be applied to various medical data or scientific research project data. Referring to fig. 1, the medical data subsidence method described above may include the steps of:

step S11, extracting data to be subsided in the target project database according to the preset field according to the first trigger information;

step S12, converting the data to be restored into a preset format and storing the data to be restored into a preset temporary storage database;

and step S13, extracting the data to be rewound from the preset temporary storage database according to second trigger information and storing the data to be rewound into a preset main database.

In the medical data retrogradation method provided by the present example embodiment, data to be retrograded is first extracted from a target project database through a preset field, and the data to be retrograded is stored in a preset temporary storage database; and when the trigger information is received, the data to be rewound is extracted from the preset temporary storage database and is stored in a preset main database, so that the medical data or scientific research project data can be rapidly reflowed. The data to be refluxed is stored in the preset temporary storage database by setting during data reflux processing, so that the efficiency, flexibility and reliability of precipitation processing of the refluxed data are improved.

Hereinafter, each step in the disease evaluation and disease risk assessment method according to the exemplary embodiment will be described in more detail with reference to the drawings and examples.

Step S101, a target project database is created, and a storage condition and a preset field of the target project database are obtained;

step S102, extracting patient data from a preset main database according to the preset admittance condition and the preset field, and storing a preset backup database;

and step S103, extracting patient data from the preset backup database according to third trigger information and storing the patient data in the target project database.

In the exemplary embodiment, and as shown with reference to FIG. 2, a primary database and a backup database may be provided. Wherein, the main database comprises all patient detail data, patient summary data and data index. In addition, the master database may further include a master database dictionary for expressing the correspondence between the patient data and the preset fields, and the data dictionary may include general research fields in the medical research field, such as: any one or more of a field name, a data type, a data path, a field description, a crf topic, and a data value field. The backup database may also contain patient data, as well as a backup database index.

When a user creates a project database, the patient data required by the project can be pulled from the main database according to the storage and arrangement conditions of the project and stored in the project backup database. Thereafter, the user may extract some or all of the patient data from the project backup database into the project database based on the scientific requirements of the project.

By arranging the backup database, the independence of project data can be effectively ensured, and the data updating influence of the main database is avoided. Meanwhile, the data of the project database is extracted from the backup data, and new data collection, processing and research are carried out from the backup data.

And step S11, extracting the data to be rewound in the target project database according to the preset field according to the first trigger information.

In this exemplary embodiment, the target item database may include detailed patient data related to a target item, and may further include a target item data dictionary for expressing a correspondence between the patient data and preset fields, where the item data dictionary may include a plurality of preset fields. And, the item data dictionary may be a subset of the master library item dictionary. For example, when the target project database is a tumor-related research project, the target project data dictionary may be a tumor disease data dictionary and include general research fields for research in the tumor field.

Specifically, the first trigger information may be a data reflow application submitted by the target project database management user. In addition, an interactive interface can be provided for the user, so that the user can submit a data reflow application about the target project to a superior or an administrator on the interactive interface. And the preset fields can be utilized to extract the relevant data to be rewound from the project database. For example, the data to be rewound may be selected in the target project database by a data field and/or patient identification. For example, the data to be restored is selected according to the age, sex, or pathological grade corresponding to the disease of the patient.

For example, when the target item database is an item related to a tumor study, the patient data may include personal information of the patient, medical records related to surgery, medical records related to examination or examination, medical records related to medication, and the like. The target item number dictionary may be a dictionary containing data about the tumor disease. When the data to be subsided is selected, the patient data in the target project can be accurately selected according to the project data dictionary by using the project data field and used as the data to be subsided.

The target project database can adopt a Mongo database and the like, and the target project database can also contain patient summary data. Of course, in other exemplary embodiments of the present disclosure, the user may also extract the data to be rewound in the target project database according to the customized rule. For example, a specified amount of patient data in the target project database is selected as the data to be rewound.

And step S12, converting the data to be rewound into a preset format and storing the data to be rewound into a preset temporary storage database.

In this example embodiment, a pre-defined staging database may be provided. After the user extracts the data to be restored from the target project database, the data to be restored can be converted into a data format or a data structure consistent with the main database and stored in the preset temporary storage database.

Meanwhile, the data to be restored can be stored in the backup database, and the backup database index can be updated.

In this exemplary embodiment, it may be determined whether second trigger information for feeding back the first trigger information is received first. For example, the data to be rewound in the temporary storage database may be checked by a superior or administrator by using tool software or manually, so as to determine whether the data quality of the data to be rewound meets a preset standard or meets a data requirement of a preset rule. Of course, in some exemplary embodiments of the present disclosure, a user or administrator may customize the rules and criteria of data inspection according to actual business needs or data types, etc.

And if the data to be rewound is verified to meet the preset rule or meet the preset data standard, generating second trigger information. Or, if the data to be rewound does not meet the preset rule or does not meet the preset data standard, generating corresponding data error prompt information, and including a data error reason in the error prompt information, so that the user can correct or modify the data to be rewound.

For example, the preset fields are lymphoid tumors, with pathological grades G2 (medium grade) and G1 (low grade); and extracting relevant patient data in the target project database according to the preset field. However, the actually extracted data to be restored contains a certain amount of patient data with the pathology grade GX (grade cannot be determined). If the preset data quality standard or the preset rule is that the proportion of the unmatched data in the data to be rewound is not higher than 1%. After the data to be rewound is checked and approved according to the standard, if the number of the patient data with the pathology grade GX (grade cannot be determined) in the data to be rewound is 0.5%, the second trigger information is generated. Alternatively, if the number of patient data with a pathology level GX (level uncertain) in the data to be restored is 5%, corresponding data error information may be generated.

When the second trigger information is judged to be received, the data to be restored and the patient data in the master database can be subjected to data fusion, for example, the data items in the master database are subjected to operations such as adding or modifying. At the same time, the master database index may also be updated.

For example, the primary database, the target project database, and the backup database may be Mongo databases. When the Mongo database is deployed, the data storage amount can be estimated firstly, for example, the data storage amount can be calculated according to the storage amount required by each patient and the total number of patients, and a certain upgrade space is reserved, for example, 3 times of space is reserved, and the method can be used for multi-version iteration. The specific calculation method of the storage amount of the database is as follows: single patient data volume total number of patients 3. In addition, the storage may also be pre-estimated in the manner described above when deploying an ES search engine.

The data sink method provided by the present disclosure may be executed at a server or a user terminal. By setting the data temporary storage area, the data to be rewound can be managed according to the dimensionality of the target project. The problem of quick subside and convenient follow-up long-term use and sharing of disease scientific research project data is solved, the accumulation efficiency and the sharing availability factor of disease scientific research project data have been improved.

It is to be noted that the above-mentioned figures are only schematic illustrations of the processes involved in the method according to an exemplary embodiment of the invention, and are not intended to be limiting. It will be readily understood that the processes shown in the above figures are not intended to indicate or limit the chronological order of the processes. In addition, it is also readily understood that these processes may be performed synchronously or asynchronously, e.g., in multiple modules.

Further, referring to fig. 3, the present exemplary embodiment also provides a medical data sink device 30, including: a data extraction module 301, a data temporary storage module 302 and a data merging module 303. Wherein:

the data extraction module 301 may be configured to extract data to be rewound in the target project database according to a preset field according to the first trigger information.

The data temporary storage module 302 may be configured to convert the data to be rewound into a preset format and store the preset format in a preset temporary storage database.

The data merging module 303 may be configured to extract the data to be rewound from the preset temporary storage database according to second trigger information and store the data to be rewound in a preset master database.

The specific details of each module in the medical data subsidence device are already described in detail in the corresponding medical data subsidence method, and therefore are not described herein again.

It should be noted that although in the above detailed description several modules or units of the device for action execution are mentioned, such a division is not mandatory. Indeed, the features and functionality of two or more modules or units described above may be embodied in one module or unit, according to embodiments of the present disclosure. Conversely, the features and functions of one module or unit described above may be further divided into embodiments by a plurality of modules or units.

In an exemplary embodiment of the present disclosure, an electronic device capable of implementing the above method is also provided.

As will be appreciated by one skilled in the art, aspects of the present invention may be embodied as a system, method or program product. Thus, various aspects of the invention may be embodied in the form of: an entirely hardware embodiment, an entirely software embodiment (including firmware, microcode, etc.) or an embodiment combining hardware and software aspects that may all generally be referred to herein as a "circuit," module "or" system.

An electronic device 600 according to this embodiment of the invention is described below with reference to fig. 4. The electronic device 600 shown in fig. 4 is only an example, and should not bring any limitation to the functions and the scope of use of the embodiments of the present invention.

As shown in fig. 4, the electronic device 600 is embodied in the form of a general purpose computing device. The components of the electronic device 600 may include, but are not limited to: the at least one processing unit 610, the at least one memory unit 620, and a bus 630 that couples the various system components including the memory unit 620 and the processing unit 610.

Wherein the storage unit stores program code that is executable by the processing unit 610 to cause the processing unit 610 to perform steps according to various exemplary embodiments of the present invention as described in the above section "exemplary methods" of the present specification. For example, the processing unit 610 may execute step S11 as shown in fig. 1: extracting data to be subsided in a target project database according to a preset field according to the first trigger information; step S12: converting the data to be rewound into a preset format and storing the data to be rewound into a preset temporary storage database; step S13: and extracting the data to be rewound from the preset temporary storage database according to second trigger information and storing the data to be rewound into a preset main database.

The storage unit 620 may include readable media in the form of volatile memory units, such as a random access memory unit (RAM)6201 and/or a cache memory unit 6202, and may further include a read-only memory unit (ROM) 6203.

The memory unit 620 may also include a program/utility 6204 having a set (at least one) of program modules 6205, such program modules 6205 including, but not limited to: an operating system, one or more application programs, other program modules, and program data, each of which, or some combination thereof, may comprise an implementation of a network environment.

Bus 630 may be one or more of several types of bus structures, including a memory unit bus or memory unit controller, a peripheral bus, an accelerated graphics port, a processing unit, or a local bus using any of a variety of bus architectures.

The electronic device 600 may also communicate with one or more external devices 700 (e.g., keyboard, pointing device, bluetooth device, etc.), with one or more devices that enable a user to interact with the electronic device 600, and/or with any devices (e.g., router, modem, etc.) that enable the electronic device 600 to communicate with one or more other computing devices. Such communication may occur via an input/output (I/O) interface 650. Also, the electronic device 600 may communicate with one or more networks (e.g., a Local Area Network (LAN), a Wide Area Network (WAN), and/or a public network such as the Internet) via the network adapter 660. As shown, the network adapter 660 communicates with the other modules of the electronic device 600 over the bus 630. It should be appreciated that although not shown in the figures, other hardware and/or software modules may be used in conjunction with the electronic device 600, including but not limited to: microcode, device drivers, redundant processing units, external disk drive arrays, RAID systems, tape drives, and data backup storage systems, among others.

Through the above description of the embodiments, those skilled in the art will readily understand that the exemplary embodiments described herein may be implemented by software, or by software in combination with necessary hardware. Therefore, the technical solution according to the embodiments of the present disclosure may be embodied in the form of a software product, which may be stored in a non-volatile storage medium (which may be a CD-ROM, a usb disk, a removable hard disk, etc.) or on a network, and includes several instructions to enable a computing device (which may be a personal computer, a server, a terminal device, or a network device, etc.) to execute the method according to the embodiments of the present disclosure.

In an exemplary embodiment of the present disclosure, there is also provided a computer-readable storage medium having stored thereon a program product capable of implementing the above-described method of the present specification. In some possible embodiments, aspects of the invention may also be implemented in the form of a program product comprising program code means for causing a terminal device to carry out the steps according to various exemplary embodiments of the invention described in the above section "exemplary methods" of the present description, when said program product is run on the terminal device.

Referring to fig. 5, a program product 800 for implementing the above method according to an embodiment of the present invention is described, which may employ a portable compact disc read only memory (CD-ROM) and include program code, and may be run on a terminal device, such as a personal computer. However, the program product of the present invention is not limited in this regard and, in the present document, a readable storage medium may be any tangible medium that can contain, or store a program for use by or in connection with an instruction execution system, apparatus, or device.

The program product may employ any combination of one or more readable media. The readable medium may be a readable signal medium or a readable storage medium. A readable storage medium may be, for example, but not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any combination of the foregoing. More specific examples (a non-exhaustive list) of the readable storage medium include: an electrical connection having one or more wires, a portable disk, a hard disk, a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing.

A computer readable signal medium may include a propagated data signal with readable program code embodied therein, for example, in baseband or as part of a carrier wave. Such a propagated data signal may take many forms, including, but not limited to, electro-magnetic, optical, or any suitable combination thereof. A readable signal medium may also be any readable medium that is not a readable storage medium and that can communicate, propagate, or transport a program for use by or in connection with an instruction execution system, apparatus, or device.

Program code embodied on a readable medium may be transmitted using any appropriate medium, including but not limited to wireless, wireline, optical fiber cable, RF, etc., or any suitable combination of the foregoing.

Program code for carrying out operations for aspects of the present invention may be written in any combination of one or more programming languages, including an object oriented programming language such as Java, C + + or the like and conventional procedural programming languages, such as the "C" programming language or similar programming languages. The program code may execute entirely on the user's computing device, partly on the user's device, as a stand-alone software package, partly on the user's computing device and partly on a remote computing device, or entirely on the remote computing device or server. In the case of a remote computing device, the remote computing device may be connected to the user computing device through any kind of network, including a Local Area Network (LAN) or a Wide Area Network (WAN), or may be connected to an external computing device (e.g., through the internet using an internet service provider).

Furthermore, the above-described figures are merely schematic illustrations of processes involved in methods according to exemplary embodiments of the invention, and are not intended to be limiting. It will be readily understood that the processes shown in the above figures are not intended to indicate or limit the chronological order of the processes. In addition, it is also readily understood that these processes may be performed synchronously or asynchronously, e.g., in multiple modules.

Other embodiments of the disclosure will be apparent to those skilled in the art from consideration of the specification and practice of the disclosure disclosed herein. This application is intended to cover any variations, uses, or adaptations of the disclosure following, in general, the principles of the disclosure and including such departures from the present disclosure as come within known or customary practice within the art to which the disclosure pertains. It is intended that the specification and examples be considered as exemplary only, with a true scope and spirit of the disclosure being indicated by the following claims.

It will be understood that the present disclosure is not limited to the precise arrangements described above and shown in the drawings and that various modifications and changes may be made without departing from the scope thereof. The scope of the present disclosure is to be limited only by the terms of the appended claims.

Claims

1. A method of medical data subsidence, comprising:

creating a target project database, extracting patient data from a preset main database according to preset rules corresponding to the target project database, and storing the patient data in a backup database; and saving the patient data from the backup database to the target project database;

extracting patient data corresponding to a preset field in a target project database according to the project data dictionary according to the first triggering information so as to obtain data to be subsided; the target project database comprises patient data derived from a preset main database and a project data dictionary used for expressing the corresponding relation between the patient data and preset fields;

extracting the data to be rewound from the preset temporary storage database according to second trigger information for feeding back the first trigger information, and performing data fusion on the data to be rewound and the preset main database so as to fuse the data to be rewound to the preset main database; wherein the master database comprises a master database dictionary, and the project database dictionary is a subset of the master database dictionary.

2. The medical data subsidence method of claim 1, wherein the project data dictionary comprises a plurality of preset fields.

3. The medical data subsidence method of claim 2, wherein when saving the data to be subsided to a preset staging database, the method further comprises:

4. The medical data subsidence method of claim 1, wherein the master database comprises patient data, a master database dictionary for expressing the correspondence of the patient data and preset fields, and a master database data index;

wherein the master library data dictionary comprises a plurality of preset fields.

5. The medical data retrogradation method according to claim 4, wherein the extracting the data to be retrogradation from the preset temporary database according to the second trigger information for feeding back the first trigger information and saving the data to be retrogradation to a preset master database comprises:

6. The medical data subsidence method according to claim 1, wherein the target project database is created, and the patient data is extracted from the preset main database according to the preset rules corresponding to the target project database and stored in the backup database; and saving the patient data from the backup database to the target project database; the method comprises the following steps:

7. A medical data subsidence device, comprising:

the data extraction module is used for creating a target project database, extracting patient data from a preset main database according to preset rules corresponding to the target project database and storing the patient data in a backup database; and saving the patient data from the backup database to the target project database; and

the data merging module is used for extracting the data to be rewound from the preset temporary storage database according to second trigger information for feeding back the first trigger information, and performing data fusion on the data to be rewound and the preset main database so as to fuse the data to be rewound to the preset main database; wherein the master database comprises a master database dictionary, and the project database dictionary is a subset of the master database dictionary.

8. A storage medium having stored thereon a computer program which, when executed by a processor, implements a medical data subsidence method according to any one of claims 1-6.

9. An electronic terminal, comprising:

one or more processors; and

a memory for storing executable instructions of the processor;

wherein the processor is configured to perform the medical data subsidence method of one of claims 1-6 via execution of the executable instructions.