Identifying Extended Entity-Relationship Object Structures in Relational Schemas
IEEE Transactions on Software Engineering
Conceptual database design: an Entity-relationship approach
Conceptual database design: an Entity-relationship approach
DoD legacy systems: reverse engineering data requirements
Communications of the ACM
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
Algorithms for inferring functional dependencies from relations
Data & Knowledge Engineering
Closure maintenance in an object-oriented query model
CIKM '94 Proceedings of the third international conference on Information and knowledge management
A survey of database design transformations based on the Entity-Relationship model
Data & Knowledge Engineering
A framework for the design and evaluation of reverse engineering methods for relational databases
Data & Knowledge Engineering
Object-oriented modeling and design for database applications
Object-oriented modeling and design for database applications
Proper handling of query results towards maximizing reusability in object-oriented databases
Information Sciences: an International Journal
Incremental materialization of object-oriented views
Data & Knowledge Engineering
The entity-relationship model—toward a unified view of data
ACM Transactions on Database Systems (TODS) - Special issue: papers from the international conference on very large data bases: September 22–24, 1975, Framingham, MA
Reverse Engineering and Design Recovery: A Taxonomy
IEEE Software
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
A Method for Transforming Relational Schemas Into Conceptual Schemas
Proceedings of the Tenth International Conference on Data Engineering
Towards the Reverse Engineering of Denormalized Relational Databases
ICDE '96 Proceedings of the Twelfth International Conference on Data Engineering
Efficient Discovery of Functional and Approximate Dependencies Using Partitions
ICDE '98 Proceedings of the Fourteenth 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
Schema Transformation Techniques for Database Reverse Engineering
ER '93 Proceedings of the 12th International Conference on the Entity-Relationship Approach: Entity-Relationship Approach
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
Using Queries to Improve Database Reverse Engineering
ER '94 Proceedings of the13th International Conference on the Entity-Relationship Approach
Clustering Relations into Abstract ER Schemas for Database Reverse Engineering
CSMR '99 Proceedings of the Third European Conference on Software Maintenance and Reengineering
Dimensions of Data ase Reverse Engineering
WCRE '97 Proceedings of the Fourth Working Conference on Reverse Engineering (WCRE '97)
Knowledge Transfer in Database Reverse Engineering - A Supporting Case Study
WCRE '97 Proceedings of the Fourth Working Conference on Reverse Engineering (WCRE '97)
On Reverse Engineering of Vendor Databases
WCRE '98 Proceedings of the Working Conference on Reverse Engineering (WCRE'98)
A Retrospective on Industrial Database Reverse Engineering Projects-Part 1
WCRE '01 Proceedings of the Eighth Working Conference on Reverse Engineering (WCRE'01)
WI '06 Proceedings of the 2006 IEEE/WIC/ACM International Conference on Web Intelligence
Reusing relational sources for semantic information access
Proceedings of the ACM first Ph.D. workshop in CIKM
Relational Database Migration: A Perspective
DEXA '08 Proceedings of the 19th international conference on Database and Expert Systems Applications
R2O transformation system: relation to ontology transformation for scalable data integration
IDEAS '08 Proceedings of the 2008 international symposium on Database engineering & applications
A Conceptual Modeling Framework for Expressing Observational Data Semantics
ER '08 Proceedings of the 27th International Conference on Conceptual Modeling
Flexible approach for representing object oriented databases in XML format
Proceedings of the 10th International Conference on Information Integration and Web-based Applications & Services
Automatic Extraction of Ontologies Wrapping Relational Data Sources
DEXA '09 Proceedings of the 20th International Conference on Database and Expert Systems Applications
VIREX: visual relational to XML conversion tool
Journal of Visual Languages and Computing
ER'07 Proceedings of the 26th international conference on Conceptual modeling
VIREX and VRXQuery: interactive approach for visual querying of relational databases to produce XML
Journal of Intelligent Information Systems
XML materialized views and schema evolution in VIREX
Information Sciences: an International Journal
A model-driven heuristic approach for detecting multidimensional facts in relational data sources
DaWaK'10 Proceedings of the 12th international conference on Data warehousing and knowledge discovery
Extracting knowledge from fuzzy relational databases with description logic
Integrated Computer-Aided Engineering
Re-engineering relational databases: the way forward
Proceedings of the 2011 International Conference on Intelligent Semantic Web-Services and Applications
A web of knowledge: a conceptual-modeling perspective
The evolution of conceptual modeling
A metadata driven approach to performing complex heterogeneous database schema migrations
Innovations in Systems and Software Engineering
Bringing relational databases into the Semantic Web: A survey
Semantic Web - On real-time and ubiquitous social semantics
Integrated Computer-Aided Engineering
Hi-index | 0.00 |
The maintenance of an existing database depends on the depth of understanding of its characteristics. Such an understanding is easily lost when the developers disperse. The situation becomes worse when the related documentation is missing. This paper addresses this issue by extracting the extended entity-relationship schema from the relational schema. We developed algorithms that investigate characteristics of an existing legacy database in order to identify candidate keys of all relations in the relational schema, to locate foreign keys, and to decide on the appropriate links between the given relations. Based on this analysis, a graph consistent with the entity-relationship diagram is derived to contain all possible uniary and binary relationships between the given relations. The minimum and maximum cardinalities of each link in the mentioned graph are determined, and extra links within the graph are identified and categorized, if any. The latter information is necessary to optimize foreign keys related information Finally, the last steps in the process involve~(when applicable) suggesting improvements on the original conceptual design, deciding on relationships with attributes, many-to-many and n-ary (n ≥ 3) relationships, and identifying is-a links. User involvement in the process is minimized to the case of having multiple choices, where the system does not have the semantic knowledge required to decide on a certain choice.