Abstract
After two decades of research in Deductive Databases, SQL99 [12] brings them again to the foreground given that SQL99 includes queries with linear recursion. Therefore some of the problems solved for the relational model demand our attention again.
In this paper, we tackle the implication of functional dependencies (also known as the FD-FD implication problem) in the deductive model framework. The problem is as follows. GivenP, F, andf, whereP is a Datalog program, Fis a set of functional dependencies defined on the predicates of P, andf is a fd defined over the predicates of P, is it true that for all databasesd defined exclusively on the extensional predicates ofP, dsatisfies Fimplies that P( d) –the output database– satisfies f. Unlike the implication problem of functional dependencies in the relational data model, this problem is undecidable for general Datalog programs.
In this paper, we provide two methods to check if a given set of fds will be satisfied by the output database (without computing such database) for a class of Datalog programs.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
References
Abiteboul, S., Hull, R., Vianu, V.: Foundations of Databases. Addison-Wesley, Reading (1995)
Abiteboul, S., Hull, R.: Data functions, datalog and negation. In: Proc. Seventh ACM SIGACT-SIGMOD-SIGART Symposium on Principle of Database Systems, pp. 143–153 (1988)
Aho, A.V., Beeri, C., Ullman, J.D.: The theory of joins in relational databases. ACM TODS 4(3), 297–314 (1979)
Armstong, W.W.: Dependency structures of data base relationships. In: Proc. 1974 IFIP Congress, pp. 580–583 (1974)
Beeri, C., Vardi, M.Y.: A proof procedure for data dependencies. J. ACM 31, 718–741 (1984)
Bell, S., Brockhausen, P.: Discovery of constraints and data dependencies in databases (extended abstract). In: European Conference on Machine Learning, pp. 267–270 (1995)
Bell, S.: Discovery and maintenance of functional dependencies by independencies. In: Knowledge Discovery and Data Mining, pp. 27–32 (1995)
Brisaboa, N.R., Gonzalez-Tuchmann, A., Hernández, H.J., Paramá, J.R.: Chasing programs in datalog. In: Proceedings of the 6th International Workshop on Deductive Databases and Logic Programming DDLP 1998. GMDForschungzentrum Informationstechnik GmbH 1998 (GMD Report 22), pp. 13–23 (1998)
Gonzalez-Tuchmann, A.: The chase of datalog programs. PhD thesis, New Mexico State University, Department of Computer Science, Las Cruces, NM 88003-0001 (1995)
Maier, D., Mendelzon, A.O., Sagiv, Y.: Testing implications of data dependencies. ACM TODS 4(4), 455–469 (1979)
Maier, D.: The Theory of Relational Databases. Computer Science Press, Rockville (1983)
Melton, J., Simon, A.R.: SQL:1999 Understanding Relational Language Components. Morgan Kaufmann, San Francisco (2002)
Popa, L., Deutsch, A., Sahuguet, A., Tannen, V.: A chase too far. In: SIGMOD, pp. 273–284 (2000)
Popa, L.: Object/Relational Query Optimization with Chase and Backchase. PhD thesis, University of Pennsylvania (2000)
Ullman, J.D.: Principles of Database And Knowledge-Base Systems, vol. 1. Computer Science Press, Rockville (1988)
Wang, K., Yuan, L.Y.: Preservation of integrity constraints in definite datalog programs. Information Processing Letters 44(4) (1992)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2004 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Paramá, J.R., Brisaboa, N.R., Penabad, M.R., Places, Á.S. (2004). Implication of Functional Dependencies for Recursive Queries. In: Broy, M., Zamulin, A.V. (eds) Perspectives of System Informatics. PSI 2003. Lecture Notes in Computer Science, vol 2890. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-540-39866-0_49
Download citation
DOI: https://doi.org/10.1007/978-3-540-39866-0_49
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-20813-6
Online ISBN: 978-3-540-39866-0
eBook Packages: Springer Book Archive