Abstract
We investigate the expressive power of query languages for constraint databases. We examine languages over first order logic enhanced with the inequality constraint and linear constraints. We show that the query “one-line” is not expressible in FO+order (i.e. inequality constraint). In fact, the result is stronger in that we prove that it is not expressible in any higher order logic either. Furthermore, we show that the same query can be expressed in FO+linear by giving a non-trivial sentence that characterizes the class of databases consisting of exactly one line.
This is a preview of subscription content, log in via an institution.
Preview
Unable to display preview. Download preview PDF.
References
F. Afrati, S. Cosmadakis, S. Grumbach, G. Kuper. Linear vs. Polynomial Constraints in Database Query Languages. PPCP 1994
A. Brodsky, J. Jaffar and M.J. Maher. Toward Practical Constraint Databases. Proc. 19th International Conference on Very Large Data Bases, Dublin, Ireland, 1993.
H. Enderton. A Mathematical Introduction to Logic. Academic Press Inc., 1972.
S. Grumbach and J. Su, Finitely representable databases. In Manuscript, 1994.
S. Grumbach and J. Su. Dense-Order Constraint Databases. Proc. 14th ACM PODS, 1995
J. Jaffar and J.L. Lassez. Constraint Logic Programming. Proc. 14th ACM POPL, 111–119, 1987.
P. Kanellakis, G. Kuper and P. Revesz. Constraint Query Languages. Proc. 9th ACM PODS, pp. 299–313, 1990. To appear in JCSS.
P. Kanellakis, D. Goldin. Constraint Programming and Database Query Languages. Technical Report, Brown University, CS-94-31.
G.M. Kuper. On the expressive power of the relational calculus with arithmetic constraints. In Proc. Int. Conf. on Database Theory, pages 202–211, 1990.
G.M. Kuper. Aggregation in constraint databases. In Proc. First Workshop on Principles and Practice of Constraint Programming, 1993.
J.L. Lassez. Querying Constraints. Proc. 9th ACM PODS, 1990.
M. Maher. A Logic Semantics for a class of Committed Choice Languages. Proc. ICLP4, MIT Press 1987.
J. Paredaens, J. Van den Bussche, D. Van Gucht. First-order queries on finite structures over the reals. LICS '95.
P.Z. Revesz. A Closed Form for Datalog Queries with Integer Order. Proc. 3rd International Conference on Database Theory, 1990. To appear in TCS.
Author information
Authors and Affiliations
Editor information
Rights and permissions
Copyright information
© 1996 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Afrati, F., Andronikos, T., Kavalieros, T.G. (1996). On the expressiveness of first-order constraint languages. In: Kuper, G., Wallace, M. (eds) Constraint Databases and Application. CDB 1995. Lecture Notes in Computer Science, vol 1034. Springer, Berlin, Heidelberg. https://doi.org/10.1007/3-540-60794-3_12
Download citation
DOI: https://doi.org/10.1007/3-540-60794-3_12
Published:
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-60794-6
Online ISBN: 978-3-540-49456-0
eBook Packages: Springer Book Archive