Creation method of three-dimensional volume mesh model, and data processing method and device

By creating a three-dimensional mesh model in the database and combining three-dimensional geometric information and spatial attribute types, the data consistency and computing performance issues in the management and analysis of non-homogeneous and anisotropic three-dimensional data are solved, and efficient and secure data processing is achieved.

CN120653625APending Publication Date: 2025-09-16ALIBABA CLOUD COMPUTING CO LTD
View PDF 0 Cites 0 Cited by

Patent Information

Application Number
CN202410257776.5
Authority / Receiving Office
CN · China
Patent Type
Applications(China)
Current Assignee / Owner
Filing Date
2024-03-06
Publication Date
2025-09-16

AI Technical Summary

Technical Problem

Existing technologies make it difficult to efficiently manage and analyze inhomogeneous and anisotropic three-dimensional data, especially when there are problems with data consistency and computing performance in the database.

Method used

By creating a three-dimensional mesh model, combining three-dimensional geometric information and spatial attribute types, binding and synchronously updating in the database, the atomicity and consistency of the data are achieved, and data processing is performed within the database to avoid middleware intervention.

Benefits of technology

It improves data computing performance and security, ensures data integrity and consistency, and avoids problems that the middleware cannot perceive.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN120653625A_ABST
    Figure CN120653625A_ABST
Patent Text Reader

Abstract

The invention provides a three-dimensional volume mesh model creating method and device and a data processing method and device, and relates to the technical field of databases. In the embodiment of the invention, a three-dimensional volume mesh model is created in a database according to three-dimensional geometric information and spatial attribute types of the three-dimensional volume mesh model; through the binding of the three-dimensional geometric information and the spatial attribute type, the synchronous updating of the three-dimensional geometric information and the spatial attribute of the three-dimensional object can be realized, and the atomicity and the consistency of the data are ensured. Besides, by creating the three-dimensional volume mesh model in the database, data processing can be realized in the database without the participation of middleware, and the problem that the data in the database cannot be perceived by the modified middleware can be avoided. Moreover, the data processing is performed in the database, and the data does not need to be transmitted to middleware for calculation and then written back to the database, so that the calculation performance is greatly improved.
Need to check novelty before this filing date? Find Prior Art

Description

Technical Field

[0001] The present application relates to the field of database technology, and in particular to a method for creating a three-dimensional mesh model, a data processing method and a device. Background Art

[0002] With the rapid development of information technologies such as earth observation technology, the Internet of Things, and digital twins, three-dimensional spatiotemporal data has become ubiquitous and is growing exponentially. For example, in the fields of infrastructure management, emergency management, transportation, information and communications, scenarios based on Building Information Modeling (BIM), City Information Modeling (CIM), and Geographic Information System (GIS) have generated massive amounts of three-dimensional data. In addition, in the fields of energy exploration, natural resource management, weather forecasting, aerospace, etc., there are also a large number of inhomogeneous and anisotropic objects, such as geological ore bodies, meteorological fields, and ocean currents. The three-dimensional data of such inhomogeneous and anisotropic objects are characterized by large quantity, complex structure, and high analysis complexity. As the foundation for data calculation and storage, the database needs to efficiently manage the three-dimensional data.

[0003] Therefore, a method for effectively managing and analyzing three-dimensional data is needed. Summary of the Invention

[0004] The embodiments of the present application provide a method for creating a three-dimensional mesh model, a data processing method and an apparatus to achieve effective management and analysis of three-dimensional data.

[0005] In a first aspect, an embodiment of the present application provides a method for creating a three-dimensional mesh model, the method comprising:

[0006] Get a request to create a 3D mesh model;

[0007] Determine the three-dimensional geometric information and spatial attribute type of the three-dimensional mesh model according to the creation request;

[0008] A 3D volume mesh model is created in the database based on 3D geometric information and spatial attribute types.

[0009] In a second aspect, an embodiment of the present application provides a data processing method based on a three-dimensional volume mesh model, the method comprising:

[0010] Obtaining a data processing request for a three-dimensional volume mesh model in a database;

[0011] According to the data processing request, corresponding processing is performed on the three-dimensional mesh model in the database;

[0012] The three-dimensional mesh model is created according to the method for creating a three-dimensional mesh model of any embodiment of the present application.

[0013] In a third aspect, an embodiment of the present application provides a device for creating a three-dimensional mesh model, the device comprising:

[0014] A creation request acquisition module is used to obtain a creation request for a three-dimensional mesh model;

[0015] A model information determination module is used to determine the three-dimensional geometric information and spatial attribute type of the three-dimensional mesh model according to the creation request;

[0016] The model creation module is used to create a three-dimensional mesh model in the database based on three-dimensional geometric information and spatial attribute types.

[0017] In a fourth aspect, an embodiment of the present application provides a data processing device based on a three-dimensional mesh model, the device comprising:

[0018] A processing request acquisition module is used to obtain a data processing request for a three-dimensional mesh model in a database;

[0019] The model processing module is used to perform corresponding processing on the three-dimensional mesh model in the database according to the data processing request;

[0020] The three-dimensional mesh model is created according to the method for creating a three-dimensional mesh model of any embodiment of the present application.

[0021] In a fifth aspect, an embodiment of the present application provides an electronic device, comprising a memory, a processor, and a computer program stored in the memory, wherein the processor implements any of the above methods when executing the computer program.

[0022] In a sixth aspect, an embodiment of the present application provides a computer-readable storage medium, in which a computer program is stored. When the computer program is executed by a processor, any of the above methods is implemented.

[0023] In a seventh aspect, an embodiment of the present application provides a computer program product, which includes a computer program, and when the computer program is executed by a processor, it implements any of the above methods.

[0024] Compared with the prior art, this application has the following advantages:

[0025] The present application provides a method for creating a three-dimensional mesh model, a data processing method and a device. According to the three-dimensional geometric information and spatial attribute type of the three-dimensional mesh model, a three-dimensional mesh model is created in a database. By binding the three-dimensional geometric information and the spatial attribute type, the three-dimensional geometric information and the spatial attribute type of the three-dimensional object can be updated synchronously, ensuring the atomicity and consistency of the data. In addition, by creating a three-dimensional mesh model in the database, data processing can be implemented in the database without the participation of middleware, which can avoid the problem that the data in the database is modified but the middleware cannot perceive it. Moreover, all data processing is performed in the database, and there is no need to transmit data to the middleware for calculation and then write it back to the database, which greatly improves the computing performance. In addition, the data to be processed are all calculated in the database and do not leave the database, ensuring the security of the data.

[0026] The above description is only an overview of the technical solution of this application. In order to more clearly understand the technical means of this application, it can be implemented in accordance with the contents of the specification. In order to make the above and other purposes, features and advantages of this application more obvious and easy to understand, the specific implementation methods of this application are listed below. BRIEF DESCRIPTION OF THE DRAWINGS

[0027] In the accompanying drawings, unless otherwise specified, the same reference numerals throughout the multiple drawings represent the same or similar components or elements. These drawings are not necessarily drawn to scale. It should be understood that these drawings only depict some embodiments according to the present application and should not be regarded as limiting the scope of the present application.

[0028] Figure 1 A schematic diagram of the data structure and storage structure of the three-dimensional mesh model provided in this application.

[0029] Figure 2 A schematic diagram of a method for creating a three-dimensional mesh model according to an embodiment of the present application.

[0030] Figure 3 Schematic diagram of a data processing method based on a three-dimensional mesh model according to an embodiment of the present application.

[0031] Figure 4 A schematic diagram of function operations supported by a three-dimensional mesh model according to an embodiment of the present application.

[0032] Figure 5 FIG. 1 is a schematic diagram of a database system architecture supporting a three-dimensional mesh model according to an embodiment of the present application.

[0033] Figure 6 This is a flowchart of a method for creating a three-dimensional mesh model according to an embodiment of the present application.

[0034] Figure 7This is a flowchart of a data processing method based on a three-dimensional mesh model according to an embodiment of the present application.

[0035] Figure 8 This is a structural block diagram of a device for creating a three-dimensional mesh model according to an embodiment of the present application.

[0036] Figure 9 This is a structural block diagram of a data processing device based on a three-dimensional mesh model according to an embodiment of the present application.

[0037] Figure 10 A block diagram of an electronic device used to implement an embodiment of the present application. DETAILED DESCRIPTION

[0038] Hereinafter, only certain exemplary embodiments are briefly described. As will be appreciated by those skilled in the art, the described embodiments may be modified in various ways without departing from the spirit or scope of the present application. Therefore, the drawings and description are to be regarded as illustrative in nature and not restrictive.

[0039] To facilitate understanding of the technical solutions of the embodiments of the present application, the following describes the related technologies of the embodiments of the present application. The following related technologies can be combined with the technical solutions of the embodiments of the present application as optional solutions, and all of them fall within the scope of protection of the embodiments of the present application.

[0040] It should be noted that the user information (including but not limited to user device information, user personal information, etc.) and data (including but not limited to data used for analysis, stored data, displayed data, etc.) involved in this application are all information and data authorized by the user or fully authorized by all parties, and the collection, use and processing of relevant data must comply with the relevant laws, regulations and standards of relevant countries and regions, and provide corresponding operation entrances for users to choose to authorize or refuse.

