阅读说明：本技术 一种基于bim的图集查询方法 (BIM-based atlas query method ) 是由 郭魁 于 2021-08-11 设计创作，主要内容包括：本发明公开了一种基于BIM的图集查询方法,具体涉及图集查询技术领域,包括步骤一、设计二维图集数据库；步骤二、创建数据表连接；步骤三、搭建前端可视化网页；步骤四、自动创建自定义表格；步骤五、查询程序与BIM平台整合；步骤六、模型设计。本发明通过将查询程序与BIM平台整合,使得根据用户需求自定义显示所需的三维图集,增加用户的体验感,同时具有高效性,只从数据库检索用户所需的信息,加快了数据库的查询速度,缩短了服务端的响应时间,同时更加具有实用性和便捷性,使得用户在改变模型属性和数据的同时直接操控数据库,保障了数据的一致性和完整性。(The invention discloses an atlas query method based on BIM, in particular to the technical field of atlas query, which comprises the steps of firstly, designing a two-dimensional atlas database; step two, establishing data table connection; step three, building a front-end visual webpage; step four, automatically creating a custom table; step five, integrating the query program with the BIM platform; and step six, designing a model. According to the invention, through integrating the query program with the BIM platform, the required three-dimensional atlas is displayed in a user-defined manner according to the user requirement, the experience of the user is increased, meanwhile, the efficiency is high, only the information required by the user is retrieved from the database, the query speed of the database is accelerated, the response time of a server is shortened, meanwhile, the practicability and convenience are better realized, the user directly controls the database while changing the model attribute and the data, and the consistency and the integrity of the data are ensured.)

1. A BIM-based atlas query method comprises the following specific steps:

designing a two-dimensional atlas database, wherein the two-dimensional atlas database consists of a two-dimensional atlas data table and a two-dimensional atlas table, the two-dimensional atlas data table creates fields to arrange data information of the building engineering into each cell, and the two-dimensional atlas table summarizes all two-dimensional atlas information of the building engineering;

establishing data table connection, namely establishing query connection for the two-dimensional atlas data table and the two-dimensional atlas table, namely establishing a main key for the two-dimensional atlas data table, and enabling the two tables to be connected for convenient query;

building a front-end visual webpage, wherein the front-end visual webpage provides an operation interface of a user, and the user can quickly find an atlas and related data required by the user by inputting a query keyword, namely a main key of the two-dimensional atlas data table;

step four, automatically creating a custom form, and providing a result query form according to information searched by a user;

integrating a query program with the BIM platform, wherein the query program comprises designing a two-dimensional atlas database, creating data table connection, building a front-end visual webpage and automatically creating a custom form, and then importing a two-dimensional atlas searched by the custom form and related data into a model of the BIM platform to generate a three-dimensional atlas;

and sixthly, designing the model, namely, clicking the model by a user to edit, namely, the user can add, delete, modify and query data in the model, and the model with the modified data can be relatively changed in a certain proportion so as to present visual experience for the user.

2. The BIM-based atlas query method of claim 1, wherein: in the first step, firstly downloading a mySQL database, then installing and configuring the mySQL database, then configuring the environmental variables of the mySQL database, and finally starting the mySQL database service;

the method for starting MySQL service under Windows system mainly includes the following two methods:

managing by a computer;

by way of a command line;

and then creating a database, managing the data table by using a mySQL database, creating a new database in the mySQL database management system, and setting a connection name, a host name, a port number, a user name and a password so as to connect the database.

3. The BIM-based atlas query method of claim 2, wherein: in the second step, firstly, creating tables, namely creating two data tables of a two-dimensional atlas data table and a two-dimensional atlas table under a well-connected database;

and then designing a table, namely creating fields for the two tables of the two-dimensional atlas data table and the two-dimensional atlas table, wherein the fields are column attributes of the tables, then creating respective main keys of the two-dimensional atlas data table and the two-dimensional atlas table, wherein the main key of the two-dimensional atlas data table is an external key of the two-dimensional atlas table, the main key of the two-dimensional atlas data table is set to be self-increment, so that a user can conveniently add the fields, the two-dimensional atlas data table and the two-dimensional atlas table are linked, the two tables of the two-dimensional atlas data table and the two-dimensional atlas table can be added, deleted, modified and inquired at the same time by compiling an sql statement, namely, the two tables of the two-dimensional atlas data table and the two tables of the two-dimensional atlas data table are subjected to addition, deletion and modification, and the consistency and the integrity of each data in the database are ensured.

