Skip to main content

Induction of Relational Algebra Expressions

  • Conference paper

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

Abstract

We study the problem of inducing relational databases queries expressing quantification. Such queries express interesting multi-relational patterns in a database in a concise manner. Queries on relational databases can be expressed as Datalog programs. Inducing Datalog programs expressing quantification requires both negation and predicate invention. Predicate invention has been studied in the ILP literature. However, we propose a radical new approach to inducing quantification. We express queries in the relational algebra and we perform a heuristic search for the desired expression. A heuristic, which takes the complement operator into account, is proposed. We report some preliminary experimental results of a software prototype implementing our ideas. The results are compared with the results of FOIL and Tilde on the same examples.

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. Abiteboul, S., Hull, R., Vianu, V.: Foundations of Databases. Addison-Wesley Publishing Company Inc., Reading (1995)

    MATH  Google Scholar 

  2. Ullman, J.: Principles of Database and Knowledge-Base Systems, vol. 1. Computer Science Publisher, Rockville (1988)

    Google Scholar 

  3. Ullman, J.: Principles of Database and Knowledge-Base Systems, vol. 2. Computer Science Publisher, Rockville (1989)

    Google Scholar 

  4. Blockeel, H., De Raedt, L.: Relational knowledge discovery in databases (1996)

    Google Scholar 

  5. Blockeel, H., De Raedt, L.: Inductive database design (1996)

    Google Scholar 

  6. Codd, E.: Relational completeness of data base sublanguages. Database Systems (1972)

    Google Scholar 

  7. Chandra, A., Harel, D.: Structure and complexity of relational queries. Journal of Computer and System Sciences 25, 99–128 (1982)

    Article  MATH  Google Scholar 

  8. Silverstein, G., Pazzani, M.: Relational clichés: Constraining induction during relational learning (1991)

    Google Scholar 

  9. Kijsirikul, B., Numao, M., Shimura, M.: Discrimination-based constructive induction of logic programs (1992)

    Google Scholar 

  10. Kok, S., Domingos, P.: Statistical predicate invention (2007)

    Google Scholar 

  11. Quinlan, J., Cameron-Jones, R.: Induction of logic programs: Foil and related systems. New Generation Computing 13, 287–312 (1995)

    Article  Google Scholar 

  12. Blockeel, H., De Raedt, L.: Top-down induction of first-order logical decision trees. Artificial Intelligence 101, 285–297 (1998)

    Article  MATH  MathSciNet  Google Scholar 

  13. De Raedt, L.: Logical and Relational Learning. In: Cognitive Technologies. Springer, Heidelberg (2008)

    Google Scholar 

  14. Acar, A., Motro, A.: Intensional encapsulation of database subsets via genetic programming (2005)

    Google Scholar 

  15. Miller, R., Haas, L., Hernández, M.: Schema mapping as query discovery (2000)

    Google Scholar 

  16. Fletcher, G., Wyss, C.: Data mapping as search. In: Ioannidis, Y., Scholl, M.H., Schmidt, J.W., Matthes, F., Hatzopoulos, M., Böhm, K., Kemper, A., Grust, T., Böhm, C. (eds.) EDBT 2006. LNCS, vol. 3896, pp. 95–111. Springer, Heidelberg (2006)

    Chapter  Google Scholar 

  17. Henkin, L., Monk, J., Tarski, A.: Cylindric Algebras, Part I. North-Holland, Amsterdam (1971)

    Google Scholar 

  18. Van den Bussche, J.: Applications of alfred tarski’s ideas in database theory (2001)

    Google Scholar 

  19. Imielinski, T., Lipski, W.: The relational model of data and cylindric algebras. Journal of Computer and System Sciences 28, 80–102 (1984)

    Article  MATH  MathSciNet  Google Scholar 

  20. Kahr, A., Moore, E., Wang, H.: Entscheidungsproblem recuded to the ∀ ∃ ∀ case. Proc. Natl. Acad. Sci. USA 48, 365–377 (1962)

    Article  MATH  MathSciNet  Google Scholar 

  21. Russell, S., Norvig, P.: Artificial Intelligence, A Modern Approach, 2nd edn. Prentice Hall, Englewood Cliffs (2003)

    Google Scholar 

  22. Blockeel, H., Dehaspe, L., Demoen, B., Janssens, G., Raons, J., Vandecasteele, H.: Improving the efficiency of inductive logic programming through the use of query packs. Journal of Artificial Intelligence Research 16, 135–166 (2002)

    MATH  Google Scholar 

  23. Koza, J.: Genetic Programming: On the Programming of Computers by Means of Natural Selection. MIT Press, Cambridge (1992)

    MATH  Google Scholar 

Download references

Author information

Authors and Affiliations

Authors

Editor information

Editors and Affiliations

Rights and permissions

Reprints and permissions

Copyright information

© 2010 Springer-Verlag Berlin Heidelberg

About this paper

Cite this paper

Gillis, J.J.M., Van den Bussche, J. (2010). Induction of Relational Algebra Expressions. In: De Raedt, L. (eds) Inductive Logic Programming. ILP 2009. Lecture Notes in Computer Science(), vol 5989. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-13840-9_4

Download citation

  • DOI: https://doi.org/10.1007/978-3-642-13840-9_4

  • Publisher Name: Springer, Berlin, Heidelberg

  • Print ISBN: 978-3-642-13839-3

  • Online ISBN: 978-3-642-13840-9

  • eBook Packages: Computer ScienceComputer Science (R0)

Publish with us

Policies and ethics