Automatic report generation method and device for laboratory information management system

Abstract

The invention discloses an automatic report generation method and device for a laboratory information management system, and the method comprises the steps: collecting original data of different upper computers, cleaning the original data corresponding to each upper computer, transmitting the cleaned original data to a first data block pool, obtaining a first data source, and distributing a unique identifier for each data; summarizing data in the first data source to obtain summarized data, sending the summarized data to a second data block pool to obtain a second data source, extracting data in the second data source based on a preset extraction rule to obtain a data packet, sending the data packet to a third data block pool, and sending the third data block pool to the second data block pool; according to the calling application information and the unique identifier, the data packet in the third data block pool is called, and the corresponding report is generated, according to the method, the data is accurately recognized and summarized when facing complex data from different sources, and the accuracy of automatically generating the report is improved.

Description

Technical Field

[0001] The present invention relates to the field of system function technology, and in particular to a method and device for automatically generating reports for a laboratory information management system. Background Art

[0002] Currently, the test reports issued by testing laboratories include the following two forms: one is to manually download the original data, process the data, and make a report; the other is to manually download the original data and make a report through the LIMS laboratory information management system. For these two forms, only manual sampling and review can be done at present. This process consumes a lot of manpower and time, and the quality of the report cannot be guaranteed. Therefore, a module is usually designed that can automatically collect data from multiple instruments and equipment and support automatic generation of test reports and reviews. However, the current automatic generation of test reports has the following problems:

[0003] First, the data formats and communication methods of various instruments and equipment are diverse, and they cannot effectively handle data encryption, data structuring and data timeliness. Second, laboratory data is huge, and when faced with complex data, it is impossible to aggregate and integrate single data for storage and conduct a certain degree of data mining and analysis. Third, how to identify and judge large amounts of data during the testing process to ensure the accuracy and authenticity of automatically generated reports and their anti-counterfeiting inspection and supervision functions. Summary of the invention

[0004] In order to solve the above technical problems, an embodiment of the present invention provides a method and device for automatically generating reports for a laboratory information management system, so as to solve the technical problems that the prior art cannot accurately identify and summarize data when faced with complex data from different sources, and the automatically generated reports have low accuracy.

[0005] A first aspect of an embodiment of the present invention provides a method for automatically generating a report for a laboratory information management system, the method comprising:

[0006] Obtain the original data of each host computer;

[0007] Cleaning the original data corresponding to each host computer to obtain cleaned data corresponding to each host computer, sending each cleaned data to the first data block pool to obtain the first data source, and assigning a unique identifier to each data based on basic information of each data in the first data source;

[0008] Summarize the data in the first data source to obtain summarized data, send the summarized data to the second data block pool to obtain the second data source, extract the data in the second data source based on preset extraction rules to obtain a data packet, send the data packet to the third data block pool, call the data packet in the third data block pool according to the call application information and the unique identifier corresponding to each data, and generate a corresponding report.

[0009] In a possible implementation of the first aspect, obtaining the original data of each host computer is to use a transfer tool to obtain the original data of each host computer, and using the transfer tool to obtain the original data of each host computer includes:

[0010] Based on the collection requirements, configure the parameters of the transfer tool. After completing the parameter configuration, use the transfer tool to collect the original data in the host computer;

[0011] Alternatively, the original data of each host computer is obtained by using an interface in the host computer to obtain the original data of each host computer, and the interface includes a serial port interface or a gateway interface.

[0012] In a possible implementation of the first aspect, when the original data of each host computer is obtained by using a transfer tool, the original data of each host computer is obtained by using the transfer tool, further comprising:

[0013] If the account, password and structure design of the database of the host computer are obtained, the original data in the host computer is collected according to the extraction strategy configured by the structure design after connecting to the database of the host computer using the driver package according to the account and password of the database, so as to obtain the original data of each host computer;

[0014] If the account and password of the database of the host computer are not obtained, the original data in the host computer is saved in the local database, and the original data in the local database is obtained by using file sharing to obtain the original data of each host computer.

[0015] In a possible implementation of the first aspect, data cleaning is performed on raw data corresponding to each host computer to obtain cleaned data corresponding to each host computer, including:

[0016] Screen the original data corresponding to each host computer to obtain duplicate data, data that does not meet the preset conditions, and missing data;

