Method, device and equipment for determining association relationship between data tables

A technology of association relationship and data table, applied in the field of data processing, can solve problems such as inability to join data tables
CN112115138APending Publication Date: 2020-12-22THE FOURTH PARADIGM BEIJING TECH CO LTD
0 Cites 5 Cited by

Patent Information

Authority / Receiving Office
CN · China
Current Assignee / Owner
THE FOURTH PARADIGM BEIJING TECH CO LTD
Publication Date
2020-12-22

Smart Images

  • Figure 1
    Figure 1
  • Figure 2
    Figure 2
  • Figure 3
    Figure 3
Patent Text Reader

Abstract

The invention provides a method, a device and equipment for determining an association relationship between data tables. The method comprises the following steps: acquiring data table pairs involved in a target data table set; wherein the data table pair comprises a first data table and a second data table; obtaining a splicing key field pair used for associating the first data table with the second data table; wherein the splicing key field pair comprises an outer key field of the first data table and a main key field of the second data table; and calculating the association degree of the splicing key field pairs, and determining the association relationship between the data tables according to the calculated association degree.
Need to check novelty before this filing date? Find Prior Art

Description

technical field

[0001] The present invention relates to the field of data processing, and more specifically, to a method for determining the association relationship between data tables, a device for determining the association relationship between data tables, and a device including at least one computing device and at least one storage device , and a computer-readable storage medium. Background technique

[0002] With the emergence of massive data in various industries, data needs to be processed in more and more scenarios, such as first determining the relationship between data tables, and splicing the data tables according to the relationship.

[0003] In related technologies, the user manually inputs the association relationship between two data tables and the primary and foreign key information of the two data tables. This method relies on artificially providing the primary and foreign key information of the data tables and the table association relationship. When the...

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