Physical database design for relational databases
ACM Transactions on Database Systems (TODS)
Identifying Extended Entity-Relationship Object Structures in Relational Schemas
IEEE Transactions on Software Engineering
Database tuning: a principled approach
Database tuning: a principled approach
The design of relational databases
The design of relational databases
Options in physical database design
ACM SIGMOD Record
An approach for reverse engineering of relational databases
Communications of the ACM
The power of sampling in knowledge discovery
PODS '94 Proceedings of the thirteenth ACM SIGACT-SIGMOD-SIGART symposium on Principles of database systems
Reverse engineering of relational databases: extraction of an EER model from a relational database
Data & Knowledge Engineering
A survey of database design transformations based on the Entity-Relationship model
Data & Knowledge Engineering
Approximate inference of functional dependencies from relations
ICDT '92 Selected papers of the fourth international conference on Database theory
AutoAdmin “what-if” index analysis utility
SIGMOD '98 Proceedings of the 1998 ACM SIGMOD international conference on Management of data
Integrity constraints: semantics and applications
Logics for databases and information systems
The Asilomar report on database research
ACM SIGMOD Record
On the foundations of the universal relation model
ACM Transactions on Database Systems (TODS)
Data mining: concepts and techniques
Data mining: concepts and techniques
Guaranteeing no interaction between functional dependencies and tree-like inclusion dependencies
Theoretical Computer Science
Making views self-maintainable for data warehousing
DIS '96 Proceedings of the fourth international conference on on Parallel and distributed information systems
SIGMOD '75 Proceedings of the 1975 ACM SIGMOD international conference on Management of data
Principles of Database Systems
Principles of Database Systems
A Guided Tour of Relational Databases and Beyond
A Guided Tour of Relational Databases and Beyond
Database System Implementation
Database System Implementation
Levelwise Search and Borders of Theories in KnowledgeDiscovery
Data Mining and Knowledge Discovery
Justification for Inclusion Dependency Normal Form
IEEE Transactions on Knowledge and Data Engineering
Query Folding with Inclusion Dependencies
ICDE '98 Proceedings of the Fourteenth International Conference on Data Engineering
A Method for Transforming Relational Schemas Into Conceptual Schemas
Proceedings of the Tenth International Conference on Data Engineering
Exploiting Uniqueness in Query Optimization
Proceedings of the Tenth International Conference on Data Engineering
Inclusion Dependencies in Database Design
Proceedings of the Second International Conference on Data Engineering
Towards the Reverse Engineering of Denormalized Relational Databases
ICDE '96 Proceedings of the Twelfth International Conference on Data Engineering
ICDE '96 Proceedings of the Twelfth International Conference on Data Engineering
Discovery of "Interesting" Data Dependencies from a Workload of SQL Statements
PKDD '99 Proceedings of the Third European Conference on Principles of Data Mining and Knowledge Discovery
Implementation of Two Semantic Query Optimization Techniques in DB2 Universal Database
VLDB '99 Proceedings of the 25th International Conference on Very Large Data Bases
Enforcing Inclusion Dependencies and Referencial Integrity
VLDB '88 Proceedings of the 14th International Conference on Very Large Data Bases
The Conceptual Database Design Optimizer CoDO - Concepts, Implementation, Application
ER '96 Proceedings of the 15th International Conference on Conceptual Modeling
Complements for Data Warehouses
ICDE '99 Proceedings of the 15th International Conference on Data Engineering
Automating Statistics Management for Query Optimizers
ICDE '00 Proceedings of the 16th International Conference on Data Engineering
Efficient Algorithms for Mining Inclusion Dependencies
EDBT '02 Proceedings of the 8th International Conference on Extending Database Technology: Advances in Database Technology
Samples for Understanding Data-Semantics in Relations
ISMIS '02 Proceedings of the 13th International Symposium on Foundations of Intelligent Systems
Mediation in a dynamic context: arguing for a request-oriented approach and structuring it
Web-enabled systems integration
Zigzag: a new algorithm for mining large inclusion dependencies in databases
ICDM '03 Proceedings of the Third IEEE International Conference on Data Mining
Wrapper-based evolution of legacy information systems
ACM Transactions on Software Engineering and Methodology (TOSEM)
Extracting generalization hierarchies from relational databases: A reverse engineering approach
Data & Knowledge Engineering
Unary and n-ary inclusion dependency discovery in relational databases
Journal of Intelligent Information Systems
On multi-column foreign key discovery
Proceedings of the VLDB Endowment
Database semantics recovery through analysis of dynamic SQL statements
Journal on data semantics XV
Proceedings of the 2004 European conference on Constraint-Based Mining and Inductive Databases
ACM SIGMOD Record
Hi-index | 0.00 |
Inclusion dependencies together with functional dependencies form the most important data dependencies used in practice. Inclusion dependencies are important for various database applications such as database design and maintenance, semantic query optimization and efficient view maintenance of data warehouse. Existing approaches for discovering inclusion dependencies consist in producing the whole set of inclusion dependencies holding in a database, leaving the task of selecting the interesting ones to an expert user.In this paper, we take another look at the problem of discovering inclusion dependencies. We exploit the logical navigation, inherently available in relational databases through workloads of SQL statements, as a guess to automatically find out only interesting inclusion dependencies. This assumption leads us to devise a tractable algorithm for discovering interesting inclusion dependencies. Within this framework, approximate dependencies, i.e. inclusion dependencies which almost hold, are also considered.As an example, we present a novel application, namely self-tuning the logical database design, where the discovered inclusion dependencies can be used effectively.