Advertisement

Answering Queries Using Views in the Presence of Functional Dependencies

  • Jun Hong
  • Weiru Liu
  • David Bell
  • Qingyuan Bai
Conference paper
Part of the Lecture Notes in Computer Science book series (LNCS, volume 3567)

Abstract

This paper is concerned with the problem of answering queries using views in the presence of functional dependencies. Previous algorithms for answering queries using views, such as the MiniCon algorithm, have not taken into account the presence of functional dependencies. As a consequence, these algorithms may miss query rewritings in the presence of such dependencies. In this paper, we present an extension of the MiniCon algorithm to handle the presence of functional dependencies while still retaining the main properties of the algorithm and its computational advantage over the other algorithms.

Keywords

Functional Dependency Degree Program Partial Mapping Distinguished Variable User Query 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. 1.
    Levy, A.Y., Rajaraman, A., Ordille, J.J.: Querying heterogeneous information sources using source descriptions. In: VLDB, pp. 251–262 (1996)Google Scholar
  2. 2.
    Duschka, O.M., Genesereth, M.R.: Query planning in informaster. In: Proc. of the ACM Symposium on Applied Computing, pp. 109–111 (1997)Google Scholar
  3. 3.
    Kwok, C.T., Weld, D.S.: Planning to gather information. In: AAAI., pp. 32–39 (1996)Google Scholar
  4. 4.
    Lambrecht, E., Kambhampati, S., Gnanaprakasam, S.: Optimizing recursive information gathering plans. In: IJCAI, pp. 1204–1211 (1999)Google Scholar
  5. 5.
    Pottinger, R., Halevy, A.: Minicon: A scalable algorithm for answering queries using views. VLDB Journal 10, 182–198 (2001)zbMATHGoogle Scholar
  6. 6.
    Halevy, A.: Answering queries using views: a survey. VLDB Journal 10, 270–294 (2001)zbMATHCrossRefGoogle Scholar
  7. 7.
    Qian, X.: Query folding. In: ICDE, pp. 48–55 (1996)Google Scholar
  8. 8.
    Duschka, O.M., Genesereth, M.R.: Answering recursive queries using views. In: PODS, pp. 109–116 (1997)Google Scholar
  9. 9.
    Duschka, O.M., Levy, A.Y.: Recursive plans for information gathering. In: IJCAI, pp. 778–784 (1997)Google Scholar
  10. 10.
    Duschka, O.M., Genesereth, M.R., Levy, A.Y.: Recursive query plans for data integration. Journal of Logic Programming 43, 49–73 (2000)zbMATHCrossRefMathSciNetGoogle Scholar
  11. 11.
    Gryz, J.: Query rewriting using views in the presence of functional and inclusion dependencies. Information Systems 24, 597–612 (1999)zbMATHCrossRefGoogle Scholar
  12. 12.
    Yang, H.Z., Larson, P.A.: Query transformation for psj-queries. In: VLDB, pp. 245–254 (1987)Google Scholar
  13. 13.
    Afrati, F.N., Li, C., Mitra, P.: Answering queries using views with arithmetic comparisons. In: PODS, pp. 209–220 (2002)Google Scholar
  14. 14.
    Duschka, O.M., Genesereth, M.R.: Query planning with disjunctive sources. In: Proc. of AAAI Workshop on AI and Information Integration (1998)Google Scholar
  15. 15.
    Flesca, S., Greco, S.: Rewriting queries using views. IEEE Transactions on Knowledge and Data Engineering 13, 980–995 (2001)CrossRefGoogle Scholar
  16. 16.
    Gupta, A., Harinarayan, V., Quass, D.: Aggregate-query processing in data warehousing environments. In: VLDB, pp. 358–369 (1995)Google Scholar
  17. 17.
    Srivastava, D., Dar, S., Jagadish, H.V., Levy, A.Y.: Answering sql queries using materilized views. In: VLDB, pp. 318–329 (1996)Google Scholar
  18. 18.
    Papakonstantinou, Y., Vassalos, V.: Query rewriting for semi-structured data. In: SIGMOD, pp. 455–466 (1999)Google Scholar
  19. 19.
    Calvanese, D., Giacomo, G.D., Lenzerini, M., Vardi, M.: Rewriting of regular expressions and regular path queries. In: PODS, pp. 194–204 (1999)Google Scholar
  20. 20.
    Florescu, D., Raschid, L., Valduriez, P.: A methodology for query reformulation in cis using semantic knowledge. International Journal of Intelligent and Cooperative Information Systems 5, 431–468 (1996)CrossRefGoogle Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 2005

Authors and Affiliations

  • Jun Hong
    • 1
  • Weiru Liu
    • 1
  • David Bell
    • 1
  • Qingyuan Bai
    • 2
  1. 1.School of Computer ScienceQueen’s University BelfastBelfastUK
  2. 2.School of Computing and MathematicsUniversity of UlsterNewtownabbey, Co. AntrimUK

Personalised recommendations