CN117056335A - Data storage method and device, equipment and storage medium - Google Patents

Data storage method and device, equipment and storage medium Download PDF

Info

Publication number
CN117056335A
CN117056335A CN202310737734.7A CN202310737734A CN117056335A CN 117056335 A CN117056335 A CN 117056335A CN 202310737734 A CN202310737734 A CN 202310737734A CN 117056335 A CN117056335 A CN 117056335A
Authority
CN
China
Prior art keywords
detection
detection information
type
point
display
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
CN202310737734.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.)
Avatr Technology Chongqing Co Ltd
Original Assignee
Avatr Technology Chongqing 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 Avatr Technology Chongqing Co Ltd filed Critical Avatr Technology Chongqing Co Ltd
Priority to CN202310737734.7A priority Critical patent/CN117056335A/en
Publication of CN117056335A publication Critical patent/CN117056335A/en
Pending legal-status Critical Current

Links

Classifications

    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/22—Indexing; Data structures therefor; Storage structures
    • G06F16/2282—Tablespace storage structures; Management thereof
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F3/00—Input arrangements for transferring data to be processed into a form capable of being handled by the computer; Output arrangements for transferring data from processing unit to output unit, e.g. interface arrangements
    • G06F3/01—Input arrangements or combined input and output arrangements for interaction between user and computer
    • G06F3/048—Interaction techniques based on graphical user interfaces [GUI]
    • G06F3/0481—Interaction techniques based on graphical user interfaces [GUI] based on specific properties of the displayed interaction object or a metaphor-based environment, e.g. interaction with desktop elements like windows or icons, or assisted by a cursor's changing behaviour or appearance
    • G06F3/04815—Interaction with a metaphor-based environment or interaction object displayed as three-dimensional, e.g. changing the user viewpoint with respect to the environment or object
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F3/00—Input arrangements for transferring data to be processed into a form capable of being handled by the computer; Output arrangements for transferring data from processing unit to output unit, e.g. interface arrangements
    • G06F3/01—Input arrangements or combined input and output arrangements for interaction between user and computer
    • G06F3/048—Interaction techniques based on graphical user interfaces [GUI]
    • G06F3/0484—Interaction techniques based on graphical user interfaces [GUI] for the control of specific functions or operations, e.g. selecting or manipulating an object, an image or a displayed text element, setting a parameter value or selecting a range
    • G06F3/04842—Selection of displayed objects or displayed text elements

Abstract

The application provides a data storage method, a device, equipment and a storage medium, wherein the method comprises the steps of obtaining a plurality of detection information tables corresponding to a target component, and extracting detection information of the target component in each detection information table; the plurality of detection information tables comprise detection information tables of at least two table types; determining a table type of each detection information table based on the detection information of each detection information table; based on the table type of each detection information table, the detection information of the target component in each detection information table is stored in a first database corresponding to the table type.

Description