4. The BIM-based atlas query method of claim 3, wherein: in the third step, Java programming language is used for integrated development in IntelliJIDEA, the IntelliJIDEA integrated development tool has a characteristic function, JSP is completely supported on the premise of no plug-in, asynchronous transmission of data between a page and a web server is realized through ajax, the JSP can dynamically display Java codes in a static webpage, the static page is used as a framework, and after a user clicks an interface to send a request, a data result is dynamically generated and packaged to generate an object to be used when the object is waited to be inquired.

5. The BIM-based atlas query method of claim 4, wherein: in step four, a configuration file for loading a driver and connecting a database is written in IntelliJIDEA, JSP and link are written to the database, the JSP can dynamically access the database, a query interface is compiled based on the JSP and is divided into a static data area and a dynamic data area, all fields of the two tables of the two-dimensional atlas data table and the two-dimensional atlas table are set as query options, the query options are static data contents, which are also called HTML, the contents of the static data in the JSP file are completely consistent with the contents output to HTTP response, a client can obtain the same response contents every request, the dynamic data area is a blank area before a query result does not appear, and after a user point sends a request, after the query program calls the packaged object, the dynamic data area is a self-defined table, columns displayed by the custom form are fields inquired by a user, and rows of the custom form are data contents corresponding to each field.

6. The BIM-based atlas query method of claim 5, wherein: in the fifth step, the front end and the back end are integrated by using SpringBoot, a three-dimensional atlas conversion module and a model design module are designed and compiled, the module can generate a three-dimensional atlas from a two-dimensional atlas, a developer mode of the BIM platform is started, the BIM platform can carry out system putting and debugging, an inquiry program can be implanted into the BIM, and information to be inquired can be retrieved on a model interface when a user enters the model interface of the BIM.

7. The BIM-based atlas query method of claim 6, wherein: in the fifth step, the model design module mainly simplifies the operation of the user on the model data, the attributes and the data of the model are displayed to the user through a visual interface, the user can directly change, the attributes and the data of the model after being changed can be refreshed, and the attribute and the data of the model after being changed correspond to the attributes and the data of the model after being changed, the attributes and the data of the model after being changed are added, deleted, changed and checked by the query program, so that the consistency of the data of the database and the front end is maintained.

Technical Field

The invention relates to the technical field of atlas query, in particular to an atlas query method based on BIM.

Background

The BIM is also called Building Information Model (BIM), which is an application of digital information, rather than simply integrating digital information, and refers to simulating real information of a building through digital information, where the content of information is not only visual information of geometric description, but also contains a large amount of non-geometric information.

The technical core of the Building Information Model (BIM) is a database formed by computer three-dimensional models, which not only contains the design information of architects, but also can contain the whole process information from design to construction and even the end of the service cycle, and all kinds of information are always built in a three-dimensional model database. The Building Information Model (BIM) can provide project design scope, progress and cost information on a continuous and instant basis, which is complete, reliable and fully coordinated. Building Information Models (BIMs) are capable of maintaining information in a comprehensive digital environment, are constantly updated and provide access rooms for architects, engineers, constructors and owners with a clear and comprehensive understanding of projects. The information can promote the decision-making progress to be accelerated and the decision-making quality to be improved in the building design, construction and management processes, so that the project quality is improved and the benefit is increased.

The prior art has the following defects: the BIM models are numerous, but the BIM platform model is single in function, not practical and poor in user experience.

Disclosure of Invention

Therefore, the invention provides an atlas query method based on BIM, which integrates a query program with a BIM platform, so that a required three-dimensional atlas is displayed in a user-defined mode according to the requirements of a user, the experience of the user is increased, the efficiency is high, only information required by the user is retrieved from a database, the query speed of the database is increased, the response time of a server is shortened, the practicability and the convenience are better, the user directly controls the database while changing the attributes and the data of the model, the consistency and the integrity of the data are ensured, and the problems that the BIM platform model in the prior art is single in function, does not have practicality and is poor in user experience are solved.

In order to achieve the above object, the embodiments of the present invention provide the following technical solutions: a BIM-based atlas query method comprises the following specific steps:

