Adaptive selection of materialized queries in a mediator for the integration of distributed information resources

  • Authors:
  • Kil Hong Joo;Won Suk Lee

  • Affiliations:
  • Department of Computer Science, Yonsei University, 134 Sedaemoongu Shinchondong, Seoul, Korea;Department of Computer Science, Yonsei University, 134 Sedaemoongu Shinchondong, Seoul, Korea

  • Venue:
  • High performance scientific and engineering computing
  • Year:
  • 2004

Quantified Score

Hi-index 0.00

Visualization

Abstract

A global query in a mediator system to integrate distributed information is transformed into a set of its sub-queries and each sub-query is the unit of evaluation in a remote server. Therefore, it is possible to speed up the execution of a global query if the previous results of frequently evaluated sub-queries are materialized in a mediator. Since the integration schema of a mediator can be incrementally modified and the evaluation frequency of a global query can also be continuously varied, query usage should be carefully monitored to determine the optimized set of materialized sub-queries. Furthermore, as the number of sub-queries increases, the optimization process itself may take too long, so that the optimized set identified by a long optimization process may become obsolete due to the recent change of query usage. This paper proposes the adaptive selection of materialized sub-queries such that available storage in a mediator can be highly utilized at any time. In order to differentiate the recent usage of a query from the past, the accumulated usage frequency of a query decays as time goes by. As a result, it is possible to change the set of materialized sub-queries adaptively according to the recent variation of query usage.