A multi-source heterogeneous spatial data transfer method based on oracle database

Abstract

The invention discloses a multi-source heterogeneous spatial data transfer method based on an Oracle database. The method includes accepting a data request; determining the database node to be accessed through a spatial data index according to the request; The conversion module converts the spatial data model; performs simple preprocessing on the converted data; stores the data or stores the data after processing. The present invention combines the mature relational database spatial data storage with the spatial database engine technology, and integrates the spatial data in the distributed storage spatial databases by establishing an integrated vector and raster data storage model and optimizing the spatial data retrieval mechanism. Realize the data flow of multi-source heterogeneous data. The Oracle data-driven engine NMSDE developed based on the technology of the present invention is better than ArcSDE in both storage and query efficiency tests.

Description

technical field [0001] The invention relates to the technical field of databases, in particular to a method for transferring multi-source heterogeneous spatial data based on an Oracle database. Background technique [0002] With the continuous development of spatial geographic information technology, the means of obtaining geographic spatial information are constantly enriched. Geospatial data presents the characteristics of diversified data sources, differentiated data models, decentralized data storage, complex spatial relationships, and massive quantities. To this end, various data and application-oriented spatial database technologies, spatial data engine technologies, and distributed storage management technologies have emerged, which have effectively solved the problem of geospatial data storage and management to a certain extent or from a certain aspect. question. [0003] For the storage, organization, management and release of multi-source heterogeneous spatial dat...

AI Technical Summary

Problems solved by technology

Although many solutions have been proposed for spatial data management based on non-relational databases, they are not widely used in commercial applications. The reasons include: the technology of distributed vector data storage, spatial operation and distributed processing is not perfect, Further exploration and research are needed; there is still insufficient support for multi-source heterogeneous data; there is no good solution for how to integrate spatial data in existing relational databases

[0007] At present, most of the domestic database construction does not have a cloud environment, and the more widely used databases are still mainly concentrated in the two aspects of Oracle-based "extended object-relational database" and "spatial data engine". However, many years of database construction have emerged. Many GIS systems with different architectures make it difficult to share data, low data migration efficiency, difficult multi-source heterogeneous data flow, and difficult data interoperability.

Images