CN116991859A - Engineering machinery test data processing method and system - Google Patents

Engineering machinery test data processing method and system Download PDF

Info

Publication number
CN116991859A
CN116991859A CN202310994522.7A CN202310994522A CN116991859A CN 116991859 A CN116991859 A CN 116991859A CN 202310994522 A CN202310994522 A CN 202310994522A CN 116991859 A CN116991859 A CN 116991859A
Authority
CN
China
Prior art keywords
data
test
result
test data
record table
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Pending
Application number
CN202310994522.7A
Other languages
Chinese (zh)
Inventor
张文远
王飞
张孝天
胡一明
周波
王世阳
冯涛
王彦飞
居世昊
李闯
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Xuzhou XCMG Excavator Machinery Co Ltd
Original Assignee
Xuzhou XCMG Excavator Machinery Co Ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Xuzhou XCMG Excavator Machinery Co Ltd filed Critical Xuzhou XCMG Excavator Machinery Co Ltd
Priority to CN202310994522.7A priority Critical patent/CN116991859A/en
Publication of CN116991859A publication Critical patent/CN116991859A/en
Pending legal-status Critical Current

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/23Updating
    • G06F16/2365Ensuring data consistency and integrity
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/22Indexing; Data structures therefor; Storage structures
    • G06F16/2228Indexing structures
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/25Integrating or interfacing systems involving database management systems
    • YGENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y02TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
    • Y02PCLIMATE CHANGE MITIGATION TECHNOLOGIES IN THE PRODUCTION OR PROCESSING OF GOODS
    • Y02P90/00Enabling technologies with a potential contribution to greenhouse gas [GHG] emissions mitigation
    • Y02P90/30Computing systems specially adapted for manufacturing

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Databases & Information Systems (AREA)
  • Data Mining & Analysis (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Computer Security & Cryptography (AREA)
  • Software Systems (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

The application discloses a processing method and a processing system of engineering machinery test data, wherein the method comprises the following steps: checking the uploaded test data format; if the test data format meets the requirement, checking whether the test data is successfully uploaded; if the test data is successfully uploaded, checking whether the test data is correctly named; if the test data are named correctly, determining working condition and mode gear information in the naming of the index data of the data working condition in the original record table according to the naming of the test data; analyzing the test data to obtain result data, and filling the result data into corresponding cells according to the cell attributes in the original record table; filling data in an original record table into a result record table and calculating; and judging whether the test result is qualified or not according to the data calculated in the result record table. And (3) associating multiple groups of test data of the same test item under different working conditions and different working modes with the same data algorithm, analyzing the test result by one key to generate a test result, judging the test result, and generating a conclusion.

Description

Engineering machinery test data processing method and system
Technical Field
The application belongs to the technical field of engineering machinery testing, and particularly relates to a processing method and a processing system of engineering machinery testing data.
Background
At present, test data of engineering machinery (such as an excavator) are processed by using data processing software by engineers and then filled into a result record table, but under the conditions of a large number of engineering machinery test requirements, multiple working conditions and multiple operation modes, high-efficiency processing and application of the test data are difficult to realize, the management of output files of test results is also very disordered, and meanwhile, the method of retention of related files and data processing is also difficult to trace back along with personnel flow.
At present, in the field of engineering machinery, after a tester collects test data, software matched with hardware of a data collection system is required to be opened for analysis. And manually record the data into a data record table, the data acquired by different acquisition systems are required to be analyzed and processed by different software, and the manual analysis is low in efficiency and easy to make mistakes. The engineering machinery test data comprise multiple disciplines such as acoustics, electricity, machinery, power and the like, and a test engineer of related professions is required to analyze and process the data to generate a test conclusion.
The prior art has the following defects: (1) At present, the test data of engineering machinery is processed, and the data acquired by different acquisition systems need different software for analysis and processing, so that a unified analysis and processing platform is not available. (2) At present, the test data of the engineering machinery is processed manually by engineers, and repeated work is more likely to cause low work efficiency and easy error. (3) The existing engineering machinery test processing method aims at simple and standardized data analysis work, and a test engineer with related professions is required to conduct analysis processing, so that more manpower resources are consumed. (4) The current engineering machinery test processing method does not consider the standardization of test analysis.
Therefore, a set of processing method of engineering machinery test data is urgently needed to realize efficient and reliable test data processing and application.
Disclosure of Invention
The purpose is as follows: in view of at least one of the above technical problems, the present application provides a method and a system for processing test data of an engineering machine.
In a first aspect, the present application provides a method for processing test data of an engineering machine, including:
checking the uploaded test data format; if the test data format meets the requirement, checking whether the test data is successfully uploaded;
if the test data is successfully uploaded, checking whether the test data is correctly named;
if the test data are named correctly, determining working condition and mode gear information in the naming of the index data of the data working condition in the original record table according to the naming of the test data;
analyzing the test data to obtain result data, and filling the result data into corresponding cells according to the cell attributes in the original record table;
filling data in an original record table into a result record table and calculating;
and judging whether the test result is qualified or not according to the data calculated in the result record table.
In a second aspect, the present application further provides a system for processing engineering machinery test data, including:
the test data uploading checking module is configured to: checking the uploaded test data format; if the test data format meets the requirement, checking whether the test data is successfully uploaded;
a trial data file naming module configured to: if the test data is successfully uploaded, checking whether the test data is correctly named;
the working condition and mode gear information determining module is configured to: if the test data are named correctly, determining working condition and mode gear information in the naming of the index data of the data working condition in the original record table according to the naming of the test data;
a result data filling module configured to: analyzing the test data to obtain result data, and filling the result data into corresponding cells according to the cell attributes in the original record table;
a data calculation module configured to: filling data in an original record table into a result record table and calculating;
a result determination module configured to: and judging whether the test result is qualified or not according to the data calculated in the result record table.
In a third aspect, the application provides an apparatus comprising,
a memory;
a processor;
and
a computer program;
wherein the computer program is stored in the memory and configured to be executed by the processor to implement the method of the first aspect described above.
In a fourth aspect, the present application provides a storage medium having stored thereon a computer program which, when executed by a processor, implements the method of the first aspect.
The beneficial effects are that: the processing method and the processing system for the engineering machinery test data provided by the application have the following advantages: the working condition information and the working mode information of the engineering machinery are standardized, collected data are automatically checked for data format and name, and the unit cells of the original recording table and the result recording table are set, so that the system automatically fills the analyzed data result into the test original recording table and the result recording table according to the data name. By means of the method for setting cell attributes in the table, multiple groups of test data of the same test item under different working conditions and different working modes are associated with the same data algorithm, one-key analysis is conducted to generate test results, the test results are judged, and a conclusion is generated.
Drawings
FIG. 1 is a flow chart of a method for processing test data of an engineering machine according to an embodiment;
FIG. 2 is a schematic diagram of an original record table according to an embodiment;
fig. 3 is a schematic configuration diagram of a result record table of an embodiment.
Detailed Description
The following description of the embodiments of the present application will be made clearly and completely with reference to the accompanying drawings, in which it is apparent that the embodiments described are only some embodiments of the present application, but not all embodiments. The following description of at least one exemplary embodiment is merely exemplary in nature and is in no way intended to limit the application, its application, or uses. All other embodiments, which can be made by those skilled in the art based on the embodiments of the application without making any inventive effort, are intended to be within the scope of the application.
The relative arrangement of the components and steps, numerical expressions and numerical values set forth in these embodiments do not limit the scope of the present application unless it is specifically stated otherwise. Meanwhile, it should be understood that the sizes of the respective parts shown in the drawings are not drawn in actual scale for convenience of description. Techniques, methods, and apparatus known to one of ordinary skill in the relevant art may not be discussed in detail, but should be considered part of the specification where appropriate. In all examples shown and discussed herein, any specific values should be construed as merely illustrative, and not a limitation. Thus, other examples of the exemplary embodiments may have different values. It should be noted that: like reference numerals and letters denote like items in the following figures, and thus once an item is defined in one figure, no further discussion thereof is necessary in subsequent figures.
Example 1
As shown in fig. 1, the method for processing test data of a construction machine includes:
checking the uploaded test data format; if the test data format meets the requirement, checking whether the test data is successfully uploaded;
if the test data is successfully uploaded, checking whether the test data is correctly named;
if the test data are named correctly, determining working condition and mode gear information in the naming of the index data of the data working condition in the original record table according to the naming of the test data;
analyzing the test data to obtain result data, and filling the result data into corresponding cells according to the cell attributes in the original record table;
filling data in an original record table into a result record table and calculating;
and judging whether the test result is qualified or not according to the data calculated in the result record table.
In some embodiments, verifying the uploaded test data format includes: satisfactory test data formats include. Dat,. Gbd,. Fpd,. Mat,. Uff.
In some embodiments, verifying that the test data naming is correct includes: proper test data naming includes: engineering machinery design model, engineering machinery number, mode gear, engine speed, test working condition, test project, test date, tester name and connection sequence;
in some embodiments, the correct test data naming convention is: engineering machine design model number-engineering machine number-mode gear-engine speed-test condition-test project-test date (tester name).
For example: XE380DK-19927# -P1-1800 r-actual excavation-thermal balance-20220315 (test person name).
In some embodiments, the configuration of the original record table includes an original data table setup area and an original data attribute selection area; each cell to be filled in the original data table setting area is assigned with an address, the attribute of each cell is preconfigured through the original data attribute selection area, and the attribute of each cell is working condition data or result data after data analysis.
Analyzing the test data to obtain result data, and filling the result data into corresponding cells according to the cell attributes in the original record table, wherein the method comprises the following steps:
the working condition and mode gear information is automatically acquired from the corresponding cells according to the attributes of the cells, and the result data under different working conditions and modes obtained through analysis is automatically filled into the corresponding working condition and mode gear information.
In some embodiments, the configuration of the result record table includes a result data table setting area and a result data attribute selection area, and the data sources of the cells of the result data table setting area are "original records" or "operation formulas";
when the data source of the cell is 'original record', pre-assigning an address of the cell corresponding to an original record table; when the data source of the cell is an operation formula, the operation formula is pre-edited according to the calculation requirement.
Filling data in an original record table into a result record table and calculating, wherein the method comprises the following steps:
based on the preset data source in the cells of the result data table setting area as the cell address corresponding to the original record and the pre-added original record table, associating the cell data of the address in the original record table into the result record table;
the preset data source in the cells of the setting area of the result data table is an operation formula, and the cell data is calculated according to the operation formula which is pre-edited.
In some embodiments, determining whether the test result is acceptable based on the data calculated in the result record table includes:
presetting test result comparison rules and target values of different test items;
and comparing the data calculated in the result record table with the target value of the test item according to the test result comparison rule of the test item, and judging whether the test result is qualified or not according to the comparison result.
Example 2
A system for processing engineering machine test data, comprising:
the test data uploading checking module is configured to: checking the uploaded test data format; if the test data format meets the requirement, checking whether the test data is successfully uploaded;
a trial data file naming module configured to: if the test data is successfully uploaded, checking whether the test data is correctly named;
the working condition and mode gear information determining module is configured to: if the test data are named correctly, determining working condition and mode gear information in the naming of the index data of the data working condition in the original record table according to the naming of the test data;
a result data filling module configured to: analyzing the test data to obtain result data, and filling the result data into corresponding cells according to the cell attributes in the original record table;
a data calculation module configured to: filling data in an original record table into a result record table and calculating;
a result determination module configured to: and judging whether the test result is qualified or not according to the data calculated in the result record table.
The test data uploading checking module is used for analyzing whether the test data format meets the requirement and whether the test data uploading is successful;
the test data file naming verification module is used for maintaining file naming verification rules and analyzing uploaded test data name information;
in some embodiments, a system for processing engineering machine test data further comprises: the test project management module, the test working condition module, the test algorithm management module and the test algorithm configuration module;
the test item management module is used for adding or deleting test items and maintaining an original record table and a result record table in an Excle format corresponding to the test items;
the test working condition module is used for maintaining test working conditions;
the test algorithm management module is used for maintaining a test algorithm;
the test algorithm configuration module is used for configuring the data analysis rules and algorithms into the original record table and the result record table.
The data analysis rule and algorithm are configured into an original record table, the configuration of the original record table is shown in fig. 2, 1 is an original data table setting area, 2 is a data attribute selecting area, each cell to be filled in the table area is assigned with an address, after clicking the cell, the attribute of each cell can be configured to be working condition data or result data after data analysis, when the data is analyzed, working condition and mode gear information can be automatically acquired into the corresponding cell according to the set attribute of the cell, and the result data under different working conditions and modes analyzed by one key of the algorithm can be automatically filled into the corresponding working condition and mode.
The configuration of the result record table is shown in fig. 3, wherein 3 is a result data table setting area, 4 is a data attribute selecting area, the cell data of the address in the original record table can be correlated to the result record table by setting the data source as 'original record' in the cells of the 3 area and adding the cell address corresponding to the original record table, the cell data of the address in the original record table is set as an operation formula in the cells of the 3 area, and the operation formula can be edited to calculate the cell data; finally, configuring a check rule for judging whether the result data is qualified or not in an algorithm configuration unit;
after the standardized data is maintained, uploading the data according to a specified naming specification, and clicking analysis data to finish one-key processing and application of the test data.
The system has the following advantages: (1) By classifying and grading the test items and different working conditions in the test items, a test data processing method for the test working conditions and working modes of a test prototype is realized, a tester only needs to maintain a test data algorithm in a system at one time, a test data naming rule and test data working condition information can generate result data for collected data by one key, and the accurate and efficient application of the data is realized; (2) The test data processing method is summarized aiming at test items which can be standardized by a test algorithm, so that repeated labor of different professional engineers is reduced, and the work coordination efficiency is improved.
Example 3
In a third aspect, based on embodiment 1, the present embodiment provides an apparatus, comprising,
a memory;
a processor;
and
a computer program;
wherein the computer program is stored in the memory and configured to be executed by the processor to implement the method of embodiment 1.
Example 4
In a fourth aspect, based on embodiment 1, the present embodiment provides a storage medium having stored thereon a computer program which, when executed by a processor, implements the method described in embodiment 1.
It will be appreciated by those skilled in the art that embodiments of the present application may be provided as a method, system, or computer program product. Accordingly, the present application may take the form of an entirely hardware embodiment, an entirely software embodiment or an embodiment combining software and hardware aspects. Furthermore, the present application may take the form of a computer program product embodied on one or more computer-usable storage media (including, but not limited to, disk storage, CD-ROM, optical storage, and the like) having computer-usable program code embodied therein.
The present application is described with reference to flowchart illustrations and/or block diagrams of methods, apparatus (systems) and computer program products according to embodiments of the application. It will be understood that each flow and/or block of the flowchart illustrations and/or block diagrams, and combinations of flows and/or blocks in the flowchart illustrations and/or block diagrams, can be implemented by computer program instructions. These computer program instructions may be provided to a processor of a general purpose computer, special purpose computer, embedded processor, or other programmable data processing apparatus to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing apparatus, create means for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be stored in a computer-readable memory that can direct a computer or other programmable data processing apparatus to function in a particular manner, such that the instructions stored in the computer-readable memory produce an article of manufacture including instruction means which implement the function specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be loaded onto a computer or other programmable data processing apparatus to cause a series of operational steps to be performed on the computer or other programmable apparatus to produce a computer implemented process such that the instructions which execute on the computer or other programmable apparatus provide steps for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
The foregoing is only a preferred embodiment of the application, it being noted that: it will be apparent to those skilled in the art that various modifications and adaptations can be made without departing from the principles of the present application, and such modifications and adaptations are intended to be comprehended within the scope of the application.

Claims (11)

1. The processing method of engineering machinery test data is characterized by comprising the following steps:
checking the uploaded test data format; if the test data format meets the requirement, checking whether the test data is successfully uploaded;
if the test data is successfully uploaded, checking whether the test data is correctly named;
if the test data are named correctly, determining working condition and mode gear information in the naming of the index data of the data working condition in the original record table according to the naming of the test data;
analyzing the test data to obtain result data, and filling the result data into corresponding cells according to the cell attributes in the original record table;
filling data in an original record table into a result record table and calculating;
and judging whether the test result is qualified or not according to the data calculated in the result record table.
2. The method for processing test data of construction machine according to claim 1, wherein verifying the uploaded test data format comprises:
satisfactory test data formats include. Dat,. Gbd,. Fpd,. Mat,. Uff.
3. The method for processing test data of construction machine according to claim 1, wherein verifying whether the test data is named correctly comprises:
proper test data naming includes: the method comprises the steps of engineering machine design model, engineering machine number, mode gear, engine speed, test working condition, test project, test date, tester name and connection sequence.
4. The method according to claim 1, wherein the configuration of the original record table includes an original data table setting area and an original data attribute selection area; each cell to be filled in the original data table setting area is assigned with an address, the attribute of each cell is preconfigured through the original data attribute selection area, and the attribute of each cell is working condition data or result data after data analysis.
5. The method for processing test data of construction machine according to claim 4, wherein analyzing the test data to obtain result data, and filling the result data into corresponding cells according to cell attributes in the original record table, comprises:
the working condition and mode gear information is automatically acquired from the corresponding cells according to the attributes of the cells, and the result data under different working conditions and modes obtained through analysis is automatically filled into the corresponding working condition and mode gear information.
6. The method according to claim 1, wherein the configuration of the result record table includes a result data table setting area and a result data attribute selection area, and the data sources of the cells of the result data table setting area are "original records" or "operation formulas";
when the data source of the cell is 'original record', pre-assigning an address of the cell corresponding to an original record table; when the data source of the cell is an operation formula, the operation formula is pre-edited according to the calculation requirement.
7. The method for processing test data of construction machine according to claim 6, wherein the step of writing data in the original record table into the result record table and calculating includes:
based on the preset data source in the cells of the result data table setting area as the cell address corresponding to the original record and the pre-added original record table, associating the cell data of the address in the original record table into the result record table;
the preset data source in the cells of the setting area of the result data table is an operation formula, and the cell data is calculated according to the operation formula which is pre-edited.
8. The method for processing test data of construction machine according to claim 1, wherein determining whether the test result is acceptable or not based on the data calculated in the result record table, comprises:
presetting test result comparison rules and target values of different test items;
and comparing the data calculated in the result record table with the target value of the test item according to the test result comparison rule of the test item, and judging whether the test result is qualified or not according to the comparison result.
9. A system for processing test data of a construction machine, comprising:
the test data uploading checking module is configured to: checking the uploaded test data format; if the test data format meets the requirement, checking whether the test data is successfully uploaded;
a trial data file naming module configured to: if the test data is successfully uploaded, checking whether the test data is correctly named;
the working condition and mode gear information determining module is configured to: if the test data are named correctly, determining working condition and mode gear information in the naming of the index data of the data working condition in the original record table according to the naming of the test data;
a result data filling module configured to: analyzing the test data to obtain result data, and filling the result data into corresponding cells according to the cell attributes in the original record table;
a data calculation module configured to: filling data in an original record table into a result record table and calculating;
a result determination module configured to: and judging whether the test result is qualified or not according to the data calculated in the result record table.
10. A storage medium having stored thereon a computer program which, when executed by a processor, implements the method of any of claims 1 to 8.
11. An apparatus, comprising:
a memory;
a processor;
and
a computer program;
wherein the computer program is stored in the memory and configured to be executed by the processor to implement the method of any one of claims 1 to 8.
CN202310994522.7A 2023-08-09 2023-08-09 Engineering machinery test data processing method and system Pending CN116991859A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202310994522.7A CN116991859A (en) 2023-08-09 2023-08-09 Engineering machinery test data processing method and system

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202310994522.7A CN116991859A (en) 2023-08-09 2023-08-09 Engineering machinery test data processing method and system

Publications (1)

Publication Number Publication Date
CN116991859A true CN116991859A (en) 2023-11-03

Family

ID=88531816

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202310994522.7A Pending CN116991859A (en) 2023-08-09 2023-08-09 Engineering machinery test data processing method and system

Country Status (1)

Country Link
CN (1) CN116991859A (en)

Similar Documents

Publication Publication Date Title
JP6116139B2 (en) System and method for creating an intuitive context for analysis data
US11176028B2 (en) System, method and storage device for CIM/E model standard compliance test
CN109784758B (en) Engineering quality supervision early warning system and method based on BIM model
CN107844424A (en) Model-based testing system and method
CN113807747A (en) Enterprise budget management maturity evaluation system
CN112231786B (en) General evaluation method and system for evaluating effectiveness of simulation model
CN113190501A (en) Method for forming and filing electronic file for quality testing of water conservancy and hydropower engineering
CN110019067A (en) A kind of log analysis method and system
CN111190814B (en) Method and device for generating software test case, storage medium and terminal
CN112686773B (en) Electric power metering all-link key business anomaly positioning model construction method based on fusion business topology
CN114880176A (en) Aviation data conversion unit test system, method and device
TWM593625U (en) Green building engineering inspection management system
CN116991859A (en) Engineering machinery test data processing method and system
CN112255548B (en) Battery management system test method and system thereof
CN112632944A (en) Method, system, equipment and storage medium for generating inspection report
CN112232760A (en) Infrastructure management system and method
CN113609698A (en) Process reliability analysis method and system based on process fault database
CN114115843A (en) Low code production method of index data and visualized data processing system thereof
CN109685453B (en) Method for intelligently identifying effective paths of workflow
CN113791980A (en) Test case conversion analysis method, device, equipment and storage medium
CN116010349B (en) Metadata-based data checking method and device, electronic equipment and storage medium
CN106855841B (en) System memory analysis method and device
Stepien et al. Flexible Model Exchange in Modelling Smart Mobility by Using Domain Ontologies
CN113807100B (en) Protection device calculation model auditing method and device based on source end data
CN115357996A (en) Passenger car cabin CFD automatic simulation analysis method

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination