Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

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

Pending Publication Date: 2020-12-22
THE FOURTH PARADIGM BEIJING TECH CO LTD
View PDF0 Cites 5 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[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 user cannot obtain or provide the table association relationship and primary and foreign key information of the data table, the data table cannot be spliced

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
  • Method, device and equipment for determining association relationship between data tables
  • Method, device and equipment for determining association relationship between data tables
  • Method, device and equipment for determining association relationship between data tables

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0178] Various exemplary embodiments of the present invention will now be described in detail with reference to the accompanying drawings. It should be noted that the relative arrangements of components and steps, numerical expressions and numerical values ​​set forth in these embodiments do not limit the scope of the present invention unless specifically stated otherwise.

[0179] The following description of at least one exemplary embodiment is merely illustrative in nature and in no way taken as limiting the invention, its application or uses.

[0180] Techniques, methods and devices known to those of ordinary skill in the relevant art may not be discussed in detail, but where appropriate, such techniques, methods and devices should be considered part of the description.

[0181] In all examples shown and discussed herein, any specific values ​​should be construed as exemplary only, and not as limitations. Therefore, other instances of the exemplary embodiment may have dif...

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 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.

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

Application Information

Patent Timeline
no application Login to View More
IPC IPC(8): G06F16/22G06F16/28
CPCG06F16/2282G06F16/284
Inventor 姚均霖
Owner THE FOURTH PARADIGM BEIJING TECH CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com