Skip to main content
SpringerLink
Log in

Rewriting Queries using Views

  • Conference paper
  • First Online:
Database and Expert Systems Applications (DEXA 1999)

Part of the book series: Lecture Notes in Computer Science ((LNCS,volume 1677))

Included in the following conference series:

  • 431 Accesses

Abstract

In this paper we consider the problem of answering queries using materialized views in the presence of negative goals. The solution is carried out by ‘inverting’ views and deriving both positive and negative knowledge. In order to derive negative knowledge we invert conjunctive views with negation into a set of (extended) views which may also have, in addition to negation-as-failure, a different form of negation called classical (or strong) negation. Finally, we analyze the problem of inferring knowledge from views based on relations with functional dependencies.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Log in via an institution
Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 84.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 109.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. Abiteboul S., Hull R., and V. Vianu, Foundations of Databases, Addison-Wesley, 1994.

    Google Scholar 

  2. Abiteboul S., Duschka O., Proc. PODS Symp., 1998.

    Google Scholar 

  3. Chaudhuri S., R. Krishnamurty, S. Potamianos, and K. Shim, Optimizing queries with materialized views. Proc. ICDE Conf., 1995, pp. 190–200.

    Google Scholar 

  4. Chekuri C., and A. Rajaraman, Conjunctive Query Containment Revisited. Proc. ICDT Conf., 1997, pp. 56–70.

    Google Scholar 

  5. Duschka O. M., and M. R. Genesereth, Answering Recursive Queries Using Views. Proc. PODS Symp., 1997, pp. 109–116.

    Google Scholar 

  6. Duschka O. M., Query Planning and Optimization in Information Integration. PhD dissertation, 1997.

    Google Scholar 

  7. Eiter T., G. Gottlob, and H. Mannila, Adding Disjunction to Datalog, Proc. PODS Symp., 1993, pp. 267–278.

    Google Scholar 

  8. Gelfond M., and V. Lifschitz, Logic Programming with Classical Negation. Proc. ICLP Conf., 1991, pp. 580–597.

    Google Scholar 

  9. Greco S., and D. Sacca’, Negative Logic Programming. Proc. NACLP Conf., 1991.

    Google Scholar 

  10. Kowalsky R., and F. Sadri, Logic Programming with Exceptions. Proc. ICLP Conf., 1991, pp. 598–613.

    Google Scholar 

  11. Levy A., A. Mendelzon, Y. Sagiv, and D. Srivastava, Answering Queries Using views. Proc. PODS Symp., 1995, pp. 95–104.

    Google Scholar 

  12. Levy A., A. Rajaraman, and J. Ullman, Answering Queries Using limited external processors. Proc. PODS Symp., 1996.

    Google Scholar 

  13. J. Lloyd, Foundation of Logic Programming, Second Edition, Spinger-Verlag, 1987.

    Google Scholar 

  14. Ramakrinshnan R., Y. Sagiv, J. Ullman, and M. Vardi, Proof-three transformations theorems and their applications. Proc. PODS Symp., 1989, pp. 172–181.

    Google Scholar 

  15. Shmueli O., Decidability and expressiveness aspects of logic queries. Proc. PODS Symp., 1987, pp. 237–249.

    Google Scholar 

  16. Qian X., Query folding. Proc. ICDE, 1996, pp. 48–55.

    Google Scholar 

  17. Ullman J.D., Principles of Database and Knowledge Base Systems, Computer Science Press, 1988.

    Google Scholar 

  18. Ullman J.D., Information integration using logical views. Proc. ICDT Conf., 1997.

    Google Scholar 

Download references

Author information

Authors and Affiliations

  1. DEIS, Università della Calabria, 87030, Rende, Italy

    Sergio Flesca & Sergio Greco

Authors
  1. Sergio Flesca
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Sergio Greco
    View author publications

    You can also search for this author in PubMed Google Scholar

Editor information

Editors and Affiliations

  1. Department of Computer Science, University of Liverpool, P.O. Box 147, Liverpool, L49 3BX, UK

    Trevor J.M. Bench-Capon

  2. Department of Systems and Computers, University of Florence, Via S. Marta, 3, I-50139, Florence, Italy

    Giovanni Soda

  3. IFS, Technical University of Vienna, Resselgasse 3, A-1040, Vienna, Austria

    A Min Tjoa

Rights and permissions

Reprints and permissions

Copyright information

© 1999 Springer-Verlag Berlin Heidelberg

About this paper

Cite this paper

Flesca, S., Greco, S. (1999). Rewriting Queries using Views. In: Bench-Capon, T.J., Soda, G., Tjoa, A.M. (eds) Database and Expert Systems Applications. DEXA 1999. Lecture Notes in Computer Science, vol 1677. Springer, Berlin, Heidelberg. https://doi.org/10.1007/3-540-48309-8_33

Download citation

  • DOI: https://doi.org/10.1007/3-540-48309-8_33

  • Published:

  • Publisher Name: Springer, Berlin, Heidelberg

  • Print ISBN: 978-3-540-66448-2

  • Online ISBN: 978-3-540-48309-0

  • eBook Packages: Springer Book Archive

Publish with us

Policies and ethics

Search

Navigation