Data storage method and device, equipment and storage medium
Technical Field
The present application relates to the field of data storage, and in particular, to a data storage method, apparatus, device, and storage medium.
Background
At present, the automobile industry has various detection modes aiming at parts, but the construction of the parts at the supply level based on a big data platform of a main stream host factory of the industry mainly comprises the following steps: 1. monitoring the detection data of a single detection mode, and only uploading the detection data of the detection mode to be monitored by a provider at the moment; 2. the inspection data of multiple inspection modes is monitored, and at this time, one part is regarded as multiple parts, and the suppliers simultaneously go on multiple inspection data. Most of the host factories use various inspection data of one part as data of a plurality of parts for platform management, which reduces the efficiency of acquiring inspection data of the parts.
Disclosure of Invention
The application mainly provides a data storage method, a data storage device, equipment and a storage medium, which can solve the problem of low efficiency of acquiring part detection data in the related technology.
The technical scheme of the embodiment of the application is realized as follows:
the embodiment of the application provides a data storage method, which comprises the following steps:
acquiring a plurality of detection information tables corresponding to a target component, and extracting detection information of the target component in each detection information table; the plurality of detection information tables comprise detection information tables of at least two table types; determining the table type of each detection information table based on the detection information of each detection information table; based on the table type of each detection information table, the detection information of the target component in each detection information table is stored in a first database corresponding to the table type.
In some embodiments, the target component corresponds to at least one detection point, the detection information including a corresponding detection value for each of the detection points; the determining a table type of each detection information table based on the detection information of each detection information table includes: and determining the table type of each detection information table based on the detection type of the detection value corresponding to each detection point in the detection information table.
In some embodiments, the table types include a first table type and a second table type; the detection types include: a first detection type and a second detection type; the determining a table type of the detection information table based on the detection type of the detection value corresponding to each detection point in the detection information table includes: for each detection point, determining a table type of the detection information table as the first table type under the condition that the detection type of the detection value corresponding to the detection point is the first detection type; determining that the table type of the detection information table is the second table type under the condition that the detection type of the detection value corresponding to the detection point is the second detection type; the first detection type and the second detection type are determined based on whether the detection value includes three-dimensional coordinate data.
In some embodiments, the detection information includes header information; the determining a table type of each detection information table based on the detection information of each detection information table includes: for each detection information table, determining the table type of each detection information table based on the header information in the detection information table.
In some embodiments, the detection information includes a corresponding theoretical value for each of the detection points; the method further comprises the steps of: acquiring a three-dimensional model corresponding to the target component in response to a display event for the target component; determining a display point corresponding to each detection point on the three-dimensional model based on the theoretical value corresponding to each detection point; and storing the detection information corresponding to each display point and the three-dimensional model into a second database.
In some embodiments, the method further comprises:
extracting a three-dimensional model of the target component and detection information corresponding to each display point from the second database, and displaying each display point corresponding to the three-dimensional model and the target component on a human-computer interaction interface; and responding to the selection operation of the target display point, and displaying the detection information corresponding to the target display point on the man-machine interaction interface.
In some embodiments, displaying the detection information corresponding to the target display point on the human-computer interaction interface includes: displaying a selection control corresponding to each detection type corresponding to the target display point on the man-machine interaction interface; and responding to the triggering operation for the target selection control, and displaying detection information of a detection type corresponding to the target selection control on the human-computer interaction interface.
In some embodiments, the human-computer interaction interface is further configured to display a display point status of each of the display points; the method further comprises the steps of: displaying the three-dimensional model and each display point corresponding to the target component and the display point state of each display point on the human-computer interaction interface; the display point state of each display point is determined based on first difference information corresponding to each display point and second difference information corresponding to each display point.
An embodiment of the present application provides a data storage device, including:
an obtaining unit, configured to obtain a plurality of detection information tables corresponding to a target component, and extract detection information of the target component in each detection information table;
a determining unit configured to determine a table type of each of the detection information tables based on detection information of each of the detection information tables;
and the storage unit is used for storing the detection information of the target component in each detection information table into a first database corresponding to the table type based on the table type of each detection information table.
An embodiment of the present application provides a data storage device, including:
A memory for storing executable instructions;
and the processor is used for realizing the data storage method provided by the embodiment of the application when executing the executable instructions stored in the memory.
The embodiment of the application provides a storage medium, and executable instructions are stored on the storage medium, and when the executable instructions are executed by a processor, the data storage method provided by the embodiment of the application is realized.
The embodiment of the application has the following beneficial effects:
the embodiment of the application acquires a plurality of detection information tables corresponding to the target component, and extracts the detection information of the target component in each detection information table; the plurality of detection information tables comprise detection information tables of at least two table types; determining a table type of each detection information table based on the detection information of each detection information table; based on the table type of each detection information table, the detection information of the target component in each detection information table is stored in a first database corresponding to the table type. Thus, after obtaining the detection information tables of multiple table types corresponding to the target component, the embodiment of the application can determine the table type of each detection information table based on the detection information of each detection information table, and finally store the detection information of the detection information tables of different table types into different databases, wherein the different databases are corresponding to the target component. Thus, various kinds of detection information of one component can be managed as data of one component, thereby improving the efficiency of acquiring different types of detection data.
Drawings
FIG. 1 is a schematic flow chart of an alternative method for storing data according to an embodiment of the present application;
FIG. 2 is a schematic flow chart of an alternative method for storing data according to an embodiment of the present application;
FIG. 3 is a schematic flow chart of an alternative method for storing data according to an embodiment of the present application;
FIG. 4 is a schematic flow chart of an alternative method for storing data according to an embodiment of the present application;
FIG. 5 is a schematic flow chart of an alternative method for storing data according to an embodiment of the present application;
FIG. 6 is a schematic diagram of a man-machine interaction interface in a data storage method according to an embodiment of the present application;
FIG. 7 is a schematic diagram of a data storage device according to an embodiment of the present application;
fig. 8 is a schematic diagram of a composition structure of a data storage device according to an embodiment of the present application.
Detailed Description
The technical scheme of the application is further elaborated below with reference to the drawings and specific embodiments.
In order that those skilled in the art will better understand the embodiments of the present disclosure, a technical solution in the embodiments of the present disclosure will be clearly described below with reference to the accompanying drawings in which it is apparent that the described embodiments are only some embodiments of the present disclosure, not all embodiments.
The terms first, second, third and the like in the description and in the claims and in the above-described figures are used for distinguishing between similar elements and not necessarily for describing a particular sequential or chronological order. Furthermore, the terms "comprise" and "have," as well as any variations thereof, are intended to cover a non-exclusive inclusion, such as a series of steps or elements. The method, system, article, or apparatus is not necessarily limited to those explicitly listed but may include other steps or elements not explicitly listed or inherent to such process, method, article, or apparatus.
The following is an explanation of terms involved in the embodiments of the present application:
the checking tool comprises: the gauge is a simple tool for controlling various sizes (such as aperture, space size and the like) of products in industrial production enterprises, improves production efficiency and control quality, is suitable for mass production of products such as automobile parts, and replaces professional measuring tools such as a smooth plug gauge, a thread plug gauge, an outer diameter caliper gauge and the like.
Three coordinates: all three-coordinate measuring machine can evaluate the dimension data of the parts quickly and accurately. The specific use process is as follows: and placing the part to be detected in a three-coordinate measurement space, obtaining the coordinate position of each detection point on the part to be detected, and solving the geometric dimension, shape and position of the detected object according to the space coordinate values of the detection points.
In the related art, for managing the inspection data of the parts, the platform management is often performed by regarding the inspection data of multiple inspection types of one part as the data of two parts, in this case, multiple completely different achievement forms must be made, and multiple sets of platform system grabbing logic and multiple visual report templates must be made. All parts of one type need to be made in multiple times, and the problems of great challenges, complex process and low efficiency are solved from the aspects of traffic, labor input and time for building a part platform. And for data processing, most of domestic sheet metal suppliers are in short capability, offline EXCEL format achievement tables are used, and a host factory uses a large data platform as a carrier for storing data based on the quotation, so that visualization is low and data traceability is poor.
To solve the above technical problem, the embodiments of the present disclosure provide a data storage method, which may be applied to various electronic devices, including but not limited to fixed devices and/or mobile devices, for example, the fixed devices include but are not limited to: personal computers (Personal Computer, PCs), or servers, which may be cloud servers or general servers. The mobile device includes, but is not limited to: one or more of a cell phone, tablet computer, or wearable device.
FIG. 1 is a flowchart of a data storage method according to an embodiment of the present application, as shown in FIG. 1, the flowchart may include:
in S101, acquiring a plurality of detection information tables corresponding to a target component, and extracting detection information of the target component in each detection information table; the plurality of detection information tables comprises detection information tables of at least two table types.
Here, the target component may be a component subjected to size detection. The detection information table may be a set containing the detection value of the target component subjected to the size detection and the related information of the target component.
In the embodiment of the application, the plurality of detection information tables corresponding to the target component include at least two detection information tables of table types, wherein the table types are used for representing detection modes of detection values in detection information, and the detection modes can be detection tools or three coordinates, and can also be any other detection modes capable of detecting the sizes of the components. Detecting the target component based on different detection modes, wherein the detection types corresponding to the obtained detection values are different; that is, the detection information tables of different table types are formed based on the detection types of the detection values within the tables being different. For example, the detection type of the detection value in the detection information table a is the detection type a, the detection type of the detection value in the detection information table B is the detection type B, and at this time, the table types of the detection information table a and the detection information table B are different.
The detection information table in the embodiment of the application comprises the writing positions of all detection values corresponding to various detection modes, and the detection values corresponding to different detection modes can be written into the detection information table, so that the detection information table with different formats is not required to be constructed aiming at different detection modes, and the efficiency of data management is improved.
In the following, the embodiment of the application takes the gauge and three coordinates as examples, and specifically describes that the compatibility of detection values of different detection modes is realized through the detection information table in the embodiment of the application. In an actual process, the target component is measured by the gauge to obtain gauge data, the gauge data comprises a T value, and the target component is measured by three coordinates to obtain three-coordinate data, wherein the three-coordinate data comprises an X value, a Y value, a Z value and a T value, the X value, the Y value and the Z value are three-dimensional coordinate data, and the T value is a deviation value of the coordinates. In order to realize compatibility of the gauge data and the three-coordinate data, the detection information table may include writing positions of an X value, a Y value, a Z value and a T value. Thus, when writing in the gauge data, writing in the writing position of the T value, and when writing in the three-coordinate data, writing in the writing positions of the X value, the Y value, the Z value and the T value respectively, thereby forming detection information tables with different table types, and further realizing compatibility of the gauge data and the three-coordinate data.
In some embodiments, on the basis of filling the detection information table with detection values of different detection types corresponding to the detection modes, the type of the measurement device may also be written in the table head of the detection information table, for example, "CMM" is used as a code number of three coordinates, and "CHFIX" is used as a code number of the detection tool. When the detection value corresponding to the three coordinates filled in the detection information table is detected, the measurement device of the table head of the detection information table can be filled with a 'CMM', and when the detection value corresponding to the three coordinates filled in the detection information table is detected, the measurement device of the table head of the detection information table can be filled with a 'CHFIX'. Thus, after the electronic device acquires the detection information table, the table type of the detection information table can be determined through the detection type of the detection value and the table head information of the detection information table, and the determination error caused by determining the table type of the detection information table only through the detection type of the detection value or the table head information of the detection information table is avoided.
In some embodiments, "extracting the detection information of the target component in each of the detection information tables" in S101 may be achieved by: and extracting detection information of the target component in each detection information table based on the grabbing templates. The capture template is determined based on format information in the detection information table, wherein the format information comprises row information and column information in the detection information table, and the row information and the column information comprise information in each row and each column of the detection information table. In the practical application process, the electronic equipment can acquire the format information of the detection information table in advance, and edit the grabbing template according to the format information of the detection information table. Thus, the electronic equipment can accurately extract the detection information of the target component in each detection information table based on the edited grabbing template.
In S102, a table type of each of the detection information tables is determined based on the detection information of each of the detection information tables.
Here, the detection information in the detection information table may be information representing the detection manner, such as the code number of the measuring apparatus mentioned above, and the sample number of the target component, which are written in the header information in the detection information table. In some embodiments, the detection information may also be detection values of different detection types detected by different detection modes.
In some embodiments, when the detection information includes header information, S102 may include: based on header information in each detection information table, a table type of each detection information table is determined. Since the header information contains information representing the detection mode corresponding to the table type of the detection information table, the table type of each detection information table can be determined by the header information.
In some embodiments, when the detection information includes a detection value, S102 may include: the table type of the detection information table is determined based on the detection type of the detection value in the detection information table. Because the detection values corresponding to different detection modes are different in detection type, the table type of the detection information table can be determined according to the detection type of the detection value.
In some embodiments, when the detection information includes header information and a detection value, S102 may include: the table type of the detection information table is determined through the table header information, then the table type of the detection information table is determined again through the detection value, and when the table types determined twice are the same table type, the determined table type is determined to be the table type of the detection information table. This can avoid an error in determining the table type of the detection information table due to an error in header information or detection value.
In S103, based on the table type of each of the detection information tables, the detection information of the target component in each of the detection information tables is stored in a first database corresponding to the table type.
For example, when the electronic device determines that the plurality of detection information tables includes two types of detection information tables, the two types of detection information tables being respectively the type a and the type B, the electronic device stores the detection information of the detection information table of the target component in the type a in the database a, and stores the detection information of the detection information table of the target component in the type B in the database B, that is, the electronic device may store all the detection information according to different types of tables, and the plurality of databases after the storage correspond to the target component. Thus, one target component can correspond to a plurality of first databases stored according to different table types, thereby achieving the effect that a plurality of detection information of one component can be managed as data of one component.
After obtaining the detection information tables of multiple table types corresponding to the target component, the embodiment of the application can determine the table type of each detection information table based on the detection information of each detection information table, and finally store the detection information of the detection information tables of different table types into different databases, wherein the different databases correspond to the target component. Thus, various kinds of detection information of one component can be managed as data of one component, thereby improving the efficiency of acquiring different types of detection data.
In some embodiments, referring to fig. 2, fig. 2 is a schematic flow chart of an alternative data storage method according to an embodiment of the present application, based on fig. 1, S102 in fig. 1 may be updated to S201 and S202, and the steps shown in fig. 2 will be described.
In S201, for each of the detection information tables, a table type of the detection information table is determined based on a detection type of a detection value corresponding to each of the detection points in the detection information table.
Here, the target component may correspond to at least one detection point, and the detection information in the detection information table may include a detection value corresponding to each of the at least one detection point. The detection point is a position point on the target component, where size detection is required, for example, the detection point is one or more position points on a reference plane of the target component, and detection values of different detection types corresponding to the detection point can be obtained through size detection of different detection modes.
In some embodiments, S201 may be implemented by: for each detection information table, determining the detection type of the detection value corresponding to each detection point based on the detection value corresponding to each detection point in the detection information table; and determining the table type of the detection information table based on the detection type of the detection value corresponding to each detection point.
In some embodiments, S201 may be implemented through S2011 to S2012:
in S2011, for each of the detection points, if the detection type of the detection value corresponding to the detection point is the first detection type, it is determined that the table type of the detection information table is the first table type.
In S2012, in the case where the detection type of the detection value corresponding to the detection point is the second detection type, it is determined that the table type of the detection information table is the second table type.
Here, the table types of the detection information table may include a first table type and a second table type; the detection type of the detection value may include: a first detection type and a second detection type. In some embodiments, the first detection type and the second detection type may be data types of detection values obtained based on different detection modes, for example, the first detection type may be data types of detection values obtained based on three coordinates, and the second detection type may be data types of detection values obtained based on a gauge.
In some embodiments, the electronic device may determine the detection type of the detection value based on whether the three-dimensional coordinate data is included in the detection value corresponding to each detection point. In the embodiment of the application, under the condition that the detection value corresponding to the detection point contains three-dimensional coordinate data, determining that the detection type of the detection value is a first detection type, and determining that the table type containing the detection value detection information table is a first table type; and under the condition that the detection value corresponding to the detection point does not contain three-dimensional coordinate data, determining that the detection type of the detection value is a second detection type, and determining that the table type containing the detection value detection information table is the second table type.
In S202, for each of the detection information tables, a table type of the detection information table is determined based on header information in the detection information table.
The header information in the embodiment of the application contains the name information of the detection type, and the electronic equipment can determine the table type of the detection information table according to the name information of the detection type.
In some embodiments, when header information in the detection information table includes name information of the first detection type, determining that the detection type of the detection information table is the first detection type; when the header information in the detection information table contains the name information of the second detection type, the detection type of the detection information table is determined to be the second detection type.
In some embodiments, when the electronic device determines the table type of the detection information table based on the detection type of the detection value corresponding to each detection point in the detection information table, and determines the table type of the detection information table based on the header information in the detection information table, the table type is determined as the table type of the detection information table in a case where the table type determined based on the detection value and the table type determined based on the header information are the same. For example, the table type of the detection information table determined based on the detection value is the table type a, and the table type of the detection information table determined based on the header information is also the table type a, then the table type of the detection information table is the table type a; if the table type of the detection information table determined based on the detection value is the table type A, the table type of the detection information table determined based on the header information is the table type B, and the detection information in the detection information table is indicated to have errors. Thus, the table type of the detection information table is determined by the detection value corresponding to the detection point and the header information together, so that the accuracy of determining the table type of the detection information table can be improved.
After extracting header information of each detection information table and detection values corresponding to each detection point of the target component, the embodiment of the application can determine the table type of the detection information table based on the header information and/or determine the table type of the detection information table based on the detection values corresponding to each detection point. This can improve the accuracy of determining the table type of the detection information table.
In some embodiments, referring to fig. 3, fig. 3 is a schematic flow chart of an alternative data storage method according to an embodiment of the present application, based on fig. 1, after S103 in fig. 1, the data storage method according to an embodiment of the present application may further include S301 to S303, and will be described with reference to the steps shown in fig. 3.
In S301, in response to a display event for the target component, a three-dimensional model corresponding to the target component is acquired.
In the embodiment of the application, the user can initiate the display event aiming at the target component, and the electronic equipment can respond to the display event to acquire the three-dimensional model corresponding to the target component. Here, the display event for the target component may be caused by clicking an upload button on the man-machine interaction interface by the user, and the user may upload the three-dimensional model and the part number corresponding to the three-dimensional model on the man-machine interaction interface, and since each detection information table corresponding to the target component includes the part number corresponding to the target component, after uploading the three-dimensional model, the three-dimensional model may be mapped to the detection information in the detection information table based on the part number.
In S302, a display point corresponding to each detection point is determined on the three-dimensional model based on the theoretical value corresponding to each detection point.
Here, the theoretical value corresponding to the detection point may be a nominal value corresponding to the detection point, the nominal value including a three-dimensional coordinate value corresponding to the detection point, and the position of each detection point on the three-dimensional model may be determined based on the three-dimensional coordinate value.
In some embodiments, the theoretical value corresponding to each detection point may be obtained from any one of the first databases. Since the theoretical values of the same detection point in different first databases are the same.
In S303, the detection information corresponding to each display point and the three-dimensional model are stored in a second database.
In the embodiment of the application, after the electronic device determines the position (i.e. the display point) of the detection point on the three-dimensional model, the detection information corresponding to each display point and the three-dimensional model can be stored in the second database.
Here, the detection information corresponding to each display point may be the corresponding detected point information. For example, the detection point information may include a design value, an engineering specification, a control specification, an actual measurement value, a deviation condition, and an out-of-tolerance condition corresponding to the detection point, where the design value may include: numbering, coding, characteristic codes, and theoretical values.
The embodiment of the application can respond to the display event aiming at the target component to acquire the three-dimensional model corresponding to the target component; determining display points corresponding to each detection point on the three-dimensional model based on theoretical values corresponding to each detection point; and storing the detection information corresponding to each display point and the three-dimensional model into a second database. Therefore, the second database in the embodiment of the application contains the three-dimensional model corresponding to the target component and the detection information corresponding to each display point on the three-dimensional model, so that the three-dimensional model of the target component and the detection information can be correspondingly combined, the corresponding detection information can be directly read on the three-dimensional model, and the data reading efficiency is improved.
In some embodiments, referring to fig. 4, fig. 4 is a schematic flow chart of an alternative data storage method provided in the embodiment of the present application, based on fig. 3, after S303 in fig. 3, the data storage method in the embodiment of the present application may further include S401 to S402, which will be described in connection with the steps shown in fig. 4.
In S401, a three-dimensional model of the target component and detection information corresponding to each display point are extracted from the second database, and each display point corresponding to the three-dimensional model and the target component is displayed on a man-machine interaction interface.
In the embodiment of the application, when the electronic equipment needs to display the three-dimensional model and the display points on the three-dimensional model, the three-dimensional model of the target component and the detection information corresponding to each display point can be extracted from the second database, and each display point corresponding to the three-dimensional model and the target component is displayed on the man-machine interaction interface.
In some embodiments, each display point on the three-dimensional model may be filled with a corresponding color that is associated with the detected information, which may not only distinguish between non-display points and display points on the three-dimensional model, but may also display different display points based on different detected information.
In S402, in response to a selection operation for a target display point, the detection information corresponding to the target display point is displayed on the human-computer interaction interface.
In the embodiment of the application, a user can select the target display point from at least one display point on the man-machine interaction interface, and the electronic equipment can respond to the selection operation for the target display point to display the detection information corresponding to the target display point on the man-machine interaction interface.
Here, the target display point may be at least one of at least one display point on the three-dimensional model, that is, the electronic device may display detection information corresponding to a part of display points on the human-computer interaction interface, or may display detection information corresponding to all display points.
In some embodiments, the "displaying the detection information corresponding to the target display point on the human-computer interaction interface" in S402 may be implemented by:
in S4021, a selection control corresponding to each detection type corresponding to the target display point is displayed on the human-computer interaction interface.
In the embodiment of the application, the electronic equipment can display the selection control for selecting the detection type of the detection value by the user on the man-machine interaction interface.
Here, there may be a plurality of selection controls, where the plurality of selection controls correspond to the plurality of detection types, for example, the selection control 1 corresponds to the first detection type, the selection control 2 corresponds to the first detection type, when the user clicks the selection control 1, the human-computer interaction interface may display detection information corresponding to the first detection type, and when the user clicks the selection control 2, the human-computer interaction interface may display detection information corresponding to the second detection type.
In S4022, in response to a trigger operation for a target selection control, detection information of a detection type corresponding to the target selection control is displayed on the human-computer interaction interface.
In the embodiment of the application, a user can select the target selection control corresponding to the requirement based on the requirement of the display information, and then the electronic equipment can respond to the triggering operation aiming at the target selection control to display the detection information of the detection type corresponding to the target selection control on the human-computer interaction interface.
In some embodiments, detection information of a detection type corresponding to the target selection control is displayed on the human-computer interaction interface, and the detection information can be a detection value.
The implementation process of S405 is specifically described below by taking the example that the detection value of the first detection type is three-coordinate data output by the three-coordinate device, and the detection value of the second detection type is gauge data output by the gauge device: the electronic equipment firstly displays a three-dimensional model corresponding to the target component and display points in the three-dimensional model on the human-computer interaction interface, after a user selects the display points, the electronic equipment displays a selection control 1 corresponding to the first detection type and a selection control 2 corresponding to the second detection type on the selected display points, the user clicks the selection control 1, and the electronic equipment responds to triggering operation aiming at the selection control 1 to display corresponding three-coordinate data, namely XYZT, on the human-computer interaction interface.
The embodiment of the application can display the three-dimensional model corresponding to the target component and the display point corresponding to the detection point, and display the detection information of the corresponding detection type on the human-computer interaction interface based on the selection of the user. In this way, the detection information of different detection types can be quickly read by combining the three-dimensional model.
In some embodiments, the human-computer interaction interface is further configured to display a display point status of each display point, and in the embodiment of the present application, the "displaying each display point corresponding to the target component on the human-computer interaction interface" in S401 includes: and displaying the three-dimensional model, each display point corresponding to the target component and the display point state of each display point on the human-computer interaction interface.
In the embodiment of the application, the electronic equipment can display the display point state of each display point while displaying the three-dimensional model and each display point corresponding to the target component.
Here, the display point state may represent out-of-tolerance conditions of detection information of different detection types corresponding to the display point. The display point state of each display point is determined based on first difference information corresponding to each display point and second difference information corresponding to each display point, wherein the first difference information is used for representing the out-of-tolerance condition of the detection value of the first detection type, and the second difference information is used for representing the out-of-tolerance condition of the detection value of the second detection type.
In some embodiments, the display point status of each display point may be determined by:
A. For each display point, first difference information is determined based on a detection value corresponding to the first detection type and a theoretical value corresponding to the first detection type.
B. And determining second difference information based on the detection value corresponding to the second detection type and the theoretical value corresponding to the second detection type.
C. And determining the display point state of the display point based on the first difference information and the second difference information.
In the embodiment of the application, the electronic equipment can acquire the detection value and the theoretical value corresponding to the display point from the first database corresponding to the first detection type, and determine the first difference information based on the detection value and the theoretical value; in the embodiment of the present application, the difference between the detected value and the theoretical value may be used as the first difference information.
Then, the electronic device may acquire a detection value and a theoretical value corresponding to the display point in a first database corresponding to the second detection type, and determine second difference information based on the detection value and the theoretical value; in the embodiment of the present application, the difference between the detected value and the theoretical value may be used as the second difference information.
In some embodiments, determining display information of the display point based on the first difference information and the second difference information may include:
Under the condition that the first difference information and the second difference information are smaller than or equal to a preset threshold value, determining the display point state of the display point to be a first color display state;
determining a display point state of the display point to be a second color display state under the condition that any one of the first difference information and the second difference information is larger than a preset threshold value;
and determining the display point state of the display point to be a third color display state under the condition that the first difference information and the second difference information are both larger than a preset threshold value.
Here, the first color display state may refer to the display point being displayed in the first color, the second color display state may refer to the display point being displayed in the second color, and the third color display state may refer to the display point being displayed in the third color. In some embodiments, the first color may be green, and neither the detected value of the first detection type nor the detected value of the second detection type representing the display point is out of tolerance; the second color may be yellow, and one of the detection value of the first detection type and the detection value of the second detection type representing the display point is out of tolerance; the third color may be red, and the detected value of the first detection type and the detected value of the second detection type representing the display point are out of tolerance.
Therefore, the embodiment of the application determines the display point state of the display point based on whether the detection values of different detection types are out of tolerance, can quickly determine the problematic detection point on the three-dimensional model, and improves the efficiency of data analysis.
In some embodiments, the electronic device may further display a data analysis graph corresponding to the target display point on the human-machine interaction interface.
In the embodiment of the present application, the data analysis map corresponding to the target display point may be determined based on the detection information corresponding to the target display point. In some embodiments, after the user selects the target display point on the man-machine interaction interface, the detection type of the detection value to be displayed is selected based on the selection control, then the user can continue to select the data analysis graph displaying the detection value corresponding to the selected detection type, and the electronic device can display the corresponding data analysis graph on the man-machine interaction interface in response to the interaction operation of displaying the data analysis graph.
As shown in fig. 5, fig. 5 is a schematic diagram of a human-computer interaction interface in the data storage method according to the embodiment of the present application, where the human-computer interaction interface includes a three-dimensional model 501 corresponding to a target component, a target display point 502, and a data analysis graph 503. The data analysis chart 503 includes a plurality of detection values (X value and Y value) displayed by the histogram, an engineering specification (i.e., ±1.2 in the chart), a control specification (i.e., ±1 in the chart) and process capability information, and whether the plurality of detection values corresponding to the target display point 502 exceed the engineering specification and the control specification can be intuitively seen by the data analysis chart 503. Wherein the process capability information may characterize a degree of uniformity of a corresponding plurality of detection values for each display point. In some embodiments, the process capability information may include at least one of an average value (MEAN), a RANGE, 6σ, a process performance index (Pp), and a process performance k index (Ppk).
The application of the data storage method provided by the embodiment of the application in an actual scene is described below. Referring to fig. 6, fig. 6 is a schematic flowchart of an alternative data storage method according to an embodiment of the present application, and the steps shown in fig. 6 will be described.
In S601, a standard score table uploaded by a user is received.
In the embodiment of the present application, each standard score table (corresponding to the detection information table in the above embodiment) may be a gauge standard score table or a three-coordinate standard score table. The format of the header information and the measuring point information in the standard score table is fixed, so that the standard score table with the standard format is formed. Wherein, the table head information row and column are fixed, the measuring point information column below is solidified, and the row can be increased or decreased according to the number of the measuring points.
The standard score table is additionally provided with management of T values, so that compatibility of the gauge and three coordinates is realized. In some embodiments, three coordinates are measured: the T value is taken as a normal direction of the three coordinates, is directly output after being measured by the three coordinates equipment, and XYZT is directly output by the measuring equipment and is normally uploaded to the platform; when the gauge measures: the XYZ three directions are not filled, only the T direction is filled, the value of the measuring point of the measuring tool is directly filled in the T direction of the corresponding measuring point of the result table, and then the position degree of the hole is measured by the normal uploading platform, and the T value is not filled in during three-coordinate measurement (the three-coordinate hole position cannot be normal to T); when the gauge measures, the nominal value and tolerance of the normal T of the hole site are uniformly filled with 0, and the hole passing performance is judged by whether the detection pin passes or not, namely, 0 can be filled and 1 cannot be filled.
In S602, detection information in the standard score table is acquired based on the grabbing template.
According to the embodiment of the application, the big data platform edits the grabbing templates according to the format of the score table and the rules of the rows and columns and the corresponding information, so that bridges of the big data platform and the offline score table are built, and a one-to-one correspondence is formed.
In S603, the three-dimensional model uploaded by the receiving user forms a platform structure tree.
In the embodiment of the application, corresponding 3D digital models are uploaded in the part management of the large data platform corresponding to the target part, and the digital models and the measuring point information are in one-to-one correspondence to form a platform structure tree.
In S604, the acquired detection information is identified, and different platform databases are obtained.
In the embodiment of the application, the acquired detection information is identified, so that a 'gauge' platform database and a 'three-coordinate' platform database can be formed.
In S605, responsive to a user selection of a data type, the corresponding type of data is presented in conjunction with a three-dimensional modulo.
In the embodiment of the application, the data platform can process the target part database and watch the 3D measurement data on line through the 3DDrive module.
According to the embodiment of the application, the T value is added to the existing score table to realize the compatibility of the gauge data and the three-dimensional data, the detection information of the standard score table is acquired through the grabbing template, and after the corresponding three-dimensional digital-analog is uploaded, the measurement data, the measuring point and the three-dimensional digital-analog are in one-to-one correspondence, so that the data visualization is high in data reading efficiency, the data reading is easy, the time is saved, the analysis problem is rapid, and the timeliness is high.
An embodiment of the present application provides a data storage device, and fig. 7 is a schematic diagram of a composition structure of a data storage device 700 provided in an embodiment of the present application, as shown in fig. 7, where the device includes: an acquisition unit 701, a determination unit 702, and a storage unit 703, wherein:
an obtaining unit 701, configured to obtain a plurality of detection information tables corresponding to a target component, and extract detection information of the target component in each detection information table;
a determining unit 702 configured to determine a table type of each of the detection information tables based on detection information of each of the detection information tables;
a storage unit 703, configured to store, based on a table type of each of the detection information tables, detection information of the target component in each of the detection information tables into a first database corresponding to the table type.
In some embodiments, the target component corresponds to at least one detection point, the detection information including a corresponding detection value for each of the detection points; the determining unit 702 is further configured to determine, for each of the detection information tables, a table type of the detection information table based on a detection type of a detection value corresponding to each detection point in the detection information table.
In some embodiments, the table types include a first table type and a second table type; the detection types include: a first detection type and a second detection type; the determining unit 702 is further configured to determine, for each of the detection points, that a table type of the detection information table is the first table type, in a case where a detection type of a detection value corresponding to the detection point is the first detection type; determining that the table type of the detection information table is the second table type under the condition that the detection type of the detection value corresponding to the detection point is the second detection type; the first detection type and the second detection type are determined based on whether the detection value includes three-dimensional coordinate data.
In some embodiments, the detection information includes header information; the determining unit 702 is further configured to determine, for each of the detection information tables, a table type of the detection information table based on header information in the detection information table.
In some embodiments, the detection information includes a corresponding theoretical value for each of the detection points; the storage unit 703 is further configured to obtain a three-dimensional model corresponding to the target component in response to a display event for the target component; determining a display point corresponding to each detection point on the three-dimensional model based on the theoretical value corresponding to each detection point; and storing the detection information corresponding to each display point and the three-dimensional model into a second database.
In some embodiments, the data storage device further includes a display unit, where the display unit is configured to extract, from the second database, a three-dimensional model of the target component and detection information corresponding to each display point, and display, on a human-computer interaction interface, each display point corresponding to the three-dimensional model and the target component; and responding to the selection operation of the target display point, and displaying the detection information corresponding to the target display point on the man-machine interaction interface.
In some embodiments, the display unit is further configured to display, on the human-computer interaction interface, a selection control corresponding to each detection type corresponding to the target display point; and responding to the triggering operation for the target selection control, and displaying detection information of a detection type corresponding to the target selection control on the human-computer interaction interface.
In some embodiments, the human-computer interaction interface is further configured to display a display point status of each of the display points; the display unit is further used for displaying the three-dimensional model, each display point corresponding to the target component and the display point state of each display point on the human-computer interaction interface; the display point state of each display point is determined based on first difference information corresponding to each display point and second difference information corresponding to each display point.
In order to solve the above technical problem, an embodiment of the present application provides a data storage device, and fig. 8 is a schematic structural diagram of a data storage device 800 provided in the embodiment of the present application, as shown in fig. 8, where the device includes: a processor 801, a communication interface 802, and a memory 803, wherein:
the processor 801 generally controls the overall operation of the computer device 800, which may be the implementation of the data storage methods provided by embodiments of the present application, such as the methods shown in fig. 2-6.
The communication interface 802 may enable the computer device to communicate with other terminals or servers over a network.
The memory 803 is configured to store instructions and applications executable by the processor 801, and may also cache data (e.g., image data, audio data, voice communication data, and video communication data) to be processed or processed by various modules in the processor 801 and the computer device 800, which may be implemented by a FLASH memory (FLASH) or a random access memory (Random Access Memory, RAM). Data may be transferred between processor 801, communication interface 802, and memory 803 via bus 804.
Embodiments of the present application provide a computer program product or computer program comprising computer instructions stored in a readable storage medium. The processor of the computer device reads the computer instructions from the readable storage medium, and the processor executes the computer instructions, so that the computer device executes the data storage method according to the embodiment of the present application.
An embodiment of the present application provides a readable storage medium storing executable instructions that, when executed by a processor, cause the processor to perform a data storage method provided by an embodiment of the present application, for example, a method as shown in fig. 1 to 6.
In some possible implementations, the readable storage medium may be FRAM, ROM, PROM, EPROM, EEPROM, flash memory, magnetic surface memory, optical disk, or CD-ROM; but may be a variety of devices including one or any combination of the above memories.
In some possible implementations, the executable instructions may be in the form of programs, software modules, scripts, or code, written in any form of programming language (including compiled or interpreted languages, or declarative or procedural languages), and they may be deployed in any form, including as stand-alone programs or as modules, components, subroutines, or other units suitable for use in a computing environment.
As an example, the executable instructions may, but need not, correspond to files in a file system, may be stored as part of a file that holds other programs or data, for example, in one or more scripts in a hypertext markup language (HTML, hyper Text Markup Language) document, in a single file dedicated to the program in question, or in multiple coordinated files (e.g., files that store one or more modules, sub-programs, or portions of code).
As an example, executable instructions may be deployed to be executed on one computing device or on multiple computing devices located at one site or, alternatively, distributed across multiple sites and interconnected by a communication network.
The foregoing is merely exemplary embodiments of the present application and is not intended to limit the scope of the present application. Any modification, equivalent replacement, improvement, etc. made within the spirit and scope of the present application are included in the protection scope of the present application.

