EVA: A symbolic approach to accelerating exploratory video analytics with materialized views

Z Xu, GT Kakkar, J Arulraj… - Proceedings of the 2022 …, 2022 - dl.acm.org
Advances in deep learning have led to a resurgence of interest in video analytics. In an
exploratory video analytics pipeline, a data scientist often starts by searching for a global …

Cost models for big data query processing: Learning, retrofitting, and our findings

T Siddiqui, A **dal, S Qiao, H Patel, W Le - Proceedings of the 2020 …, 2020 - dl.acm.org
Query processing over big data is ubiquitous in modern clouds, where the system takes care
of picking both the physical query execution plans and the resources needed to run those …

Automatic view generation with deep learning and reinforcement learning

H Yuan, G Li, L Feng, J Sun… - 2020 IEEE 36th …, 2020 - ieeexplore.ieee.org
Materializing views is an important method to reduce redundant computations in DBMS,
especially for processing large scale analytical queries. However, many existing methods …

Wetune: Automatic discovery and verification of query rewrite rules

Z Wang, Z Zhou, Y Yang, H Ding, G Hu, D Ding… - Proceedings of the …, 2022 - dl.acm.org
Query rewriting transforms a relational database query into an equivalent but more efficient
one, which is crucial for the performance of database-backed applications. Such rewriting …

Automatic detection of performance bugs in database systems using equivalent queries

X Liu, Q Zhou, J Arulraj, A Orso - … of the 44th International Conference on …, 2022 - dl.acm.org
Because modern data-intensive applications rely heavily on database systems (DBMSs),
developers extensively test these systems to eliminate bugs that negatively affect …

Proving query equivalence using linear integer arithmetic

H Ding, Z Wang, Y Yang, D Zhang, Z Xu… - Proceedings of the …, 2023 - dl.acm.org
Proving the equivalence between SQL queries is a fundamental problem in database
research. Existing solvers model queries using algebraic representations and convert such …

Predicate pushdown for data science pipelines

C Yan, Y Lin, Y He - Proceedings of the ACM on Management of Data, 2023 - dl.acm.org
Predicate pushdown is a widely adopted query optimization. Existing systems and prior work
mostly use pattern-matching rules to decide when a predicate can be pushed through …

QED: A Powerful Query Equivalence Decider for SQL

S Wang, S Pan, A Cheung - Proceedings of the VLDB Endowment, 2024 - dl.acm.org
Checking query equivalence is of great significance in database systems. Prior work in
automated query equivalence checking sets the first steps in formally modeling and …

Lightweight Materialization for Fast Dashboards Over Joins

Z Huang, E Wu - Proceedings of the ACM on Management of Data, 2023 - dl.acm.org
Dashboards are vital in modern business intelligence tools, providing non-technical users
with an interface to access comprehensive business data. With the rise of cloud technology …

[PDF][PDF] Incremental Stream Query Merging.

A Chaudhary, S Zeuch, V Markl, J Karimov - EDBT, 2023 - openproceedings.org
ABSTRACT Stream Processing Engines (SPEs) execute long-running queries on
unbounded data streams. They mainly focus on achieving high throughput and low-latency …