Data processing and retrieval method, computer and storage medium

Abstract

The invention provides a data processing and retrieval method, a computer and a storage medium, and belongs to the technical field of data processing and retrieve.The data processing and retrieval method is based on a visual simulation tool in the computer, a user imports a file through the visual simulation tool in the computer, whether data exist in the file or not is detected, and if yes, the data are retrieved. If no data exist, the work is ended; if the data exists, reading the data line by line, and judging whether the data line is empty or not; and generating a primary subsystem, importing data in the file, packaging the data and outputting the data. Generating a secondary subsystem, detecting the data type of the data output by the primary subsystem, converting the data which does not meet the requirement type into the data of the required type, analyzing the data, splitting the data into independent signals, and outputting the independent signals; and a user reads the signal through the reading function and lists the path of the signal, and retrieves the signal in a table look-up manner. According to the invention, the efficiency of automobile state data retrieval is improved.

Description

Technical Field

[0001] The present invention belongs to the technical field of data processing and retrieval, and in particular, relates to a data processing and retrieval method, a computer and a storage medium. Background Art

[0002] During vehicle development and testing, vehicle status analysis is essential. This is typically done by exporting vehicle status data for analysis and fault simulation. However, the sheer volume of vehicle status data can be time-consuming for R&D personnel to process and retrieve, hindering vehicle development and testing efficiency.

[0003] Chinese Patent 114494998B provides a method and system for intelligent vehicle data analysis, belonging to the field of public safety technology. The method includes: a camera device monitors controlled vehicles in real time, acquires controlled vehicle data, and transmits the controlled vehicle data to an edge computing device; the edge computing device analyzes and processes the controlled vehicle data, issues real-time warnings for key scenarios, and transmits the analysis results to a cloud-based big data analysis platform; the cloud-based big data analysis platform receives and stores the analysis data uploaded by the edge computing device, and performs data mining on historical analysis data to conduct retrospective analysis of controlled vehicle trajectories and analyze the trajectories of controlled vehicles in warning zones.

[0004] Existing technologies fail to improve the efficiency of retrieving vehicle status data, which reduces the efficiency of vehicle development and testing. Summary of the Invention

[0005] The present invention aims to provide a data processing and retrieval method, a computer and a storage medium to achieve the technical purpose of improving the efficiency of automobile status data retrieval and improving the efficiency of automobile development and testing.

[0006] In order to achieve the above object, the technical solution adopted by the present invention is:

[0007] The present invention provides a data processing and retrieval method based on a visual simulation tool in a computer:

[0008] Step 1: The user imports the file through the visual simulation tool on the computer;

[0009] Step 2: Check whether there is data in the file. If there is no data, the work ends; if there is data, read the data line by line and determine whether the data in the line is empty;

[0010] Step 3: Generate a first-level subsystem, import the read data, package the data and output the data;

[0011] Step 4: Generate a secondary subsystem, detect the data type of the output data of the primary subsystem, and convert the data that does not meet the required type into the required type;

[0012] Step 5: The secondary subsystem parses the data that meets the required type, splits it into independent signals and outputs them;

[0013] Step 6: The user reads the signal through the read function and lists the path where the signal is located, and retrieves the signal through a table lookup.

[0014] The computer stores path variables of the first-level subsystem and the second-level subsystem.

[0015] In step 1, the user imports the file into the visual simulation tool through the given path of the file.

[0016] In step three, the first-level subsystem packages the input data through the Bus Creator packaging module.

[0017] In step 4, the visual simulation tool converts data that does not meet the required type through the Data Type Conversion module.

[0018] In step five, the secondary subsystem parses the data through the CAN Unpack parsing module.

[0019] In step five, the secondary subsystem adds signal names to the output independent signals and confirms whether the signal names match the signal objects in the visual simulation tool.

[0020] The user retrieves the output signal to obtain the path where the signal is located and determines the primary subsystem and secondary subsystem where the signal is located.

