On Embeddings in Relational Databases

05/13/2020
by   Siddhant Arora, et al.
0

We address the problem of learning a distributed representation of entities in a relational database using a low-dimensional embedding. Low-dimensional embeddings aim to encapsulate a concise vector representation for an underlying dataset with minimum loss of information. Embeddings across entities in a relational database have been less explored due to the intricate data relations and representation complexity involved. Relational databases are an inter-weaved collection of relations that not only model relationships between entities but also record complex domain-specific quantitative and temporal attributes of data defining complex relationships among entities. Recent methods for learning an embedding constitute of a naive approach to consider complete denormalization of the database by materializing the full join of all tables and representing as a knowledge graph. This popular approach has certain limitations as it fails to capture the inter-row relationships and additional semantics encoded in the relational databases. In this paper we demonstrate; a better methodology for learning representations by exploiting the underlying semantics of columns in a table while using the relation joins and the latent inter-row relationships. Empirical results over a real-world database with evaluations on similarity join and table completion tasks support our proposition.

READ FULL TEXT

page 1

page 2

page 3

page 4

research
04/30/2021

BERT Meets Relational DB: Contextual Representations of Relational Databases

In this paper, we address the problem of learning low dimension represen...
research
11/14/2022

Row Conditional-TGAN for generating synthetic relational databases

Besides reproducing tabular data properties of standalone tables, synthe...
research
03/12/2019

Termite: A System for Tunneling Through Heterogeneous Data

Data-driven analysis is important in virtually every modern organization...
research
03/11/2021

Dynamic Database Embeddings with FoRWaRD

We study the problem of computing an embedding of the tuples of a relati...
research
03/23/2016

Enabling Cognitive Intelligence Queries in Relational Databases using Low-dimensional Word Embeddings

We apply distributed language embedding methods from Natural Language Pr...
research
05/24/2023

Towards Foundation Models for Relational Databases [Vision Paper]

Tabular representation learning has recently gained a lot of attention. ...
research
10/04/2017

A Comparative Analysis of Materialized Views Selection and Concurrency Control Mechanisms in NoSQL Databases

Increasing resource demands require relational databases to scale. While...

Please sign up or login with your details

Forgot password? Click here to reset