Database linkage operation method, medium and equipment

Abstract

The invention discloses a database linkage operation method, a medium and equipment, and relates to the technical field of data storage, and the method comprises the steps: obtaining a target type definition file and a target BIM model corresponding to a target project, constructing a first target database based on the target type definition file and target object data, and constructing a second target database based on the target type definition file and target feature data, according to the BIM data management method and system, the BIM data are subjected to two-way linkage operation, the second target database is constructed, two-way linkage operation of the first target database and the second target database is achieved through the target mixed statements, and it can be known that refined management of the BIM data is achieved, so that the storage mode expansibility is good, different databases are selected for data storage based on different features of the BIM data, and the BIM data management efficiency is improved. Different parts of the same BIM data are stored in a proper database, and the performance of a graph database and the performance of a relational database are brought into full play.

Description

Technical Field

[0001] The present invention relates to the technical field of data storage, and in particular to a method, medium and device for database linkage operation. Background Art

[0002] At present, the mainstream form of BIM data management is based on files, which emphasizes the collection and unified management of files of different formats and their external distribution as a central connection node. With the continuous deepening of engineering digitalization business, it is found that file-level BIM data management has obvious deficiencies in data consistency, transmission efficiency, data security, etc. Therefore, more refined management of BIM data has become an urgent problem to be solved.

[0003] The method for hybrid storage of BIM data in the prior art is: linking highly structured databases such as geometric data and attribute data to MySQL, and storing data of other document types in document-oriented databases such as MongoDB. The above method for hybrid storage of BIM data does not perform fine management of BIM data, which limits the scalability of the storage method, does not store different parts of the same BIM data in a suitable database, and does not give full play to the performance of different databases. Summary of the invention

[0004] In view of the above technical problems, the technical solution adopted by the present invention is a method for database linkage operation, which comprises the following steps: A target type definition file and a target BIM model corresponding to the target project are obtained, wherein the target BIM model stores a plurality of target object data and target feature data corresponding to the target object data.

[0005] Based on the target type definition file and the target object data, a first target database is constructed, wherein the first target database is a graph database generated based on the target type definition file and a plurality of target objects in the target BIM model.

[0006] Based on the target type definition file and the target feature data, a second target database is constructed, wherein the second target database is a relational database generated based on the target type definition file and the target feature data in the target BIM model.

[0007] Through the target mixed statement, a bidirectional linkage operation between the first target database and the second target database is realized.

[0008] The present invention also provides a non-transitory computer-readable storage medium, in which at least one instruction or at least one program is stored, and the at least one instruction or at least one program is loaded and executed by a processor to implement the above-mentioned database linkage operation method.

[0009] The present invention also provides an electronic device, including a processor and a memory, wherein the memory stores at least one instruction or at least one program, and the at least one instruction or the at least one program is loaded and executed by the processor to implement the above-mentioned database linkage operation method.

[0010] The present invention has at least the following beneficial effects: the present invention can obtain the target type definition file and the target BIM model corresponding to the target project, and construct a first target database based on the target type definition file and the target object data, wherein the first target database is a graph database generated based on the target type definition file and several target objects in the target BIM model; and construct a second target database based on the target type definition file and the target feature data, wherein the second target database is a relational database generated based on the target type definition file and the target feature data in the target BIM model; and realize the bidirectional linkage operation between the first target database and the second target database through the target mixed statement. It can be seen that the present invention realizes the refined management of BIM data, so that the storage method has better scalability, and based on the different characteristics of BIM data, different databases are selected for data storage based on different characteristics, and different parts of the same BIM data are stored in a suitable database, giving full play to the performance of the graph database and the relational database. BRIEF DESCRIPTION OF THE DRAWINGS

[0011] In order to more clearly illustrate the technical solutions in the embodiments of the present invention, the following briefly introduces the drawings required for use in the description of the embodiments. Obviously, the drawings described below are only some embodiments of the present invention. For ordinary technicians in this field, other drawings can be obtained based on these drawings without creative work.

[0012] Figure 1 A flowchart of a method for database linkage operation provided in Embodiment 1 of the present invention; Figure 2 This is a flowchart of S400 provided in the first embodiment of the present invention. DETAILED DESCRIPTION

[0013] The following will be combined with the drawings in the embodiments of the present invention to clearly and completely describe the technical solutions in the embodiments of the present invention. Obviously, the described embodiments are only part of the embodiments of the present invention, not all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by those skilled in the art without creative work are within the scope of protection of the present invention.

[0014] It should be noted that the terms "first", "second", etc. in the specification and claims of the present invention and the above-mentioned drawings are used to distinguish similar objects, and are not necessarily used to describe a specific order or sequence. It should be understood that the data used in this way can be interchangeable where appropriate, so that the embodiments of the present invention described herein can be implemented in an order other than those illustrated or described herein. In addition, the terms "including" and "having" and any variations are intended to cover non-exclusive inclusions, for example, a process, method, system, product or server that includes a series of steps or units is not necessarily limited to those steps or units clearly listed, but may include other steps or units that are not clearly listed or inherent to these processes, methods, products or devices.

[0015] Embodiment 1, This embodiment provides a method for database linkage operation, the method comprising the following steps: Figure 1 As shown: S100, obtaining a target type definition file and a target BIM model corresponding to a target project, wherein the target BIM model stores a plurality of target object data and target feature data corresponding to the target object data.

[0016] Specifically, the target project is a construction project in a selected field, such as a target project such as a bridge project.

[0017] Specifically, the target type definition file is a file that defines and describes the data type, data structure or data interface in the BIM model based on the target standard.

[0018] Preferably, the target standard is the IFC standard.

[0019] Specifically, the target BIM model is a BIM model that stores data related to the target project.

[0020] Specifically, the target object data is data corresponding to the target object, wherein the target object is a building entity related to the target project, for example, when the target project is a bridge project, tie beams, bridge piers, pile foundations, etc. are target objects.

[0021] Specifically, the target feature data is data that characterizes several features of the target object.

[0022] Furthermore, the target feature data includes: attribute data, position data, relationship data, geometric data and material data. For example, when the target project is a bridge project, the position information of the piers, the geometric shape of the piers, the design parameters of the piers, the engineering quantity calculation data of the piers and other data all belong to the target feature data corresponding to the target project.

[0023] Furthermore, the attribute data is characteristic or descriptive information data of each element in the target BIM model, for example, attribute data such as material, volume, and opening method of the bridge.

[0024] S200, constructing a first target database based on a target type definition file and target object data, wherein the first target database is a graph database generated based on the target type definition file and a plurality of target objects in a target BIM model.

[0025] Specifically, the first target database includes target object nodes, relationship nodes and association nodes and the association relationships between them, wherein the target object node is a node of the target object, the relationship node is a node that represents the relationship between target objects, and the association node is a node that stores connection information with the second target database, for example: target object nodes such as piers and pile foundations, relationship nodes such as aggregation relationships, and association nodes such as geometric associations, position associations, and attribute associations.

[0026] In a specific embodiment, when the target project is a bridge project and the target standard corresponding to the target type definition file is the IFC standard, S200 further includes the following steps: S201, creating a target object node and a relationship node in a preset graph database, wherein the node attributes corresponding to the target object node are the attribute name of the target object in the target type definition file and the attribute value stored in the target object in the target BIM model.

[0027] Specifically, those skilled in the art know that the preset graph database can be selected according to actual needs, which falls within the protection scope of the present invention and will not be described in detail here.

[0028] S202, creating an associated node in a preset graph database, wherein the node attribute corresponding to the associated node includes connection information with a second target database.

[0029] Specifically, the creation method of the association node is consistent with the creation method of the target object node and the relationship node.

[0030] Furthermore, the associated node is a node that stores connection information with the second target database.

[0031] S203: Associating the nodes created in the preset graph database through the first reference method and the second reference method to obtain the first target database.

