Supercharge Your Innovation With Domain-Expert AI Agents!

Generation method and device for mapping relationship

A technology of mapping relationship and syntax tree, which is applied in the directions of instruments, calculations, electrical digital data processing, etc., can solve problems such as inconvenient operation and increased labor costs

Active Publication Date: 2013-07-03
ADVANCED NEW TECH CO LTD
View PDF5 Cites 25 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, when the SQL is directly modified by the maintenance personnel, the field mapping relationship in the MAPPING tool requires the maintenance personnel to perform maintenance and modification after modifying the program, which increases labor costs and is inconvenient to operate

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
  • Generation method and device for mapping relationship
  • Generation method and device for mapping relationship

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0020] The method for generating the mapping relationship in the embodiment of the present invention is to perform grammatical analysis on the SQL program, and extract the SQL basic element objects in the SQL syntax tree; number and store the extracted SQL basic element objects according to the order of appearance; The non-specific SQL basic element objects in the basic element objects are replaced with explicit SQL basic element objects, and stored according to the number; the mapping relationship is generated according to the numbered SQL basic element objects and corresponding rules. Extract the basic element objects in the SQL syntax tree, and then generate the mapping relationship according to the corresponding rules after processing. The generated mapping relationship can cover the field level. The requirement of lineage analysis facilitates the automatic maintenance of metadata information in ETL.

[0021] A complex SQL may be composed of multiple sub-SQLs. The most ba...

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 generation method for a mapping relationship. The method is used for generating a field-stage mapping relationship so as to facilitate the automatic maintenance on element data in ETL (extraction transformation loading). The method comprises the following steps of: carrying out syntax analysis on a structured query language (SQL) program, and extracting SQL basic element objects in an SQL syntax tree; carrying out numbering and storing on the extracted SQL basic element objects according to an appearance sequence; replacing indefinite SQL basic element objects in the SQL basic element objects into definite SQL basic element objects, and storing according to numbers; and generating the mapping relationship according to the numbers of numbered SQL basic element objects and a corresponding rule. The invention further discloses a device for realizing the method.

Description

technical field [0001] The invention relates to the fields of computers and databases, in particular to a method and device for generating a mapping relationship. Background technique [0002] ETL (Extraction-Transformation-Loading, data extraction, transformation and loading) technology is responsible for extracting data from distributed and heterogeneous data sources such as relational data and flat data files to the temporary middle layer for cleaning, transformation and integration, and finally Loaded into the data warehouse or data mart, it becomes the basis of online analytical processing and data mining. [0003] In the ETL technology based on SQL (Structured Query Language, Structured Query Language) scripts, whenever the ETL program is developed or modified, it is necessary to manually maintain the tables and fields in the source system and the tables and fields in the data warehouse It is easy to cause the maintenance information to be out of sync with the actual ...

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 ADVANCED NEW TECH 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