Database management system and method
By introducing user management module, file extraction module, information management and locking module, inspection module, script generation module and flow diagram generation module in the database management system, the problem of difficult management of project interfaces and file extraction and conversion of different storage interface formats is solved. , realizes efficient and automated database management.
Patent Information
- Application Number
- CN202310935318.8
- Authority / Receiving Office
- CN · China
- Patent Type
- Applications(China)
- Current Assignee / Owner
- Filing Date
- 2023-07-27
- Publication Date
- 2025-02-07
AI Technical Summary
In the prior art, project interfaces are difficult to manage and control, big data of the same type does not have automated processing tools, and the extraction and conversion of files in different storage interface formats.
Provide a database management system, including user management module, file extraction module, information management and locking module, inspection module, script generation module and flow diagram generation module, through which efficient management of databases and automation functions are improved.
It improves the efficiency of database management, avoids manual intervention, solves the problem of difficulty in managing project interfaces and the extraction and conversion of files in different storage interface formats, and improves the automation function of the database, improving its functions and usability.
Smart Images

Figure CN119396905A_ABST
Abstract
Description
Technical Field
[0001] The present application relates to the field of computer technology, and in particular to a database management system and method. Background Art
[0002] The existing automotive development platform uses the AUTOSAR architecture for collaborative development of software systems. Although AUTOSAR supports interface management between modules, it has high requirements for hardware and developers' AUTOSAR knowledge reserves. With the increasing requirements for vehicle intelligence, more and more non-vehicle-related professionals are involved in the development of automotive systems. In order to reduce the time and hardware costs of interface docking, the current application layer interfaces are mostly delivered in the form of EXCEL documents. The existing technology has problems such as difficult management and control of project interfaces, no automated processing tools for the same type of big data, and extraction and conversion of files in different storage interface formats. Summary of the invention
[0003] In view of this, the embodiments of the present application provide a database management system and method, which aim to solve the problems of difficult management and control of project interfaces, lack of automated processing tools for the same type of big data, and extraction and conversion of files in different storage interface formats.
[0004] In a first aspect, an embodiment of the present application provides a database management system, the database management system comprising: a user management module, a file extraction module, an information management and locking module, a check module, a script generation module and a flow chart generation module:
[0005] The user management module is used to manage the rights of users of the system;
[0006] The file extraction module is used to extract information from the network configuration file into the target file during the development of the project;
[0007] The checking module is used to check whether the rule form of the modified version meets the requirements when the version of the project is modified;
[0008] The information management and locking module is used to manage the entry of the target file. When the requirements of the project change and a new version is generated, the new version is reviewed and locked, and the change items are recorded;
[0009] The script generation module is used to automatically generate the test script of the project according to the development requirements of the project;
[0010] The flow graph generation module is used to generate a signal flow graph between modules in the project.
[0011] Optionally, the script generation module is specifically used to:
[0012] Obtain network signals and input and output signals of each module;
[0013] Performing an input interface test based on the input signal;
[0014] Performing an output interface test based on the output signal;
[0015] According to the assignment rules in the input interface test and the output interface test, the python script is associated with the database through the API interface of the database, and a test script is generated.
[0016] Optionally, the flow graph generation module is specifically used to:
[0017] Define the input terminals and input terminal properties of each module;
[0018] Based on the API interface of the database, read the input and output terminals of each module;
[0019] A signal flow graph between the modules is generated by using a mapping module according to the input terminals of the modules and the data flow of the input terminals.
[0020] Optionally, the user management module is specifically used to:
[0021] Setting the authority of the system architecture personnel to use the file extraction module, the information management and locking module, the script generation module and the flow chart generation module;
[0022] Setting the module developer's authority to modify the database content of the project and receiving the generated test script and signal flow graph;
[0023] Set the viewer's permissions to view the contents of the locked version of the project.
[0024] Optionally, the permission of the module developer is to modify the database content of the project, and the user management module specifically includes:
[0025] If the system architect opens the modification rights of the module developer, the module developer’s rights at this time are to modify and import the database. If there are format errors after importing, the module developer needs to rework and modify the database.
[0026] If the system architect closes the modification authority of the module developer, the authority of the module developer is changed to viewing the current version of the project database and the module database of historical changes.
[0027] Optionally, the inspection module is specifically used to:
[0028] When each application layer module enters information, if there is information required by the specified rule form, then a restriction item and an example description are added to the database side. When the information is entered, it is determined whether the rule form of the information meets the rule form requirements;
[0029] If it involves interaction between modules, the signal information of the module input and output ends is identified through the API interface using a Python script, and the signal information at both ends is compared to see if they are consistent. If they are inconsistent, they are displayed on the database interaction interface.
[0030] Optionally, the file extraction module specifically includes:
[0031] Analyze the standardized format of ARXML / DBC and complete the signal information extraction of ARXML / DBC;
[0032] The extracted signal information is written into a database through an API interface of the database and processed, and the processed signal information or module information of an existing database is extracted into a target table.
[0033] In a second aspect, an embodiment of the present application provides a database management method, which is applied to a database management system, wherein the system includes: a user management module, a file extraction module, an information management and locking module, a check module, a script generation module, and a flow chart generation module; the method includes:
[0034] Using the user management module to manage the rights of users of the system;
[0035] Utilizing the file extraction module to extract information from a network configuration file into a target file during the development of a project;
[0036] When the version of the project is modified, the checking module is used to check whether the rule form of the modified version meets the requirements;
[0037] The target file is entered and managed using the information management and locking module. When the requirements of the project change and a new version is generated, the new version is reviewed and locked, and the change items are recorded;
[0038] Utilizing the script generation module to automatically generate a test script for the project according to the development requirements of the project;
[0039] The flow graph generation module is used to generate a signal flow graph between modules in the project.
[0040] Optionally, the automatically generating a test script for the project includes:
[0041] Obtain network signals and input and output signals of each module;
[0042] Performing an input interface test based on the input signal;
[0043] Performing an output interface test based on the output signal;
[0044] According to the assignment rules in the input interface test and the output interface test, the python script is associated with the database through the API interface of the database, and a test script is generated.
[0045] Optionally, generating a signal flow graph between modules involved in the project includes:
[0046] Define the input terminals and input terminal properties of each module;
[0047] Based on the API interface of the database, read the input and output terminals of each module;
[0048] A signal flow graph between the modules is generated by using a mapping module according to the input terminals of the modules and the data flow of the input terminals.
[0049] In a third aspect, an embodiment of the present application provides a computer storage medium, in which a code is stored. When the code is executed, a device executing the code implements any method described in the second aspect.
[0050] The present application provides a database management system and method, which includes: a user management module, a file extraction module, an information management and locking module, a check module, a script generation module and a flow graph generation module. Among them, the user management module is used to manage the rights of users of the system; the file extraction module is used to extract information from the network configuration file into the target file during the development of the project; the check module is used to check whether the rule form of the modified version meets the requirements when the version of the project is modified; the information management and locking module is used to enter the target file, and when the requirements of the project change and a new version is generated, the new version is reviewed and locked, and recorded; the script generation module is used to automatically generate the test script of the project according to the development requirements of the project; the flow graph generation module is used to generate the signal flow graph between the modules in the project. In this way, by extracting data information from the database and creating a project through the check module, the file extraction module and the information management and locking module, the version update occurs, and the rule review of the updated version is completed, which can greatly improve the management efficiency of the database, avoid manual intervention, and solve the problem of difficult management of project interfaces and extraction and conversion of files in different storage interface formats. At the same time, by using the script generation module and the flow graph generation module, the automatic generation of test scripts and signal flow graphs between different modules of the database can be completed, which improves the automation function of the database, making the database more comprehensive and improving its usability. BRIEF DESCRIPTION OF THE DRAWINGS
[0051] In order to more clearly illustrate the technical solutions in this embodiment or the prior art, the drawings required for use in the embodiments or the description of the prior art will be briefly introduced below. Obviously, the drawings described below are only some embodiments of the present application. For ordinary technicians in this field, other drawings can be obtained based on these drawings without paying creative work.
[0052] Figure 1 A schematic diagram of the structure of a database management system provided in an embodiment of the present application;
[0053] Figure 2 A flowchart of a database management method provided in an embodiment of the present application;
[0054] Figure 3 A schematic diagram of the structure of a database management system in an application scenario provided in an embodiment of the present application. DETAILED DESCRIPTION
[0055] The embodiments of the present application will be described in more detail below with reference to the accompanying drawings. Although certain embodiments of the present application are shown in the accompanying drawings, it should be understood that the present application can be implemented in various forms and should not be construed as being limited to the embodiments described herein. Instead, these embodiments are provided to provide a more thorough and complete understanding of the present application. It should be understood that the drawings and embodiments of the present application are only for exemplary purposes and are not intended to limit the scope of protection of the present application.
[0056] In the study of related technologies, it was found that the existing automotive development platform uses the AUTOSAR architecture for cooperative development of software systems. Although AUTOSAR supports interface management between modules, it has high requirements for hardware and developers' AUTOSAR knowledge reserves. With the increasing requirements for vehicle intelligence, more and more non-vehicle-related professionals are involved in the development of automotive systems. In order to reduce the time and hardware costs of interface docking, the current application layer interfaces are mostly delivered in the form of EXCEL documents.
[0057] Based on this, the present application proposes a database management system and method, which, by designing different operation management modules, can achieve efficient management of the database and improve the automation function, while solving the problems of difficult management and control of project interfaces, lack of automated processing tools for the same type of big data, and extraction and conversion of files in different storage interface formats.
[0058] Figure 1 A schematic diagram of the structure of a database management system provided in the embodiment of the present application is shown in FIG. Figure 1 As shown, a database management system provided by an embodiment of the present application includes: a user management module 100, a file extraction module 200, a check module 300, an information management and locking module 400, a script generation module 500 and a flow chart generation module 600:
[0059] The user management module 100 is used to manage the rights of users of the system;
[0060] The file extraction module 200 is used to extract information in the network configuration file into a target file during the development of the project;
[0061] The checking module 300 is used to check whether the rule form of the modified version meets the requirements when the version of the project is modified;
[0062] The information management and locking module 400 is used to manage the entry of the target file, and when the requirements of the project change and a new version is generated, the new version is reviewed and locked, and recorded;
[0063] The script generation module 500 is used to automatically generate a test script for the project according to the development requirements of the project;
[0064] The flow graph generation module 600 is used to generate a signal flow graph between modules in the project.
[0065] In a possible implementation, the script generation module 500 is specifically used to:
[0066] Obtain network signals and input and output signals of each module;
[0067] Performing an input interface test based on the input signal;
[0068] Performing an output interface test based on the output signal;
[0069] According to the assignment rules in the input interface test and the output interface test, the python script is associated with the database through the API interface of the database, and a test script is generated.
[0070] The specific function of the script generation module mentioned above is mainly used to automatically generate test scripts. The specific generation method is explained by taking the network signal as an example, integrating the network signal and the corresponding input and output signals of each module in the database. Then input the interface test, assign the value to the controller through the capl script in CANoe, obtain the value of the signal received by the corresponding module in the controller on the CANape side, and compare it with the expected value to generate a test report.
[0071] Output interface test, by assigning values to the output signals of the internal modules of the controller, obtaining the signal values sent by CAN on the CANoe side, and comparing them with the expected values to generate a test report.
[0072] By utilizing the database's API interface, Python is associated with the database, and the scripts required for testing can be directly generated based on the Python algorithm and the data in the database.
[0073] In a possible implementation, the flow graph generation module 600 is specifically used for:
[0074] Define the input terminals and input terminal properties of each module;
[0075] Based on the API interface of the database, read the input and output terminals of each module;
[0076] A signal flow graph between the modules is generated by using a mapping module according to the input terminals of the modules and the data flow of the input terminals.
[0077] The main function of the flow graph generation module mentioned above is to generate signal flow graphs for each module in the database. The signal flow graphs between modules are displayed in the form of a graphical interface, and the display is based on the input and output flows of the modules in the database.
[0078] The specific process is:
[0079] In the input and output flow of the module, the properties of the input and output terminals are defined. The input and output terminals of the module can be read through the API interface inside the database, and the editable graphical software can be linked to automatically generate the signal flow diagram of each module in the entire controller.
[0080] In a possible implementation, the user management module 100 is specifically used for:
[0081] Setting the authority of the system architecture personnel to use the file extraction module, the information management and locking module, the script generation module and the flow chart generation module;
[0082] Setting the module developer's authority to modify the database content of the project and receiving the generated test script and signal flow graph;
[0083] Set the viewer's permissions to view the contents of the locked version of the project.
[0084] The function of the user management module in the embodiment of the present application is to set different usage and operation permissions for different types of database users, so as to perform permission management on users who log in to the database and ensure the security of the database.
[0085] For example, the user roles for logging into the database may include system architects, module developers, and viewers, etc. System architects and module developers are given higher permissions than viewers. System architects and module developers can have management permissions to change database configurations, while viewers can only have the ability to browse data and cannot change the system architecture.
[0086] In a possible implementation, the permission of the module developer is to modify the database content of the project, and the user management module 100 specifically includes:
[0087] If the system architect opens the modification rights of the module developer, the module developer’s rights at this time are to modify and import the database. If there are format errors after importing, the module developer needs to rework and modify the database.
[0088] If the system architect closes the modification authority of the module developer, the authority of the module developer is changed to viewing the current version of the project database and the module database of historical changes.
[0089] The above method is only an example of dividing user rights in the user management module. In actual applications, other methods can also be used to divide user rights. The operating rights that users can obtain may be different in different application scenarios and usage situations. The specific division of user rights can be made by technical personnel in this field according to actual conditions and application scenarios, and is not limited here.
[0090] In a possible implementation, the inspection module 300 is specifically used to:
[0091] When each application layer module enters information, if there is information required by the specified rule form, then a restriction item and an example description are added to the database side. When the information is entered, it is determined whether the rule form of the information meets the rule form requirements;
[0092] If it involves interaction between modules, the signal information of the module input and output is identified through the API interface using a python script, and the signal information of the input and output are compared to see if they are consistent. If they are inconsistent, they are displayed on the database interaction interface.
[0093] The main function of the inspection module is to verify whether the information entered into the database complies with the rules and whether there are errors in the information transmission between modules.
[0094] In a possible implementation, the file extraction module 200 specifically includes:
[0095] Analyze the standardized format of ARXML / DBC and complete the signal information extraction of ARXML / DBC;
[0096] The extracted signal information is written into a database through an API interface of the database and processed, and the processed signal information or module information of an existing database is extracted into a target table.
[0097] The main function of the file extraction module is to extract signal information and then extract the signal information into the target table, so that the information of the target table can be used for data transmission later.
[0098] In this embodiment, a database management system is proposed, which includes: a user management module, a file extraction module, a check module, an information management and locking module, a script generation module and a flow graph generation module. Among them, the user management module is used to manage the rights of users of the system; the file extraction module is used to extract information from the network configuration file into the target file during the development of the project; the check module is used to check whether the rule form of the modified version meets the requirements when the version of the project is modified; the information management and locking module is used to enter and manage the target file, and when the requirements of the project change and a new version is generated, the new version is reviewed and locked, and recorded; the script generation module is used to automatically generate the test script of the project according to the development requirements of the project; the flow graph generation module is used to generate the signal flow graph between the modules in the project. In this way, the inspection module, the file extraction module and the information management and locking module are used to extract the data information in the database, and the version is updated in the process of creating the project. The completion of the rule review for the updated version can greatly improve the management efficiency of the database, avoid manual intervention, effectively manage each project interface, and realize the extraction and conversion of files in different storage interface formats. At the same time, by using the script generation module and the flow graph generation module, the automatic generation of test scripts and signal flow graphs between different modules of the database can be completed, which improves the automation function of the database, making the database more comprehensive and improving its usability.
[0099] Figure 2 A flowchart of a database management method provided in an embodiment of the present application, as shown in the figure, a database management method specifically includes: the method is applied to a database management system, the system includes: a user management module, a file extraction module, a check module, an information management and locking module, a script generation module and a flow chart generation module; the method includes:
[0100] S11: Utilize the user management module to perform authority management on users of the system.
[0101] Permission management can be understood as assigning different operation permissions to different users. User permissions can be composed of, but not limited to, the following permissions: system architect permissions, module developer permissions, and browser permissions. System architect permissions are to use the file extraction module, the information management and locking module, the script generation module, and the flow graph generation module; module developers permissions are to modify the database content of the project, receive the generated test script and signal flow graph; browser permissions are to view the content of the locked project version. Specific permission management settings can be set by those skilled in the art according to actual conditions and application scenarios, and are not limited here.
[0102] S12: Utilizing the file extraction module to extract information in the network configuration file into a target file during the project development process.
[0103] The specific function of the file extraction module mentioned above is: to analyze the standardized format of ARXML / DBC and complete the signal information extraction of ARXML / DBC; then write the extracted signal information into the database through the database API interface and process it, and extract the processed signal information or the module information of the existing database into the target table.
[0104] S13: When the version of the project is modified, the checking module is used to check whether the rule form of the modified version meets the requirements.
[0105] The functions of the above-mentioned inspection module are as follows: when each application layer module enters information, if there is information required by the specified rule form, then add restrictions and examples on the database side. When the information is entered, determine whether the rule form of the information meets the requirements of the rule form; if it involves interaction between modules, then use the API interface to use a python script to identify the signal information of the module input and output ends, and compare whether the signal information at both ends is consistent. If it is inconsistent, it will be displayed on the database interaction interface. By checking the version rule form, the rule forms of each version can be standardized, making the database data more regular and orderly.
[0106] S14: Use the information management and locking module to perform entry management on the target file. When the requirements of the project change and a new version is generated, the new version is reviewed and locked, and the change items are recorded.
[0107] S15: Utilizing the script generation module to automatically generate a test script for the project according to the development requirements of the project.
[0108] The specific function of the script generation module is as follows: first, the network signal and the input and output signals of each module are obtained. Then, the input interface test is performed based on the input signal, and the output interface test is performed based on the output signal. Finally, according to the assignment rules in the input interface test and the output interface test, the Python script is associated with the database through the API interface of the database, and a test script is generated. By automatically generating test scripts, a large number of test scripts can be generated for testing, thereby improving the efficiency of the database.
[0109] S16: Generate a signal flow graph between modules in the project using the flow graph generation module.
[0110] The specific function of the flow graph generation module is: first, define the input end and the attributes of the input end of each module, then read the input end and the input end of each module based on the API interface of the database, and finally use the mapping module to generate the signal flow graph between the modules according to the data flow of the input end and the input end of each module. By automatically generating the signal flow graph between modules, the data transmission between modules can be mastered, which is convenient for the overall management of the database.
[0111] This embodiment provides a database management method, which is applied to a database management system. The system includes: a user management module, a file extraction module, a check module, an information management and locking module, a script generation module and a flow graph generation module; the method includes: using the user management module to manage the rights of users of the system; using the file extraction module to extract information in the network configuration file into the target file during the development of the project; using the check module to check whether the rule form of the modified version meets the requirements when the version of the project is modified; using the information management and locking module to manage the entry of the target file, when the requirements of the project change and a new version is generated, the new version is reviewed and locked, and recorded; using the script generation module to automatically generate the test script of the project according to the development requirements of the project; using the flow graph generation module to generate the signal flow graph between the modules in the project. In this way, the user management module can clarify the operation rights of different users for the database, and improve the security of database use. The file extraction module, the information management and locking module and the check module can improve the processing efficiency of the database, avoid occupying unnecessary human resources, and realize the extraction and conversion of files in different storage interface formats. The script generation module and flow chart generation module can improve the automation function of the database and facilitate user use.
[0112] Figure 3 A schematic diagram of the structure of a database management system in an application scenario provided by an embodiment of the present application, such as Figure 3 As shown, the system may include: a front end and a back end;
[0113] The front end can use web pages and other forms to perform user registration and login, permission settings, display and operation of database content, and feedback and response to data processing from the back end. The front end server supports multi-person online editing.
[0114] The backend is mainly responsible for the storage and basic operations of the interface database information. In addition, the backend is also responsible for parsing and importing network configuration files. After the module developer modifies the database, the backend will check the data and feedback it to the frontend. When the version of the project database is locked, the backend will create a new database for the corresponding module and record the version change information.
[0115] exist Figure 3 In the system, different database usage permissions are granted according to different roles in software project development, mainly divided into system architects (maintainer), module developers (developer), and browsers (Guest).
[0116] For system architects, after a new project is started, they are responsible for creating new project engineering and proposing network signal configuration requirements. The network signal configuration file supports the import of ARXML / DBC / EXCEL and other formats. System architects are responsible for opening / closing the entry of interface database information, as well as reviewing and locking the version according to the changes in project requirements. The back-end database is responsible for recording the version number and change records of each change. System architects can extract the databases of all responsible projects to achieve the effect of subsequent product interface iterations. System architects can automatically generate header files for interface development in a unified format for module developers to use, automatically generate scripts for interface testing, automatically generate module input and output signal flows, and even arrange IPC communications, etc. according to development requirements.
[0117] For module developers, after the system architect opens the modification permission, they can modify and import the interface database. If there are format errors after input, they will be reworked and modified. After the system architect closes the modification permission, the module developer can view the current version of the project database and the module database of historical changes. After the version is locked, the module developer can also receive the header / source files and interface test scripts automatically generated for the corresponding version, which is convenient for subsequent module development.
[0118] For viewers, only the contents of the currently locked version of the project database can be viewed.
[0119] In addition to the above-mentioned contents, the following technical problems can also be solved in this embodiment:
[0120] 1. How to extract all signal information in the network configuration file into an EXCEL table;
[0121] 2. How to use EXCEL for version management and locking;
[0122] 3. How to efficiently check the signal input and output flows of each module in the application layer;
[0123] 4. How to effectively manage different versions of signal interfaces between different projects;
[0124] 5. How to standardize or automatically generate the development and test scripts required for each module;
[0125] 6. How to automatically generate signal flow graphs between modules.
[0126] The solution to the first problem is to analyze the standardized format of ARXML / DBC, write code in Python to extract signal information from ARXML / DBC, write it into the database through the database API interface, process it in the database, and extract it into an EXCEL table.
[0127] The solution to the second problem is to use a database to manage and lock signal versions.
[0128] The solution to the third problem is: when each application layer module enters information, if there is information required by the specified rule form, then add restriction items and example descriptions on the database side, and when the information is entered, determine whether the rule form of the information meets the rule form requirements;
[0129] If it involves interaction between modules, the signal information of the module input and output can be identified by Python script through the API interface inside the database, and the signal information at both ends can be compared for consistency. If inconsistent, it will be displayed on the database interaction interface in a timely manner.
[0130] The solution to the fourth problem is to use a database to store information and store data for different projects separately.
[0131] The solution to the fifth problem is: when targeting network signals, integrate the network signals and the corresponding module input and output signals in the database.
[0132] Input interface test, assign values to the controller through the capl script in CANoe, obtain the value of the signal received by the corresponding module on the CANape side, compare it with the expected value, and generate a test report.
[0133] Output interface test, by assigning values to the output signals of the internal modules of the controller, obtaining the signal values sent by CAN on the CANoe side, and comparing them with the expected values to generate a test report.
[0134] In the link of the above interface test, since the signal volume is large but the assignment rules are regular, Python can be associated with the database through the database API interface to directly generate the script required for the test.
[0135] The solution to the sixth problem is to display the signal flow graph between modules in a graphical interface, based on the input and output flows of the modules in the database. In the input and output flows of the modules, the properties of the input and output ends are defined, and the input and output ends of the modules can be read through the API interface inside the database, and the editable graphical software can be linked to automatically generate the signal flow graph of each module in the entire controller.
[0136] The embodiments of the present application also provide corresponding devices and computer-readable storage media for implementing the solutions provided by the embodiments of the present application.
[0137] The device includes a memory and a processor, the memory is used to store instructions or codes, and the processor is used to execute the instructions or codes so that the device executes a database management method described in any embodiment of the present application.
[0138] In practical applications, the computer-readable storage medium can adopt any combination of one or more computer-readable media. The computer-readable medium can be a computer-readable signal medium or a computer-readable storage medium. The computer-readable storage medium can be, for example, but not limited to, a system, device or device of electricity, magnetism, light, electromagnetic, infrared, or semiconductor, or any combination of the above. More specific examples (non-exhaustive list) of computer-readable storage media include: an electrical connection with one or more wires, a portable computer disk, a hard disk, a random access memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disk read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the above. In the present embodiment, the computer-readable storage medium can be any tangible medium containing or storing a program, which can be used by an instruction execution system, device or device or used in combination with it.
[0139] Computer-readable signal media may include data signals propagated in baseband or as part of a carrier wave, which carry computer-readable program code. Such propagated data signals may take a variety of forms, including but not limited to electromagnetic signals, optical signals, or any suitable combination of the above. Computer-readable signal media may also be any computer-readable medium other than a computer-readable storage medium, which may send, propagate, or transmit a program for use by or in conjunction with an instruction execution system, apparatus, or device.
[0140] The program code embodied on the computer readable medium may be transmitted using any appropriate medium, including but not limited to wireless, wireline, optical fiber cable, RF, etc., or any suitable combination of the foregoing.
[0141] Computer program code for performing the operations of the present invention may be written in one or more programming languages or a combination thereof, including object-oriented programming languages such as Java, Smalltalk, C++, and conventional procedural programming languages such as "C" or similar programming languages. The program code may be executed entirely on the user's computer, partially on the user's computer, as a separate software package, partially on the user's computer and partially on a remote computer, or entirely on a remote computer or server. In the case of a remote computer, the remote computer may be connected to the user's computer through any type of network, including a local area network (LAN) or a wide area network (WAN), or may be connected to an external computer (e.g., via the Internet using an Internet service provider).
[0142] It should also be noted that, in this article, relational terms such as first and second, etc. are only used to distinguish one entity or operation from another entity or operation, and do not necessarily require or imply any such actual relationship or order between these entities or operations. Moreover, the terms "include", "comprise" or any other variants thereof are intended to cover non-exclusive inclusion, so that a process, method, article or device including a series of elements includes not only those elements, but also other elements not explicitly listed, or also includes elements inherent to such process, method, article or device. In the absence of further restrictions, the elements defined by the sentence "comprise a ..." do not exclude the presence of other identical elements in the process, method, article or device including the elements.
[0143] The above is only a specific implementation of the present application, but the protection scope of the present application is not limited thereto. Any changes or substitutions that can be easily thought of by a person skilled in the art within the technical scope disclosed in the present application should be included in the protection scope of the present application. Therefore, the protection scope of the present application should be based on the protection scope of the claims.
Claims
1. A database management system, characterized in that: The database management system includes: a user management module, a file extraction module, an information management and locking module, a check module, a script generation module and a flow chart generation module: The user management module is used to manage the rights of users of the system; The file extraction module is used to extract information from the network configuration file into the target file during the development of the project; The checking module is used to check whether the rule form of the modified version meets the requirements when the version of the project is modified; The information management and locking module is used to manage the entry of the target file. When the requirements of the project change and a new version is generated, the new version is reviewed and locked, and the change items are recorded; The script generation module is used to automatically generate the test script of the project according to the development requirements of the project; The flow graph generation module is used to generate a signal flow graph between modules in the project.
2. The system according to claim 1, characterized in that The script generation module is specifically used for: Obtain network signals and input and output signals of each module; Performing an input interface test based on the input signal; Performing an output interface test based on the output signal; According to the assignment rules in the input interface test and the output interface test, the python script is associated with the database through the API interface of the database, and a test script is generated.
3. The system according to claim 1, characterized in that The flow graph generation module is specifically used for: Define the input terminals and input terminal properties of each module; Based on the API interface of the database, read the input and output terminals of each module; A signal flow graph between the modules is generated by using a mapping module according to the input terminals of the modules and the data flow of the input terminals.
4. The system according to claim 2, characterized in that The user management module is specifically used for: Setting the authority of the system architecture personnel to use the file extraction module, the information management and locking module, the script generation module and the flow chart generation module; Setting the module developer's authority to modify the database content of the project and receiving the generated test script and signal flow graph; Set the viewer's permissions to view the contents of the locked version of the project.
5. The system according to claim 4, characterized in that The permission of the developer of the setting module is to modify the database content of the project. The user management module specifically includes: If the system architect opens the modification rights of the module developer, the module developer’s rights at this time are to modify and import the database. If there are format errors after importing, the module developer needs to rework and modify the database. If the system architect closes the modification authority of the module developer, the authority of the module developer is changed to viewing the current version of the project database and the module database of historical changes.
6. The system according to claim 1, characterized in that The inspection module is specifically used for: When each application layer module enters information, if there is information required by the specified rule form, then a restriction item and an example description are added to the database side. When the information is entered, it is determined whether the rule form of the information meets the rule form requirements; If it involves interaction between modules, the signal information of the module input and output is identified through the API interface using a python script, and the signal information of the input and output are compared to see if they are consistent. If they are inconsistent, they are displayed on the database interaction interface.
7. The system according to claim 1, characterized in that The file extraction module specifically includes: Analyze the standardized format of ARXML / DBC and complete the signal information extraction of ARXML / DBC; The extracted signal information is written into a database through an API interface of the database and processed, and the processed signal information or module information of an existing database is extracted into a target table.
8. A database management method, characterized in that: The method is applied to a database management system, the system comprising: a user management module, a file extraction module, an information management and locking module, a check module, a script generation module and a flow chart generation module; the method comprises: Using the user management module to manage the rights of users of the system; Utilizing the file extraction module to extract information from a network configuration file into a target file during the development of a project; When the version of the project is modified, the checking module is used to check whether the rule form of the modified version meets the requirements; The target file is entered and managed using the information management and locking module. When the requirements of the project change and a new version is generated, the new version is reviewed and locked, and the change items are recorded; Utilizing the script generation module to automatically generate a test script for the project according to the development requirements of the project; The flow graph generation module is used to generate a signal flow graph between modules in the project.
9. The method according to claim 8, characterized in that The automatic generation of the test script of the project includes: Obtain network signals and input and output signals of each module; Performing an input interface test based on the input signal; Performing an output interface test based on the output signal; According to the assignment rules in the input interface test and the output interface test, the python script is associated with the database through the API interface of the database, and a test script is generated.
10. The method according to claim 8, characterized in that The generating of the signal flow graph between the modules involved in the project includes: Define the input terminals and input terminal properties of each module; Based on the API interface of the database, read the input and output terminals of each module; A signal flow graph between the modules is generated by using a mapping module according to the input terminals of the modules and the data flow of the input terminals.