Table Dissolution: Adding Salt To Your Data

Corporations continually generate and receive new tabular data whose integration into existing systems is crucial to maximizing business value. However, this integration is challenging due to data heterogeneity and lack of standard formats. Current methods focus on identifying relationships between table pairs, often neglecting table-to-database scenarios. Conventional schema matching techniques map columns between relational schemas but overlook subtables that could better align with database elements, limiting their effectiveness. We introduce the task of table dissolution: the identification of queries to integrate new tabular data into databases via coherent and semantically meaningful views on the new data. This process allows a fine-grained integration where new data dissolves into a database as salt dissolves into water.