Functional dependencies and constraints on Null values in database relations
Information and Control
Conceptual database design: an Entity-relationship approach
Conceptual database design: an Entity-relationship approach
An approach for reverse engineering of relational databases
Communications of the ACM
Reverse engineering of relational databases: extraction of an EER model from a relational database
Data & Knowledge Engineering
Conceptual design of object-oriented database schemas using the binary-relationship model
Data & Knowledge Engineering
Converting relational to object-oriented databases
ACM SIGMOD Record
Relational database reverse engineering: algorithms to extract cardinality constraints
Data & Knowledge Engineering
Database abstractions: aggregation and generalization
ACM Transactions on Database Systems (TODS)
Discovering interesting inclusion dependencies: application to logical database tuning
Information Systems - Databases: Creation, management and utilization
Designing the Reengineering Services for the DOK Federated Database System
ICDE '97 Proceedings of the Thirteenth International Conference on Data Engineering
Towards an Assisted Reorganization of Is_A Hierarchies
OOIS '02 Proceedings of the 8th International Conference on Object-Oriented. Information Systems
Functional Dependencies and Disjunctive Existence Constraints in Database Relations with Null Values
Proceedings of the 11th Colloquium on Automata, Languages and Programming
Abstraction Capabilities and Invariant Properties Modelling within the Entity-Relationship Approach
Proceedings of the 1st International Conference on the Entity-Relationship Approach to Systems Analysis and Design
Extracting an Entity Relationship Schema from a Relational Database through Reverse Engineering
ER '94 Proceedings of the13th International Conference on the Entity-Relationship Approach
Reconstruction of ER Schema from Database Applications: a Cognitive Approach
ER '94 Proceedings of the13th International Conference on the Entity-Relationship Approach
An Executable Meta Model for Re-Engineering of Database Schemas
ER '94 Proceedings of the13th International Conference on the Entity-Relationship Approach
Reverse Engineering of Relational Database Applications
OOER '95 Proceedings of the 14th International Conference on Object-Oriented and Entity-Relationship Modelling
Reverse Engineering of Relational Database Physical Schema
ER '96 Proceedings of the 15th International Conference on Conceptual Modeling
Semantically Enriching Relational Databases into an Object Oriented Semantic Model
DEXA '94 Proceedings of the 5th International Conference on Database and Expert Systems Applications
Mining the Content of Relational Databases to Learn Ontologies with Deeper Taxonomies
WI-IAT '08 Proceedings of the 2008 IEEE/WIC/ACM International Conference on Web Intelligence and Intelligent Agent Technology - Volume 01
A survey on summarizability issues in multidimensional modeling
Data & Knowledge Engineering
A web of knowledge: a conceptual-modeling perspective
The evolution of conceptual modeling
Functional dependency discovery via Bayes net analysis
MAMECTIS/NOLASC/CONTROL/WAMUS'11 Proceedings of the 13th WSEAS international conference on mathematical methods, computational techniques and intelligent systems, and 10th WSEAS international conference on non-linear analysis, non-linear systems and chaos, and 7th WSEAS international conference on dynamical systems and control, and 11th WSEAS international conference on Wavelet analysis and multirate systems: recent researches in computational techniques, non-linear systems and control
Bringing relational databases into the Semantic Web: A survey
Semantic Web - On real-time and ubiquitous social semantics
| Hi-index | 0.00 |
Relational Data Base Management Systems (RDBMS) are currently the most popular database management systems. The relational model is a simple and powerful model for representing real world applications. However, it lacks the expressiveness of conceptual models. Unlike the latter, the relational model does not offer the generalization abstraction. Therefore, it does not allow the designer to represent directly a large variety of integrity constraints. Moreover, inclusion dependencies formalizing inter-relational constraints cannot directly be represented in the relational model, due to the fact that its basic construct, the relation, is the unique structure. Finally, relational databases do not enable a natural way to represent inheritances. In this paper we describe a reverse engineering method which particularly deals with the elicitation of inheritance links embedded in a relational database, combining heuristic and algorithmic approaches. We provide rules for detecting intersection constraints and inclusion dependencies. Heuristics are proposed for understanding null value semantics. Finally, we present decision rules for detecting existence dependencies and translating them into IS-A hierarchies among entities. An example is used to illustrate our approach.