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.

An Effective Framework for Enhancing Query Answering in a Heterogeneous Data Lake

An Ontology-Based Semantic Retrieval Approach for Heterogeneous 3D CAD Models

Exploring Heterogeneous Data Lake Based on Unified Canonical Graphs

Searching Data Lakes for Nested and Joined Data

A multi-source heterogeneous medical data enhancement framework based on lakehouse

Symphony: Towards Natural Language Query Answering over Multi-modal Data Lakes.

Semantic Data Management in Data Lakes

MQRLD: A Multimodal Data Retrieval Platform with Query-aware Feature Representation and Learned Index Based on Data Lake

Coarse-to-Careful: Seeking Semantic-related Knowledge for Open-domain Commonsense Question Answering

Efficient Query Processing Framework for Big Data Warehouse: an Almost Join-Free Approach

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

A System and Benchmark for LLM-based Q&A on Heterogeneous Data

Personalized Query System Based on Heterogeneous Data Sources

A Heterogeneous Multi-Modal Medical Data Fusion Framework Supporting Hybrid Data Exploration

A Synergistic Framework for Geographic Question Answering

Robust Table Integration in Data Lakes

A Flexible Data Warehousing Approach for One-Stop Querying on Heterogeneous Personal Information

Hierarchical Scalable Data Lake Design for Game Engine

An Effective and Versatile Keyword Search Engine on Heterogenous Data Sources.

Integrating Heterogeneous Stream and Historical Data Sources using SQL

AQUA: Automatic Collaborative Query Processing in Analytical Database