[0041] Figure 1 This is a schematic diagram of the data structure and storage structure of the three-dimensional mesh model provided in this application. Figure 1 As shown, a three-dimensional volume mesh model (Volume Mesh, VoMesh) is defined in the database, and VoMesh type data is indexed according to the database (such as Figure 1 The 3D mesh model can represent real-world 3D objects in the digital world, including but not limited to: 3D non-homogeneous and anisotropic materials such as geology, ocean currents, and meteorology. The 3D mesh model consists of the following parts:

[0042] 1. 3D geometric information (G), including the following:

[0043] Vertex information (V), each vertex consists of XYZ coordinates.

[0044] Surfactant information (F), each surfel consists of a set of ordered vertex sequences.

[0045] Voxel information (C): To represent the internal structure of a 3D object, the 3D mesh model is decomposed into a series of voxels. A voxel can be an irregular closed polyhedron composed of several facets.

[0046] 2. Spatial attribute type (A) is used to represent the physical, chemical, spatiotemporal, or other properties of a three-dimensional object, such as barycentric coordinates, temperature, melting point, refractive index, conductivity, acidity, and alkalinity. Based on its source, it can be divided into:

[0047] Vertex attributes (VA), the number and type of attributes for each vertex are the same.

[0048] Facet attributes (FA), the number and type of attributes of each facet are the same.

[0049] Voxel attributes (CA), the number and type of attributes of each voxel are the same.

[0050] The data type of an attribute may include, but is not limited to, integer, floating-point, and discrete types (Categorical types); the dimensions of the data may include scalars (0 dimensions), vectors (1 dimensions), or matrices (2 dimensions).

[0051] 3. Global information (U), including but not limited to:

[0052] A reference frame (SR) is used to interpret the actual positions of vertex coordinates in the real world.

[0053] The data source (S) indicates the real-world source of the 3D mesh model.

[0054] Level of detail (L) indicates the level of detail of the 3D mesh model, used for fast rendering and display in the scene. LOD information can be represented by a numerical value, with different values ​​representing different mesh sizes. For example, 0 represents the lowest level, with the smallest mesh, while 1 represents a higher level, with a larger mesh that can include multiple sub-meshes.

[0055] Temporal information (TS) is used to represent the time-related information of the 3D mesh model.

[0056] Texture information (T), used to represent the texture information of the three-dimensional mesh model.

[0057] Material information (M), used to represent the material information of the three-dimensional mesh model.

[0058] Figure 2 Schematic diagram of a method for creating a three-dimensional mesh model according to an embodiment of the present application. Figure 2 As shown, the user terminal sends a request to create a three-dimensional mesh model to the server. The creation request can be a Structured Query Language (SQL) statement. The database in the server parses the creation request through a parser to obtain the three-dimensional geometric information and spatial attribute type of the three-dimensional mesh model, and performs a validity check to check whether the input three-dimensional geometric information and spatial attribute type represented by a preset format (for example, WKT, WKB, TEXT, etc.) are valid, that is, whether the format is correct. If invalid, an error message is given; if valid, a three-dimensional mesh model is created according to the three-dimensional geometric information and spatial attribute type and written to the database, and finally the index in the database is updated.

[0059] Figure 3 Schematic diagram of a data processing method based on a three-dimensional mesh model according to an embodiment of the present application. Figure 3 As shown, the user terminal sends a data processing request to the server. The database in the server generates and selects a query execution plan through an optimizer. The query execution plan includes a series of operation steps for retrieving target data from the database, performing calculations, and returning results. The database in the server parses the data processing request through a parser to obtain filtering conditions. The database index is filtered according to the filtering conditions to obtain the target three-dimensional volume mesh model. Index filtering includes but is not limited to filtering based on three-dimensional geometric information, filtering based on spatial attribute types, and joint filtering to obtain the target three-dimensional volume mesh model that meets the filtering conditions. The parsing also obtains a processing method. According to the processing method, the target three-dimensional volume mesh model is processed accordingly in the database. The processing method includes at least one of the following: spatial relationship judgment, spatial topology operation, spatial clipping, model simplification, model merging, model visualization, model query, model update, or model attribute interpolation. Each processing method corresponds to a function operator, which is used to perform corresponding processing on the target three-dimensional volume mesh model and return the processing result to the user terminal.

[0060] Different function operators correspond to different functions and call different SQL application programming interfaces (APIs). Figure 4 This is a schematic diagram of the function operations supported by the three-dimensional mesh model of an embodiment of the present application. The function operations specifically include:

[0061] 1. Spatial relationship judgment, judge whether two 3D mesh models intersect, contain, or separate, and return a Boolean value result ( Figure 4 The SQL API is as follows:

[0062] ST_3DIntersects(VoMesh,VoMesh);

[0063] ST_3DContains(VoMesh,VoMesh);

[0064] ST_3DDisjoint(VoMesh,VoMesh);

[0065] 2. Spatial topological operations: calculate the intersection, difference, and union of two 3D mesh models. The SQL API is as follows:

[0066] ST_3DIntersection(VoMesh,VoMesh);

[0067] ST_3DDifference(VoMesh,VoMesh);

[0068] ST_3DUnion(VoMesh,VoMesh);

[0069] 3. Spatial sectioning (clipping) operations use a geometric object (usually a patch composed of multiple triangles) to cut a 3D mesh model to obtain a polygonal plane at the cross section. The SQL API is as follows:

[0070] ST_3DClip(VoMesh,Geometry);

[0071] 4. Model simplification: Reduce the number of geometric elements of the 3D mesh model, such as vertices and facets, to obtain a new 3D mesh model with a coarser mesh size. The SQL API is as follows:

[0072] ST_3DSimplify(VoMesh);

[0073] 5. Model merging: Merge a 3D mesh model array into a larger 3D mesh model. The SQL API is as follows:

[0074] ST_3DUnion(VoMesh[]);

[0075] 6. Model visualization: Convert the 3D mesh model into GLTF / GLB format. The SQL API is as follows:

[0076] ST_AsGLTF(VoMesh);

[0077] ST_AsGLB(VoMesh);

[0078] 7. Model query, query the 3D geometric information of the 3D mesh model: (1) center coordinates; (2) which voxel contains a given point; or query the spatial attribute type of the 3D mesh model; (3) the maximum and minimum values ​​of the specified attribute; (4) the rectangular bounding box, etc. Figure 4 The Arguments shown in the query are the parameters passed to the query function. Geometry and Attributes represent the 3D geometry information and spatial attribute types of the 3D mesh model obtained by the query, respectively. The SQL API is as follows:

[0079] ST_Center(VoMesh);

[0080] ST_LocatePoint(VoMesh,Point);

[0081] ST_Minmax(VoMesh,String);

[0082] ST_Box(VoMesh);

[0083] 8. Model update, you can add attribute information to the 3D mesh model (such as Figure 4 The Arguments shown in refer to the parameters passed to the update function), or to delete attribute information. The SQL API is as follows:

[0084] ST_AppendAttr(VoMesh,String,Data);

[0085] ST_DropAttr(VoMesh,String);

[0086] 9. Attribute interpolation: Based on the attribute information of the reference point, the interpolation method (for example, Kriging method, etc.) can be used to interpolate new attribute data (such as Figure 4 The SQL API is as follows:

[0087] ST_KrigingInterpolate(VoMesh,Data).

[0088] Optionally, in actual operation, a unique identifier can be set for each three-dimensional mesh model, and the three-dimensional geometric information and spatial attribute type of each three-dimensional mesh model can be split into multiple tables for storage. Then, the unique identifier of the three-dimensional mesh model can be used as the primary key of these tables. At the same time, an independent index structure can be established for each table.

[0089] In addition to the above-mentioned function operators, the three-dimensional mesh model can also be converted into other three-dimensional data formats (obj, off, b3dm, etc.), and the three-dimensional mesh model can be geometrically transformed (translated, rotated, scaled).

[0090] Figure 5 This is a schematic diagram of a database system architecture supporting a three-dimensional mesh model according to an embodiment of the present application. Figure 5 As shown, it includes: an input / output module, a central processing unit, and a network adapter. The network adapter can be used to access the network to realize the storage functions of the network storage system and the object storage system. The database management system includes: a parser, an optimizer, and an executor. The parser is used to parse the received request; the optimizer is used to query the target and formulate an operation plan based on the parsing result; the executor is used to execute the operation plan and return the execution result to the requester. The database management system stores a three-dimensional mesh model data table, an index established for the three-dimensional mesh model, function operators supported by the three-dimensional mesh model, and a three-dimensional mesh model metadata table. The metadata table stores the creator name and database name of the three-dimensional mesh model. The storage system in the database system includes a local file system, a network storage system, and an object storage system.

[0091] like Figure 1-Figure 5 The embodiment shown has the following beneficial effects:

[0092] 1. Create a new three-dimensional grid model at the database system level, making the database system more suitable for fields such as energy exploration and natural resource management, greatly broadening the application scenarios of the database system.

[0093] 2. Use unified SQL to query and analyze 3D mesh model data, which is more user-friendly and reduces learning costs.

[0094] 3. Address data atomicity and consistency. By binding 3D geometry and spatial attribute types, 3D geometry and spatial attribute types can be updated synchronously, ensuring data integrity and avoiding partial updates, thus guaranteeing data atomicity. Furthermore, database functionality is used to maintain data consistency, resolving the issue of data inconsistencies caused by database modifications that are not perceived by middleware in solutions using middleware.

[0095] 4. Improved data computing performance. By fully leveraging the database's native indexing technology, queries can fully utilize the database's internal indexing mechanism to improve query performance. All calculations are performed within the database, eliminating the need to transfer data to middleware for calculation and then write it back to the database, significantly improving computing performance.

[0096] 5. Improve data security. All data is calculated within the database, and the original data does not leave the database, which greatly ensures data security.

[0097] The present application embodiment provides a method for creating a three-dimensional mesh model. The method in this embodiment can be applied to a computing device, which may include a server, etc. Figure 6 FIG. 1 is a flow chart of a method for creating a three-dimensional mesh model according to an embodiment of the present application, comprising:

[0098] Step S601: Obtain a request for creating a three-dimensional mesh model.

[0099] Step S602: Determine the three-dimensional geometric information and spatial attribute type of the three-dimensional volume mesh model according to the creation request.

[0100] Step S603: Create a three-dimensional mesh model in the database according to the three-dimensional geometric information and the spatial attribute type.

[0101] Among them, the three-dimensional volume mesh model can represent three-dimensional objects in the real world in the digital world, including but not limited to: three-dimensional non-homogeneous and anisotropic materials such as geology, ocean currents, and meteorology in the real world.

[0102] The method for creating a three-dimensional mesh model provided in the embodiment of the present application creates a three-dimensional mesh model in a database based on the three-dimensional geometric information and spatial attribute type of the three-dimensional mesh model. By binding the three-dimensional geometric information and the spatial attribute type, the three-dimensional geometric information and the spatial attribute type of the three-dimensional object can be updated synchronously, ensuring the atomicity and consistency of the data. In addition, by creating a three-dimensional mesh model in the database, data processing can be implemented in the database without the participation of middleware, which can avoid the problem that the data in the database is modified but the middleware cannot perceive it. Moreover, all data processing is performed in the database, and there is no need to transmit data to the middleware for calculation and then write it back to the database, which greatly improves the computing performance. In addition, the data to be processed are all calculated in the database and do not leave the database, ensuring the security of the data.

[0103] In one implementation, step S602 determines the three-dimensional geometric information and spatial attribute type of the three-dimensional volume mesh model according to the creation request, including: parsing the creation request to obtain the three-dimensional geometric information and spatial attribute type of the three-dimensional volume mesh model.

[0104] The creation request can be a Structured Query Language (SQL) statement. The server's database parses the creation request through a parser to obtain the 3D geometry information and spatial attribute types of the 3D volume mesh model. Optionally, the parsed result is validated to check whether the input 3D geometry information and spatial attribute types, expressed in a preset format (e.g., WKT, WKB, TEXT, etc.), are valid, i.e., whether the format is correct. If invalid, an error message is given. If valid, a 3D volume mesh model is created based on the 3D geometry information and spatial attribute types and written to the database. Finally, the database index is updated.

[0105] In one implementation, the three-dimensional geometric information includes at least one of the following: vertex information; facet information, the facet information includes vertex information corresponding to the face units of the three-dimensional mesh model; and voxel information, the voxel information includes facet information corresponding to the voxel units of the three-dimensional mesh model.

[0106] The three-dimensional geometric information (G) includes the following:

[0107] Vertex information (V), each vertex consists of XYZ coordinates.

[0108] Surfactant information (F), each surfel consists of a set of ordered vertex sequences.

[0109] Voxel information (C): To represent the internal structure of a 3D object, the 3D mesh model is decomposed into a series of voxels. A voxel can be an irregular closed polyhedron composed of several facets.

[0110] In one implementation, the spatial attribute type includes at least one of vertex attributes, facet attributes, and voxel attributes; the spatial attribute type is used to characterize attribute information of at least one dimension of physics, chemistry, time and space of a three-dimensional object.

[0111] Among them, spatial attribute type (A) is used to represent the physical, chemical, spatiotemporal or other properties of three-dimensional objects, such as center of gravity coordinates, temperature, melting point, refractive index, conductivity, acidity and alkalinity, etc. According to its source, it can be divided into:

[0112] Vertex attributes (VA), the number and type of attributes for each vertex are the same.

[0113] Facet attributes (FA), the number and type of attributes of each facet are the same.

[0114] Voxel attributes (CA), the number and type of attributes of each voxel are the same.

[0115] The data type of an attribute may include, but is not limited to, integer, floating-point, and discrete types (Categorical types); the dimensions of the data may include scalars (0 dimensions), vectors (1 dimensions), or matrices (2 dimensions).

[0116] In one implementation, the method for creating a three-dimensional mesh model further includes: obtaining texture information, material information, and detail level information of the three-dimensional mesh model; and visualizing the three-dimensional mesh model based on the texture information, material information, and detail level information.

[0117] The level of detail (L) indicates the level of detail of the 3D mesh model; the texture information (T) indicates the texture information of the 3D mesh model; and the material information (M) indicates the material information of the 3D mesh model. The level of detail, texture information, and material information are used to visualize the 3D mesh model, for example, for fast rendering and display in a scene.

[0118] The embodiment of the present application provides a data processing method based on a three-dimensional mesh model. The method in this embodiment can be applied to a computing device, which may include a server, etc. Figure 7 FIG. 1 is a flow chart of a data processing method based on a three-dimensional mesh model according to an embodiment of the present application, comprising:

[0119] Step S701: Obtain a data processing request for a three-dimensional mesh model in a database.

[0120] Step S702: performing corresponding processing on the three-dimensional mesh model in the database according to the data processing request.

[0121] The three-dimensional volume mesh model is created according to the three-dimensional volume mesh model creation method of any embodiment of the present application. The data processing request may include a data query request or a data operation request. The data query request is used to query the three-dimensional volume mesh model, and the data operation request is used to perform corresponding operations on the three-dimensional volume mesh model using a function operator.

[0122] The data processing method based on the three-dimensional body mesh model provided in the embodiment of the present application creates a three-dimensional body mesh model in the database according to the three-dimensional geometric information and spatial attribute type of the three-dimensional body mesh model. By binding the three-dimensional geometric information and the spatial attribute type, the three-dimensional geometric information and the spatial attribute type of the three-dimensional object can be updated synchronously, ensuring the atomicity and consistency of the data. In addition, by creating a three-dimensional body mesh model in the database, data processing can be implemented in the database without the participation of middleware, which can avoid the problem that the data in the database is modified but the middleware cannot perceive it. Moreover, all data processing is carried out in the database, and there is no need to transmit data to the middleware for calculation and then write it back to the database, which greatly improves the computing performance. In addition, the data to be processed are all calculated in the database and do not leave the database, ensuring the security of the data.

[0123] In one implementation, step S702 performs corresponding processing on the three-dimensional mesh model in the database according to the data processing request, including: parsing the data processing request to obtain filtering conditions and processing methods; filtering in the database according to the filtering conditions to obtain the target three-dimensional mesh model; and performing corresponding processing on the target three-dimensional mesh model in the database according to the processing method.

[0124] In actual applications, the database in the server parses the data processing request through a parser to obtain filtering conditions, and filters the database index according to the filtering conditions to obtain the target three-dimensional mesh model.

[0125] In one implementation, the filtering condition includes at least one of a three-dimensional geometric information filtering condition or a spatial attribute type filtering condition.

[0126] The index filtering includes but is not limited to filtering based on three-dimensional geometric information, filtering based on spatial attribute types, and combined filtering to obtain a target three-dimensional mesh model that meets the filtering conditions.

[0127] In one implementation, the processing method includes at least one of the following: spatial relationship judgment, spatial topology operation, spatial clipping, model simplification, model merging, model visualization, model query, model update, or model attribute interpolation.

[0128] The data processing request is parsed to determine a processing method. Based on this processing method, the target 3D mesh model is processed accordingly in the database. These processing methods include at least one of the following: spatial relationship determination, spatial topology calculation, spatial clipping, model simplification, model merging, model visualization, model query, model update, or model attribute interpolation. Each processing method corresponds to a function operator, which is used to perform the corresponding processing on the target 3D mesh model and return the processing results to the user.

[0129] Corresponding to the application scenario and method of the method for creating a three-dimensional mesh model provided in the embodiment of the present application, the embodiment of the present application also provides a device for creating a three-dimensional mesh model. Figure 8 FIG. 1 is a block diagram of a device for creating a three-dimensional mesh model according to an embodiment of the present application. The device includes:

[0130] The creation request acquisition module 801 is used to obtain a creation request for a three-dimensional mesh model.

[0131] The model information determination module 802 is used to determine the three-dimensional geometric information and spatial attribute type of the three-dimensional mesh model according to the creation request.

[0132] The model creation module 803 is used to create a three-dimensional mesh model in the database according to the three-dimensional geometric information and the spatial attribute type.

[0133] The device for creating a three-dimensional mesh model provided in the embodiment of the present application creates a three-dimensional mesh model in a database based on the three-dimensional geometric information and spatial attribute type of the three-dimensional mesh model. By binding the three-dimensional geometric information and the spatial attribute type, the three-dimensional geometric information and spatial attributes of the three-dimensional object can be updated synchronously, ensuring the atomicity and consistency of the data. In addition, by creating a three-dimensional mesh model in the database, data processing can be implemented in the database without the participation of middleware, which can avoid the problem that the data in the database is modified but the middleware cannot perceive it. Moreover, all data processing is carried out in the database, and there is no need to transmit data to the middleware for calculation and then write it back to the database, which greatly improves the computing performance. In addition, the data to be processed are all calculated in the database and do not leave the database, ensuring the security of the data.

[0134] In one implementation, the model information determination module 802 is configured to parse the creation request to obtain the three-dimensional geometric information and spatial attribute type of the three-dimensional mesh model.

[0135] In one implementation, the three-dimensional geometric information includes at least one of the following: vertex information; facet information, the facet information includes vertex information corresponding to the face units of the three-dimensional mesh model; and voxel information, the voxel information includes facet information corresponding to the voxel units of the three-dimensional mesh model.

[0136] In one implementation, the spatial attribute type includes at least one of vertex attributes, facet attributes, and voxel attributes; the spatial attribute type is used to characterize attribute information of at least one dimension of physics, chemistry, time and space of a three-dimensional object.

[0137] In one implementation, the device for creating a three-dimensional mesh model is further used to: obtain texture information, material information and detail level information of the three-dimensional mesh model; and visualize the three-dimensional mesh model based on the texture information, material information and detail level information.

[0138] The functions of each module in the embodiment of the present application can be referred to the corresponding description in the above method, and have corresponding beneficial effects, which will not be repeated here.

[0139] Corresponding to the application scenario and method of the data processing method based on the three-dimensional mesh model provided in the embodiment of the present application, the embodiment of the present application also provides a data processing device based on the three-dimensional mesh model. Figure 9 FIG2 is a block diagram of a data processing device based on a three-dimensional mesh model according to an embodiment of the present application, wherein the device includes:

[0140] The processing request acquisition module 901 is used to acquire a data processing request for a three-dimensional mesh model in a database.

[0141] The model processing module 902 is used to perform corresponding processing on the three-dimensional mesh model in the database according to the data processing request.

[0142] The three-dimensional mesh model is created according to the method for creating a three-dimensional mesh model of any embodiment of the present application.

[0143] The data processing device based on the three-dimensional body mesh model provided in the embodiment of the present application creates a three-dimensional body mesh model in the database according to the three-dimensional geometric information and spatial attribute type of the three-dimensional body mesh model. By binding the three-dimensional geometric information and the spatial attribute type, the three-dimensional geometric information and spatial attributes of the three-dimensional object can be updated synchronously, ensuring the atomicity and consistency of the data. In addition, by creating a three-dimensional body mesh model in the database, data processing can be implemented in the database without the participation of middleware, which can avoid the problem that the data in the database is modified but the middleware cannot perceive it. Moreover, all data processing is carried out in the database, and there is no need to transmit data to the middleware for calculation and then write it back to the database, which greatly improves the computing performance. In addition, the data to be processed are all calculated in the database and do not leave the database, ensuring the security of the data.

[0144] In one implementation, the model processing module 902 is used to: parse the data processing request to obtain filtering conditions and processing methods; filter in the database according to the filtering conditions to obtain the target three-dimensional mesh model; and perform corresponding processing on the target three-dimensional mesh model in the database according to the processing method.

[0145] In one implementation, the filtering condition includes at least one of a three-dimensional geometric information filtering condition or a spatial attribute type filtering condition.

[0146] In one implementation, the processing method includes at least one of the following: spatial relationship judgment, spatial topology operation, spatial clipping, model simplification, model merging, model visualization, model query, model update, or model attribute interpolation.

[0147] The functions of each module in the embodiment of the present application can be referred to the corresponding description in the above method, and have corresponding beneficial effects, which will not be repeated here.

[0148] Figure 10 FIG. 1 is a block diagram of an electronic device for implementing an embodiment of the present application. Figure 10 As shown, the electronic device includes: a memory 1010 and a processor 1020. The memory 1010 stores a computer program that can be run on the processor 1020. When the processor 1020 executes the computer program, the method in the above embodiment is implemented. The number of the memory 1010 and the processor 1020 can be one or more.

[0149] The electronic device also includes:

[0150] The communication interface 1030 is used to communicate with external devices and perform data exchange transmission.

[0151] If the memory 1010, the processor 1020, and the communication interface 1030 are implemented independently, the memory 1010, the processor 1020, and the communication interface 1030 can be connected to each other via a bus and communicate with each other. The bus can be an Industry Standard Architecture (ISA) bus, a Peripheral Component Interconnect (PCI) bus, or an Extended Industry Standard Architecture (EISA) bus. The bus can be divided into an address bus, a data bus, a control bus, etc. For ease of representation, Figure 10 Only one thick line is used in the diagram, but this does not mean that there is only one bus or one type of bus.

[0152] Optionally, in a specific implementation, if the memory 1010, the processor 1020 and the communication interface 1030 are integrated on a chip, the memory 1010, the processor 1020 and the communication interface 1030 can communicate with each other through an internal interface.

[0153] An embodiment of the present application provides a computer-readable storage medium storing a computer program, which implements the method provided in the embodiment of the present application when the program is executed by a processor.

[0154] An embodiment of the present application provides a computer program product, which includes a computer program. When the computer program is executed by a processor, the method provided in the embodiment of the present application is implemented.

[0155] An embodiment of the present application also provides a chip, which includes a processor for calling and executing instructions stored in the memory from the memory, so that a communication device equipped with the chip executes the method provided in the embodiment of the present application.

[0156] An embodiment of the present application also provides a chip, including: an input interface, an output interface, a processor and a memory. The input interface, the output interface, the processor and the memory are connected through an internal connection path. The processor is used to execute the code in the memory. When the code is executed, the processor is used to execute the method provided in the embodiment of the application.

[0157] It should be understood that the processor may be a central processing unit (CPU), or other general-purpose processors, digital signal processors (DSP), application-specific integrated circuits (ASIC), field-programmable gate arrays (FPGA), or other programmable logic devices, discrete gate or transistor logic devices, discrete hardware components, etc. A general-purpose processor may be a microprocessor or any conventional processor, etc. It is worth noting that the processor may be a processor that supports the Advanced RISC Machines (ARM) architecture.

[0158] Furthermore, optionally, the above-mentioned memory may include a read-only memory and a random access memory. The memory may be a volatile memory or a non-volatile memory, or may include both volatile and non-volatile memories. Among them, the non-volatile memory may include a read-only memory (ROM), a programmable read-only memory (PROM), an erasable programmable read-only memory (EPROM), an electrically erasable programmable read-only memory (EEPROM), or a flash memory. The volatile memory may include a random access memory (RAM), which is used as an external cache. By way of example but not limitation, many forms of RAM are available. For example, static random access memory (SRAM), dynamic random access memory (DRAM), synchronous dynamic random access memory (SDRAM), double data rate synchronous dynamic random access memory (DDR SDRAM), enhanced synchronous dynamic random access memory (ESDRAM), synchronous link DRAM (SLDRAM) and direct memory bus random access memory (DR RAM).

[0159] In the above embodiments, all or part of the embodiments may be implemented using software, hardware, firmware, or any combination thereof. When implemented using software, all or part of the embodiments may be implemented in the form of a computer program product. A computer program product includes one or more computer instructions. When the computer program instructions are loaded and executed on a computer, the processes or functions according to the present application are generated in whole or in part. The computer may be a general-purpose computer, a special-purpose computer, a computer network, or other programmable device. The computer instructions may be stored in a computer-readable storage medium or transferred from one computer-readable storage medium to another.

[0160] In the description of this specification, the reference terms "one embodiment," "some embodiments," "example," "specific example," or "some examples" mean that the specific features, structures, materials, or characteristics described in conjunction with the embodiment or example are included in at least one embodiment or example of the present application. Moreover, the specific features, structures, materials, or characteristics described may be combined in any appropriate manner in any one or more embodiments or examples. In addition, those skilled in the art may combine and combine different embodiments or examples described in this specification, as well as features of different embodiments or examples, unless they are mutually inconsistent.

[0161] Furthermore, the terms "first" and "second" are used for descriptive purposes only and should not be construed as indicating or implying relative importance or implicitly specifying the number of technical features being referred to. Thus, a feature defined as "first" or "second" may explicitly or implicitly include at least one such feature. Throughout the description of this application, "plurality" means two or more, unless otherwise specifically defined.

[0162] Any process or method described in the flowchart or otherwise described herein can be understood to represent a module, segment or portion of code comprising one or more executable instructions for implementing the steps of a specific logical function or process. The scope of the preferred embodiments of the present application includes other implementations in which the functions may be performed in a different order than shown or discussed, including performing the functions substantially simultaneously or in reverse order depending on the functions involved.

[0163] The logic and / or steps described in the flowchart or otherwise described herein, for example, can be considered as an ordered list of executable instructions for implementing logical functions, and can be embodied in any computer-readable medium for use by an instruction execution system, apparatus or device (such as a computer-based system, a system including a processor or other system that can fetch instructions from an instruction execution system, apparatus or device and execute instructions), or used in combination with such instruction execution systems, apparatuses or devices.

[0164] It should be understood that various parts of the present application can be implemented using hardware, software, firmware, or a combination thereof. In the above embodiments, multiple steps or methods can be implemented using software or firmware stored in a memory and executed by a suitable instruction execution system. All or part of the steps of the above embodiment method can be completed by instructing the relevant hardware through a program, which can be stored in a computer-readable storage medium. When the program is executed, it includes one or a combination of the steps of the method embodiment.

[0165] In addition, the functional units in the various embodiments of the present application may be integrated into a single processing module, or each unit may exist physically separately, or two or more units may be integrated into a single module. The aforementioned integrated modules may be implemented in the form of hardware or in the form of software functional modules. If the aforementioned integrated modules are implemented in the form of software functional modules and sold or used as independent products, they may also be stored in a computer-readable storage medium. The storage medium may be a read-only memory, a magnetic disk, or an optical disk, etc.

[0166] The above is merely an exemplary embodiment of the present application, but the scope of protection of the present application is not limited thereto. Any person skilled in the art can easily conceive of various modifications or substitutions within the technical scope described in this application, and such modifications or substitutions should be included in the scope of protection of the present application. Therefore, the scope of protection of the present application should be based on the scope of protection of the claims.

Claims

1. A method for creating a three-dimensional mesh model, characterized in that: The method comprises: Get the request to create a 3D mesh model; Determining, according to the creation request, three-dimensional geometric information and spatial attribute types of the three-dimensional volume mesh model; The three-dimensional volume mesh model is created in a database according to the three-dimensional geometric information and the spatial attribute type.

2. The method according to claim 1, characterized in that Determining the three-dimensional geometric information and spatial attribute type of the three-dimensional volume mesh model according to the creation request includes: The creation request is parsed to obtain the three-dimensional geometric information and spatial attribute type of the three-dimensional volume mesh model.

3. The method according to claim 1, characterized in that The three-dimensional geometric information includes at least one of the following: Vertex information; Facet information, the facet information including vertex information corresponding to face units of the three-dimensional mesh model; Voxel information, where the voxel information includes facet information corresponding to the volume unit of the three-dimensional mesh model.

4. The method according to claim 1, wherein The spatial attribute type includes at least one of vertex attributes, facet attributes, and voxel attributes; the spatial attribute type is used to characterize attribute information of at least one dimension of physics, chemistry, time and space of a three-dimensional object.

5. The method according to any one of claims 1 to 4, characterized in that The method further comprises: Obtaining texture information, material information, and detail level information of the three-dimensional mesh model; The three-dimensional mesh model is visualized according to the texture information, the material information and the detail level information.

6. A data processing method based on a three-dimensional mesh model, characterized in that: The method comprises: Obtaining a data processing request for a three-dimensional volume mesh model in a database; According to the data processing request, performing corresponding processing on the three-dimensional mesh model in the database; Wherein, the three-dimensional mesh model is created according to the method according to any one of claims 1-5.

7. The method according to claim 6, characterized in that The performing corresponding processing on the three-dimensional mesh model in the database according to the data processing request includes: Parsing the data processing request to obtain filtering conditions and processing methods; Filtering the database according to the filtering condition to obtain a target three-dimensional mesh model; According to the processing method, the target three-dimensional mesh model is processed accordingly in the database.

8. The method according to claim 7, characterized in that The filtering condition includes at least one of a three-dimensional geometric information filtering condition and a spatial attribute type filtering condition.

9. The method according to claim 7, characterized in that The processing method includes at least one of the following: Spatial relationship judgment, spatial topology operation, spatial clipping, model simplification, model merging, model visualization, model query, model update or model attribute interpolation.

10. A device for creating a three-dimensional mesh model, characterized in that: The device comprises: A creation request acquisition module is used to obtain a creation request for a three-dimensional mesh model; a model information determination module, configured to determine the three-dimensional geometric information and spatial attribute type of the three-dimensional volume mesh model according to the creation request; The model creation module is used to create the three-dimensional body grid model in the database according to the three-dimensional geometric information and the spatial attribute type.

11. A data processing device based on a three-dimensional mesh model, characterized in that: The device comprises: A processing request acquisition module is used to obtain a data processing request for a three-dimensional mesh model in a database; A model processing module, configured to perform corresponding processing on the three-dimensional mesh model in the database according to the data processing request; Wherein, the three-dimensional mesh model is created according to the method according to any one of claims 1-5.

12. An electronic device, characterized in that: The electronic device includes a memory, a processor, and a computer program stored in the memory, and the processor implements the method according to any one of claims 1 to 9 when executing the computer program.

13. A computer-readable storage medium, characterized in that The computer-readable storage medium stores a computer program, and when the computer program is executed by a processor, the method according to any one of claims 1 to 9 is implemented.

14. A computer program product, characterized in that The computer program product comprises a computer program, and when the computer program is executed by a processor, the method according to any one of claims 1 to 9 is implemented.