Database reverse engineering: From requirements to CARE tools

Automated Software Engineering

Volumn 3, Issue 1-2, 1996, Pages 9-45

  Hainaut, J L ^a   Englebert, V ^a   Henrard, J ^a   Hick, J M ^a   Roland, D ^a  

^a UNIVERSITY OF NAMUR   (Belgium)

Author keywords

CASE tools; Database engineering; Methodology; Program understanding; Reverse engineering

Indexed keywords

COMPUTER SOFTWARE; DATABASE SYSTEMS; USER INTERFACES;

COMPUTER AIDED REVERSE ENGINEERING (CARE) TOOLS; DATABASE REVERSE ENGINEERING (DBRE); SOFTWARE PACKAGE DB MAIN; SOFTWARE UNDERSTANDING;

COMPUTER AIDED SOFTWARE ENGINEERING;

EID: 0030169147     PISSN: 09288910     EISSN: None     Source Type: Journal    
DOI: 10.1007/BF00126958     Document Type: Article

References (53)

1. Andersson, M. 1994. Extracting an entity relationship schema from a relational database through reverse engineering. In Proc. of the 13th Int. Conf. on ER Approach, Manchester: Springer-Verlag.
2. Batini, C., Ceri, S., and Navathe, S.B. 1992. Conceptual Database Design. Benjamin-Cummings.
3. Batini, C., Di Battista, G., and Santucci, G. 1993. Structuring primitives for a dictionary of entity relationship data schemas. IEEE TSE, 19(4).
4. Blaha, M.R. and Premerlani, W.J. 1995. Observed idiosyncracies of relational database designs. In Proc. of the 2nd IEEE Working Conf. on Reverse Engineering, Toronto: IEEE Computer Society Press.
5. Bolois, G. and Robillard, P. 1994. Transformations in reengineering techniques. In Proc. of the 4th Reengineering Forum Reengineering in Practice, Victoria, Canada.
6. Casanova, M. and Amarel de Sa, J. 1983. Designing entity relationship schemas for conventional information systems. In Proc. of ERA, pp. 265-278.
7. Casanova, M.A. and Amaral, De Sa 1984. Mapping uninterpreted schemes into entity-relationship diagrams: Two applications to conceptual schema design. In IBM J. Res. & Develop., 28(1).
8. Chiang, R.H., Barron, T.M., and Storey, V.C. 1994. Reverse engineering of relational databases: Extraction of an EER model from a relational database. Journ. of Data and Knowledge Engineering, 12(2):107-142.
9. Date, C.J. 1994. An Introduction to Database Systems. Vol. 1, Addison-Wesley.
10. Davis, K.H. and Arora, A.K. 1985. A Methodology for translating a conventional file system into an entity-relationship model. In Proc. of ERA, IEEE/North-Holland.
11. Davis, K.H. and Arora, A.K. 1988. Converting a relational database model to an entity relationship model. In Proc. of ERA: A Bridge to the User, North-Holland.
12. Edwards, H.M. and Munro, M. 1995. Deriving a logical model for a system using recast method. In Proc. of the 2nd IEEE WC on Reverse Engineering. Toronto: IEEE Computer Society Press.
13. Fikas, S.F. 1985. Automating the transformational development of software. IEEE TSE, SE-11:1268-1277.
14. Fong, J. and Ho, M. 1994. Knowledge-based approach for abstracting hierarchical and network schema semantics. In Proc. of the 12th Int. Conf. on ER Approach, Arlington-Dallas: Springer-Verlag.
15. Fonkam, M.M. and Gray, W.A. 1992. An approach to eliciting the semantics of relational databases. In Proc. of 4th Int. Conf. on Advance Information Systems Engineering-CAiSE'92, pp. 463-480, LNCS, Springer-Verlag.
16. Elmasri, R. and Navathe, S. 1994. Fundamentals of Database Systems. Benjamin-Cummings.
17. Hainaut, J.-L. 1981. Theoretical and practical tools for database design. In Proc. Intern. VLDB Conf., ACM/IEEE.
18. Hainaut, J.-L. 1991. Entity-generating schema transformation for entity-relationship models. In Proc. of the 10th ERA, San Mateo (CA), North-Holland.
19. Hainaut, J.-L., Cadelli, M., Decuyper, B., and Marchand, O. 1992. Database CASE tool architecture: Principles for flexible design strategies. In Proc. of the 4th Int. Conf. on Advanced Information System Engineering (CAiSE-92), Manchester: Springer-Verlag, LNCS.
20. Hainaut, J.-L., Chandelon M., Tonneau C., and Joris, M. 1993a. Contribution to a theory of database reverse engineering. In Proc. of the IEEE Working Conf. on Reverse Engineering, Baltimore: IEEE Computer Society Press.
21. Hainaut, J.-L., Chandelon M., Tonneau C., and Joris, M. 1993b. Transformational techniques for database reverse engineering. In Proc. of the 12th Int. Conf. on ER Approach, Arlington-Dallas: E/R Institute and Springer-Verlag, LNCS.
22. Hainaut, J.-L., Englebert, V., Henrard, J., Hick, J.-M., and Roland, D. 1994. Evolution of database applications: The DB-MAIN approach. In Proc. of the 13th Int. Conf. on ER Approach, Manchester: Springer-Verlag.
23. Hainaut, J.-L. 1995. Transformation-based database engineering. Tutorial notes, VLDB'95, Zürich, Switzerland, (available at jlh@info.fundp.ac.be).
24. Hainaut, J.-L. 1996. Specification Preservation in Schema transformations - Application to Semantics and Statistics, Elsevier: Data & Knowledge Engineering (to appear).
25. Hainaut, J.-L., Roland, D., Hick J.-M., Henrard, J., and Englebert, V. 1996. Database design recovery, in Proc. of CAiSE-96, Springer-Verlag.
26. Halpin, T.A. and Proper, H.A. 1995. Database schema transformation and optimization. In Proc. of the 14th Int. Conf. on ER/OO Modelling (ERA), Springer-Verlag.
27. Hall, P.A.V. (Ed.) 1992. Software Reuse and Reverse Engineering in Practice, Chapman & Hall IEEE, 1990. Special issue on Reverse Engineering, IEEE Software, January, 1990.
28. Johannesson, P. and Kalman, K. 1990. A Method for translating relational schemas into conceptual schemas. In Proc. of the 8th ERA, Toronto, North-Holland.
29. Joris, M., Van Hoe, R., Hainaut, J.-L., Chandelon, M., Tonneau, C., and Bodart F. et al. 1992. PHENIX: Methods and tools for database reverse engineering. In Proc. 5th Int. Conf. on Software Engineering and Applications, Toulouse, December 1992, EC2 Publish.
30. Kobayashi, I. 1986. Losslessness and semantic correctness of database schema transformation: Another look of schema equivalence. In Information Systems, 11(1):41-59.
31. Kozaczynsky, Lilien, 1987. An extended entity-relationship (E2R) database specification and its automatic verification and transformation. In Proc. of ERA Conf.
32. Markowitz, K.M. and Makowsky, J.A. 1990. Identifying extended entity-relationship object structures in relational schemas. IEEE Trans. on Software Engineering, 16(8).
33. Navathe, S.B. 1980. Schema analysis for database restructuring. In ACM TODS, 5(2).
34. Navathe, S.B. and Awong, A. 1988. Abstracting relational and hierarchical data with a semantic data model. In Proc. of ERA: A Bridge to the User, North-Holland.
35. Nilsson, E.G. 1985. The translation of COBOL data structure to an entity-rel-type conceptual schema. In Proc. of ERA, IEEE/North-Holland.
36. Petit, J.-M., Kouloumdjian, J., Bouliaut, J.-F., and Toumani, F. 1994. Using queries to improve database reverse engineering. In Proc. of the 13th Int. Conf. on ER Approach, Springer-Verlag: Manchester.
37. Premerlani, W.J. and Blaha, M.R. 1993. An approach for reverse engineering of relational databases. In Proc. of the IEEE Working Conf. on Reverse Engineering, IEEE Computer Society Press.
38. Potts, C. and Bruns, G. 1988. Recording the reasons for design decisions. In Proc. of ICSE, IEEE Computer Society Press.
39. Rauh, O. and Stickel, E. 1995. Standard transformations for the normalization of ER schemata. In Proc. of the CAiSE-95 Conf., Jyväskylä, Finland, LNCS, Springer-Verlag.
40. Rock-Evans, R. 1990. Reverse engineering: Markets, methods and tools, OVUM report.
41. Rosenthal, A. and Reiner, D. 1988. Theoretically sound transformations for practical database design. In Proc. of ERA Conf.
42. Rosenthal, A. and Reiner, D. 1994. Tools and transformations - Rigourous and otherwise - for practical database design, ACM TODS, 19(2).
43. Rolland, C 1993. Modeling the requirements engineering process. In Proc. of the 3rd European-Japanese Seminar in Information Modeling and Knowledge Bases, Budapest (preprints).
44. Sabanis, N. and Stevenson, N. 1992. Tools and techniques for data remodelling cobol applications. In Proc. 5th Int. Conf. on Software Engineering and Applications, Toulouse, 7-11 December, pp. 517-529, EC2 Publish.
45. Selfridge, P.G., Waters, R.C., and Chikofsky, E.J. 1993. Challenges to the field of reverse engineering. In Proc. of the 1st WC on Reverse Engineering, pp. 144-150, IEEE Computer Society Press.
46. Shoval, P. and Shreiber, N. 1993. Database reverse engineering: From relational to the binary relationship Model, data and knowledge Engineering, 10(10).
47. Signore, O., Loffredo, M., Oregon, M., and Cima, M. 1994. Reconstruction of E-R schema from database Applications: A cognitive approach. In Proc. of the 13th Int. Conf. on ER Approach, Manchester: Springer-Verlag.
48. Springsteel, F.N. and Kou, C. 1990. Reverse data engineering of E-R designed relational schemas. In Proc. of Databases, Parallel Architectures and their Applications.
49. Teorey, T.J. 1994. Database Modeling and Design: The Fundamental Principles, Morgan Kaufmann.
50. Vermeer, M. and Apers, P. 1995. Reverse engineering of relational databases. In Proc. of the 14th Int. Conf. on ER/OO Modelling (ERA).
51. Weiser, M. 1984. Program slicing, IEEE TSE, 10:352-357.
52. Wills, L., Newcomb, P., and Chikofsky, E. (Eds.) 1995. Proc. of the 2nd IEEE Working Conf. on Reverse Engineering. Toronto: IEEE Computer Society Press.
53. Winans, J. and Davis, K.H. 1990. Software reverse engineering from a currently existing IMS database to an entity-relationship model. In Proc. of ERA: the Core of Conceptual Modelling, pp. 345-360, North-Holland.