Abstract:In this paper, we investigate the challenge of integrating tables from data lakes, focusing on three core tasks: 1) pairwise integrability judgment, which determines whether a tuple pair in a table is integrable, accounting for any occurrences of semantic equivalence or typographical errors; 2) integrable set discovery, which aims to identify all integrable sets in a table based on pairwise integrability judgments established in the first task; 3) multi-tuple conflict resolution, which resolves conflicts among multiple tuples during integration. We train a binary classifier to address the task of pairwise integrability judgment. Given the scarcity of labeled data, we propose a self-supervised adversarial contrastive learning algorithm to perform classification, which incorporates data augmentation methods and adversarial examples to autonomously generate new training data. Upon the output of pairwise integrability judgment, each integrable set is considered as a community, a densely connected sub-graph where nodes and edges correspond to tuples in the table and their pairwise integrability, respectively. We proceed to investigate various community detection algorithms to address the integrable set discovery objective. Moving forward to tackle multi-tuple conflict resolution, we introduce an novel in-context learning methodology. This approach capitalizes on the knowledge embedded within pretrained large language models to effectively resolve conflicts that arise when integrating multiple tuples. Notably, our method minimizes the need for annotated data. Since no suitable test collections are available for our tasks, we develop our own benchmarks using two real-word dataset repositories: Real and Join. We conduct extensive experiments on these benchmarks to validate the robustness and applicability of our methodologies in the context of integrating tables within data lakes.

FREYJA: Efficient Join Discovery in Data Lakes

Retrieve, Merge, Predict: Augmenting Tables with Data Lakes

Searching Data Lakes for Nested and Joined Data

Measuring and Predicting the Quality of a Join for Data Discovery

Relaxed Functional Dependency Discovery in Heterogeneous Data Lakes

LakeBench: Benchmarks for Data Discovery over Data Lakes

Integrating Data Lake Tables

Minimally-Supervised Attribute Fusion for Data Lakes

Self-supervised data lakes discovery through unsupervised metadata-driven weighted similarity

A New Design of High-Performance Large-Scale GIS Computing at a Finer Spatial Granularity: A Case Study of Spatial Join with Spark for Sustainability

Finding Related Tables in Data Lakes for Interactive Data Science

Optimizing Federated Queries Based on the Physical Design of a Data Lake

Efficient Join Synopsis Maintenance for Data Warehouse.

Analytic Processing in Data Lakes: A Semantic Query-Driven Discovery Approach

Exploiting Formal Concept Analysis for Data Modeling in Data Lakes

Discovering Multi-Table Functional Dependencies Without Full Join Computation

Joint Management and Analysis of Textual Documents and Tabular Data within the AUDAL Data Lake

Deep Lake: a Lakehouse for Deep Learning

Robust Table Integration in Data Lakes

Reservoir Sampling over Joins

Model Joins: Enabling Analytics Over Joins of Absent Big Tables