Skip to main content

Exact Learning of Multivalued Dependencies

  • Conference paper
  • First Online:

Part of the book series: Lecture Notes in Computer Science ((LNAI,volume 9355))

Abstract

The transformation of a relational database schema into fourth normal form, which minimizes data redundancy, relies on the correct identification of multivalued dependencies. In this work, we study the learnability of multivalued dependency formulas (MVDF), which correspond to the logical theory behind multivalued dependencies. As we explain, MVDF lies between propositional Horn and 2-Quasi-Horn. We prove that MVDF is polynomially learnable in Angluin et al.’s exact learning model with membership and equivalence queries, provided that counterexamples and membership queries are formulated as 2-Quasi-Horn clauses. As a consequence, we obtain that the subclass of 2-Quasi-Horn theories which are equivalent to MVDF is polynomially learnable.

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

Buying options

Chapter
USD   29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD   39.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD   54.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

Learn about institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. Angluin, D.: Learning k-term dnf formulas using queries and counterexamples. Technical report, Department of Computer Science, Yale University, August 1987

    Google Scholar 

  2. Angluin, D.: Queries and concept learning. Mach. Learn. 2(4), 319–342 (1988)

    MathSciNet  Google Scholar 

  3. Angluin, D.: Negative results for equivalence queries. Machine Learning 5, 121–150 (1990)

    Google Scholar 

  4. Angluin, D., Frazier, M., Pitt, L.: Learning conjunctions of Horn clauses. Machine Learning 9, 147–164 (1992)

    MATH  Google Scholar 

  5. Balcázar, J.L., Baixeries, J.: Characterizations of multivalued dependencies and related expressions. In: Suzuki, E., Arikawa, S. (eds.) DS 2004. LNCS (LNAI), vol. 3245, pp. 306–313. Springer, Heidelberg (2004)

    Chapter  Google Scholar 

  6. Codd, E.F.: A relational model of data for large shared data banks. Communications of the ACM 13(6), 377–387 (1970)

    Article  MATH  Google Scholar 

  7. Delobel, C.: Normalization and hierarchical dependencies in the relational data model. ACM Transactions on Database Systems 3(3), 201–222 (1978)

    Article  Google Scholar 

  8. Fagin, R.: Multivalued dependencies and a new normal form for relational databases. ACM Transactions on Database Systems 2, 262–278 (1977)

    Article  Google Scholar 

  9. Frazier, M., Pitt, L.: Learning from entailment: an application to propositional Horn sentences. In: Machine Learning, Proceedings of the Tenth International Conference, University of Massachusetts, Amherst, MA, USA, June 27–29, 1993, pp. 120–127 (1993)

    Google Scholar 

  10. Hermo, M., Lavín, V.: Learning minimal covers of functional dependencies with queries. In: Watanabe, O., Yokomori, T. (eds.) ALT 1999. LNCS (LNAI), vol. 1720, p. 291. Springer, Heidelberg (1999)

    Chapter  Google Scholar 

  11. Khardon, R., Mannila, H., Roth, D.: Reasoning with Examples: Propositional Formulae and Database Dependencies. Acta Informatica 36(4), 267–286 (1999)

    Article  MathSciNet  MATH  Google Scholar 

  12. Lavín, V.: On learning multivalued dependencies with queries. Theor. Comput. Sci. 412(22), 2331–2339 (2011)

    Article  MathSciNet  MATH  Google Scholar 

  13. Lavín, V., Hermo, M.: Negative results on learning multivalued dependencies with queries. Information Processing Letters 111(19), 968–972 (2011)

    Article  MathSciNet  MATH  Google Scholar 

  14. Pillaipakkamnatt, K., Raghavan, V.: Read-twice DNF formulas are properly learnable. Information and Computation 122(2), 236–267 (1995)

    Article  MathSciNet  MATH  Google Scholar 

  15. Sagiv, Y., Delobel, C., Parker Jr, D.S., Fagin, R.: An equivalence between relational database dependencies and a fragment of propositional logic. Journal of the ACM 28(3), 435–453 (1981)

    Article  MathSciNet  MATH  Google Scholar 

Download references

Author information

Authors and Affiliations

Authors

Corresponding author

Correspondence to Ana Ozaki .

Editor information

Editors and Affiliations

Rights and permissions

Reprints and permissions

Copyright information

© 2015 Springer International Publishing Switzerland

About this paper

Cite this paper

Hermo, M., Ozaki, A. (2015). Exact Learning of Multivalued Dependencies. In: Chaudhuri, K., GENTILE, C., Zilles, S. (eds) Algorithmic Learning Theory. ALT 2015. Lecture Notes in Computer Science(), vol 9355. Springer, Cham. https://doi.org/10.1007/978-3-319-24486-0_5

Download citation

  • DOI: https://doi.org/10.1007/978-3-319-24486-0_5

  • Published:

  • Publisher Name: Springer, Cham

  • Print ISBN: 978-3-319-24485-3

  • Online ISBN: 978-3-319-24486-0

  • eBook Packages: Computer ScienceComputer Science (R0)

Publish with us

Policies and ethics