Answering constraint-based mining queries on itemsets using previous materialized results

Authors: Esposito, Roberto¹; Meo, Rosa²; Botta, Marco³

Source: Journal of Intelligent Information Systems, Volume 26, Number 1, January 2006 , pp. 95-111(17)

Publisher: Springer

Buy & download fulltext article:

Price: $47.00 plus tax (Refund Policy)

Abstract:

In recent years, researchers have begun to study inductive databases, a new generation of databases for leveraging decision support applications. In this context, the user interacts with the DBMS using advanced, constraint-based languages for data mining where constraints have been specifically introduced to increase the relevance of the results and, at the same time, to reduce its volume. In this paper we study the problem of mining frequent itemsets using an inductive database. We propose a technique for query answering which consists in rewriting the query in terms of union and intersection of the result sets of other queries, previously executed and materialized. Unfortunately, the exploitation of past queries is not always applicable. We then present sufficient conditions for the optimization to apply and show that these conditions are strictly connected with the presence of functional dependencies between the attributes involved in the queries. We show some experiments on an initial prototype of an optimizer which demonstrates that this approach to query answering is viable and in many practical cases it drastically reduces the query execution time.

Keywords: Data mining; KDD; Query languages; Inductive databases; Genetic algorithm

Document Type: Research article

DOI: http://dx.doi.org/10.1007/s10844-006-5453-z

Affiliations: 1: Email: esposito@di.unito.it 2: Email: meo@di.unito.it 3: Email: botta@di.unito.it

Publication date: 2006-01-01