DeepSPACE: Approximate Geospatial Query Processing with Deep Learning
Authors:
Dimitri Vorona,
Andreas Kipf,
Thomas Neumann,
Alfons Kemper
Abstract:
The amount of the available geospatial data grows at an ever faster pace. This leads to the constantly increasing demand for processing power and storage in order to provide data analysis in a timely manner. At the same time, a lot of geospatial processing is visual and exploratory in nature, thus having bounded precision requirements. We present DeepSPACE, a deep learning-based approximate geospa…
▽ More
The amount of the available geospatial data grows at an ever faster pace. This leads to the constantly increasing demand for processing power and storage in order to provide data analysis in a timely manner. At the same time, a lot of geospatial processing is visual and exploratory in nature, thus having bounded precision requirements. We present DeepSPACE, a deep learning-based approximate geospatial query processing engine which combines modest hardware requirements with the ability to answer flexible aggregation queries while kee** the required state to a few hundred KiBs.
△ Less
Submitted 14 June, 2019;
originally announced June 2019.
Estimating Cardinalities with Deep Sketches
Authors:
Andreas Kipf,
Dimitri Vorona,
Jonas Müller,
Thomas Kipf,
Bernhard Radke,
Viktor Leis,
Peter Boncz,
Thomas Neumann,
Alfons Kemper
Abstract:
We introduce Deep Sketches, which are compact models of databases that allow us to estimate the result sizes of SQL queries. Deep Sketches are powered by a new deep learning approach to cardinality estimation that can capture correlations between columns, even across tables. Our demonstration allows users to define such sketches on the TPC-H and IMDb datasets, monitor the training process, and run…
▽ More
We introduce Deep Sketches, which are compact models of databases that allow us to estimate the result sizes of SQL queries. Deep Sketches are powered by a new deep learning approach to cardinality estimation that can capture correlations between columns, even across tables. Our demonstration allows users to define such sketches on the TPC-H and IMDb datasets, monitor the training process, and run ad-hoc queries against trained sketches. We also estimate query cardinalities with HyPer and PostgreSQL to visualize the gains over traditional cardinality estimators.
△ Less
Submitted 17 April, 2019;
originally announced April 2019.