
5 CONCLUSIONS
In previous bucket-based rewriting algorithms, for a
given query Q, view selection is done by unifying Q
with the definition of views. In other words, the
meaning of “relevant to Q” is in terms of unification.
We found that there is another explanation about
“relevant to Q”, i.e., in the presence of domain
semantics. That is, we can remove the irrelevant
views which could not be found in any bucket-based
algorithm. Also, in some cases, we can avoid the
problem of missing relevant views, which occurs in
bucket-based algorithms.
In this paper, we have aimed to solve the
problems of missing query rewritings and redundant
query rewritings in bucket-based rewriting
algorithms so that we can improve the soundness
and completeness of these algorithms. In the
presence of domain semantics in a mediated schema,
we first compute the pseudo residue for each
constraint over the views using the resolution
method. In fact, what we have done is to transfer the
integrity constraints over the relations of the
mediated schema into a rule over a view. As a result,
for a given query, we can determine which view is
irrelevant to the query, in the presence of domain
semantics, by making a comparison between the
pseudo residue of a view and the comparison
expression of the query. The pseudo residues can be
calculated in advanced, which means that the total
increased computation in Step 1 in our algorithm is
only in polynomial size of |D|*|V|, where |D| and |V|
are the number of domain semantics in a mediated
schema and of the views respectively. This process
is useful for query rewriting, which has been shown
by examples in Section 1.
REFERENCES
Arens, Y., Knoblock, C.A., Shen, W., 1996. Query
Reformulation for Dynamic Information Integration.
In Journal of Intelligent Information Systems, Special
Issue on Intelligent Information Integration, 6(2/3):99-
-130.
Cali, A., Calvanese, D., Giacomo, G. D., Lenzerini, M.,
2002. On the Role of Integrity Constraints in Data
Integration. In IEEE Data Engineering Bulletin, 25(3),
Special Issue on Organizing and Discovering the
Semantic Web, 39-45.
Chakravarthy, U.S., Grant, J., Minker, J., 1990. Logic
based approach to semantic query optimization. In
ACM Transactions on Database Systems, 15(2): 162-
207.
Chaudhuri, S., Krishnamurthy, R., Potamianos, S., Shim,
K., 1995. Optimizing Queries with Materialized
Views. In Proceeding of the 11th International
Conference on Data Engineering, IEEE Computer
Soc. Press, 190-200.
Duschka, O.M., Genesereth, M.R., Levy, A.Y., 2000.
Recursive Query Plans for Data Integration. In
Journal of Logic Programming, special issue on Logic
Based Heterogeneous Information Systems, 43(1), 49-
73.
Florescu, D., Raschid, L., Valduriez, P., 1996. Query
Reformulation in Multidatabase Systems using
Semantic Knowledge. In International Journal of
Cooperative Information Systems, 5(1996), 431-468.
Fagin, R., Vardi, M.Y.,1986. The Theory of Data
Dependencies—A Survey. In Proceedings of
Symposia in Applied Mathematics, Volume 34, 19-71.
Godfrey, P., Grant, J., Gryz, J., Minker, J., 1998. Integrity
Constraints: Semantics and Applications. In Chapter 9
of Logics for Databases and Information Systems,
J.Chomicki and G.Saake, editors, Kluwer Press, 265-
306.
Grant, J., Minker., J., 2002. A logic-based approach to
data integration. In TLP, 2(3):323-368.
Gryz, J., 1998. An Algorithm for Query Folding with
Functional Dependencies. In Proceedings of the 7th
International Symposium on Intelligent Information
Systems , 7-16.
Gryz, J., 1999. Query rewriting using views in the
presence of functional and inclusion dependencies. In
Information System, 24(7):597-612.
Hsu, C., Knoblock, C.A., 2000. Semantic Query
Optimization for Query Plans of Heterogeneous
Multidatabase Systems. In IEEE Transactions on
Knowledge and Data Engineering, 12(6):959--978.
Levy, A.Y., 2001. Answering Queries Using Views: A
Survey. In VLDB Journal, 10(4), 270-294.
Levy, A.Y., Rajaraman, A., Ordille, J.J., 1996a. Querying
Heterogeneous Information Sources Using Source
Descriptions. In Proceedings of the 22nd VLDB
Conference, 251--262.
Levy, A.Y., Rajaraman, A., Ordille, J.J., 1996b. Query-
Answering Algorithms for Information Agents. In
Proceedings of the Thirteenth National Conference on
Artificial Intelligence and the Eighth Innovative
Applications of Artificial Intelligence Conference,
AAAI Press / MIT Press, 40--47.
Mitra, P., 2001. An Algorithm for Answering Queries
Efficiently Using Views. In Proceedings of the 12th
Australasian Database Conference, 99-106.
Pottinger, R., Levy, A.Y., 2000. A Scalable Algorithm for
Answering Queries Using Views. In Proceedings of
the International Conference on Very Large Data
Bases(VLDB), 484-495.
Qian, X., 1996. Query folding. In Proceedings of the 12th
IEEE International Conference on Data Engineering
(ICDE’96), 48-55.
IMPROVING VIEW SELECTION IN QUERY REWRITING USING DOMAIN SEMANTICS
183