Publication
Title
Discovery and application of functional dependencies in conjunctive query mining
Author
Abstract
We present an algorithm for mining frequent queries in arbitrary relational databases, over which functional dependencies are assumed. Building upon previous results, we restrict to the simple, but appealing subclass of simple conjunctive queries. The proposed algorithm makes use of the functional dependencies of the database to optimise the generation of queries and prune redundant queries. Furthermore, our algorithm is capable of detecting previously unknown functional dependencies that hold on the database relations as well as on joins of relations. These detected dependencies are subsequently used to prune redundant queries. We propose an efficient database-oriented implementation of our algorithm using SQL, and provide several promising experimental results.
Language
English
Source (book)
Data Warehousing and Knowledge Discovery, Data Warehousing and Knowledge Discovery Data Warehousing and Knowledge Discovery 12th International Conference, DaWaK 2010, Bilbao, Spain, August 30 - September 2, 2010 / Mohania, Mukesh K. [edit.]
Publication
Berlin : Springer, 2010
ISBN
978-3-642-15104-0
Volume/pages
p. 142-156
ISI
000285524900012
Full text (Publisher's DOI)
UAntwerpen
Faculty/Department
Research group
Publication type
Subject
Affiliation
Publications with a UAntwerp address
External links
Web of Science
Record
Identification
Creation 31.03.2011
Last edited 04.11.2017
To cite this reference