ReStore – Neural Data Completion for Relational Databases

05/26/2021
by   Benjamin Hilprecht, et al.
0

Classical approaches for OLAP assume that the data of all tables is complete. However, in case of incomplete tables with missing tuples, classical approaches fail since the result of a SQL aggregate query might significantly differ from the results computed on the full dataset. Today, the only way to deal with missing data is to manually complete the dataset which causes not only high efforts but also requires good statistical skills to determine when a dataset is actually complete. In this paper, we propose an automated approach for relational data completion called ReStore using a new class of (neural) schema-structured completion models that are able to synthesize data which resembles the missing tuples. As we show in our evaluation, this efficiently helps to reduce the relative error of aggregate queries by up to 390 real-world data compared to using the incomplete data directly for query answering.

READ FULL TEXT

page 1

page 2

page 3

page 4

research
04/26/2023

Towards Multi-Modal DBMSs for Seamless Querying of Texts and Tables

In this paper, we propose Multi-Modal Databases (MMDBs), which is a new ...
research
02/08/2018

SQL Query Completion for Data Exploration

Within the big data tsunami, relational databases and SQL are still ther...
research
10/02/2022

Towards a Complete Direct Mapping From Relational Databases To Property Graphs

It is increasingly common to find complex data represented through the g...
research
06/30/2009

Query Significance in Databases via Randomizations

Many sorts of structured data are commonly stored in a multi-relational ...
research
04/08/2020

Fast and Reliable Missing Data Contingency Analysis with Predicate-Constraints

Today, data analysts largely rely on intuition to determine whether miss...
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
08/10/2017

Contextuality from missing and versioned data

Traditionally categorical data analysis (e.g. generalized linear models)...

Please sign up or login with your details

Forgot password? Click here to reset