Abstract
The discovery of functional dependencies (FDs) in relational databases is an important data-mining problem. Most current work assumes that the database is static, and a database update requires rediscovering all the FDs by scanning the entire old and new database repeatedly. Some works consider the incremental discovery of FDs in the presence of a new set of tuples added to an old database. In this work, we present two incremental data mining algorithms, top-down and bottom-up, to discover all FDs when deletion of tuples occurred to the database. Based on the principle of monotonicity of FDs [2], we avoid rescanning of the database and thereby reduce computation time. Feasibility and efficiency of the two proposed algorithms are demonstrated through examples.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
Similar content being viewed by others
References
Bell S, Brockhausen P (1995) Discovery of Data Dependencies in Relational Databases. Tech. Rep. LS-8, Report-14, University of Dortmund, Apr.
Flach PA (1990) Inductive Characterization of Database Relations. ITK Research Report, November
Flach PA, Savnik I (1999) Database Dependency Discovery: A Machine Learning Approach. AI Communications, 12(3), November, pp 139–160
Huhtala Y, Karkkainen J, Porkka P, Toivonen H (1997) Efficient Discovery of Functional and Approximate Dependencies Using Partitions.(Extended Version) Report C Report C-1997–79, November
Huhtala Y, Karkkainen J, Porkka P, Toivonen H (1998) Efficient Discovery of Functional and Approximate Dependencies Using Partitions. Proceedings of IEEE International Conference on Data Engineering, pp 392–410
Huhtala Y, Karkkainen J, Porkka P, Toivonen H (1999) TANE: An Efficient Algorithm for Discovering Functional and Approximate Dependencies. The Computer Journal, Vol 42, No 2, pp 100–111
Mannila H, Räihä KJ (1994) Algorithms for Inferring Functional Dependencies. Data & Knowledge Engineering, 12 (1), pp 83–99
Mannila H, Toivonen H (1997) Levelwise Search and Borders of Theories in Knowledge Discovery. Data Mining and Knowledge Discovery, 1 (3), pp 241–258
Schlimmer JC (1993) Efficiently Inducting Determinations: A Complete and Systematic Search Algorithm that Using Optimal Pruning. In G. Piatetsky-Shapiro, editor, Proceedings of the Tenth International Conference on Machine Learning, Morgan Kaufmann, pp 284–290
Wang SL, Shen JW, Hong TP (2001) Incremental Data Mining of Functional Dependencies. Proceedings of the Joint 9`h IFSA World Congress and 201h NAFIPS International Conference, Vancouver, Canada, pp 1322–1326
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2003 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Wang, SL., Tsou, WC., Lin, JH., Hong, TP. (2003). Maintenance of Discovered Functional Dependencies: Incremental Deletion. In: Abraham, A., Franke, K., Köppen, M. (eds) Intelligent Systems Design and Applications. Advances in Soft Computing, vol 23. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-540-44999-7_55
Download citation
DOI: https://doi.org/10.1007/978-3-540-44999-7_55
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-40426-2
Online ISBN: 978-3-540-44999-7
eBook Packages: Springer Book Archive