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

A data column mapping method and system

A mapping method and data column technology, applied in the field of data mapping, can solve problems such as long time-consuming and high cost, and achieve the effect of improving work efficiency

Active Publication Date: 2020-10-16
深圳市翼海云峰科技有限公司
View PDF6 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] In view of the problems existing in the prior art, the object of the present invention is to design a data column mapping method and system to solve the problem that the mapping from the source database column structure to the target database column structure takes a long time and costs high

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
  • A data column mapping method and system
  • A data column mapping method and system
  • A data column mapping method and system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0024] The present invention will be described in detail below in conjunction with the accompanying drawings. The description in this part is only exemplary and explanatory, and should not have any limiting effect on the protection scope of the present invention.

[0025] A data column mapping method provided by the present invention includes:

[0026] S1. Obtain feature information of source database and target database tables and columns;

[0027] S2. Converting the obtained feature information into text, specifically converting the obtained database table / column feature information into a text string;

[0028] S3, transforming the textual feature information into a vector;

[0029] S4. Extract a combination of some source database columns and target database columns to form a sample set;

[0030] S5. Perform similarity calculation and matching judgment on the feature information vectors of the source database column and the target database column in the sample set;

[00...

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 data column mapping method and system. The method comprises the steps of obtaining feature information of tables and columns of a source database and a target database; textualizing the obtained feature information; converting the textualized feature information into vectors; extracting part of combinations of the columns of the source database and the target database to form a sample set; performing similarity calculation on the feature information vectors of the columns of the source database and the target database in the sample set, and performing matching judgment; based on a similarity calculation result and a matching judgment result, generating a Bayesian classifier; and applying the Bayesian classifier to all the combinations of the columns of the source database and the target database. According to the method and the system, automated database column mapping can be realized, so that the working efficiency is improved.

Description

technical field [0001] The present invention relates to the technical field of data mapping, and more specifically, to a data column mapping method and system. Background technique [0002] As we all know, data in databases, especially relational databases, is organized in the form of tables (Tab l e), and each database table is organized by rows (Rows) and columns (Columns). The columns are also called fields, and each field has a specific type. Each row in the database table represents a specific piece of data, and each piece of data is composed of the above fields. In data processing tasks, it often involves the mapping and integration of the source database to the target database, and because the source database and the target database often have different database schemas (Scheme), that is to say, the database tables and column structures of the two databases are often Different, so it is necessary to map the table and column structure of the source database to the ta...

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): G06F16/22
CPCG06F16/221
Inventor 陈磊
Owner 深圳市翼海云峰科技有限公司