Database management system supporting intelligent machining of electro-hydraulic control actuator parts

Abstract

The invention belongs to the technical field of databases, and discloses a database management system supporting intelligent machining of electro-hydraulic control actuator parts, the system comprises a data entry and verification module and a data storage and management module; the data input and verification module is used for inputting a process instance data table and calling a pre-compiled verification mechanism to verify the process instance data table; the data storage and management module is used for storing the plurality of verified data tables by adopting a relational database, establishing a relation among the plurality of data tables on the basis of primary keys and foreign keys of the plurality of verified data tables, and taking the data table corresponding to the primary key as a primary data table and the data table corresponding to the foreign key as a sub-data table; and the data storage and management module is also used for querying in the main data table and the sub-data table in the relational database when receiving the data query request to obtain a data query result. The data query result is more accurate, and the data query efficiency and the data management efficiency are improved.

Description

Technical Field

[0001] The present invention belongs to the technical field of databases, and particularly relates to a database management system for supporting intelligent processing of electro-hydraulic control actuator parts. Background Art

[0002] In the design and manufacturing process of electro-hydraulic control actuators, accurate management and efficient query of part data are crucial. Traditional database systems are difficult to meet the management requirements of complex part data, resulting in problems such as data redundancy and low query efficiency.

[0003] Specifically, traditional data entry is mainly completed by manual input. This method is not only inefficient but also prone to human errors, such as data format errors, parameter omissions, data duplication, etc., resulting in low accuracy and reliability of the stored data, which in turn affects subsequent production and manufacturing. For example, when manufacturing a certain part, incorrect part data queried will lead to problems with the generated part. Summary of the Invention

[0004] The database management system for supporting intelligent processing of electro-hydraulic control actuator parts of the present invention includes a data entry and verification module, and a data storage and management module, which makes the data query results more accurate, improves the data query efficiency and data management efficiency, and the accurate data query results contribute to the intelligent processing of electro-hydraulic control actuator parts, which is beneficial to subsequent part design, manufacturing and maintenance work.

[0005] An embodiment of the present invention provides a database management system for supporting intelligent processing of electro-hydraulic control actuator parts, and the database management system includes a data entry and verification module, and a data storage and management module;

[0006] The data entry and verification module is used to enter a process instance data table, and call a pre-compiled verification mechanism to verify the process instance data table to obtain multiple verified data tables;

[0007] The data storage and management module is used to obtain the multiple verified data tables, store the multiple verified data tables using a relational database, establish a connection between the multiple data tables based on the primary keys and foreign keys of the multiple verified data tables, and use the data table corresponding to the primary key as the main data table among the multiple data tables with established connections, and the data table corresponding to the foreign key as the sub-data table of the main data table; wherein, the relational database supports multi-dimensional indexing, and the index type is a B-tree index;

[0008] The data storage and management module is further configured to, when receiving a data query request, respond to the data query request and query in the main data table and the sub - data table in the relational database to obtain a data query result.

[0009] Optionally, the data entry and verification module enters the process instance data table, specifically including:

[0010] The data entry and verification module receives the process instance data table input by the user in a preset visual operation interface, where the input operations include at least one of the following operations: adding, deleting, editing, and saving;

[0011] and / or,

[0012] The data entry and verification module receives the process instance data table batch - imported by the target data management tool through attribute mapping. During the batch import process, each process instance data table sets the part ID as the primary key.

[0013] Optionally, the data entry and verification module calls a verification mechanism to verify the process instance data table, and obtains multiple verified data tables, including:

[0014] The data entry and verification module performs format verification on the process instance data table. If the format of the process instance data table does not conform to the predetermined format, it adjusts the format of the process instance data table to the predetermined format;

[0015] The data entry and verification module performs integrity verification on the process instance data table. If there are missing required fields in the process instance data table or errors in the associated data, it supplements the missing required fields or modifies the associated data with errors;

[0016] The data entry and verification module performs historical data verification on the process instance data table. If the process instance data table is exactly the same as the existing historical data table in the database, it deletes the newly entered process instance data table.

[0017] Optionally, the process instance data table includes a part information data table, a tool material data table, and a processing technology data table:

[0018] The part information data table is used to store the component attribute information of hydraulic components, and the component attribute information includes number, name, description, and type;

[0019] The tool material data table is used to store the key information of tool materials, and the key information includes geometric parameters and models;

[0020] The processing technology data table is used to store the process steps of hydraulic components and the detailed parameters corresponding to each process step. The detailed parameters include a process table, a working step table, and a process parameter table.

[0021] Optionally, the pre-compiled verification mechanism is a group of pre-compiled SQL statements stored in a relational database. After detecting the input process instance data table, it automatically verifies the input process instance data table and returns a verification result.

[0022] Optionally, the database management system further includes a user permission and security management module;

[0023] The user permission and security management module is used to set user login permissions and user access permissions;

[0024] The user permission and security management module is further used to determine the target user login permission and target user access permission corresponding to the target user after receiving a login request from the target user;

[0025] The user permission and security management module is further used to determine the target data that the target user can access stored in the data storage and management module based on the target user login permission and the target user access permission;

[0026] The user permission and security management module is further used to record the operation log of the target user during the process of the target user accessing the target data.

[0027] Optionally, the user access permission includes data access permission, operation permission control user, and system permission;

[0028] The data access permission is used to determine the data range that a user can access. The accessible data range includes at least one of the following: table, view, and data storage procedure;

[0029] The operation permission control user is used to determine the operations that a user can execute. The executable operations include at least one of the following: query, insert, update, and delete;

[0030] The system permission is used to determine the system functions that a user can access. The accessible system functions include at least one of the following: user management, configuration management, query and record operation log.

[0031] In a second aspect, an embodiment of the present invention provides a database management method for supporting intelligent processing of electro-hydraulic control actuator parts, which is applied to a database management system for supporting intelligent processing of electro-hydraulic control actuator parts. The database management system includes a data entry and verification module and a data storage and management module. The method includes:

[0032] The data entry and verification module is used to enter the process instance data table and call the pre-compiled verification mechanism to verify the process instance data table, so as to obtain multiple verified data tables.

[0033] The data storage and management module is used to obtain the multiple verified data tables, store the multiple verified data tables in a relational database, establish the connection between the multiple data tables based on the primary keys and foreign keys of the multiple verified data tables, and use the data table corresponding to the primary key in the multiple data tables with established connection as the main data table, and the data table corresponding to the foreign key as the sub-data table of the main data table; wherein, the relational database supports multi-dimensional indexing, and the index type is B-tree index.

[0034] The data storage and management module is further used to, when receiving a data query request, respond to the data query request and query in the main data table and sub-data tables in the relational database to obtain a data query result.

[0035] In a third aspect, an embodiment of the present invention provides an electronic device, which is installed with the database management system for supporting intelligent processing of electro-hydraulic control actuator parts described in the first aspect, including:

[0036] At least one processor;

[0037] A memory for storing instructions executable by the at least one processor;

[0038] Wherein, the at least one processor is configured to execute the instructions to run the database management system for supporting intelligent processing of electro-hydraulic control actuator parts described in the first aspect.

[0039] In a fourth aspect, an embodiment of the present invention provides a computer-readable storage medium, when the instructions in the computer-readable storage medium are executed by a processor of an electronic device, enabling the electronic device to run the database management system for supporting intelligent processing of electro-hydraulic control actuator parts described in the first aspect.

[0040] The technical solution provided by the embodiment of the present invention is a database management system that supports the intelligent processing of electro-hydraulic control actuator parts, including a data entry and verification module and a data storage and management module. The data entry and verification module can call a pre-compiled verification mechanism to verify the process instance data table, obtaining multiple verified data tables, and the data in the multiple verified data tables is more accurate. Moreover, the data storage and management module stores the multiple verified data tables using a relational database, establishes the connection between multiple data tables through the primary key and foreign key of the data tables, and the relational database supports multi-dimensional indexing, and the index type is a B-tree index. When receiving a data query request, it queries in the main data table and sub-data tables in the relational database to obtain a data query result.

[0041] The data storage and management module uses a relational database for data storage, supports multi-dimensional indexing and fast retrieval, improves the accuracy of query results, establishes the connection between multiple data tables through the primary key and foreign key, and this structured association relationship ensures the close connection and dependence between various elements in the processing process. And the retrieval type of the relational database is a B-tree index, which is suitable for most query scenarios, supports operations such as equal value query, range query, sorting, etc., including clustered index, non-clustered index, and composite index, etc., thereby making the data query result more accurate, improving the data query efficiency and data management efficiency, and the accurate data query result is helpful for the intelligent processing of electro-hydraulic control actuator parts and is beneficial to subsequent part design, manufacturing, and maintenance work. Brief Description of the Drawings

[0042] Figure 1 It is a schematic diagram of the overall structure of a database management system that supports the intelligent processing of electro-hydraulic control actuator parts provided by the embodiment of the present invention;

[0043] Figure 2 It is a schematic diagram of the structure of multiple data tables provided by the embodiment of the present invention;

[0044] Figure 3 It is a schematic diagram of the structure of the relational database established by the embodiment of the present invention;

[0045] Figure 4 It is a schematic diagram of the hierarchical management interface for user permissions implemented by the user permission and security management module in the embodiment of the present invention;

[0046] Figure 5 It is a schematic diagram of the interaction between various modules in a database management system that supports the intelligent processing of electro-hydraulic control actuator parts provided by the embodiment of the present invention;

[0047] Figure 6 It is a schematic diagram of the visual operation interface when manually inputting the process instance data table provided by the embodiment of the present invention;

[0048] Figure 7 It is a schematic flowchart of the verification process of the process instance data table provided by the embodiment of the present invention;

[0049] Figure 8 It is a schematic diagram of the electronic device provided by the embodiment of the present invention. Detailed implementation manners

[0050] The present invention will be described in detail below through embodiments.

[0051] In the design and manufacturing process of electro-hydraulic control actuators, the accurate management and efficient query of part data are crucial. Traditional database systems are difficult to meet the management requirements of complex part data, resulting in problems such as data redundancy and low query efficiency. Therefore, it is of great significance to design a database system that can intelligently manage the key part data of electro-hydraulic control actuators.

[0052] Traditional data entry is mainly completed by manual input. This method is not only inefficient but also prone to human errors, such as data format errors, parameter omissions, data duplication, etc., seriously affecting the accuracy and reliability of process data. To improve data entry efficiency, related technologies adopt the batch import method to import process data from external files such as Excel and CSV into the database. However, although batch import improves the speed, if the external data format is not standardized, there are missing or incorrect data, and it is directly stored in the database without verification, it will lead to a decline in data quality and affect subsequent design, manufacturing, and maintenance work.

[0053] To solve the above problems existing in the related technologies, the database management system provided by the embodiment of the present invention establishes a perfect data verification mechanism, which can automatically perform format verification, integrity verification, and historical data verification on the input data to ensure the accuracy and integrity of the data, avoid human errors, and avoid storing a large amount of redundant data in the database. In addition, for traditional relational databases when dealing with massive process data, query efficiency and data management capabilities often become performance bottlenecks. Therefore, the embodiment of the present invention provides an efficient database indexing scheme to improve the query and management efficiency of process data, which has important practical significance and application value.

[0054] To describe the solution clearly, first, the overall technical solution of the embodiment of the present invention will be elaborated in detail. As Figure 1 shown, it is a schematic diagram of the overall structure of a database management system that supports intelligent processing of electro-hydraulic control actuator parts provided by the embodiment of the present invention.

[0055] As Figure 1As shown in the figure, the database management system provided by the embodiment of the present invention includes three major modules, namely, a data entry and verification module, a data storage and management module, and a user permission and security management module.

[0056] 1. First, the data entry and verification module will be introduced.

[0057] The data entry and verification module supports users to manually and batch import process instance data tables. Moreover, it has a built-in verification mechanism that calls stored procedures to ensure the accuracy and integrity of the process instance data tables. The verification mechanism of the stored procedure is a set of pre-compiled SQL statements, which are stored in the database and executed by the database management system. It can receive parameters, execute complex business logics, and return verification results. The present invention uses user-defined stored procedures for data verification. It is similar to functions or methods in programming languages and usually uses SQL statements such as IF or IF EXISTS to execute verification operations. Since the verification mechanism is pre-compiled, its execution speed is faster than that of dynamic SQL.

[0058] As the main body of the database system, the data table is the basis for the realization of the functions of the data entry and verification module and the data storage and management module. The system divides the data tables into three types according to the processing characteristic attributes of hydraulic components. This structured data table design helps to systematically manage and query the detailed information of hydraulic components and their processing technologies. The data table structure diagram is as Figure 2 shown. The process instance data table can include a part information data table, a cutting tool material data table, and a processing technology data table.

[0059] Among them, the part information data table is used to store basic information such as the number, name, description, and type of hydraulic components. The types of hydraulic components include pistons, piston rods, flanges, cylinder heads, cylinder blocks, and rod barrels, etc.

[0060] The cutting tool material data table is used to store key data such as the geometric parameters and models of cutting tool materials. Among them, the geometric parameters mainly include tool diameter, tool angle, drill diameter, tap specification, etc.

[0061] The processing technology data table is used to store the process steps of the hydraulic component and their corresponding detailed parameters, including sub-tables such as a process table, a working step table, and a process parameter table. Among them, the process table involves processes such as rough turning, semi-finish turning, finish turning, milling slots, finish grinding, rough grinding, drilling threaded holes, and chrome plating. Based on the process name, the working step table further refines each process into specific operation steps, and finally lists the detailed parameters of each working step in the process parameter table. The process parameters involved include spindle speed, cutting speed, feed rate, and depth of cut.

[0062] Moreover, the method for entering the process instance data table in the embodiments of the present invention can be divided into manual entry and batch import. For the sake of complete and clear description of the solution, the method for entering the process instance data table and the verification process of the process instance data table will be elaborated in detail in the following embodiments.

[0063] 2. Introduce the data storage and management module.

[0064] The data storage and management module uses a relational database for data storage, supports multi-dimensional indexing and fast retrieval, and improves the accuracy of query results.

[0065] The data storage and management module uses a relational database management system (RDBMS), supports multi-dimensional indexing and fast retrieval, and the relational database established is as Figure 3 shown, and the relationship between each data table is established through the connection of the primary key and the foreign key.

[0066] For the creation of the primary and foreign keys of the tool material information table, the following SQL statements can be used for operations:

[0067] CREATE TABLE Materials(CREATE TABLE Materials(

[0068] ProcessID INT PRIMARY KEY,

[0069] PartID INT,

[0070] StepID INT,

[0071] MaterialName NVARCHAR(50),

[0072] MaterialDescription NVARCHAR(255),

[0073] ToolParameters DOUBLE,

[0074] FOREIGN KEY(PartID)REFERENCES Parts(PartID));

[0075] Among them, ProcessID is set as the PRIMARY KEY, that is, the primary key of the table Materials, and PartID in the Materials table is set as the FOREIGN KEY, that is, PartID is the foreign key of the affiliated table and corresponds to the primary key PartID in the above Parts table.

[0076] Specifically, as Figure 3As shown, "PartID" in the part information table is associated with the corresponding items in the cutting tool material information table and the machining process operation table. This indicates that the cutting tool material information table and the machining process operation table are two sub-tables of the part information table, which means that the machining process of a target machined part depends on specific operation steps and corresponding machining tool information.

[0077] Similarly, "ProcessID" in the machining operation table is associated with the corresponding item in the machining step table, indicating that the machining step table is a sub-table of the machining operation table, which means that each machining step belongs to a specific machining operation; "StepID" in the machining step table is associated with the corresponding item in the process parameter table, indicating that the process parameter table is a sub-table of the machining step table, which means that each process parameter is associated with a specific machining step. This structured association relationship ensures the close connection and dependence among various elements in the machining process.

[0078] The retrieval type of the relational database in the embodiment of the present invention is a B-tree index, which is suitable for most query scenarios and supports operations such as equality query, range query, sorting, etc., including clustered index, non-clustered index, and composite index, etc.

[0079] A clustered index (CLUSTERED INDEX) stores data rows in the order of the index key. Therefore, each data table can only have one clustered index, that is, the clustered index is usually applied to the primary key, while multiple non-clustered indexes (NONCLUSTERED INDEX) can be created. For the case of multi-column queries, a composite index can be used and arranged in the order of decreasing selectivity. Among them, columns with high selectivity should be selected as much as possible to create indexes, and columns with high update frequencies should be avoided as much as possible to create indexes.

[0080] Specifically, the following indexes can be established through SQL language. Table 1 shows the creation of clustered indexes and composite indexes.

[0081] Table 1

[0082]

[0083] 3. Introduce the user permission and security management module.

[0084] The user permission and security management module controls the user's access permission to data by establishing login permission settings and records operation logs to ensure data security.

[0085] Among them, the user permission and security management module realizes hierarchical management of user permissions, such as Figure 4As shown, by developing a database login interface, the access rights of users to different data can be controlled. Users can select the corresponding role on the login interface according to their identities, and log in to the database system by entering the corresponding account and password. Depending on the logged-in role, the scope of permissions that can be exercised is also different. Based on the size of the permission scope, different user roles are defined:

[0086] Administrators have all permissions and can manage system user data, query and record operation logs, etc.;

[0087] Ordinary users have basic query and operation permissions and can access and modify data within the authorized scope;

[0088] Visitors have read-only permissions and can view some public data.

[0089] The above access permissions specifically include:

[0090] Data access permissions control which tables, views, stored procedures, etc. users can access, and all user roles have this right;

[0091] Operation permissions control which operations users can perform, such as query, insert, update, delete, etc., and both administrators and ordinary users have this right;

[0092] System permissions control which system functions users can access, such as user management, configuration management, etc., and at the same time can query and record operation logs to ensure data security. Only administrators have this right.

[0093] Among them, the SQL CREATE USER and GRANT statements can be used to create users and assign permissions.

[0094] CREATE USER user1 IDENTIFIED BY"password";

[0095] GRANT SELECT,INSERT,UPDATE ON Users TO user1;

[0096] Among them, user1 is the user name and "password" is the password set by the user.

[0097] Compared with the prior art, the beneficial effects of the embodiments of the present invention are as follows: Through the automated data collection and parameter verification functions, the present invention provides rapid selection support for designers, effectively avoids repetitive labor, significantly reduces the time cost, and reduces the human errors caused by insufficient manual experience. At the same time, the present invention adopts multi-dimensional indexing and fast retrieval technologies. By creating composite indexes on multiple keyword fields, the data query efficiency is significantly improved. For example, in the part information table, composite indexes can be created for multiple dimensions such as part number, type, and material name to support multi-condition fast queries.

[0098] In addition, the present invention adopts a modular design, and the database management system can be flexibly configured and adjusted according to different parts, materials, and equipment to meet various processing requirements. Its good scalability and adaptability enable it to be widely applied to various complex manufacturing scenarios.

[0099] After elaborating on the overall technical solution of the embodiments of the present invention, a database management system for supporting intelligent machining of electro-hydraulic control actuator parts provided by the embodiments of the present invention will be elaborated in detail below. As Figure 5 shown, the database management system 500 includes a data entry and verification module 501 and a data storage and management module 502;

[0100] The data entry and verification module 501 is used to enter the process instance data table and call the pre-compiled verification mechanism to verify the process instance data table to obtain multiple verified data tables.

[0101] Among them, the process instance data table may include a part information data table, a tool material data table, and a machining process data table, as Figure 2 shown. The part information data table is used to store the component attribute information of hydraulic components, and the component attribute information includes number, name, description, and type;

[0102] The tool material data table is used to store the key information of tool materials, and the key information includes geometric parameters and models;

[0103] The machining process data table is used to store the process steps of hydraulic components and the detailed parameters corresponding to each process step. The detailed parameters include process tables, work step tables, and process parameter tables.

[0104] The database management system involved in the embodiments of the present invention is based on the SQL Server database system, which has a powerful transaction processing function and uses various methods to ensure data integrity for storing historical machining data.

[0105] As an implementation manner of the embodiments of the present invention, the data entry and verification module enters the process instance data table, which may specifically include the following two methods.

[0106] The first method is as follows: The data entry and verification module receives the process instance data table input by the user in a preset visual operation interface. Among them, the input operations include at least one of the following operations: adding, deleting, editing, and saving.

[0107] The second method is as follows: The data entry and verification module receives the process instance data table batch-imported by the target data management tool through attribute mapping. Among them, during the batch import process, each process instance data table sets the part ID as the primary key.

[0108] For the first method, the manual input function designs a visual operation interface for the process database based on the Visual Studio platform. Users can manually add, delete, edit, or save process instance data through this visual operation interface. By operating through this visual operation interface to enter the process instance data table, it is possible to avoid using a large amount of SQL language to implement data management, saving storage time. This visual operation interface is as Figure 6 shown.

[0109] Among them, for the design of this visual operation interface, it is necessary to establish a connection between the SQL database and the Visual Studio platform based on the C# programming language. The connection method uses SQL Servers authentication. The server name can be LAPTOP-S5EV9E5V\TEW_SQLEXPRESS, the connection port is 1433, and the user name is sa.

[0110] The connection format between SQL Server and the Visual Studio platform is as follows:

[0111] using System.Data.SqlClient;

[0112] SqlConnection Con = new SqlConnection("connstring");

[0113] Con.Open();

[0114] Among them, "using System.Data.SqlClient" is the namespace. SqlConnection represents an open connection to a SQL Server database. The database connection string "connstring" contains all the information required to connect to the database, such as the server address, database name, user name, etc.

[0115] Users can perform manual entry operations according to the following process: In the Figure 6The feature attribute information input module shown above inputs the feature attributes of the new process instance data table. This module sets different areas for separate filling according to the data table attribute types. After filling is completed and the "Save" control is clicked, the database management system will, based on the verification function, determine whether the input new process instance data table meets the requirements of the data table attributes. If it meets the requirements, a preview image of the new process instance data table will appear in the storage result display module of this interface, that is, the process instance data table has been entered into the database system. If it does not meet the requirements, the storage result display module will display an error message to provide the verification result. The user can click the "Edit" control according to the verification result, modify the feature attributes again in the feature attribute information input module, and finally click the "Save" control until the process instance data table is successfully stored.

[0116] For the second method, batch import uses the import wizard function of the Navicat data management tool to achieve batch import of the process instance data table through attribute mapping.

[0117] During the batch import process, the primary key of the imported process instance data table must be set correctly, otherwise it will affect the use of subsequent indexes. Usually, the ID value of the part can be used as the primary key of the process instance data table to ensure the uniqueness of the data and the effectiveness of the index.

[0118] For the creation of the Parts table attributes and the primary key, the following SQL statement can be executed:

[0119] CREATE TABLE Parts(

[0120] PartID INT PRIMARY KEY,

[0121] PartName NVARCHAR(100),

[0122] Description NVARCHAR(255),

[0123] Type NVARCHAR(50));

[0124] Among them, the data type of PartID is INT and it is set as PRIMARY KEY, that is, PartID is the primary key of the Parts table.

[0125] Specifically, the user first needs to set the table headers in the Navicat data management tool, that is, the processing feature attributes of each data table, and determine the primary key. Then, through the import wizard function, select multiple process instance data tables to be imported, map the set table headers to the attributes of the process instance data tables one by one, perform attribute mapping, and select the append import mode to achieve the import of multiple process instance data tables. If error messages are obtained through the verification function, the user also needs to modify the process instance data table through the visual operation interface and re-import it.

[0126] In practical applications, when importing a large number of process instance data tables, the manual import method and the batch import method can be combined to improve the import efficiency of the process instance data tables.

[0127] As an implementation manner of the embodiment of the present invention, the data entry and verification module calls the verification mechanism to verify the process instance data tables, and obtains multiple verified data tables, which may include the following three steps, namely step a1 to step a3:

[0128] Step a1, the data entry and verification module performs format verification on the process instance data tables. If the format of the process instance data tables does not conform to the predetermined format, adjust the format of the process instance data tables to the predetermined format.

[0129] Step a2, the data entry and verification module performs integrity verification on the process instance data tables. If there are missing required fields in the process instance data tables or errors in the associated data, supplement the missing required fields or modify the associated data with errors.

[0130] Step a3, the data entry and verification module performs historical data verification on the process instance data tables. If the process instance data tables are exactly the same as the existing historical data tables in the database, delete the newly entered process instance data tables.

[0131] Specifically, for the verification function of the data entry and verification module, it automatically performs verification on data format, integrity, and repeatability by calling a stored procedure. The verification process is as Figure 7 shown, and it can be seen from Figure 7 that the verification process may include the following steps:

[0132] Step 1: For the newly imported process instance data tables, format verification needs to be performed first, including data type verification, range verification, etc., to ensure that the data conforms to the predetermined format requirements. The system will call a stored procedure to check whether the data format is correct. If the check is correct, the next test will be performed. Otherwise, error messages will be output, and the user will be returned to the processing technology management system interface to modify the feature attributes again, and finally re-import.

[0133] Step 2: After the format check is completed, enter the integrity check. This step is used to detect whether all required fields have been filled in and the associated data is complete and error-free. For example, check whether the geometric parameters of the parts are complete and the material information is complete. The system will call a stored procedure to check whether the data content is complete. If the check is correct, proceed to the next check. Otherwise, an error message will be output, and the user will be returned to the processing technology management system interface to modify the feature attributes again. Finally, import again.

[0134] Step 3: After passing the integrity check, enter the historical data check. This step is used to check whether the newly entered process instance data table is exactly the same as the existing historical data in the database, avoid duplicate entry, and ensure the uniqueness of the process instance information. The system will call a stored procedure to compare the imported data with the data table content in the original database to check whether there is duplicate data content. If there is no duplication, confirm to import the new process instance data table into the database system to complete the update of the database system. Otherwise, an error message will be output, and the newly entered process instance data table will be deleted.

[0135] As an implementation of the embodiment of the present invention, the pre-compiled verification mechanism is a group of pre-compiled SQL statements. The SQL statements are stored in a relational database and, after detecting the entered process instance data table, automatically verify the entered process instance data table and return the verification result.

[0136] Specifically, the pre-compiled verification mechanism is a group of pre-compiled SQL statements. It is stored in the database and is executed by the database management system. It can receive parameters, execute complex business logic, and return the verification result. The present invention uses user-defined stored procedures for data verification. It is similar to functions or methods in programming languages. Usually, SQL statements such as IF or IF EXISTS are used to execute verification operations. Since the stored procedure is pre-compiled, the execution speed is faster than that of dynamic SQL.

[0137] Specifically, based on SQL statements, the creation of the following stored procedure can be realized. Table 2 shows the creation and verification logic of the stored procedure.

[0138] Table 2

[0139]

[0140] The data storage and management module 502 is used to obtain multiple verified data tables, store the multiple verified data tables in a relational database, establish the relationship between the multiple data tables based on the primary key and foreign key of the multiple verified data tables, and use the data table corresponding to the primary key in the multiple established data tables as the main data table, and the data table corresponding to the foreign key as the sub-data table of the main data table.

[0141] Among them, the relational database supports multi-dimensional indexing, and the index type is B-tree index.

[0142] Specifically, after obtaining multiple verified data tables, the data storage and management module uses a relational database for data storage, supports multi-dimensional indexing and fast retrieval, and improves the accuracy of query results. The established relational database model is as mentioned in the above embodiments Figure 3 As shown, the relationship between each data table is established through the connection between the primary key and the foreign key. Among the multiple data tables with established connections, the data table corresponding to the primary key is used as the main data table, and the data table corresponding to the foreign key is used as the sub-data table of the main data table. A main data table can have multiple sub-data tables. This structured association relationship ensures the close connection and dependence between various elements in the processing process. The retrieval type of the relational database in the embodiment of the present invention is B-tree index, which is applicable to most query scenarios and supports operations such as equal value query, range query, sorting, etc., including clustered index, non-clustered index, and composite index, etc., to improve the retrieval speed of the database management system. Among them, the clustered index, non-clustered index, and composite index have been described in the above embodiments and will not be elaborated here.

[0143] The data storage and management module 502 is further configured to, when receiving a data query request, respond to the data query request and query in the main data table and the sub-data table in the relational database to obtain a data query result.

[0144] Specifically, after storing multiple verified data tables in a relational database and establishing the connection between multiple data tables based on the primary key and foreign key of the multiple verified data tables, if a data query request is received, the data storage and management module responds to the data query request, that is, parses the data query request to obtain the parsing result of the data query request, and queries in the main data table and the sub-data table in the relational database according to the parsing result to obtain a data query result. Since the database management system provided by the embodiment of the present invention supports multi-dimensional indexing and fast retrieval, and associates multiple data tables, the accuracy of the data query result is improved, and the data query efficiency is also improved.

[0145] The technical solution provided by the embodiment of the present invention is a database management system that supports the intelligent processing of electro-hydraulic control actuator parts, including a data entry and verification module, and a data storage and management module. The data entry and verification module can call a pre-compiled verification mechanism to verify the process instance data table, obtaining multiple verified data tables. The data in the multiple verified data tables is more accurate. Moreover, the data storage and management module stores the multiple verified data tables using a relational database, establishes the connection between multiple data tables through the primary key and foreign key of the data tables, and the relational database supports multi-dimensional indexing, and the index type is a B-tree index. When receiving a data query request, it queries in the main data table and sub-data tables in the relational database to obtain a data query result.

[0146] The data storage and management module uses a relational database for data storage, supports multi-dimensional indexing and fast retrieval, improves the accuracy of query results, establishes the connection between multiple data tables through the primary key and foreign key. This structured association relationship ensures the close connection and dependence between various elements in the processing process. And the retrieval type of the relational database is a B-tree index, which is suitable for most query scenarios, supports operations such as equal value query, range query, sorting, including clustered index, non-clustered index, and composite index, etc. Furthermore, it makes the data query result more accurate, improves the data query efficiency and data management efficiency, and the accurate data query result is helpful for the intelligent processing of electro-hydraulic control actuator parts, and is beneficial to subsequent part design, manufacturing, and maintenance work.

[0147] Based on the Figure 5 shown embodiment, as an implementation manner of the embodiment of the present invention, the database management system may further include a user permission and security management module;

[0148] The user permission and security management module is used to set user login permissions and user access permissions;

[0149] The user permission and security management module is further used to determine the target user login permission and target user access permission corresponding to the target user after receiving the login request of the target user;

[0150] The user permission and security management module is further used to determine the target data that the target user can access based on the target user login permission and target user access permission;

[0151] The user permission and security management module is further used to record the operation log of the target user during the process of the target user accessing the target data.

[0152] As an implementation manner of the embodiment of the present invention, the user access permission may include data access permission, operation permission control user, and system permission.

[0153] Data access rights are used to determine the data range accessible to users. The accessible data range includes at least one of the following: tables, views, and data storage procedures;

[0154] Operation permissions control users to determine the operations that users can perform. The operations that can be performed include at least one of the following: query, insert, update, and delete;

[0155] System permissions are used to determine the system functions that users can access. The system functions that can be accessed include at least one of the following: user management, configuration management, querying and recording operation logs.

[0156] It should be noted that in the previous embodiments, the user permissions and security management module have been elaborated in detail and will not be repeated here.

[0157] An embodiment of the present invention also provides a database management method for supporting intelligent machining of electro-hydraulic control actuator parts, which is applied to a database management system for supporting intelligent machining of electro-hydraulic control actuator parts. The database management system includes a data entry and verification module and a data storage and management module. The method includes:

[0158] The data entry and verification module is used to enter the process instance data table and call a pre-compiled verification mechanism to verify the process instance data table to obtain multiple verified data tables;

[0159] The data storage and management module is used to obtain the multiple verified data tables, store the multiple verified data tables using a relational database, establish connections between the multiple data tables based on the primary keys and foreign keys of the multiple verified data tables, and use the data table corresponding to the primary key as the main data table and the data table corresponding to the foreign key as the sub-data table of the main data table among the multiple data tables with established connections; wherein, the relational database supports multi-dimensional indexing and the index type is a B-tree index;

[0160] The data storage and management module is further used to, when receiving a data query request, respond to the data query request and query in the main data table and sub-data tables in the relational database to obtain a data query result.

[0161] It should be noted that since the database management method for supporting intelligent machining of electro-hydraulic control actuator parts corresponds to the database management system for supporting intelligent machining of electro-hydraulic control actuator parts, the database management method will not be repeated here.

[0162] An embodiment of the present invention also provides an electronic device 800, which is installed with the database management system for supporting intelligent machining of electro-hydraulic control actuator parts according to the embodiment of the present invention, such as Figure 8 shown, including:

[0163] At least one processor 801;

[0164] A memory 802 for storing executable instructions of the at least one processor;

[0165] Wherein, the at least one processor is configured to execute the instructions to run the database management system for supporting intelligent machining of electro-hydraulic control actuator parts according to the embodiment of the present invention.

[0166] An embodiment of the present invention also provides a computer-readable storage medium. When the instructions in the computer-readable storage medium are executed by a processor of an electronic device, the electronic device can run the database management system for supporting intelligent machining of electro-hydraulic control actuator parts according to the embodiment of the present invention.

[0167] Although the embodiments of the present invention have been shown and described above, the above embodiments are exemplary and should not be construed as limiting the present invention. Those of ordinary skill in the art can make changes, modifications, substitutions, and variations to the above embodiments within the scope of the present invention without departing from the principles and purposes of the present invention.

Claims

1. A database management system for supporting intelligent machining of electro-hydraulic control actuator parts, characterized in that, The database management system includes a data entry and verification module, and a data storage and management module; The data entry and verification module is used to enter the process instance data table and call a pre-compiled verification mechanism to verify the process instance data table to obtain multiple verified data tables; The data storage and management module is used to obtain the multiple verified data tables, store the multiple verified data tables in a relational database, establish a connection between the multiple data tables based on the primary keys and foreign keys of the multiple verified data tables, and use the data table corresponding to the primary key as the main data table among the multiple data tables with the established connection, and the data table corresponding to the foreign key as the sub-data table of the main data table; wherein, the relational database supports multi-dimensional indexing, and the index type is a B-tree index; The data storage and management module is further used to, when receiving a data query request, respond to the data query request and query in the main data table and sub-data tables in the relational database to obtain a data query result.

2. The system according to claim 1, wherein The data entry and verification module enters the process instance data table, specifically including: The data entry and verification module receives the process instance data table input by the user in a preset visual operation interface, wherein the input operations include at least one of the following operations: adding, deleting, editing, and saving; And / or, The data entry and verification module receives the process instance data table batch-imported by the target data management tool through attribute mapping, wherein during the batch import, each process instance data table sets the part ID as the primary key.

3. The system according to claim 1, characterized in that, The data entry and verification module calls the verification mechanism to verify the process instance data table to obtain multiple verified data tables, including: The data entry and verification module performs format verification on the process instance data table, and if the format of the process instance data table does not conform to the predetermined format, adjusts the format of the process instance data table to the predetermined format; The data entry and verification module performs integrity verification on the process instance data table, and if there are missing required fields in the process instance data table or errors in the associated data, supplements the missing required fields or modifies the associated data with errors; The data entry and verification module performs historical data verification on the process instance data table, and if the process instance data table is exactly the same as the existing historical data table in the database, deletes the newly entered process instance data table.

4. The system according to claim 1, wherein The process instance data table includes a part information data table, a tool material data table, and a machining process data table: The part information data table is used to store the component attribute information of the hydraulic component, and the component attribute information includes number, name, description, and type; The tool material data table is used to store the key information of the tool material, and the key information includes geometric parameters and model; The machining process data table is used to store the process steps of the hydraulic component and the detailed parameters corresponding to each process step, and the detailed parameters include a process table, a work step table, and a process parameter table.

5. The system according to claim 1, characterized in that, The pre-compiled verification mechanism is a set of pre-compiled SQL statements stored in a relational database. After detecting the input process instance data table, it automatically verifies the input process instance data table and returns the verification result.

6. The system according to any one of claims 1 to 5, characterized in that The database management system further includes a user privilege and security management module; The user privilege and security management module is used to set user login privileges and user access privileges; The user privilege and security management module is further used to determine the target user login privilege and target user access privilege corresponding to the target user after receiving the login request of the target user; The user privilege and security management module is further used to determine the target data that the target user can access based on the target user login privilege and the target user access privilege; The user privilege and security management module is further used to record the operation log of the target user during the process of the target user accessing the target data.

7. The system according to claim 6, wherein The user access privilege includes data access privilege, operation privilege control user, and system privilege; The data access privilege is used to determine the data range that the user can access, and the accessible data range includes at least one of the following: table, view, and data storage procedure; The operation privilege control user is used to determine the operations that the user can execute, and the executable operations include at least one of the following: query, insert, update, and delete; The system privilege is used to determine the system functions that the user can access, and the accessible system functions include at least one of the following: user management, configuration management, query and record operation log.

8. A database management method for supporting intelligent machining of electro-hydraulic control actuator parts, characterized in that, A database management system applied to support intelligent machining of electro-hydraulic control actuator parts, the database management system includes a data entry and verification module, and a data storage and management module, the method includes: The data entry and verification module is used to enter the process instance data table and call the pre-compiled verification mechanism to verify the process instance data table to obtain multiple verified data tables; The data storage and management module is used to obtain the multiple verified data tables, store the multiple verified data tables using a relational database, establish the relationship between the multiple data tables based on the primary key and foreign key of the multiple verified data tables, and use the data table corresponding to the primary key as the main data table and the data table corresponding to the foreign key as the sub-data table of the main data table among the multiple data tables with established relationships; wherein, the relational database supports multi-dimensional indexing and the index type is B-tree index; The data storage and management module is further used to, when receiving a data query request, respond to the data query request and query in the main data table and sub-data tables in the relational database to obtain a data query result.

9. An electronic device, characterized in that, The electronic device is installed with the database management system for supporting intelligent machining of electro-hydraulic control actuator parts according to any one of claims 1 to 7, including: At least one processor; A memory for storing executable instructions of the at least one processor; Wherein, the at least one processor is configured to execute the instructions to run the database management system for supporting intelligent machining of electro-hydraulic control actuator parts according to any one of claims 1 to 7.

10. A computer-readable storage medium, characterized in that, When the instructions in the computer-readable storage medium are executed by a processor of an electronic device, the electronic device is enabled to run the database management system for supporting intelligent machining of electro-hydraulic control actuator parts according to any one of claims 1 to 7.

Images