[0032] Specifically, the first reference method is a direct reference method starting from the target object node and directly pointing to the referenced target object node.

[0033] Specifically, the second reference method is an indirect reference method starting from the relationship node and pointing to the referencing target object node and the referenced target object node respectively, for example: the connection between the node marked as IfcRelAggregates and the node marked as IfcElementAssembly is named RelatingObject and the connection between the node marked as IfcRelAggregates and the node marked as IfcBeam is named RelatedObjects.

[0034] S300, constructing a second target database based on the target type definition file and the target feature data, wherein the second target database is a relational database generated based on the target type definition file and the target feature data in the target BIM model.

[0035] Specifically, the second target database includes an association table and a data table, wherein the association table is used to store connection information with the first target database and an association relationship with the data table, and each target feature data of each target object corresponds to an association table.

[0036] Furthermore, when the data volume corresponding to the target feature data of multiple target objects of the same type exceeds a preset threshold, the target feature data of each target object is stored in multiple data tables, and there is an association relationship in each data table. When the data volume corresponding to the target feature data of the same type does not exceed the preset threshold, the target feature data of each target object is stored in one data table.

[0037] Furthermore, those skilled in the art know that the preset threshold value can be selected according to actual needs, which falls within the protection scope of the present invention and will not be described in detail here.

[0038] Specifically, the construction of the second target database is generated on a preset relational database, wherein those skilled in the art know that the preset relational database can be selected according to actual needs, all of which fall within the protection scope of the present invention and will not be described in detail here.

[0039] Preferably, the preset relational database is a PostGreSQL database.

[0040] In a specific embodiment, taking a data table storing geometric data as an example, when the target project is a bridge project and the target standard corresponding to the target type definition file is the IFC standard, the data table is obtained in three ways: Mesh, parameterization and Brep. The Mesh method is to design a representation_mesh table in a preset relational database. The table contains at least three fields: primary key id, vertex coordinate point, and vertex index index, which store the eight vertex coordinates and connection index data of the target object in the target project.

[0041] The parametric method is to design a parameter table to store geometric data. For example, the parameter values ​​of the length, width, and height of the tie beam design parameters are stored in the parameter table representation_parameters.

[0042] The Brep method is to design a topological data table and a vertex coordinate table to store geometric data through topological relationships. For example, the topological data of the body, surface, edge, vertex and other topological types of the tie beam component are stored in the topological data table representation_brep, and the vertex coordinate data are stored in the coordinate table representation_point.

[0043] S400, implementing a bidirectional linkage operation between the first target database and the second target database through a target mixed statement.

[0044] Specifically, S400 also includes the following steps: Figure 2 As shown: S401, when the first target database is a primary database and the second target database is a secondary database, the target mixed statement begins with a Clause in the Cypher language, and a Clause in the SQL language is used as a restriction condition.

[0045] Specifically, the SQL statement needs to be written in the execution environment SQL() function.

[0046] S402: When the first target database is a secondary database and the second target database is a primary database, the target mixed statement begins with a Clause in the SQL language and a Clause in the Cypher language is used as a restriction condition.

[0047] Specifically, the Cypher statement needs to be written in the execution environment CQL() function.

[0048] Specifically, the bidirectional linkage operation is to perform bidirectional linkage query, addition, deletion and update operations on the first target database and the second target database based on the target mixed statement, wherein the bidirectional operation includes forward and reverse directions, for example: to find the construction that requires 5.5m3 The name of the tie beam component with concrete consumption is a forward linkage operation, and searching for the concrete consumption required for the construction of the component named "Lundu Road Bridge-Left Span-Left 1#-Tie Beam 2-2-b" is a reverse linkage operation.

