Data table processing method and device

Abstract

The invention discloses a data table processing method and device. The method comprises: acquiring a first main key of a data table in a knowledge base, the first main key being a standard main key, the first main key at least comprising a Chinese main key and an English main key, and the first main key comprising one or more fields; obtaining a second primary key of a to-be-standardized data table; when the second primary key in the to-be-standardized data table is inconsistent with the standard primary key corresponding to the second primary key in the knowledge base, modifying a second primary key in the to-be-standardized data table into a standard primary key corresponding to the second primary key in the to-be-standardized data table. According to the method and the device, the mainkeys of the plurality of data tables of the same event are standardized, so that the technical problem of high error rate in the process of processing the data in the plurality of data tables of the same event due to inconsistency of the main keys of the data tables of the same event in the prior art is solved.

Description

technical field [0001] The present invention relates to the field of data table processing, in particular to a data table processing method and device. Background technique [0002] Data standardization refers to the social practices in various fields, for those data that are repeated, incomplete, and with inconsistent rules, through some regulations of the state or industry, these problematic data can meet the required uniform standards, So that these data become regular, neat and effective data. [0003] Many of the original tables provided by customers are not uniform enough: data tables generally have Chinese and English names of the tables, but many original tables have random Chinese and English names, and there are also different tables with the same Chinese and English names. The phenomenon of disagreement will cause wrong operations on the data during the data governance process, resulting in problems with the data in the final target table. [0004] In the prior ...

AI Technical Summary

Problems solved by technology

[0005] The embodiment of the present invention provides a data table processing method and device, to at least solve the problem in the prior art, due to the inconsistency of the primary key of the data table of the same event, resulting in the data in multiple data tables of the same event Technical issues with high error rates during processing

Images