[PDF][PDF] Estimating filtered group-by queries is hard: Deep learning to the rescue

A Kipf, M Freitag, D Vorona, P Boncz… - … Workshop on Applied …, 2019 - db.in.tum.de
While estimating the result size of a group-by operation on a base table is hard on its own,
the presence of selections makes this problem increasingly difficult to solve. We show that …

Automatic Database Index Tuning: A Survey

Y Wu, X Zhou, Y Zhang, G Li - IEEE Transactions on …, 2024 - ieeexplore.ieee.org
Index tuning plays a crucial role in facilitating the efficiency of data retrieval within database
systems, which adjusts index settings to optimize the database performance. Recently, with …

DITune: A Reinforcement Learning Based Framework for Automated Database Index Selection

X Huang, X Gao, G Chen - 2024 18th International Conference …, 2024 - ieeexplore.ieee.org
Index selection is a crucial and essential aspect of database management systems (DBMS)
aiming to optimize performance, and it is also one of the most time-consuming and laborious …

A Sampling-based Learning Framework for Big Databases

J Zhang, S Wu, J Zhao, Z Xie, F Li, Y Gao… - Proceedings of the ACM …, 2022 - dl.acm.org
The autonomous database of the next generation aims to apply the reinforcement learning
(RL) on tasks like query optimization and performance tuning with little or no human DBAs' …

Synopses for Efficient and Reliable Approximate Query Processing

X Liang - 2022 - search.proquest.com
Answering queries accurately at interactive speeds has become more challenging in
modern data systems due to the massive growth of data. Such challenges lead to an …

On Enabling Efficient and Scalable Processing of Semi-Structured Data

N Schäfer - 2023 - kluedo.ub.rptu.de
Semi-structured data is a common data format in many domains. It is characterized by a
hierarchical structure and a schema that is not fixed. Efficient and scalable processing of this …

[PDF][PDF] Automatic Index Tuning: A Survey

Y Wu, X Zhou, Y Zhang, G Li - dbgroup.cs.tsinghua.edu.cn
Index tuning plays a crucial role in facilitating the efficiency of data retrieval within database
systems, which adjusts index settings to optimize the database performance. Recently, with …

Advancing Analytical Database Systems

AM Kipf - 2020 - mediatum.ub.tum.de
This thesis contributes to the state of the art in analytical database systems. First, we identify
and explore extensions to better support analytics on event streams. Second, we propose a …

Deep Learning Data and Indexes in a Database

V Sharma - 2021 - search.proquest.com
A database is used to store and retrieve data, which is a critical component for any software
application. Databases require configuration for efficiency, however, there are tens of …

[PDF][PDF] Spatial Database Cracking with Quadtrees

E Leal, L Gruenwald - cs.ou.edu
Many scientific disciplines that make extensive use of spatial data, like weather, urban
planning and smart cities, deal with Big Spatial Data because, among other things, they …