System and Method for Joining Datasets

A computer-implemented system comprising:

• a first input for receiving a first dataset including a first table having a first plurality of parts, where each part of the first plurality of parts represents either a row or a column of the first table;
• a second input for receiving a second dataset including a second table having a second plurality of parts, where each part of the second plurality of parts represents either a row or a column of the second table;
• a processor configured to perform the following steps:
• for each part of the first plurality of parts,
• forming a string representation of the part from a plurality of values associated with the part;
• determining a numerical representation of the string representation of the part;
• for each part of the second plurality of parts,
• forming a string representation of the part from a plurality of values associated with the part;
• determining a numerical representation of the string representation of the part;
• determining a mapping between at least some parts of the first table and second table including determining that a first set of one or more parts of the first plurality of parts correspond a second set of one or more parts of the second plurality of parts based at least in part on a similarity between numerical representations of the parts.

Software stored in a non-transitory form on a computer-readable medium, the software including instructions for causing a computing system to:

• receive a first dataset including a first table having a first plurality of parts, where each part of the first plurality of parts represents either a row or a column of the first table;
• receive a second dataset including a second table having a second plurality of parts, where each part of the second plurality of parts represents either a row or a column of the second table;
• for each part of the first plurality of parts,
• form a string representation of the part from a plurality of values associated with the part;
• determine a numerical representation of the string representation of the part;
• for each part of the second plurality of parts,
• form a string representation of the part from a plurality of values associated with the part;
• determine a numerical representation of the string representation of the part;
• determine a mapping between at least some parts of the first table and second table including determining that a first set of one or more parts of the first plurality of parts correspond a second set of one or more parts of the second plurality of parts based at least in part on a similarity between numerical representations of the parts.