designing a two-dimensional atlas database, wherein the two-dimensional atlas database consists of a two-dimensional atlas data table and a two-dimensional atlas table, the two-dimensional atlas data table creates fields to arrange data information of the building engineering into each cell, and the two-dimensional atlas table summarizes all two-dimensional atlas information of the building engineering;

establishing data table connection, namely establishing query connection for the two-dimensional atlas data table and the two-dimensional atlas table, namely establishing a main key for the two-dimensional atlas data table, and enabling the two tables to be connected for convenient query;

building a front-end visual webpage, wherein the front-end visual webpage provides an operation interface of a user, and the user can quickly find an atlas and related data required by the user by inputting a query keyword, namely a main key of the two-dimensional atlas data table;

step four, automatically creating a custom form, and providing a result query form according to information searched by a user;

integrating a query program with the BIM platform, wherein the query program comprises designing a two-dimensional atlas database, creating data table connection, building a front-end visual webpage and automatically creating a custom form, and then importing a two-dimensional atlas searched by the custom form and related data into a model of the BIM platform to generate a three-dimensional atlas;

and sixthly, designing the model, namely, clicking the model by a user to edit, namely, the user can add, delete, modify and query data in the model, and the model with the modified data can be relatively changed in a certain proportion so as to present visual experience for the user.

Further, in the first step, firstly downloading a mySQL database, then installing and configuring the mySQL database, then configuring the environmental variables of the mySQL database, and finally starting the mySQL database service;

the method for starting MySQL service under Windows system mainly includes the following two methods:

managing by a computer;

by way of a command line;

and then creating a database, managing the data table by using a mySQL database, creating a new database in the mySQL database management system, and setting a connection name, a host name, a port number, a user name and a password so as to connect the database.

Further, in the second step, firstly, a table is created, namely two data tables of a two-dimensional atlas data table and a two-dimensional atlas table are created under a connected database;

and then designing a table, namely creating fields for the two tables of the two-dimensional atlas data table and the two-dimensional atlas table, wherein the fields are column attributes of the tables, then creating respective main keys of the two-dimensional atlas data table and the two-dimensional atlas table, wherein the main key of the two-dimensional atlas data table is an external key of the two-dimensional atlas table, the main key of the two-dimensional atlas data table is set to be self-increment, so that a user can conveniently add the fields, the two-dimensional atlas data table and the two-dimensional atlas table are linked, the two tables of the two-dimensional atlas data table and the two-dimensional atlas table can be added, deleted, modified and inquired at the same time by compiling an sql statement, namely, the two tables of the two-dimensional atlas data table and the two tables of the two-dimensional atlas data table are subjected to addition, deletion and modification, and the consistency and the integrity of each data in the database are ensured.

Furthermore, in the third step, Java programming language is used for integrated development in IntelliJ IDEA, the IntelliJ IDEA integrated development tool has a characteristic function, JSP is completely supported on the premise of no plug-in, asynchronous transmission of data between a page and a web server is realized through ajax, JSP can dynamically display Java codes in a static webpage, the static page is used as a framework, and after a user clicks an interface to send a request, a data result is dynamically generated and packaged to generate an object to be used when the object is waited to be inquired.

Further, in step four, writing a configuration file in a manner of loading a driver and connecting a database in IntelliJ IDEA, connecting JSP to the database so that JSP can dynamically access the database, writing a query interface based on JSP, wherein the query interface is divided into a static data area and a dynamic data area, all fields of two tables of a two-dimensional atlas data table and the two-dimensional atlas table are set as query options, the query options are static data contents, also called HTML, the contents of the static data in the JSP file are completely consistent with the contents output to HTTP response, a client can obtain the same response contents every request, the dynamic data area is a blank area before a query result does not appear, after a user point sends a request, a query program calls a packaged object, the dynamic data area is a self-defined table, and columns displayed by the self-defined table are fields queried by the user, and customizing the data content corresponding to each field of the behavior of the form.

Furthermore, in the fifth step, the front end and the rear end are integrated by using Spring Boot, a three-dimensional atlas conversion module and a model design module are designed and compiled, a user-defined form is inserted into the three-dimensional atlas conversion module, a three-dimensional atlas required by a user can be displayed in a user-defined mode, the three-dimensional atlas conversion module can generate a three-dimensional atlas from a two-dimensional atlas, a developer mode of the BIM platform is started, the BIM platform can be placed in and debugged in a system, a query program can be implanted into the BIM, and when the user enters the BIM model interface, information to be queried can be retrieved from the model interface.

Furthermore, in the fifth step, the model design module mainly simplifies the operation of the user on the model data, displays the attributes and data of the model to the user through a visual interface, and the user can directly change the attributes and data of the model, and the attributes and data of the model after being changed can be refreshed again, which corresponds to the attribute and data of the model after being changed, the attribute and data of the model can be changed and checked by the query program, so that the consistency of the data of the database and the front end can be maintained.

The embodiment of the invention has the following advantages:

1. according to the invention, data and graphic information of the two-dimensional atlas are respectively stored in the two tables of the two-dimensional atlas data table and the two tables of the two-dimensional atlas table, the two tables of the two-dimensional atlas data table and the two tables of the two-dimensional atlas table are associated, and the query program is prompted to execute operations of adding, deleting and modifying the database in the background through a user operation interface;

2. according to the invention, the model design module is additionally arranged, the attributes and data of the model are displayed to the user through a visual interface, the user can directly change, and the attributes and data of the model after being changed can be refreshed.

Drawings

In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings used in the description of the embodiments or the prior art will be briefly described below. It should be apparent that the drawings in the following description are merely exemplary, and that other embodiments can be derived from the drawings provided by those of ordinary skill in the art without inventive effort.

The structures, ratios, sizes, and the like shown in the present specification are only used for matching with the contents disclosed in the specification, so as to be understood and read by those skilled in the art, and are not used to limit the conditions that the present invention can be implemented, so that the present invention has no technical significance, and any structural modifications, changes in the ratio relationship, or adjustments of the sizes, without affecting the effects and the achievable by the present invention, should still fall within the range that the technical contents disclosed in the present invention can cover.

FIG. 1 is an overall flow chart provided by the present invention.

Detailed Description

The present invention is described in terms of particular embodiments, other advantages and features of the invention will become apparent to those skilled in the art from the following disclosure, and it is to be understood that the described embodiments are merely exemplary of the invention and that it is not intended to limit the invention to the particular embodiments disclosed. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.

As shown in fig. 1, the present invention provides a BIM-based atlas query method, which includes the following specific steps:

designing a two-dimensional atlas database, wherein the two-dimensional atlas database consists of a two-dimensional atlas data table and a two-dimensional atlas table, the two-dimensional atlas data table creates fields to arrange data information of the building engineering into each cell, and the two-dimensional atlas table summarizes all two-dimensional atlas information of the building engineering;

downloading a mySQL database, installing and configuring the mySQL database, configuring environment variables of the mySQL database, and starting a mySQL database service;

the method for starting MySQL service under Windows system mainly includes the following two methods:

managing by a computer;

by way of a command line;

and then creating a database, managing the data table by using a mySQL database, creating a new database in the mySQL database management system, and setting a connection name, a host name, a port number, a user name and a password so as to connect the database.

Establishing data table connection, namely establishing query connection for the two-dimensional atlas data table and the two-dimensional atlas table, namely establishing a main key for the two-dimensional atlas data table, and enabling the two tables to be connected for convenient query;

firstly, creating tables, namely creating two data tables of a two-dimensional atlas data table and a two-dimensional atlas table under a well-connected database;

fields in a database, most often the "columns" of a table are called "fields," each field containing information for a topic. Just like in the "address book" database, "name" and "contact" are attributes common to all rows in the table, so these columns are called the "name" field and the "contact" field;

and then designing a table, namely creating fields for the two tables of the two-dimensional atlas data table and the two-dimensional atlas table, wherein the fields are column attributes of the tables, then creating respective main keys of the two-dimensional atlas data table and the two-dimensional atlas table, wherein the main key of the two-dimensional atlas data table is an external key of the two-dimensional atlas table, the main key of the two-dimensional atlas data table is set to be self-increment, so that a user can conveniently add the fields, the two-dimensional atlas data table and the two-dimensional atlas table are linked, the two tables of the two-dimensional atlas data table and the two-dimensional atlas table can be added, deleted, modified and inquired at the same time by compiling an sql statement, namely, the two tables of the two-dimensional atlas data table and the two tables of the two-dimensional atlas data table are subjected to addition, deletion and modification, and the consistency and the integrity of each data in the database are ensured.

