×

TECHNIQUES FOR FACILITATING THE JOINING OF DATASETS

  • US 20180075115A1
  • Filed: 09/14/2017
  • Published: 03/15/2018
  • Est. Priority Date: 09/15/2016
  • Status: Active Grant
First Claim
Patent Images

1. A method comprising, at a computer system:

  • generating first profile metadata for each column of a first plurality of columns in a first dataset stored a first data source;

    generating second profile metadata for each column of a second plurality of columns in a second dataset stored a second data source;

    identifying, based on the first profile metadata and second profile metadata, a plurality of column pairs between the first dataset and the second dataset, wherein columns in each of the plurality of column pairs have a relationship;

    determining one or more types of join functions for each of the one or more column pairs;

    generating a first graphical interface to display each of the one or more types of join functions, wherein each of the one or more types of join functions are displayed showing a diagram of the type of join function for joining the first dataset with the second dataset by columns in a different column pair of the plurality of column pairs;

    receiving input corresponding to selection of a first type of join function of the one or more types of join functions; and

    generating a second graphical interface to display a third dataset based on joining, according to the first type of join function, the first dataset at a first column within a first column pair with the second dataset at a second column in the first column pair.

View all claims
  • 1 Assignment
Timeline View
Assignment View
    ×
    ×