The paper adresses the problem of consistency preservation in data intensive applications evolution. When the database structure evolves, the application programs must be changed to interface with the new schema. The latter modification can prove very complex, error prone and time consuming. We describe a comprehensive transformation/generative approach according to which automated program transformation can be derived from schema transformation. The proposal is illustrated in the particular context of database reengineering, for which a specific methodology and a prototype tool are presented. Some results of two case studies are described.


Structural Mapping Entity Type Relationship Type Database Schema Program Transformation 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.


  1. 1.
    Bianchi, A., Caivano, D., Marengo, V., Visaggio, G.: Iterative reengineering of legacy systems. IEEE Trans. Softw. Eng. 29(3), 225–241 (2003)CrossRefGoogle Scholar
  2. 2.
    Boyd, M., McBrien, P.: Towards a semi-automated approach to intermodel transformation. In: CAiSE Workshops Proceedings, Riga Technical University, vol. 1, pp. 175–188 (2004)Google Scholar
  3. 3.
    van den Brand, M.G.J., van Deursen, A., Heering, J., de Jong, H.A., de Jonge, M., Kuipers, T., Klint, P., Moonen, L., Olivier, P.A., Scheerder, J., Vinju, J.J., Visser, E., Visser, J.: The ASF+SDF Meta-Environment: A component-based language development environment. In: Wilhelm, R. (ed.) CC 2001. LNCS, vol. 2027, pp. 365–370. Springer, Heidelberg (2001)CrossRefGoogle Scholar
  4. 4.
    Cleve, A., Henrard, J., Hainaut, J.-L.: Co-transformations in information system reengineering. In: Proc. of the 2nd International Workshop on Meta-Models, Schemas and Grammars for Reverse Engineering. ENTCS, vol. 137(3), pp. 5–15. Springer, Heidelberg (2005)Google Scholar
  5. 5.
    Didonet Del Fabro, M., Bézivin, J., Jouault, F., Valduriez, P.: Applying generic model management to data mapping. In: Proc. of the Journées Bases de Donnes Avancées (BDA 2005) (2005)Google Scholar
  6. 6.
    Hainaut, J.-L.: Specification preservation in schema transformations - application to semantics and statistics. Data & Knowledge Engineering 16(1) (1996)Google Scholar
  7. 7.
    Hainaut, J.-L.: Transformation-based database engineering. In: van Bommel, P. (ed.) Transformation of Knowledge, Information and Data: Theory and Applications, ch. 1. IDEA Group, USA (2005)Google Scholar
  8. 8.
    Henrard, J.: Program Understanding in Database Reverse Engineering. PhD thesis, University of Namur (2003)Google Scholar
  9. 9.
    Henrard, J., Cleve, A., Hainaut, J.-L.: Inverse wrappers for legacy information systems migration. In: WRAP 2004 Workshop Proceedings. CS Reports, vol. 04–34, pp. 30–43. Technische Universiteit Eindhoven (2004)Google Scholar
  10. 10.
    Henrard, J., Hick, J.-M., Thiran, P., Hainaut, J.-L.: Strategies for data reengineering. In: Proc. of the 9th Working Conference on Reverse Engineering (WCRE 2002), pp. 211–220. IEEE Computer Society Press, Los Alamitos (2002)CrossRefGoogle Scholar
  11. 11.
    Hick, J.-M., Hainaut, J.-L.: Database application evolution: a transformational approach. Data and Knowledge Engineering (to appear, 2006)Google Scholar
  12. 12.
    Lämmel, R., Verhoef, C.: Semi-automatic Grammar Recovery. Software—Practice & Experience 31(15), 1395–1438 (2001)MATHCrossRefGoogle Scholar
  13. 13.
    Lämmel, R.: Coupled Software Transformations (Ext. Abstract). In: Proc. of the First International Workshop on Software Evolution Transformations (November 2004)Google Scholar
  14. 14.
    Lämmel, R.: Transformations everywhere. Science of Computer Programming. The guest editor’s introduction to the SCP special issue on program transformation (2004)Google Scholar
  15. 15.
    Lohmann, W., Riedewald, G.: Towards automatical migration of transformation rules after grammar extension. In: Proc. of 7th European Conference on Software Maintenance and Reengineering (CSMR 2003), pp. 30–39. IEEE Computer Society Press, Los Alamitos (2003)CrossRefGoogle Scholar
  16. 16.
    Navathe, S.B.: Schema analysis for database restructuring. ACM Transactions on Database Systems 5(2), 157–184 (1980)CrossRefGoogle Scholar
  17. 17.
    Papakonstantinou, Y., Gupta, A., Garcia-Molina, H., Ullman, J.: A query translation scheme for rapid implementation of wrappers. In: Proc. of the International Conference on Declarative and Object-oriented Databases (1995)Google Scholar
  18. 18.
    Sneed, H.M.: Encapsulation of legacy software: A technique for reusing legacy software components. Annals of Software Engineering 9, 293–313 (2000)CrossRefGoogle Scholar
  19. 19.
    The DB-MAIN official website,
  20. 20.
    Veerman, N.: Revitalizing modifiability of legacy assets. Software Maintenance and Evolution: Research and Practice, Special issue on CSMR 2003 16(4–5), 219–254 (2004)CrossRefGoogle Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 2006

Authors and Affiliations

  • Anthony Cleve
    • 1
  • Jean-Luc Hainaut
    • 1
  1. 1.Laboratory of Database Applications EngineeringUniversity of NamurNamurBelgium

Personalised recommendations