Towards mining frequent queries in star schemes

  • Authors:
  • Tao-Yuan Jen;Dominique Laurent;Nicolas Spyratos;Oumar Sy

  • Affiliations:
  • LICP, Université de Cergy-Pontoise, Cergy-Pontoise, France;LICP, Université de Cergy-Pontoise, Cergy-Pontoise, France;LRI, Orsay, France;LICP, Université de Cergy-Pontoise, Cergy-Pontoise, France

  • Venue:
  • KDID'05 Proceedings of the 4th international conference on Knowledge Discovery in Inductive Databases
  • Year:
  • 2005

Quantified Score

Hi-index 0.00

Visualization

Abstract

The problem of mining all frequent queries in a database is intractable, even if we consider conjunctive queries only. In this paper, we study this problem under reasonable restrictions on the database, namely: (i) the database scheme is a star scheme; (ii) the data in the database satisfies a set of functional dependencies and a set of referential constraints. We note that star schemes are considered to be the most appropriate schemes for data warehouses, while functional dependencies and referential constraints are the most common constraints that one encounters in real databases. Our approach is based on the weak instance semantics of databases and considers the class of selection-projection queries over weak instances. In such a context, we show that frequent queries can be mined using level-wise algorithms such as Apriori.