EVA: A symbolic approach to accelerating exploratory video analytics with materialized views
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 …
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
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 …
of picking both the physical query execution plans and the resources needed to run those …
Automatic view generation with deep learning and reinforcement learning
Materializing views is an important method to reduce redundant computations in DBMS,
especially for processing large scale analytical queries. However, many existing methods …
especially for processing large scale analytical queries. However, many existing methods …
Wetune: Automatic discovery and verification of query rewrite rules
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 …
one, which is crucial for the performance of database-backed applications. Such rewriting …
Automatic detection of performance bugs in database systems using equivalent queries
Because modern data-intensive applications rely heavily on database systems (DBMSs),
developers extensively test these systems to eliminate bugs that negatively affect …
developers extensively test these systems to eliminate bugs that negatively affect …
Proving query equivalence using linear integer arithmetic
Proving the equivalence between SQL queries is a fundamental problem in database
research. Existing solvers model queries using algebraic representations and convert such …
research. Existing solvers model queries using algebraic representations and convert such …
Predicate pushdown for data science pipelines
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 …
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 …
automated query equivalence checking sets the first steps in formally modeling and …
Lightweight Materialization for Fast Dashboards Over Joins
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 …
with an interface to access comprehensive business data. With the rise of cloud technology …
[PDF][PDF] Incremental Stream Query Merging.
ABSTRACT Stream Processing Engines (SPEs) execute long-running queries on
unbounded data streams. They mainly focus on achieving high throughput and low-latency …
unbounded data streams. They mainly focus on achieving high throughput and low-latency …