Method for storing space geometric objects to database

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 sThe 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 sns; 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 tumns; 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.he geometric columns.pace 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 codepace 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 writeto 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 writethe 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 val 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 colues 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 colum

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

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

Images