Worst-case optimal join algorithms

HQ Ngo, E Porat, C Ré, A Rudra - Journal of the ACM (JACM), 2018 - dl.acm.org
Efficient join processing is one of the most fundamental and well-studied tasks in database
research. In this work, we examine algorithms for natural join queries over many relations …

Tractable circuits in database theory

A Amarilli, F Capelli - ACM SIGMOD Record, 2024 - dl.acm.org
This work reviews how database theory uses tractable circuit classes from knowledge
compilation. We present relevant query evaluation tasks, and notions of tractable circuits …

SPORES: sum-product optimization via relational equality saturation for large scale linear algebra

YR Wang, S Hutchison, J Leang, B Howe… - arXiv preprint arXiv …, 2020 - arxiv.org
Machine learning algorithms are commonly specified in linear algebra (LA). LA expressions
can be rewritten into more efficient forms, by taking advantage of input properties such as …

Query Evaluation under Differential Privacy

W Dong, K Yi - ACM SIGMOD Record, 2023 - dl.acm.org
Differential privacy has garnered significant attention in recent years due to its potential in
offering robust privacy protection for individual data during analysis. With the increasing …

The dynamic yannakakis algorithm: Compact and efficient query processing under updates

M Idris, M Ugarte, S Vansummeren - Proceedings of the 2017 ACM …, 2017 - dl.acm.org
Modern computing tasks such as real-time analytics require refresh of query results under
high update rates. Incremental View Maintenance (IVM) approaches this problem by …

Secure yannakakis: Join-aggregate queries over private data

Y Wang, K Yi - Proceedings of the 2021 International Conference on …, 2021 - dl.acm.org
In this paper, we describe a secure version of the classical Yannakakis algorithm for
computing free-connex join-aggregate queries. This protocol can be used in the secure two …

Residual sensitivity for differentially private multi-way joins

W Dong, K Yi - Proceedings of the 2021 International Conference on …, 2021 - dl.acm.org
A general-purpose query engine that supports a large class of SQLs under differential
privacy is the holy grail in privacy-preserving query release. The join operator presents a …

Joinboost: Grow trees over normalized data using only SQL

Z Huang, R Sen, J Liu, E Wu - arXiv preprint arXiv:2307.00422, 2023 - arxiv.org
Although dominant for tabular data, ML libraries that train tree models over normalized
databases (eg, LightGBM, XGBoost) require the data to be denormalized as a single table …

Fast Matrix Multiplication for Query Processing

X Hu - Proceedings of the ACM on Management of Data, 2024 - dl.acm.org
This paper studies how to use fast matrix multiplication to speed up query processing. As
observed, computing a two-table join and then projecting away the join attribute is …

Levelheaded: A unified engine for business intelligence and linear algebra querying

C Aberger, A Lamb, K Olukotun… - 2018 IEEE 34th …, 2018 - ieeexplore.ieee.org
Pipelines combining SQL-style business intelligence (BI) queries and linear algebra (LA)
are becoming increasingly common in industry. As a result, there is a growing need to unify …