Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Method for storing space geometric objects to database

A technology of geometric objects and databases, which is applied in the information field where databases and geographic information systems intersect, can solve the problem of low I/O response efficiency in accessing spatial geometric objects, achieve spatial query efficiency improvement, minimize realization, and improve response efficiency Effect

Inactive Publication Date: 2009-09-02
INST OF GEOGRAPHICAL SCI & NATURAL RESOURCE RES CAS +2
View PDF0 Cites 13 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0009] The technical problem to be solved by the present invention is: Aiming at the problem that the I / O response efficiency of accessing spatial geometric objects based on the conventional LOB mechanism is not high, a database spatial geometric object access method is proposed. Relational features are stored in spatial geometry object values ​​to minimize unnecessary out-of-row access processes when reading data, and how to improve the I / O efficiency of out-of-row data access when out-of-row access must be involved

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 storing space geometric objects to database
  • Method for storing space geometric objects to database
  • Method for storing space geometric objects to database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0048] In conjunction with the method of the present invention, the following embodiments are provided: To the space table T g The geometry column (assuming the column name is geom) is stored in 4 geometric objects G 1 = {POINT(1 2)}, G 2 ={POLYGON(0 0.9, 1.3 0.9, 1.3 2, 0 2)}, G 3 ={LINESTRING(1.5 1, 2.5 1, 2.32.3)}, G 4 ={POLYGON(2.8 1, 3.6 1, 3.6 1.8, 2.8 1.8)}, and take a typical spatial relational query as an example to read to illustrate the entire data access process.

[0049] The method that the present invention puts into the spatial geometry object value to the database, its flow process is as follows figure 1 shown, including the following steps:

[0050] (1) Create a spatial table T containing geometry columns g ;

[0051] Create a spatial table T with a geometry column g At the same time, construct its subsidiary structure and association relationship to form an organizational structure scheme: Schema g ={T b ,T s , I bs ,R bs},Such as image 3 shown....

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 relates to a method for storing space geometric objects to a database. The method comprises the following steps: creating a database space table containing geometric columns; receiving space geometric object embodiments in an information mode, extracting space geometric eigenvalues and initialing in-row indicators of the geometric columns; calculating and assigning a space order code to each space geometric object; writing the in-row indicators of the geometric columns along with other in-row data; adopting a blocking and aggregation index method of the geometric objects to write the out-row data of the geometric columns; and creating or refreshing a space index. A corresponding reading method comprises the following steps: confirming the reading types of geometric object values according to the operation types of a current space and the storage types of the geometric objects; reading the in-row data of the space geometric object embodiments appointed by the geometric columns; and reading the out-row data if necessary. The method improves the response efficiency for reading the data of the geometric objects and further minimizes the I / O access of the out-row data of the geometric columns.

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 geometry object access method implemented in the kernel of a database management system. Background technique [0002] The efficient organization and management of massive geospatial data is the key technology to be solved by the next generation geographic information system (GIS) platform. "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 dat...

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
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 Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

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

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com