CN111462327A - Three-dimensional modeling software three-dimensional inspection model unstructured data analysis method - Google Patents
Three-dimensional modeling software three-dimensional inspection model unstructured data analysis method Download PDFInfo
- Publication number
- CN111462327A CN111462327A CN202010171173.5A CN202010171173A CN111462327A CN 111462327 A CN111462327 A CN 111462327A CN 202010171173 A CN202010171173 A CN 202010171173A CN 111462327 A CN111462327 A CN 111462327A
- Authority
- CN
- China
- Prior art keywords
- data
- dimensional
- model
- unstructured
- information
- 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.)
- Granted
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06T—IMAGE DATA PROCESSING OR GENERATION, IN GENERAL
- G06T17/00—Three dimensional [3D] modelling, e.g. data description of 3D objects
- G06T17/20—Finite element generation, e.g. wire-frame surface description, tesselation
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/30—Information retrieval; Database structures therefor; File system structures therefor of unstructured textual data
- G06F16/31—Indexing; Data structures therefor; Storage structures
- G06F16/313—Selection or weighting of terms for indexing
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/80—Information retrieval; Database structures therefor; File system structures therefor of semi-structured data, e.g. markup language structured data such as SGML, XML or HTML
- G06F16/84—Mapping; Conversion
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Software Systems (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- General Engineering & Computer Science (AREA)
- Computer Graphics (AREA)
- Geometry (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses an unstructured data analysis method for a three-dimensional inspection model of three-dimensional modeling software, and aims to provide an unstructured data analysis method which can improve the compatibility and the applicability of a system and can be smoothly identified or used. The invention is realized by the following technical scheme: according to the internal connection of three-dimensional modeling software, a three-dimensional vector finite element calculation flow based on a three-dimensional modeling unstructured grid is established, when data are stored, assembly nodes in an assembly digital-to-analog structure are stored in a design end product data management system in a structure presentation mode to serve as a manufacturing end PDM system of an application layer, an assembly part document is regenerated according to a position coordinate matrix recorded in a database, an unstructured three-dimensional model data analyzer is introduced into the manufacturing end PDM system to construct an unstructured three-dimensional model data analyzer, geometric data and non-geometric data in three-dimensional model data and required non-geometric data labels are analyzed, and all xml information is converted into identifiable unstructured three-dimensional model data.
Description
Technical Field
The invention relates to a visual unstructured three-dimensional model data analysis method for analyzing unstructured data (unstructured data) of a three-dimensional inspection model of three-dimensional modeling software into a computer understandable format.
Background
The data in the world is growing in an explosive situation, wherein the content of unstructured data occupies 80% of the current data sea, and more than 80% of the data can be unstructured data with greater processing difficulty, the exponentially growing data volume makes it almost impossible to use manual work to complete the data management process, and computers become important tools for data management, however, most computer software can only understand certain data with specific structures according to preset programs, so that computers do not seem to be distracting when managing unstructured data.
The unstructured data is more easily represented by the unstructured data in a more general structured data system than the structured data in a more general structured data system, the unstructured data is more easily represented by the structured data in a more general structured data system than the structured data in a more general structured data system, the structured data is more easily represented by the structured data in a more general structured data system than the structured data in a more general structured data system, the structured data in a more general structured data, the more difficult structured data in a more general structured data, more difficult structured data, more information.
One difficulty with unstructured data storage is that the content of metadata to be extracted cannot be determined in advance, and the content and format of the metadata may change as the system requirements change. In fact, pure unstructured data is not present. Firstly, the unstructured data may contain partially structured information and many different types of features, wherein the unstructured data may contain data with format information, such as tables; secondly, the unstructured data can be converted into structured data under the translation of a proper interpreter, and structured meta information such as a data storage mode, a data producer, a data transmission mode and even data can be extracted from the unstructured data. Relational databases the files used to store data, which are unstructured before database management loads and parses, are typically binary files stored on disk. The method has the defects that the structure is complex, the implementation difficulty is increased, in addition, the machine can automatically mine and understand the structured part in the unstructured data through means of machine learning, natural language processing and the like, and the structure of the data is learned according to the method. The data generally has two storage modes, the first mode is to store the data in a file system and store a file link in a database, and the mode has certain safety problem and needs extra work to ensure the ACID characteristic of a transaction; the other mode is that large data types provided by a database system are used for storage, such as Blob of Oracle, the mode increases IO work in the database query process, and therefore efficiency is low, some database systems provide a columnar storage model to solve the problem, metadata is used as the feature of unstructured data, and compared with original data, the metadata has certain structurality, and the feature can be described by using a feature type and a feature value binary group, so that a corresponding relation exists between the metadata and an entity of a relational data model. Second, the complexity of unstructured data determines the versatility of its metadata type, and even unstructured data of similar types may exist in disparate metadata types. Due to the diversity of unstructured data, the whole entity relationship model is abnormally bloated, and therefore the complexity of a data management program is increased. One difficulty with unstructured data storage is that the content of metadata to be extracted cannot be determined in advance, and the content and format of the metadata may change as the system requirements change. Over time and with the increasing number of users, the original data scheme is gradually faced with some problems: the application system is frequently changed, so that new and old data are difficult to be compatible; the system needs to process a large amount of unstructured data, and the management requirement is variable; the data volume is larger and larger, the original copying technology not only wastes the storage space, but also can not improve the execution efficiency of single complex query operation. If the structure is complicated, the difficulty of implementation is increased.
In a modern manufacturing enterprise, process data is the most important and basic technical data for the transformation of the process data of the enterprise. For a long time, due to the lack of professional auxiliary software support, in the information society, the data types of information are mainly three types: the traditional process is mostly manually compiled by office software, and the process data mostly exist in an independent electronic document form. With the lapse of time, process data accumulate day by day, the data volume is huge, and is dispersedly stored in an unstructured data form, the process data sharing and the reusability are poor, the knowledge contained in the data resources cannot be fully mined and utilized, and the problems of abundant data and poor knowledge are very serious. The traditional process rule usually relies on WORD software to create a one-dimensional table and describe process information in the form of the one-dimensional table, and belongs to a typical unstructured data type.
With the rapid development of information technology, the method and means for designing products in the mechanical industry undergo the leap-type development from manual drawing to two-dimensional CAD technology and then to three-dimensional modeling technology, the transformation from planar projection technology to full three-dimensional model digital prototype and complete digital product definition is realized, and the analysis and verification of product performance and manufacturing capability are finished by relying on a computer application system more and more. The three-dimensional labeling technology really opens the full three-dimensional digital design and manufacturing era, really realizes the three-dimensional digital and drawing-free design and manufacturing technology, enables the two-dimensional engineering drawing or the engineering drawing to become history, is no longer the manufacturing authority basis even if the two-dimensional engineering drawing or the engineering drawing exists, and is only an auxiliary expression mode of data under specific conditions. However, although the product design process has all the engineering and manufacturing information contained in the three-dimensional model, when the data of the three-dimensional model is transmitted to the product manufacturing process, the data is stored in an unstructured mode, and only special tool software, such as typical unstructured three-dimensional modeling software CATIA, UG and the like, can be used for analyzing and extracting the data for being identified or applied by a relevant technician or an information system. These software relational databases are unstructured before the files used to store the data, which are typically binary files stored on disk, are loaded and parsed by the database management. Metadata is used as the characteristics of unstructured data, and the characteristics are divided into basic attributes, semantic characteristics, bottom-layer characteristics and original data to represent the data into dimensions, variables, attributes and original data. However, the metadata of unstructured data is not necessarily able to simply correspond. First, the data type of metadata is not necessarily an atomic type, and may be a list or even unstructured data, so the actual corresponding result is a tree structure. The complexity of unstructured data determines the versatility of its metadata types, even though unstructured data of similar types may exist in disparate metadata types. The complexity of unstructured data makes it often inadequate to utilize views alone, and database management systems typically do not support update operations across table views. With the increase of time and user quantity, the original data scheme gradually faces some problems that an application system is frequently changed, so that new and old data are difficult to be compatible; the system needs to process a large amount of unstructured data, such as logs and images, and the management requirements are variable; the data volume is larger and larger, the original copying technology not only wastes the storage space, but also can not improve the execution efficiency of single complex query operation. The unstructured data structure is complex, the realization difficulty is high, and the problem of management and data version compatibility is difficult to solve.
The three-dimensional modeling software CATIA adopts a characteristic modeling and parametric modeling technology, has a unified user interface, data management and compatible database and application program interfaces, can watch the model from any direction, is easier to visually inspect the structure of a part and interfere among the parts, and greatly depends on the conformity of dimensional constraints in a two-dimensional graph and physical parameters.
Disclosure of Invention
The invention provides a three-dimensional modeling software unstructured three-dimensional model data analysis method which can improve the compatibility and the applicability of a system and can be smoothly identified or used, and solves the problems that the three-dimensional modeling software unstructured three-dimensional model data analysis method in the prior art cannot be conveniently identified or applied in the whole design, manufacture and inspection process, and the application environment is greatly limited.
The method comprises the steps of firstly, establishing a three-dimensional MT vector finite element calculation process based on a three-dimensional modeling unstructured grid according to the internal relation between basic attributes, semantic features, bottom layer features and original data composition elements of unstructured data of the three-dimensional modeling software, storing assembly nodes in a design end product data management system in a structural presentation mode as a manufacturing end product data management PDM system of an application layer, regenerating a document assembly according to a position coordinate matrix recorded in a database, importing the assembly nodes into the manufacturing end product data management PDM system, constructing a file format definition module, a data abstract merging module, an object retrieval and distribution module, a data query analysis module, a data storage module and an exception processing module, sequentially forming an unstructured three-dimensional model data parser, wherein the file format definition module imports an assembly data database, extracts inheritance relationship information in a text, stores inherited data in a sub-format, extracts inherited data from a data storage module, extracts the inherited data of a model, stores the inherited data in a model, stores the extracted and inherited data in a model, and updated information storage module, extracts the model, stores the data in a model, extracts the model, stores the model, reads the data in a geometric data storage module, reads the model, reads the data of a geometric data storage module, the model, reads the model, the data, the model, the data is stored in the model, the data is stored in the model, the data management module, the model, the data is stored in the model, the data is stored in the model, the model.
Compared with the prior art, the invention has the following beneficial effects.
According to the invention, a three-dimensional MT vector finite element calculation process based on a three-dimensional modeling unstructured grid is established according to the basic attributes, semantic features, bottom layer features and internal relations among original data composition elements of three-dimensional modeling software unstructured data, and after configuration information of a data abstraction merging module is shared, data query requests from different application systems can be processed in a non-interfering manner by each calculation process, so that concurrent query operation is supported. The computing process can also adopt a mode similar to MapReduce, and the parallel processing of merging the query results is realized. The three-dimensional model data is converted from the unstructured storage mode to the structured storage mode, so that the application environment of the unstructured three-dimensional model data is greatly expanded, the unstructured three-dimensional model data can be conveniently identified or applied in the whole design, manufacture and inspection processes, the informatization development of the manufacturing industry can be smoothly carried out, and the data management and application level of enterprises can be improved.
The data query analysis module is used for segmenting data based on types according to query fields, loading structural tree information of three-dimensional model data into an unstructured three-dimensional model data model, converting an unstructured storage mode into a structured storage mode from the three-dimensional model data, respectively generating structured document data and unstructured model data into corresponding xml and file extension GEOM files, executing data analysis operation, and forwarding sub-queries to other computing nodes (Map); different query conditions may be added to a particular field in a sub-query to segment the query according to that field. This is especially important for the consolidation of large numbers of query results. The object retrieval and distribution module automatically completes the decomposition of the query and the mapping of the sub-query, different sub-tables are stored in different physical databases, the working process of the system is not influenced actually, the subclassing can be automatically carried out on the class with overlarge data volume, and the transparent data segmentation (Partition) based on the type is realized. Image attributes, height, width and compression format of images with resolutions up to 46000x46000 are extracted. The method is characterized in that a format graph is created and is easy to self-define by using a powerful programming method driven by a model, information can be managed, protected, inquired and managed by the highest level of performance, and the guidance on services can be realized by easy scheduling and use; second, it may not rely on dedicated application or device logic.
The invention adopts a data storage module which takes semi-structured XM L as a bridge, adopts the gradual conversion of unstructured data → semi-structured data → structured data to realize the conversion from unstructured data to structured data, stores geometric data as a file extension GEOM file, stores the non-geometric data as an xml file, defines a data table according to the hierarchical relationship of the structured data and a three-dimensional model structure tree after storage and analysis, stores the data table between two product data management PDMs of a flow in a system in a structural presentation form, and stores the data table in a distributed manner in a relational database, thereby breaking through the storage capacity limit of a single host, eliminating the isomerism and inconsistency of the data, helping to realize the conversion of the isomerism data, ensuring that the data access process of single query is completed in parallel and improving the input and output efficiency.
The method comprises the steps of reading an xml file of a feature tree of a three-dimensional modeling software part by adopting an exception handling module, extracting structure tree information, generating the information such as a parameter name, a parameter value and a geometric figure set into the xml file, sequentially writing geometric tolerance marking information associated with a model into the same xml file, respectively marking data on all the information according to xml tags, collecting scattered unstructured data together to form a complete data set of the xml file generated by the information such as the parameter name, the parameter value and the geometric figure set, and forming a complete geometric view. After data are collected, the data can go deep into the industry, professional knowledge of the industry is formed, the business is ploughed in deeply, the use threshold of the algorithm is fully reduced, the value of the data is fully exerted, and the visual angle of each BU for viewing the data is no longer isolated and is no longer limited. Meanwhile, a format definition module is added to support data conversion of unstructured files with the same type and different structures, and functions of the system are further improved. On the basis, the performance of the initial system is optimized, so that the large data file is analyzed, mass data can be quickly imported, and the compatibility and the applicability of the system are improved.
The invention is suitable for storing and processing large-scale unstructured data. The unstructured data is converted to structured data.
Drawings
The present invention is illustrated and described with reference to the accompanying drawings, where like method steps/system components are optionally identified, and in which:
FIG. 1 is a flow chart of the unstructured data parser of the three-dimensional modeling software three-dimensional inspection model of the present invention.
Detailed Description
According to the method, firstly, a three-dimensional MT vector finite element calculation process based on a three-dimensional modeling unstructured grid is established according to the internal relation between the basic attribute, semantic feature, bottom layer feature and original data composition elements of three-dimensional modeling software unstructured data, when three-dimensional model data is stored, assembly nodes in an assembly digital-to-analog structure are stored in a design end product data management PPDM system in a structure presentation form, a manufacturing end product data management PDM system serving as an application layer is used, assembly documents are regenerated according to position coordinate matrixes recorded in a database and are imported into a manufacturing end product data management PDM system, secondly, a file format definition module is established, a data abstract merging module, an object retrieval and distribution module, a data query analysis module, a module data storage module and an exception processing module form, an unstructured three-dimensional model data parser is formed according to sequence, wherein the file format definition module imports assembly text data into a database, fields in each assembly text data document data are extracted and inserted into a target database, a data query and are sequentially formed, a three-dimensional data query model, a model is stored in a model, a model management sub-dimensional data storage sub-element management file is stored, a model is stored in a model, a model management sub-data management sub-file is stored, a model is automatically read, a sub-element management sub-file is stored, a sub-file is automatically stored in a model, a model management sub-data management sub-file is automatically stored, a model management sub-file is automatically stored, a model file is stored in a model management sub-file, a model management sub-file is automatically stored, a sub-file is automatically stored, a sub-file is stored, a sub-information management sub-file is automatically stored, a sub-file is automatically read, a sub-file is stored, a sub-file is automatically read, a sub-file is stored, a sub-file is automatically stored, a sub-file is automatically read, a sub-file is stored, a sub-file is automatically stored, a sub-file is stored.
The required non-geometric data tags include: part number, part name, version, weight, and comment tag information.
The information of the relational database table includes: table names, field names, data types, field lengths, value constraints, primary foreign key constraints, and the like. The tables are very convenient to query and count, simple to operate and easy to maintain.
The user can specify the code of a specific interface realized by a high-level language, the data abstraction merging module carries out format conversion according to a processing mode configured by the user, the user code is called through a reflection mechanism of the high-level language, a configuration result is converted into a format required by the user, then each sub-query data is connected, all elements in the Join array are placed into one character for sequencing and grouping, the query results of each sub-query are merged, and the data conversion process is completed, so that the compatibility of an original application system based on a relational database is realized. In implementation, the data abstraction merging module can also be completed by using a process independent from the actual database system, and a computing process can be generally merged with the process of the data query parsing and distributing module.
The object retrieval and distribution module receives and analyzes the query statement of the data user, and distributes the query to the actual database management system according to the mapping relation provided by the data abstract merging module.
The object retrieval and distribution module adopts a heuristic optimization scheme and a characteristic cache to carry out query optimization, reads the configuration information of the data abstraction merging module, automatically maps the configuration information subclass to the physical data table, and carries out separate processing on data query and data write-in operation, and automatically expands a new class to modify the format of the data table. In actual implementation, this module is done by a process that is independent of the actual database management system.
In a practical system, the data storage module is composed of independent database systems, and the databases may be ordinary database systems or some database systems specially designed for meeting polymorphic functions. The data do not show the relationship among the data in the module, and the relationship information is maintained by the data abstract merging module.
In an optional embodiment, the exception handling module adopts different conversion rules to convert xml files generated by parameter names, parameter values and geometric figure sets into standard XM L documents respectively, analyzes the mapping relation between the XM L document and a relational database, creates a simulation result table structure in the database according to a generated file template through structure mapping and semantic mapping, converts the XM L document into a relational database table according to the conversion rules, creates a management module to acquire and manage the file structure required in the unstructured file conversion process, and stores corresponding information into the corresponding database table, so that the conversion process becomes a whole.
The abnormal processing module reads a corresponding XM L document according to information in the template based on a relational database, extracts metadata of a document template document, analyzes the XM L document by using an analysis tool, extracts data content in the document, distinguishes the template document by using a uniform conversion interface, converts the structure of the template document by using different programs respectively to generate a one-to-many relation standard structure document, then selects a document template, guides data in a plurality of simulation output documents into the same database table, inserts the standard structure document into a created result table, and completes data conversion from semi-structured to structured.
In the modeling specification, all the data expressed in the form of a structure tree and a parameter are structured data and can be viewed in a text mode; all the information contained in the geometric model is unstructured data and is expressed in a binary manner.
In another optional embodiment, the exception handling module stores the geometric data of the unstructured three-dimensional model as an extension file, extension geo file, and stores the non-geometric data as an extension xml file, wherein the extension geo file is still reserved as an unstructured storage mode, and the xml file meeting the international uniform requirement is defined in a tag mode, for example, "PartNumber" is a tag, and its value is a specific part drawing number. And the xml file is converted into a structured storage mode according to the label definition. During conversion, if structured data expressed in a structure tree form and a parameter form is encountered, an xml file is written, and unstructured data such as the rest geometric model information and the like are reserved.
And the exception handling module is used for handling exception errors occurring in the data analysis and storage module execution process. When the three-dimensional model data is analyzed, the analyzer automatically opens the model in a program background and extracts the structure tree information; generating an xml file from information such as parameter names, parameter values, geometric figure sets and the like; writing the 'geometric tolerance marking' information associated with the model into the same xml file in sequence, and marking all the information according to xml tags respectively; the three-dimensional model is stored in a file extension GEOM format and can be opened and viewed by special graphic software; after the suffix is changed into a file extension GEOM and an xml file, the suffix can only be opened by special graphic software, and the suffix can be opened by any text editor. All xml information is eventually stored in a database table defined in advance.
And traversing the whole structural tree information by the exception handling module according to the modeling specification, reading a file with a CATPArt suffix and an xml file of a product and a part with a CATProduct suffix in a CATIA three-dimensional model database in the unstructured three-dimensional model, analyzing the tag information of the xml file and a required non-geometric data tag, traversing the whole xml tag during analysis, reading tag values in a one-to-one correspondence manner, generating a file extension GEOM file for storing the xml file of the structured data and the unstructured data, and storing the tag information of the xml file.
The anomaly processing module defines a data table according to the hierarchical relationship of a structure tree of a CATIA (computer-graphics aided three-dimensional interactive application) at a manufacturing end, separates out non-geometric data from non-structural three-dimensional model data, analyzes the geometric data and the non-geometric data of the structural relationship in the CATIA three-dimensional model, analyzes the structural tree information of the three-dimensional model data, distinguishes the geometric data and the non-geometric data, performs information characteristic identification according to modeling specifications, stores the analyzed xml file label information in a relational database in a data table mode according to the hierarchical relationship of the CATIA structure tree, and stores the analyzed structural data in a database table.
When the three-dimensional model data is analyzed, the analyzer automatically opens the model in a program background and extracts the structure tree information; generating an xml file from information such as parameter names, parameter values, geometric figure sets and the like; writing the 'geometric tolerance marking' information associated with the model into the same xml file in sequence, and marking all the information according to xml tags respectively; the three-dimensional model is stored in a file extension GEOM format and can be opened and viewed by special graphic software; all xml information is eventually stored in a database table defined in advance. After the suffix is changed into a file extension GEOM and an xml file, the suffix can only be opened by special graphic software, and the suffix can be opened by any text editor.
Although the invention has been illustrated and described above with reference to preferred embodiments and specific examples thereof, those skilled in the art will readily appreciate that other embodiments and examples may perform similar functions and/or achieve similar results. It is therefore to be understood that all such equivalent embodiments and examples are within the spirit and scope of the present invention and are intended to be covered by the appended claims.
Claims (10)
1. A method for analyzing unstructured data of three-dimensional modeling software three-dimensional inspection model includes such steps as creating three-dimensional MT vector finite element calculation flow based on three-dimensional modeling unstructured grid according to internal relation between basic attribute, semantic feature, bottom layer feature and original data constituting elements of three-dimensional modeling software unstructured data, storing assembly nodes in design end product data management PPDM system in structure presentation mode, creating assembly document according to position coordinate matrix recorded in database, importing it into manufacture end product data management PDM system, creating file format definition module, data abstract merging module, object retrieval and distribution module, data query analysis, module data storage module and exception processing module, forming unstructured three-dimensional model data analyzer in sequence, importing assembly text data into three-dimensional data base, inserting each piece of text data in assembly document into data base, extracting and storing each piece of document data in model, extracting and storing them in model, storing them in model storage system, extracting and storing them in model storage system, extracting their corresponding to model information, extracting and storing them in model, extracting their corresponding to model, extracting their corresponding data, extracting their corresponding to their associated data, storing them, and storing them in model, extracting their associated data, storing them, and storing them in model, extracting their associated data, and storing them in their associated data, storing them in model, storing them in their associated data, the model, extracting their associated data, storing them in model, the model management model, the model
And sequentially writing the marking information into the same xml file, respectively marking data on all the information according to xml tags, analyzing and processing the data and abnormal errors generated in the execution process of the storage module, converting all the xml information into unstructured three-dimensional model data which can be identified and used, and storing the unstructured three-dimensional model data in a database table which is defined in advance.
2. The method for analyzing unstructured data of the three-dimensional inspection model of the three-dimensional modeling software according to claim 1, characterized in that: the non-geometric data tag includes: part number, part name, version, weight, and comment tag information.
3. The method for analyzing unstructured data of the three-dimensional inspection model of the three-dimensional modeling software according to claim 1, characterized in that: the information of the relational database table includes: table name, field name, data type, field length, value constraints, and primary foreign key constraints.
4. The method for analyzing unstructured data of the three-dimensional inspection model of the three-dimensional modeling software according to claim 1, characterized in that: the data abstraction merging module carries out format conversion according to a processing mode configured by a user, calls a user code through a reflection mechanism of a high-level language, converts a configuration result into a format required by the user, then connects each sub-query data, puts all elements in the Join array into a character for sequencing and grouping, combines the query results of each sub-query, and completes a data conversion process so as to realize the compatibility of the original application system based on the relational database.
5. The method for analyzing unstructured data of the three-dimensional inspection model of the three-dimensional modeling software according to claim 1, characterized in that: the object retrieval and distribution module receives and analyzes the query statement of the data user, and distributes the query to the actual database management system according to the mapping relation provided by the data abstract merging module.
6. The method for analyzing unstructured data of the three-dimensional inspection model of the three-dimensional modeling software according to claim 1, characterized in that: the object retrieval and distribution module adopts a heuristic optimization scheme and a characteristic cache to carry out query optimization, reads the configuration information of the data abstraction merging module, automatically maps the configuration information subclass to the physical data table, and carries out separate processing on data query and data write-in operation, and automatically expands a new class to modify the format of the data table.
7. The method for analyzing unstructured data of the three-dimensional modeling software three-dimensional inspection model as claimed in claim 1, wherein the exception handling module adopts different conversion rules to convert xml files generated by parameter names, parameter values and geometric figure sets into standard XM L documents respectively, analyzes the mapping relationship between the XM L document and the relational database, creates a simulation result table structure in the database according to the generated file template through structural mapping and semantic mapping, converts the XM L document into a relational database table according to the conversion rules, creates a management module to obtain and manage the file structure required in the unstructured file conversion process, and stores the corresponding information into the corresponding database table to integrate the conversion process.
8. The method for parsing unstructured data of a three-dimensional modeling software three-dimensional inspection model according to claim 1, wherein the exception handling module reads a corresponding XM L document based on a relational database according to information in a template, extracts metadata of the document template document, parses the XM L document using a parsing tool, extracts data content therein, distinguishes the template documents by using a uniform conversion interface, converts the structure of the template documents by using different programs respectively, generates a pair of multi-relational standard structure documents, selects a document template, imports data in a plurality of simulation output documents into the same database table, inserts the standard structure documents into a created result table, and completes conversion of semi-structured to structured data.
9. The method for analyzing unstructured data of the three-dimensional inspection model of the three-dimensional modeling software according to claim 1, characterized in that: and traversing the whole structural tree information by the exception handling module according to the modeling specification, reading a file with a CATPArt suffix and an xml file of a product and a part with a CATProduct suffix in a CATIA three-dimensional model database in the unstructured three-dimensional model, analyzing the tag information of the xml file and a required non-geometric data tag, traversing the whole xml tag during analysis, reading tag values in a one-to-one correspondence manner, generating a file extension GEOM file for storing the xml file of the structured data and the unstructured data, and storing the tag information of the xml file.
10. The method for analyzing unstructured data of the three-dimensional inspection model of the three-dimensional modeling software according to claim 1, characterized in that: the anomaly processing module defines a data table according to the hierarchical relationship of a structure tree of a CATIA (computer-graphics aided three-dimensional interactive application) at a manufacturing end, separates out non-geometric data from non-structural three-dimensional model data, analyzes the geometric data and the non-geometric data of the structural relationship in the CATIA three-dimensional model, analyzes the structural tree information of the three-dimensional model data, distinguishes the geometric data and the non-geometric data, performs information characteristic identification according to modeling specifications, stores the analyzed xml file label information in a relational database in a data table mode according to the hierarchical relationship of the CATIA structure tree, and stores the analyzed structural data in a database table.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010171173.5A CN111462327B (en) | 2020-03-12 | 2020-03-12 | Unstructured data analysis method for three-dimensional inspection model of three-dimensional modeling software |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010171173.5A CN111462327B (en) | 2020-03-12 | 2020-03-12 | Unstructured data analysis method for three-dimensional inspection model of three-dimensional modeling software |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN111462327A true CN111462327A (en) | 2020-07-28 |
| CN111462327B CN111462327B (en) | 2022-12-13 |
Family
ID=71680769
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202010171173.5A Active CN111462327B (en) | 2020-03-12 | 2020-03-12 | Unstructured data analysis method for three-dimensional inspection model of three-dimensional modeling software |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111462327B (en) |
Cited By (12)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112258629A (en) * | 2020-10-16 | 2021-01-22 | 珠海格力精密模具有限公司 | Mold manufacturing processing method and device and server |
| CN112434376A (en) * | 2020-12-01 | 2021-03-02 | 沪东中华造船(集团)有限公司 | Rapid conversion method for heterogeneous CAD hull model of SPD system |
| CN112733383A (en) * | 2021-01-21 | 2021-04-30 | 广东电网有限责任公司广州供电局 | Power data analysis method and device, computer equipment and storage medium |
| CN112765712A (en) * | 2021-01-20 | 2021-05-07 | 广联达科技股份有限公司 | Structured management method and device of BIM data, computer equipment and storage medium |
| CN113253685A (en) * | 2021-05-31 | 2021-08-13 | 航天中认软件测评科技（北京）有限责任公司 | Industrial data acquisition method, device, equipment and medium |
| CN113494939A (en) * | 2021-04-15 | 2021-10-12 | 浙江工商大学 | Distributed monitoring method for rural domestic sewage |
| CN113568909A (en) * | 2021-07-21 | 2021-10-29 | 北京无线电测量研究所 | Data updating method and system for structure tree |
| CN114090700A (en) * | 2021-11-22 | 2022-02-25 | 广州华森建筑与工程设计顾问有限公司 | Method, system and equipment for generating feature data |
| CN115798655A (en) * | 2023-01-25 | 2023-03-14 | 江苏新恒基特种装备股份有限公司 | Method for modeling forge piece through related parameters |
| CN116050358A (en) * | 2023-03-21 | 2023-05-02 | 北京飞轮数据科技有限公司 | Data processing method and device applied to dynamic data and electronic equipment |
| CN116644084A (en) * | 2023-07-27 | 2023-08-25 | 上海秉匠信息科技有限公司 | Method, apparatus, device and storage medium for processing three-dimensional model member data |
| CN117195582A (en) * | 2023-09-20 | 2023-12-08 | 北京瑞风协同科技股份有限公司 | Method and system for automatically generating weighing list in design and manufacturing process |
Citations (12)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2002041190A2 (en) * | 2000-11-15 | 2002-05-23 | Holbrook David M | Apparatus and method for organizing and/or presenting data |
| US20030065492A1 (en) * | 2001-07-11 | 2003-04-03 | Shigeki Matsutani | Finite element method library, finite element method program, and storage medium |
| US20050055355A1 (en) * | 2003-09-05 | 2005-03-10 | Oracle International Corporation | Method and mechanism for efficient storage and query of XML documents based on paths |
| CN101169716A (en) * | 2007-11-30 | 2008-04-30 | 清华大学 | Emulated procedure information modeling and maintenance method based on product structural tree |
| CN103593181A (en) * | 2013-10-23 | 2014-02-19 | 中国运载火箭技术研究院 | Configurable distributed three-dimensional scene simulating system |
| CN103885774A (en) * | 2014-03-21 | 2014-06-25 | 浙江天正信息科技有限公司 | Domain feature tree modeling method based on i* framework |
| CN104268179A (en) * | 2014-09-17 | 2015-01-07 | 成都飞机工业（集团）有限责任公司 | Unstructured three-dimensional model data analytical algorithm |
| US20150213154A1 (en) * | 2014-01-28 | 2015-07-30 | Stephan Toebben | Transitioning cad model data into variant configurations |
| CN105630916A (en) * | 2015-12-21 | 2016-06-01 | 浙江工业大学 | Method for extracting and organizing unstructured sheet document data under big data environment |
| US20170329749A1 (en) * | 2016-05-16 | 2017-11-16 | Linguamatics Ltd. | Extracting information from tables embedded within documents |
| CN109446296A (en) * | 2018-09-10 | 2019-03-08 | 上海勋立信息科技有限公司 | A kind of magnanimity unstructured data treating method and apparatus |
| CN110795697A (en) * | 2019-10-29 | 2020-02-14 | 北京明略软件系统有限公司 | Logic expression obtaining method and device, storage medium and electronic device |
-
2020
- 2020-03-12 CN CN202010171173.5A patent/CN111462327B/en active Active
Patent Citations (12)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2002041190A2 (en) * | 2000-11-15 | 2002-05-23 | Holbrook David M | Apparatus and method for organizing and/or presenting data |
| US20030065492A1 (en) * | 2001-07-11 | 2003-04-03 | Shigeki Matsutani | Finite element method library, finite element method program, and storage medium |
| US20050055355A1 (en) * | 2003-09-05 | 2005-03-10 | Oracle International Corporation | Method and mechanism for efficient storage and query of XML documents based on paths |
| CN101169716A (en) * | 2007-11-30 | 2008-04-30 | 清华大学 | Emulated procedure information modeling and maintenance method based on product structural tree |
| CN103593181A (en) * | 2013-10-23 | 2014-02-19 | 中国运载火箭技术研究院 | Configurable distributed three-dimensional scene simulating system |
| US20150213154A1 (en) * | 2014-01-28 | 2015-07-30 | Stephan Toebben | Transitioning cad model data into variant configurations |
| CN103885774A (en) * | 2014-03-21 | 2014-06-25 | 浙江天正信息科技有限公司 | Domain feature tree modeling method based on i* framework |
| CN104268179A (en) * | 2014-09-17 | 2015-01-07 | 成都飞机工业（集团）有限责任公司 | Unstructured three-dimensional model data analytical algorithm |
| CN105630916A (en) * | 2015-12-21 | 2016-06-01 | 浙江工业大学 | Method for extracting and organizing unstructured sheet document data under big data environment |
| US20170329749A1 (en) * | 2016-05-16 | 2017-11-16 | Linguamatics Ltd. | Extracting information from tables embedded within documents |
| CN109446296A (en) * | 2018-09-10 | 2019-03-08 | 上海勋立信息科技有限公司 | A kind of magnanimity unstructured data treating method and apparatus |
| CN110795697A (en) * | 2019-10-29 | 2020-02-14 | 北京明略软件系统有限公司 | Logic expression obtaining method and device, storage medium and electronic device |
Non-Patent Citations (6)
| Title |
|---|
| MARKUS SALCHNER等: "Multi-CAD approach for knowledge-based design methods", 《COMPUTER-AIDED DESIGN AND APPLICATIONS》 * |
| YANG WEI等: "Robust methodology of automatic design for automobile panel drawing die based on multilevel modeling strategy", 《THE INTERNATIONAL JOURNAL OF ADVANCED MANUFACTURING TECHNOLOGY》 * |
| 周苏等: "《大数据时代管理信息系统》", 31 January 2017, 北京：中国铁道出版社 * |
| 徐龙等: "基于MBD的检验数模在数字化检测中的应用", 《工具技术》 * |
| 李伟刚等: "基于Web的零件特征信息共享技术研究", 《计算机辅助设计与图形学学报》 * |
| 杨波: "基于私有云平台的三维CAD与信息化系统集成研究", 《中国优秀博硕士学位论文全文数据库(硕士) 信息科技辑》 * |
Cited By (17)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112258629A (en) * | 2020-10-16 | 2021-01-22 | 珠海格力精密模具有限公司 | Mold manufacturing processing method and device and server |
| CN112434376A (en) * | 2020-12-01 | 2021-03-02 | 沪东中华造船(集团)有限公司 | Rapid conversion method for heterogeneous CAD hull model of SPD system |
| CN112765712A (en) * | 2021-01-20 | 2021-05-07 | 广联达科技股份有限公司 | Structured management method and device of BIM data, computer equipment and storage medium |
| CN112733383A (en) * | 2021-01-21 | 2021-04-30 | 广东电网有限责任公司广州供电局 | Power data analysis method and device, computer equipment and storage medium |
| CN113494939A (en) * | 2021-04-15 | 2021-10-12 | 浙江工商大学 | Distributed monitoring method for rural domestic sewage |
| CN113253685A (en) * | 2021-05-31 | 2021-08-13 | 航天中认软件测评科技（北京）有限责任公司 | Industrial data acquisition method, device, equipment and medium |
| CN113253685B (en) * | 2021-05-31 | 2021-09-24 | 航天中认软件测评科技（北京）有限责任公司 | Industrial data acquisition method, device, equipment and medium |
| CN113568909B (en) * | 2021-07-21 | 2023-09-12 | 北京无线电测量研究所 | Data updating method and system for structural tree |
| CN113568909A (en) * | 2021-07-21 | 2021-10-29 | 北京无线电测量研究所 | Data updating method and system for structure tree |
| CN114090700A (en) * | 2021-11-22 | 2022-02-25 | 广州华森建筑与工程设计顾问有限公司 | Method, system and equipment for generating feature data |
| CN114090700B (en) * | 2021-11-22 | 2022-05-17 | 广州华森建筑与工程设计顾问有限公司 | Method, system and equipment for generating feature data |
| CN115798655A (en) * | 2023-01-25 | 2023-03-14 | 江苏新恒基特种装备股份有限公司 | Method for modeling forge piece through related parameters |
| CN116050358A (en) * | 2023-03-21 | 2023-05-02 | 北京飞轮数据科技有限公司 | Data processing method and device applied to dynamic data and electronic equipment |
| CN116644084A (en) * | 2023-07-27 | 2023-08-25 | 上海秉匠信息科技有限公司 | Method, apparatus, device and storage medium for processing three-dimensional model member data |
| CN116644084B (en) * | 2023-07-27 | 2023-09-26 | 上海秉匠信息科技有限公司 | Method, apparatus, device and storage medium for processing three-dimensional model member data |
| CN117195582A (en) * | 2023-09-20 | 2023-12-08 | 北京瑞风协同科技股份有限公司 | Method and system for automatically generating weighing list in design and manufacturing process |
| CN117195582B (en) * | 2023-09-20 | 2024-04-30 | 北京瑞风协同科技股份有限公司 | Method and system for automatically generating weighing list in design and manufacturing process |
Also Published As
| Publication number | Publication date |
|---|---|
| CN111462327B (en) | 2022-12-13 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN111462327B (en) | Unstructured data analysis method for three-dimensional inspection model of three-dimensional modeling software | |
| Karnitis et al. | Migration of relational database to document-oriented database: structure denormalization and data transformation | |
| CN110837492B (en) | Method for providing data service by multi-source data unified SQL | |
| US20210357577A1 (en) | Logical, recursive definition of data transformations | |
| US20190384785A1 (en) | Method for Determining and Representing a Data Ontology | |
| US20040031015A1 (en) | System and method for manipulation of software | |
| CN104298496B (en) | data analysis type software development framework system | |
| CN101901265B (en) | Objectification management system of virtual test data | |
| JPWO2006085455A1 (en) | Document processing apparatus and document processing method | |
| CN103412853A (en) | Method for automatically generating test cases aiming at document converters | |
| Bala et al. | A Fine‐Grained Distribution Approach for ETL Processes in Big Data Environments | |
| US7013468B2 (en) | Method and apparatus for design and manufacturing application associative interoperability | |
| Tierney et al. | Managing equivalent representations of design and analysis models | |
| US20070282804A1 (en) | Apparatus and method for extracting database information from a report | |
| CN116303359A (en) | Method for realizing multi-type document export of database structure | |
| CN116450110A (en) | Automatic generation method and system for access codes of database based on custom attributes | |
| Poinot et al. | Seven keys for practical understanding and use of CGNS | |
| CN107341021B (en) | Software network representation, storage and retrieval method for large complex software with constraint logic attribute | |
| Ding et al. | Strategies for the Collaborative Use of CAD Product Models | |
| Riahi et al. | XML in formal specification, verification and generation of mobile HCI | |
| US20030163604A1 (en) | Method and apparatus for design and manufacturing application feature interoperability | |
| Du et al. | Research and Implementation of MapReduce Programming Oriented Graphical Modeling System | |
| JP2005202612A (en) | Data base generation program preparing apparatus | |
| Tompa | Data structure design | |
| Sahoo et al. | Supporting XML based high-level abstractions on HDF5 datasets: A case study in automatic data virtualization |
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 | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |