Updating relational databases through object-based views
SIGMOD '91 Proceedings of the 1991 ACM SIGMOD international conference on Management of data
An approach for reverse engineering of relational databases
Communications of the ACM
A framework for the design and evaluation of reverse engineering methods for relational databases
Data & Knowledge Engineering
Incremental materialization of object-oriented views
Data & Knowledge Engineering
A Theory of Translation From Relational Queries to Hierarchical Queries
IEEE Transactions on Knowledge and Data Engineering
Efficient Discovery of Functional Dependencies and Armstrong Relations
EDBT '00 Proceedings of the 7th International Conference on Extending Database Technology: Advances in Database Technology
Designing the Reengineering Services for the DOK Federated Database System
ICDE '97 Proceedings of the Thirteenth International Conference on Data Engineering
A Query Model for Object-Oriented Databases
Proceedings of the Ninth International Conference on Data Engineering
OOER: Toward Making the E-R Approach Object-Oriented
Proceedings of the Seventh International Conference on Enity-Relationship Approach: A Bridge to the User
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
Using Queries to Improve Database Reverse Engineering
ER '94 Proceedings of the13th International Conference on the Entity-Relationship Approach
Documenting Legacy Relational Databases
ER '99 Proceedings of the Workshops on Evolution and Change in Data Management, Reverse Engineering in Information Systems, and the World Wide Web and Conceptual Modeling
Dimensions of Data ase Reverse Engineering
WCRE '97 Proceedings of the Fourth Working Conference on Reverse Engineering (WCRE '97)
| Hi-index | 0.00 |
This paper presents a novel approach to decide on the equivalence of a conventional relational schema and a corresponding object-oriented schema. We assume that the two schemas are consistent and implemented a prototype to handle the process. First, characteristics of the relational schema are derived and lead to a graph consistent with the entity-relationship diagram. Second, a graph that include all nesting and inheritance links is derived based on characteristics of the object-oriented schema. Third, we investigate the equivalence of the two graphs in order to decide on relational attributes equivalent to object-oriented attributes with primitive domains, and on the equivalence between relational foreign keys and object-oriented attributes with non-primitive domains.