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 …

On approximation measures for functional dependencies

C Giannella, E Robertson - Information Systems, 2004 - Elsevier
We examine the issue of how to measure the degree to which a functional dependency (FD)
is approximate. The primary motivation lies in the fact that approximate FDs represent …

The complexity of dependency detection and discovery in relational databases

T Bläsius, T Friedrich, M Schirneck - Theoretical Computer Science, 2022 - Elsevier
Multi-column dependencies in relational databases come associated with two different
computational tasks. The detection problem is to decide whether a dependency of a certain …

HLS: Tunable mining of approximate functional dependencies

JT Engle, EL Robertson - British National Conference on Databases, 2008 - Springer
This paper examines algorithmic aspects of searching for approximate functional
dependencies in a database relation. The goal is to avoid exploration of large parts of the …

Discovering branching and fractional dependencies in databases

T Georgieva - Data & Knowledge Engineering, 2008 - Elsevier
The discovery of dependencies between attributes in databases is an important problem in
data mining, and can be applied to facilitate future decision-making. In the present paper …

Unsupervised database optimization: efficient index selection & data dependency-driven query optimization

J Koßmann - 2023 - publishup.uni-potsdam.de
The amount of data stored in databases and the complexity of database workloads are ever-
increasing. Database management systems (DBMSs) offer many configuration options, such …

A note on approximation measures for multi-valued dependencies in relational databases

C Giannella, E Robertson - Information processing letters, 2003 - Elsevier
We consider the problem of defining a normalized approximation measure for multi-valued
dependencies in relational database theory. An approximation measure is a function …

Depth first algorithms and inferencing for afd mining

JT Engle, EL Robertson - Proceedings of the 2009 International …, 2009 - dl.acm.org
The task of searching a powerset lattice is part of many problem domains. In Approximate
Functional Dependencies (AFDs) mining the algorithm used for searching lattices has been …

[PDF][PDF] Modularizing data mining: A case study framework

JT Engle, EL Robertson - 2009 - legacy.cs.indiana.edu
This paper presents the fundamental concepts underpinning MoLS, a framework for
exploring and applying many variations of algorithms for one datamining problem: mining a …

[图书][B] Architectural support for database visualization

DP Groth - 2002 - search.proquest.com
The rapid proliferation and growth of database management systems has resulted in the
retention of massive amounts of information for data processing and analysis needs. Many …