Title: Using rule mining modules combined with automatic rule derivation on semantic query optimisation

Authors: Ayla Sayli, Armagan Elibol

Addresses: Mathematical Engineering Department, Yildiz Technical University, Davutpasa Campus, 34210 Esenler, Istanbul, Turkey. ' Mathematical Engineering Department, Yildiz Technical University, Davutpasa Campus, 34210 Esenler, Istanbul, Turkey

Abstract: Semantic Query Optimisation (SQO) is a considerably new approach to query optimisation, compared to the approaches used by the commercial databases. It takes the original query into its optimiser and analyses it by the use of automatically derived rules. From the answer and condition(s) of this query, the new rule(s) may be learned. The approach yields considerable time savings on query optimisation, especially when the query answer can be found from the rules. A main concern is that automatic rule derivation requires a long time in the SQO approach because of the database connection and its retrievals. To solve this problem, we apply mathematic logic to determine where a transition (from one rule to another) exists, and from here produce new rules. In this paper, two rule-mining modules useful in the SQO approach are Rule Transition and |If and only If|. Computational results of the modules are very promising for learning new rules, and these rules improve the query executions.

Keywords: rule mining; rule transition; rule derivation; semantic query optimisation; SQO; databases; query representation; rule maintenance.

DOI: 10.1504/IJTPM.2005.008635

International Journal of Technology, Policy and Management, 2005 Vol.5 No.4, pp.348 - 360

Published online: 12 Jan 2006 *

Full-text access for editors Full-text access for subscribers Purchase this article Comment on this article