An Efficient Query Rewriting Technique Utilizing Semantic Information and Materialized Views


The KIPS Transactions:PartD, Vol. 10, No. 4, pp. 661-670, Aug. 2003
10.3745/KIPSTD.2003.10.4.661,   PDF Download:

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
Show / Hide Statistics

Statistics (Cumulative Counts from September 1st, 2017)
Multiple requests among the same browser session are counted as one view.
If you mouse over a chart, the values of data points will be shown.


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.