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

Method and system for simultaneously realizing ETL (Extract Transform and Load) process of spatial data and attribute data

A technology of spatial data and attribute data, applied in the direction of electrical digital data processing, special data processing applications, instruments, etc., can solve problems such as loss of style information, failure to consider spatial data style information, failure to save and restore, etc., to achieve flexible design and implementation Effect

Active Publication Date: 2013-07-24
FOUNDER INTERNATIONAL CO LTD
View PDF3 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, these methods only consider the spatial information in the spatial data, but do not consider the style information contained in the spatial data, and cannot save and restore this information during the ETL process, and the style information is lost after the ETL process

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 and system for simultaneously realizing ETL (Extract Transform and Load) process of spatial data and attribute data
  • Method and system for simultaneously realizing ETL (Extract Transform and Load) process of spatial data and attribute data
  • Method and system for simultaneously realizing ETL (Extract Transform and Load) process of spatial data and attribute data

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0043] The present invention will be described below in conjunction with the accompanying drawings and specific embodiments.

[0044] like figure 1 As shown, the source data is spatial data, which includes not only traditional attribute information, but also spatial information and style information, and the target data source to be loaded also has attribute information, spatial information and style information correspondingly. By adopting the method of the invention, the ETL process of attribute data and spatial data (spatial information and style information data) can be integrated together, and the extraction, conversion and loading between arbitrary spatial data and attribute data can be realized.

[0045] like figure 2 As shown, a system that realizes the ETL process of spatial data and attribute data at the same time includes the following devices:

[0046] A source data reading device 11, configured to read source data from a data source, where the source data is sp...

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 and system for simultaneously realizing an ETL (Extract Transform and Load) process of spatial data and attribute data, which relate to the technical field of computerized information processing. In the prior art, an ETL solution of the spatial data is provided but not perfect, and is only limited in extraction, transformation and load of coordinate information, and the combination of the ETL solution and an ETL process of traditional attribute information is not considered. The method comprises the following steps: reading source data from a data source; detecting whether the source data contains graphic element information or not, if yes, transforming the graphic element information which comprises spatial information and style information, and if not, directly transforming into attribute data; and loading the transformed data into a target data source. According to the invention, the ETL process of the attribute data and the ETL process of the spatial data are integrated, so that extraction and transformation between any spatial data and any attribute data are realized.

Description

technical field [0001] The invention relates to the technical field of computer information processing, in particular to a method and a system for simultaneously realizing the ETL process of spatial data and attribute data. Background technique [0002] ETL is the abbreviation of Extract-Transform-Load, which is the process of data extraction, transformation, and loading. It is responsible for extracting data from distributed and heterogeneous data sources such as relational data and flat data files to the temporary intermediate layer for cleaning, Transformation, integration, and finally loading into the target data source or data warehouse become the basis for online analytical processing and data mining. [0003] Spatial data refers to the data used to represent the position, shape, size and distribution characteristics of spatial entities. It can be used to describe objects from the real world. It has characteristics such as positioning, qualitative, temporal and spatial...

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 Patents(China)
IPC IPC(8): G06F17/30
Inventor 王生郑学进周小良程永辉郑佳栋肖云
Owner FOUNDER INTERNATIONAL CO LTD
Features
  • R&D
  • Intellectual Property
  • Life Sciences
  • Materials
  • Tech Scout
Why Patsnap Eureka
  • Unparalleled Data Quality
  • Higher Quality Content
  • 60% Fewer Hallucinations
Social media
Patsnap Eureka Blog
Learn More

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

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