Database dependency discovery: a machine learning approach

作者: Iztok Savnik , Peter A. Flach

DOI: 10.5555/1216155.1216159

关键词:

摘要: Database dependencies, such as functional and multivalued express the presence of structure in database relations, that can be utilised design process. The discovery dependencies viewed an induction problem, which general rules (dependencies) are obtained from specific facts (the relation). This viewpoint has advantage abstracting away much possible particulars dependencies. algorithms this paper designed they easily generalised to other kinds dependencies.Like current approaches computational inductive logic programming, we distinguish between top-down bottom-up algorithms. In a approach, hypotheses generated systematic way then tested against given relation. relation is inspected order see what it may satisfy or violate. We give simple (but inefficient) algorithm, bi-directional algorithm. case these have been implemented FDEP system evaluated experimentally. algorithm most efficient three, also outperforms literature.

参考文章(26)
Juha Karkkainen, Hannu T. T. Toivonen, Yka Huhtala, Pasi P. Porkka, Efficient Discovery of Functional and Approximate Dependencies Using Partitions (Extended version) ,(1997)
Heikki Mannila, Hannu Toivonen, On an algorithm for finding all interesting sentences Cybernetics and Systems. pp. 973- 978 ,(1996)
Raymond Reiter, Towards a Logical Reconstruction of Relational Database Theory On Conceptual Modelling (Intervale). pp. 191- 238 ,(1984) , 10.1007/978-1-4612-5196-5_8
Peter A. Flach, Inductive characterisation of database relations Methodologies for intelligent systems, 5. pp. 371- 378 ,(1991)
Georg Gottlob, Leonid Libkin, Investigations on Armstrong relations, dependency inference, and excluded functional dependencies. Acta Cybernetica. ,vol. 9, pp. 385- 402 ,(1990)
Peter A. Flach, Normal Forms for Inductive Logic Programming inductive logic programming. pp. 149- 156 ,(1997) , 10.1007/3540635149_43
Thomas G Dietterich, Geoff Dromey, Kenneth Clarkson, Bob London, Learning and Inductive Inference ,(1982)
Pieter Adriaan Flach, None, Conjectures: an inquiry concerning the logic of induction Institute for Language Technology & Artificial Intelligence, Tilburg University. ,(1995)
Peter A. Flach, Predicate Invention in Inductive Data Engineering european conference on machine learning. pp. 83- 94 ,(1993) , 10.1007/3-540-56602-3_129
Iztok Savnik, Peter A. Flach, Discovery of multivalued dependencies from relations intelligent data analysis. ,vol. 4, pp. 195- 211 ,(2000) , 10.3233/IDA-2000-43-403