[PDF][PDF] LEO-DB2's learning optimizer

M Stillger, GM Lohman, V Markl, M Kandil - VLDB, 2001 - vldb.org
Most modern DBMS optimizers rely upon a cost model to choose the best query execution
plan (QEP) for any given query. Cost estimates are heavily dependent upon the optimizer's …

[КНИГА][B] Quality-driven query answering for integrated information systems

F Naumann - 2002 - Springer
8 Completeness-Driven Query Optimization Page 1 8 Completeness-Driven Query
Optimization Completeness measures the usefulness of a source or of a plan to answer a …

Robust query processing through progressive optimization

V Markl, V Raman, D Simmen, G Lohman… - Proceedings of the …, 2004 - dl.acm.org
Virtually every commercial query optimizer chooses the best plan for a query using a cost
model that relies heavily on accurate cardinality estimation. Cardinality estimation errors can …

Quicksel: Quick selectivity learning with mixture models

Y Park, S Zhong, B Mozafari - Proceedings of the 2020 ACM SIGMOD …, 2020 - dl.acm.org
Estimating the selectivity of a query is a key step in almost any cost-based query optimizer.
Most of today's databases rely on histograms or samples that are periodically refreshed by …

Estimating join selectivities using bandwidth-optimized kernel density models

M Kiefer, M Heimel, S Breß, V Markl - Proceedings of the VLDB …, 2017 - dl.acm.org
Accurately predicting the cardinality of intermediate plan operations is an essential part of
any modern relational query optimizer. The accuracy of said estimates has a strong and …

Completeness of integrated information sources

F Naumann, JC Freytag, U Leser - Information Systems, 2004 - Elsevier
For many information domains there are numerous World Wide Web data sources. The
sources vary both in their extension and their intension: They represent different real-world …

Learning from empirical results in query optimization

GM Lohman, M Stillger, V Markl - US Patent 6,763,359, 2004 - Google Patents
An optimizer function of a Relational Database Manage ment System (RDBMS) generates
alternative query execu tion plans (QEPs) for executing a query, provides an execu tion …

LEO: An autonomic query optimizer for DB2

V Markl, GM Lohman, V Raman - IBM Systems Journal, 2003 - ieeexplore.ieee.org
SQL has emerged as an industry standard for querying relational database management
systems, largely because a user need only specify what data is wanted, not the details of …

[КНИГА][B] Datenbanksysteme: Konzepte und Techniken der Implementierung

T Härder, E Rahm - 2013 - books.google.com
Datenbanksysteme gehören zu den wichtigsten Produkten der Software-Industrie; kaum
eine größere Informatikanwendung ist ohne Datenbankunterstützung denkbar. Ausgehend …

Parallel discrepancy detection and incremental detection

W Fan, C Tian, Y Wang, Q Yin - Proceedings of the VLDB Endowment, 2021 - dl.acm.org
This paper studies how to catch duplicates, mismatches and conflicts in the same process.
We adopt a class of entity enhancing rules that embed machine learning predicates, unify …