Claims (10)

1. A method of data storage, comprising:
acquiring a plurality of detection information tables corresponding to a target component, and extracting detection information of the target component in each detection information table; the plurality of detection information tables comprise detection information tables of at least two table types;
determining the table type of each detection information table based on the detection information of each detection information table;
based on the table type of each detection information table, the detection information of the target component in each detection information table is stored in a first database corresponding to the table type.
2. The method of claim 1, wherein the target component corresponds to at least one detection point, the detection information including a corresponding detection value for each of the detection points; the determining a table type of each detection information table based on the detection information of each detection information table includes:
And determining the table type of each detection information table based on the detection type of the detection value corresponding to each detection point in the detection information table.
3. The method of claim 2, wherein the table types include a first table type and a second table type; the detection types include: a first detection type and a second detection type; the determining a table type of the detection information table based on the detection type of the detection value corresponding to each detection point in the detection information table includes:
for each detection point, determining a table type of the detection information table as the first table type under the condition that the detection type of the detection value corresponding to the detection point is the first detection type;
determining that the table type of the detection information table is the second table type under the condition that the detection type of the detection value corresponding to the detection point is the second detection type; the first detection type and the second detection type are determined based on whether the detection value includes three-dimensional coordinate data.
4. A method according to any one of claims 1 to 3, wherein the detection information comprises header information; the determining a table type of each detection information table based on the detection information of each detection information table includes:
For each detection information table, determining the table type of the detection information table based on the header information in the detection information table.
5. The method according to claim 2, wherein the detection information comprises a corresponding theoretical value for each of the detection points; the method further comprises the steps of:
acquiring a three-dimensional model corresponding to the target component in response to a display event for the target component;
determining a display point corresponding to each detection point on the three-dimensional model based on the theoretical value corresponding to each detection point;
and storing the detection information corresponding to each display point and the three-dimensional model into a second database.
6. The method of claim 5, wherein the method further comprises:
extracting a three-dimensional model of the target component and detection information corresponding to each display point from the second database, and displaying each display point corresponding to the three-dimensional model and the target component on a human-computer interaction interface;
and responding to the selection operation of the target display point, and displaying the detection information corresponding to the target display point on the man-machine interaction interface.
7. The method of claim 6, wherein displaying the detection information corresponding to the target display point on the human-machine interaction interface comprises:
displaying a selection control corresponding to each detection type corresponding to the target display point on the man-machine interaction interface;
and responding to the triggering operation for the target selection control, and displaying detection information of a detection type corresponding to the target selection control on the human-computer interaction interface.
8. The method of claim 7, wherein the human-machine interface is further configured to display a display point status of each of the display points; the method further comprises the steps of:
displaying the three-dimensional model, each display point corresponding to the target component and the display point state of each display point on the human-computer interaction interface; the display point state of each display point is determined based on first difference information corresponding to each display point and second difference information corresponding to each display point.
9. A data storage device, the device comprising:
an obtaining unit, configured to obtain a plurality of detection information tables corresponding to a target component, and extract detection information of the target component in each detection information table;
A determining unit configured to determine a table type of each of the detection information tables based on detection information of each of the detection information tables;
and the storage unit is used for storing the detection information of the target component in each detection information table into a first database corresponding to the table type based on the table type of each detection information table.
10. A data storage device, comprising:
a memory for storing executable instructions;
a processor for implementing the method of any one of claims 1 to 8 when executing executable instructions stored in said memory.
CN202310737734.7A 2023-06-20 2023-06-20 Data storage method and device, equipment and storage medium Pending CN117056335A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202310737734.7A CN117056335A (en) 2023-06-20 2023-06-20 Data storage method and device, equipment and storage medium

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202310737734.7A CN117056335A (en) 2023-06-20 2023-06-20 Data storage method and device, equipment and storage medium

