CN118377808A - Automatic extraction and identification method and system for design data - Google Patents
Automatic extraction and identification method and system for design data Download PDFInfo
- Publication number
- CN118377808A CN118377808A CN202410663560.9A CN202410663560A CN118377808A CN 118377808 A CN118377808 A CN 118377808A CN 202410663560 A CN202410663560 A CN 202410663560A CN 118377808 A CN118377808 A CN 118377808A
- Authority
- CN
- China
- Prior art keywords
- data table
- array
- attributes
- design data
- template
- 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
Links
- 238000013461 design Methods 0.000 title claims abstract description 110
- 238000000034 method Methods 0.000 title claims abstract description 56
- 238000000605 extraction Methods 0.000 title claims description 25
- 230000003993 interaction Effects 0.000 claims description 4
- 238000012545 processing Methods 0.000 abstract description 7
- 230000008569 process Effects 0.000 description 13
- 230000006870 function Effects 0.000 description 10
- 238000013075 data extraction Methods 0.000 description 9
- 238000012552 review Methods 0.000 description 5
- 238000010586 diagram Methods 0.000 description 4
- 239000000284 extract Substances 0.000 description 4
- 238000012423 maintenance Methods 0.000 description 4
- 230000000007 visual effect Effects 0.000 description 4
- 230000009471 action Effects 0.000 description 3
- 238000003491 array Methods 0.000 description 3
- 238000004364 calculation method Methods 0.000 description 3
- 238000004590 computer program Methods 0.000 description 3
- 230000010354 integration Effects 0.000 description 3
- 238000007726 management method Methods 0.000 description 3
- 230000004048 modification Effects 0.000 description 3
- 238000012986 modification Methods 0.000 description 3
- 230000006978 adaptation Effects 0.000 description 2
- 238000004458 analytical method Methods 0.000 description 2
- 238000013499 data model Methods 0.000 description 2
- 230000008676 import Effects 0.000 description 2
- 230000002159 abnormal effect Effects 0.000 description 1
- 230000004888 barrier function Effects 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 230000008859 change Effects 0.000 description 1
- 230000003749 cleanliness Effects 0.000 description 1
- 238000010835 comparative analysis Methods 0.000 description 1
- 238000007405 data analysis Methods 0.000 description 1
- 238000012938 design process Methods 0.000 description 1
- 238000011161 development Methods 0.000 description 1
- 238000011156 evaluation Methods 0.000 description 1
- 238000007689 inspection Methods 0.000 description 1
- 230000002045 lasting effect Effects 0.000 description 1
- 239000000463 material Substances 0.000 description 1
- 230000007246 mechanism Effects 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 230000000750 progressive effect Effects 0.000 description 1
- 238000000275 quality assurance Methods 0.000 description 1
- 239000013589 supplement Substances 0.000 description 1
- 238000012795 verification Methods 0.000 description 1
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a method and a system for automatically extracting and identifying design data, wherein the method comprises the steps of establishing a data table template; the data table template comprises names and attributes of equipment items, wherein the attributes comprise key attributes and associated attributes; extracting names and key attributes of equipment items from a flow chart database; extracting associated attributes of the equipment items from the attribute association database; importing the names, key attributes and associated attributes of the equipment items into the data table template to obtain a current design data table; and acquiring a historical data table, and identifying a difference item between the historical data table and the current design data table to obtain a difference comparison result. According to the invention, the obtained historical data table and the current design data table are subjected to difference item identification, so that a comparison result can be obtained quickly, manual processing is not needed, and the accuracy and the working efficiency of personnel are improved greatly.
Description
Technical Field
The invention relates to the technical field of data processing, in particular to a method and a system for automatically extracting and identifying design data.
Background
At present, various industries comprehensively carry out a digitizing process in the aspect of data processing, and the efficiency and quality of industry development are remarkably improved. However, in some industries, such as the nuclear power industry, when publishing files such as a system design manual, an equipment list, and a purchase list, a designer still needs to rely on manual statistics and tabulation to sort out relevant data including equipment items and attribute lists. When design change and related files need to be raised or manually tabulated, the latest data table and the historical data table of the digital flow chart database need to be manually compared, so that human errors such as non-uniform data table formats, information filling errors, missing filling and the like are easy to generate, the quality of the files is influenced, and the trouble is brought to downstream users. The manual comparison accuracy is low, the workload of modifying the difference item is large, the efficiency is low, and time and labor are consumed.
In view of the foregoing, there is a need for an automated processing scheme that automatically generates a correlation data table and accurately identifies discrepancies.
Disclosure of Invention
The embodiment of the invention provides a method and a system for automatically extracting and identifying design data, which aim to solve the problems that in the prior art, the accuracy is low due to the fact that data files need to be manually counted and arranged, and further the working efficiency is low.
In a first aspect, an embodiment of the present invention provides a method for automatically extracting and identifying design data, including:
Establishing a data table template; the data table template comprises names and attributes of equipment items, wherein the attributes comprise key attributes and associated attributes;
extracting names and key attributes of equipment items from a flow chart database;
extracting associated attributes of the equipment items from the attribute association database;
importing the names, key attributes and associated attributes of the equipment items into the data table template to obtain a current design data table;
and acquiring a historical data table, and identifying a difference item between the historical data table and the current design data table to obtain a difference comparison result.
In a second aspect, an embodiment of the present invention provides an automatic design data extraction and identification system, including:
The data establishing unit is used for establishing a data table template; the data table template comprises names and attributes of equipment items, wherein the attributes comprise key attributes and associated attributes;
a first extraction unit for extracting names and key attributes of equipment items from a flowchart database;
a second extraction unit for extracting the associated attribute of the equipment item from the attribute association database;
the data importing unit is used for importing the names, the key attributes and the associated attributes of the equipment items into the data table template to obtain a current design data table;
The data identification unit is used for acquiring a historical data table, and carrying out difference item identification on the historical data table and the current design data table to obtain a difference comparison result.
The embodiment of the invention provides a method for automatically extracting and identifying design data, which comprises the steps of establishing a data table template; the data table template comprises names and attributes of equipment items, wherein the attributes comprise key attributes and associated attributes; extracting names and key attributes of equipment items from a flow chart database; extracting associated attributes of the equipment items from the attribute association database; importing the names, key attributes and associated attributes of the equipment items into the data table template to obtain a current design data table; and acquiring a historical data table, and identifying a difference item between the historical data table and the current design data table to obtain a difference comparison result. According to the invention, the obtained historical data table and the current design data table are subjected to difference item identification, so that a comparison result can be obtained quickly, manual processing is not needed, and the accuracy and the working efficiency of personnel are improved greatly.
The embodiment of the invention also provides a system for automatically extracting and identifying the design data, which also has the beneficial effects.
Drawings
In order to more clearly illustrate the technical solutions of the embodiments of the present invention, the drawings required for the description of the embodiments will be briefly described below, and it is obvious that the drawings in the following description are some embodiments of the present invention, and other drawings may be obtained according to these drawings without inventive effort for a person skilled in the art.
FIG. 1 is a schematic flow chart of a method for automatically extracting and identifying design data according to an embodiment of the present invention;
FIG. 2 is a schematic flow chart of a method for automatically extracting and identifying design data according to an embodiment of the present invention;
Fig. 3 is a schematic flow chart of step S101 according to an embodiment of the present invention;
Fig. 4 is a schematic flow chart before step S103 provided in the embodiment of the present invention;
fig. 5 is a schematic flow chart of step S103 according to an embodiment of the present invention;
fig. 6 is a schematic flow chart of step S104 according to an embodiment of the present invention;
FIG. 7 is a flow chart of array comparison provided by an embodiment of the present invention;
FIG. 8 is a second flow chart of array comparison provided in an embodiment of the present invention;
FIG. 9 is a schematic general flow chart of the difference item identification according to the embodiment of the present invention;
FIG. 10 is a schematic diagram of a form extraction interface according to an embodiment of the present invention;
Fig. 11 is a schematic block diagram of an automatic design data extraction and identification system according to an embodiment of the present invention.
Detailed Description
The following description of the embodiments of the present invention will be made clearly and fully with reference to the accompanying drawings, in which it is evident that the embodiments described are some, but not all embodiments of the invention. All other embodiments, which can be made by those skilled in the art based on the embodiments of the invention without making any inventive effort, are intended to be within the scope of the invention.
It should be understood that the terms "comprises" and "comprising," when used in this specification and the appended claims, specify the presence of stated features, integers, steps, operations, elements, and/or components, but do not preclude the presence or addition of one or more other features, integers, steps, operations, elements, components, and/or groups thereof.
It is also to be understood that the terminology used in the description of the invention herein is for the purpose of describing particular embodiments only and is not intended to be limiting of the invention. As used in this specification and the appended claims, the singular forms "a," "an," and "the" are intended to include the plural forms as well, unless the context clearly indicates otherwise.
It should be further understood that the term "and/or" as used in the present specification and the appended claims refers to any and all possible combinations of one or more of the associated listed items, and includes such combinations.
Referring to fig. 1, fig. 1 is a schematic flow chart of a method for automatically extracting and identifying design data according to an embodiment of the present invention, which specifically includes: steps S101 to S105.
S101, establishing a data table template; the data table template comprises names and attributes of equipment items, wherein the attributes comprise key attributes and associated attributes;
S102, extracting names and key attributes of equipment items from a flow chart database;
s103, extracting the associated attribute of the equipment item from the attribute associated database;
s104, importing the names, key attributes and associated attributes of the equipment items into the data table template to obtain a current design data table;
S105, acquiring a historical data table, and identifying a difference item between the historical data table and the current design data table to obtain a difference comparison result.
As shown in connection with fig. 2, in step S101, a data table template is used to ensure that data extracted from each data source can be properly displayed and used in accordance with a predefined format. The data sheet template first defines the names of the items of equipment, which is the basic information that identifies and associates the various equipment. The equipment items may be referred to as equipment objects, in particular pipes of a nuclear power plant or the like. The names of the equipment items are used as key indexes for retrieving and displaying data, and support subsequent data operation such as matching, comparison and analysis. The attributes of the equipment items are further subdivided into two major categories, key attributes and associated attributes. Key attributes are critical to the functionality and performance of a device, and associated attributes include interrelationships and dependencies between the device and other systems or devices.
In the design process, the data table template is presented in a table form, the readability and usability of data are considered in the template design, and the fact that all fields have enough space to display complete information is ensured, so that the data table template can be designed into a unified format, and is convenient to review and modify. It should be noted that the attribute database associated with the feature data set in fig. 2 is the attribute database in fig. 1, the latest design data of the flowchart in fig. 2 is the current design data table in fig. 1, the local data table in fig. 2 is the history data table in fig. 1, and the comparison result in fig. 2 is the difference item comparison result in fig. 1.
Referring to fig. 3, in one embodiment, the step S101 includes steps S301 to S304:
S301, determining a template type, and matching a corresponding equipment type and a corresponding data object type by using the template type;
S302, setting the template content as a two-dimensional array; wherein the two-dimensional array comprises names of equipment items and names of attributes;
s303, taking the name of the attribute as a first header and the name of the equipment item as a second header;
S304, integrating the first header and the second header, and setting an extraction mode of each attribute to obtain the data table template.
In this embodiment, different template types are determined according to the system requirements and project specifications, and each template type corresponds to a device type and a data object type. The template content is designed in a two-dimensional array format to clearly represent the data items and attribute values. The structure of the two-dimensional array allows the system to flexibly store and invoke data. The first row (first header) includes all relevant attribute names; the first column (second header) includes the name of the equipment item as the primary index, facilitating retrieval and reference of the data. For each attribute name, the corresponding field and the corresponding calculation method in the database can be obtained, so that the subsequent extraction is convenient. The extraction mode of each header attribute value is set, for example, directly read from a database, processed through a calculation formula or obtained through an external interface. The first header and the second header are integrated to form a complete data table template, and the system can automatically fill data extracted from various data sources by using the formulated data table template to generate a complete data table. These data tables may be used for further data analysis, report generation or as decision support tools for project management and equipment maintenance.
In step S102, the flow chart database may be a collection of flow charts based on Diagrams (process system flow chart design software) software design. First, the names of equipment items are retrieved from the flow chart database through specific query commands or API calls, and the equipment names are used as main keys for data extraction, so that the system is allowed to accurately locate specific equipment records. The extraction of the device name is based on identifiers or codes of the device in the engineering project, which are unique in the database, ensuring the accuracy of the query. The process of extracting key attributes involves querying relevant fields in the flow chart database, which is typically accomplished by predefined data models and query statements to ensure the accuracy and integrity of the data. For each device item, the system will match and extract all relevant key attributes based on its name. These attributes are then stored in an intermediate data structure within the system for further processing or direct output.
In step S103, the attribute association database is dedicated to storing device items and their additional associated attribute information, which supplement basic information of the device, provide a more comprehensive data perspective, and facilitate complex system analysis and decision support. The system first locates to a specific device item through a specific query command or API call. This is typically based on the names or unique identifiers of the equipment items, which ensure the accuracy of the query in the database. Extraction of the association attributes involves querying additional fields in the database that are directly associated with the device item. For each equipment item, the system matches and queries all relevant associated attributes based on its identifier. These attributes are extracted by predefined data models and query statements to ensure the integrity and accuracy of the data. The extracted association attributes may then be stored in an intermediate data structure within the system for further data integration or direct report generation.
As shown in fig. 4, in an embodiment, before the step S103, steps S401 to S403 are included:
S401, setting a DDA code association attribute table according to design requirements, and setting a pipe diameter and wall thickness comparison table and a drift diameter outer diameter comparison table;
s402, writing the association attribute table, the pipe diameter and wall thickness comparison table and the drift diameter and outer diameter comparison table into the attribute association database;
s403, setting an interface program for interaction for the attribute association database.
In this embodiment, multiple types of attributes related to a feature data set (DDA) code are carded according to design requirements, including a quality assurance level, a nuclear security level, a barrier item level, a function item level (runnability and integrity), a cleanliness level, a pipeline level, a mechanical level, and the like, which are associated attributes associated with the DDA code, and a set of these attributes is defined as an "associated attribute table". Meanwhile, a 'pipe diameter and wall thickness comparison table' and a 'drift diameter and outer diameter comparison table' are created, and the tables provide important comparison information between physical parameters of equipment and support accurate calculation and verification of a system in the design and maintenance processes. And writing the association attribute table, the pipe diameter and wall thickness comparison table and the drift diameter and outer diameter comparison table into an attribute association database so as to ensure accurate input and lasting storage of data. An interface program that interacts with the attribute association database may be written using the c# language. The program not only provides data reading functions, but also includes data updating, deleting and adding functions to support dynamic maintenance of the database. The written interface program will be integrated into the main program of the flow chart design software. The method allows design software to directly call the interface and read the required data from the attribute association database, so that the design efficiency and the real-time performance of the data are improved. And setting adding, deleting and modifying rights of the attribute association database in the interface program. The database can be maintained automatically according to the requirement, so that the dependence on the background maintenance manpower is reduced, and meanwhile, the safety and the integrity of the data are ensured.
Referring to fig. 5, in an embodiment, the association attribute includes an association attribute associated with the DDA code, a wall thickness value, and an outer diameter value, and step S103 includes steps S501 to S504:
S501, obtaining a DDA code and a pipe diameter value of the equipment item;
S502, extracting association attributes associated with the DDA codes from the attribute association database according to the DDA codes;
S503, extracting a wall thickness value from the attribute association database according to the DDA code and the pipe diameter value;
S504, extracting an outer diameter value from the attribute association database according to the pipe diameter value.
In this embodiment, the DDA code of the target equipment item and the pipe diameter value of the target equipment item are obtained by a user input or automatic identification method. The DDA code is a unique identifier associated with a device-specific design dataset, while the pipe diameter value is an important component of the device's physical parameters. With the acquired DDA code, the system extracts all associated attributes associated with the DDA code from the attribute association database. And further using the DDA code and the pipe diameter value as query parameters, and searching corresponding wall thickness values in the attribute association database. And extracting a corresponding outer diameter value from the attribute association database by the system through the pipe diameter value.
In step S104, the acquired equipment item name, key attribute and associated attribute are filled into corresponding columns according to the format requirement of the data table template. After all relevant data is imported into the data table template, the system automatically performs data integration operations to ensure that each data is completely and correctly presented in the table. After data integration is completed, a current design data table is generated. This data table may be used directly for design reviews, performance evaluations, customer demonstrations, or as a basis for further engineering decisions. By using standardized data sheet templates, data sharing in the project management process is more efficient and accurate.
Referring to fig. 6, in one embodiment, the step S104 includes steps S601 to S602:
S601, forming a two-dimensional array by the names of the equipment items and the attributes of the equipment items, and writing the two-dimensional array back into a form display control;
s602, taking a data table template as a driving condition, and automatically generating the current design data table based on a data table export function of the table display control.
In this embodiment, first, according to a drawing or a data extraction range set by a system, names of equipment items are used as search conditions, and all the equipment items meeting the conditions in the data extraction range are collected. And circularly traversing the collected equipment item sets, and calculating and extracting key attributes and associated attributes of each equipment item according to a preset data table template. Then through traversal process, two-dimensional array containing equipment item name and its corresponding attribute is formed. And writing the constructed two-dimensional array back to a form display control in the system, wherein the form display control not only displays data, but also provides an interface for user interaction, so that the data can be further edited or checked. And calling a data table export function based on the data which is written back in the table display control. This function is typically driven by a data table template, which needs to ensure that the derived data format and content meet design requirements. After all settings are completed, the system will automatically generate the current design data table.
In step S105, a history data table stored in a database or file system is accessed, which contains design data of previous project phases, which is the basis of the comparative analysis. The history data table is loaded into the system through an automation script or user interface. The historical data table format needs to be compatible with the current design data table format for efficient comparison. The system automatically compares the current design data table with the historical data table, which typically involves a one-by-one comparison of each data item, including the names, key attributes, and associated attributes of the equipment items. The system algorithmically identifies differences between the two data tables, including newly added items, modified attribute values, and possibly deleted items. All identified discrepancy terms are recorded in the discrepancy comparison result. The difference comparison results may be output as a document or visual report for project team review and reference. This helps the team understand the design changes and make further decisions.
In one embodiment, the step S105 includes:
Judging whether the template format of the current design data table is consistent with the template format of the historical data table;
If not, not carrying out difference item identification;
If yes, respectively traversing the cells of the current design data table and the historical data table in a circulating way, comparing one by one, and recording a difference item to obtain a difference comparison result.
In this embodiment, it is necessary to ensure that the current design data table and the history data table use the same template format, which is a precondition for effective data comparison. Different templates can cause data fields to be mismatched, thereby affecting the accuracy of the differential recognition. The system automatically examines the template format of the two data tables, including column header, column order, and data type, etc. If the inspection result shows that the template format of the current design data table is inconsistent with the template format of the historical data table, the system does not conduct difference item identification, so as to prevent error difference identification caused by format mismatch. If the template formats of the two data tables are identical, the system will continue to execute the discrepancy identification procedure. After confirming that the template formats are consistent, the system will cycle through each cell of the current design data table and the historical data table, respectively, and all recorded difference items will be summarized and a difference comparison result will be generated.
In an embodiment, the step S105 further includes:
And recording the difference comparison result in the historical data table.
In the present embodiment, a dedicated area or column is preset in the history data table to record the difference comparison result. The difference comparison results are written to the specified locations of the history data table in a predetermined format, including the difference type (e.g., add, modify, delete), specific difference item descriptions, and corresponding data table locations. Specifically, the detailed difference comparison result may be written in the last column of the history data table.
In an embodiment, after the step S105, the method further includes:
calling a method for exporting files by a form demonstration control;
And exporting the difference comparison result based on the method for exporting the file by the form display control to obtain the file to be checked.
In this embodiment, the form presentation control is used in the system to display and manipulate data, including the input, editing and presentation of data. The form presentation control has a data export function that allows a user to export presented data into various file formats, such as Excel, PDF, or CSV files. The system invokes a export method of the form presentation control via the programming interface that is configured to identify and transform the data presented in the control, including any visual patterns such as color identification, font bolding, etc., that are used to highlight the difference item. The exported files are usually provided in a spreadsheet format, so that auditors can conveniently review and annotate and modify the exported files, the manual processing requirement is reduced in an automatic export process, and the working efficiency is improved.
In an embodiment, the step of respectively circularly traversing the cells of the current design data table and the historical data table, performing one-to-one comparison, and recording a difference term to obtain a difference comparison result includes:
Respectively circularly traversing corresponding cells of the current design data table and the historical data table to obtain a first array and a second array;
Judging whether the elements in the first array are in the second array, if so, continuing to traverse the next cell, and if not, updating the elements and the attributes in the first array into the historical data table, and continuing to traverse the next cell;
And judging whether the element in the second array is in the first array, if so, continuing to traverse the next cell, and if not, marking the position of the element in the history data table, and continuing to traverse the next cell.
In this embodiment, the cells of the current design data table and the history data table are respectively cycled through to create two arrays: the first array is from the second column of the current design data table and the second array is from the second column of the historical data table. And comparing each cell one by one, and judging whether each element in the first array exists in the second array. If the elements in the first array are present in the second array, the system will continue to traverse the next cell without modification. If the element in the first array is not present in the second array, indicating that the element is new or modified, the system updates the elements and their attributes to the history table and continues the traversal. For elements that exist in the second array but are missing in the first array, the system needs to identify where the element is located in the history table, highlighting with a red mark or other visual identification means, indicating that the elements have been deleted or modified in the current design. All comparison results, including new, modified and deleted items, are updated and identified in the history data table accordingly.
In an embodiment, the first array and the second array are obtained by traversing cells in the same column of the current design data table and the historical data table;
And judging whether the element in the second array is in the first array, if so, continuing to traverse the next cell, wherein the judging comprises the following steps:
if yes, continuing to traverse the cells of the row where the elements of the second array are located in the historical data table and traversing the cells of the same row of the current design data table to obtain a third array and a fourth array;
and comparing the elements in the third array with the elements in the fourth array one by one.
In this embodiment, in the preliminary comparison, if it is determined that an element in the second array exists in the first array, the system will continue to traverse the other cells of the row in which the element is located in the history data table while traversing the cells of the same row in the current design data table. Through the above traversal, the system obtains a third array and a fourth array, respectively, which contain elements of the corresponding row. And comparing the elements in the third array with the elements in the fourth array one by one, and recording all the identified differences.
Referring to fig. 7, in an embodiment, the comparing the elements in the third array and the fourth array one by one includes steps S701 to S703:
s701, extracting corresponding elements in the third array and the fourth array;
s702, comparing the extracted elements one by one, and judging whether the extracted elements are consistent;
s703, marking the positions of the corresponding elements according to the judgment result.
In this embodiment, the corresponding elements are extracted from the third and fourth arrays containing detailed data from the respective rows of the current design data table and the history data table. The extracted elements are temporarily stored in a comparison cache ready for further detailed comparison. The system compares the extracted elements one by one to determine if they are consistent, inconsistent elements will be marked as difference terms, and consistent elements are confirmed as requiring no further operation. Based on the comparison, the system will visually identify where the inconsistent elements are, typically by changing the background color of the cell, adding an icon or other visual cue. This identification helps the user quickly identify changes or errors in the data table, supporting the data review and decision making process.
Referring to fig. 8 to fig. 10, in an embodiment, the identifying the location of the corresponding element according to the determination result includes steps S801 to S803:
S801, if the extracted elements are consistent, identifying the cells of the historical data table in which the elements are located in a first identification mode, and if the extracted elements are inconsistent, identifying the cells of the historical data table in which the elements are located in a second identification mode;
S802, if not, identifying the position of the element in the history data table, including:
identifying the row of the element in the history data table in a second identification mode;
S803, if not, updating the elements and the attributes in the first array into the history data table, including: updating the elements and the attributes in the first array to the last row of the historical data table, and identifying the last row in a second identification mode.
In this embodiment, if the cell values are consistent, the system identifies the corresponding cell in the history data table with a green background (in the first identification manner), which indicates that the data are consistent. If the cell values are not consistent, the system identifies the cell in the corresponding history data table with a red background (second identification mode), and highlights the difference, for example, the dark cell in fig. 10 is represented as an abnormal cell. If the device name in the current design data table does not exist in the history data table, the system automatically adds the device name and related attributes to the last row of the history data table, and sets the background color of the row to be red, and marks the row as a newly added item. If the device name in the history data table does not exist in the current design data table, the system sets the background color of the row in which the device is located to red, indicating that the device is no longer in use or updated.
The following is presented for the flow execution steps of fig. 9:
S901, starting;
S902, judging whether two data table templates are consistent, wherein one data table template is a historical data table, and one data table template is a current design data table, if not, directly entering S9017, and if so, entering S903;
s903, respectively taking the second columns of the two data tables as two arrays, wherein the array 1 is extracted from the current design data table, the array 2 is extracted from the history data table, and then respectively entering S904 (method 1) and S908 (method 2);
S904, circularly traversing the array 1, and entering S905;
s905, judging whether the elements in the array 1 exist in the array 2, if so, directly entering S9017, and if not, entering S906;
S906, updating the element and the attribute thereof to the last row of the data table 2 (namely, a history data table), and entering S907;
s907, the line background is set to "red", and S9016 is entered;
s9016, the element in the last column of the row in the data table 2 (i.e. the history data table) writes the comparison result, and finally goes to S9017.
S908, traversing the array 2 circularly, and entering S909;
S909, judging whether the element in the array 2 exists in the array 1, if not, entering S9010; if so, entering S9011;
s9010, setting the line background of the element in the most middle of the data table 2 (namely the history data table) to be red, and entering S9016;
s9011, respectively acquiring the rows of the element in the two data tables and taking the rows as an array 3 (corresponding to the current design data table) and an array 4 (corresponding to the history data table), and then entering S9012;
s9012, comparing each element of the array 3 and the array 4, and entering S9013;
S9013, judging whether the two types of the materials are consistent, if so, entering S9015, and if not, entering S9014;
s9014, setting the cell background of the element in the data table 2 (namely the history data table) to be red, and entering S9016;
S9015, setting the cell background of the element in the data table 2 (namely the history data table) to be green, and entering S9017;
S9016, writing a comparison result in the last column of the line where the element is in a data table 2 (namely a history data table), and finally entering S9017;
S9017, ending.
In summary, the invention avoids the risk of inconsistent reference to design parameters, and realizes unified and standardized management of various data sheet templates for file publishing or downstream funding in the process of designing a process system. The function ensures the consistency and standardization of design files and greatly improves the working efficiency. The invention also realizes the rapid and accurate extraction of the table data through a high-efficiency automatic extraction mechanism based on the digital flow chart, and reduces the requirement of manual operation and the error rate. When the design data is changed, the difference item between the historical data table and the latest data can be automatically identified, and the missing item can be rapidly updated.
Of course, for data table difference item identification, there is also an alternative scheme of developing plug-ins in Excel, using VB language programming to realize comparison of two Excel contents, carrying out color identification on the difference item, and adding comparison result description. Although the scheme can achieve similar functions, the invention provides a more integrated and automatic solution, and optimizes the operation flow and user experience.
Referring to fig. 11, fig. 11 is a schematic block diagram of an automatic design data extraction and identification system 1100 according to an embodiment of the present invention, where the automatic design data extraction and identification system includes:
A data establishing unit 1101, configured to establish a data table template; the data table template comprises names and attributes of equipment items, wherein the attributes comprise key attributes and associated attributes;
a first extracting unit 1102, configured to extract names and key attributes of equipment items from the flowchart database;
A second extracting unit 1103 for extracting the associated attribute of the equipment item from the attribute association database;
a data importing unit 1104, configured to import the name, the key attribute, and the associated attribute of the equipment item into the data table template, to obtain a current design data table;
The data identifying unit 1105 is configured to obtain a history data table, and identify a difference term between the history data table and the current design data table to obtain a difference comparison result.
In the present embodiment, the data creation unit 1101 creates a data table template; the data table template comprises names and attributes of equipment items, wherein the attributes comprise key attributes and associated attributes; the first extraction unit 1102 extracts names and key attributes of the device items from the flowchart database; the second extraction unit 1103 extracts the associated attribute of the device item from the attribute association database; the data importing unit 1104 imports the name, the key attribute and the associated attribute of the equipment item into the data table template to obtain a current design data table; the data identifying unit 1105 obtains a history data table, and identifies the difference item between the history data table and the current design data table, so as to obtain a difference comparison result.
In an embodiment, the data establishing unit 1101 includes:
The type matching unit is used for determining the template type and matching the corresponding equipment type and the data object type by utilizing the template type;
the first setting unit is used for setting the template content into a two-dimensional array; wherein the two-dimensional array comprises names of equipment items and names of attributes;
the second setting unit is used for taking the name of the attribute as a first header and the name of the equipment item as a second header;
And the third setting unit is used for integrating the first header and the second header, setting the extraction mode of each attribute and obtaining the data table template.
In one embodiment, the automatic design data extraction and identification system 1100 further includes:
a fourth setting unit, configured to set an association attribute table of the DDA code according to a design requirement, and set a pipe diameter and wall thickness comparison table and a drift diameter and outer diameter comparison table;
A table writing unit, configured to write the association attribute table, the pipe diameter and wall thickness comparison table, and the drift diameter and outer diameter comparison table into the attribute association database;
and the interface setting unit is used for setting an interface program for interaction for the attribute association database.
In an embodiment, the association attribute includes an association attribute associated with the DDA code, a wall thickness value, and an outer diameter value, and the second extracting unit 1103 includes:
the numerical value acquisition unit is used for acquiring the DDA code and the pipe diameter value of the equipment object item;
A first extracting unit, configured to extract, according to the DDA code, an association attribute associated with the DDA code from the attribute association database;
The second extraction unit is used for extracting a wall thickness value from the attribute association database according to the DDA code and the pipe diameter value;
and the third extraction unit is used for extracting the outer diameter value from the attribute association database according to the pipe diameter value.
In an embodiment, the data importing unit 1104 includes:
the numerical value writing back unit is used for forming a two-dimensional array by the names of the equipment items and the attributes of the equipment items, and writing back the two-dimensional array into a form display control;
and the numerical driving unit is used for automatically generating the current design data table based on the data table export function of the table display control by taking the data table template as a driving condition.
In an embodiment, the data identifying unit 1105 includes:
the numerical value judging unit is used for judging whether the template format of the current design data table is consistent with the template format of the historical data table;
If not, not carrying out difference item identification;
If yes, respectively traversing the cells of the current design data table and the historical data table in a circulating way, comparing one by one, and recording a difference item to obtain a difference comparison result.
In an embodiment, the data identifying unit 1105 further includes:
And the result importing unit is used for recording the difference comparison result in the historical data table.
In one embodiment, the automatic design data extraction and identification system 1100 further includes:
The control calling unit is used for calling a method for exporting a file by a form display control;
And the file generation unit is used for exporting the difference comparison result based on the form display control export file method to obtain the file to be checked.
In one embodiment, the numerical value judging unit includes:
The numerical value traversing unit is used for respectively and circularly traversing corresponding cells of the current design data table and the historical data table to obtain a first array and a second array;
The first judging unit is used for judging whether the elements in the first array are in the second array, if so, continuing to traverse the next cell, and if not, updating the elements and the attributes in the first array into the historical data table, and continuing to traverse the next cell;
And the second judging unit is used for judging whether the element in the second array is in the first array, if so, continuing to traverse the next cell, and if not, marking the position of the element in the history data table, and continuing to traverse the next cell.
In an embodiment, the first array and the second array are obtained by traversing cells in the same column of the current design data table and the historical data table; the second judging unit includes:
A third judging unit, configured to continuously traverse cells of a row where elements of the second array are located in the history data table if yes, and traverse cells of the same row of the current design data table to obtain a third array and a fourth array;
and the array comparison unit is used for comparing the elements in the third array and the fourth array one by one.
In one embodiment, the array comparison unit includes:
The element extraction unit is used for extracting corresponding elements in the third array and the fourth array;
the element comparison unit is used for comparing the extracted elements one by one and judging whether the extracted elements are consistent;
the element marking unit is used for marking the position of the corresponding element according to the judging result.
In an embodiment, the element marking unit includes:
a fourth judging unit, configured to identify, if the extracted elements are consistent, a cell in the history data table where the element is located in a first identification manner, and if the extracted elements are inconsistent, identify, if the extracted elements in the history data table where the element is located in a second identification manner;
a fifth judging unit, configured to identify, if not, a location of the element in the history data table, where the element is located, where the fifth judging unit includes: identifying the row of the element in the history data table in a second identification mode;
A sixth judging unit, configured to update the elements and attributes in the first array to the history data table if not, where the sixth judging unit includes: updating the elements and the attributes in the first array to the last row of the historical data table, and identifying the last row in a second identification mode.
Since the embodiments of the apparatus portion and the embodiments of the method portion correspond to each other, the embodiments of the apparatus portion are referred to the description of the embodiments of the method portion, and are not repeated herein.
The embodiment of the present invention also provides a computer readable storage medium having a computer program stored thereon, which when executed can implement the steps provided in the above embodiment. The storage medium may include: a U-disk, a removable hard disk, a Read-Only Memory (ROM), a random access Memory (RandomAccess Memory, RAM), a magnetic disk, or an optical disk, or other various media capable of storing program codes.
The embodiment of the invention also provides a computer device, which can comprise a memory and a processor, wherein the memory stores a computer program, and the processor can realize the steps provided by the embodiment when calling the computer program in the memory. Of course, the computer device may also include various network interfaces, power supplies, and the like.
In the description, each embodiment is described in a progressive manner, and each embodiment is mainly described by the differences from other embodiments, so that the same similar parts among the embodiments are mutually referred. For the system disclosed in the embodiment, since it corresponds to the method disclosed in the embodiment, the description is relatively simple, and the relevant points refer to the description of the method section. It should be noted that it will be apparent to those skilled in the art that various modifications and adaptations of the application can be made without departing from the principles of the application and these modifications and adaptations are intended to be within the scope of the application as defined in the following claims.
It should also be noted that in this specification, relational terms such as first and second, and the like are used solely to distinguish one entity or action from another entity or action without necessarily requiring or implying any actual such relationship or order between such entities or actions. Moreover, the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or apparatus. Without further limitation, an element defined by the phrase "comprising one … …" does not exclude the presence of other like elements in a process, method, article, or apparatus that comprises the element.
Claims (13)
1. The automatic extraction and identification method for the design data is characterized by comprising the following steps of:
Establishing a data table template; the data table template comprises names and attributes of equipment items, wherein the attributes comprise key attributes and associated attributes;
extracting names and key attributes of equipment items from a flow chart database;
extracting associated attributes of the equipment items from the attribute association database;
importing the names, key attributes and associated attributes of the equipment items into the data table template to obtain a current design data table;
and acquiring a historical data table, and identifying a difference item between the historical data table and the current design data table to obtain a difference comparison result.
2. The automatic extraction and identification method of design data according to claim 1, wherein the associated attributes include an associated attribute associated with DDA code, a wall thickness value, and an outer diameter value, and the extracting the associated attributes of the equipment items from the attribute association database includes:
Acquiring a DDA code and a pipe diameter value of the equipment item;
Extracting association attributes associated with the DDA codes from the attribute association database according to the DDA codes;
extracting a wall thickness value from the attribute association database according to the DDA code and the pipe diameter value;
And extracting an outer diameter value from the attribute association database according to the pipe diameter value.
3. The method for automatically extracting and identifying design data according to claim 1, wherein the importing the names, key attributes and associated attributes of the equipment items into the data table template to obtain the current design data table comprises:
forming a two-dimensional array by the names of the equipment items and the attributes of the equipment items, and writing the two-dimensional array back into a form display control;
and taking a data table template as a driving condition, and automatically generating the current design data table based on a data table export function of the table display control.
4. The method for automatically extracting and identifying design data according to claim 1, wherein the step of identifying the difference term between the historical data table and the current design data table to obtain a difference comparison result comprises the steps of:
Judging whether the template format of the current design data table is consistent with the template format of the historical data table;
If not, not carrying out difference item identification;
If yes, respectively traversing the cells of the current design data table and the historical data table in a circulating way, comparing one by one, and recording a difference item to obtain a difference comparison result.
5. The method for automatically extracting and identifying design data according to claim 4, wherein the steps of respectively traversing the cells of the current design data table and the historical data table in a circulating way, comparing one by one, and recording difference items to obtain a difference comparison result comprise the steps of:
Respectively circularly traversing corresponding cells of the current design data table and the historical data table to obtain a first array and a second array;
Judging whether the elements in the first array are in the second array, if so, continuing to traverse the next cell, and if not, updating the elements and the attributes in the first array into the historical data table, and continuing to traverse the next cell;
And judging whether the element in the second array is in the first array, if so, continuing to traverse the next cell, and if not, marking the position of the element in the history data table, and continuing to traverse the next cell.
6. The automatic extraction and recognition method of design data according to claim 5, wherein the first array and the second array are obtained by traversing cells in the same column of the current design data table and the historical data table;
And judging whether the element in the second array is in the first array, if so, continuing to traverse the next cell, wherein the judging comprises the following steps:
if yes, continuing to traverse the cells of the row where the elements of the second array are located in the historical data table and traversing the cells of the same row of the current design data table to obtain a third array and a fourth array;
and comparing the elements in the third array with the elements in the fourth array one by one.
7. The method for automatically extracting and identifying design data according to claim 6, wherein the comparing the elements in the third array and the fourth array one by one includes:
Extracting corresponding elements in the third array and the fourth array;
comparing the extracted elements one by one, and judging whether the extracted elements are consistent;
and marking the positions of the corresponding elements according to the judgment result.
8. The method for automatically extracting and identifying design data according to claim 7, wherein the identifying the location of the corresponding element according to the determination result includes:
if the extracted elements are consistent, marking the cells of the elements in the historical data table in a first marking mode, and if the extracted elements are inconsistent, marking the cells of the elements in the historical data table in a second marking mode;
And if not, identifying the position of the element in the history data table, wherein the identification comprises the following steps:
identifying the row of the element in the history data table in a second identification mode;
If not, updating the elements and the attributes in the first array into the history data table, including: updating the elements and the attributes in the first array to the last row of the historical data table, and identifying the last row in a second identification mode.
9. The method for automatically extracting and identifying design data according to claim 1, wherein said identifying the difference term between the historical data table and the current design data table to obtain a difference comparison result, further comprises:
And recording the difference comparison result in the historical data table.
10. The method for automatically extracting and identifying design data according to claim 1, wherein the creating a data table template comprises:
determining a template type, and matching a corresponding equipment type and a corresponding data object type by utilizing the template type;
Setting the template content as a two-dimensional array; wherein the two-dimensional array comprises names of equipment items and names of attributes;
Taking the name of the attribute as a first header and the name of the equipment item as a second header;
and integrating the first header and the second header, and setting an extraction mode of each attribute to obtain the data table template.
11. The method for automatically extracting and identifying design data according to claim 1, further comprising, before the step of extracting the associated attribute of the equipment item from the attribute association database:
setting an associated attribute table of the DDA code according to design requirements, and setting a pipe diameter and wall thickness comparison table and a drift diameter and outer diameter comparison table;
Writing the association attribute table, the pipe diameter and wall thickness comparison table and the drift diameter and outer diameter comparison table into the attribute association database;
and setting an interface program for interaction for the attribute association database.
12. The method for automatically extracting and identifying design data according to claim 1, wherein after the step of obtaining the history data table and identifying the difference item between the history data table and the current design data table to obtain the difference comparison result, further comprises:
calling a method for exporting files by a form demonstration control;
And exporting the difference comparison result based on the method for exporting the file by the form display control to obtain the file to be checked.
13. An automatic extraction and recognition system for design data, comprising:
The data establishing unit is used for establishing a data table template; the data table template comprises names and attributes of equipment items, wherein the attributes comprise key attributes and associated attributes;
a first extraction unit for extracting names and key attributes of equipment items from a flowchart database;
a second extraction unit for extracting the associated attribute of the equipment item from the attribute association database;
the data importing unit is used for importing the names, the key attributes and the associated attributes of the equipment items into the data table template to obtain a current design data table;
The data identification unit is used for acquiring a historical data table, and carrying out difference item identification on the historical data table and the current design data table to obtain a difference comparison result.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN202410663560.9A CN118377808A (en) | 2024-05-27 | 2024-05-27 | Automatic extraction and identification method and system for design data |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN202410663560.9A CN118377808A (en) | 2024-05-27 | 2024-05-27 | Automatic extraction and identification method and system for design data |
Publications (1)
Publication Number | Publication Date |
---|---|
CN118377808A true CN118377808A (en) | 2024-07-23 |
Family
ID=91911659
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN202410663560.9A Pending CN118377808A (en) | 2024-05-27 | 2024-05-27 | Automatic extraction and identification method and system for design data |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN118377808A (en) |
-
2024
- 2024-05-27 CN CN202410663560.9A patent/CN118377808A/en active Pending
Similar Documents
Publication | Publication Date | Title |
---|---|---|
KR102330547B1 (en) | Building reports | |
KR101013810B1 (en) | An excel-based management system for updating db tables and the method thereof | |
JP5570608B2 (en) | Excel-based analysis report creation system and method | |
RU2406115C2 (en) | Accessing complex data | |
EP3493050A1 (en) | System for metadata management | |
CN110738027B (en) | Computer-implemented method, apparatus, and storage medium for generating spreadsheet formulas | |
CN102314424A (en) | Dimension-based relational graph of files | |
CN111143370B (en) | Method, apparatus and computer-readable storage medium for analyzing relationships between a plurality of data tables | |
CN110738037A (en) | Method, apparatus, device and storage medium for automatically generating electronic form | |
US5651101A (en) | Knowledge base system for setting attribute value derivation data independently from attribute value derivation procedure and shared data management apparatus for selectively locking attribute | |
CN116028653B (en) | Method and system for constructing map by visually configuring multi-source heterogeneous data | |
CN110795524A (en) | Main data mapping processing method and device, computer equipment and storage medium | |
CN112016287A (en) | Data management method, platform, storage medium and electronic device | |
CN113190694A (en) | Knowledge management platform of knowledge graph | |
CN117392269B (en) | Pipe network drawing data extraction method and device | |
WO2020118354A1 (en) | Improved spreadsheet and method for updating same | |
CN111191429A (en) | System and method for automatic filling of data table | |
US20030110175A1 (en) | Deploying predefined data warehouse process models | |
CN105260300A (en) | Service test method based on CAS (General Classification Standards of China Accounting Standards) application platform | |
CN109636303B (en) | Storage method and system for semi-automatically extracting and structuring document information | |
US20240036890A1 (en) | System and method of a modular framework for configuration and reuse of web components | |
Shafiq et al. | Application of signature-based matching for IFC model comparison | |
CN118377808A (en) | Automatic extraction and identification method and system for design data | |
JP7022472B1 (en) | Data management system, data management method and data management program | |
JP6775740B1 (en) | Design support device, design support method and design support program |
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 |