Generating three-tier applications from relational databases: A formal and practical approach

Information and Software Technology

Volumn 44, Issue 15, 2002, Pages 923-941

  Polo, Macario ^a   Gómez, Juan Ángel ^a   Piattini, Mario ^a   Ruiz, Francisco ^a  

^a Paseo de la Universidad 4   (Spain)

Author keywords

Code generation; Database reengineering; Pattern formalization

Indexed keywords

COMPUTER AIDED SOFTWARE ENGINEERING; COMPUTER SOFTWARE; MATHEMATICAL TRANSFORMATIONS; REVERSE ENGINEERING;

DATABASE REENGINEERING;

RELATIONAL DATABASE SYSTEMS;

EID: 0036888284     PISSN: 09505849     EISSN: None     Source Type: Journal    
DOI: 10.1016/S0950-5849(02)00130-1     Document Type: Article

References (30)

1. Andersson M. Loucopoulos, (Ed.), Extracting an Entity Relationship Schema from a Relational Database through Reverse Engineering, Proceedings of the 13th International Conference on Entity-Relationship Approach, Springer-Verlag, Berlin, LNCS. vol. 881:1994;403-419.
2. Arnold R. Software Reengineering. 1992;IEEE Press, New York.
3. Biggerstaff T.J., Mitbander B.G., Webster D.E. Program understanding and the concept assignment problem. Communications of the ACM. 37:(5):1994;72-83.
4. Briand L.C., Morasca S., Basili V.R. Property-based software engineering measurement. IEEE Transactions on Software Engineering. 22:(1):1996;68-86.
5. Brookshear J.G. Theory of Computation: Formal Languages, Automata and Complexity. 1989;The Benjamin/Cummins Publishing Company, Redwood City, CA.
6. Broy M. Toward a mathematical foundation of software engineering methods. IEEE Transactions on Software Engineering. 27:(1):2001;42-57.
7. Buschman F., Meunier R., Rohnert H., Sommerlad P., Stal M. A System of Patterns: Pattern-Oriented Software Architecture. 1996;Addison-Wesley, Reading, MA.
8. Pedro de Jesus L., Sousa P. Nesi, Verhoef., Nesi, Verhoef (Ed.), Selection of Reverse Engineering Methods for Relational Database, Proceedings of the Third European Conference on Software Maintenance. 1998;194-197 IEEE Computer Society, Los Alamitos, CA.
9. Biskup J., Menzel R., Polle T. Transforming an entity-relationship schema into object-oriented database schemas. Eder, Kalinichenko, Advance in Databases and Information System, Moscow, Workshops in Computing. Workshops in Computing. 1996;109-136 Springer, Berlin.
10. Castellanos M. A Methodology for Semantically Enriching Interoperable Database, Proceedings of the 11th British National Conference on Databases. 1993;. pp. 58-75.
11. Chiang R., Barron T., Storey V.C. Reverse engineering of relational databases: extraction of an EER model from a relational database. Journal of Data and Knowledge Engineering. 12:(2):1994;107-142.
12. Gamma E., Helm R., Johnson R., Vlissides J. Design Patterns. 1995;Addisson-Wesley, Reading, MA.
13. Gogolla M., Herzig R., Conrad S., Denker G., Vlachantonis N. Elmasri V., Kouramajian, Thalheim B., Integrating the ER Approach in an OO Environment, Proceedings of 12th International Conference on Entity-Relationship Approach, Arlington, Texas, USA. 1993;376-389.
14. Hainaut J.L., Henrard J., Hick J.M., Roland D., Englebert V. Database Design Recovery, Proceedings of the Eighth Conference on Advance Information Systems Engineering, CAiSE'96. 1996;Springer, Berlin. pp. 463-480.
15. Jungclaus R., Saake G., Hartmann T., Sernadas C. Object-oriented specification of information systems: the TROLL language. Informatik-Bericht. 91:(04):1991.
16. Lano K., Bicarregui J., Goldsack S. Formalising Design Patterns, First BCS-FACS Northern Formal Methods Workshop, Electronic Workshops in Computer Science. 1996;Springer, Berlin.
17. Larman C. Applying UML and Patterns. 1998;Prentice-Hall, Upper Saddle River, NJ.
18. Leavit N. Whatever happened to object-oriented databases? IEEE Computer. 33:(8):2001;16-19.
19. Malki M., Flory A., Rahmouni M.K. Extraction of object-oriented schemas from existing relational databases: a form-driven approach. Informatica. 13:(1):2002;47-72.
20. Pastor ó., Insfrán E., Pelechano V., Romero J., Merseguer J. OOMETHOD: An OO Software Production Environment Combining Conventional and Formal Methos, Proceedings of the Ninth Conference on Advanced Information Systems Engineering (CaiSE, 1997). 1997;. pp. 145-158.
21. Polo M., Piattini M., Ruiz F. RCRUD: Reflective Create, Read, Update and Delete, Proceedings of the Sixth European Conference on Pattern Languages of Programs. 2001;. Also available at (May 5, 2002); http://www.inf-cr.uclm.es/www/mpolo.
22. Premerlani W., Blaha M. An approach for reverse engineering of relational databases. Communications of the ACM. 37:(5):1994;42-49.
23. Rational Software Corporation, Available at (May 5, 2002); http://www.rational.com.
24. Reinder J., Loe M.G., Glas A., Krikhaar R.L., Winter T. Maintaining a legacy: towards support at the architectural level. Journal of Software Maintenance. 12:(3):2000;143-170.
25. Schach S.R., Tomer A. A maintenance-oriented approach to software construction. Journal of Software Maintenance. 12:(1):2000;25-45.
26. Shoval P., Shreiber N. Database reverse engineering: from the relational to the binary relationship model. Journal of Data and Knowledge Engineering. 10:1993;293-315.
27. Soutou C. Relational database reverse engineering: algorithms to extract cardinality constraints. Journal of Data and Knowledge Engineering. 28:1998;161-207.
28. TogetherSoft Corporation, Available at (May 5, 2002); http://www.togethersoft.com.
29. Warmer J., Kleppe A. The Object Constraint Language. 1998;Addison-Wesley, Reading, MA.
30. Yoder J.W. Patterns for Making Business Objects Persistent in a Relational Database, nnTutorial at the Conference on Object-Oriented Programming, Systems, Languages, and Applications (OOPSLA, 2001), Tampa Bay, Florida, USA. 2002;. Examples can be found at (May 5, 2002); http://www.joeyoder.com.