Information Systems Frontiers

, Volume 5, Issue 2, pp 149–160 | Cite as

The Migration of Multi-tier E-commerce Applications to an Enterprise Java Environment

  • Terence C. Lau
  • Jianguo Lu
  • John Mylopoulos
  • Kostas Kontogiannis


As technology evolves, many organizations face the problem of migrating legacy applications from one technology base to another. We report on a case study involving the migration of legacy code into the IBM® WebSphere® Commerce Suite product. Specifically, we focus on the problem of migrating applications that use traditional database access techniques to applications using the Enterprise JavaBean (EJB) programming model. Our results include a practical methodology that facilitates such migration, as well as a tool that supports this methodology. The tool has been released on IBM's alphaWorks site.

e-commerce migration database reengineering Enterprise JavaBean SQL Net.Data JSP relational-object mapping 


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.


  1. Behm A, Geppert A, Dittrich KR. On the migration of relational schemas and data to object-oriented database systems. In: Proceedings of the 5th International Conference on Re-Technologies for Information Systems, Austria, 1997.Google Scholar
  2. Bergamaschi S, Garuti, A, Sartori C, Venuta A. The object wrapper: An object oriented interface for relational databases. Euromicro 1997.Google Scholar
  3. Brown K. Handling N-ary relationships in VisualAge for, Aug. 2000.Google Scholar
  4. IBM, IBM Net.Data Reference. Version 7, software/data/, June 2001.Google Scholar
  5. IBM, IBM WebSphere Commerce Suite, Programmers Guide.Version 5.1 Second Edition. webservers, March 2001.Google Scholar
  6. In2J, Automated Tool for Migrating Oracle Pl/SQL into Java,, Apr. 2001, Iplanet.Google Scholar
  7. iPlanet Application Server Migration Guide.Version 6.0., May 2000.Google Scholar
  8. Jahnke J, Schafer W, Zundorf A. A design environment for migrating relational to object oriented database systems. In: Proceedings of the International Conference on Software Maintenance, pp. 163-170. IEEE Computer Society Press, 1996.Google Scholar
  9. Kassem N. and the Enterprise Team. Designing Enterprise Application with the Java 2 Platform, Enterprise Edition. Sun Microsystems,, Oct. 3, 2000.Google Scholar
  10. Lau T, Lu J, Mylopoulos J, Hedges E, Kontogiannis K, Xing E, Crowley M. Net.Data to JSP helper. IBM alphaWorks, Scholar
  11. Lu J. Reengineering database applications to EJB based architecture.In: CAiSE * 02, 14th Conference on Advanced Information Systems Engineering. Toronto, May 27-31, 2002.Google Scholar
  12. Miller RJ, Haas LM, Hernández M. Schema mapping as query discovery.In: Proceedings of the Twenty-Sixth International Conference on Very Large Data Bases (VLDB). Cairo, Egypt, Sept. 2000.Google Scholar
  13. Moving from IBM WebSphere 3 to BEA WebLogic Server 5.1. Tech-Metrix Research, Sept. 2000.Google Scholar
  14. Ramanathan C. Providing object-oriented access to existing relational databases, PhD dissertation, Mississippi State University, 1997.Google Scholar
  15. Sun Microsystems, Enterprise JavaBeans 2.0 Specification.,, 2001.Google Scholar
  16. Vermeer MWW, Apers PMG. Reverse engineering of relational database applications. In: Proceedings of the Fourteenth International Conference on Object-Oriented and Entity Relationship Modeling (ER'95), Dec. 1995.Google Scholar
  17. Takagiwa O. et al. Programming with VisualAge for Java Version 3.5. IBM RedBooks,, April 2001.Google Scholar
  18. Yan L, Miller RJ, Haas LM, Fagin R. Data-driven understanding and refinement of schema mappings. SIGMOD May 2001.Google Scholar

Copyright information

© Kluwer Academic Publishers 2003

Authors and Affiliations

  • Terence C. Lau
    • 1
  • Jianguo Lu
    • 2
  • John Mylopoulos
    • 3
  • Kostas Kontogiannis
    • 4
  1. 1.IBM Canada LaboratoryCentre for Advanced StudiesCanada
  2. 2.Department of Computer ScienceUniversity of WindsorCanada
  3. 3.Department of Computer ScienceUniversity of TorontoCanada
  4. 4.Department of Electrical and Computer EngineeringUniversity of WaterlooCanada

Personalised recommendations