Termite: a system for tunneling through heterogeneous data

© 2019 ACM. Data-driven analysis is important in virtually every modern organization. Yet, most data is underutilized because it remains locked in silos inside of organizations; large organizations have thousands of databases, and billions of files that are not integrated together in a single, query...

Full description

Bibliographic Details
Main Authors: Fernandez, Raul Castro (Author), Madden, Samuel (Author)
Format: Article
Language:English
Published: Association for Computing Machinery (ACM), 2021-11-05T15:21:26Z.
Subjects:
Online Access:Get fulltext
LEADER 02021 am a22001693u 4500
001 137523
042 |a dc 
100 1 0 |a Fernandez, Raul Castro  |e author 
700 1 0 |a Madden, Samuel  |e author 
245 0 0 |a Termite: a system for tunneling through heterogeneous data 
260 |b Association for Computing Machinery (ACM),   |c 2021-11-05T15:21:26Z. 
856 |z Get fulltext  |u https://hdl.handle.net/1721.1/137523 
520 |a © 2019 ACM. Data-driven analysis is important in virtually every modern organization. Yet, most data is underutilized because it remains locked in silos inside of organizations; large organizations have thousands of databases, and billions of files that are not integrated together in a single, queryable repository. Despite 40+ years of continuous effort by the database community, data integration still remains an open challenge. In this paper, we advocate a different approach: rather than trying to infer a common schema, we aim to find another common representation for diverse, heterogeneous data. Specifically, we argue for an embedding (i.e., a vector space) in which all entities, rows, columns, and paragraphs are represented as points. In the embedding, the distance between points indicates their degree of relatedness. We present Termite, a prototype we have built to learn the best embedding from the data. Because the best representation is learned, this allows Termite to avoid much of the human effort associated with traditional data integration tasks. On top of Termite, we have implemented a Termite-Join operator, which allows people to identify related concepts, even when these are stored in databases with different schemas and in unstructured data such as text files, webpages, etc. Finally, we show preliminary evaluation results of our prototype via a user study, and describe a list of future directions we have identified. 
546 |a en 
655 7 |a Article 
773 |t 10.1145/3329859.3329877 
773 |t Proceedings of the ACM SIGMOD International Conference on Management of Data