Abstract
Akhtar et al. introduced equality-generating constraints and functional constraints as a first step towards dependency-like integrity constraints for RDF data [3]. Here, we focus on functional constraints. Since the usefulness of functional constraints is not limited to the RDF data model, we study the functional constraints in the more general setting of relations with arbitrary arity. We further introduce constant constraints and study the functional and constant constraints combined. Our main results are sound and complete axiomatizations for the functional and constant constraints, both separately and combined. These axiomatizations are derived using the chase algorithm for equality-generating constraints. For derivations of constant constraints, we show how every chase step can be simulated by a bounded number of applications of inference rules. For derivations of functional constraints, we show that the chase algorithm can be normalized to a more specialized symmetry-preserving chase algorithm performing so-called symmetry-preserving steps. We then show how each symmetry-preserving step can be simulated by a bounded number of applications of inference rules. The axiomatization for functional constraints is in particular applicable to the RDF data model, solving a major open problem of Akhtar et al.
Similar content being viewed by others
References
Abiteboul, S., Hull, R., Vianu, V.: Foundations of Databases. Addison-Wesley (1995)
Aho, A.V., Beeri, C., Ullman, J.D.: The theory of joins in relational databases. ACM Trans. Database Syst. 4(3), 297–314 (1979)
Akhtar, W., Cortés-Calabuig, Á., Paredaens, J.: Constraints in RDF. In: Semantics in Data and Knowledge Bases, Lecture Notes in Computer Science, vol. 6834, pp. 23–39. Springer (2011)
Arenas, M., Libkin, L.: A normal form for XML documents. ACM Trans. Database Syst. 29(1), 195–232 (2004)
Armstrong, W.W.: Dependency structures of data base relationships. In: Information Processing 74, pp. 580–583 (1974)
Beeri, C., Fagin, R., Howard, J.H.: A complete axiomatization for functional and multivalued dependencies in database relations. In:Proceedings of the 1977 ACM SIGMOD International Conference on Management of Data, SIGMOD ’77, pp. 47–61 (1977)
Beeri, C., Vardi, M.: The implication problem for data dependencies. In: Automata, Languages and Programming, Lecture Notes in Computer Science, vol. 115, pp. 73–85. Springer (1981)
Beeri, C., Vardi, M.Y.: A proof procedure for data dependencies. J. ACM 31 (4), 718–741 (1984)
Bravo, L., Fan, W., Geerts, F., Ma, S.: Increasing the expressivity of conditional functional dependencies without extra complexity. In: ICDE ’08 Proceedings of the 2008 IEEE 24th International Conference on Data Engineering, pp. 516–525 (2008)
Bray, T., Paoli, J., Sperberg-McQueen, C.M., Maler, E., Yergeau, F.: Extensible markup language (XML) 1.0 (fifth edition), W3C recommendation 26 November 2008 (2008). http://www.w3.org/TR/2008/REC-xml-20081126/
Buneman, P., Davidson, S., Fan, W., Hara, C., Tan, W.C.: Keys for XML. Comput. Netw. 39(5), 473–487 (2002)
Calbimonte, J.P., Porto, F., Keet, C.M.: Functional dependencies in OWL ABOX. In: XXIV Simposio Brasileiro de Banco de Dados, pp. 16–30 (2009)
Codd, E.F.: Relational completeness of data base sublanguages, vol. 987. IBM Research Laboratory, San Jose, California (1972)
Codd, E.F.: Recent investigations in relational data base systems. In: Information Processing 74, pp. 1017–1021 (1974)
Cortés-Calabuig, A., Paredaens, J.: Semantics of constraints in RDFS. In: Proceedings of the 6th Alberto Mendelzon International Workshop on Foundations of Data Management, pp. 75–90 (2012)
Fagin, R.: Horn clauses and database dependencies. J. ACM 29(4), 952–985 (1982)
Fagin, R., Vardi, M.Y.: The theory of data dependencies—a survey. In: Mathematics of Information Processing, Proceedings of Symposia in Applied Mathematics, vol. 34, pp. 19–71. American Mathematical Society (1986)
Fallside, D.C., Walmsley, P.: RDF schema 1.1, W3C recommendation 25 February 2014 (2014). http://www.w3.org/TR/2014/REC-rdf-schema-20140225/
Fallside, D.C., Walmsley, P.: XML schema part 0: Primer second edition, W3C recommendation 28 October 2004 (2004). http://www.w3.org/TR/2004/REC-xmlschema-0-20041028/
Fan, W., Geerts, F., Jia, X.: Conditional dependencies: A principled approach to improving data quality. In: Dataspace: The Final Frontier, Lecture Notes in Computer Science, vol. 5588, pp. 8–20. Springer (2009)
Fan, W., Geerts, F., Jia, X., Kementsietsidis, A.: Conditional functional dependencies for capturing data inconsistencies. ACM Trans. Database Syst. 33(2), 6:1–6:48 (2008)
Hartmann, S., Link, S.: More functional dependencies for XML. In: Advances in Databases and Information Systems, Lecture Notes in Computer Science, vol. 2798, pp. 355–369. Springer (2003)
Hartmann, S., Link, S.: Efficient reasoning about a robust XML key fragment. ACM Trans. Database Syst. 34(2), 10:1–10:33 (2009)
He, Q., Ling, T.W.: Extending and inferring functional dependencies in schema transformation. In: Proceedings of the Thirteenth ACM International Conference on Information and Knowledge Management, CIKM ’04, pp. 12–21. ACM (2004)
Hellings, J., Gyssens, M., Paredaens, J., Wu, Y.: Implication and axiomatization of functional constraints on patterns with an application to the RDF data model. In: Foundations of Information and Knowledge Systems, Lecture Notes in Computer Science, vol. 8367, pp. 250–269. Springer (2014)
Kanellakis, P.C.: Elements of relational database theory. Tech. Rep. CS-89-39, Brown University (1989)
Lausen, G., Meier, M., Schmidt, M.: SPARQLing constraints for RDF. In: Proceedings of the 11th International Conference on Extending Database Technology: Advances in Database Technology, EDBT ’08, pp. 499–509 (2008)
Niewerth, M., Schwentick, T.: Reasoning about XML constraints based on XML-to-relational mappings. In: Proceedings of the 17th International Conference on Database Theory, ICDT ’14, pp. 72–83 (2014)
Vardi, M.Y.: Fundamentals of dependency theory. In: Trends in Theoretical Computer Science, Principles of Computer Science Series, vol. 34, pp. 171–224. Computer Science Press (1987)
Vincent, M.W., Liu, J., Mohania, M.: The implication problem for ‘closest node‘ functional dependencies in complete XML documents. J. Comput. Syst. Sci. 78 (4), 1045–1098 (2012)
Wijsen, J.: Database repairing using updates. ACM Trans. Database Syst. 30 (3), 722–768 (2005)
Yu, Y., Heflin, J.: Extending functional dependency to detect abnormal data in RDF graphs. In: The Semantic Web ISWC 2011, Lecture Notes in Computer Science, vol. 7031, pp. 794–809. Springer (2011)
Author information
Authors and Affiliations
Corresponding author
Additional information
This is a revised and extended version of the paper ‘Implication and Axiomatization of Functional Constraints on Patterns with an Application to the RDF Data Model’ presented at the 8th International Symposium on Foundations of Information and Knowledge Systems, Bordeaux, France (FOIKS 2014) [25].
Yuqing Wu carried out part of her work during a sabbatical visit to Hasselt University with a Senior Visiting Postdoctoral Fellowship of the Research Foundation Flanders (FWO).
Rights and permissions
About this article
Cite this article
Hellings, J., Gyssens, M., Paredaens, J. et al. Implication and axiomatization of functional and constant constraints. Ann Math Artif Intell 76, 251–279 (2016). https://doi.org/10.1007/s10472-015-9473-7
Published:
Issue Date:
DOI: https://doi.org/10.1007/s10472-015-9473-7