Data mapping method and device

A data mapping and database technology, applied in the field of data processing, can solve problems such as low efficiency, inconsistent code and data mapping logic, etc., and achieve the effect of good presentation, simplified definition process, and high technical maturity.

Active Publication Date: 2018-11-16
CHINA CONSTRUCTION BANK
View PDF12 Cites 6 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, in the existing technology, the data mapping logic is usually described in words, so the process of converting the data mapping logic into the corresponding code often requires developers to manually write, or combine a large number of manual modifications on the basis of partial automatic generation It is inefficient and may lead to inconsistencies between code and data mapping logic

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
  • Data mapping method and device
  • Data mapping method and device
  • Data mapping method and device

Examples

Experimental program
Comparison scheme
Effect test

no. 1 example

[0061] figure 2 A flowchart of data mapping is shown. refer to figure 2 , data mapping usually includes the following steps:

[0062] Step S1: Configure data mapping logic.

[0063] Data mapping logic is usually configured by users according to the actual needs of data mapping. In the prior art, the data mapping logic is usually identified in the form of unstructured data, such as a text description or a text description combined with some tables. However, in the data mapping method provided by the embodiment of the present invention, the data mapping logic to be parsed is marked in the form of structured data, which is convenient for data presentation and automatic parsing.

[0064] The data mapping logic in the embodiment of the present invention may include the first structured data and the second structured data. In the embodiment of the present invention, only the content of the structured data is limited, but its specific organizational form is not limited. For ex...

no. 2 example

[0164] Figure 4 A functional block diagram of the data mapping apparatus 200 provided by the embodiment of the present invention is shown. refer to Figure 4 , the device includes an analysis module 210 and an SQL statement generation module 220 .

[0165] The parsing module 210 is used to parse the logical segment in the first structured data, and obtain the SQL fragment used to form the structured query language SQL statement, wherein the first structured data is used to represent the data processing steps in the data mapping structured data, the logical segment is structured data representing the SQL segment; the SQL statement generating module 220 is configured to generate the SQL statement corresponding to the data processing step based on the splicing of the SQL segment.

[0166] Further, in an implementation manner of the second embodiment, the parsing module 210 may include a first parsing unit, a second parsing unit, and a SQL fragment splicing unit.

[0167]Where...

no. 3 example

[0170] The third embodiment of the present invention provides a computer storage medium, in which computer program instructions are stored. When the computer program instructions are read and run by a processor of the computer, the data mapping method provided by the embodiment of the present invention is executed. The computer storage medium can be implemented as, but not limited to figure 1 Memory 102 is shown.

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 relates to the technical field of data processing and provides a data mapping method and device. The data mapping method includes the steps that logical segments in first structured dataare parsed, and SQL segments forming SQL statements are obtained, wherein the first structured data is used for representing structured data of data processing steps in data mapping, and the logicalsegments are used for representing structured data of the SQL segments; the SQL statements corresponding to the data processing steps are spliced and generated based on the SQL segments. It is visiblethat data mapping logics are represented with the first structured data in advance, so that the SQL segments are easily obtained by parsing the structured data, and then the SQL statements corresponding to the data processing steps are restored. By adopting the method, corresponding codes can be completely and automatically generated based on the data mapping logics, accordingly the executing efficiency of data mapping can be remarkably improved, and meanwhile the consistency of the generated codes and the data mapping logics is ensured.

Description

technical field [0001] The present invention relates to the technical field of data processing, in particular to a data mapping method and device. Background technique [0002] Data mapping refers to the process of mapping source data to target data through some data processing steps. Generally speaking, the source data and the target data are the fields of the data table, and the data processing steps are represented by a structured query language (Structured Query Language, SQL) statement. The data used to describe the data mapping is called the data mapping logic, based on the data mapping logic, the code for implementing the data mapping can be generated. However, in the existing technology, the data mapping logic is usually described in words, so the process of converting the data mapping logic into the corresponding code often requires developers to manually write, or combine a large number of manual modifications on the basis of partial automatic generation It is in...

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 CHINA CONSTRUCTION BANK
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

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

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap