🤖 AI Summary
This work addresses the challenge of identifying non-rectangular, non-contiguous overlapping regions in heterogeneous tables by proposing Shape-Agnostic Largest Table Overlap (SALTO), a novel framework that models tables as hypergraphs and formulates overlap detection as a maximum common subhypergraph problem. SALTO employs structure-aware label classification, coherence-based pruning, and tolerance-aware optimization within a branch-and-bound strategy to enable the HyperSplit algorithm to efficiently avoid explicit enumeration of row and column permutations. Evaluated on real-world datasets, the method discovers larger overlaps in 78.8% of cases, significantly outperforming existing approaches, and demonstrates practical efficacy in cross-source duplication detection, deduplication, and version comparison tasks.
📝 Abstract
Understanding how two tables overlap is useful for many data management tasks, but challenging because tables often differ in row and column orders and lack reliable metadata in practice. Prior work defines the largest rectangular overlap, which identifies the maximal contiguous region of matching cells under row and column permutations. However, real overlaps are rarely rectangular, where many valid matches may lie outside any single contiguous block. In this paper, we introduce the Shape-Agnostic Largest Table Overlap (SALTO), a novel generalized notion of overlap that captures arbitrary-shaped, non-contiguous overlaps between tables.
To tackle the combinatorial complexity of row and column permutations, we propose to model each table as a hypergraph, casting SALTO computation into a maximum common subhypergraph problem. We prove their equivalence and show the problem is NP-hard to approximate. To solve it, we propose HyperSplit, a novel branch-and-bound algorithm tailored to table-induced hypergraphs. HyperSplit introduces (i) hypergraph-aware label classes that jointly encode cell values and their row-column memberships to ensure structurally valid correspondences without explicit permutation enumeration, (ii) incidence-guided refinement and upper-bound pruning that leverage row-column connectivity to eliminate infeasible partial matches early, and (iii) a tolerance-based optimization mechanism with a tunable parameter that relaxes pruning by a bounded margin to accelerate convergence, enabling scalable yet accurate overlap discovery. Experiments on real-world datasets show that HyperSplit discovers overlaps more effectively (larger overlaps in up to 78.8% of the cases) and more efficiently than state of the art. Three case studies further demonstrate its practical impact across three tasks: cross-source copy detection, data deduplication, and version comparison.