Publications (1)

Publication Number Publication Date
CN117056335A true CN117056335A (en) 2023-11-14

Family

ID=88656092

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202310737734.7A Pending CN117056335A (en) 2023-06-20 2023-06-20 Data storage method and device, equipment and storage medium

Country Status (1)

Country Link
CN (1) CN117056335A (en)

Similar Documents

Publication Publication Date Title
US7065461B2 (en) Point cloud measuring system and method
CN105116842B (en) A kind of fault data visualization analytic method based on digital control system daily record
CN101898317B (en) Virtual numerical control machine on-line detection system and method
US10620615B2 (en) Engineering tool coordination device, engineering tool coordination method, and non-transitory computer readable storage medium
CN112506759B (en) Automatic test method and device for servo system control software and storage medium
US9523970B2 (en) Field device information display apparatus and method that display information based on proximity
CN107944005B (en) Data display method and device
CN114153926A (en) Data quality evaluation method and device, computer equipment and storage medium
CN104268325A (en) Automatic modelling method for coordinate measuring machine model
CN110442852B (en) Target cost compiling method, storage medium and intelligent terminal thereof
CN117056335A (en) Data storage method and device, equipment and storage medium
CN103034917A (en) Device and method for designing material tracking system
CN115994709A (en) Data index calculation method, device, computer equipment and storage medium
WO2019094462A1 (en) Interactive guidance system for selecting thermodynamics methods in process simulations
KR101717597B1 (en) The dimensional control system based on mobile
CN210807303U (en) Portable electric power protocol tester
CN116775655A (en) Data storage method and device based on three-dimensional model, equipment and storage medium
CN100582659C (en) Complex position degree computing system and method
CN111861149B (en) Detection process driving method and system based on three-dimensional model
CN106443732B (en) Path diagram drawing method and system based on GPS
KR101513056B1 (en) Requirement Traceability Management System and its Method
CN100345146C (en) Object measuring system and method
CN112215977B (en) Process industrial equipment inspection data processing method, inspection system, device and medium
CN114637571B (en) Method and device for controlling IOS terminal by computer terminal, intelligent terminal and storage medium
US11815872B2 (en) Systems, methods and computer program products for automated revision comparison of engineering data in process control systems

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