Database spatial sharding replication method and system

Abstract

The invention relates to the technical field of spatial databases, and discloses a database spatial sharding replication method and system. The method comprises the steps that a target distribution type database is deployed according to a specified spatial sharding scheme; the variation of spatial object records is captured in a source database space list in the target distribution type database; spatial relationship judgment is conducted on the spatial position information of the varied spatial object records and a spatial sharding rule, and if a divided spatial position relation is met, it is judged that the current spatial object records after variation need to be replicated to destination databases where corresponding spatial sharding areas are placed; according to the definition of data propagation, the varied spatial object records are replicated to the destination databases. According to the database spatial sharding replication method and system, the spatial data are stored in a sharding mode according to spatial position features, replication is achieved according to the specified spatial relationship rule, so that the updating synchronization efficiency of the spatial data under a distribution type environment is improved, the global consistency of spatial objects is supported and maintained, and a spatial distribution type application is simplified.

Description

technical field [0001] The invention relates to the technical field of spatial databases, in particular to a method and system for duplicating database space slices. Background technique [0002] With the rapid development of geographic information system (GIS), remote sensing (RS) and global satellite navigation system (GNSS) technologies, geographic information applications are becoming more and more extensive, involving municipal management, emergency response, health care, transportation, energy, communications, and commercial applications. And other major fields. As the core foundation of geographic information applications, geospatial data mainly records the spatial location information and related attribute information of various geographic entities such as roads, houses, and rivers. Different from conventional general-purpose relational data, geospatial data has obvious regional characteristics, complex structure (unstructured) and multi-dimensional space (x, y, z)....

AI Technical Summary

Problems solved by technology

[0006] Aiming at the problem that the traditional database system replication technology is mainly aimed at general relational data, which can only be replicated by copy or key value subset and does not support replication by spatial position relationship, a database space shard replication method and system are proposed. Data is stored in fragments according to spatial location characteristics, and replicated according to specified spatial relationship rules, thus effectively improving the update and synchronization efficiency of spatial data in a distributed environment, supporting the maintenance of global consistency of spatial objects, and simplifying spatial distributed applications

Images