Method for accessing spatial grid object of database

A database and grid technology, applied in the information field where databases and geographic information systems intersect, can solve problems such as poor storage access efficiency, achieve poor access efficiency, improve data access efficiency, and facilitate access efficiency Effect

Inactive Publication Date: 2010-06-30
INST OF GEOGRAPHICAL SCI & NATURAL RESOURCE RES CAS +2
View PDF0 Cites 20 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

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

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Method for accessing spatial grid object of database
  • Method for accessing spatial grid object of database
  • Method for accessing spatial grid object of database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0064] In conjunction with the method of the present invention, the following embodiments are provided: to the user main table T u The raster column is stored in three rows of records, corresponding to save the spatial raster object R 1 , R 2 and R 3 , the data source comes from three GeoTiff images GTiff 1 、GTiff 2 、GTiff 3 , and read with a typical data subset interception operation Subset to illustrate the entire data access process.

[0065] The method for importing spatial raster objects into the database proposed by the present invention, its flow is as follows figure 1 shown, including the following steps:

[0066] (1) Create a grid space table scheme Schema r ;

[0067] Create user master table T with raster columns u And its block subsidiary structure to form a grid space table scheme: Schema r ={T u ,T br ,T bf},Such as image 3 shown. in:

[0068] ①T u ={C 1 , C 2 ,...,C n , RASTER}(n≥0), is the user master table structure containing raster colum...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

PUM

No PUM Login to view more

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...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

Application Information

Patent Timeline
no application Login to view more
Patent Type & Authority Applications(China)
IPC IPC(8): G06F17/30
Inventor 谢炯陈振陈荣国周成虎熊伟李飞程昌秀张明波林永恒景宁朱自军费春霞王超冯登国张敏陈驰徐震
Owner INST OF GEOGRAPHICAL SCI & NATURAL RESOURCE RES CAS
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap