An Efficient Query Rewriting Technique Utilizing Semantic Information and Materialized Views 


Vol. 10,  No. 4, pp. 661-670, Aug.  2003
10.3745/KIPSTD.2003.10.4.661


PDF
  Abstract

Materialized views which are stored views of the database offer opportunities for significant performance gain in query evaluation by providing fast access to pre-computed data. The question of when and how to use a materialized view in processing a given query is a difficult one attracting a significant amount of research. Whether a materialized view can be used in answering a query depends on the relationship between the view and the query. Proposed in this paper are new ways of utilizing materialized views in answering a query. Semantic relationships are used in addition to syntactic ones. We also utilize a materialized view in answering a query even if it has relations unrelated to the query. We first show the conditions for testing whether a materialized view can be utilized in answering a query and then present the algorithms for testing the conditions and reformulating a query with a materialized view.

  Statistics


  Cite this article

[IEEE Style]

J. J. Yeong, "An Efficient Query Rewriting Technique Utilizing Semantic Information and Materialized Views," The KIPS Transactions:PartD, vol. 10, no. 4, pp. 661-670, 2003. DOI: 10.3745/KIPSTD.2003.10.4.661.

[ACM Style]

Jang Jae Yeong. 2003. An Efficient Query Rewriting Technique Utilizing Semantic Information and Materialized Views. The KIPS Transactions:PartD, 10, 4, (2003), 661-670. DOI: 10.3745/KIPSTD.2003.10.4.661.