Cardinality estimation in dbms: A comprehensive benchmark evaluation

Y Han, Z Wu, P Wu, R Zhu, J Yang, LW Tan… - arXiv preprint arXiv …, 2021 - arxiv.org
Cardinality estimation (CardEst) plays a significant role in generating high-quality query
plans for a query optimizer in DBMS. In the last decade, an increasing number of advanced …

Parallel rule discovery from large datasets by sampling

W Fan, Z Han, Y Wang, M Xie - … of the 2022 international conference on …, 2022 - dl.acm.org
Rule discovery from large datasets is often prohibitively costly. The problem becomes more
staggering when the rules are collectively defined across multiple tables. To scale with large …

Answering (unions of) conjunctive queries using random access and random-order enumeration

N Carmeli, S Zeevi, C Berkholz, B Kimelfeld… - Proceedings of the 39th …, 2020 - dl.acm.org
As data analytics becomes more crucial to digital systems, so grows the importance of
characterizing the database queries that admit a more efficient evaluation. We consider the …

The relational data borg is learning

D Olteanu - arXiv preprint arXiv:2008.07864, 2020 - arxiv.org
This paper overviews an approach that addresses machine learning over relational data as
a database problem. This is justified by two observations. First, the input to the learning task …

gsword: Gpu-accelerated sampling for subgraph counting

C Ye, Y Li, S Sun, W Guo - Proceedings of the ACM on Management of …, 2024 - dl.acm.org
Subgraph counting is a fundamental component for many downstream applications such as
graph representation learning and query optimization. Since obtaining the exact count is …

Joins on samples: A theoretical guide for practitioners

D Huang, DY Yoon, S Pettie, B Mozafari - arXiv preprint arXiv:1912.03443, 2019 - arxiv.org
Despite decades of research on approximate query processing (AQP), our understanding of
sample-based joins has remained limited and, to some extent, even superficial. The …

Join ordering of SPARQL property path queries

J Aimonier-Davat, H Skaf-Molli, P Molli… - European Semantic …, 2023 - Springer
SPARQL property path queries provide a succinct way to write complex navigational queries
over RDF knowledge graphs. However, their evaluation remains difficult as they may involve …

Learning models over relational data: A brief tutorial

M Schleich, D Olteanu, M Abo-Khamis, HQ Ngo… - … Conference, SUM 2019 …, 2019 - Springer
This tutorial overviews the state of the art in learning models over relational databases and
makes the case for a first-principles approach that exploits recent developments in database …

Accurate Sampling-Based Cardinality Estimation for Complex Graph Queries

P Hu, B Motik - ACM Transactions on Database Systems, 2024 - dl.acm.org
Accurately estimating the cardinality (ie, the number of answers) of complex queries plays a
central role in database systems. This problem is particularly difficult in graph databases …

Online aggregation based approximate query processing: A literature survey

PS Akash, WC Lai, PW Lin - arXiv preprint arXiv:2204.07125, 2022 - arxiv.org
In the current world, OLAP (Online Analytical Processing) is used intensively by modern
organizations to perform ad hoc analysis of data, providing insight for better decision …