Survive the Schema Changes: Integration of Unmanaged Data Using Deep Learning

10/15/2020
by   Zijie Wang, et al.
0

Data is the king in the age of AI. However data integration is often a laborious task that is hard to automate. Schema change is one significant obstacle to the automation of the end-to-end data integration process. Although there exist mechanisms such as query discovery and schema modification language to handle the problem, these approaches can only work with the assumption that the schema is maintained by a database. However, we observe diversified schema changes in heterogeneous data and open data, most of which has no schema defined. In this work, we propose to use deep learning to automatically deal with schema changes through a super cell representation and automatic injection of perturbations to the training data to make the model robust to schema changes. Our experimental results demonstrate that our proposed approach is effective for two real-world data integration scenarios: coronavirus data integration, and machine log integration.

READ FULL TEXT
research
07/20/2021

Information Integration using the Typed Graph Model

Schema and data integration have been a challenge for more than 40 years...
research
09/20/2023

Live Local Schema Change: Challenge Problems

Schema change is an unsolved problem in both live programming and local-...
research
06/08/2022

Towards Schema Inference for Data Lakes

A data lake is a repository of data with potential for future analysis. ...
research
03/08/2022

It's AI Match: A Two-Step Approach for Schema Matching Using Embeddings

Since data is often stored in different sources, it needs to be integrat...
research
08/26/2020

Automatic Integration Issues of Tabular Data for On-Line Analysis Processing

Companies and individuals produce numerous tabular data. The objective o...
research
01/27/2021

Alaska: A Flexible Benchmark for Data Integration Tasks

Data integration is a long-standing interest of the data management comm...
research
09/09/2009

Interactive Data Integration through Smart Copy & Paste

In many scenarios, such as emergency response or ad hoc collaboration, i...

Please sign up or login with your details

Forgot password? Click here to reset