|
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
| |
|
DOI
|
|
|
|
10.1007/978-3-642-15105-7_12
| |
|
Volume/pages
|
|
|
|
p. 142-156
| |
|
ISI
|
|
|
|
000285524900012
| |
|
Full text (Publisher's DOI)
|
|
|
|
| |
|