3D Data Management Of Construction Waste Based On Main Memory Database

As the urbanization process continues to accelerate,the construction waste problem in our country is getting more and more serious.The annual generation of construction waste has rapidly increased from 500 million tons in 2007 to more than 15 tons in recent years.Many cities are about to face with the situation of garbage besieging the city.In the supervision of construction waste,how to comprehensively and accurately obtain relevant monitoring data is one of the most important issues.As far as the existing monitoring data acquisition methods are concerned,the integrated monitoring method of heaven and earth is one of the more advanced solutions: it combines high-and low-altitude remote sensing platforms and ground mobile platforms,and adopts multi-source remote sensing,tilt photogrammetry,three-dimensional laser scanning,collaborative observation of the Internet of Things and other technical means,to solve the problem that the traditional single monitoring method can not quickly and accurately obtain dynamic change information such as type,area,volume of construction waste.In the integrated monitoring method of heaven and earth,a large amount of three-dimensional data is generated,and these data have wide sources,many types,and complicated relationships.How to effectively store and manage these three-dimensional data and integrate it into the WebGIS system to realize the visualization on the network side has become a problem that puzzles developers of regulatory applications.This paper researches on the method of three-dimensional data organization and management in the integrated monitoring of heaven and earth.First,explore a threedimensional construction garbage model management method with in-memory database priority: that is,use the high-speed data reading and writing performance of the in-memory database to reduce the delay time when the client requests the three-dimensional model;at the same time,use its good stability under high concurrent access to improve the overall service performance of the system.Next,based on the Redis database,a three-dimensional model distributed storage solution and data persistence solution were implemented to expand memory storage capacity while ensuring high system availability;Finally,the Cesium open source library was used as the front-end three-dimensional rendering engine for the overall framework and key functions of the three-dimensional construction waste management system,breaking the limitation of traditional two-dimensional data on the expression of construction waste data,providing a new way for construction waste monitoring and management.The main research work carried out is briefly described as follows:(1)Organize the supervision data of the three-dimensional construction waste management system.The three-dimensional monitoring data in the integrated monitoring of the world and the earth is organized,the internal correlation characteristics of the three-dimensional model data and related attribute data are analyzed,the logical organization of the three-dimensional data is realized,and the design work of the memory and relational databases is completed.(2)Realize the storage of construction waste heap model data in the Redis database.The storage structure of the three-dimensional model of construction waste is constructed in the in-memory database,and the batch writing method of the three-dimensional model and spatial information in the memory database is researched and implemented.(3)Experiments and analysis verified that the three-dimensional model organization and management method based on in-memory database(Redis database is used in this paper)can improve the performance of all aspects of the Web-side system.First,through the model call speed comparison experiment,it was verified that the management method based on the inmemory database takes 15%-30% less time to call the construction waste 3D model than using traditional file management,which greatly improves the visualization when the client requests the 3D model Efficiency;Then,through the comparison test of high concurrency test,it is verified that the in-memory database has fast read and write performance.In the case of high concurrency access,user requests can be processed quickly,so that the database service always maintains good stability;Next,design and build a distributed storage cluster consisting of 3 masters and 3 slaves with a total of 6 nodes to test the Redis database.The test results showed that distributed storage can improve the storage capacity and availability of the system;finally,design and implement an AOF + RDB data persistence method based on distributed clusters,which improves data security and reduces the risk of database service blocking.(4)Design and implement a three-dimensional construction waste management system.Combined with actual needs and project background,a comprehensive demand analysis and system design were carried out for the three-dimensional construction waste management system,and the overall system construction plan was proposed.And using the established technology stack,the front-end and back-end of the system are developed separately,and the three-dimensional data management method with in-memory database as the priority is integrated into the system to construct the basic framework of the system and realize some basic functions.