Abstract: Methods and systems for joining two tables are provided. At least two tables to be joined are received. A joinable row pair between the at least two tables is determined. The determined joinable row pair includes a first row from a first table having a common string value with a second row from a second table of the at least two tables. A transformation model is generated from the determined joinable row pair. A column of the first table is transformed based on the generated transformation model. The transformed first table is joined with the second table.

Abstract: There is provided a system and method for set overlap searching of a data lake. The method includes: receiving input tables; generating an inverted index from the input tables; receiving a query set of data values to be searched; receiving a requested set quantity; while a comparison condition is true, the comparison condition based on at least a size of the query set, iteratively performing: determining whether a first net cost of reading a candidate set is greater than a second net cost of reading an unread one of the posting lists; where its true, adding the unread one of the posting lists to the candidate set; and where its negative, determining whether the overlap between the query set and the candidate set is greater than the lowest ranked candidate set in a heap, and adding the candidate set to the heap.

Abstract: Methods and systems for joining two tables are provided. At least two tables to be joined are received. A joinable row pair between the at least two tables is determined. The determined joinable row pair includes a first row from a first table having a common string value with a second row from a second table of the at least two tables. A transformation model is generated from the determined joinable row pair. A column of the first table is transformed based on the generated transformation model. The transformed first table is joined with the second table.