Data dependencies for query optimization: a survey

J Kossmann, T Papenbrock, F Naumann - The VLDB Journal, 2022 - Springer
Effective query optimization is a core feature of any database management system. While
most query optimization techniques make use of simple metadata, such as cardinalities and …

Invisible glue: scalable self-tuning multi-stores

F Bugiotti, D Bursztyn, A Deutsch, I Ileana… - … on innovative data …, 2015 - inria.hal.science
Next-generation data centric applications often involve di-verse datasets, some very large
while others may be of mod-erate size, some highly structured (eg, relations) while others …

Possible and certain keys for SQL

H Köhler, U Leck, S Link, X Zhou - The VLDB Journal, 2016 - Springer
Driven by the dominance of the relational model and the requirements of modern
applications, we revisit the fundamental notion of a key in relational databases with NULL. In …

Towards scalable hybrid stores: Constraint-based rewriting to the rescue

R Alotaibi, D Bursztyn, A Deutsch, I Manolescu… - Proceedings of the …, 2019 - dl.acm.org
Big data applications routinely involve diverse datasets: relations flat or nested, complex-
structure graphs, documents, poorly structured logs, or even text data. To handle the data …

Querying with access patterns and integrity constraints

M Benedikt, J Leblay, E Tsamoura - Proceedings of the VLDB …, 2015 - dl.acm.org
Traditional query processing involves a search for plans formed by applying algebraic
operators on top of primitives representing access to relations in the input query. But many …

Possible and certain SQL keys

H Köhler, S Link, X Zhou - Proceedings of the VLDB Endowment, 2015 - dl.acm.org
Driven by the dominance of the relational model, the requirements of modern applications,
and the veracity of data, we revisit the fundamental notion of a key in relational databases …

ESTOCADA: towards scalable polystore systems

R Alotaibi, B Cautis, A Deutsch, M Latrache… - Proceedings of the …, 2020 - dl.acm.org
Big data applications increasingly involve diverse datasets, conforming to different data
models. Such datasets are routinely hosted in heterogeneous stores, each capable of …

ProSA—using the CHASE for provenance management

T Auge, A Heuer - Advances in Databases and Information Systems: 23rd …, 2019 - Springer
Collecting, storing, tracking, and archiving scientific data is the main task of research data
management, being the basis for scientific evaluations. In addition to the evaluation (a …

Answering queries using views

F Afrati, R Chirkova - Answering Queries Using Views, Second Edition, 2019 - Springer
Answering 2ueries Using Views Page 1 173 CHAPTER 7 Answering 2ueries Using Views he
problem of answering queries using views suggests several theoretical questions. In this …

Probabilistic keys

P Brown, S Link - IEEE Transactions on Knowledge and Data …, 2016 - ieeexplore.ieee.org
Probabilistic databases address well the requirements of an increasing number of modern
applications that produce large volumes of uncertain data from a variety of sources …