skip to main content
10.1145/773153.773169acmconferencesArticle/Chapter ViewAbstractPublication PagespodsConference Proceedingsconference-collections
Article

Numerical document queries

Authors Info & Claims
Published:09 June 2003Publication History

ABSTRACT

A query against a database behind a site like Napster may search, e.g., for all users who have downloaded more jazz titles than pop music titles. In order to express such queries, we extend classical monadic second-order logic by Presburger predicates which pose numerical restrictions on the children (content) of an element node and provide a precise automata-theoretic characterization. While the existential fragment of the resulting logic is decidable, it turns out that satisfiability of the full logic is undecidable. Decidable satisfiability and a querying algorithm even with linear data complexity can be obtained if numerical constraints are only applied to those contents of elements where ordering is irrelevant. Finally, it is sketched how these techniques can be extended also to answer questions like, e.g., whether the total price of the jazz music downloaded so far exceeds a user's budget.

References

  1. A. Berlea and H. Seidl. Binary Queries. In Extreme Markup Languages 2002 Conference, Montreal, August 2002.]]Google ScholarGoogle Scholar
  2. L. Berman. The Complexity of Logical Theories. Theoretical Computer Science (TCS), 11:71--77, 1980.]]Google ScholarGoogle Scholar
  3. J.R. Büchi. Weak Second-order Arithmetic and Finite Automata. Math. Logik. Grund. Math., 6:66--92, 1960.]]Google ScholarGoogle ScholarCross RefCross Ref
  4. L. Cardelli and G. Ghelli. A Query Language Based on the Ambient Logic. In 10th European Symposium on Programming (ESOP), pages 1--22. LNCS 2028, Springer Verlag, 2001.]] Google ScholarGoogle ScholarDigital LibraryDigital Library
  5. L. Cardelli and A. Gordon. Anytime, Anywhere: Modal Logics for Mobile Ambients. In 27th ACM Conf. on Principles of Programming Languages (POPL), pages 365--377, 2000.]] Google ScholarGoogle ScholarDigital LibraryDigital Library
  6. G. Conforti, O. Ferrara, and G. Ghelli. TQL Algebra and its Implementation (Extended Abstract). In IFIP Int. Conf. on Theoretical Computer Science (IFIP TCS), pages 422--434, 2002.]] Google ScholarGoogle ScholarDigital LibraryDigital Library
  7. G. Conforti, G. Ghelli, A. Albano, D. Colazzo, P. Manghi, and C. Sartiani. The Query Language TQL. In 5th Int. Workshop on the Web and Databases (WebDB), 2002.]]Google ScholarGoogle Scholar
  8. J. Ferrante and C.W. Racko. The Computational Complexity of Logical Theories, volume 718 of Lecture Notes in Mathematics. Springer Verlag, 1979.]]Google ScholarGoogle ScholarCross RefCross Ref
  9. M.J. Fischer and M.O. Rabin. Superexponential Complexity of Presburger Arithmetic. In AMS Symp. on the Complexity of Computational Computational Processes. Vol. 7, pages 27--41, 1974.]]Google ScholarGoogle Scholar
  10. S. Ginsburg and E.H. Spanier. Bounded ALGOL-like Languages. Trans. Amer. Math. Soc., 113:333--368, 1964.]]Google ScholarGoogle ScholarCross RefCross Ref
  11. S. Ginsburg and E.H. Spanier. Semigroups, Presburger Formulas and Languages. Pacific Journal of Mathematics, 16(2):285--296, 1966.]]Google ScholarGoogle ScholarCross RefCross Ref
  12. G. Gottlob and C. Koch. Monadic Datalog and the Expressive Power of Languages for Web Information Extraction. In PODS 2001, pages 17--28, 2002.]] Google ScholarGoogle ScholarDigital LibraryDigital Library
  13. F. Klaedtke and H. Ruess. Parikh automata and monadic second-order logics with linear cardinality constraints. Technical Report 177, Institute of Computer Science at Freiburg University, 2002.]]Google ScholarGoogle Scholar
  14. O. Kupferman, U. Sattler, and M.Y. Vardi. The Complexity of the Graded μ-Calculus. In 18th Int. Conf. on Automated Deduction (CADE), pages 423--437. LNCS 2392, Springer Verlag, 2002.]] Google ScholarGoogle ScholarDigital LibraryDigital Library
  15. D. Lugiez. A Good Class of Automata and Application to Inductive Theorem Proving. In 25th Int. Coll. on Automata, Languages and Programming (ICALP), pages 409--420. LNCS 1443, Springer Verlag, 1998.]] Google ScholarGoogle ScholarDigital LibraryDigital Library
  16. D. Lugiez and S. Dal Zilio. Multitrees Automata, Presburger's Constraints and Tree Logics. Technical Report 08-2002, Laboratoire d'Informatique Fondamentale de Marseille, 2002.]]Google ScholarGoogle Scholar
  17. D. Lugiez and S. Dal Zilio. XML Schema, Tree Logic and Sheaves Automata. Technical Report RR-4631, INRIA, 2002.]]Google ScholarGoogle Scholar
  18. T. Milo, D. Suciu, and V. Vianu. Typechecking for XML Transformers. In Proceedings of the ACM Symposium on Principles of Database Systems, pages 11--22, Dallas, TX, 2000.]] Google ScholarGoogle ScholarDigital LibraryDigital Library
  19. M. Minsky. Recursive Unsolvability of Post's Problem of Tag and Other Topics in the Theory of Turing Machines. Ann. of Math., 74:437--455, 1961.]]Google ScholarGoogle ScholarCross RefCross Ref
  20. A. Neumann and H. Seidl. Locating Matches of Tree Patterns in Forests. In V. Arvind and R. Ramanujam, editors, Foundations of Software Technology and Theoretical Computer Science (FSTTCS), LNCS, pages 134--145. Springer Verlag, 1998.]] Google ScholarGoogle ScholarDigital LibraryDigital Library
  21. F. Neven and T. Schwentick. Query Automata over Finite Trees. Theoretical Computer Science (TCS), 275(1--2):633--674, 2002.]] Google ScholarGoogle ScholarDigital LibraryDigital Library
  22. F. Neven, T. Schwentick, and V. Vianu. Towards Regular Languages over In nite Alphabets. In MFCS 2001, pages 560--572, 2001.]] Google ScholarGoogle ScholarDigital LibraryDigital Library
  23. F. Neven and J. Van den Bussche. Expressiveness of Structured Document Query Languages Based on Attribute Grammars. Journal of the ACM, 49(1):56--100, 2002.]] Google ScholarGoogle ScholarDigital LibraryDigital Library
  24. J. Niehren and A. Podelski. Feature Automata and Recognizable Sets of Feature Trees. In 4th Int. Conf. on Theory and Practice of Software Development (TAPSOFT), pages 356--375. LNCS 668, Springer Verlag, 1993.]] Google ScholarGoogle ScholarDigital LibraryDigital Library
  25. H. Ohsaki. Beyond Regularity: Equational Tree Automata for Associative and Commutative Theories. In 15th Computer Science Logic (CSL), pages 539--553. LNCS 2142, Springer Verlag, 2001.]] Google ScholarGoogle ScholarDigital LibraryDigital Library
  26. H. Ohsaki and T. Takai. Decidability and Closure Properties of Equational Tree Languages. In 13th Int. Conf. on Rewriting Techniques and Applications (RTA), pages 114--128. LNCS 2378, Springer Verlag, 2002.]] Google ScholarGoogle ScholarDigital LibraryDigital Library
  27. R. Parikh. On Context-Free Languages. Journal of the ACM (JACM), 13(4):570--581, 1966.]] Google ScholarGoogle ScholarDigital LibraryDigital Library
  28. P. Wolper and B. Boigelot. On the Construction of Automata from Linear Arithmetic Constraints. In Tools and Algorithms for Construction and Analysis of Systems, 6th Ann. Conf. (TACAS), pages 1--19. LNCS 1785, Springer Verlag, 2000.]] Google ScholarGoogle ScholarDigital LibraryDigital Library

Index Terms

  1. Numerical document queries

        Recommendations

        Comments

        Login options

        Check if you have access through your login credentials or your institution to get full access on this article.

        Sign in
        • Published in

          cover image ACM Conferences
          PODS '03: Proceedings of the twenty-second ACM SIGMOD-SIGACT-SIGART symposium on Principles of database systems
          June 2003
          291 pages
          ISBN:1581136706
          DOI:10.1145/773153
          • Conference Chair:
          • Frank Neven,
          • General Chair:
          • Catriel Beeri,
          • Program Chair:
          • Tova Milo

          Copyright © 2003 ACM

          Permission to make digital or hard copies of all or part of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. Copyrights for components of this work owned by others than ACM must be honored. Abstracting with credit is permitted. To copy otherwise, or republish, to post on servers or to redistribute to lists, requires prior specific permission and/or a fee. Request permissions from [email protected]

          Publisher

          Association for Computing Machinery

          New York, NY, United States

          Publication History

          • Published: 9 June 2003

          Permissions

          Request permissions about this article.

          Request Permissions

          Check for updates

          Qualifiers

          • Article

          Acceptance Rates

          PODS '03 Paper Acceptance Rate27of136submissions,20%Overall Acceptance Rate642of2,707submissions,24%

        PDF Format

        View or Download as a PDF file.

        PDF

        eReader

        View online with eReader.

        eReader