A laboratory information management platform based on saline-alkali soil ecological restoration database

Abstract

The application provides a laboratory informatization management platform based on a saline-alkali soil ecological restoration database, which comprises a saline-alkali soil ecological restoration database system, a database background system and a data visualization foreground system; the database background system is used for receiving research project work packages of a research center and sample submission work packages of external agencies, generating sample detection work packages based on the research project work packages and the sample submission work packages, and uploading the sample detection work packages to the saline-alkali soil ecological restoration database system; the data visualization foreground system is used for providing a laboratory user with an access interface of the saline-alkali soil ecological restoration database system and uploading corresponding detection result data packages to the saline-alkali soil ecological restoration database system; and the saline-alkali soil ecological restoration database system generates sample result data packages according to the sample detection work packages and the detection result data packages. The laboratory user can access and manage sample detection data conveniently, and the data management efficiency is improved.

Description

Technical Field

[0001] This application relates to the field of information management technology, and in particular to a laboratory information management platform based on a saline-alkali land ecological restoration database. Background Technology

[0002] The central laboratory for ecological restoration in saline-alkali areas primarily analyzes and tests various samples from different units and regions, including soil, water, desulfurization gypsum, biomass, and soil conditioners, receiving tens of thousands of samples annually. Each sample contains hundreds of data points, such as sampling information, process control information, and physicochemical index testing information, along with different file types like JPG, Word, Excel, and PDF. The total data volume is enormous and fragmented, making it inconvenient to manage and use.

[0003] However, the management and operation of the laboratory still follow the traditional model. The processes of submitting samples, receiving samples, analysis and testing, and data processing are mainly based on paper or document records, which cannot guarantee the efficiency of data management. Summary of the Invention

[0004] This application provides a laboratory information management platform based on a database of saline-alkali land ecological restoration to address the shortcomings of existing technologies, such as low data management efficiency.

[0005] This application provides a laboratory information management platform based on a saline-alkali land ecological restoration database, including: a saline-alkali land ecological restoration database system, a database backend system, and a data visualization frontend system;

[0006] The database backend system is used to receive research project work packages from the research center and sample submission work packages from external institutions, generate sample testing work packages based on the research project work packages and sample submission work packages, and upload the sample testing work packages to the saline-alkali land ecological restoration database system.

[0007] The data visualization front-end system is used to provide laboratory users with an access interface to the saline-alkali land ecological restoration database system, so that the laboratory users can view the sample testing work package and upload the test result data package corresponding to the sample testing work package to the saline-alkali land ecological restoration database system.

[0008] After receiving the detection result data packet, the saline-alkali land ecological restoration database system generates a sample result data packet based on the sample detection work packet and the detection result data packet.

[0009] Optionally, the saline-alkali land ecological restoration database system includes a database and a resource repository;

[0010] The database is used to store data from the research project work package and the sample submission work package;

[0011] The resource library is used to store non-data type files in the research project work package and sample submission work package.

[0012] Optionally, the database backend system includes: a sample entry system, a sample receiving system, and a sample testing system;

[0013] The sample entry system is used to receive research project work packages from the research center and sample submission work packages from external institutions, generate submission sample work packages based on the research project work packages and sample submission work packages, and send the submission sample work packages to the sample receiving system.

[0014] The sample receiving system is used to perform a preliminary inspection on the submitted sample work package. If the submitted sample work package passes the preliminary inspection, a sample testing work package corresponding to the submitted sample work package is generated and the sample testing work package is sent to the sample testing system.

[0015] The sample testing system is used to upload the sample testing work package to the saline-alkali land ecological restoration database system.

[0016] Optionally, the sample receiving system is also used for:

[0017] If the submitted sample work package fails the preliminary inspection, the submitted sample work package will be returned to the sample entry system.

[0018] Optionally, the saline-alkali land ecological restoration database system is also used for:

[0019] Based on the detection result data package, the sample detection work package is reviewed.

[0020] If the sample testing work package fails the data review, the sample testing work package will be returned to the sample testing system.

[0021] Optionally, the database backend system may further include: a work log system;

[0022] The log system is used to automatically record process information at each time point during the operation of the database backend system, based on the operations of different user roles, and generate a work log data package.

[0023] Optionally, the database backend system may further include: a file management system;

[0024] The file management system is used to receive sample testing-related files uploaded by users, generate corresponding supporting file data packages, and upload the supporting file data packages to the saline-alkali land ecological restoration database system.

[0025] Optionally, the sample result data package includes: a sample submission work package, a sample testing work package, a test result data package, a supporting document data package, and a work log data package.

[0026] Optionally, the saline-alkali land ecological restoration database system is also used for:

[0027] The sample result data packets are cleaned to obtain all sample data packets; wherein, all sample data packets contain database data in a format that conforms to a preset specification.

[0028] Optional features also include: a platform management system;

[0029] The platform management system is used to provide a platform management interface for platform administrators, enabling them to manage the platform based on the platform management system.

[0030] The technical solution of this application has the following advantages:

[0031] This application provides a laboratory information management platform based on a saline-alkali land ecological restoration database. The platform includes: a saline-alkali land ecological restoration database system, a database backend system, and a data visualization frontend system. The database backend system receives research project work packages from the research center and sample submission work packages from external institutions, generates sample testing work packages based on these work packages, and uploads these work packages to the saline-alkali land ecological restoration database system. The data visualization frontend system provides laboratory users with an access interface to the saline-alkali land ecological restoration database system, enabling them to view sample testing work packages and upload corresponding test result data packages to the database system. Upon receiving the test result data packages, the saline-alkali land ecological restoration database system generates sample result data packages based on the sample testing work packages and the test result data packages. The platform provided by this solution automates the management of sample testing data, facilitates access and management of sample testing data by laboratory users, and improves data management efficiency. Attached Figure Description

[0032] To more clearly illustrate the technical solutions in the embodiments of this application or the prior art, the drawings used in the description of the embodiments or the prior art will be briefly introduced below. Obviously, the drawings described below are some embodiments of this application. For those skilled in the art, other drawings can be obtained based on these drawings.

[0033] Figure 1 A schematic diagram of the data interaction process of the laboratory information management platform based on the saline-alkali land ecological restoration database provided in this application embodiment;

[0034] Figure 2 This is a schematic diagram of the data interaction process of the database backend system provided in an embodiment of this application.

[0035] The accompanying drawings have illustrated specific embodiments of this application, which will be described in more detail below. These drawings and descriptions are not intended to limit the scope of the present disclosure in any way, but rather to illustrate the concepts of this application to those skilled in the art through reference to particular embodiments. Detailed Implementation

[0036] To make the objectives, technical solutions, and advantages of the embodiments of this application clearer, the technical solutions of the embodiments of this application will be clearly and completely described below with reference to the accompanying drawings. Obviously, the described embodiments are only some embodiments of this application, not all embodiments. Based on the embodiments of this application, all other embodiments obtained by those skilled in the art without creative effort are within the scope of protection of this application.

[0037] Furthermore, the terms "first," "second," etc., are used for descriptive purposes only and should not be construed as indicating or implying relative importance or implicitly specifying the number of technical features indicated. In the following descriptions of embodiments, "a plurality of" means two or more, unless otherwise explicitly defined.

[0038] Currently, the management and operation of the laboratory still follow the traditional model. The processes of submitting samples, receiving samples, analysis and testing, and data processing are mainly based on paper or document records, which cannot guarantee the efficiency of data management.

[0039] To address the aforementioned issues, this application provides a laboratory information management platform based on a saline-alkali land ecological restoration database, comprising: a saline-alkali land ecological restoration database system, a database backend system, and a data visualization frontend system. The database backend system receives research project work packages from the research center and sample submission work packages from external institutions, generates sample testing work packages based on these work packages, and uploads these work packages to the saline-alkali land ecological restoration database system. The data visualization frontend system provides laboratory users with an access interface to the saline-alkali land ecological restoration database system, enabling them to view sample testing work packages and upload corresponding test result data packages to the database system. Upon receiving the test result data packages, the saline-alkali land ecological restoration database system generates sample result data packages based on the sample testing work packages and the test result data packages. The platform provided by this solution automates the management of sample testing data, facilitates access and management of sample testing data by laboratory users, and improves data management efficiency.

[0040] The following specific embodiments can be combined with each other, and the same or similar concepts or processes may not be described again in some embodiments. The embodiments of the present invention will now be described with reference to the accompanying drawings.

[0041] This application provides a laboratory information management platform based on a saline-alkali land ecological restoration database, which provides rich user interfaces and application scenarios for saline-alkali land ecological restoration centers and external institutions, and facilitates communication, learning, data storage, and data sharing among researchers in the industry.

[0042] The laboratory information management platform based on the saline-alkali land ecological restoration database provided in this application embodiment allows all platform operations to be performed by registered users and can be accessed, viewed, and updated in real time on PCs and mobile devices, without time or space limitations. Platform architecture design constraints: B / S structure (browser / server structure), enabling interaction between the browser and the server. Standard architecture constraints: J2EE architecture (Java 2 Platform Enterprise Edition), with Java as the system architecture language.

[0043] like Figure 1 The diagram shown is a schematic of the data interaction process of a laboratory information management platform based on a saline-alkali land ecological restoration database provided in this application embodiment. The platform includes: a saline-alkali land ecological restoration database system, a database backend system, and a data visualization frontend system.

[0044] The database backend system receives research project work packages from the research center and sample submission work packages from external institutions. Based on these work packages, it generates sample testing work packages and uploads them to the saline-alkali land ecological restoration database system. The data visualization frontend system provides laboratory users with an access interface to the saline-alkali land ecological restoration database system, enabling them to view sample testing work packages and upload corresponding test result data packages to the system. Upon receiving the test result data packages, the saline-alkali land ecological restoration database system generates sample result data packages based on the sample testing work packages and the test result data packages.

[0045] It should be noted that the saline-alkali land ecological restoration database system, database backend system, and data visualization frontend system are online, while the research center and external institutions are offline. Users of the research center and external institutions can log in to the saline-alkali land ecological restoration database system or database backend system through the data visualization frontend system.

[0046] The research center's users are categorized into roles such as platform administrators, staff, teachers, and students. Platform administrators have management interfaces, while staff, teachers, and students have access interfaces. The research center also has physical laboratories and research projects. Research projects include research requirements and project information. Based on these requirements, physical samples are obtained, and sample and testing information is derived through requirements analysis. These samples, sample information, testing information, and project information form a research project work package. External institution users are categorized into roles such as researchers and sample submitters, and these roles have access interfaces. External institutions also include research projects and institution information. Research projects include testing requirements and project information. Based on these requirements, physical samples are obtained, and sample and testing information is derived through requirements analysis. These samples, sample information, testing information, project information, and institution information form a sample submission work package.

[0047] Specifically, after receiving the research project work package and the corresponding sample submission work package from the research center, the database backend system generates a sample testing work package based on these materials and uploads it to the saline-alkali land ecological restoration database system. Laboratory users access the saline-alkali land ecological restoration database system through the data visualization frontend system's interface, view the sample testing work package, and arrange experiments according to the information recorded in the work package (such as sample testing requirements). For example, they can arrange experiments to test for soil exchangeable cations and water-soluble anions. After completing the experiments, they obtain the relevant experimental results and construct the corresponding test result data package. Upon receiving this test result data package, the saline-alkali land ecological restoration database system generates a sample result data package based on the sample testing work package and the test result data package.

[0048] The sample results database package may include a sample submission work package, a sample testing work package, a test result data package, a supporting file data package, and a work log data package.

[0049] Specifically, in one embodiment, the saline-alkali land ecological restoration database system includes a database and a resource repository; the database is used to store data in research project work packages and sample submission work packages; the resource repository is used to store non-data type files in research project work packages and sample submission work packages.

[0050] The database stores mostly numeric data, while the resource library stores non-data type files, including photos, Word documents, and PDFs.

[0051] Based on the above embodiments, in order to further improve data management efficiency, Figure 2The diagram illustrates the data interaction process of the database backend system provided in this application embodiment. As an implementable approach, in one embodiment, the database backend system includes: a sample entry system, a sample receiving system, and a sample testing system.

[0052] The sample entry system receives research project work packages from the research center and sample submission work packages from external institutions. Based on the research project work packages and sample submission work packages, it generates a sample submission work package and sends it to the sample receiving system. The sample receiving system performs a preliminary check on the submitted sample work packages. If the submitted sample work package passes the preliminary check, it generates a corresponding sample testing work package and sends it to the sample testing system. The sample testing system uploads the sample testing work packages to the saline-alkali land ecological restoration database system.

[0053] Specifically, users of the research center and external institutions can import research project work packages and sample submission work packages into the database backend system via the sample entry system interface. Further, the sample receiving system performs preliminary checks on the submitted sample work packages, such as data integrity checks. If the submitted sample work package passes the preliminary check, it is sent to the sample testing system, which then uploads the sample testing work package to the saline-alkali land ecological restoration database system.

[0054] Conversely, in one embodiment, the sample receiving system returns the submitted sample work package to the sample entry system if the submitted sample work package fails the preliminary inspection.

[0055] Specifically, by returning sample work packages that fail the initial inspection to the sample entry system, users at the research center and external institutions can make adaptive modifications to the research project work packages and sample submission work packages to generate new sample work packages.

[0056] Specifically, in one embodiment, the saline-alkali land ecological restoration database system can also review the sample testing work package based on the test result data package; when the sample testing work package fails the data review, the sample testing work package is returned to the sample testing system.

[0057] Specifically, the sample testing work package can be reviewed by comparing the data (test result data package) included in the experimental results of the testing experiments conducted according to the sample testing requirements corresponding to the sample testing work package with the relevant data recorded in the sample testing work package. This review aims to determine whether the data in the sample testing work package is accurate and reliable. If there is a data conflict between the sample testing work package and the test result data package, the sample testing work package is determined to have failed the data review and is then returned to the sample testing system.

[0058] Specifically, in one embodiment, the database backend system further includes a work log system; the log system is used to automatically record process information at each time point according to the operations of different user roles during the operation of the database backend system, and generate work log data packets.

[0059] This work log data package includes system operation records for all users. Experiment logs manually recorded by different roles during the experiment can also be aggregated into the work log data package.

[0060] Specifically, in one embodiment, the database backend system further includes: a file management system; the file management system is used to receive sample testing-related files uploaded by users, generate corresponding supporting file data packages, and upload the supporting file data packages to the saline-alkali land ecological restoration database system.

[0061] The sample testing-related documents may include learning materials and operation manuals related to the current sample testing, and can be expanded according to actual needs. This application does not limit the scope of the embodiments.

[0062] Specifically, in one embodiment, the saline-alkali land ecological restoration database system can also perform data cleaning on the sample result data packets to obtain all sample data packets.

[0063] All data packets in the sample contain database data in a format that conforms to preset specifications.

[0064] Specifically, data cleaning can be performed on the sample result data packet to correct the format of the data in the sample result data packet, so as to obtain all sample data packets.

[0065] Specifically, in one embodiment, the platform further includes a platform management system; the platform management system is used to provide a platform management interface for platform administrators, so that platform administrators can perform platform management based on the platform management system.

[0066] Specifically, platform administrators can manage the database backend system through the platform management system. They can also perform system maintenance on the database backend system through the backend maintenance system. Other personnel within the research center can review the data in the database backend system. Similarly, platform administrators can manage the data visualization frontend system through the platform management system. They can also perform system maintenance on the data visualization frontend system through the backend maintenance system, and other personnel within the research center can inspect the data in the data visualization frontend system.

[0067] Furthermore, in one embodiment, the data visualization front-end system includes a front-end maintenance system with a front-end maintenance interface, a user login system with a user login interface, a data retrieval system with a data monitoring interface, a data visualization system with a data visualization interface, and a map search system with a map search interface.

[0068] Specifically, different retrieval requests can be made to the database through a data retrieval system, different data capture requests can be made to the database through a data visualization system, and requests such as reading geographic information and location can be made to the database through a map search system.

[0069] Regarding platform security requirements, unauthorized users are prohibited from accessing the system. Unauthorized users refer to those who have not passed authentication and lack valid user IDs and passwords; access to the system requires illegitimate means. The system's security design prioritizes preventing intrusions by these unauthorized users. The platform is deployed on a secure network and is managed and scheduled by an administrator. Each role operates under certain constraints to prevent improper manipulation of the platform, system, and data. The platform has strict backup and fault recovery mechanisms for data and information, with regular backups. In the event of a system crash or service disruption due to natural or human factors, the system can promptly activate fault recovery mechanisms and emergency plans. The platform guarantees uninterrupted 24 / 7 operation, with all services remaining available. Except in cases of disaster, the platform ensures that all system services remain operational and that service quality does not degrade. In the event of a disaster, the system possesses appropriate disaster recovery capabilities in accordance with relevant regulations.

[0070] In terms of platform performance, the platform possesses the following characteristics: universality, ease of use, responsiveness, scalability, reliability, availability, accuracy, real-time performance, openness, sharing, and portability. Universality: Adaptable to diverse needs in relevant industries and laboratories. Ease of use: All business function interfaces and operation processes are consistent, featuring a user-friendly Chinese interface, detailed help information, and platform parameter maintenance and management completed through the interface; business forms are WYSIWYG. Responsiveness: Possesses rapid system response capabilities, ensuring that response speed does not impact business operations or cause inefficiency. Scalability: Adaptable to new functionalities without altering the existing architecture. Reliability: Guarantees the correctness of business logic under both normal and extreme conditions, ensuring reliable, continuous, and fault-free platform operation. Availability: Prevents single-point failures or system upgrades from affecting the normal operation of the entire platform. Accuracy: Ensures the accuracy of system data processing, providing verification and auditing methods. Real-time performance: Completes large-volume data processing in real time, providing support for concurrent processing. Openness: The platform adopts mainstream and open technologies, ensuring services for various data businesses and interconnectivity with related systems. Shareability: Data can be shared with authorized and required roles. Portability: The platform can be ported across platforms during future system updates and iterations.

[0071] This application provides a laboratory information management platform based on a saline-alkali land ecological restoration database. The platform includes a saline-alkali land ecological restoration database system, a database backend system, and a data visualization frontend system. The database backend system receives research project work packages from the research center and sample submission work packages from external institutions. Based on these work packages, it generates sample testing work packages and uploads them to the saline-alkali land ecological restoration database system. The data visualization frontend system provides laboratory users with an access interface to the saline-alkali land ecological restoration database system, enabling them to view sample testing work packages and upload corresponding test result data packages to the database system. Upon receiving the test result data packages, the saline-alkali land ecological restoration database system generates sample result data packages based on the sample testing work packages and the test result data packages. The platform provided by this solution automates the management of sample testing data, facilitates access and management of sample testing data by laboratory users, and improves data management efficiency. Furthermore, the systems are coupled through control logic and transmission interfaces, enabling laboratory information management and the input, transmission, analysis, cleaning, and archiving of large amounts of research data, providing strong support for the informatization development, scientific research, and technical services in this field. Furthermore, through a series of standardized processes including "sample entry - sample review - sample form receipt - sample form review - test data import - test result analysis - publication," the platform avoids the uncertainties caused by traditional manual operations, effectively improving laboratory work efficiency. Moreover, the platform can be logged into and operated on any device with a browser, and provides interfaces for different teams to store and share data within the industry.

[0072] Finally, it should be noted that the above embodiments are only used to illustrate the technical solutions of this application, and are not intended to limit them. Although this application has been described in detail with reference to the foregoing embodiments, those skilled in the art should understand that modifications can still be made to the technical solutions described in the foregoing embodiments, or equivalent substitutions can be made to some or all of the technical features therein. Such modifications or substitutions do not cause the essence of the corresponding technical solutions to deviate from the scope of the technical solutions of the embodiments of this application.

Claims

1. A laboratory information management platform based on a database for saline-alkali land ecological restoration, characterized in that, include: A database system for ecological restoration of saline-alkali land, a database backend system, and a data visualization frontend system; The database backend system is used to receive research project work packages from the research center and sample submission work packages from external institutions, generate sample testing work packages based on the research project work packages and sample submission work packages, and upload the sample testing work packages to the saline-alkali land ecological restoration database system. The data visualization front-end system is used to provide laboratory users with an access interface to the saline-alkali land ecological restoration database system, so that the laboratory users can view the sample testing work package and upload the test result data package corresponding to the sample testing work package to the saline-alkali land ecological restoration database system. After receiving the detection result data packet, the saline-alkali land ecological restoration database system generates a sample result data packet based on the sample detection work packet and the detection result data packet. The database backend system includes: a sample entry system, a sample receiving system, and a sample testing system; The sample entry system is used to receive research project work packages from the research center and sample submission work packages from external institutions, generate submission sample work packages based on the research project work packages and sample submission work packages, and send the submission sample work packages to the sample receiving system. The sample receiving system is used to perform a preliminary inspection on the submitted sample work package. If the submitted sample work package passes the preliminary inspection, a sample testing work package corresponding to the submitted sample work package is generated and the sample testing work package is sent to the sample testing system. The sample testing system is used to upload the sample testing work package to the saline-alkali land ecological restoration database system.

2. The platform according to claim 1, characterized in that, The saline-alkali land ecological restoration database system includes a database and a resource repository; The database is used to store data from the research project work package and the sample submission work package; The resource library is used to store non-data type files in the research project work package and sample submission work package.

3. The platform according to claim 1, characterized in that, The sample receiving system is also used for: If the submitted sample work package fails the preliminary inspection, the submitted sample work package will be returned to the sample entry system.

4. The platform according to claim 1, characterized in that, The saline-alkali land ecological restoration database system is also used for: Based on the detection result data package, the sample detection work package is reviewed. If the sample testing work package fails the data review, the sample testing work package will be returned to the sample testing system.

5. The platform according to claim 1, characterized in that, The database backend system also includes: a work log system; The log system is used to automatically record process information at each time point during the operation of the database backend system, based on the operations of different user roles, and generate a work log data package.

6. The platform according to claim 1, characterized in that, The database backend system also includes: a file management system; The file management system is used to receive sample testing-related files uploaded by users, generate corresponding supporting file data packages, and upload the supporting file data packages to the saline-alkali land ecological restoration database system.

7. The platform according to claim 1, characterized in that, The sample result data package includes: the submitted sample work package, the sample testing work package, the test result data package, the supporting document data package, and the work log data package.

8. The platform according to claim 1, characterized in that, The saline-alkali land ecological restoration database system is also used for: The sample result data packets are cleaned to obtain all sample data packets; wherein, all sample data packets contain database data in a format that conforms to a preset specification.

9. The platform according to claim 1, characterized in that, Also includes: Platform management system; The platform management system is used to provide a platform management interface for platform administrators, enabling them to manage the platform based on the platform management system.

Images