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

Mapping relation generation method and device

A mapping relationship and syntax analysis technology, applied in database management systems, special data processing applications, instruments, etc., can solve the problem of low accuracy of mapping relationship

Active Publication Date: 2019-08-20
CHINA MOBILE SUZHOU SOFTWARE TECH CO LTD +1
View PDF5 Cites 1 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] Embodiments of the present invention provide a method and device for generating a mapping relationship to solve the problem in the prior art that the accuracy of generating a mapping relationship based on the number of the SQL element is low

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
  • Mapping relation generation method and device
  • Mapping relation generation method and device
  • Mapping relation generation method and device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0054] In order to make the purpose, technical solution and advantages of the present invention clearer, the present invention will be further described in detail below in conjunction with the accompanying drawings. Based on the embodiments of the present invention, all other embodiments obtained by persons of ordinary skill in the art without making creative efforts belong to the protection scope of the present invention.

[0055] The mapping relationship generation method provided by the embodiment of the present invention is executed by a device with a database access function, such as a personal computer, a server, etc., and is applicable to a Data Definition Language (DDL) in SQL.

[0056] In the embodiment of the present invention, the first table name is the table name of the table created in the SQL program, and the second table name is a table name other than the first table name in the SQL program. The first set is used to save the information of the SQL elements obt...

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 mapping relation generation method and device, for solving the problem that the mapping relation generated in the prior art is relatively low in accuracy. The mapping relation generation method comprises the following steps: carrying out grammatical analysis on a structured query language (SQL) program, and constructing an abstract syntax tree (AST) of the SQL program; recursively traversing the AST to obtain the information of the SQL element obtained by recursion each time, the information of the SQL element at least comprising a table name and a field name; establishing and storing a first set according to the obtained information of the SQL element, wherein the ith key value pair in the first set is used for storing the information of the SQL element obtainedby the jth recursion, and a key in the ith key value pair at least comprises a table name obtained through the jth recursion, and a value in the ith key value pair at least comprises a field name obtained through the jth recursion, i = 1, 2,... N, j = 1, 2,... N, and N is the recursion frequency; and generating a mapping relationship according to the first set.

Description

technical field [0001] The invention relates to the field of computers and databases, in particular to a method and device for generating a mapping relationship. Background technique [0002] Data extraction, transformation, and loading (Extract-Transform-Load, ETL) technology is the core and soul of the data warehouse (Data Warehouse, DW), responsible for the process of data transformation from the data source to the target data warehouse, that is, extracting the required data from the data source. After data cleaning, the data is finally loaded into the data warehouse according to the pre-defined data warehouse model. Among them, DW is used for the data generated by the enterprise's On-Line Transaction Processing (OLTP) system Carry out integration, explore the commercial value, and provide decision support for enterprises. [0003] In the ETL technology based on Structured Query Language (SQL) scripts, it is necessary to parse the SQL program to extract the SQL elements ...

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): G06F16/25G06F16/28G06F16/242G06F17/27
CPCG06F16/254
Inventor 朱刘江
Owner CHINA MOBILE SUZHOU SOFTWARE TECH CO LTD