[0049] Furthermore, those skilled in the art know that the operation statement can be set based on the mixed statement to perform linkage operation according to actual needs, which falls within the protection scope of the present invention and will not be repeated here. For example, the target mixed statement is obtained as: Match(n:IfcBeam)-[*]-(t:IfcPropertySet) Where id(t) = SQL("pg", Select n-id From property_rel_table JOINproperty_table ON property_rel_table.d-id = property_table.id Where property_table.concrete-volume = 5.5 ) Return n.Name to achieve the search construction requires 5.5m 3 The name of the tie beam member for the amount of concrete.

[0050] From the above content, we can see that refined management of BIM data has been achieved, making the storage method more scalable. Based on the different characteristics of BIM data, different databases are selected for data storage, and different parts of the same BIM data are stored in appropriate databases, giving full play to the performance of graph databases and relational databases.

[0051] The first embodiment of the present invention can obtain the target type definition file and the target BIM model corresponding to the target project, and construct a first target database based on the target type definition file and the target object data, wherein the first target database is a graph database generated based on the target type definition file and a number of target objects in the target BIM model; and construct a second target database based on the target type definition file and the target feature data, wherein the second target database is a relational database generated based on the target type definition file and the target feature data in the target BIM model. Through the target mixed statement, the bidirectional linkage operation between the first target database and the second target database is realized. It can be seen that the present invention realizes the refined management of BIM data, so that the storage method has better scalability, and based on the different characteristics of the BIM data, different databases are selected for data storage based on different characteristics, and different parts of the same BIM data are stored in a suitable database, giving full play to the performance of the graph database and the relational database.

[0052] Embodiment 2: An embodiment of the present invention provides a non-transitory computer-readable storage medium, wherein at least one instruction or at least one program is stored in the non-transitory computer-readable storage medium, and the at least one instruction or at least one program is loaded and executed by a processor to implement the steps: A target type definition file and a target BIM model corresponding to the target project are obtained, wherein the target BIM model stores a plurality of target object data and target feature data corresponding to the target object data.

[0053] Based on the target type definition file and the target object data, a first target database is constructed, wherein the first target database is a graph database generated based on the target type definition file and a plurality of target objects in the target BIM model.

[0054] Based on the target type definition file and the target feature data, a second target database is constructed, wherein the second target database is a relational database generated based on the target type definition file and the target feature data in the target BIM model.

[0055] Through the target mixed statement, a bidirectional linkage operation between the first target database and the second target database is realized.

[0056] Those skilled in the art can understand that all or part of the processes in the above-mentioned embodiment methods can be completed by instructing the relevant hardware through a computer program, and the computer program can be stored in a non-volatile computer-readable storage medium. When the computer program is executed, it can include the processes of the embodiments of the above-mentioned methods. Among them, any reference to memory, storage, database or other media used in the embodiments provided in this application can include non-volatile and / or volatile memory. Non-volatile memory may include read-only memory (ROM), programmable ROM (PROM), electrically programmable ROM (EPROM), electrically erasable programmable ROM (EEPROM) or flash memory. Volatile memory may include random access memory (RAM) or external cache memory. As an illustration and not limitation, RAM is available in many forms, such as static RAM (SRAM), dynamic RAM (DRAM), synchronous DRAM (SDRAM), double data rate SDRAM (DDRSDRAM), enhanced SDRAM (ESDRAM), synchronous link (Synchlink) DRAM (SLDRAM), memory bus (Rambus) direct RAM (RDRAM), direct memory bus dynamic RAM (DRDRAM), and memory bus dynamic RAM (RDRAM).

[0057] Those skilled in the art can clearly understand that for the convenience and simplicity of description, only the division of the above-mentioned functional units and modules is used as an example. In actual applications, the above-mentioned functions can be assigned to different functional units and modules as needed, that is, the internal structure of the device can be divided into different functional units or modules to complete all or part of the functions described above.

[0058] Embodiment 3, An embodiment of the present invention provides an electronic device, including a processor and a memory, wherein the memory stores at least one instruction or at least one program, and the at least one instruction or the at least one program is loaded and executed by the processor to implement the steps: A target type definition file and a target BIM model corresponding to the target project are obtained, wherein the target BIM model stores a plurality of target object data and target feature data corresponding to the target object data.

[0059] Based on the target type definition file and the target object data, a first target database is constructed, wherein the first target database is a graph database generated based on the target type definition file and a plurality of target objects in the target BIM model.

[0060] Based on the target type definition file and the target feature data, a second target database is constructed, wherein the second target database is a relational database generated based on the target type definition file and the target feature data in the target BIM model.

[0061] Through the target mixed statement, a bidirectional linkage operation between the first target database and the second target database is realized.

[0062] The above description is only a preferred embodiment of the present invention and does not limit the present invention in any form. Although the present invention has been disclosed as a preferred embodiment as above, it is not used to limit the present invention. Any technician familiar with this profession can make some changes or modifications to equivalent embodiments of equivalent changes using the technical contents disclosed above without departing from the scope of the technical solution of the present invention. However, any simple modifications, equivalent changes and modifications made to the above embodiments based on the technical essence of the present invention without departing from the content of the technical solution of the present invention are still within the scope of the technical solution of the present invention.

Claims

1. A method for database linkage operation, characterized in that: The method comprises the following steps: Obtain a target type definition file and a target BIM model corresponding to a target project, wherein the target BIM model is a BIM model storing data related to the target project, wherein the target BIM model stores a number of target object data and target feature data corresponding to the target object data, wherein the target object data is data corresponding to the target object, wherein the target object is a building entity related to the target project, and wherein the target feature data is data characterizing a number of features of the target object, wherein the target feature data includes: attribute data, position data, relationship data, geometry data, and material data; Based on the target type definition file and the target object data, a first target database is constructed, wherein the first target database is a graph database generated based on the target type definition file and a plurality of target objects in the target BIM model; Based on the target type definition file and the target feature data, construct a second target database, wherein the second target database is a relational database generated based on the target type definition file and the target feature data in the target BIM model; Through the target mixed statement, a bidirectional linkage operation between the first target database and the second target database is realized.

2. The method for database linkage operation according to claim 1, characterized in that: The target type definition file is a file that defines and describes the data type, data structure or data interface in the BIM model based on the target standard.

3. The method for database linkage operation according to claim 1, characterized in that: The first target database includes target object nodes, relationship nodes and association nodes and the association relationships between them, wherein the target object nodes are nodes of target objects, the relationship nodes are nodes representing the relationships between target objects, and the association nodes are nodes storing connection information with the second target database.

4. The method for database linkage operation according to claim 1, characterized in that: The second target database includes an association table and a data table, wherein the association table is used to store connection information with the first target database and an association relationship with the data table, and each target object's target feature data corresponds to an association table, wherein, when the data volume corresponding to the target feature data of multiple target objects of the same type exceeds a preset threshold, the target feature data of each target object is stored in multiple data tables, and there is an association relationship in each data table, and when the data volume corresponding to the target feature data of the same type does not exceed the preset threshold, the target feature data of each target object is stored in one data table.

5. The method for database linkage operation according to claim 1, characterized in that: Implementing the bidirectional linkage operation between the first target database and the second target database through the target mixed statement also includes the following steps: When the first target database is the primary database and the second target database is the secondary database, the target hybrid statement begins with a Clause in the Cypher language and a Clause in the SQL language is used as a restriction condition; When the first target database is a secondary database and the second target database is a primary database, the target mixed statement begins with a Clause in the SQL language, and a Clause in the Cypher language is used as a restriction condition.

6. A non-transitory computer-readable storage medium, wherein at least one instruction or at least one program is stored in the non-transitory computer-readable storage medium, characterized in that: The at least one instruction or the at least one program is loaded and executed by the processor to implement the method for database linkage operation as described in any one of claims 1-5.

7. An electronic device, characterized in that: It comprises a processor and a memory, wherein the memory stores at least one instruction or at least one program, and the at least one instruction or the at least one program is loaded and executed by the processor to implement the method for database linkage operation as described in any one of claims 1-5.

Images