Design Of Integrated Scheme Of Universal Spatial Database Interface

With the continuous development of the Internet era and the continuous expansion of the field of spatial data applications,the integration and sharing of spatial data has become an important issue and concern in the development of information technology.Because the storage and application of spatial data in related departments in the early stage are mainly concentrated within the department,the spatial data structure of each department is different.The stored spatial data has the problems of data type crossover and spatial data duplication,resulting in spatial data integration and sharing.hard to accomplish.Therefore,the thesis is devoted to the research on the integration of universal spatial database interface,mainly to solve the problem of integration and sharing caused by the heterogeneous characteristics of spatial data and the different database types,versions,and data structures.The design of metadata model for general spatial data mainly solves the problems brought about by the heterogeneous characteristics of spatial data in integration and sharing.The thesis first studies and compares the spatial metadata standards at home and abroad,and then chooses to expand and design based on the "Geological Information Metadata Standard(DD2006-05)" to achieve spatial data acquisition through the metadata model.In the design process of the metadata model,by analyzing the requirements of the metadata model design,and formulating the rules and constraints of the model design,the entity composition and relationship of the metadata model are clarified,and the data elements in the metadata model are further detailed Definition.The distributed interface integration of general spatial data mainly solves the integration problem of databases of different types,different versions and different data structures,realizes its interface service for each spatial database,and realizes the logical integration of the spatial database through the interface.The paper analyzes and compares the three mainstream distributed frameworks in the market and chooses to build a master node for interface integration based on the Spring Cloud framework to implement registration and monitoring of interface services for each child node.In addition,the paper analyzes the spatial data types and interface integration environment,explains the interface development specifications and constraints,and describes the interface design content of spatial data in detail.The interface management platform mainly implements unified management of interface and metadata synchronization,including interface registration,interface status monitoring,interface testing,metadata synchronization,and synchronization data volume statistics.The thesis introduces the business process and system framework of the interface management platform,combines the metadata model to realize the construction of the metadata database,and completes the design and implementation of the functional modules.Among them,the interface management platform is implemented in Java language based on the Spring Boot framework,uses MySQL to store platform data,and uses MongoDB to store metadata.The thesis from the metadata model design,interface design and integration to the implementation of the interface management platform,step by step,detailed design and verification of the feasibility of universal spatial database interface integration,provides ideas for the integration and sharing of spatial data in multiple regions.