Building a front-end visual webpage, wherein the front-end visual webpage provides an operation interface of a user, and the user can quickly find an atlas and related data required by the user by inputting a query keyword, namely a main key of the two-dimensional atlas data table;

a JSP page can be divided into the following parts:

static data, such as HTML;

JSP instructions, such as include instructions;

JSP script elements and variables;

JSP action;

a user self-defines a label;

static data;

HTML, known as hypertext markup language, is a markup language. The document format on the network can be unified through the labels, so that the scattered Internet resources are connected into a logic whole. HTML text is descriptive text consisting of HTML commands that can specify words, graphics, animations, sounds, tables, links, etc.

Ajax is a web data interaction way, and a web application can quickly present incremental updates on a user interface by using Ajax technology without reloading (refreshing) the whole page, so that a program can more quickly respond to the operation of a user.

The intelligent web page integrated development method based on the Java programming language has the advantages that the Java programming language is used for carrying out integrated development in the IntelliJ IDEA, the IntelliJ IDEA integrated development tool has a characteristic function, JSP is completely supported on the premise of no plug-in, asynchronous transmission of data between a page and a web server is achieved through Ajax, Java codes can be dynamically displayed in a static web page by the JSP, the static web page is used as a framework, and after a user clicks an interface to send a request, a data result is dynamically generated and packaged to generate an object to be used when the object is waited to be inquired.

Step four, automatically creating a custom form, and providing a result query form according to information searched by a user;

writing configuration files for loading a drive and connecting database mode in the intelliJ IDEA, connecting JSP to the database, the JSP can dynamically access the database, a query interface is compiled based on the JSP and is divided into a static data area and a dynamic data area, all fields of the two tables of the two-dimensional atlas data table and the two-dimensional atlas table are set as query options, the query options are static data contents, which are also called HTML, the contents of the static data in the JSP file are completely consistent with the contents output to HTTP response, a client can obtain the same response contents every request, the dynamic data area is a blank area before a query result does not appear, and after a user point sends a request, after the query program calls the packaged object, the dynamic data area is a self-defined table, columns displayed by the custom form are fields inquired by a user, and rows of the custom form are data contents corresponding to each field.

Integrating a query program with the BIM platform, wherein the query program comprises designing a two-dimensional atlas database, creating data table connection, building a front-end visual webpage and automatically creating a custom form, and then importing a two-dimensional atlas searched by the custom form and related data into a model of the BIM platform to generate a three-dimensional atlas;

the Spring framework provides a series of solutions for development, such as using a core characteristic of control inversion, realizing control inversion by relying on injection to realize management object lifecycle containerization, using section-oriented programming to carry out declarative transaction management, integrating multiple persistence technologies to manage data access, providing a large number of excellent Web frameworks to facilitate development, and the like.

The method comprises the steps of integrating the front end and the rear end by using Spring Boot, designing and compiling a three-dimensional atlas conversion module and a model design module, inserting a custom form into the three-dimensional atlas conversion module to custom-display a three-dimensional atlas required by a user, enabling the three-dimensional atlas conversion module to generate a three-dimensional atlas from a two-dimensional atlas, starting a developer mode of a BIM platform, enabling the BIM platform to carry out system putting and debugging, implanting an inquiry program into the BIM, and retrieving information to be inquired in the model interface when the user enters the model interface of the BIM.

The model design module mainly simplifies the operation of the user on the model data, displays the attributes and data of the model to the user through a visual interface, the user can directly change the attributes and data of the model after the change, and the attributes and data of the model after the change can be refreshed, and the attribute and data correspond to the attribute, deletion, change and check of the database by the query program, so that the consistency of the database and the front-end data is maintained.

And sixthly, designing the model, namely, clicking the model by a user to edit, namely, the user can add, delete, modify and query data in the model, and the model with the modified data can be relatively changed in a certain proportion so as to present visual experience for the user.

Although the invention has been described in detail above with reference to a general description and specific examples, it will be apparent to one skilled in the art that modifications or improvements may be made thereto based on the invention. Accordingly, such modifications and improvements are intended to be within the scope of the invention as claimed.