CN111026757B - Method, device, equipment and storage medium for generating standard statistical format data - Google Patents
Method, device, equipment and storage medium for generating standard statistical format data Download PDFInfo
- Publication number
- CN111026757B CN111026757B CN201911258630.8A CN201911258630A CN111026757B CN 111026757 B CN111026757 B CN 111026757B CN 201911258630 A CN201911258630 A CN 201911258630A CN 111026757 B CN111026757 B CN 111026757B
- Authority
- CN
- China
- Prior art keywords
- data
- standard
- statistical
- field
- fields
- 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.)
- Active
Links
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
- 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/25—Integrating or interfacing systems involving database management systems
- G06F16/258—Data format conversion from or to a database
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02A—TECHNOLOGIES FOR ADAPTATION TO CLIMATE CHANGE
- Y02A90/00—Technologies having an indirect contribution to adaptation to climate change
- Y02A90/10—Information and communication technologies [ICT] supporting adaptation to climate change, e.g. for weather forecasting or climate simulation
Abstract
The present application relates to the field of computer technologies, and in particular, to a method, an apparatus, a device, and a storage medium for generating standard statistical format data. The method comprises the following steps: receiving a field selection instruction carrying clinical trial data fields in a conventional field library through a form generation interface; generating a data receiving table according to the selected clinical trial data fields; based on the association relation between clinical trial data fields and medical research data standard fields in a standard field library, acquiring medical research data standard fields corresponding to the clinical trial data fields from the standard field library, generating a statistical data table according to the statistical format requirement of a statistical terminal, and storing the statistical data table into a statistical database; and receiving diagnosis data corresponding to each clinical test data field through the data receiving table, and storing the received diagnosis data into a statistic data table in a statistic database to obtain statistic format data. By adopting the method, the data processing efficiency can be improved.
Description
Technical Field
The present application relates to the field of computer technologies, and in particular, to a method and apparatus for generating standard statistical format data, a computer device, and a storage medium.
Background
With the long-term development of clinical medicine research, more and more enterprises in China begin to actively prepare the standard of clinical data interchange standard (the Clinical Data Interchange Standards Consortium, CDISC) for landing so as to promote the China medical industry and international connection, and participate in global competition.
In the traditional model, clinical trial data is typically collected in a form that does not meet the CDISC standard and then presented to the statistics. The statistics personnel convert the collected clinical test data into CDISC standard data and into a format required by statistics to carry out statistics, so that the middle needs to spend a large amount of manpower and material resources to carry out data processing, the data processing flow is complex, the efficiency is low, and the generation process of the statistical format data is not intelligent enough.
Disclosure of Invention
In view of the foregoing, it is desirable to provide a method, an apparatus, a computer device, and a storage medium for generating standard statistical format data, which can improve data processing efficiency and can generate statistical format data intelligently.
A method of generating standard statistical format data, the method comprising:
receiving a field selection instruction through a form generation interface, wherein the field selection instruction carries clinical trial data fields in a conventional field library;
generating a data receiving table according to the selected clinical trial data fields;
based on the association relation between the preset clinical test data field and the medical research data standard field in the standard field library, acquiring the medical research data standard field corresponding to the clinical test data field from the standard field library, generating a statistical data table according to the statistical format requirement of a statistical terminal, and storing the statistical data table into a statistical database, wherein the medical research data standard field in the standard field library is created according to the medical research data standard;
and receiving diagnosis data corresponding to each clinical test data field through the data receiving table, and storing the received diagnosis data into a statistic data table in a statistic database to obtain statistic format data.
In one embodiment, the establishing manner of the association relationship includes:
creating a standard field library corresponding to medical research data standards and a conventional field library corresponding to clinical trial data;
and establishing an association relation between clinical trial data fields in the conventional field library and traditional Chinese medicine research data standard fields in the standard field library.
In one embodiment, the method further comprises:
based on the association relation, acquiring medical research data standard fields corresponding to clinical test data fields from a standard field library, generating a standard data table according to medical research data standards, and storing the standard data table into a standard database;
and obtaining diagnosis data corresponding to each clinical trial data field received by the form in the conventional database, and storing the diagnosis data into a standard database to obtain standard data.
In one embodiment, the method further comprises:
receiving a change request for a data receiving table through a table generation interface;
based on the change request, the clinical trial data fields and the diagnostic data in the data receiving table are changed, and the diagnostic data in the statistical data table is correspondingly changed.
In one embodiment, after generating the data reception table from the selected clinical trial data fields, the method further comprises:
and receiving the preview instruction, and sending the generated data receiving table to the display terminal according to the preview instruction so that the display terminal displays the data receiving table.
In one embodiment, the method further comprises:
receiving a statistical request of a statistical terminal;
acquiring statistical format data based on the statistical request, and generating a comparison table corresponding to the medical research data standard field and the clinical test data field;
and sending the statistical format data and the comparison table to a statistical terminal.
A generation apparatus of standard statistical format data, comprising:
the first receiving module is used for receiving a field selection instruction through the form generation interface, wherein the field selection instruction carries clinical trial data fields in a conventional field library;
the data receiving table generating module is used for generating a data receiving table according to the selected clinical trial data fields;
the statistical data table generation module is used for acquiring medical research data standard fields corresponding to clinical test data fields from the standard field library based on the association relation between the preset clinical test data fields and the medical research data standard fields in the standard field library, generating a statistical data table according to the statistical format requirement of the statistical terminal, and storing the statistical data table into the statistical database, wherein the medical research data standard fields in the standard field library are created according to the medical research data standard;
and the statistical format data generation module is used for receiving the diagnosis data corresponding to each clinical test data field through the data receiving table, and storing the received diagnosis data into a statistical data table in the statistical database to obtain statistical format data.
In one embodiment, the apparatus further includes:
the creation module is used for creating a standard field library corresponding to the medical research data standard and a conventional field library corresponding to the clinical test data;
the association relation establishing module is used for establishing association relation between clinical test data fields in the conventional field library and medical research data standard fields in the standard field library.
A computer device comprising a memory storing a computer program and a processor implementing the steps of any one of the methods described above when the processor executes the computer program.
A computer readable storage medium having stored thereon a computer program which, when executed by a processor, implements the steps of the method of any of the preceding claims.
The method, the device, the computer equipment and the storage medium for generating the standard statistical data are characterized in that a data receiving table is generated through a field selection instruction received by a form generation interface, a medical research data standard field corresponding to a clinical test data field is obtained from a standard field library based on the association relation between a preset clinical test data field and a medical research data standard field in a standard field library, a statistical data table is generated according to the statistical format requirement of a statistical terminal, the statistical data table is stored in a statistical database, diagnostic data corresponding to each clinical test data field is further received through the data receiving table, and the received diagnostic data is stored in the statistical data table in the statistical database to obtain statistical format data. Therefore, the statistical format data in the statistical database is stored according to the medical research data standard and the statistical format requirement, and when the subsequent statistical terminal performs data statistical analysis, the statistical analysis can be directly performed by the statistical format data meeting the CDISC standard and the statistical format requirement, and the efficiency of the statistical analysis can be improved without performing an additional conversion process. In addition, in the scheme, the generation of the statistical format data is completely realized through the server, and standard conversion and statistical format conversion are not needed to be manually carried out, so that the statistical format data can be intelligently generated.
Drawings
FIG. 1 is an application scenario diagram of a method of generating standard statistical format data in one embodiment;
FIG. 2 is a flow chart of a method of generating standard statistical format data in one embodiment;
FIG. 3 is a block diagram of the structure of a device for generating standard statistical format data in one embodiment;
fig. 4 is an internal structural diagram of a computer device in one embodiment.
Detailed Description
The present application will be described in further detail with reference to the drawings and examples, in order to make the objects, technical solutions and advantages of the present application more apparent. It should be understood that the specific embodiments described herein are for purposes of illustration only and are not intended to limit the scope of the application.
The method for generating the standard statistical format data can be applied to an application environment shown in fig. 1. Wherein the terminal 102 communicates with the server 104 via a network. The terminal 102 may be a statistical terminal or a requesting terminal. Specifically, the server 104 may receive a field selection instruction through a form generation interface, the field selection instruction carrying clinical trial data fields in a conventional field library, and generate a data reception table according to the selected clinical trial data fields. Further, the server 104 may obtain a medical study data standard field corresponding to the clinical test data field from the standard field library based on a preset association relationship between the clinical test data field and the medical study data standard field in the standard field library, generate a statistical data table according to a statistical format requirement of the statistical terminal, store the statistical data table in the statistical database, then the server 104 receives diagnostic data corresponding to each clinical test data field through the data receiving table, and store the received diagnostic data in the statistical data table in the statistical database to obtain statistical format data. Further, when the terminal 102 needs to perform statistical analysis, the server 104 may acquire statistical format data and send the statistical format data to the terminal 102 for performing statistical analysis, or when the terminal 102 needs to perform display, the server 104 may send a data receiving table to the terminal 104 for displaying. The terminal 102 may be, but not limited to, various personal computers, notebook computers, smartphones, tablet computers, and portable wearable devices, and the server 104 may be implemented by a stand-alone server or a server cluster composed of a plurality of servers.
In one embodiment, as shown in fig. 2, a method for generating standard statistical format data is provided, and the method is applied to the server in fig. 1 for illustration, and may include the following steps:
step S202, receiving a field selection instruction through a form generation interface, wherein the field selection instruction carries clinical trial data fields in a conventional field library.
The form generation interface is a man-machine interaction interface, and a user can generate a corresponding field selection instruction by performing corresponding operation on the man-machine interface, wherein the field selection instruction can carry clinical trial data fields in a conventional field library.
The clinical test data field refers to a field corresponding to a diagnosis item, such as a "platelet", "average platelet volume", etc., and may also include some conventional fields, such as a "user name", "visit date", etc., when a diagnostic person performs an examination diagnosis in clinical diagnosis. The diagnostic data refers to specific numerical data corresponding to clinical trial data fields in clinical diagnosis, for example, visit date of "2018/1/1", platelet of "265", average platelet volume of "9.1", etc.
Step S204, a data receiving table is generated according to the selected clinical trial data fields.
The data receiving table is a table generated according to the selected clinical trial data field and used for receiving diagnostic data, as shown in table 1.
Table 1 data receiving table
| User name | Visit date | Platelets | Average platelet volume |
| A001 | 2018/1/1 | 265 | 9.1 |
Specifically, when the server receives a field selection instruction through the form generation interface, the field of the carried clinical test data may be written into the header of the data receiving table, for example, referring to table 1, fields such as "user name", "visit date", "platelet", "average platelet volume", etc. are written into the header and stored, so as to obtain the data receiving table for receiving diagnostic data.
Step S206, based on the association relation between the preset clinical test data field and the medical research data standard field in the standard field library, acquiring the medical research data standard field corresponding to the clinical test data field from the standard field library, generating a statistical data table according to the statistical format requirement of the statistical terminal, and storing the statistical data table in the statistical database.
Wherein, the medical research data standard fields in the standard field library are standard fields created according to the medical research data standard, i.e. created according to the CDISC standard, such as 'VISD', 'PLT', 'MPV', etc.
Specifically, there is a one-to-one or one-to-many association between the medical study data standard field and the clinical trial data field in the standard field library, for example, for the "MPV" field of the CDISC standard, the corresponding clinical trial data field may be "average platelet volume" or "platelet average volume" or "platelet volume average value", etc., while for the "PLT" field of the CDISC standard, the corresponding clinical trial data field may be only "platelet".
In this embodiment, the statistical terminal refers to a terminal that performs statistical analysis on medical study data, and may refer to a plurality of different statistical terminals, and the statistical format requirements of the statistical terminals may be different corresponding to different statistical terminals, so that the table structures of the generated statistical data tables may be different.
Specifically, after obtaining the corresponding standard field of medical research data from the standard field library according to the association relationship, the server generates a table structure of a statistical data table corresponding to different statistical terminals according to the statistical format requirements of different statistical terminals, and table 2 shows the table structure of a statistical data table in this embodiment.
Table 2 statistics table
| patient | VISD-V1 | PLT-V1 | MPV-V1 | VISD-V2 | PLT-V2 | MPV-V2 |
| A001 | 2018/1/1 | 265 | 9.1 | 2018/4/1 | 214 | 8.7 |
In particular, for medical study data, study analysis is generally performed on a patient with multiple diagnostic data, and it is necessary to count the multiple diagnostic data of the patient before the study is performed. Referring to table 2, the server generates a statistical data table for recording diagnostic data of the patient different times (V1 represents a first diagnosis, V2 represents a second diagnosis) in the row direction of the data table according to the requirement of the statistical format of the statistical terminal.
Step S208, receiving diagnosis data corresponding to each clinical trial data field through the data receiving table, and storing the received diagnosis data into a statistic data table in the statistic database to obtain statistic format data.
Specifically, referring to table 1, the server receives the diagnosis data of each clinical test data field through the data receiving table, such as "2018/1/1" corresponding to the "visit date" field, and stores it in the statistics data table, such as "2018/1/1" corresponding to the "visd-V1" field stored in table 2, etc., thereby obtaining statistics format data corresponding to the statistics format requirements of the statistics terminal.
In the method for generating the standard statistical format data, a data receiving table is generated through a field selection instruction received by a form generating interface, a medical research data standard field corresponding to a clinical test data field is obtained from a standard field library based on the association relation between a preset clinical test data field and the medical research data standard field in the standard field library, a statistical data table is generated according to the statistical format requirement of a statistical terminal, the statistical data table is stored in the statistical database, diagnostic data corresponding to each clinical test data field is further received through the data receiving table, and the received diagnostic data is stored in the statistical data table in the statistical database to obtain the statistical format data. Therefore, the statistical format data in the statistical database is stored according to the medical research data standard and the statistical format requirement, and when the subsequent statistical terminal performs data statistical analysis, the statistical analysis can be directly performed by the statistical format data meeting the CDISC standard and the statistical format requirement, and the efficiency of the statistical analysis can be improved without performing an additional conversion process. In addition, in the scheme, the generation of the statistical format data is completely realized through the server, and standard conversion and statistical format conversion are not needed to be manually carried out, so that the statistical format data can be intelligently generated.
In one embodiment, the association between the clinical trial data fields and the standard fields of the medical study data in the standard field library may be established by: creating a standard field library corresponding to medical research data standards and a conventional field library corresponding to clinical trial data; and establishing an association relation between clinical trial data fields in the conventional field library and traditional Chinese medicine research data standard fields in the standard field library.
Specifically, the server may obtain clinical trial data fields used in clinical trials according to the terminal indication, and build a conventional field library, and build a standard field library according to the CDISC standard.
Further, the server associates clinical trial data fields corresponding to the association operation with medical research data standard fields conforming to the CDISC standard based on the terminal association operation, and establishes an association relationship between the clinical trial data fields and the medical research data standard fields. Specifically, as described above, there is a one-to-one or one-to-many association between the medical study data standard fields and the clinical trial data fields in the standard field library, which the present application is not limited to.
In the above embodiment, by establishing the standard field library and the conventional field library corresponding to the clinical test data, and establishing the association relationship between the clinical test data field in the conventional field library and the medical research data standard field in the standard field library, the corresponding medical research data standard field can be obtained through the field selection instruction corresponding to the clinical test data field, and the statistical data table corresponding to the CDISC standard is generated, so that standard conversion can be performed without manual operation, and the processing efficiency can be improved.
In one embodiment, the method may further include: based on the association relation, acquiring medical research data standard fields corresponding to clinical test data fields from a standard field library, generating a standard data table according to medical research data standards, and storing the standard data table into a standard database; and obtaining diagnosis data corresponding to each clinical trial data field received by the form in the conventional database, and storing the diagnosis data into a standard database to obtain standard data.
The standard data table refers to a table generated according to the standard field of medical study data of the CDISC standard, and the table structure may be different according to different storage requirements, and fig. 3 shows a table structure of a standard data table.
Table 3 standard data table
| patient | VIS | VISDAT | LBPLT | LBMPV |
| A001 | V1 | 2018/1/1 | 265 | 9.1 |
| A001 | V2 | 2018/4/1 | 214 | 8.7 |
In table 3, the medical study data standard field whose header is the CDISC standard stores the multiple diagnostic data (first diagnostic data is V1 and second diagnostic data is V2) of the same user name "a001" in order according to the column direction of the table according to the storage requirement.
In the above embodiment, the standard data table is generated, and the standard data of the CDISC standard is generated according to the acquired diagnostic data, and when the standard data is required to be exported according to the CDISC data, the generated standard data is directly exported, so that the intermediate manual conversion process of the CDISC standard is saved, and the human resources are saved.
In one embodiment, the method may further include: receiving a change request for a data receiving table through a table generation interface; based on the change request, the clinical trial data fields and the diagnostic data in the data receiving table are changed, and the diagnostic data in the statistical data table is correspondingly changed.
Where the change request refers to a request for clinical trial data fields or for diagnostic data, the changed data may be included as well as the changed data.
Specifically, the server may receive a change request instruction through the form generation interface, and change the clinical trial data field or the diagnostic data in the data receiving table, for example, change the clinical trial data field "average platelet volume" to "platelet average volume", change the diagnostic data "9.1" of the "platelet" field to "9.0", and so on. Similarly, the server may correspondingly alter the diagnostic data in the statistics table.
Optionally, after the server alters the clinical trial data fields in the data receiving table, the altered fields can be stored in a conventional field library, and an association relationship between the altered fields and the medical research data standard fields is established. For example, after the previous example is used to change the "average platelet volume" of the clinical test data field into the "average platelet volume", if the "average platelet volume" field does not exist in the conventional field library, the field may be stored in the conventional field library to obtain the "average platelet volume" of the clinical test data field, and the association relationship between the "average platelet volume" of the clinical test data field and the "MPV" field of the CDISC standard is established.
In the above embodiment, the data receiving table and the statistical data table are automatically changed through the change request received by the form generating interface, without redundant operation flow, so that the processing efficiency can be improved.
In one embodiment, after generating the data reception table from the selected clinical trial data fields, the method may further comprise: and receiving the preview instruction, and sending the generated data receiving table to the display terminal according to the preview instruction so that the display terminal displays the data receiving table.
The preview instruction refers to an instruction sent by the display terminal, and may include a preview request for the data receiving table.
Specifically, when receiving the preview instruction, the server may send the acquired clinical test data field and the corresponding diagnostic data in the data receiving table to the display terminal, so as to generate an html page through the display terminal according to a preset display requirement, and display the html page. Or the server can directly generate an html page according to the display requirement and send the html page to the display terminal to display the html page through the display terminal.
In the embodiment, the display terminal is used for displaying, so that clinical test data fields and diagnosis data can be visually seen, and modification or addition is facilitated.
In one embodiment, the method may further include: receiving a statistical request of a statistical terminal; acquiring statistical format data based on the statistical request, and generating a comparison table corresponding to the medical research data standard field and the clinical test data field; and sending the statistical format data and the comparison table to a statistical terminal.
The statistical request is a request sent by the statistical terminal for performing statistical analysis on the statistical format data.
As mentioned above, the statistical format data may be data corresponding to different statistical format requirements, respectively, i.e. corresponding to different statistical terminals, respectively. The statistics request may carry an identifier of the statistics terminal, and the server may determine the corresponding statistics terminal according to the identifier in the statistics request, and determine statistics format data corresponding to the statistics terminal, so as to send the statistics format data to the statistics terminal.
The lookup table may be a lookup table between a standard field of medical study data and a corresponding field of clinical trial data in the corresponding statistical format data, as shown in table 4.
Table 4 comparison table
| Clinical trial data field | Medical research data standard field |
| Visit date | VISD |
| Platelets | PLT |
| Average platelet volume | MPV |
Specifically, when the server receives a statistics request sent by the statistics terminal, the server may correspond to a comparison table of medical research data standard fields for generating statistics format data, and send the comparison table to the statistics terminal, so as to facilitate identification of statistics personnel of the statistics terminal.
In the above embodiment, when the statistical request of the statistical terminal is received, the comparison table corresponding to the medical research data standard field and the clinical test data field is generated and sent to the statistical terminal, so that when the statistical staff is unfamiliar with the medical research data standard, the statistical staff can look up according to the sent comparison table to perform corresponding statistical analysis, thereby improving convenience and improving efficiency of the statistical analysis.
It should be understood that, although the steps in the flowchart of fig. 2 are shown in sequence as indicated by the arrows, the steps are not necessarily performed in sequence as indicated by the arrows. The steps are not strictly limited to the order of execution unless explicitly recited herein, and the steps may be executed in other orders. Moreover, at least some of the steps in fig. 2 may include multiple sub-steps or stages that are not necessarily performed at the same time, but may be performed at different times, nor do the order in which the sub-steps or stages are performed necessarily performed in sequence, but may be performed alternately or alternately with at least a portion of the sub-steps or stages of other steps or other steps.
In one embodiment, as shown in fig. 3, there is provided a generating apparatus of standard statistical format data, including: a first receiving module 100, a data receiving table generating module 200, a statistical data table generating module 300, and a statistical format data generating module 400, wherein:
the first receiving module 100 is configured to receive, through the form generation interface, a field selection instruction, where the field selection instruction carries a clinical trial data field in a conventional field library.
The data receiving table generating module 200 is configured to generate a data receiving table according to the selected clinical trial data field.
The statistical data table generating module 300 is configured to obtain, from the standard field library, a medical study data standard field corresponding to the clinical test data field based on a preset association relationship between the clinical test data field and the medical study data standard field in the standard field library, and generate a statistical data table according to a statistical format requirement of the statistical terminal, and store the statistical data table in the statistical database, where the medical study data standard field in the standard field library is created according to a medical study data standard.
The statistical format data generating module 400 is configured to receive diagnostic data corresponding to each clinical test data field through the data receiving table, and store the received diagnostic data into the statistical data table in the statistical database, so as to obtain statistical format data.
In one embodiment, the apparatus may further include:
the creation module is used for creating a standard field library corresponding to the medical research data standard and a conventional field library corresponding to the clinical trial data.
The association relation establishing module is used for establishing association relation between clinical test data fields in the conventional field library and medical research data standard fields in the standard field library.
In one embodiment, the apparatus may further include:
the standard data table generation module is used for acquiring medical research data standard fields corresponding to clinical test data fields from the standard field library based on the association relation, generating a standard data table according to the medical research data standard, and storing the standard data table into the standard database.
The standard data generation module is used for acquiring diagnosis data corresponding to each clinical test data field received by the form in the conventional database, and storing the diagnosis data into the standard database to obtain standard data.
In one embodiment, the apparatus may further include:
and the second receiving module is used for receiving a change request for the data receiving table through the table generation interface.
And the change module is used for changing clinical trial data fields and diagnostic data in the data receiving table based on the change request and correspondingly changing the diagnostic data in the statistical data table.
In one embodiment, the apparatus may further include: and the first sending module is used for receiving the preview instruction after the data receiving table generating module 200 generates the data receiving table according to the selected clinical trial data field, and sending the generated data receiving table to the display terminal according to the preview instruction so as to enable the display terminal to display the data receiving table.
In one embodiment, the apparatus may further include:
and the third receiving module is used for receiving the statistical request of the statistical terminal.
And the comparison table generation module is used for acquiring the statistical format data based on the statistical request and generating a comparison table corresponding to the medical research data standard field and the clinical test data field.
And the second sending module is used for sending the statistic format data and the comparison table to the statistic terminal.
For specific limitations on the generation means of the standard statistical format data, reference may be made to the above limitations on the generation method of the standard statistical format data, and no further description is given here. The modules in the generation device of the standard statistical format data can be all or partially implemented by software, hardware and a combination thereof. The above modules may be embedded in hardware or may be independent of a processor in the computer device, or may be stored in software in a memory in the computer device, so that the processor may call and execute operations corresponding to the above modules.
In one embodiment, a computer device is provided, which may be a server, the internal structure of which may be as shown in fig. 4. The computer device includes a processor, a memory, a network interface, and a database connected by a system bus. Wherein the processor of the computer device is configured to provide computing and control capabilities. The memory of the computer device includes a non-volatile storage medium and an internal memory. The non-volatile storage medium stores an operating system, computer programs, and a database. The internal memory provides an environment for the operation of the operating system and computer programs in the non-volatile storage media. The database of the computer device is used for storing standard data, statistical format data and the like. The network interface of the computer device is used for communicating with an external terminal through a network connection. The computer program is executed by a processor to implement a method of generating standard statistical format data.
It will be appreciated by persons skilled in the art that the architecture shown in fig. 4 is merely a block diagram of some of the architecture relevant to the present inventive arrangements and is not limiting as to the computer device to which the present inventive arrangements are applicable, and that a particular computer device may include more or fewer components than shown, or may combine some of the components, or have a different arrangement of components.
In one embodiment, a computer device is provided comprising a memory storing a computer program and a processor that when executing the computer program can implement the steps of: receiving a field selection instruction through a form generation interface, wherein the field selection instruction carries clinical trial data fields in a conventional field library; generating a data receiving table according to the selected clinical trial data fields; based on the association relation between the preset clinical test data field and the medical research data standard field in the standard field library, acquiring the medical research data standard field corresponding to the clinical test data field from the standard field library, generating a statistical data table according to the statistical format requirement of a statistical terminal, and storing the statistical data table into a statistical database, wherein the medical research data standard field in the standard field library is created according to the medical research data standard; and receiving diagnosis data corresponding to each clinical test data field through the data receiving table, and storing the received diagnosis data into a statistic data table in a statistic database to obtain statistic format data.
In one embodiment, the processor, when executing the computer program, may further implement the steps of: creating a standard field library corresponding to medical research data standards and a conventional field library corresponding to clinical trial data; and establishing an association relation between clinical trial data fields in the conventional field library and traditional Chinese medicine research data standard fields in the standard field library.
In one embodiment, the processor, when executing the computer program, may further implement the steps of: based on the association relation, acquiring medical research data standard fields corresponding to clinical test data fields from a standard field library, generating a standard data table according to medical research data standards, and storing the standard data table into a standard database; and obtaining diagnosis data corresponding to each clinical trial data field received by the form in the conventional database, and storing the diagnosis data into a standard database to obtain standard data.
In one embodiment, the processor, when executing the computer program, may further implement the steps of: receiving a change request for a data receiving table through a table generation interface; based on the change request, the clinical trial data fields and the diagnostic data in the data receiving table are changed, and the diagnostic data in the statistical data table is correspondingly changed.
In one embodiment, after the processor, when executing the computer program, implements generating the data receiving table from the selected clinical trial data fields, the following steps may also be implemented: and receiving the preview instruction, and sending the generated data receiving table to the display terminal according to the preview instruction so that the display terminal displays the data receiving table.
In one embodiment, the processor, when executing the computer program, may further implement the steps of: receiving a statistical request of a statistical terminal; acquiring statistical format data based on the statistical request, and generating a comparison table corresponding to the medical research data standard field and the clinical test data field; and sending the statistical format data and the comparison table to a statistical terminal.
In one embodiment, a computer readable storage medium is provided having a computer program stored thereon, which when executed by a processor, can implement the steps of: receiving a field selection instruction through a form generation interface, wherein the field selection instruction carries clinical trial data fields in a conventional field library; generating a data receiving table according to the selected clinical trial data fields; based on the association relation between the preset clinical test data field and the medical research data standard field in the standard field library, acquiring the medical research data standard field corresponding to the clinical test data field from the standard field library, generating a statistical data table according to the statistical format requirement of a statistical terminal, and storing the statistical data table into a statistical database, wherein the medical research data standard field in the standard field library is created according to the medical research data standard; and receiving diagnosis data corresponding to each clinical test data field through the data receiving table, and storing the received diagnosis data into a statistic data table in a statistic database to obtain statistic format data.
In one embodiment, the computer program may further implement the following steps when executed by a processor: creating a standard field library corresponding to medical research data standards and a conventional field library corresponding to clinical trial data; and establishing an association relation between clinical trial data fields in the conventional field library and traditional Chinese medicine research data standard fields in the standard field library.
In one embodiment, the computer program may further implement the following steps when executed by a processor: based on the association relation, acquiring medical research data standard fields corresponding to clinical test data fields from a standard field library, generating a standard data table according to medical research data standards, and storing the standard data table into a standard database; and obtaining diagnosis data corresponding to each clinical trial data field received by the form in the conventional database, and storing the diagnosis data into a standard database to obtain standard data.
In one embodiment, the computer program may further implement the following steps when executed by a processor: receiving a change request for a data receiving table through a table generation interface; based on the change request, the clinical trial data fields and the diagnostic data in the data receiving table are changed, and the diagnostic data in the statistical data table is correspondingly changed.
In one embodiment, after the computer program is executed by the processor to implement the generation of the data receiving table from the selected clinical trial data fields, the following steps may also be implemented: and receiving the preview instruction, and sending the generated data receiving table to the display terminal according to the preview instruction so that the display terminal displays the data receiving table.
In one embodiment, the computer program may further implement the following steps when executed by a processor: receiving a statistical request of a statistical terminal; acquiring statistical format data based on the statistical request, and generating a comparison table corresponding to the medical research data standard field and the clinical test data field; and sending the statistical format data and the comparison table to a statistical terminal.
Those skilled in the art will appreciate that implementing all or part of the above described methods may be accomplished by way of a computer program stored on a non-transitory computer readable storage medium, which when executed, may comprise the steps of the embodiments of the methods described above. Any reference to memory, storage, database, or other medium used in embodiments provided herein may include non-volatile and/or volatile memory. The nonvolatile memory can include Read Only Memory (ROM), programmable ROM (PROM), electrically Programmable ROM (EPROM), electrically Erasable Programmable ROM (EEPROM), or flash memory. Volatile memory can include Random Access Memory (RAM) or external cache memory. By way of illustration and not limitation, RAM is available in a variety of forms such as Static RAM (SRAM), dynamic RAM (DRAM), synchronous DRAM (SDRAM), double Data Rate SDRAM (DDRSDRAM), enhanced SDRAM (ESDRAM), synchronous Link DRAM (SLDRAM), memory bus direct RAM (RDRAM), direct memory bus dynamic RAM (DRDRAM), and memory bus dynamic RAM (RDRAM), among others.
The technical features of the above embodiments may be arbitrarily combined, and all possible combinations of the technical features in the above embodiments are not described for brevity of description, however, as long as there is no contradiction between the combinations of the technical features, they should be considered as the scope of the description.
The above examples illustrate only a few embodiments of the application, which are described in detail and are not to be construed as limiting the scope of the application. It should be noted that it will be apparent to those skilled in the art that several variations and modifications can be made without departing from the spirit of the application, which are all within the scope of the application. Accordingly, the scope of protection of the present application is to be determined by the appended claims.
Claims (10)
1. A method of generating standard statistical format data, the method comprising:
receiving a field selection instruction through a form generation interface, wherein the field selection instruction carries clinical trial data fields in a conventional field library;
generating a data receiving table according to the selected clinical trial data fields;
based on the association relation between the preset clinical test data field and the medical research data standard field in the standard field library, acquiring the medical research data standard field corresponding to the clinical test data field from the standard field library, generating a statistical data table according to the statistical format requirement of a statistical terminal, and storing the statistical data table into a statistical database, wherein the medical research data standard field in the standard field library is created according to the medical research data standard;
receiving diagnosis data corresponding to each clinical test data field through the data receiving table, and storing the received diagnosis data into a statistic data table in the statistic database to obtain statistic format data;
receiving a change request for the data receiving table through a table generation interface;
based on the change request, changing clinical trial data fields and diagnostic data in the data receiving table, and automatically correspondingly changing the diagnostic data in the statistical data table.
2. The method according to claim 1, wherein the establishing manner of the association relationship includes:
creating a standard field library corresponding to medical research data standards and a conventional field library corresponding to clinical trial data;
and establishing an association relation between the clinical test data field in the conventional field library and the traditional Chinese medicine research data standard field in the standard field library.
3. The method according to claim 1, wherein the method further comprises:
based on the association relation, acquiring a medical research data standard field corresponding to the clinical test data field from the standard field library, generating a standard data table according to a medical research data standard, and storing the standard data table into a standard database;
and obtaining diagnosis data corresponding to each clinical trial data field received by a form in a conventional database, and storing the diagnosis data into the standard database to obtain standard data.
4. The method according to claim 1, wherein the method further comprises:
after the clinical trial data fields in the data receiving table are changed, storing the changed clinical trial data fields into the conventional field library;
and establishing an association relationship between the modified clinical trial data field and the medical research data standard field.
5. The method of claim 1, wherein after generating the data reception table from the selected clinical trial data fields, the method further comprises:
and receiving a preview instruction, and sending the generated data receiving table to a display terminal according to the preview instruction so that the display terminal displays the data receiving table.
6. The method according to claim 1, wherein the method further comprises:
receiving a statistical request of a statistical terminal;
acquiring the statistical format data based on the statistical request, and generating a comparison table corresponding to the medical research data standard field and the clinical test data field;
and sending the statistical format data and the comparison table to the statistical terminal.
7. A device for generating standard statistical format data, comprising:
the first receiving module is used for receiving a field selection instruction through a form generation interface, wherein the field selection instruction carries clinical trial data fields in a conventional field library;
the data receiving table generating module is used for generating a data receiving table according to the selected clinical trial data fields;
the statistical data table generation module is used for acquiring medical research data standard fields corresponding to the clinical test data fields from the standard field library based on the preset association relation between the clinical test data fields and the medical research data standard fields in the standard field library, generating a statistical data table according to the statistical format requirement of a statistical terminal, and storing the statistical data table into a statistical database, wherein the medical research data standard fields in the standard field library are created according to the medical research data standard;
the statistical format data generation module is used for receiving diagnosis data corresponding to each clinical test data field through the data receiving table, and storing the received diagnosis data into a statistical data table in the statistical database to obtain statistical format data;
a change request receiving module for receiving a change request of the data receiving table through a table generation interface;
and the statistical data changing module is used for changing clinical trial data fields and diagnostic data in the data receiving table based on the changing request and automatically correspondingly changing the diagnostic data in the statistical data table.
8. The apparatus of claim 7, wherein the apparatus further comprises:
the creation module is used for creating a standard field library corresponding to the medical research data standard and a conventional field library corresponding to the clinical test data;
and the association relation establishing module is used for establishing association relation between clinical test data fields in the conventional field library and traditional Chinese medicine research data standard fields in the standard field library.
9. A computer device comprising a memory and a processor, the memory storing a computer program, characterized in that the processor implements the steps of the method of any of claims 1 to 6 when the computer program is executed.
10. A computer readable storage medium, on which a computer program is stored, characterized in that the computer program, when being executed by a processor, implements the steps of the method of any of claims 1 to 6.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911258630.8A CN111026757B (en) | 2019-12-10 | 2019-12-10 | Method, device, equipment and storage medium for generating standard statistical format data |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911258630.8A CN111026757B (en) | 2019-12-10 | 2019-12-10 | Method, device, equipment and storage medium for generating standard statistical format data |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN111026757A CN111026757A (en) | 2020-04-17 |
| CN111026757B true CN111026757B (en) | 2023-10-10 |
Family
ID=70205289
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201911258630.8A Active CN111026757B (en) | 2019-12-10 | 2019-12-10 | Method, device, equipment and storage medium for generating standard statistical format data |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111026757B (en) |
Families Citing this family (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113986343B (en) * | 2021-10-22 | 2023-11-21 | 上海太美数字科技有限公司 | Program module acquisition method, program module acquisition device, computer equipment and storage medium |
| CN114168544B (en) * | 2021-11-17 | 2023-10-27 | 上海太美数字科技有限公司 | Clinical trial data processing method, device, computer equipment and storage medium |
| CN115757423B (en) * | 2022-11-29 | 2024-01-30 | 中诚智信工程咨询集团股份有限公司 | Engineering cost data correction method, system, equipment and storage medium |
Citations (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2013009890A2 (en) * | 2011-07-13 | 2013-01-17 | The Multiple Myeloma Research Foundation, Inc. | Methods for data collection and distribution |
| CN105787282A (en) * | 2016-03-24 | 2016-07-20 | 国家卫生计生委统计信息中心 | Automatic standardization method and system for medical data dictionaries |
| CN108829727A (en) * | 2018-05-09 | 2018-11-16 | 上海陆家嘴国际金融资产交易市场股份有限公司 | Date storage method, device, computer equipment and storage medium |
| CN109189769A (en) * | 2018-08-14 | 2019-01-11 | 平安医疗健康管理股份有限公司 | Data standardization processing method, device, computer equipment and storage medium |
| CN109325030A (en) * | 2018-09-03 | 2019-02-12 | 平安国际融资租赁有限公司 | Message processing method, device, computer equipment and storage medium |
| CN109346163A (en) * | 2018-12-21 | 2019-02-15 | 邬超 | Data transfer device, equipment and system |
| CN109597801A (en) * | 2018-11-14 | 2019-04-09 | 金色熊猫有限公司 | Medical data standardized management method and system, electronic equipment, storage medium |
| CN109710677A (en) * | 2018-12-27 | 2019-05-03 | 长沙通诺信息科技有限责任公司 | Processing for Data Analysis in Physics, device, computer equipment and storage medium |
| CN110276002A (en) * | 2019-06-26 | 2019-09-24 | 浙江大搜车软件技术有限公司 | Search for application data processing method, device, computer equipment and storage medium |
Family Cites Families (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20090319535A1 (en) * | 2008-06-20 | 2009-12-24 | Webber Robert C | System and method for interacting with clinical trial operational data |
| US20150186618A1 (en) * | 2013-12-30 | 2015-07-02 | Robert POORVIN | Medical research information exchange system |
-
2019
- 2019-12-10 CN CN201911258630.8A patent/CN111026757B/en active Active
Patent Citations (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2013009890A2 (en) * | 2011-07-13 | 2013-01-17 | The Multiple Myeloma Research Foundation, Inc. | Methods for data collection and distribution |
| CN105787282A (en) * | 2016-03-24 | 2016-07-20 | 国家卫生计生委统计信息中心 | Automatic standardization method and system for medical data dictionaries |
| CN108829727A (en) * | 2018-05-09 | 2018-11-16 | 上海陆家嘴国际金融资产交易市场股份有限公司 | Date storage method, device, computer equipment and storage medium |
| CN109189769A (en) * | 2018-08-14 | 2019-01-11 | 平安医疗健康管理股份有限公司 | Data standardization processing method, device, computer equipment and storage medium |
| CN109325030A (en) * | 2018-09-03 | 2019-02-12 | 平安国际融资租赁有限公司 | Message processing method, device, computer equipment and storage medium |
| CN109597801A (en) * | 2018-11-14 | 2019-04-09 | 金色熊猫有限公司 | Medical data standardized management method and system, electronic equipment, storage medium |
| CN109346163A (en) * | 2018-12-21 | 2019-02-15 | 邬超 | Data transfer device, equipment and system |
| CN109710677A (en) * | 2018-12-27 | 2019-05-03 | 长沙通诺信息科技有限责任公司 | Processing for Data Analysis in Physics, device, computer equipment and storage medium |
| CN110276002A (en) * | 2019-06-26 | 2019-09-24 | 浙江大搜车软件技术有限公司 | Search for application data processing method, device, computer equipment and storage medium |
Non-Patent Citations (2)
| Title |
|---|
| Ting Tin Tin et al..B2B Standardized Information Interchange Challenges - A Study on Standardization versus Personalization.《2009 International Association of Computer Science and Information Technology - Spring Conference》.2009,第244-248页. * |
| 蔡永敏等.基于现代名老中医临床著作的肺病数据库建立及数据挖掘.中国中西医结合杂志.2015,第35卷(第10期),第1186-1191页. * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN111026757A (en) | 2020-04-17 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN111026757B (en) | Method, device, equipment and storage medium for generating standard statistical format data | |
| CN108874926B (en) | Mass data query method, device, computer equipment and storage medium | |
| CN112071425B (en) | Data processing method and device, computer equipment and storage medium | |
| CN108899064A (en) | Electronic health record generation method, device, computer equipment and storage medium | |
| CN111078910A (en) | Medical image storage method, device, system, equipment and storage medium | |
| US11449986B2 (en) | Enhancing medical imaging workflows using artificial intelligence | |
| US10769363B2 (en) | System and methods for transmitting clinical data having multi-segment fields from one or more modalities to a dictation machine | |
| CN107038329B (en) | Online processing method and device for medical image file | |
| JP6328768B2 (en) | Metadata automation system | |
| CN112150376A (en) | Blood vessel medical image analysis method and device, computer equipment and storage medium | |
| CN112527923A (en) | Unstructured data storage method and device, computer equipment and storage medium | |
| US20200321098A1 (en) | System and method for viewing medical image | |
| Zhang et al. | Healthcare-based on cloud electrocardiogram system: a medical center experience in middle Taiwan | |
| CN203706207U (en) | Compression medical image storage transmission system based on cloud storage | |
| CN109542962B (en) | Data processing method, data processing device, computer equipment and storage medium | |
| US20160078173A1 (en) | Method for editing data and associated data processing system or data processing system assembly | |
| CN116030950A (en) | Medical data integration management method | |
| US20170132321A1 (en) | System and Methods for Transmitting Clinical Data from One or More Sending Applications to a Dictation System | |
| Dong | Using the diffusion of innovation theory to understand the challenges and opportunities to advancing use of nutrigenetics in clinical practice | |
| US9734286B2 (en) | System and method for splitting DICOM medical image series into framesets | |
| CN112286879A (en) | Metadata-based data asset construction method and device | |
| CN111311587A (en) | Medical image data processing method, medical image data processing device, medical information system and medium | |
| CN110807310B (en) | Method, apparatus and storage medium for evaluating X-ray film analysis results | |
| US20240087740A1 (en) | Augmenting files such as dicom objects containing medical imaging information with additional medical information about the subject of the medical imaging information | |
| CN112559333B (en) | Log production method and device, computer 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 | ||
| CB02 | Change of applicant information |
Address after: No.95, Yong'an Road, Xicheng District, Beijing 100032 Applicant after: BEIJING FRIENDSHIP HOSPITAL, CAPITAL MEDICAL University Applicant after: Shanghai Aisha Medical Technology Co.,Ltd. Address before: No.95, Yong'an Road, Xicheng District, Beijing 100032 Applicant before: BEIJING FRIENDSHIP HOSPITAL, CAPITAL MEDICAL University Applicant before: SHANGHAI ASHERMED INFORMATION TECHNOLOGY CO.,LTD. |
|
| CB02 | Change of applicant information | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |