Intelligent database system and method for material and test data management

Abstract

The invention discloses an intelligent database system and method for material and test data management, and belongs to the technical field of computer software. The system comprises a material management module which supports management and intelligent verification of material information with labels; the parameter management module supports dynamic creation of parameter types and parameters and configures labeling classification of'basic attributes', 'variable attributes' and'other attributes' for the parameters, and the'variable attributes' support association of a plurality of conditions; the experiment management module is used for inputting experiment data based on a parameter system and supporting template import; the data analysis module is used for comparing and displaying various attribute data of the selected experiment by adopting partition layout, and providing a chart drawing function for variable attributes; and the data query module supports advanced screening based on range combination of a plurality of basic attributes and visualizes a comparison result by using a histogram. According to the method, the problems that existing material management software is rigid in parameter, weak in data relevance and insufficient in analysis capability are solved.

Description

Technical Field

[0001] This invention relates to the field of computer software technology, and more specifically to an intelligent database system and method for managing material and experimental data. Background Technology

[0002] In chemical research, efficient and accurate management of a wide variety of chemicals and their related parameters and experimental data is crucial. Traditional materials management often relies on paper records or simple spreadsheets (such as Excel), which have the following significant drawbacks:

[0003] Poor data correlation: Material information, parameter definitions, and test data are stored in a scattered manner, making it difficult to effectively correlate them, resulting in low efficiency in traceability and analysis.

[0004] Rigid parameter management: Parameter definitions are fixed, making it difficult to adapt to the need to add or modify parameter types during the R&D process, resulting in poor scalability.

[0005] Weak analytical capabilities: It lacks intelligent data comparison, filtering, and visualization tools, requiring manual extraction and organization of information from massive amounts of data, which is tedious and prone to errors.

[0006] Low system integration: Each functional module is independent, data flow is not smooth, and it is impossible to form an integrated workflow from data entry to intelligent analysis.

[0007] Therefore, there is an urgent need for a dedicated database system that can uniformly manage materials and test data, support flexible parameter definition, and provide powerful internal analysis and query tools. Summary of the Invention

[0008] The technical problem to be solved by the present invention is to provide an intelligent material database system and method with a clear architecture, high configurability, strong data correlation, powerful analysis and visualization capabilities, and excellent user experience.

[0009] To achieve the above objectives, the present invention adopts the following technical solution:

[0010] Firstly, this invention provides an intelligent material database system for chemical management. The system adopts a standard three-tier architecture based on C# Winform, ensuring good maintainability and scalability. The core innovation of this invention lies in the collaborative design and unique functionalities of its five major functional modules:

[0011] 1. Materials Management Module: Responsible for managing chemical entities. It introduces a labeling system, allowing materials to be categorized by affixing user-defined labels. This module features intelligent validation logic: prohibiting the addition of blank materials (name and label are required), prohibiting the creation of duplicate labels, and preventing the deletion of labels currently in use by materials, thereby ensuring data consistency and integrity.

[0012] 2. Parameter Management Module: This is the system's "metadata" management center. It allows users to dynamically create parameter types (such as "physical parameters") and specific parameters (such as "density"). Its core innovation lies in the parameter tagging and classification mechanism, which forces each parameter to be categorized as a "basic attribute," "variable attribute," or "other attribute." In particular, for "variable attributes," the system supports associating them with multiple conditional parameters (such as "temperature"), thereby accurately describing those physical properties that change with conditions, laying the foundation for the structured storage of complex experimental data.

[0013] 3. Experiment Management Module: As the data entry point, it closely integrates with the previous two modules. Its most distinctive feature is its intelligent data import function: the system can export an Excel template that is completely synchronized with the current parameter definitions. During import, the system automatically identifies the parameter types in the data and executes rules: if the data consists entirely of "basic attributes," it can be imported in batches; if it contains "variable attributes," it imports only one record at a time, ensuring the accuracy of data with complex conditions and dimensions.

[0014] 4. Data Analysis Module: This module provides powerful data comparison and insight capabilities. Its interface employs an innovative partitioned display layout, clearly dividing the data from selected experiments into multiple blocks for side-by-side comparison, such as "Basic Information and Basic Attributes," "Variable Attributes and Conditional Parameters," and "Other Attributes." For "Variable Attributes," a customizable plotting tool is provided. Users can freely choose which variable attribute to use as the X-axis and select one or two corresponding conditional parameters as the Y-axis to generate precise XY or XYY curves. The "Plot" button explicitly triggers the plot, resolving the issue of unclear correspondence between charts and data.

[0015] 5. Data Query Module: Provides advanced filtering capabilities beyond keyword search. Users can freely select multiple "basic attributes" from all available options and set their respective value ranges (e.g., molecular weight between 50-100 and density greater than 1.0) for combined queries. Query results are presented intuitively in a multi-dimensional bar chart, with the horizontal axis containing experimental and material information and the vertical axis representing attribute values. The chart is automatically sorted, facilitating quick location and comparison of materials and experiments that meet specific physical property requirements.

[0016] Secondly, the present invention provides a chemical material management method based on the above system, covering the entire process from parameter definition, material entry, experimental data management to data analysis and query.

[0017] In a second aspect, the present invention provides an electronic device, including a memory, a processor, and a computer program stored in the memory and executable on the processor. When the processor executes the program, it implements the steps of the above-described management method.

[0018] The beneficial effects of this invention are as follows:

[0019] Highly flexible and adaptive: The dynamic parameter system and tag-based management enable the system to easily adapt to changes in the needs of different disciplines and project management.

[0020] Deep data association: It breaks down the barriers between materials, parameters, and experimental data, forming a traceable and mineable data network.

[0021] Powerful analytical decision support: Through multi-dimensional comparative analysis, advanced filtering, and rich visualization tools, raw data is transformed into intuitive insights to assist in scientific research decision-making and material selection. Attached Figure Description

[0022] Figure 1 A diagram illustrating the hierarchy and attribute tag configuration of the parameter management module.

[0023] Figure 2 A schematic diagram illustrating the various extensions of the parameter management module.

[0024] Figure 3 A diagram illustrating the multi-condition data display of variable attributes in the data analysis module.

[0025] Figure 4 A diagram illustrating the data display of basic attributes in the data analysis module.

[0026] Figure 5 A diagram illustrating the multi-condition configuration and result visualization of the data query module.

[0027] Figure 6 Flowchart of chemical material management methods. Detailed Implementation

[0028] The present invention will be further described below.

[0029] An intelligent material database system for chemical management. The system includes the following functional modules:

[0030] The materials management module is used to manage basic information and labels of chemical materials;

[0031] The parameter management module is used to dynamically configure parameter types and specific parameters, and to set attribute labels for parameters;

[0032] The experiment management module is used to input, manage, and query experimental data related to specific materials and parameters;

[0033] The data analysis module is used to perform multi-dimensional comparative analysis and visualization of selected experimental data;

[0034] The data query module is used to perform combination filtering and result visualization based on the numerical range of parameters.

[0035] Furthermore, the materials management module includes:

[0036] The material editing unit is used to add, delete, and modify material information. The material name is a required field, and at least one category label must be added to the material.

[0037] The label management unit is used to add and delete material labels and enforce the following validation rules: adding labels with duplicate names is prohibited, and deleting labels that have already been used by any material is prohibited.

[0038] Furthermore, the parameter management module includes:

[0039] The parameter type management unit is used to add, delete, and modify parameter types, and to configure unit information for parameter types;

[0040] The parameter information management unit is used to add, delete, and modify specific parameters under a specified parameter type, and to configure the unit, description, and condition information for the parameters;

[0041] Furthermore, the parameter labeling unit is used to assign a fixed attribute label to each specific parameter. The attribute labels include: basic attributes, variable attributes, and other attributes. For parameters with variable attribute labels, it is supported to associate one or more condition names.

[0042] Furthermore, the experiment management module includes:

[0043] The data import unit is used to import experimental data according to a predefined Excel template. The template is automatically associated with parameters defined in the parameter management module.

[0044] The data import unit is configured to support batch import of multiple data entries when the imported experimental data contains only parameters with labels as basic attributes; and to limit each import operation to a single data entry when the imported experimental data contains parameters with labels as "variable attributes".

[0045] Furthermore, the data analysis module includes:

[0046] The data selection unit allows users to select one or more experimental records from the experimental list to add to the analysis set.

[0047] The partitioned display unit is used to display the analytical data of the selected experiment in partitioned blocks on the interface, including at least:

[0048] The first display area is used to display the material's name, chemical formula, CAS number, and all the basic attribute parameters and their values ​​as labeled.

[0049] The second display area is used to display all parameters with variable attributes in tabular form, their associated condition names, and corresponding values.

[0050] The third display area is used to display all parameters labeled "Other Attributes" and their values;

[0051] The visualization plotting unit is used to generate a two-dimensional curve graph based on the data in the second display area, in response to user operations, by using one variable attribute selected by the user as the X-axis and one or two conditional attributes selected as the Y-axis.

[0052] Furthermore, the data query module includes:

[0053] The condition configuration unit provides a user interface that allows users to select one or more parameters from all parameters labeled as basic attributes via drop-down lists, and set a numerical range for each selected parameter to combine them into advanced query conditions.

[0054] The results visualization unit is used to display the queried experimental results data in the form of grouped bar charts. The horizontal axis includes the experiment number and material name, and the vertical axis is the value of the queried basic attribute. The data in the bar chart are arranged in ascending order of the attribute value.

[0055] like Figure 6 As shown, the chemical material management method of this system includes the following steps:

[0056] S1: Add chemical material information through the material management module and associate one or more category tags with the material;

[0057] S2: Dynamically create parameter types and specific parameters through the parameter management module, and configure attribute labels for the parameters;

[0058] S3: Through the experiment management module, select a specific material and enter or import experimental data according to the parameter system defined in step S2;

[0059] S4: Through the data analysis module, select multiple experimental data, perform partitioned comparison and display, and perform customized plotting on variable attribute data;

[0060] S5: Through the data query module, experimental data are filtered based on the numerical range of multiple basic attributes, and the filtering results are compared and displayed in the form of a bar chart.

[0061] Specifically, an electronic device is provided, including a memory, a processor, and a computer program stored in the memory and executable on the processor, characterized in that the processor executes the program to implement the steps of the above-described method.

[0062] Example 1: Specific Implementation of the Parameter Management Module

[0063] The core of the parameter management module is a tree-like, multi-level management structure. Users first create nodes, such as "Physical Parameters," using the "Add Parameter Type" function. Under the "Physical Parameters" node, users can add specific parameters, such as "density," and specify their units, such as "g / cm³." 3 When adding "Density," users must select an attribute label from the drop-down menu: "Basic Attribute," "Variable Attribute," or "Other Attributes." Selecting "Variable Attribute" activates the "Condition Parameters" area, allowing users to add multiple condition names, such as "Temperature" and "Pressure." See the illustration below. Figure 1 You can also add "parameter type" and "specific parameter", such as in... Figure 1 Add a parameter type "Chemical Parameter" to the existing structure, and under the "Chemical Parameter" node, add specific parameters, such as "Enthalpy of Formation," specifying its unit as "KJ / mol," and set it as a "Basic Property." See the attached diagram for a detailed illustration. Figure 2 .

[0064] Example 2: Interface and Functions of the Data Analysis Module

[0065] The data analysis module features a clear, partitioned layout. Users select experiments from the experiment management module on the left to add to the analysis. The interface is mainly divided into:

[0066] Search and Overview Area: A search box is provided at the top for searching by material name, and a list of selected experiment numbers is displayed below.

[0067] Section 1 (Basic Information and Basic Attributes): Displays the material name, chemical formula, etc. corresponding to the selected experiment in tabular form, and shows all parameters marked as "Basic Attributes" and their values ​​in parallel.

[0068] Section Two (Variable Attributes and Conditional Parameters): This is the core innovation area. Variable attributes are displayed in multi-column tables. For example, for the variable attribute "density," the table columns might include: "Density = 1.3 g / cm³". 3 Temperature = 25℃, Pressure = 1 atm, Density = 1.4 g / cm³ 3The display of data with multiple conditions, such as "temperature = 50℃, pressure = 1 atm", is presented in a flat, comparative manner. See the specific illustration below. Figure 3 (and Figure 1 (Corresponding). If you add "Chemical Parameters" and "Enthalpy of Formation", and set the basic property "Enthalpy of Formation" to "3.6 KJ / mol", the specific illustration is as follows. Figure 4 (and Figure 2 correspond).

[0069] Section 3 (Other Attributes): Displays parameters marked as "Other Attributes".

[0070] Example 3: Workflow of the Data Query Module

[0071] Users access the data query module. In the condition configuration area, users click the "+" sign and select "Molecular Weight" from the drop-down list (containing all "Basic Attribute" parameters, such as molecular weight and boiling point). In the input box that appears, they set the range, such as "50 to 100". They can click "+" again to add a second condition, such as "Boiling Point" greater than "80", as shown in the illustration. Figure 5 After clicking the "Search" button, the system performs combined filtering in the database. The results visualization area displays a grouped bar chart. Each group on the horizontal axis corresponds to a queried experiment, with labels including the experiment number and material name. The vertical axis represents the molecular weight value. Crucially, all experimental results in the chart are automatically sorted from low to high molecular weight, allowing users to clearly see the distribution at a glance.

[0072] The above description is merely a preferred embodiment of the present invention, but the scope of protection of the present invention is not limited thereto. Any equivalent substitutions or modifications made by those skilled in the art within the scope of the technology disclosed in the present invention, based on the technical solution and inventive concept of the present invention, should be covered within the scope of protection of the present invention.

Claims

1. An intelligent material database system for chemical management, characterized in that, The system includes the following functional modules: The materials management module is used to manage basic information and labels of chemical materials; The parameter management module is used to dynamically configure parameter types and specific parameters, and to set attribute labels for parameters; The experiment management module is used to input, manage, and query experimental data related to specific materials and parameters; The data analysis module is used to perform multi-dimensional comparative analysis and visualization of selected experimental data; The data query module is used to perform combination filtering and result visualization based on the numerical range of parameters.

2. The system according to claim 1, characterized in that, The material management module includes: The material editing unit is used to add, delete, and modify material information. The material name is a required field, and at least one category label must be added to the material. The label management unit is used to add and delete material labels and enforce the following validation rules: adding labels with duplicate names is prohibited, and deleting labels that have already been used by any material is prohibited.

3. The system according to claim 1, characterized in that, The parameter management module includes: The parameter type management unit is used to add, delete, and modify parameter types, and to configure unit information for parameter types; The parameter information management unit is used to add, delete, and modify specific parameters under a specified parameter type, and to configure the unit, description, and condition information for the parameters; The parameter tagging unit is used to assign a fixed attribute tag to each specific parameter. The attribute tags include: basic attributes, variable attributes, and other attributes. For parameters with variable attribute tags, it is supported to associate one or more condition names.

4. The system according to claim 1, characterized in that, The experiment management module includes: The data import unit is used to import experimental data according to a predefined Excel template, which is automatically associated with parameters defined in the parameter management module. The data import unit is configured to support batch import of multiple data entries when the imported experimental data contains only parameters labeled as basic attributes; and to limit each import operation to a single data entry when the imported experimental data contains parameters labeled as "variable attributes".

5. The system according to claim 1, characterized in that, The data analysis module includes: The data selection unit allows users to select one or more experimental records from the experimental list to add to the analysis set. The partitioned display unit is used to display the analytical data of the selected experiment in partitioned blocks on the interface, including at least: The first display area is used to display the material's name, chemical formula, CAS number, and all the basic attribute parameters and their values ​​as labeled. The second display area is used to display all parameters with variable attributes in tabular form, their associated condition names, and corresponding values. The third display area is used to display all parameters labeled "Other Attributes" and their values; The visualization plotting unit is used to generate a two-dimensional curve graph based on the data in the second display area, in response to user operations, by using a variable attribute selected by the user as the X-axis and one or two conditional attributes selected as the Y-axis.

6. The system according to claim 1, characterized in that, The data query module includes: The condition configuration unit provides a user interface that allows users to select one or more parameters from all parameters labeled as basic attributes via drop-down lists, and set a numerical range for each selected parameter to combine them into advanced query conditions. The results visualization unit is used to display the queried experimental results data in the form of grouped bar charts. The horizontal axis includes the experiment number and material name, and the vertical axis is the value of the queried basic attribute. The data in the bar chart are arranged in ascending order of the attribute value.

7. A chemical material management method based on the system according to any one of claims 1-6, characterized in that, Includes the following steps: S1: Add chemical material information through the material management module and associate one or more category tags with the material; S2: Dynamically create parameter types and specific parameters through the parameter management module, and configure attribute labels for the parameters; S3: Through the experiment management module, select a specific material and enter or import experimental data according to the parameter system defined in step S2; S4: Through the data analysis module, select multiple experimental data, perform partitioned comparison and display, and perform customized plotting on variable attribute data; S5: Through the data query module, experimental data are filtered based on the numerical range of multiple basic attributes, and the filtering results are compared and displayed in the form of a bar chart.

8. An electronic device comprising a memory, a processor, and a computer program stored in the memory and executable on the processor, characterized in that, When the processor executes the program, it implements the steps of the method as described in claim 7.

Images