Unlock instant, AI-driven research and patent intelligence for your innovation.

Method for importing high-capacity VCT file into spatial database

A spatial data and database technology, which is applied in the field of importing large-capacity VCT files into spatial databases, can solve problems such as memory overflow, and achieve the effect of solving memory limitations and avoiding differences in storage characteristics

Active Publication Date: 2019-08-09
SOUTHEAST UNIV
View PDF11 Cites 1 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0009] The second idea can effectively reduce the time consumption of performing database query operations, but requires a large amount of memory as a temporary storage area for elements
After testing, when the file exceeds 600M, using this method to import the VCT file will cause an abnormal situation of memory overflow

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 importing high-capacity VCT file into spatial database
  • Method for importing high-capacity VCT file into spatial database
  • Method for importing high-capacity VCT file into spatial database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0032] The present invention will be further explained below in conjunction with the accompanying drawings and specific embodiments. It should be understood that the following specific embodiments are only used to illustrate the present invention and are not intended to limit the scope of the present invention.

[0033] A method for importing a large-capacity VCT file into a spatial database according to the present invention is realized by developing a desktop application program running on a Windows platform with the C# programming language under the integrated development environment of Microsofit VisualStudio 2010. The application program implements the writing of spatial elements by calling the ArcObjects development component. The imported target spatial database adopts ArcGIS Geodatabase and is stored in the Oracle database management system. The VCT file selects the current land use data of a city as the file to be imported, and the file size is about 1.5GB. The featu...

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 importing a high-capacity VCT file into a spatial database, and the basic idea of the method comprises the steps: an index table for recording element target identification codes, element types, spatial geometric data storage line numbers and attribute storage line numbers is established before the VCT file is imported; when the VCT file import is executed, onecopy is copied from the VCT file, the original file and the copy are opened at the same time, then data are read and analyzed from the two files according to the geometric data storage line number and the attribute storage line number of the element by traversing the index table, and an analysis result is written into the spatial database together. According to the invention, the problem that a large-capacity VCT file is limited by a memory when being imported into spatial data can be thoroughly solved; the risk of low data exchange efficiency caused by storage characteristic difference between a VCT file and a general spatial geographic database is effectively avoided, a reliable and efficient method is provided for actual data conversion work, and the method has important practical significance in application of a geographic information system.

Description

technical field [0001] The invention belongs to the field of geographic information system (GIS) data exchange, and in particular relates to a method for importing a large-capacity VCT file into a spatial database. Background technique [0002] The national standard "GB / T 17798-2007 Geospatial Data Exchange Format" stipulates that the vector data file used for data exchange between geographic information systems is called a VCT file, the suffix is ​​*.vct, and the spatial data is stored in a VCT in plain text. in the file. [0003] The content stored in the VCT file can be divided into eight parts, as attached figure 1 As shown, including: 1) Describe the basic information of the data, such as the file header of the data range, coordinate dimension, and mathematical basic information; 2) Define the element type parameters of the spatial data classification included; 3) Define the structure of the attribute data; 4 ) Spatial geometry data; 5) Annotation data; 6) Topological...

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): G06F16/29
CPCG06F16/29
Inventor 王鸣飞郭胜涛
Owner SOUTHEAST UNIV