Implication and axiomatization of functional and constant constraints

  • Jelle Hellings
  • Marc Gyssens
  • Jan Paredaens
  • Yuqing Wu
Article
  • 98 Downloads

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.

Keywords

Functional constraints Constant constraints Chase algorithm Axiomatization 

Mathematics Subject Classfication (2010)

68P15 05C60 

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. 1.
    Abiteboul, S., Hull, R., Vianu, V.: Foundations of Databases. Addison-Wesley (1995)Google Scholar
  2. 2.
    Aho, A.V., Beeri, C., Ullman, J.D.: The theory of joins in relational databases. ACM Trans. Database Syst. 4(3), 297–314 (1979)CrossRefGoogle Scholar
  3. 3.
    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)Google Scholar
  4. 4.
    Arenas, M., Libkin, L.: A normal form for XML documents. ACM Trans. Database Syst. 29(1), 195–232 (2004)CrossRefGoogle Scholar
  5. 5.
    Armstrong, W.W.: Dependency structures of data base relationships. In: Information Processing 74, pp. 580–583 (1974)Google Scholar
  6. 6.
    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)Google Scholar
  7. 7.
    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)Google Scholar
  8. 8.
    Beeri, C., Vardi, M.Y.: A proof procedure for data dependencies. J. ACM 31 (4), 718–741 (1984)MathSciNetCrossRefMATHGoogle Scholar
  9. 9.
    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)Google Scholar
  10. 10.
    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/
  11. 11.
    Buneman, P., Davidson, S., Fan, W., Hara, C., Tan, W.C.: Keys for XML. Comput. Netw. 39(5), 473–487 (2002)CrossRefMATHGoogle Scholar
  12. 12.
    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)Google Scholar
  13. 13.
    Codd, E.F.: Relational completeness of data base sublanguages, vol. 987. IBM Research Laboratory, San Jose, California (1972)Google Scholar
  14. 14.
    Codd, E.F.: Recent investigations in relational data base systems. In: Information Processing 74, pp. 1017–1021 (1974)Google Scholar
  15. 15.
    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)Google Scholar
  16. 16.
    Fagin, R.: Horn clauses and database dependencies. J. ACM 29(4), 952–985 (1982)MathSciNetCrossRefMATHGoogle Scholar
  17. 17.
    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)Google Scholar
  18. 18.
    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/
  19. 19.
    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/
  20. 20.
    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)Google Scholar
  21. 21.
    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)CrossRefGoogle Scholar
  22. 22.
    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)Google Scholar
  23. 23.
    Hartmann, S., Link, S.: Efficient reasoning about a robust XML key fragment. ACM Trans. Database Syst. 34(2), 10:1–10:33 (2009)CrossRefGoogle Scholar
  24. 24.
    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)Google Scholar
  25. 25.
    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)Google Scholar
  26. 26.
    Kanellakis, P.C.: Elements of relational database theory. Tech. Rep. CS-89-39, Brown University (1989)Google Scholar
  27. 27.
    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)Google Scholar
  28. 28.
    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)Google Scholar
  29. 29.
    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)Google Scholar
  30. 30.
    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)MathSciNetCrossRefMATHGoogle Scholar
  31. 31.
    Wijsen, J.: Database repairing using updates. ACM Trans. Database Syst. 30 (3), 722–768 (2005)CrossRefGoogle Scholar
  32. 32.
    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)Google Scholar

Copyright information

© Springer International Publishing Switzerland 2015

Authors and Affiliations

  • Jelle Hellings
    • 1
  • Marc Gyssens
    • 1
  • Jan Paredaens
    • 2
  • Yuqing Wu
    • 3
  1. 1.Faculty of SciencesHasselt University and Transnational University of LimburgHasseltBelgium
  2. 2.Department of Mathematics and Computer ScienceUniversity of AntwerpAntwerpBelgium
  3. 3.Computer Science DepartmentPomona CollegeClaremontUSA

Personalised recommendations