Skip to main content

A Framework for Comparing Query Languages in Their Ability to Express Boolean Queries

  • Conference paper
  • First Online:
Foundations of Information and Knowledge Systems (FoIKS 2018)

Part of the book series: Lecture Notes in Computer Science ((LNISA,volume 10833))

Abstract

We identify three basic modalities for expressing boolean queries using the expressions of a query language: nonemptiness, emptiness, and containment. For the class of first-order queries, these three modalities have exactly the same expressive power. For other classes of queries, e.g., expressed in weaker query languages, the modalities may differ in expressiveness. We propose a framework for studying the expressive power of boolean query modalities. Along one dimension, one may work within a fixed query language and compare the three modalities, e.g., we can compare a fixed query language \(\mathcal {F}\) under emptiness to \(\mathcal {F}\) under nonemptiness. Here, we identify crucial query features that enable us to go from one modality to another. Furthermore, we identify semantical properties that reflect the lack of these query features to establish separations. Along a second dimension, one may fix a modality and compare different query languages. This second dimension is the one that has already received quite some attention in the literature, whereas in this paper we emphasize the first dimension. Combining both dimensions, it is interesting to compare the expressive power of a weak query language using a strong modality, against that of a seemingly stronger query language but perhaps using a weaker modality. We present some initial results within this theme. As an important auxiliary result, we establish a preservation theorem for monotone containments of conjunctive queries.

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

Access this chapter

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 EPUB and 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

Notes

  1. 1.

    In this paper, \(e_1 \subseteq e_2\) stands for a boolean query which, in general, may return true on some databases and return false on the other databases. Thus \(e_1 \subseteq e_2\) as considered in this paper should not be misconstrued as an instance of the famous query containment problem [1, 5], where the task would be to verify statically if \(e_1(D)\) is a subset of \(e_2(D)\) on every database D. Indeed, if \(e_1\) is contained in \(e_2\) in this latter sense, then the boolean query \(e_1 \subseteq e_2\) is trivial as it returns true on every database.

  2. 2.

    Some of our results can be refined to fragments containing just one of the two projections or coprojections, but for others this remains a technical open problem [21].

References

  1. Abiteboul, S., Hull, R., Vianu, V.: Foundations of Databases. Addison-Wesley, Boston (1995)

    MATH  Google Scholar 

  2. Ebbinghaus, H.D., Flum, J.: Finite Model Theory, 2nd edn. Springer, Heidelberg (1999). https://doi.org/10.1007/3-540-28788-4

    Book  MATH  Google Scholar 

  3. Libkin, L.: Elements of Finite Model Theory. Springer, Heidelberg (2004). https://doi.org/10.1007/978-3-662-07003-1

    Book  MATH  Google Scholar 

  4. Kolaitis, P.: On the expressive power of logics on finite models. In: Grädel, E., Kolaitis, P.G., Libkin, L., Marx, M., Spencer, J., Vardi, M.Y., Venema, Y., Weinstein, S. (eds.) Finite Model Theory and Its Applications. Springer, Heidelberg (2007). https://doi.org/10.1007/3-540-68804-8_2

    Chapter  Google Scholar 

  5. Chandra, A., Merlin, P.: Optimal implementation of conjunctive queries in relational data bases. In: Proceedings 9th ACM Symposium on the Theory of Computing, pp. 77–90. ACM (1977)

    Google Scholar 

  6. Beeri, C., Vardi, M.: A proof procedure for data dependencies. J. ACM 31(4), 718–741 (1984)

    Article  MathSciNet  Google Scholar 

  7. Angles, R., Gutierrez, C.: Survey of graph database models. ACM Comput. Surv. 40(1), 1 (2008)

    Article  Google Scholar 

  8. Wood, P.: Query languages for graph databases. SIGMOD Rec. 41(1), 50–60 (2012)

    Article  Google Scholar 

  9. Barceló, P.: Querying graph databases. In: Proceedings 32nd ACM Symposium on Principles of Databases, pp. 175–188. ACM (2013)

    Google Scholar 

  10. Marx, M., de Rijke, M.: Semantic characterizations of navigational XPath. SIGMOD Rec. 34(2), 41–46 (2005)

    Article  Google Scholar 

  11. ten Cate, B., Marx, M.: Navigational XPath: calculus and algebra. SIGMOD Rec. 36(2), 19–26 (2007)

    Article  Google Scholar 

  12. Fletcher, G., Gyssens, M., Leinders, D., Van den Bussche, J., Van Gucht, D., Vansummeren, S., Wu, Y.: Relative expressive power of navigational querying on graphs. In: Proceedings 14th International Conference on Database Theory (2011)

    Google Scholar 

  13. Libkin, L., Martens, W., Vrgoč, D.: Quering graph databases with XPath. In: Proceedings 16th International Conference on Database Theory. ACM (2013)

    Google Scholar 

  14. Angles, R., Barceló, P., Rios, G.: A practical query language for graph DBs. In: Bravo, L., Lenzerini, M. (eds.) Proceedings 7th Alberto Mendelzon International Workshop on Foundations of Data Management. CEUR Workshop Proceedings, vol. 1087 (2013)

    Google Scholar 

  15. Surinx, D., Fletcher, G., Gyssens, M., Leinders, D., Van den Bussche, J., Van Gucht, D., Vansummeren, S., Wu, Y.: Relative expressive power of navigational querying on graphs using transitive closure. Log. J. IGPL 23(5), 759–788 (2015)

    Article  MathSciNet  Google Scholar 

  16. Fletcher, G., Gyssens, M., Leinders, D., Surinx, D., Van den Bussche, J., Van Gucht, D., Vansummeren, S., Wu, Y.: Relative expressive power of navigational querying on graphs. Inf. Sci. 298, 390–406 (2015)

    Article  MathSciNet  Google Scholar 

  17. Fletcher, G., Gyssens, M., Leinders, D., Van den Bussche, J., Van Gucht, D., Vansummeren, S., Wu, Y.: The impact of transitive closure on the expressiveness of navigational query languages on unlabeled graphs. Ann. Math. Artif. Intell. 73(1–2), 167–203 (2015)

    Article  MathSciNet  Google Scholar 

  18. Surinx, D., Van den Bussche, J., Van Gucht, D.: The primitivity of operators in the algebra of binary relations under conjunctions of containments. In: Proceedings 32nd Annual ACM/IEEE Symposium on Logic in Computer Science. IEEE Computer Society Press (2017)

    Google Scholar 

  19. Imielinski, T., Lipski, W.: The relational model of data and cylindric algebras. J. Comput. Syst. Sci. 28, 80–102 (1984)

    Article  MathSciNet  Google Scholar 

  20. Van den Bussche, J.: Applications of Alfred Tarski’s ideas in database theory. In: Fribourg, L. (ed.) CSL 2001. LNCS, vol. 2142, pp. 20–37. Springer, Heidelberg (2001). https://doi.org/10.1007/3-540-44802-0_2

    Chapter  Google Scholar 

  21. Surinx, D.: A framework for comparing query languages in their ability to express boolean queries. Ph.D. thesis, Hasselt University (2017). http://dsurinx.be/phd.pdf

  22. Ameloot, T., Ketsman, B., Neven, F., Zinn, D.: Weaker forms of monotonicity for declarative networking: a more fine-grained answer to the CALM-conjecture. ACM Trans. Database Syst. 40(4), 21 (2016)

    MathSciNet  Google Scholar 

  23. Cruz, I., Mendelzon, A., Wood, P.: A graphical query language supporting recursion. In: Dayal, U., Traiger, I. (eds.) Proceedings of the ACM SIGMOD 1987 Annual Conference. SIGMOD Record, vol. 16, no. 3, pp. 323–330. ACM Press (1987)

    Article  Google Scholar 

  24. Chang, C., Keisler, H.: Model Theory, 3rd edn. North-Holland, Amsterdam (1990)

    MATH  Google Scholar 

  25. Benedikt, M., Leblay, J., ten Cate, B., Tsamoura, E.: Generating Plans from Proofs: The Interpolation-Based Approach to Query Reformulation. Morgan & Claypool, San Rafael (2016)

    MATH  Google Scholar 

  26. Rossman, B.: Homomorphism preservation theorems. J. ACM 55(3), 15 (2008)

    Article  MathSciNet  Google Scholar 

  27. Gurevich, Y.: Toward logic tailored for computational complexity. In: Börger, E., Oberschelp, W., Richter, M.M., Schinzel, B., Thomas, W. (eds.) Computation and Proof Theory. LNM, vol. 1104, pp. 175–216. Springer, Heidelberg (1984). https://doi.org/10.1007/BFb0099486

    Chapter  Google Scholar 

  28. Ajtai, M., Gurevich, Y.: Monotone versus positive. J. ACM 34(4), 1004–1015 (1987)

    Article  MathSciNet  Google Scholar 

  29. Stolboushkin, A.: Finitely monotone properties. In: Proceedings 10th Annual IEEE Symposium on Logic in Computer Science, pp. 324–330 (1995)

    Google Scholar 

  30. Barwise, J., Cooper, R.: Generalized quantifiers and natural language. Linguist. Philos. 4(2), 159–219 (1981)

    Article  Google Scholar 

  31. Badia, A.: Quantifiers in Action. ADS, vol. 37. Springer, Boston, MA (2009). https://doi.org/10.1007/978-0-387-09564-6

    Book  MATH  Google Scholar 

  32. Hella, L., Luosto, K., Väänänen, J.: The hierarchy theorem for generalized quantifiers. J. Symb. Log. 61(3), 802–817 (1996)

    Article  MathSciNet  Google Scholar 

Download references

Author information

Authors and Affiliations

Authors

Corresponding author

Correspondence to Dimitri Surinx .

Editor information

Editors and Affiliations

Rights and permissions

Reprints and permissions

Copyright information

© 2018 Springer International Publishing AG, part of Springer Nature

About this paper

Check for updates. Verify currency and authenticity via CrossMark

Cite this paper

Surinx, D., Van den Bussche, J., Van Gucht, D. (2018). A Framework for Comparing Query Languages in Their Ability to Express Boolean Queries. In: Ferrarotti, F., Woltran, S. (eds) Foundations of Information and Knowledge Systems. FoIKS 2018. Lecture Notes in Computer Science(), vol 10833. Springer, Cham. https://doi.org/10.1007/978-3-319-90050-6_20

Download citation

  • DOI: https://doi.org/10.1007/978-3-319-90050-6_20

  • Published:

  • Publisher Name: Springer, Cham

  • Print ISBN: 978-3-319-90049-0

  • Online ISBN: 978-3-319-90050-6

  • eBook Packages: Computer ScienceComputer Science (R0)

Publish with us

Policies and ethics