Discovering interesting inclusion dependencies: Application to logical database tuning

Information Systems

Volumn 27, Issue 1, 2002, Pages 1-19

  Lopes, Stéphane ^a   Petit, Jean Marc ^a   Toumani, Farouk ^a  

^a UNIVERSITÉ CLERMONT AUVERGNE   (France)

Author keywords

Data mining; Inclusion dependencies; Knowledge discovery in databases; Relational model; Self tuning databases

Indexed keywords

ALGORITHMS; DATA MINING; DATA WAREHOUSES; KNOWLEDGE BASED SYSTEMS; MATHEMATICAL MODELS; OPTIMIZATION; QUERY LANGUAGES; SEMANTICS;

SELF TUNING DATABASES;

RELATIONAL DATABASE SYSTEMS;

EID: 0036498516     PISSN: 03064379     EISSN: None     Source Type: Journal    
DOI: 10.1016/S0306-4379(01)00027-8     Document Type: Article

References (50)

1. Referential integrity
2. Inclusion dependencies and their interaction with functional dependencies
3. Inclusion dependencies in database design
4. Enforcing inclusion dependencies and referential integrity
5. Integrity constraints: Semantics and applications
6. Justification for inclusion dependency normal form
7. Reuse of database design decisions
8. Designing entity-relationship schemes for conventional information systems
9. Identifying extended entity-relationship object structures in relational schemas
10. Relational database reverse engineering: A method based on query analysis
11. Exploiting uniqueness in query optimization
12. Query folding
13. Query folding with inclusion dependencies
14. Implementation of two semantic query optimization techniques in DB2 universal database
15. Making views self-maintainable for data warehousing
16. Complements for data warehouses
17. Discovering functional and inclusion dependencies in relational databases
18. Discovering foreign key relations in relational databases
19. Reverse engineering of relational databases: Extraction of an EER model from a relational database
20. On the foundations of the universal relation model
21. The asilomar report on database research
22. Levelwise search and borders of theories in knowledge discovery
23. Database reverse engineering: Models, techniques and strategies
24. An approach for reverse engineering of relational databases
25. Options in physical database design
26. Physical database design for relational databases
27. Autoadmin 'what-if' index analysis utility
28. Automating statistics management for query optimizers
29. The conceptual database design optimizer CoDo - Concepts, implementation, application
30. Conceptual database application tuning
31. Computing joins of relations
32. Approximate inference on functional dependencies from relations
33. The power of sampling in knowledge discovery
34. Autoadmin "what-if" index analysis utility
35. A method for transforming relational schemas into conceptual schemas
36. A survey of database design transformations based on the entity-relationship model
37. Guaranteeing no interaction between functional dependencies and tree-like inclusion dependencies
38. Discovery of "Interesting" data dependencies from a workload of SQL statements
39. Efficient discovery of functional dependencies and armstrong relations
40. Mind: A levelwise algorithm for discovering inclusion dependencies
41. Informative armstrong relations