A method for constructing a building structure metadata database and its application method and device
By building a building material and load database, the problems of cumbersome construction practices and low degree of automation in professional architectural design are solved, efficient load analysis and calculation are achieved, and the automation and accuracy of architectural design are improved.
Patent Information
- Application Number
- CN202411321861.X
- Authority / Receiving Office
- CN · China
- Patent Type
- Patents(China)
- Current Assignee / Owner
- Filing Date
- 2024-09-23
- Publication Date
- 2024-11-26
- Estimated Expiration
- 2044-09-23
AI Technical Summary
In professional architectural design, the construction practices are complicated, the degree of automation is low, and the model accuracy is low, which makes it difficult to automate the extraction, processing and conversion of building measures information, and it relies on manual processing, which is time-consuming and has a high error rate.
The building material database and load database are built using JSON data format. Through standardized processing and induction classification, mapping and integration are used to form a building structural element database. The JSON_INSERT and JSON_EXTRACT functions are used to write to the cloud MySQL to realize the integration of building element levels and construction practices and load data. Integration.
It improves data acquisition efficiency, reduces the difficulty of load analysis and calculation, improves load analysis and calculation efficiency, simplifies data writing and transmission, and enhances the universality and automation of the system.
Smart Images

Figure CN118861008B_ABST
Abstract
Description
Technical Field
[0001] The present invention relates to the technical field of building engineering design, and in particular to a method for constructing a building structure metadata database and an application method and device thereof. Background Art
[0002] At present, the architectural profession cannot effectively store the construction measures in the design BIM model during the design process. It is necessary to compile a separate construction measures table file to express the structural measures of different parts. The structural profession needs to query the construction measures table and material density table as the basis for load calculation. The cost profession needs to query the construction measures table and relevant measurement and pricing specifications to estimate the material cost of the project, and further estimate the overall cost of the entire project. The floor, roof, exterior wall finish, interior wall finish, and ceiling model in the architectural design work tasks are low in precision. The construction engineering measures are complex and diverse, and it is impossible to express the construction measures in a refined way in the BIM model. The construction measures are not uniform in practice and the naming rules of each structural layer are not unified. The extraction, processing, and conversion of information are difficult to automate. The naming rules are not unified. Subsequent use requires manual information query, processing, and other work to query related documents. In addition, the structural profession obtains the construction professional design practices and measures to calculate the load, relying on manual work. The main method is to rely on work experience or query standards and specifications. The whole process is complicated and time-consuming. Cost professionals need to rely on work experience and manual inquiries to obtain the practices and measures of architectural design to carry out quantity calculation and pricing. The whole process is complicated, time-consuming and has a high error rate. Summary of the invention
[0003] In order to solve the problems of complicated construction methods, low automation, low model accuracy, etc. in existing professional architectural designs, the present invention provides a method for constructing a building structure metadata database and an application method and device thereof.
[0004] In order to achieve the above-mentioned object of the invention, the present invention provides the following technical solutions:
[0005] In a first aspect, the present invention provides a method for constructing a building structure metadata database, the method comprising:
[0006] Acquire the construction method of each level of the building element, and perform a first standardization process on the first building material used in the construction method corresponding to each level of each building element;
[0007] Based on the processed first building material and the layers and construction methods corresponding to the processed first building material, a material database is constructed in JSON data format;
[0008] Obtaining load data of the second building material, and performing a second standardization process on each second building material;
[0009] Based on the processed second building materials and the load data corresponding to each second building material, a material load database is built in JSON data format;
[0010] Mapping and merging the material database and the material load database based on the JSON data format to build a building structure metadata database;
[0011] The first standardization process includes: assigning a material code and a material standard name to each first building material;
[0012] The second standardization process includes: classifying each second building material according to the first building material, so that the second building material and the first building material are mapped to each other.
[0013] According to a specific implementation, in the above construction method, mapping and merging the material database and the material load database based on JSON data includes:
[0014] Creating a temporary JSON building construction metadata file based on the first building material and the corresponding layer and construction method in the material database, and the second building material corresponding to the first building material in the material load database and the corresponding load data are integrated;
[0015] Extract the corresponding first building material, layer, second building material and load data in the temporary JSON building construction metadata file based on the construction practice, insert the thickness value, and generate a formal JSON building construction metadata file;
[0016] The formal JSON building structure metadata file is written into the cloud MySQL through the JSON_INSERT function to generate a building structure metadata database.
[0017] According to a specific implementation, in the above construction method, the method further includes:
[0018] Based on the constructed material database, the first building material is queried in the material database through the JSON_EXTRACT function; and the first building material is entered into the material database through the JSON_INSERT function.
[0019] According to a specific implementation, in the above construction method, the method further includes:
[0020] Based on the constructed material load database, the second building material is queried in the material load data through the JSON_EXTRACT function; and the second building material is entered into the material load database through the JSON_INSERT function.
[0021] According to a specific implementation, in the above construction method, the method further includes:
[0022] Based on the constructed material database / material load database, the material database / material load database is written into the cloud MySQL through the JSON_INSERT function.
[0023] According to a specific embodiment, in the above construction method, the building elements include roof, floor, interior wall facing, exterior wall facing and ceiling.
[0024] According to a specific implementation, in the above construction method, the load data includes a minimum capacity, a maximum capacity, a load unit and a material description.
[0025] In a second aspect, the present invention provides a method for applying a building structure metadata database, the method comprising:
[0026] Select the building element to which you want to add metadata in the building model
[0027] Acquire corresponding metadata from a building structure metadata database constructed by the building structure metadata database construction method described in any one of the above items;
[0028] The metadata includes the levels corresponding to the building elements, the construction methods corresponding to each level, the first building material used in each construction method, the second building material corresponding to the first building material, and the load data corresponding to the second building material;
[0029] The acquired metadata is written into the building element.
[0030] According to a specific implementation, in the above application method, the method further includes:
[0031] generating an addition column according to the building structure metadata database, wherein the addition column is used to select a newly added structural level;
[0032] When a new structural level is selected, metadata matching the structural level is automatically brought in.
[0033] In a third aspect, the present invention also provides an electronic device, comprising at least one processor and a memory communicatively connected to the at least one processor; the memory stores instructions executable by the at least one processor, and the instructions are executed by the at least one processor so that the at least one processor can execute any one of the above-mentioned methods for constructing a building structure metadata database, or execute any one of the above-mentioned methods for applying a building structure metadata database.
[0034] Compared with the prior art, the present invention has the following beneficial effects:
[0035] Based on the technical solution of the first aspect above, the present invention improves data acquisition efficiency by integrating the levels and construction methods contained in each building element and the building materials used, and integrating the corresponding load data, so as to build a database; at the same time, the present invention not only solves the problem of inconsistent material names in the design process through standardized processing, but also can classify different materials by induction, so as to facilitate the acquisition of corresponding load data, thereby improving the efficiency of load analysis and calculation, and reducing the difficulty of load analysis and calculation in the design; further, the database built based on the JSON data format of the present invention provides convenience for different programs to parse and process, and at the same time utilizes the advantages of small size and easy reading and writing of the JSON data format to improve transmission efficiency, reduce the difficulty of data writing, and has high versatility, which is helpful for cost professionals to quickly obtain material usage data of building elements in the BIM model.
[0036] Based on the technical solution of the second aspect mentioned above, the present invention can be widely used in two-dimensional and three-dimensional architectural design processes based on the established architectural structure metadata database, which helps to greatly improve the efficiency of assigning attributes to architectural elements and practices when architectural professionals design them, and lays the foundation for further application of other work processes and results. BRIEF DESCRIPTION OF THE DRAWINGS
[0037] Figure 1 A schematic diagram of a flow chart of a method for constructing a building structure metadata database provided in an embodiment of the present application;
[0038] Figure 2 A schematic diagram of a general material JSON data file provided in an embodiment of the present application;
[0039] Figure 3 A schematic diagram of the process of entering the material database provided in the embodiment of the present application;
[0040] Figure 4 A schematic diagram of a material input interface of a material database provided in an embodiment of the present application;
[0041] Figure 5 A schematic diagram of a process for building a material load database provided in an embodiment of the present application;
[0042] Figure 6 A schematic diagram of a material load JSON data file provided in an embodiment of the present application;
[0043] Figure 7 A schematic diagram of the process of entering the material load database provided in the embodiment of the present application;
[0044] Figure 8A schematic diagram of a material input interface for a material load database provided in an embodiment of the present application;
[0045] Fig. 9 A schematic diagram of a flow chart of a method for establishing a building structure metadata database provided in an embodiment of the present application;
[0046] Fig.10 A schematic diagram of a temporary JSON building construction metadata file provided in an embodiment of the present application;
[0047] Fig.11 A schematic diagram of transforming a temporary JSON building construction metadata file provided in an embodiment of the present application;
[0048] Fig.12 A general flow chart of a building structure metadata database application method provided in an embodiment of the present application;
[0049] Fig.13 A schematic diagram of the BIM model and BIM application software provided in an embodiment of the present application. DETAILED DESCRIPTION
[0050] The present application is further described in detail below in conjunction with test examples and specific implementation methods. However, this should not be understood as the scope of the above subject matter of the present application being limited to the following embodiments, and all technologies implemented based on the content of the present application belong to the scope of the present application.
[0051] The terms "first", "second", etc. in the specification embodiments, claims, and drawings of the present application are only used for the purpose of distinguishing descriptions, and cannot be understood as indicating or implying relative importance, nor can they be understood as indicating or implying order. In addition, the terms "including" and "having" and any variations thereof are intended to cover non-exclusive inclusions, for example, including a series of steps or units. The method, system, product, or device 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.
[0052] The building practice measure table is compiled according to relevant industry standards and is one of the formal architectural design delivery results. It mainly includes the practices of roofs, floors, exterior walls, interior walls, ceilings, skirtings, and paints and their applicable functional spaces, that is, the different building parts are described in detail according to the structural level, and the structural level, that is, the relevant project practices, thickness, scope, material combustion level, use location and remarks are described in detail in the layered expression. In the design, it can improve the depth of the information expression of the building profession, provide a basis for load calculation for the structure profession, and provide a basis for material measurement and pricing for the cost profession. In the construction, it can effectively guide the construction unit to carry out construction. In the design work, the measure table plays a role in the transfer of information.
[0053] Therefore, this application focuses on the automated creation and selection of measures for roofs, floors, exterior walls, interior walls, and ceilings in the construction profession, establishes a data basis for structural load calculation and cost calculation, and proposes a method for constructing and applying a building structure metadata database based on BIM technology. Building structure metadata is the smallest data unit of a digital design model. The purpose is to improve the standardization of building measures in the BIM design system and the accuracy and efficiency of automatic acquisition of building design information by structural and cost professionals in the process of building engineering design, transform traditional data sets into an integrated structured database, form a building structure metadata database, and enhance data value. As more and more construction engineering design methods adopt the promotion and popularization of BIM technology, the method proposed in this patent application will further play the role of BIM technology applied to the construction profession, and the design process will have a higher value.
[0054] Specifically, please refer to Figure 1 , which shows a schematic flow chart of a method for constructing a building structure metadata database provided in an embodiment of the present application, the method comprising:
[0055] Step 100: Acquire the construction method of each level of the building element, and perform a first standardization process on the first building material used in the construction method corresponding to each level of each building element.
[0056] In this embodiment, 23J909 "Engineering Practice" is taken as an example. This standard covers a large number of mature and technical building practices, which can be applied to most construction projects. According to the functional requirements of the building's functional space, the roof, floor, interior wall finish, exterior wall finish, and ceiling building elements are constructed at different levels based on their base and according to the functional requirements. In the practice, only the practice and material type are often specified, without specifying the specific material brand used in the practice. All the construction practices in the measure table are highly versatile and can summarize the practices of the roof, floor, interior wall finish, exterior wall finish, and ceiling building elements.
[0057] By summarizing 23J909 "Engineering Practices", the layers and practices of roof, floor, interior wall finishes, exterior wall finishes, and ceiling architectural elements are formed. Some examples are shown in Table 1.
[0058] Table 1 Examples of architectural elements of roofs, floors, interior wall finishes, exterior wall finishes, and ceilings
[0059]
[0060] The first standardization process includes: assigning a material code and a material standard name to each first building material.
[0061] In this embodiment, GBT 51269-2017 "Classification and Coding Standard for Building Information Model" is taken as an example. This standard is a national standard issued by the Ministry of Housing and Urban-Rural Development of the People's Republic of China, which aims to standardize the classification and coding of information in building information models and realize the exchange and sharing of information throughout the life cycle of construction projects. This standard divides the classification structure of building information models into four categories: construction achievements, construction progress, construction resources, and construction attributes, with a total of 15 subcategories / forms. The coding rules of "table code-major category code. Medium category code. Subcategory code. Detailed category code" are implemented according to different project perspectives. The classification structure and table code are shown in Table 2.
[0062] Table 2 Examples from GBT 51269-2017 Classification and Coding Standard for Building Information Modeling
[0063]
[0064] According to the method provided in this application, the idea of splitting the building elements of the roof, floor, interior wall, exterior wall and ceiling by layer is applicable to the selection of work results (table code 15) and building product forms (table code 30) for material coding and determining the material standard name, the purpose of which is to use coding to unify the names of different building practices. For example, in the construction profession, there are many expressions such as "9-thick DP M15 mortar (1:3 cement mortar) compacted and smoothed", "5-thick DPM20 mortar (1:2.5 cement mortar) leveled and smoothed", "use DP-HRM20 mortar (1:2 cement mortar) to level the seams", etc., but in GBT 51269-2017 "Classification and Coding Standards for Building Information Models", the unified name for the description of mortar is "plastering mortar".
[0065] Step 200: Based on the processed first building material and the layers and construction methods corresponding to the processed first building material, a material database is constructed using the JSON data format.
[0066] In order to make the technical solution of the present application clearer, the technical solution will be described later using "applicable structural level" instead of "level" in the present application.
[0067] The JSON data format has many advantages. It is highly versatile and can be easily parsed and processed by various programs. Secondly, the data structure of the JSON format is simple and clear, easy to read and write. In terms of data volume, the volume of JSON transmitted data is small, so the transmission efficiency is high, which is suitable for transmitting large amounts of data on the network. At the same time, the data in the JSON format is highly readable, easy to parse and generate by computers, and JSON supports all programming languages.
[0068] According to the method provided in the embodiment of the present application, a general material JSON data file is proposed such as Figure 2 shown.
[0069] Among them, "Material standard name" and "Material code" correspond to GBT 51269-2017 "Building Information Model Classification and Coding Standard", "Applicable structural level" corresponds to the level of construction elements such as roof, floor, interior wall finish, exterior wall finish, and ceiling mentioned in 23J909 "Engineering Practice", "Other material names" refers to different names of the same material in the practices of different building elements mentioned in 23J909 "Engineering Practice", and string means that the data type corresponding to this attribute is string type.
[0070] It is particularly noteworthy that the "base treatment" layer, as a pretreatment procedure for the structural layer and subsequent process materials, only considers its construction methods, but does not consider the material standard name, material code, applicable structural level, and construction methods, and is uniformly set to "None".
[0071] Furthermore, when building a material database, when defining the table structure, the field type can be directly set to JSON. MySQL provides a variety of functions to operate JSON data, as shown in Table 3.
[0072] Table 3 MySQL operation methods for JSON data
[0073]
[0074] Furthermore, the material database construction method proposed in the embodiment of the present application, in order to facilitate the query and entry of material data, mainly uses the material database entry program to complete the acquisition of material code, material standard name, applicable structural level, and other material names. The program is installed in the client completed by C# and finally written into the cloud MySQL material database. The process is as follows: Figure 3 shown.
[0075] Furthermore, the material is entered as Figure 4As shown. Users can obtain the material code, material standard name, applicable structural level, and other material names that need to be entered by querying 23J909 "Engineering Practice" and GBT 51269-2017 "Classification and Coding Standards for Building Information Models". In addition, users open the material database entry program, enter the material code or material standard name in the data entry area, and use the JSON_EXTRACT function to query whether the material exists in the material database. If not, continue to enter the material standard name, applicable structural level, and other material names, click the [Add Data] button to form a JSON data file, and write it to the material database through the JSON_INSERT function; if it exists, further determine whether the applicable structural level and other material names are exactly the same. If they are the same, end. If they are different, add the applicable structural level or other material names in the data entry area, and click the [Add Data] button to write it to the material database through the JSON_SET function.
[0076] In a possible implementation, the entry of the material database includes:
[0077] (1) The material database does not contain the material data to be added
[0078] 1) Users can obtain the material code, material standard name, applicable structural level, and other material names that need to be entered by querying 23J909 "Engineering Practice" and GBT 51269-2017 "Classification and Coding Standards for Building Information Modeling".
[0079] 2) The user opens the material database entry program, enters the material code in the data entry area, and queries the JSON_EXTRACT function to find that the material does not exist.
[0080] 3) The user continues to add material standard names, applicable construction levels, and construction methods, clicks the [Add Data] button to form a JSON data file, and writes it into the material database through the JSON_INSERT function, and the process ends.
[0081] (2) The material database contains material data that needs to be added, but the applicable construction levels and construction methods are different.
[0082] 1) Users can obtain the material code, material standard name, applicable structural level, and other material names that need to be entered by querying 23J909 "Engineering Practice" and GBT 51269-2017 "Classification and Coding Standards for Building Information Modeling".
[0083] 2) The user opens the material database entry program, enters the material code in the data entry area, and uses the JSON_EXTRACT function to find that the material exists and has the same standard name.
[0084] 3) The user further checks in the data query result area whether the applicable structural level and structural method already exist. If so, the process ends. If not, enter the applicable structural level and structural method in the data entry area, click the [Add Data] button to form a JSON data file, and append it to the material database through the JSON_SET function.
[0085] (3) The material data in the material database is exactly the same as the material data to be added
[0086] 1) Users can obtain the material code, material standard name, applicable structural level, and other material names that need to be entered by querying 23J909 "Engineering Practice" and GBT 51269-2017 "Classification and Coding Standards for Building Information Modeling".
[0087] 2) The user opens the material database entry program, enters the material code in the data entry area, and uses the JSON_EXTRACT function to query the existence of the material.
[0088] 3) The user further confirms that the material standard name, applicable structural level, and construction method are the same, and the process ends.
[0089] Step 300: Obtain load data of a second building material, and perform a second standardization process on each second building material.
[0090] The second standardization process includes: classifying each second building material according to the first building material, so that the second building material and the first building material are mapped to each other.
[0091] In this embodiment, taking GB50009-2012 "Building Structure Load Code" as an example, 15 forms related to the second building material are summarized, and combined with the load acquisition requirements of the building structure profession, a material load database construction method is proposed as follows: Figure 5 shown.
[0092] In the embodiment of the present application, firstly, the material load standard name corresponding to the second building material and its minimum bulk density, maximum bulk density, material unit, and material description are obtained according to GB50009-2012 "Code for Loads on Building Structures", and mapped to the material load JSON file through the application software, and then stored in the corresponding data form in the cloud material load database through the application software.
[0093] Furthermore, GB50009-2012 "Code for Loads on Building Structures" is an important standard for building structure design in China. It specifies the load types, load values, and load combinations that need to be considered when designing building structures. It also lists common material loads and establishes a mutual mapping between the first building material and the second building material accordingly. There are 15 tables related to building materials in GB50009-2012 "Code for Loads on Building Structures". Examples of some commonly used building materials and component self-weights are shown in Table 4.
[0094] Table 4 Some examples from GB50009-2012 Code for Loads on Building Structures
[0095]
[0096] This embodiment of the application summarizes and classifies common second building materials according to GB50009-2012 "Building Structure Load Code". Different from the standard names of materials, the structural profession has a more concise method of summarizing the names of the practice materials. For example, when the structural profession accepts the construction specialty table funding, it will encounter "9 thick DPM15 mortar (1:3 cement mortar) compacted and smoothed", "5 thick DPM20 mortar (1:2.5 cement mortar) leveled and smoothed", "use DP-HRM20 mortar (1:2 cement mortar) to level the seams" and other expressions. Its purpose is surface treatment. When the structural profession performs load calculations, it is unified as "cement mortar" according to GB50009-2012 "Building Structure Load Code", and the bulk density is 20KN / m³, without considering its mix ratio and process.
[0097] Step 400: Based on the processed second building materials and the load data corresponding to each second building material, a material load database is constructed using the JSON data format.
[0098] Specifically, the material load JSON data file proposed in the embodiment of the present application is as follows: Figure 6 As shown, "Material load standard name", "Unit of bulk density", and "Material description" are expressed in string form, and "Minimum bulk density" and "Maximum bulk density" are expressed in floating-point form to facilitate subsequent calculations.
[0099] Furthermore, in order to facilitate the query and entry of material data, a method for building a material load database is proposed in the embodiment of the present application. The method mainly uses a material load database entry program to complete the query and entry of material load standard name, minimum bulk density, maximum bulk density, bulk density unit, and material description. The program is a client completed in C# and is finally written into the cloud MySQL material database. The process is as follows: Figure 7shown.
[0100] The interface of the material load database entry program is as follows: Figure 8 As shown. Includes:
[0101] (1) The user queries GB50009-2012 Code for Loads on Building Structures to obtain the material load standard name, minimum bulk density, maximum bulk density, bulk density unit, and material description.
[0102] (2) The user opens the program, enters the name of the material load standard, and uses JSON_EXTRACT to query whether the material load exists. If it does, the process ends. If it does not exist, the user enters the minimum bulk density, maximum bulk density, bulk density unit, and material description, and then clicks the [Add Data] button to form a JSON data file, which is then added to the cloud-based MySQL material load database through JSON_INSERT.
[0103] Step 500: Map and merge the material database and the material load database based on the JSON data format to build a building structure metadata database.
[0104] After the above steps, the material database and the material load database are built. In this step, according to the JSON data file structure of the building structure metadata provided in the embodiment of the present application, the material database and the material load database are mapped and merged to form a building structure metadata database. The establishment method is as follows: Fig. 9 shown.
[0105] In this method, according to the actual needs of architectural engineering design, "construction practice" is taken as the object, and the material code, material standard name, applicable construction level, and other material names in each form in the material database are extracted. At the same time, the material load standard name, minimum bulk density, maximum bulk density, bulk density unit, and material description in the material load database are integrated to form a JSON metadata file, and stored in the roof practice metadata form, floor practice metadata form, interior wall practice metadata form, exterior wall practice metadata form, and ceiling practice metadata form through the JSON_INSERT function.
[0106] Furthermore, a building construction metadata JSON data file is constructed, first forming a temporary JSON building construction metadata file, and then forming a formal JSON building construction metadata file with "construction practices" as the object through transformation.
[0107] The temporary JSON building construction metadata file is obtained by fusing material data and material load data to obtain a temporary building design metadata structure, such as Fig.10 shown.
[0108] Then, through transformation, a formal JSON building construction metadata file with "construction practice" as the object is formed, and the thickness value of the int data type is extracted from the "construction practice", with the unified unit of millimeter. Finally, the JSON_INSERT function is used to insert it into the corresponding form of the cloud-based building construction metadata database. The schematic diagram is shown in the figure below. Fig.11 shown.
[0109] It is particularly noteworthy that the "base treatment" layer, as a pretreatment procedure for the structural layer and subsequent process materials, only considers its construction method, but does not consider the thickness, material load standard name, minimum bulk density, maximum bulk density, bulk density unit, material description, and is uniformly set to "None".
[0110] In a possible implementation, the embodiment of the present application provides a schematic diagram to illustrate how to construct the building construction metadata JSON data, as shown below:
[0111] The first step is to create a material data file of JSON data:
[0112] {
[0113] "Material Code": "30-15.70.20",
[0114] "Material Standard Name": "Plastering Mortar",
[0115] "Applicable structural level": {
[0116] "Applicable structural level_1": "Isolation layer",
[0117] "Applicable structural layer_2": "Leveling layer",
[0118] "Applicable structural layer_3": "Bonding layer"
[0119] },
[0120] "Construction method": {
[0121] "Construction method_1": "20 thick M151∶2.5 cement mortar",
[0122] "Construction method_2": "20 thick DS M15 mortar (1:3 cement mortar)",
[0123] "Construction method_3": "20 thick DS M20 polymer cement mortar (1:2.5 cement mortar)"
[0124] }
[0125] }.
[0126] The second step is to create a material load data file of JSON data:
[0127] {
[0128] "Material Load Standard Name": "Cement Mortar",
[0129] "Minimum bulk density": 20,
[0130] "Maximum bulk density": 20,
[0131] "Bulk density unit": "KN / m³",
[0132] "Material Description": "None"
[0133] }.
[0134] The third step is to generate a temporary JSON building structure metadata file:
[0135] {
[0136] "Material Code": "30-15.70.20",
[0137] "Material Standard Name": "Plastering Mortar",
[0138] "Applicable structural level": {
[0139] "Applicable structural level_1": "Isolation layer",
[0140] "Applicable structural layer_2": "Leveling layer",
[0141] "Applicable structural layer_3": "Bonding layer"
[0142] },
[0143] "Construction method": {
[0144] "Construction method_1": "20 thick M151∶2.5 cement mortar",
[0145] "Construction method_2": "20 thick DS M15 mortar (1:3 cement mortar)",
[0146] "Construction method_3": "20 thick DS M20 polymer cement mortar (1:2.5 cement mortar)"
[0147] },
[0148] "Material Load Standard Name": "Cement Mortar",
[0149] "Minimum bulk density": 20,
[0150] "Maximum bulk density": 20,
[0151] "Bulk density unit": "KN / m³",
[0152] "Material Description": "None"
[0153] }.
[0154] The fourth step is to form a formal JSON building construction metadata file with "construction practices" as the object:
[0155] {
[0156] "Construction method_1": "20 thick M15 1∶2.5 cement mortar",
[0157] "Material Code": "30-15.70.20",
[0158] "Material Standard Name": "Plastering Mortar",
[0159] "Applicable structural level": {
[0160] "Applicable structural level_1": "Isolation layer",
[0161] "Applicable structural layer_2": "Leveling layer",
[0162] "Applicable structural layer_3": "Bonding layer"
[0163] },
[0164] "Thickness":20,
[0165] "Material Load Standard Name": "Cement Mortar",
[0166] "Minimum bulk density": 20,
[0167] "Maximum bulk density": 20,
[0168] "Bulk density unit": "KN / m³",
[0169] "Material Description": "None"
[0170] }
[0171] {
[0172] "Construction method_2": "20 thick DS M15 mortar (1:3 cement mortar)",
[0173] "Material Code": "30-15.70.20",
[0174] "Material Standard Name": "Plastering Mortar",
[0175] "Applicable structural level": {
[0176] "Applicable structural level_1": "Isolation layer",
[0177] "Applicable structural layer_2": "Leveling layer",
[0178] "Applicable structural layer_3": "Bonding layer"
[0179] },
[0180] "Thickness":20,
[0181] "Material Load Standard Name": "Cement Mortar",
[0182] "Minimum bulk density": 20,
[0183] "Maximum bulk density": 20,
[0184] "Bulk density unit": "KN / m³",
[0185] "Material Description": "None"
[0186] }
[0187] {
[0188] "Construction method_3": "20 thick DS M20 polymer cement mortar (1:2.5 cement mortar),
[0189] "Material Code": "30-15.70.20",
[0190] "Material Standard Name": "Plastering Mortar",
[0191] "Applicable structural level": {
[0192] "Applicable structural level_1": "Isolation layer",
[0193] "Applicable structural layer_2": "Leveling layer",
[0194] "Applicable structural layer_3": "Bonding layer"
[0195] },
[0196] "Thickness":20,
[0197] "Material Load Standard Name": "Cement Mortar",
[0198] "Minimum bulk density": 20,
[0199] "Maximum bulk density": 20,
[0200] "Bulk density unit": "KN / m³",
[0201] "Material Description": "None"
[0202] }.
[0203] Since computer languages have good processing methods for JSON data formats, the process of forming a building structure metadata database from a material database and a material load database can be automatically completed by a preset program and written into the building structure metadata database.
[0204] Based on the above scheme, the present application improves the data acquisition efficiency by integrating the levels and construction methods contained in each building element and the building materials used, and integrating the corresponding load data to build a database; at the same time, the present application not only solves the problem of inconsistent material names in the design process through standardized processing, but also can classify different materials to facilitate the acquisition of corresponding load data, thereby improving the efficiency of load analysis and calculation and reducing the difficulty of load analysis and calculation in the design; further, the database built in the present application based on the JSON data format provides convenience for different programs to parse and process, and at the same time utilizes the advantages of small size and easy reading and writing of the JSON data format to improve transmission efficiency, reduce the difficulty of data writing, and has high versatility.
[0205] Furthermore, for the metadata database that has been constructed, the embodiment of the present application also provides a method for applying the building structure metadata database, including:
[0206] Select the building elements to which metadata needs to be added in the building model;
[0207] Acquire corresponding metadata from the building structure metadata database constructed by the building structure metadata database construction method described above;
[0208] The metadata includes the levels corresponding to the building elements, the construction methods corresponding to each level, the first building material used in each construction method, the second building material corresponding to the first building material, and the load data corresponding to the second building material;
[0209] The acquired metadata is written into the building element.
[0210] Furthermore, in this embodiment, the application method further includes:
[0211] generating an addition column according to the building structure metadata database, wherein the addition column is used to select a newly added structural level;
[0212] When a new structural level is selected, metadata matching the structural level is automatically brought in.
[0213] Specifically, after completing the building structure metadata database, the user can select the roof, floor, exterior wall finish, interior wall finish or ceiling building components to which metadata needs to be added during the construction of the BIM model, open the "CSWADI Building Structure Metadata Addition Program", obtain data from the cloud-based building structure metadata database, add building construction practices in layers, and write them into the building components in the BIM model in the form of attributes. The application method of the general process provided in the embodiment of the present application is as follows: Fig.12 shown.
[0214] In this embodiment, the BIM design software Autodesk Revit is taken as an example to provide a specific introduction and description. Fig.13 shown.
[0215] When a user builds a BIM model in Autodesk Revit software, he opens the building construction metadata management system provided in the embodiment of the present application and automatically obtains the BIM component element type selected by the current user. If it is incorrect, he can drop down to select it. The drop-down menu adopts an enumeration form and only includes the construction methods of five types of building elements: "roof, floor, exterior wall finish, interior wall finish, ceiling".
[0216] The BIM components in Revit do not directly record the building structure metadata database. Instead, a "structure" attribute is added to the components of the BIM model, which is bound to the "structure name" field in the metadata database. The "structure name" is used to search for other related data on the construction metadata user side.
[0217] The user enters a construction name to distinguish different approaches to the same type of building element.
[0218] When the user clicks "Add new structural level", a new row of data can be added to the data column. The user can select the required practice level through the drop-down in "Practice level" and select the required construction practice in the drop-down in "Construction practice". Other "Material standard name", "Material code", "Thickness (mm)", "Material load standard name", "Minimum bulk density", "Maximum bulk density", "Bulk density unit", and "Material description" parameters will be automatically imported.
[0219] Users can also use "Delete", "Modify", "Move Up" and "Move Down" to modify data.
[0220] After the user completes data input, click "OK" or "Apply" to write the data into the component properties. Clicking "OK" will automatically close the window after the data is written, and clicking "Apply" can allow the user to continue editing the data after the data is written.
[0221] Based on the above scheme, this application is based on the established architectural structure metadata database and can be widely used in two-dimensional and three-dimensional architectural design processes. It helps to greatly improve the efficiency of assigning attributes to architectural elements and practices when architectural professionals design them, and lays the foundation for further application of other work processes and results.
[0222] Furthermore, another aspect of the present application provides an electronic device, which includes a processor, a network interface and a memory, wherein the processor, the network interface and the memory are interconnected, wherein the memory is used to store a computer program, and the computer program includes program instructions, and the processor is configured to call the program instructions to execute the above-mentioned method for constructing a building structure metadata database, or the above-mentioned method for applying a building structure metadata database.
[0223] In the embodiments of the present application, the processor may be an integrated circuit chip having the ability to process signals. The processor may be a general-purpose processor, a digital signal processor (DSP), an application-specific integrated circuit (ASIC), a field programmable gate array (FPGA), or other programmable logic devices, discrete gate or transistor logic devices, or discrete hardware components.
[0224] The methods, steps and logic diagrams disclosed in the embodiments of the present application can be implemented or executed. The general processor can be a microprocessor or the processor can also be any conventional processor, etc. The steps of the method disclosed in the embodiments of the present application can be directly embodied as a hardware decoding processor for execution, or a combination of hardware and software modules in the decoding processor for execution. The software module can be located in a mature storage medium in the field such as a random access memory, a flash memory, a read-only memory, a programmable read-only memory or an electrically erasable programmable memory, a register, etc. The processor reads the information in the storage medium and completes the steps of the above method in combination with its hardware.
[0225] The storage medium may be a memory, which may be, for example, a volatile memory or a nonvolatile memory, or may include both volatile and nonvolatile memory.
[0226] Among them, the non-volatile memory can be a read-only memory (ROM), a programmable ROM (PROM), an erasable programmable read-only memory (EPROM), an electrically erasable programmable read-only memory (EEPROM), or a flash memory.
[0227] The volatile memory may be a random access memory (RAM) which is used as an external cache. By way of example and not limitation, many forms of RAM are available, such as static RAM (SRAM), dynamic RAM (DRAM), synchronous DRAM (SDRAM), double data rate synchronous DRAM (DDRSDRAM), enhanced SDRAM (ESDRAM), synchronous link DRAM (SLDRAM), and direct rambus RAM (DRRAM).
[0228] The storage media described in the embodiments of the present application are intended to include, but are not limited to, these and any other suitable types of memory.
[0229] It should be understood that the system disclosed in the present application can be implemented in other ways. For example, the division of the modules is only a logical function division, and there may be other division methods in actual implementation, such as multiple units or components can be combined or integrated into another system, or some features can be ignored or not executed. Another point is that the communication connection between modules can be through some interfaces, indirect coupling or communication connection of servers or units, which can be electrical or other forms.
[0230] In addition, each functional module in each embodiment of the present application can be integrated into one processing unit, or each module can exist physically separately, or two or more modules can be integrated into one processing unit. The above-mentioned integrated unit can be implemented in the form of hardware or in the form of software functional unit.
[0231] If the integrated unit is implemented in the form of a software functional unit and sold or used as an independent product, it can be stored in a computer-readable storage medium. Based on this understanding, the technical solution of the present application, in essence, or the part that contributes to the prior art or all or part of the technical solution can be embodied in the form of a software product, and the computer software product is stored in a storage medium, including a number of instructions to enable a computer device (which can be a personal computer, a server or a network device, etc.) to perform all or part of the steps of the method described in each embodiment of the present application. The aforementioned storage medium includes: U disk, read-only memory (ROM, Read-Only Memory), random access memory (RAM, Random Access Memory), mobile hard disk, disk or optical disk and other media that can store program codes.
[0232] The above description is only a preferred embodiment of the present application and is not intended to limit the present application. Any modifications, equivalent substitutions and improvements made within the spirit and principles of the present application should be included in the protection scope of the present application.
Claims
1. A method for constructing a building structure metadata database, characterized in that: The method comprises: Acquire the construction method of each level of the building element, and perform a first standardization process on the first building material used in the construction method corresponding to each level of each building element; the building element includes a roof, a floor, an interior wall finish, an exterior wall finish, and a ceiling, Based on the processed first building material and the layers and construction methods corresponding to the processed first building material, a material database is constructed in JSON data format; Obtaining load data of the second building material, and performing a second standardization process on each second building material; Based on the processed second building materials and the load data corresponding to each second building material, a material load database is built in JSON data format; Based on JSON data, the material database and the material load database are mapped and merged to build a building structure metadata database; The first standardization process includes: assigning a material code and a material standard name to each first building material; The second standardization process includes: classifying each second building material according to the first building material so that the second building material and the first building material are mapped to each other; Mapping and fusing the material database and the material load database based on JSON data includes: Creating a temporary JSON building construction metadata file based on the first building material and the corresponding layer and construction method in the material database, and the second building material corresponding to the first building material in the material load database and the corresponding load data are integrated; Extract the corresponding first building material, layer, second building material and load data in the temporary JSON building construction metadata file based on the construction practice, insert the thickness value, and generate a formal JSON building construction metadata file; The formal JSON building structure metadata file is written into the cloud MySQL through the JSON_INSERT function to generate a building structure metadata database.
2. A method for constructing a building structure metadata database according to claim 1, characterized in that: The method further comprises: Based on the constructed material database, the first building material is queried in the material database through the JSON_EXTRACT function; and the first building material is entered into the material database through the JSON_INSERT function.
3. A method for constructing a building structure metadata database according to claim 1, characterized in that: The method further comprises: Based on the constructed material load database, the second building material is queried in the material load data through the JSON_EXTRACT function; and the second building material is entered into the material load database through the JSON_INSERT function.
4. A method for constructing a building structure metadata database according to claim 1, characterized in that: The method further comprises: Based on the constructed material database / material load database, the material database / material load database is written into the cloud MySQL through the JSON_INSERT function.
5. The method for constructing a building structure metadata database according to claim 1, characterized in that: The load data includes a minimum capacity, a maximum capacity, a load unit and a material description.
6. A method for applying a building structure metadata database, characterized in that: The method comprises: Select the building elements to which metadata needs to be added in the building model; Acquire corresponding metadata from the building structure metadata database constructed by the building structure metadata database construction method according to claim 1; The metadata includes the levels corresponding to the building elements, the construction methods corresponding to each level, the first building material used in each construction method, the second building material corresponding to the first building material, and the load data corresponding to the second building material; The acquired metadata is written into the building element.
7. The method for applying a building structure metadata database according to claim 6, characterized in that: The method further comprises: generating an addition column according to the building structure metadata database, wherein the addition column is used to select a newly added structural level; When a new structural level is selected, metadata matching the structural level is automatically brought in.
8. An electronic device, characterized in that: The device includes at least one processor and a memory communicatively connected to the at least one processor; the memory stores instructions executable by the at least one processor, and the instructions are executed by the at least one processor so that the at least one processor can execute a method for constructing a building structure metadata database as described in any one of claims 1 to 5, or execute a method for applying a building structure metadata database as described in any one of claims 6 to 7.