[0017] Delete the duplicate data and the data that does not meet the preset conditions, supplement the missing data, and obtain the cleaned data corresponding to each host computer.

[0018] In a possible implementation manner of the first aspect, aggregating the data in the first data source to obtain aggregated data includes:

[0019] The data from different data sources in the first data source are aggregated and aggregating to obtain aggregated data.

[0020] In a possible implementation manner of the first aspect, when aggregating the data in the first data source, the method further includes:

[0021] Based on the set abnormal value judgment range, the data in the first data source is judged to be abnormal. If the data is not within the abnormal value judgment range, the data is determined to be an abnormal value and a reminder message is issued.

[0022] In a possible implementation manner of the first aspect, when calling the data packets in the third data block pool according to the calling application information and the unique identifier corresponding to each data, it also includes:

[0023] If the called data packet exceeds the preset parameter range, the call is not allowed and a warning message is issued.

[0024] In order to solve the same technical problem, a second aspect of an embodiment of the present invention provides a report automatic generation device for a laboratory information management system, the device comprising:

[0025] The acquisition module is used to obtain the original data of each host computer;

[0026] A data cleaning module is used to clean the original data corresponding to each host computer to obtain the cleaned data corresponding to each host computer, send each cleaned data to the first data block pool to obtain the first data source, and assign a unique identifier to each data based on the basic information of each data in the first data source;

[0027] The report generation module is used to summarize the data in the first data source to obtain the summarized data, send the summarized data to the second data block pool to obtain the second data source, extract the data in the second data source based on the preset extraction rules to obtain the data packet, send the data packet to the third data block pool, call the data packet in the third data block pool according to the call application information and the unique identifier corresponding to each data, and generate a corresponding report.

[0028] A third aspect of an embodiment of the present invention provides a computer device, including:

[0029] Memory for storing computer programs;

[0030] A processor is used to implement the steps of the method for automatically generating a report in a laboratory information management system according to the first aspect when executing a computer program.

[0031] A fourth aspect of an embodiment of the present invention provides a storage medium having a computer program stored thereon. When the computer program is executed by a processor, the steps of the method for automatically generating a report for a laboratory information management system according to the first aspect are implemented.

[0032] The technical solution of the present invention has the following advantages:

[0033] The automatic report generation method of the laboratory information management system provided by the embodiment of the present invention collects the original data of different host computers, and then cleans the original data corresponding to each host computer, and sends it to the first data block pool to obtain the first data source, and assigns a unique identifier to each data based on the basic information of each data in the first data source; summarizes the data in the first data source to obtain the summarized data, and sends the summarized data to the second data block pool to obtain the second data source, and extracts the data in the second data source based on the preset extraction rules to obtain a data packet, and sends the data packet to the third data block pool, and calls the data packet in the third data block pool according to the call application information and the unique identifier. The above method cleans and summarizes the original data from different sources and stores them in the same database, thereby facilitating the subsequent custom extraction of data according to user needs and the unique identifier assigned to the data to generate reports, and ensuring the accuracy of the automatically generated reports. BRIEF DESCRIPTION OF THE DRAWINGS

[0034] In order to more clearly illustrate the specific implementation methods of the present invention or the technical solutions in the prior art, the drawings required for use in the specific implementation methods or the description of the prior art will be briefly introduced below. Obviously, the drawings described below are some implementation methods of the present invention. For ordinary technicians in this field, other drawings can be obtained based on these drawings without paying any creative work.

[0035] Figure 1 Flow chart of a method for automatically generating reports for a laboratory information management system according to an embodiment of the present invention;

[0036] Figure 2 It is a structural diagram of the HDFS data warehouse module of the method for automatically generating reports for the laboratory information management system in an embodiment of the present invention;

[0037] Figure 3 It is a structural block diagram of the automatic report generation device of the laboratory information management system in an embodiment of the present invention. DETAILED DESCRIPTION

[0038] The following will be combined with the drawings in the embodiments of the present invention to clearly and completely describe the technical solutions in the embodiments of the present invention. Obviously, the described embodiments are only part of the embodiments of the present invention, not all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without creative work are within the scope of protection of the present invention.

[0039] In the description of the present invention, it should be noted that the terms "first", "second" and "third" are only used for descriptive purposes and cannot be understood as indicating or implying relative importance.

[0040] The present invention provides a method for automatically generating reports for a laboratory information management system, such as Figure 1 As shown, Figure 1 The flow chart of the method for automatically generating reports for a laboratory information management system includes steps S101 to S103, each of which is as follows:

[0041] S101, obtaining the original data of each host computer.

[0042] In this embodiment, a report automatic generation system is designed, and the system includes a data acquisition module, a big data storage platform (HDFS data warehouse) module, a report automatic generation module, a report automatic review module and a report signature and release module. First, the data in the host computer is captured through the data acquisition module. Specifically, the data acquisition module mainly collects data through database transfer tools, interface docking, database acquisition, raw data file capture, encryption and analysis, and direct equipment acquisition.

[0043] In one embodiment, the original data of each host computer is obtained by using a transfer tool to obtain the original data of each host computer, and the original data of each host computer is obtained by using the transfer tool, including:

[0044] Based on the collection requirements, configure the parameters of the transfer tool. After completing the parameter configuration, use the transfer tool to collect the original data in the host computer;

[0045] Alternatively, the original data of each host computer is obtained by using an interface in the host computer to obtain the original data of each host computer, and the interface includes a serial port interface or a gateway interface.

[0046] In this embodiment, the database transfer tool is a client, which is installed on each host computer. The corresponding parameters are configured through the interface, such as the acquisition time frequency, the acquisition data range, the database configuration, the data push settings, etc. After configuration, the original data can be automatically uploaded to the data warehouse at a fixed time. In order to collect the device channel status in real time, the device channel status interface address needs to be entered in the host computer software or the transfer tool, and the device channel status interface address needs to be transmitted to the LIMS system in real time through the interface docking, so as to achieve push in seconds. All channel status of a device is transmitted in the interface each time, and there will be records and warnings if the host computer fails to call.

[0047] For devices that can support direct acquisition, for data that does not require cleaning, such as voltage and internal resistance meters, the voltage and internal resistance data can be directly collected and uploaded to the LIMS system by connecting to the serial port. For data that requires filtering, such as temperature and humidity meters, ovens, etc., the serial port and gateway can be connected, and the temperature data can be directly collected and uploaded to the data warehouse, and then associated with the charge and discharge data after data cleaning.

[0048] As an example of this embodiment, multiple data sources obtain original test data, distinguishing between charge and discharge test cabinets and auxiliary equipment. The charge and discharge test data includes txt / csv / xlsx file classes and host computer database classes such as MySQL and SQLserver; the auxiliary equipment test data includes txt / csv / xlsx file classes and RS485 and RS232 serial communication protocol interface classes.

[0049] Through a variety of integration methods, including FTP file transfer, dataX file reading and processing, standard interface access and custom plug-in tools (such as Maxwell tools to read database binlog log files), data collection is performed and the first data packet is obtained after preprocessing and stored in the first data block, which is uploaded to the big data storage platform HDFS, i.e., the data warehouse, on a regular basis every day. For example: for the charging and discharging test cabinet, through the IP address and login account password of the host computer database, create a read-only script after the connection information, collect database data through the dataX tool, generate a csv file, and then use this tool and the development file processing plug-in to encapsulate the data and transfer it to the corresponding block node directory of the big data storage platform HDFS on a regular basis every day.

[0050] In one embodiment, when the original data of each host computer is obtained by using a transfer tool, the original data of each host computer is obtained by using the transfer tool, and further comprising:

[0051] If the account, password and structure design of the database of the host computer are obtained, the original data in the host computer is collected according to the extraction strategy configured by the structure design after connecting to the database of the host computer using the driver package according to the account and password of the database, so as to obtain the original data of each host computer;

[0052] If the account and password of the database of the host computer are not obtained, the original data in the host computer is saved in the local database, and the original data in the local database is obtained by using file sharing to obtain the original data of each host computer.

[0053] In this embodiment, for devices that have provided the host computer database account and password, and clearly understand the database table structure design and data acquisition logic, the driver package can be used to connect to the host computer's database, and then the original data in the host computer can be collected in real time according to the extraction strategy configured in the structural design.

[0054] For devices that do not provide a database account password but can obtain the original data files of the host computer, they can save the data to the local path of the host computer through the automatic data file backup function or manual export, and then grab it through the FTP shared disk and store it on the data acquisition server, and then upload it to the data warehouse via HTTP on a regular basis every day.

[0055] S102, performing data cleaning on the original data corresponding to each host computer to obtain the cleaned data corresponding to each host computer, sending each cleaned data to the first data block pool to obtain the first data source, and assigning a unique identifier to each data based on the basic information of each data in the first data source.

[0056] In this embodiment, data is collected and stored in the LIMS server and then cleaned. After the data is processed, the processed data will be stored separately in the data warehouse, and the data content and format of the original data will not be affected. In addition, since the original data source of some equipment cannot meet the requirements of unique identification and splitting, a data source unique identification scheme is formulated to associate the data in the first data block pool with a unique identification to facilitate the call of the data warehouse. For example, the following basic information will be added to the charge and discharge test process for different brands of equipment: timestamp, sample information, device channel identification, and associated unique primary key ID.

[0057] In addition, the linkage data warehouse module is obtained through self-developed programs to monitor and warn of data anomalies, so as to encourage laboratory testers to handle abnormal data in a timely manner and ensure test safety and data validity.

[0058] It should be noted that the unique identifier includes but is not limited to information such as the application number, sample barcode and test item code.

[0059] In one embodiment, data cleaning is performed on the original data corresponding to each host computer to obtain the cleaned data corresponding to each host computer, including:

[0060] Screen the original data corresponding to each host computer to obtain duplicate data, data that does not meet the preset conditions, and missing data;

[0061] Delete the duplicate data and the data that does not meet the preset conditions, supplement the missing data, and obtain the cleaned data corresponding to each host computer.

[0062] In this embodiment, since the data storage table structures of various devices are somewhat different and contain some useless data, such as duplicate data, missing data, and inconsistent data formats, data cleaning is required. For example, data consistency is checked, invalid values ​​and missing values ​​are processed, and specifically, the original data corresponding to each host computer is screened to obtain duplicate data, data that does not meet the preset conditions, and missing data; duplicate data and data that does not meet the preset conditions are deleted, and missing data is supplemented to obtain the cleaned data corresponding to each host computer.

[0063] S103. Summarize the data in the first data source to obtain summarized data, send the summarized data to the second data block pool to obtain the second data source, extract the data in the second data source based on preset extraction rules to obtain a data packet, send the data packet to the third data block pool, call the data packet in the third data block pool according to the call application information and the unique identifier corresponding to each data, and generate a corresponding report.

[0064] In this embodiment, the incremental data in the first data block is uniformly connected to the data warehouse, and then data access storage, analysis and cleaning are performed, and data anomalies are automatically judged to obtain the second data source and store it in the second data block pool, waiting for the call application of the LIMS system. Specifically, in order to improve data collection efficiency and reduce the impact on the performance of the host computer, a fixed script logic extraction is performed on the first data block pool to generate an accurate and effective second data source, which is then stored in the second data block pool. For example, the test data of the charging and discharging equipment is uniformly collected at the detail layer, and then the data warehouse automatically splits the step layer and cycle layer data through the script.

[0065] like Figure 2 As shown in the figure, the data warehouse adopts the standard data warehouse construction to store data in a hierarchical manner, including ODS layer, DWD layer, DWM layer and DWS layer. After the data enters the ODS layer for storage of the full amount of original data, it is stored in the DWD layer after data cleaning and standardized structuring. After a slight data aggregation operation, the intermediate result table data is generated and stored in the DWM layer. Finally, the basic data of the DWM layer is integrated and summarized and stored in the DWS layer to facilitate the subsequent query and call of the LIMS system.

[0066] It should be noted that the ODS (Operational Data Store) layer is the operational data storage layer, the DWD (Data Warehouse Detail) layer is the data warehouse detail layer, the DWM (Data Warehouse Middle) layer is the data warehouse middle layer, and the DWS (Data Warehouse Service) layer is the data warehouse service layer. LIMS system refers to the laboratory information management system.

[0067] Then, based on the data package, the data key is issued according to the user data permissions. When the user performs editing operations in the system interface, a call request is issued. If the key verification is passed, the data is issued and the corresponding report is generated after the logic is extracted through actual operations. After the report is approved, a report with an electronic signature and report anti-counterfeiting mark is automatically generated.

[0068] The specific functions of the automatic report generation module include: the LIMS system initiates a call request to the data warehouse according to actual needs, and performs preprocessing and calculation according to the preset operation logic to obtain the parameter value. For example, the capacity value of each cycle of the battery cell is set to the capacity retention rate of the first cycle as the initial value of 100%, and then the capacity retention rate of other cycles is calculated. According to the unique identifier of the data source, the data is stored in the corresponding module area of ​​the LIMS system to obtain a data package. At the same time, the initial version of the report is automatically generated according to the preset report template configuration, which can be viewed and edited by the tester. The main functions of this module include report template configuration, viewing and downloading raw data, automatic report update, automatic data extraction and calculation, and preview and download of reports.

[0069] The report template configuration functions include: support for templates in different formats, such as Excel, Word, and PDF, and support for switching between Chinese and English templates. When generating a template, you can select the corresponding template format, configure the report template sheet, and support customizing chart curve configuration based on existing fields.

[0070] The functions of viewing and downloading raw data include: after data collection and data warehouse processing, the LIMS system calls the data warehouse through the unique identifier of the test data and displays the corresponding data in the interface. It supports filtering by application number, test ID, sample barcode, and can view or download the raw data of the sample according to search conditions such as time and step number. It can also switch the data display mode and choose table or curve chart display according to personal preference.

[0071] The functions of automatic report update include: collecting data in real time to the database and the data processed by the data warehouse, automatically updating to the corresponding report template every day through scheduled task updates and unique matching of sample barcodes, and recording the operation records during the test process in the report, such as sample collection, loading and unloading, etc. At the same time, according to customer needs, the module can automatically calculate the parameter values ​​after the custom data extraction step to achieve semi-automatic report generation.

[0072] The functions of previewing and downloading reports include: for test items with generated reports, you can preview the reports online on the web page by calling the OfficeOnline extension program; downloading reports supports Chinese and English versions, Word, Excel, and PDF report formats.

[0073] In one embodiment, aggregating the data in the first data source to obtain aggregated data includes:

[0074] The data from different data sources in the first data source are aggregated and aggregating to obtain aggregated data.

[0075] In this embodiment, since the data in the first data source is data from different data sources, the data from different data sources are summarized and aggregated according to certain rules.

[0076] In one embodiment, when aggregating the data in the first data source, the method further includes:

[0077] Based on the set abnormal value judgment range, the data in the first data source is judged to be abnormal. If the data is not within the abnormal value judgment range, the data is determined to be an abnormal value and a reminder message is issued.

[0078] In this implementation, the main functions of the report automatic review module include abnormal judgment configuration, automatic judgment of data abnormalities, and a three-level review process. The abnormal ranges of jump points, diving, parallel samples, etc. in different test items such as capacity division, DCIR, circulation, storage, etc. support background custom configuration. Then, after obtaining the original data, according to the range of the abnormal judgment configuration, it is judged as abnormal if it exceeds the range. For example, for the way of entering or editing data in the LIMS system, abnormal data will be highlighted. When obtaining data packets from the database, the background will automatically judge according to the preset judgment rules before synchronizing to the LIMS system, and an abnormal record will be generated if the data is abnormal.

[0079] The electronic signature model can upload department seals and signature images of auditors. When the audit is completed, the report will be automatically signed with the corresponding auditor and seal, providing a certain degree of protection for report anti-counterfeiting inspection.

[0080] In one embodiment, when the data packets in the third data block pool are called according to the call application information and the unique identifier corresponding to each data, the method further includes:

[0081] If the called data packet exceeds the preset parameter range, the call is not allowed and a warning message is issued.

[0082] In this embodiment, in addition, the data in the second data block pool is restricted by a permitted parameter set to control the parameter value range uploaded to the third data block pool. Call requests that exceed the permitted range will issue an early warning and will not allow the LIMS system to call, thereby facilitating data management and control.

[0083] The main functions of the report automatic generation and review system of the laboratory information management system designed by the present invention include data collection, data warehouse, automatic report generation, automatic report review, and electronic signature. The traditional manual operations such as downloading data, making reports, and reviewing data are automatically completed through the system, and at the same time, it supports functions such as online report preview, real-time update of report data, and data anomaly judgment. The tester only needs to confirm and then publish the report to the R&D personnel for viewing or downloading. Report generation through the LIMS system can supervise and leave traces for the entire process, ensure the authenticity of the report data, avoid arbitrary tampering, and facilitate report review and anomaly tracking.

[0084] The report automatic generation device of the laboratory information management system provided by the embodiment of the present invention is as follows: Figure 3 As shown, Figure 3 Automatically generate device diagrams for LIMS reports, including:

[0085] The acquisition module is used to obtain the original data of each host computer;

[0086] A data cleaning module is used to clean the original data corresponding to each host computer to obtain the cleaned data corresponding to each host computer, send each cleaned data to the first data block pool to obtain the first data source, and assign a unique identifier to each data based on the basic information of each data in the first data source;

[0087] The report generation module is used to summarize the data in the first data source to obtain the summarized data, send the summarized data to the second data block pool to obtain the second data source, extract the data in the second data source based on the preset extraction rules to obtain the data packet, send the data packet to the third data block pool, call the data packet in the third data block pool according to the call application information and the unique identifier corresponding to each data, and generate a corresponding report.

[0088] The specific implementation of the automatic report generation device for a laboratory information management system is basically the same as the specific implementation of the automatic report generation method for the laboratory information management system described above, and will not be described in detail here.

[0089] In one embodiment of the present application, a computer device is provided, which includes a memory and a processor, wherein a computer program is stored in the memory, and the above steps are implemented when the processor executes the computer program; the computer device provided in this embodiment has an implementation principle and technical effects similar to those of the above method embodiments, and will not be repeated here.

[0090] In one embodiment of the present application, a computer-readable storage medium is provided, on which a computer program is stored, and the above steps are implemented when the computer program is executed by a processor; the computer-readable storage medium provided in this embodiment has an implementation principle and technical effects similar to those of the above method embodiment, and will not be repeated here.

[0091] Compared with the prior art, the present invention also has the following beneficial effects:

[0092] Compared with the prior art of manually downloading test data every week through host computer software, which is time-consuming and occupies computer resources and easily causes jamming, we now connect with equipment manufacturers to automatically obtain test data by reading the database at a fixed time every day, reducing manual operations, and improving the manual update of reports every week to automatic update of reports every day. We can also generate multiple versions of reports and add anti-counterfeiting number identification, realizing online preservation of data throughout the entire process.

[0093] Compared with the existing technology that manually samples and audits report data, which cannot be fully audited and cannot avoid abnormal reasons such as audit errors, the LIMS system now automatically determines data abnormalities and abnormal reasons based on the standard range by configuring audit judgment standards, thus achieving comprehensive audit. At the same time, electronic signatures and seals are also supported after the audit is passed, and signatures can be completed without printing.

[0094] Compared with the prior art of manually exporting test data files from the host computer software and extracting and editing them by themselves, which results in the inability to effectively guarantee data accuracy and authenticity and the easy loss of data file backups, the data is collected by docking equipment and uniformly archived and stored in a data warehouse, thereby realizing the data tamper-proof function, ensuring the authenticity and integrity of the test data while facilitating reverse tracing and locating abnormalities.

[0095] Compared with the existing technology that manually decrypts and extracts encrypted data files, resulting in untimely test data updates and difficulty for customers to access and download, LIMS data acquisition can directly parse encrypted data, and after processing by the data warehouse, the test data can be quickly accessed and downloaded directly on the system interface, which improves the timeliness of data updates while ensuring a certain user experience.

[0096] The technical features of the above embodiments may be combined arbitrarily. To make the description concise, not all possible combinations of the technical features in the above embodiments are described. However, as long as there is no contradiction in the combination of these technical features, they should be considered to be within the scope of this specification.

[0097] The specific embodiments described above further illustrate the purpose, technical solutions and beneficial effects of the present invention. It should be understood that the above description is only a specific embodiment of the present invention and is not intended to limit the scope of protection of the present invention. It is particularly pointed out that for those skilled in the art, any modification, equivalent replacement, improvement, etc. made within the spirit and principle of the present invention should be included in the scope of protection of the present invention.

Claims

1. A method for automatically generating reports for a laboratory information management system, characterized in that: include: Obtain the original data of each host computer; Performing data cleaning on the original data corresponding to each of the host computers to obtain cleaned data corresponding to each of the host computers, sending each of the cleaned data to a first data block pool to obtain a first data source, and assigning a unique identifier to each of the data based on basic information of each of the data in the first data source; Summarize the data in the first data source to obtain summarized data, send the summarized data to the second data block pool to obtain the second data source, extract the data in the second data source based on preset extraction rules to obtain a data packet, send the data packet to the third data block pool, call the data packet in the third data block pool according to the call application information and the unique identifier corresponding to each data, and generate a corresponding report.

2. The method for automatically generating reports for a laboratory information management system according to claim 1, characterized in that: The method of obtaining the original data of each host computer is to use a transfer tool to obtain the original data of each host computer, and the method of using the transfer tool to obtain the original data of each host computer includes: Based on the collection requirements, the transfer tool is configured with parameters, and after the parameter configuration is completed, the original data in the host computer is collected by using the transfer tool; Alternatively, the obtaining of the original data of each host computer is to obtain the original data of each host computer by using an interface in the host computer, and the interface includes a serial port interface or a gateway interface.

3. The method for automatically generating reports for a laboratory information management system according to claim 2, characterized in that: When the method of obtaining the original data of each host computer is to use a transfer tool to obtain the original data of each host computer, the method of obtaining the original data of each host computer by using the transfer tool further includes: If the account, password and structure design of the database of the host computer are obtained, then according to the account and password of the database, after connecting to the database of the host computer using the driver package, the original data in the host computer is collected according to the extraction strategy configured by the structure design to obtain the original data of each host computer; If the account and password of the database of the host computer are not obtained, the original data in the host computer is saved in the local database, and the original data in the local database is obtained by using file sharing to obtain the original data of each host computer.

4. The method for automatically generating reports for a laboratory information management system according to claim 1, characterized in that: The step of performing data cleaning on the original data corresponding to each of the host computers to obtain the cleaned data corresponding to each of the host computers includes: Screening the original data corresponding to each of the host computers to obtain duplicate data, data that does not meet preset conditions, and missing data; The duplicate data and the data that do not meet the preset conditions are deleted, and the missing data are supplemented to obtain the cleaned data corresponding to each of the host computers.

5. The method for automatically generating reports for a laboratory information management system according to claim 1, characterized in that: The aggregating the data in the first data source to obtain the aggregated data includes: Summarize and aggregate the data from different data sources in the first data source to obtain summarized data.

6. The method for automatically generating reports for a laboratory information management system according to claim 1, characterized in that: When aggregating the data in the first data source, the method further includes: Based on the set abnormal value judgment range, the data in the first data source is judged to be abnormal. If the data is not in the abnormal value judgment range, the data is determined to be an abnormal value and a reminder message is issued.

7. The method for automatically generating reports for a laboratory information management system according to claim 1, characterized in that: When the data packets in the third data block pool are called according to the call application information, it also includes: If the called data packet exceeds the preset parameter range, the call is not allowed and a warning message is issued.

8. A report automatic generation device for a laboratory information management system, characterized in that: include: The acquisition module is used to obtain the original data of each host computer; A data cleaning module, used for cleaning the original data corresponding to each of the host computers to obtain the cleaned data corresponding to each of the host computers, sending each of the cleaned data to the first data block pool to obtain the first data source, and assigning a unique identifier to each of the data based on the basic information of each data in the first data source; The report generation module is used to summarize the data in the first data source to obtain summarized data, send the summarized data to the second data block pool to obtain the second data source, extract the data in the second data source based on preset extraction rules to obtain a data packet, send the data packet to the third data block pool, call the data packet in the third data block pool according to the call application information and the unique identifier corresponding to each data, and generate a corresponding report.

9. A computer device, characterized in that: include: Memory for storing computer programs; A processor, configured to implement the method for automatically generating a report for a laboratory information management system according to any one of claims 1 to 7 when executing the computer program.

10. A storage medium, characterized in that: The storage medium stores a computer program, and when the computer program is executed by the processor, the steps of the method for automatically generating a report for a laboratory information management system according to any one of claims 1 to 7 are implemented.

Images