Design And Implementaiton Of Distributed Storage And Management Of Spatial Data

An important part of geographic information system is the spatial datamanagement system, as a cross subject that connects the theory and method of a spacegeographic information, comprising spatial data’s collection, storage, query, analysisand display, through the establishment of geographic data model, analysis of spaceobject, provide the spatial data query service for the users, help users to makedecision.In recent years, with the accuracy of spatial data acquisition equipment is moreand more high and the diversity of spatial data increases, the large-scale spatial dataacquiring more and more easily, the spatial data showing explosive growth trend.Large-scale spatial data needs to be stored reliably, but also need to be accessed fastby a lot of users, traditional data storage and processing schema cannot adapt to theneeds of the development of spatial data, has become to be the bottleneck of businessdevelopment. With the introduction of distributed storage and management system,these data are distributed over several database storage nodes, and the databasestorage nodes can process many users’ requests in parallel. The application ofdistributed database in the storage of spatial data, can improve the storage ability ofspatial data, improve the query speed, and improve the response ability of network.The main contents of this paper are as follows:First, according to the project " town planning and construction of informationplatform of JiLin province", carry on preliminary research on the spatial data andspatial database, understand the characteristics of spatial data, the basic characteristicsof PostgreSQL, PostGIS’s support of spatial data storage and processing. Implementthe spatial data storage and retrieval.Second, focus on the research of the raster data segmentation, improve theefficiency of storage and access speed of spatial data in PostgreSQL database;research on theory knowledge of PostgreSQL database and the optimization of spatialdata query speed using index; Research the data tuples’ segmentation and copy of pgpool-II Middleware, load balancing of concurrent access, extend the databasestorage to a distributed system, further improve the efficiency of storage and accessspeed.Third, make use of Spring Framework and Spring MVC to implement the serversystem. The server system access pgpool-II middleware, pgpool-II distributes spatialdata access to each PostgreSQL database storage node rationally, achieve the rationaluse of resources of the server and distributed storage nodes, at the same time, improvethe response capability of the whole system.After the test, the system achieved the project demand and stability. Thedistributed storage and management of spatial data is designed and implemented inthis paper provides some references for the theoretical study and practical use ofspatial data.