Method and device for automatically associating synonymous data in heterogeneous database and electronic equipment

Abstract

The embodiment of the invention provides a method and device for automatically associating synonymous data in a heterogeneous database and electronic equipment. The method comprises the steps: obtaining fields in a first database and a second database, the first database and the second database being heterogeneous databases for each other; based on the mapping relation between preset fields and words in a word bank, searching the corresponding words of the obtained fields in the word bank, obtaining the words corresponding to the fields in the first database and the words corresponding to thefields in the second database, wherein the word bank comprises professional terms of the industry to which the first database and the second database belong; and respectively comparing the similarityof the words corresponding to the fields in the first database with the similarity of the words corresponding to the fields in the second database, and associating the fields in the first database with the fields in the second database, wherein the similarity of the fields in the first database is higher than a preset threshold. By applying the embodiment of the invention, the efficiency of synonymous data association between heterogeneous databases can be improved.

Description

technical field [0001] The invention relates to the technical field of data processing, in particular to a method, device and electronic equipment for automatically associating synonymous data in heterogeneous databases. Background technique [0002] At present, there are often multiple implementation methods for software systems that complete the same or similar business functions, for example, various online car-hailing application software for individual consumers, various banking business systems for enterprises, and various hospital information systems, etc. . Among them, software systems with the same or similar business functions but inconsistent implementation methods and internal structures are called heterogeneous systems, and the databases in the heterogeneous systems are called heterogeneous databases. In heterogeneous databases, because the same data has differences in internal naming, processing, and storage, the data that completely equivalently expresses the...

AI Technical Summary

Problems solved by technology

[0005] However, in the existing methods of synonymous data association in heterogeneous databases, on the one hand, some manufacturers often do not abide by the data standard specification because the data standard specification is not mandatory and its binding force is not strong. Or partially complied with, in this way, the converted data does not comply with the established data standards; Comply with the established data standards and specifications, which ultimately leads to low efficiency of synonymous data association between heterogeneous databases

Images