Title: A bottom-up algorithm for query decomposition

Authors: Thi Thu Thuy Le, Dai Duong Doan, Virendrakumar C. Bhavsar, Harold Boley

Addresses: University of New Brunswick, Fredericton, New Brunswick, Canada. ' University of New Brunswick, Fredericton, New Brunswick, Canada. ' University of New Brunswick, Fredericton, New Brunswick, Canada. ' Institute for Information Technology -e-Business, NRC, Fredericton, New Brunswick, Canada

Abstract: In order to access data from various data repositories, in Global-As-View approaches an input query is decomposed into several subqueries. Normally, this decomposition is based on a set of mappings, which describe the correspondence of data elements between a global schema and local ones. However, building mappings is a difficult task, especially when the number of participating local schemas is large. In our approach, an input query is automatically decomposed into subqueries without using mappings. An algorithm is proposed to transform a global path expression (e.g. an XPath query) into local path expressions executable in local schemas. This algorithm considers parts of a path expression from right to left, that is, the algorithm traverses from the bottom to the top of a schema tree depending on the structure of local schemas. Compared to top-down approaches, such as by Lausen and Marron, our algorithm can reduce the time for forming subqueries for local (e.g. XML) schemas to a large extent.

Keywords: query decomposition; bottom-up strategy; database integration; data retrieval; input queries.

DOI: 10.1504/IJICA.2008.019686

International Journal of Innovative Computing and Applications, 2008 Vol.1 No.3, pp.185 - 193

Published online: 20 Jul 2008 *

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