Research And Application Of MySQL Fusion Spatial Database Extension

The spatial database that realizes the integrated management of graphic data and attribute data is conducive to improving the safety,efficiency and convenience of geographic information management of surveying and mapping,but how to enhance its spatial data processing and analysis functions on the basis of the spatial database of integrated management It is an important work that the value of spatial database data can be fully tapped and developed.This article first explains the problem of the lack of spatial data analysis and computing capabilities in traditional databases,and proposes the necessity of spatial database research.This research focuses on the relational database MySQL,and then introduces the Spatial module in the MySQL database,and describes the content of the module in detail,combs several spatial data types currently supported by the Spatial module,and analyzes on this basis Study the spatial data input and output format,query and retrieval process,and analysis and calculation in the Spatial module.Aiming at the problem of insufficient spatial analysis capability of the Spatial module,this research content and research plan are proposed,and a spatial expansion is added to the module.This study is based on Vatti's polygon intersection and difference algorithm,written in C++,and integrated the polygon intersection and difference algorithm into the Spatial module of the MySQL database.After successfully compiling the MySQL source code,the three spatial extension functions INTERSECTION,UNION and DIFFERENCE verified that three SQL space expansion functions were successfully added to MySQL.Later,using the MySQL database that successfully added the polygon intersection and difference space expansion,it was applied to the proposal data collected by the urban residents' life proposal applet,and the algorithm was used to analyze the proposal data for the regional proposal analysis.It was found that the calculation was greatly simplified and the MySQL database was greatly improved.The ability of spatial data analysis can meet the basic application needs.At the end,based on the iterative idea of intersection algorithm and PageRank algorithm,a set of methods for calculating the spatial satisfaction score is proposed,which has certain innovative and practical significance.