CN109615700B - Three-dimensional virtual reality tunnel monitoring system and operation method thereof - Google Patents
Three-dimensional virtual reality tunnel monitoring system and operation method thereof Download PDFInfo
- Publication number
- CN109615700B CN109615700B CN201811563806.6A CN201811563806A CN109615700B CN 109615700 B CN109615700 B CN 109615700B CN 201811563806 A CN201811563806 A CN 201811563806A CN 109615700 B CN109615700 B CN 109615700B
- Authority
- CN
- China
- Prior art keywords
- data
- tunnel
- dimensional
- virtual reality
- database
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06T—IMAGE DATA PROCESSING OR GENERATION, IN GENERAL
- G06T17/00—Three dimensional [3D] modelling, e.g. data description of 3D objects
- G06T17/05—Geographic models
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q50/00—Systems or methods specially adapted for specific business sectors, e.g. utilities or tourism
- G06Q50/08—Construction
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06T—IMAGE DATA PROCESSING OR GENERATION, IN GENERAL
- G06T19/00—Manipulating 3D models or images for computer graphics
- G06T19/003—Navigation within 3D models or images
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02P—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN THE PRODUCTION OR PROCESSING OF GOODS
- Y02P90/00—Enabling technologies with a potential contribution to greenhouse gas [GHG] emissions mitigation
- Y02P90/02—Total factory control, e.g. smart factories, flexible manufacturing systems [FMS] or integrated manufacturing systems [IMS]
Landscapes
- Engineering & Computer Science (AREA)
- Physics & Mathematics (AREA)
- Software Systems (AREA)
- General Physics & Mathematics (AREA)
- Theoretical Computer Science (AREA)
- Geometry (AREA)
- Remote Sensing (AREA)
- Computer Graphics (AREA)
- Business, Economics & Management (AREA)
- General Engineering & Computer Science (AREA)
- Marketing (AREA)
- Radar, Positioning & Navigation (AREA)
- Health & Medical Sciences (AREA)
- Economics (AREA)
- General Health & Medical Sciences (AREA)
- Human Resources & Organizations (AREA)
- Computer Hardware Design (AREA)
- Primary Health Care (AREA)
- Strategic Management (AREA)
- Tourism & Hospitality (AREA)
- General Business, Economics & Management (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
- Alarm Systems (AREA)
Abstract
The invention discloses a three-dimensional virtual reality tunnel monitoring system, which comprises a system client, a three-dimensional virtual simulation platform, a database and a two-dimensional tunnel construction monitoring system, wherein the system client provides system starting operation, a user login entrance and an operation interface, the system client consists of a three-dimensional virtual reality simulation platform client and a two-dimensional tunnel construction monitoring system client, the three-dimensional virtual simulation platform comprises a three-dimensional virtual reality simulation platform client, the three-dimensional virtual reality simulation platform client provides login and operation parameter setting operation for the three-dimensional virtual reality simulation platform and sets and connects data sources of a local database, and the two-dimensional tunnel construction monitoring system client provides login and system parameter setting for the two-dimensional tunnel construction monitoring system, working parameter setting for bound hardware equipment and a post-disaster emergency plan entering function. The invention realizes real-time data synchronization.
Description
Technical Field
The invention relates to the technical field of construction monitoring, in particular to a three-dimensional virtual reality tunnel monitoring system and an operation method thereof.
Background
With the vigorous development of tunnel engineering construction in China, safety monitoring and scientific construction in the tunnel construction process become more and more important. In order to solve the problem of safe construction of the tunnel, the most common solution is to adopt an information monitoring and early warning system, so that the risk loss can be effectively reduced while manpower and material resources are saved. However, most of the existing tunnel construction safety monitoring systems adopt a two-dimensional monitoring mode, and have the problems that the risk cannot be found in time due to the hysteresis of monitoring data, high error rate, slow early warning and alarming, and the like, and unnecessary casualties and property loss are easily caused. Along with the improvement of the complexity of the tunnel construction technology, the construction monitoring data are more and more complex, the accuracy and timeliness of data monitoring are more and more important, if a two-dimensional monitoring system is still adopted, the monitoring work is abstract and complex, the risk early warning is delayed, the monitoring result inevitably has large difference and errors, and the risk monitoring and early warning cannot be carried out in time. Therefore, the traditional two-dimensional monitoring system is required to be technically improved, the visualization level of the system is improved, the monitoring and early warning effect is further improved, and the bottleneck problems that tunnel monitoring data are complex, visibility is poor, risk early warning is not timely and the like are solved. With the gradual maturity of the virtual simulation technology, the application field of the virtual simulation technology is more and more diversified, and the introduction of the technology into a tunnel construction monitoring system is an effective method for making up the defects of the traditional monitoring system. By introducing the virtual simulation technology, 3D visualization of a construction site can be realized, construction monitoring personnel can see monitored data very visually just like the construction site in a remote observation, all monitoring works are executed in a visual state, synchronization of remote monitoring and phenomenon construction is guaranteed, and timeliness of risk discovery and risk early warning is greatly improved.
The information disclosed in this background section is only for enhancement of understanding of the general background of the invention and should not be taken as an acknowledgement or any form of suggestion that this information forms the prior art already known to a person skilled in the art.
Disclosure of Invention
The invention aims to provide a three-dimensional virtual reality tunnel monitoring system and an operation method thereof, which can overcome the defects of the prior art.
In order to achieve the purpose, the invention provides a three-dimensional virtual reality tunnel monitoring system which comprises a system client, a three-dimensional virtual simulation platform, a database and a two-dimensional tunnel construction monitoring system, wherein the system client provides system starting operation, a user login entrance and an operation interface, the system client consists of a three-dimensional virtual reality simulation platform client and a two-dimensional tunnel construction monitoring system client, the three-dimensional virtual simulation platform comprises a three-dimensional virtual reality simulation platform client, the three-dimensional virtual reality simulation platform client provides login and operation parameter setting operation for the three-dimensional virtual reality simulation platform and sets and connects data sources of a local database, and the two-dimensional tunnel construction monitoring system client provides login and system parameter setting for the two-dimensional tunnel construction monitoring system, working parameter setting for bound hardware equipment and a recording function for a post-disaster emergency plan.
In a preferred embodiment, the three-dimensional virtual simulation platform is implemented based on OPENGL's 3D engine technology.
In a preferred embodiment, the three-dimensional virtual simulation platform is used for providing modeling of a tunnel three-dimensional virtual simulation model, 3D visual display of tunnel design survey data, real-time updating display of construction monitoring data, and dynamic roaming and 3D browsing functions of the virtual tunnel model.
In a preferred embodiment, the database is composed of a local database and a remote network database, the local database is managed and used by the three-dimensional virtual reality simulation platform, the remote network database is managed by the two-dimensional tunnel construction monitoring system, and the local database and the remote network database synchronize and update data through the Internet.
In a preferred embodiment, the two-dimensional tunnel construction monitoring system has the functions of automatic acquisition, wireless transmission, early warning and safety management of multivariate information in the tunnel construction process.
In a preferred embodiment, the two-dimensional tunnel construction monitoring system can perform tunnel construction face image real-time acquisition, face stability monitoring, in-tunnel personnel and vehicle positioning management, automatic data acquisition and comprehensive analysis of various sensors of a selected section, and starting of a four-stage early warning and emergency plan.
In a preferred embodiment, the three-dimensional virtual simulation platform can be used for tunnel three-dimensional model modeling, tunnel three-dimensional section drawing, tunnel three-dimensional line type drawing, tunnel design information three-dimensional display, tunnel survey information three-dimensional display, tunnel construction progress information display, tunnel three-dimensional virtual environment roaming browsing, tunnel construction monitoring data real-time display and construction process forecast early warning information prompt.
In a preferred embodiment, the local database performs data synchronization based on the following steps:
establishing a temporary index table in a server-side database, wherein the temporary index table is used for storing indexes of data added, deleted and modified by the server-side database; the server side clears the temporary index table regularly, creates a clearing record table newly, and inserts clearing time into a creation time field of the clearing record table in the clearing record table; the server-side program records the operations of adding, deleting and modifying the database into the temporary index table, and when the local database and the server database need to be synchronized, the server-side program reads the data to be modified recorded in the temporary index table in the server-side database and executes corresponding data operation on the local database; and after the local client synchronizes the database data each time, a text file is newly built in the local machine so as to store the modification time of the last record.
The invention also provides an operation method of the three-dimensional virtual reality tunnel monitoring system, which comprises the following steps: logging in a two-dimensional tunnel construction monitoring system through a webpage client, and inputting design information, survey information and the like of a tunnel; logging in a three-dimensional virtual reality simulation platform through a client, and setting relevant operation parameters of the three-dimensional virtual reality simulation platform; the information acquisition module acquires and processes the monitoring measurement data and sends the monitoring measurement data to the server, the data management provides a data input function, and the visualization module is used for checking the data; the database stores personnel positioning information, sound image information, survey design data, measurement data of various sensors, tunnel design overview, advanced geological forecast data, and related early warning forecast information and emergency plans; writing the design information, the survey information and the monitoring data of the tunnel into remote network data for storage and management, and updating the latest data; after the virtual reality simulation platform is set, a local database and a remote network database are synchronized for the first time, and a virtual reality engine is started and reads tunnel data from the local database to establish a three-dimensional tunnel model; and the local database is timed or keeps synchronous with the remote network database according to preset conditions to realize real-time updating of data, the two-dimensional tunnel construction monitoring system sends a data updating notice to the three-dimensional virtual simulation platform when detecting that data updating exists, and the three-dimensional virtual simulation platform sends a data updating instruction to finish one-time data updating.
Compared with the prior art, the three-dimensional virtual reality tunnel monitoring system and the operation method thereof have the following advantages: the method is mainly characterized in that a three-dimensional virtual tunnel simulation model is established to simulate the construction progress of an actual tunnel, and real-time synchronization of the virtual tunnel model and the actual tunnel construction site data is realized by utilizing a network data synchronization technology. The invention helps monitoring personnel to master field monitoring data in real time through the three-dimensional visual display system, quickly positions the position of risk data and guides the safety of construction field operation. The method has the characteristics of convenience in operation, quickness in reaction, intuitionistic interface, high visualization degree and the like, and can effectively ensure engineering safety and construction progress. The invention can simulate the tunnel construction progress, and realizes the three-dimensional visual display of the real-time monitoring data of the tunnel construction site and the real-time positioning and attendance management of site constructors. The invention can realize the deformation monitoring of the selected measured section in the virtual reality tunnel. According to the invention, risk early warning and disaster early warning in the construction process can be realized in the virtual reality tunnel, and post-disaster emergency plan implementation and disaster rescue guidance are provided. The method can effectively help the monitoring personnel to master the real situation of the construction site in real time in the virtual reality tunnel, reduce the decision-making errors of the monitoring personnel, improve the working efficiency and reduce the personnel cost. The invention adopts a unique data synchronization method, avoids frequently copying the database from the server to the local computer in a full-database backup mode, and improves the efficiency of updating the local data and the real-time performance of the data.
Drawings
Fig. 1 is a structural diagram of a three-dimensional virtual reality tunnel construction monitoring system according to the present invention.
Fig. 2 is a functional structure diagram of a three-dimensional virtual simulation platform of the three-dimensional virtual reality tunnel construction monitoring system of the present invention.
Fig. 3 is a functional structure diagram of a two-dimensional tunnel construction monitoring system of the three-dimensional virtual reality tunnel construction monitoring system of the present invention.
Fig. 4 is a flowchart of the operation of the three-dimensional virtual reality tunnel construction monitoring system of the present invention.
Fig. 5 is a database data table design diagram of the three-dimensional virtual reality tunnel construction monitoring system of the present invention.
Fig. 6 is a functional table design diagram of a database system of the three-dimensional virtual reality tunnel construction monitoring system of the present invention.
Fig. 7 is a design diagram of a database service function table of the three-dimensional virtual reality tunnel construction monitoring system according to the present invention.
Fig. 8 is a flowchart of a data synchronization method of the three-dimensional virtual reality tunnel construction monitoring system of the present invention.
Detailed Description
The following detailed description of the present invention is provided in conjunction with the accompanying drawings, but it should be understood that the scope of the present invention is not limited to the specific embodiments.
Throughout the specification and claims, unless explicitly stated otherwise, the word "comprise", or variations such as "comprises" or "comprising", will be understood to imply the inclusion of a stated element or component but not the exclusion of any other element or component.
Referring to fig. 1, the invention is composed of a system client 101, a three-dimensional virtual simulation platform 102, a database 103 and a two-dimensional tunnel construction monitoring system 104. The system client provides system starting operation, a user login entrance and an operation interface, and is composed of a three-dimensional virtual reality simulation platform client and a two-dimensional tunnel construction monitoring system client. The method comprises the steps that a three-dimensional virtual reality simulation platform client provides login and operation parameter setting operation for a three-dimensional virtual reality simulation platform, and sets and connects data sources of a local database; the client of the two-dimensional tunnel construction monitoring system provides login and system parameter setting of the two-dimensional tunnel construction monitoring system, working parameter setting of bound hardware equipment and entry functions of an emergency plan after disaster. The three-dimensional virtual simulation platform is realized based on the 3D engine technology of OPENGL, and provides functions of modeling of a tunnel three-dimensional virtual simulation model, 3D visual display of tunnel design survey data, real-time updating and display of construction monitoring data, and dynamic roaming and 3D browsing of the virtual tunnel model. The database is composed of a local database 105 and a remote network database 106, the local database is managed and used by a three-dimensional virtual reality simulation platform, the remote network database is managed by a two-dimensional tunnel construction monitoring system, and the two databases are used for synchronizing and updating data through the Internet. The two-dimensional tunnel construction monitoring system has the functions of automatic acquisition, wireless transmission, early warning, safety management and the like of multivariate information in the tunnel construction process, can perform tunnel construction face image real-time acquisition, face stability monitoring, in-tunnel personnel and vehicle positioning management, automatically acquires and comprehensively analyzes data of various sensors of a selected section, and starts a four-level early warning and emergency plan.
Referring to fig. 2, the three-dimensional virtual simulation platform of the present invention includes functions of tunnel three-dimensional model modeling, tunnel three-dimensional section drawing, tunnel three-dimensional line drawing, tunnel design information three-dimensional display, tunnel survey information three-dimensional display, tunnel construction progress information display, tunnel three-dimensional virtual environment roaming browsing, tunnel construction monitoring data real-time display, and construction process forecast warning information prompt. The three-dimensional model modeling of the tunnel is to establish a three-dimensional model of a virtual reality tunnel by adopting the 3D modeling technology of OPENGL. And the drawing of the three-dimensional section of the tunnel is to perform 3D drawing on the section of the tunnel according to the five-center circle design information of the tunnel. And the three-dimensional line type drawing of the tunnel is to draw a 3D line type of the virtual tunnel according to the design excavation line type information of the tunnel. The three-dimensional display of the tunnel design information is to draw the tunnel general view of the virtual tunnel according to the comprehensive design information of the tunnel. And the three-dimensional display of the tunnel survey information is to draw a geological tangent plane of the virtual tunnel according to the geological survey information of the tunnel and the geological information of the tunnel face. The displaying of the tunnel construction progress information is to draw the construction progress information of the virtual tunnel according to the actual excavation progress of the tunnel. The tunnel three-dimensional virtual environment roaming browsing utilizes a dynamic browsing technology, advances in a virtual tunnel at a first-person viewing angle, and observes the external conditions inside the virtual tunnel at a 360-degree viewing field. The real-time display of the tunnel construction monitoring data and the prompt of the construction process forecast early warning information are to highlight the monitoring data and the construction risk warning animation in the virtual tunnel, and quickly prompt and position the risk position.
Referring to fig. 3, the two-dimensional tunnel construction monitoring system of the present invention includes functions of user right management and system setting, information acquisition and data management, database and forecast early warning management, and comprehensive data analysis and professional analysis.
User authority management and system setting, including three functions of user authority management, system operation parameter setting and related hardware equipment parameter setting.
And information acquisition and data management, including monitoring data acquisition and transmission, data processing and data entry, personnel positioning data, sound image information and tunnel design general profiles.
Database and forecast and early warning management, including advanced geological forecast data, forecast and early warning information, emergency plans and emergency response.
Comprehensive analysis of data and professional analysis, including expert systems, regression analysis, finite element analysis, and grey theory.
Referring to fig. 4, the working process of the three-dimensional virtual reality tunnel construction monitoring system of the present invention is: firstly, respectively logging in a local client of a three-dimensional system and a webpage client of a two-dimensional system through a user login interface; a local three-dimensional virtual simulation platform is logged in and operated by a local client of the three-dimensional system, and local data is controlled and managed by the local three-dimensional virtual simulation platform; and logging in the two-dimensional tunnel construction monitoring system through a webpage client of the two-dimensional system, and managing a remote network database. The two-dimensional tunnel construction monitoring system collects and updates tunnel construction monitoring data in real time, the two-dimensional webpage client sends corresponding data updating prompts to the three-dimensional system local client, the three-dimensional system local client sends data synchronization instructions to the local data after receiving the data updating prompts, and the local database actively performs data synchronization with the remote network database through a network to acquire the latest monitoring data. The specific work flow is divided into the following 6 stages:
(1) Data entry and operational parameter setting: logging in a two-dimensional tunnel construction monitoring system through a webpage client, and inputting design information, survey information and the like of a tunnel; logging in the three-dimensional virtual reality simulation platform through the client, and setting relevant operating parameters of the three-dimensional virtual reality simulation platform.
(2) Information collection and data management: the information acquisition module acquires and processes the monitoring measurement data and sends the monitoring measurement data to the server, the data management provides a data input function, and the data is checked through the visualization module.
(3) Database and forecast early warning management: the database stores personnel positioning information, sound image information, survey design data, measurement data of various sensors, tunnel design general, advanced geological forecast data, relevant early warning forecast information, emergency plans and the like.
(4) Remote data storage and synchronous update: the design information, the survey information and the monitoring data of the tunnel are written into remote network data for storage and management, and the latest data is updated.
(5) Operation of virtual reality human-computer interaction: after the virtual reality simulation platform is set, the local database and the remote network database are synchronized for the first time, and the virtual reality engine is started and reads tunnel data from the local database to establish a three-dimensional tunnel model.
(6) And (3) updating data in real time: the local database keeps the data synchronous with the remote network database at regular time or according to preset conditions, and real-time updating of the data is realized. When detecting that data updating exists, the two-dimensional tunnel construction monitoring system sends a data updating notice to the three-dimensional virtual simulation platform, and the three-dimensional virtual simulation platform sends a data updating instruction to complete one-time data updating.
Referring to fig. 5, the system database of the present invention has a data table design composed of a base station setting table, a data acquisition table, and a measurement point information table.
And the base station setting table consists of a nearby base station table and an adding instruction table. The nearby base station table records the information of the communication base stations distributed in the tunnel; and the adding instruction table records the instructions which need to be loaded by the corresponding communication base station.
The data acquisition table consists of a channel table, a channel type table, a channel data table, a channel temporary data table and a channel deletion instruction table. Recording the number information of the channel by the channel table; the channel type table records the type information of the channel; the channel data table records data information acquired by a channel; the channel temporary data table records temporary data information acquired by a channel; and the channel deletion instruction table records the information of the deletion or addition of the corresponding channel.
Referring to fig. 6, the system function table of the system database of the present invention is designed to include a user table, a tunnel table corresponding to the user, an authority management table, a navigation management table, a base station type table, a base station port table, a direct connection base station setting table, an item type table, a short message temporary table, a short message type table, and a port table.
The user table records basic information and authority information of system users.
And recording the information of the user and the corresponding tunnel project by the user corresponding to the tunnel table.
The authority management table records authority information owned by different system accounts.
The navigation management table records navigation management information of the system.
The base station type table records the type information of the communication base station.
The base station port table records the communication port information of each communication base station and consists of a base station polling periodic table and a table whether to set a direct-connected base station or not. The base station polling periodic table records the time period information of the polling information packet of the communication base station; and whether the direct connection base station table is set or not is recorded, and whether the communication base station is set as a direct connection communication base station or not is recorded.
The setting table of the direct connection base station records the relevant information of the communication base station as the direct connection communication base station.
And the project type table records the type information of the tunnel construction project.
And the short message temporary table records temporary storage information of the short messages.
The short message type table comprises a downlink short message type table and records the type information of the construction early warning short message.
The port table records a list of ports that the system has enabled.
Referring to fig. 7, the design of the service function table of the system database of the present invention is composed of a man-machine table, a tunnel profile table, a survey design database table, an advance plan table, a geological record table, a construction plan table, a short message setting table, a picture collection table, an automatic early warning responsibility list, and an alarm light instruction table.
The man-machine table consists of a personnel positioning information table, a personnel positioning result table, a personnel attendance card table and an attendance record table. The man-machine positioning information table records relevant basic information of personnel and equipment to be positioned; the personnel positioning result table records the position information of personnel positioning; the personnel attendance card table records basic information of the personnel attendance card; the attendance record table records attendance record information of personnel.
The tunnel profile table is composed of a tunnel table, a tunnel section information table and a tunnel item type table. The tunnel table records basic tunnel information; recording the design information of the five-center circular section of the tunnel by using a tunnel section information table; and the tunnel project type table records the type information of the tunnel construction project.
The survey design database table records the early address survey design data of the tunnel.
And the advanced plan table records the advanced forecast information of the address of tunnel excavation.
And recording address record information of the tunnel excavation face by the geological record table.
The construction plan table consists of all the responsibility tables, the matching measure table and the expert decision table. Each party duty table records the duty information of each related party of the tunnel project; the matching measure table records the related matching measures of tunnel excavation; and the expert decision table records the expert decision information of the system.
The short message setting table is composed of a man-machine conversation table and records the relevant setting information of the man-machine conversation of the construction early warning short message.
The picture collecting table is composed of a picture data table and records picture data information collected on a construction site.
And the automatic early warning responsibility list records corresponding responsibility information when the system automatically warns.
And the alarm lamp instruction list records alarm state information when the monitoring data of the system exceeds a preset threshold value.
Referring to fig. 8, the data synchronization method of the present invention is to store the latest updated data and modified records of the network database in a temporary table in the form of an index, and the local program reads the latest data from the remote network database according to the index of the temporary table and updates the local database, so that the local database is consistent with the database of the server-side database. The concrete implementation steps are as follows:
(1) Establishing a temporary index table at a server-side database, wherein the table name is SynchronousDB and is used for storing indexes of data added and deleted by the server-side database, and the table comprises the following 7 fields: CRUD, CRUDGUID, DBname, tableName, priKeys, createTime, flag.
CRUD field, type integer, for storing the operation performed by this record.
CRUDGUID field, which serves as the primary key for the SynchronousDB table.
And the DBname field is of a character string type and is used for storing the library name of the database where the modification record is located.
And the TableName field is a character string and is used for storing the table name of the modified record.
And the PriKeys field is a character string in type, is used for storing a primary key set of the modification record, comprises a name-value pair set of each primary key and is divided by commas.
A CreateTime field for storing a record creation time.
And the Flag field, the type of which is integer, is used for identifying whether the record can be deleted.
(2) The server regularly clears the temporary index table Synchronous DB and creates a clearing record table with the name of Synchronous DBTime, and the clearing time is inserted into a CreateTime field of the Synchronous DBTime table.
A CreateTime field for recording the time to clear the syncronous db table. When the clearing operation is carried out, the connected local client is informed of the time of clearing the SynchronousDB table last time, and if the client does not update the database before the recording time of the table, the client needs to back up the database again.
(3) And when the local database and the server database need to be synchronized at a specific time, reading data needing to be modified recorded in the table of the server-side database, executing corresponding data operation on the local database, so as to keep the data of the local database and the data of the server database consistent, and deleting all records with Flag =1 in the temporary index table SynchronousDB after the data synchronization is finished.
The method for adding, deleting and modifying the database data by the server-side program into the temporary index table SynchronousDB comprises the following steps: and recording the database name into a DBname field of the table, recording the table name into a TableName field, recording the operation performed by which main key into a Prikeys field, adding, deleting and modifying the operation into a CRUD field, recording the time for creating a single record into a CreateTime field, and finally finishing the record for modifying the database at the server end.
(4) After the local client synchronizes the database data each time, a Txt file is newly established in the local machine, and the modification time of the last record is stored. Before each synchronization, firstly reading a Synchronous DBTime table, judging whether the field CreateTime is larger than the clearing time of the Txt file record of the computer or not, and if so, indicating that the Synchronous DB table has clearing operation and needs to back up the database again; if the time is less than the clearing time of the Txt record of the local computer, the SynchronousDB table is not cleared, all records of Flag =0 in the temporary index table SynchronousDB after the Txt record time of the local computer of the SynchronousTime are read, the content of the record corresponding to the server side is inquired according to the database name (DBName), the data table name (TableName) and the primary key set (Prikeys) corresponding to each record, and then the operations of adding, deleting and changing corresponding to the CRUD value are executed in the local database. After the synchronous update of all the data is completed, the record change of Flag =1 is made to the server data read this time, which indicates that the record is already synchronized to the local database.
As will be appreciated by one skilled in the art, embodiments of the present application may be provided as a method, system, or computer program product. Accordingly, the present application may take the form of an entirely hardware embodiment, an entirely software embodiment or an embodiment combining software and hardware aspects. Furthermore, the present application may take the form of a computer program product embodied on one or more computer-usable storage media (including, but not limited to, disk storage, CD-ROM, optical storage, and the like) having computer-usable program code embodied therein.
The present application is described with reference to flowchart illustrations and/or block diagrams of methods, apparatus (systems), and computer program products according to embodiments of the application. It will be understood that each flow and/or block of the flow diagrams and/or block diagrams, and combinations of flows and/or blocks in the flow diagrams and/or block diagrams, can be implemented by computer program instructions. These computer program instructions may be provided to a processor of a general purpose computer, special purpose computer, embedded processor, or other programmable data processing apparatus to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing apparatus, create means for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be stored in a computer-readable memory that can direct a computer or other programmable data processing apparatus to function in a particular manner, such that the instructions stored in the computer-readable memory produce an article of manufacture including instruction means which implement the function specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be loaded onto a computer or other programmable data processing apparatus to cause a series of operational steps to be performed on the computer or other programmable apparatus to produce a computer implemented process such that the instructions which execute on the computer or other programmable apparatus provide steps for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
The foregoing descriptions of specific exemplary embodiments of the present invention have been presented for purposes of illustration and description. It is not intended to limit the invention to the precise form disclosed, and obviously many modifications and variations are possible in light of the above teaching. The exemplary embodiments were chosen and described in order to explain certain principles of the invention and its practical application to enable one skilled in the art to make and use various exemplary embodiments of the invention and various alternatives and modifications as are suited to the particular use contemplated. It is intended that the scope of the invention be defined by the claims and their equivalents.
Claims (2)
1. A three-dimensional virtual reality tunnel monitoring system is characterized by comprising a system client, a three-dimensional virtual reality simulation platform, a database and a two-dimensional tunnel construction monitoring system, wherein the system client provides system starting operation, a user login entrance and an operation interface, the system client consists of a three-dimensional virtual reality simulation platform client and a two-dimensional tunnel construction monitoring system client, the three-dimensional virtual reality simulation platform comprises a three-dimensional virtual reality simulation platform client, the three-dimensional virtual reality simulation platform client provides login and operation parameter setting operation for the three-dimensional virtual reality simulation platform and sets and connects data sources of a local database, the two-dimensional tunnel construction monitoring system client provides login and system parameter setting for the two-dimensional tunnel construction monitoring system, working parameter setting for bound hardware equipment and a recording function for a post-disaster emergency plan,
the three-dimensional virtual reality simulation platform is realized based on the 3D engine technology of OPENGL,
the three-dimensional virtual reality simulation platform is used for providing the functions of modeling of a tunnel three-dimensional virtual simulation model, 3D visual display of tunnel design survey data, real-time update display of construction monitoring data and dynamic roaming and 3D browsing of the virtual tunnel model,
the database is composed of a local database and a remote network database, the local database is managed and used by the three-dimensional virtual reality simulation platform, the remote network database is managed by the two-dimensional tunnel construction monitoring system, the local database and the remote network database carry out data synchronization and update through the Internet,
the two-dimensional tunnel construction monitoring system has the functions of automatic acquisition, wireless transmission, early warning and safety management of multivariate information in the tunnel construction process,
the two-dimensional tunnel construction monitoring system can perform tunnel construction face image real-time acquisition, face stability monitoring, in-tunnel personnel and vehicle positioning management, automatic data acquisition and comprehensive analysis of various sensors of a selected section, four-stage early warning starting and emergency plan,
the three-dimensional virtual reality simulation platform can be used for drawing a three-dimensional section of a tunnel, drawing a three-dimensional linear type of the tunnel, three-dimensionally displaying tunnel design information, displaying tunnel construction progress information and prompting construction process forecast early warning information,
wherein the local database performs data synchronization based on the following steps:
establishing a temporary index table in a server database, wherein the temporary index table is used for storing indexes of data added, deleted and modified by the server database;
the server side regularly clears the temporary index table, newly establishes a clearing record table, and inserts clearing time into a creation time field of the clearing record table in the clearing record table;
the server-side program records the operations of adding, deleting and changing the database into the temporary index table, reads the data to be modified recorded in the temporary index table in the server-side database when the local database and the server database need to be synchronized, and executes corresponding data operation on the local database; and
after the local client synchronizes the database data each time, a text file is newly built in the local machine so as to store the modification time of the last record.
2. A method of operating the three-dimensional virtual reality tunnel monitoring system of claim 1, the method of operation comprising the steps of:
logging in a two-dimensional tunnel construction monitoring system through a webpage client, and inputting design information and investigation information of a tunnel; logging in the three-dimensional virtual reality simulation platform through the client, and setting relevant operating parameters of the three-dimensional virtual reality simulation platform;
the information acquisition module acquires and processes the monitoring measurement data and sends the monitoring measurement data to the server, the data management provides a data input function, and the data is checked through the visualization module;
the database stores personnel positioning information, sound image information, survey design data, measurement data of various sensors, tunnel design overview, advanced geological forecast data, and related early warning forecast information and emergency plans;
writing design information, survey information and monitoring data of the tunnel into a remote network database for storage and management, and updating the latest data;
after the virtual reality simulation platform is set, a local database and a remote network database are synchronized for the first time, and a virtual reality engine is started and reads tunnel data from the local database to establish a three-dimensional tunnel model; and
the local database is regularly or synchronously kept with the remote network database according to preset conditions to realize real-time updating of data, the two-dimensional tunnel construction monitoring system sends a data updating notice to the three-dimensional virtual reality simulation platform when detecting that data updating exists, and the three-dimensional virtual reality simulation platform sends a data updating instruction to complete one-time data updating.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811563806.6A CN109615700B (en) | 2018-12-20 | 2018-12-20 | Three-dimensional virtual reality tunnel monitoring system and operation method thereof |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811563806.6A CN109615700B (en) | 2018-12-20 | 2018-12-20 | Three-dimensional virtual reality tunnel monitoring system and operation method thereof |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN109615700A CN109615700A (en) | 2019-04-12 |
| CN109615700B true CN109615700B (en) | 2023-02-28 |
Family
ID=66009605
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201811563806.6A Active CN109615700B (en) | 2018-12-20 | 2018-12-20 | Three-dimensional virtual reality tunnel monitoring system and operation method thereof |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109615700B (en) |
Families Citing this family (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110847963B (en) * | 2019-10-08 | 2021-11-30 | 中国铁建重工集团股份有限公司 | Data interaction system for railway tunnel construction |
| CN110717986A (en) * | 2019-10-11 | 2020-01-21 | 中国电建集团铁路建设有限公司 | Shield tunnel construction system based on virtual reality technology |
| CN110830331B (en) * | 2019-12-06 | 2024-03-15 | 中国交通建设股份有限公司 | Physical model test process data transmission system and method |
| CN111966670B (en) * | 2020-07-08 | 2021-09-10 | 成都星时代宇航科技有限公司 | Remote sensing data distribution method and device based on mosaic data set and management platform |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN201689455U (en) * | 2009-12-01 | 2010-12-29 | 北京市市政工程研究院 | Tunnel construction disaster planning and preventing response system based on network platform |
| CN104680579A (en) * | 2015-03-02 | 2015-06-03 | 北京工业大学 | Tunnel construction informatization monitoring system based on three-dimensional scanning point cloud |
| CN106384191A (en) * | 2016-08-31 | 2017-02-08 | 铁道第三勘察设计院集团有限公司 | Railway tunnel construction progress management system and method based on 3DGIS and engineering 3D model |
| CN106572325A (en) * | 2015-10-13 | 2017-04-19 | 上海宝信软件股份有限公司 | Virtual-reality-technology-based tunnel monitoring equipment inspection system |
| CN108268986A (en) * | 2016-12-30 | 2018-07-10 | 上海大学 | Cross-river tunnel engineering construction simulation system based on BIM |
-
2018
- 2018-12-20 CN CN201811563806.6A patent/CN109615700B/en active Active
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN201689455U (en) * | 2009-12-01 | 2010-12-29 | 北京市市政工程研究院 | Tunnel construction disaster planning and preventing response system based on network platform |
| CN104680579A (en) * | 2015-03-02 | 2015-06-03 | 北京工业大学 | Tunnel construction informatization monitoring system based on three-dimensional scanning point cloud |
| CN106572325A (en) * | 2015-10-13 | 2017-04-19 | 上海宝信软件股份有限公司 | Virtual-reality-technology-based tunnel monitoring equipment inspection system |
| CN106384191A (en) * | 2016-08-31 | 2017-02-08 | 铁道第三勘察设计院集团有限公司 | Railway tunnel construction progress management system and method based on 3DGIS and engineering 3D model |
| CN108268986A (en) * | 2016-12-30 | 2018-07-10 | 上海大学 | Cross-river tunnel engineering construction simulation system based on BIM |
Non-Patent Citations (1)
| Title |
|---|
| 隧道施工智能管理系统研究及形象进度系统实现;张玥;《中国优秀硕士学位论文数据库信息科技辑》;20130715;第3-4章 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN109615700A (en) | 2019-04-12 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109615700B (en) | Three-dimensional virtual reality tunnel monitoring system and operation method thereof | |
| CN104766155B (en) | The management method and system of engineering project element based on BIM | |
| CN108874919B (en) | Automatic checking method for planned land, electronic equipment, storage medium and system | |
| CN110689705A (en) | Comprehensive application system for mine geological environment management | |
| CN106368247A (en) | Foundation pit intelligent monitoring and active forewarning method and system based on building information modeling (BIM) | |
| CN105631154A (en) | Method for viewing tunnel monitoring and measurement data on BIM (Building Information Modeling) construction management platform | |
| CN103632509B (en) | Based on the numeral of generalized information system, intelligent mine alarm linkage method and platform thereof | |
| CN102982411A (en) | Citizen interaction system in city planning | |
| CN113722797A (en) | Lightweight BIM prefabricated part full life cycle comprehensive information management system | |
| CN114037097A (en) | BIM model-based equipment operation and maintenance management method | |
| CN105045815A (en) | Data collecting method and apparatus | |
| CN106648994A (en) | Method, equipment and system for backup operation on log | |
| KR20140068297A (en) | Multi-dimensional and object-oriented data management system for bridge based on mobile field inspection, and method for the same | |
| CN116091039A (en) | Power transmission and transformation project acceptance result visualization method and system based on south network intelligent aerial view | |
| CN116304152A (en) | Intelligent investigation result display system based on GIS and BIM | |
| CN115905650A (en) | Coal mine production three-dimensional visual information system based on Internet of things and sensor technology | |
| CN109784840A (en) | A kind of construction survey automatic data collection processing method being associated with engineering structure task | |
| CN204576509U (en) | City planning information inquiry and government public interaction device | |
| KR101973328B1 (en) | Correlation analysis and visualization method of Hadoop based machine tool environmental data | |
| Chmelina et al. | A tunnel information system for the management and utilization of geo-engineering data in urban tunnel projects | |
| CN109934894B (en) | CAD (computer-aided design) drawing method and device and computer-readable storage medium | |
| CN111881236A (en) | Stope visualization realization method and stope visualization realization device | |
| CN110610244A (en) | Water supply pipeline hidden danger troubleshooting integrated operation method, computer readable storage medium and terminal | |
| CN110287566A (en) | A kind of system that tunnel piercing progress and process are controlled based on BIM | |
| CN104680433A (en) | BIM-based event and member association management method and system |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |