# Synthesizing Mapping Relationships Using Table Corpus

## TL;DR

This paper proposes a method to synthesize mapping relationships from large table corpora, leveraging co-occurrence and constraints, to improve data integration and cleaning applications.

## Contribution

It introduces a novel approach that uses table compatibility and functional dependencies to generate high-quality mapping relationships from web and spreadsheet tables.

## Key findings

- Effective in producing high-quality mappings
- Applicable to web tables and enterprise spreadsheets
- Enhances data cleaning and integration tasks

## Abstract

Mapping relationships, such as (country, country-code) or (company, stock-ticker), are versatile data assets for an array of applications in data cleaning and data integration like auto-correction and auto-join. However, today there are no good repositories of mapping tables that can enable these intelligent applications. Given a corpus of tables such as web tables or spreadsheet tables, we observe that values of these mappings often exist in pairs of columns in same tables. Motivated by their broad applicability, we study the problem of synthesizing mapping relationships using a large table corpus. Our synthesis process leverages compatibility of tables based on co-occurrence statistics, as well as constraints such as functional dependency. Experiment results using web tables and enterprise spreadsheets suggest that the proposed approach can produce high quality mappings.