Method for accessing spatial grid object of database

Abstract

The invention discloses a method for accessing a spatial grid object of a database, which comprises the following steps: establishing a user primary table having a grid list and a grid block accessory structure supporting an in-line storage mode and an out-of-line storage mode; establishing a new spatial grid object, assigning a storage mode, and inserting the spatial grid object into the grid list of the user primary table; importing pixel data, executing in-line block write-in or out-of-line block write-in through a block write-in driver according to the storage mode; and establishing a grid pyramid. A corresponding reading method comprises the following steps: accessing the grid list of the user primary table, reading the spatial grid object, including the storage mode; and executing in-line block reading or out-of-line block reading through a block read driver according to the storage mode. By designing a block recording sheet and a block file tree with the peer-to-peer structure under a database environment, the method for accessing the spatial grid object of the database realizes in-line and out-of-line based peer-to-peer access framework for the pixel data, and solves the problem that the storage and access efficiency of the spatial grid data are poor by adopting a database mode.

Description

technical field [0001] The invention belongs to the field of information intersected by databases and geographic information systems, and in particular relates to a spatial grid object access method realized in the kernel of a database management system. Background technique [0002] In recent years, the use of databases to store and manage spatial data has developed rapidly. "Relational database + spatial data engine" and "extended object-relational database" are two mainstream technologies currently used in the industry. The former is a technical system adopted in the classic GIS field, and its core is to use an efficient spatial data engine (middleware) to organize the storage and retrieval of spatial data in a relational database (hereinafter referred to as "registration mode"); the latter is an IT The core of the technical system adopted by database manufacturers is to add spatial data types, spatial indexes and spatial SQL language (hereinafter referred to as "built-i...

AI Technical Summary

Problems solved by technology

[0015] The technical problem to be solved by the present invention is: Aiming at the fact that spatial raster data is stored and accessed in a database manner with poor efficiency, a database spatial raster object access method that supports both in-row and out-of-row storage modes is proposed. A built-in raster file system is introduced in the database environment to optimize the read-only access efficiency of raster data, and realize transparent access to upper-level SQL functions by constructing an in-row table-based and out-of-row file-based peer-to-peer access framework

Images