Storage And Management Of Huge Amount Of 2D And 3D Ancient Architecture Spatial Data

Ancient Chinese architecture represent the great wisdom of laboring people of ancient china,and it is also an important research basis of China's political,economic,cultural,history and so on.With the influence of many factors,just like the passing of years,human social activities and so on,many ancient architectures are in danger of being destroyed.Once they are destroyed,these ancient architectures will disappear,which is an irreparable loss for both Chinese and world civilization,precisely because of the above reason,we need to strengthen the protection of ancient architectures,Author of this article mainly studies the storage,management and application of all kinds of ancient architecture data.Traditional methods for recording ancient architectural data mainly refer to the photos and the text describes about the ancient architectural.With the development of science and technology,the appearance of 3D Laser Scanning and related digital products provides a new way of protecting ancient architecture.Image photos,text describes,Point cloud,model and other 3D Laser Scanning digital products can have a better description and record of ancient architecture.By using 3D laser and cameras,point cloud and image photos can be acquired.After dealing with these digital products,ancient architecture can be showed much more vividly.However,just get the data is far from the goal,the ways to store,manage and apply the data also need to be studied.This article starts from the research status of storage and management of ancient architecture,by using database this paper studies the better ways of data storage and management,and then develops a software to apply the ancient architecture data which stored in the database.This paper designs and implements a system which can have a better storage ?management and application of all kinds of ancient architecture data.The system is completed under the C++ programing language,CLR environment and the database of PostgreSQL.The paper choices Libpq as access portal.By using Libpq combined with C++ programing language,system can have a connection and access to database,and some of ancient architecture can be managed and applied through the front-end application program.In order to increase the data sharing of ancient architecture,and facilitate the data management,all the data used in this paper are stored in the database.For the point cloud data,firstly,read and analysis the point cloud data by using the way of memory mapping,secondly,after getting the point cloud data,a fixed amount of point cloud can be converted to a binary block and stored in the table as a piece of data,so the cycle,all the point cloud data can be stored.For the image picture,in order to facilitate the query operation,Allimage and image two tables are combined to store image pictures.Two tables are associated with each other through the corresponding text index.For 3D models,in order to show the ancient architecture much more vivid and realistic,Tin model?CSG model and Depth image model are combined together to display the ancient architecture.Different ancient architecture have different characteristics,so it's necessary to establish different table structures in database,and establish different data structures to store and organize ancient architecture data.In order to improve the utilization rate of ancient architecture data,develop a application system to apply the ancient architecture data is necessary.Users with correct name and password can log in the system,after logging in the system users with different names may have different operating authority,those who have appropriate permissions can store,update,display,filter,analyze and count all kinds of ancient architecture data.Truly apply ancient architecture data safely and high efficiency.Application results show that the DBMS for ancient architecture designed and implemented by this paper can store and manage 2D and 3D ancient architecture data,which break through the limitation that traditional ancient architecture DBMS can only store and manage 2D graphic data.3D data can record and display ancient architecture much more realistically and vividly.Through filtering,counting,and analyzing the data stored in the database,the DBMS for ancient architecture can provide data support for all trades,which can satisfy the actual needs of ancient architecture protection and scientific research units,this also proved that the research content of this paper has strong practical significance.