[0021] The present invention provides a computer, comprising a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein the steps of the method are implemented when the processor executes the computer program.

[0022] The present invention provides a storage medium storing a computer program, wherein the computer program implements the steps of the method when executed by a processor.

[0023] The technical effects of the present invention are:

[0024] (1) The present invention does not require manual screening of invalid data in DBC files, and automatically reads the required data, thereby avoiding manual file processing by R&D personnel, reducing repetitive work, and shortening data preprocessing time.

[0025] (2) The present invention automatically establishes models, from file import, subsystem generation (primary / secondary subsystem) to data packaging, data type conversion, and signal analysis, all of which are completed automatically. There is no need to manually build models or configure modules, which significantly reduces manual operation costs. It is especially suitable for high-frequency, multi-file batch processing scenarios.

[0026] (3) This invention structures data processing to ensure data accuracy. The primary subsystem integrates scattered signals into bus data through the Bus Creator packaging module, avoiding cross-confusion when inputting multi-source data and ensuring the logic and orderliness of data during transmission and processing. It is particularly suitable for the centralized management of complex signals on the vehicle CAN bus.

[0027] (4) The present invention unifies data types and converts data that does not meet the required types through the Data Type Conversion module, thereby solving the problem of conflicts between heterogeneous data types, ensuring the compatibility of subsequent parsing and calculation, avoiding processing errors caused by type mismatch, and improving the reliability of data analysis results.

[0028] (5) The present invention packages and parses data through a hierarchical architecture design to form a clear hierarchical processing logic, which meets the modular development requirements of the vehicle system and facilitates team collaborative development.

[0029] (6) The present invention can quickly locate the target signal and locate the specific system and signal based on the signal's path index, without the need to search line by line in massive data, thus reducing the time for data search.

[0030] (7) The present invention shortens the automobile development cycle, reduces manual intervention through automated and structured processing, and improves the efficiency of DBC file analysis.

[0031] (8) The present invention reduces R&D costs, reduces hidden costs such as manual error detection and repeated modeling, adapts to the needs of rapid iterative development of vehicle-mounted electronics, and has practical engineering value in improving the efficiency of vehicle R&D. BRIEF DESCRIPTION OF THE DRAWINGS

[0032] This manual includes the following drawings, which show the following contents:

[0033] Figure 1 The present invention provides a flow chart of a data processing and retrieval method, a computer and a storage medium. DETAILED DESCRIPTION

[0034] The following is a further detailed description of the specific implementation methods of the present invention through the description of the embodiments with reference to the accompanying drawings, with the aim of helping those skilled in the art to have a more complete, accurate and in-depth understanding of the inventive concept and technical solution of the present invention and to facilitate their implementation.

[0035] The present invention provides a data processing and retrieval method based on a visual simulation tool in a computer:

[0036] The present invention provides a data processing and retrieval method based on a visual simulation tool in a computer:

[0037] S1: The user imports the file through the visual simulation tool on the computer;

[0038] S2: Check whether there is data in the file. If there is no data, the work ends; if there is data, read the data line by line and determine whether the data in the line is empty;

[0039] S3: Generates a first-level subsystem, imports the read data, packages the data, and outputs the data;

[0040] S4: Generate a secondary subsystem to detect the data type of the output data of the primary subsystem and convert the data that does not meet the required type into the required type;

[0041] S5: The secondary subsystem parses the data that meets the required types, splits it into independent signals and outputs them;

[0042] S6: The user reads the signal through the read function and lists the path where the signal is located, and retrieves the signal through a table lookup.

[0043] The computer stores path variables of the first-level subsystem and the second-level subsystem.

[0044] In S1, the user imports the file into the visual simulation tool through the given path of the file.

[0045] In S3, the first-level subsystem packages the input data through the Bus Creator packaging module.

[0046] In S4, the visual simulation tool converts data that does not meet the required type through the Data Type Conversion module.

[0047] In S5, the secondary subsystem parses the data through the CAN Unpack parsing module.

[0048] In S5, the secondary subsystem adds signal names to the output independent signals and confirms whether the signal names match the signal objects in the visual simulation tool.

[0049] The user retrieves the output signal to obtain the path where the signal is located and determines the primary subsystem and secondary subsystem where the signal is located.

[0050] The present invention provides a computer comprising a memory, a processor and a computer program stored in the memory and operable on the processor, wherein the steps of the method are implemented when the processor executes the computer program.

[0051] The present invention provides a storage medium storing a computer program, which implements the steps of the method when executed by a processor.

[0052] A data processing and retrieval method of the present invention is described in detail below.

[0053] The user imports the file through the visual simulation tool (Simulink) in the computer. Specifically, the visual simulation tool imports the file through a given path, which is a DBC file in the present invention. The main purpose of this step is to automatically obtain the required data and provide data support for subsequent data processing. The DBC file is used to describe the communication protocol of the automobile controller area network (CAN bus), including information such as signals, messages, nodes, frame formats in the bus, and is an important file for the development and testing of vehicle electronic systems. In the development of the car, R&D personnel need to analyze the data in the DBC file exported from the car. The process of finding the required data in a large amount of data is tedious and time-consuming, which will affect the development and testing cycle of the car and increase the cost of R&D.

[0054] The visual simulation tool detects whether there is data in the file, and if there is no data, the work ends. If there is data, the data is read line by line, and when each line of data is read, it is determined whether the line of data is empty. The present invention reads and filters the data in the DBC file for subsequent use.

[0055] The visual simulation tool generates a first-level subsystem, imports the data from the file, packages the data, and outputs it. Specifically, the first-level subsystem uses the Bus Creator packaging module to combine multiple input data into a single data stream. For example, the first-level subsystem uses the Bus Creator packaging module to combine the collected signals from three independent temperature sensors in the car into a single bus signal. When the first-level subsystem receives a large amount of data input, the Bus Creator packaging module can prevent data crosstalk.

[0056] The visual simulation tool generates a secondary subsystem and detects the data type of the data input to the primary subsystem. Data that does not meet the data type requirements is converted via the Data Type Conversion module. In an embodiment of the present invention, if the input data type is Boolean or enumerated, or does not meet the double type requirements, the Data Type Conversion module converts the non-compliant data to double type data. By adjusting the data type, the present invention ensures data type uniformity and improves the accuracy of data processing results.

[0057] The CAN Unpack parsing module in the secondary subsystem receives the data input by the Data Type Conversion data conversion module and parses the data, splitting it into independent signal outputs. The secondary subsystem adds a signal name to the output independent signal and confirms whether the signal name matches the signal object in the visual simulation tool. Specifically, the secondary subsystem checks whether the "Signal name must resolve to Simulink signalobject" option in the visual simulation tool is checked. The present invention ensures that the signal output correctly matches the signal object and avoids errors in the signal transmission process.

[0058] It should be noted that the computer stores path variables for the first-level and second-level subsystems. In the present invention, the visual simulation tool automatically generates and stores the first-level subsystem path variable (subSysString_1) and the second-level subsystem path variable (subSysString_2). These path variables are used to specify the locations of the first-level and second-level subsystems within the visual simulation tool, ensuring a clear and scalable model structure.

[0059] After data processing is complete, users can use the Read function to read the output signal and list the signal's path. This operation helps quickly locate the primary and secondary subsystems where the required data resides, obtain relevant data within them, and verify the signal's existence.

[0060] The beneficial effects of the present invention are described in detail below.

[0061] The present invention does not require manual screening of invalid data in DBC files, automatically reads required data, avoids manual file processing by R&D personnel, reduces repetitive work, and shortens data preprocessing time.

[0062] The present invention automatically establishes models, and completes everything from file import, subsystem generation (primary / secondary subsystems) to data packaging, data type conversion, and signal analysis. There is no need to manually build models or configure modules, which significantly reduces manual operation costs. It is especially suitable for high-frequency, multi-file batch processing scenarios.

[0063] This invention structures data processing to ensure data accuracy. The first-level subsystem integrates scattered signals into bus data through the Bus Creator packaging module, avoiding cross-source data input confusion and ensuring the logic and order of data during transmission and processing. It is particularly suitable for the centralized management of complex signals on the vehicle CAN bus.

[0064] The present invention unifies data types and converts data that does not meet the required types through the Data Type Conversion module, thereby resolving the conflict problem of heterogeneous data types, ensuring the compatibility of subsequent parsing and calculation, avoiding processing errors caused by type mismatch, and improving the reliability of data analysis results.

[0065] The present invention packages and parses data through a hierarchical architecture design to form a clear hierarchical processing logic, which meets the modular development requirements of the vehicle system and facilitates team collaborative development.

[0066] The present invention can quickly locate the target signal and locate the specific system and signal according to the signal's path index, without the need to search line by line in massive data, thus reducing the time for data search.

[0067] The present invention shortens the automobile development cycle, reduces manual intervention links through automated and structured processing, and improves the analysis efficiency of DBC files.

[0068] This invention reduces R&D costs, reduces hidden costs such as manual error troubleshooting and repeated modeling, adapts to the needs of rapid iterative development of vehicle-mounted electronics, and has practical engineering value in improving the efficiency of vehicle R&D.

[0069] The present invention has been described above with reference to the accompanying drawings. Obviously, the specific implementation of the present invention is not limited to the above-described method. Any non-substantial improvements made using the method concepts and technical solutions of the present invention, or any direct application of the above-described concepts and technical solutions to other situations without modification, fall within the scope of protection of the present invention.

Claims

1. A data processing and retrieval method based on a visual simulation tool in a computer, characterized in that: Step 1: The user imports the file through the visual simulation tool on the computer; Step 2: Check whether there is data in the file. If there is no data, the work ends; if there is data, read the data line by line and determine whether the data in the line is empty; Step 3: Generate a first-level subsystem, import the read data, package the data and output the data; Step 4: Generate a secondary subsystem, detect the data type of the output data of the primary subsystem, and convert the data that does not meet the required type into the required type; Step 5: The secondary subsystem parses the data that meets the required type, splits it into independent signals and outputs them; Step 6: The user reads the signal through the read function and lists the path where the signal is located, and retrieves the signal through a table lookup.

2. A data processing and retrieval method according to claim 1, characterized in that: The computer stores path variables of the first-level subsystem and the second-level subsystem.

3. A data processing and retrieval method according to claim 1, characterized in that: In step 1, the user imports the file into the visual simulation tool through the given path of the file.

4. A data processing and retrieval method according to claim 1, characterized in that: In step three, the first-level subsystem packages the input data through the Bus Creator packaging module.

5. A data processing and retrieval method according to claim 1, characterized in that: In step 4, the visual simulation tool converts data that does not meet the required type through the Data Type Conversion module.

6. A data processing and retrieval method according to claim 1, characterized in that: In step five, the secondary subsystem parses the data through the CAN Unpack parsing module.

7. A data processing and retrieval method according to claim 1, characterized in that: In step five, the secondary subsystem adds signal names to the output independent signals and confirms whether the signal names match the signal objects in the visual simulation tool.

8. A data processing and retrieval method according to claim 1 or 7, characterized in that: The user retrieves the output signal to obtain the path where the signal is located and determines the primary subsystem and secondary subsystem where the signal is located.

9. A computer comprising a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein: When the processor executes the computer program, the steps of the method according to any one of claims 1 to 8 are implemented.

10. A storage medium storing a computer program, characterized in that: When the computer program is executed by a processor, the steps of the method according to any one of claims 1 to 8 are implemented.

Images