A framework for the design and evaluation of reverse engineering methods for relational databases
Data & Knowledge Engineering
Advances in knowledge discovery and data mining
Advances in knowledge discovery and data mining
Relational database reverse engineering: algorithms to extract cardinality constraints
Data & Knowledge Engineering
Database System Concepts
Exploring into Programs for the Recovery of Data Dependencies Designed
IEEE Transactions on Knowledge and Data Engineering
A Generic Approach for Data Reverse Engineering Taking into Account Application Doamin Knowledge
CSMR '98 Proceedings of the 2nd Euromicro Conference on Software Maintenance and Reengineering ( CSMR'98)
Selection of Reverse Engineering Methods for Relational Databases
CSMR '99 Proceedings of the Third European Conference on Software Maintenance and Reengineering
Software Reengineering Based on Concept Lattices
CSMR '00 Proceedings of the Conference on Software Maintenance and Reengineering
Data Dependency Elicitation in Database Reverse Engineering
CSMR '01 Proceedings of the Fifth European Conference on Software Maintenance and Reengineering
Structure Elicitation in Database Reverse Engineering
WCRE '96 Proceedings of the 3rd Working Conference on Reverse Engineering (WCRE '96)
Extracting Entity-Relationship Schemas from Relational Databases: A Form-Driven Approach
WCRE '97 Proceedings of the Fourth Working Conference on Reverse Engineering (WCRE '97)
An Industrial Example of Database Reverse Engineering
WCRE '99 Proceedings of the Sixth Working Conference on Reverse Engineering
Lessons Learned in Data Reverse Engineering
WCRE '01 Proceedings of the Eighth Working Conference on Reverse Engineering (WCRE'01)
AICCSA '01 Proceedings of the ACS/IEEE International Conference on Computer Systems and Applications
Automated elicitation of inclusion dependencies from the source code for database transactions
Journal of Software Maintenance: Research and Practice
IBM Systems Journal
Using ontologies to discover fact IDs
DOLAP '10 Proceedings of the ACM 13th international workshop on Data warehousing and OLAP
An information presentation method based on tree-like super entity component
Journal of Systems and Software
Integrated Computer-Aided Engineering
| Hi-index | 0.00 |
Current database reverse engineering researches presume that the information regarding semantics of attributes, primary keys, and foreign keys in database tables is complete. However, this may not be the case. In a recent DBRE effort to derive a data model from a table-based database system, we find the data content of many attributes are not related to their names at all. In this paper, we present a process that extracts an extended entity-relationship diagram from a table-based database with little descriptions for the fields in its tables and no description for keys. The primary inputs of our approach are system display forms, table schema and data instance. We utilize screen displays to construct form instances. Secondly, code analysis and data analysis involving comparisons of fields and decomposition of fields are applied to extract attribute semantics from forms and table schemas, followed by the determination of primary keys, foreign keys and constraints of the database system. In the final step of conceptualization, with the processes of table mergence and relationship identification, an extended ER diagram is successfully extracted in a case study.