Field matching method and device, computer storage medium and terminal

Abstract

The invention discloses a field matching method and device, a computer storage medium and a terminal. The field matching method comprises the steps of determining a first feature vector of an originaltable and a second feature vector of each to-be-matched first standard table; Determining a second standard table in a mapping relation with the original table according to the determined first feature vector and each second feature vector; Establishing field mapping between the original field of the original table and the determined standard field of the second standard table; And determining atarget field for field matching according to the field similarity of the original field and the standard field which are mapped. According to the embodiment of the invention, the matching accuracy andefficiency of the whole field of the original table are improved.

Description

Technical field [0001] This article relates to but not limited to data processing technology, especially a method, device, computer storage medium and terminal for field matching. Background technique [0002] How to effectively ensure the integrity of data, realize the standardization and standardization of data, and improve data quality and governance efficiency is of vital importance to today's data governance tasks. The source data of data governance can include data of different types and systems. Among them, the source data of a relational database may have hundreds or even thousands of tables, and each table may have tens to hundreds of fields. Before the source data is extracted, it is a tedious task to establish a one-to-one mapping between a large number of original fields and target fields. Generally, in the process of data extraction, there are three ways to match the original field to the target field: the first method is to directly manually define the target fiel...

AI Technical Summary

Problems solved by technology

[0003] Among the matching methods of the original field and the target field above: the first method has high accuracy and flexibility, but is inefficient, and is not applicable to the situation of a large number of tables, and the manually created fields are not standardized in terms of commands; the second method The method belongs to semi-automatic matching, and the efficiency is improved compared with the first method, but it still needs to manually create mapping fields. For the situation of many tables, the efficiency is still very low

Images