Formal techniques for data base design
Formal techniques for data base design
Informal and Formal Requirements Specification Languages: Bridging the Gap
IEEE Transactions on Software Engineering
Object-oriented modeling and design
Object-oriented modeling and design
DoD legacy systems: reverse engineering data requirements
Communications of the ACM
An approach for reverse engineering of relational databases
Communications of the ACM
Using an enabling technology to reengineer legacy systems
Communications of the ACM
Database research faces the information explosion
Communications of the ACM
Design Recovery for Distributed Systems
IEEE Transactions on Software Engineering
Object-oriented modeling and design for database applications
Object-oriented modeling and design for database applications
Object-oriented client/server Internet environments
Object-oriented client/server Internet environments
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
Software Engineering Economics
Software Engineering Economics
Introduction to Database Systems
Introduction to Database Systems
Reverse Engineering and Design Recovery: A Taxonomy
IEEE Software
Planning the Reengineering of Legacy Systems
IEEE Software
Using Yourdon and Z: an Approach to Formal Specification
Proceedings of the Fifth Annual Z User Meeting on Z User Workshop
DEXA '96 Proceedings of the 7th International Conference on Database and Expert Systems Applications
Hi-index | 0.00 |
This paper focuses on some issues relating to data modelling, quality and management in a specific domain: forests. Many forest domain specialists e.g., botanists, zoologists, economists and others collect vast volumes of data about the forest fauna and flora, climate, soil, etc. The favourite tools for managing this data are spreadsheets and/or using popular DBMS packages such as Access or FoxPro. The use of these tools introduces two major problems: loss of semantics and poor data structure. These problems and associated issues are examined in this the paper. To address these problems, we propose a method for database reverse engineering from spreadsheet tables to a conceptual model and suggest a design of a prototype tool (TREAT). We also explain the motivation for and the methodology and approach that we adopted. The interactive process used to identify the constituents of the spreadsheet tables and data semantics are explained. Semi-automated analysis of the associations between the data items in terms of the domain knowledge, constraints and functional dependencies between the data items are also described. The output from the tool may be selected as either an Entity-Relationship or Object or Object-Relational model.