Automated EJB client code generation using database query rewriting

Proceedings of the International Database Engineering and Applications Symposium, IDEAS

Volumn , Issue , 2003, Pages 308-317

  Lu, Jianguo ^a   Mylopoulos, John ^b  

^a UNIVERSITY OF WINDSOR   (Canada)

^b UNIVERSITY OF TORONTO   (Canada)

Author keywords

Enterprise JavaBean; Object relational mapping; query rewriting; software reengineering

Indexed keywords

AUTOMATIC GENERATION; ENTERPRISE JAVABEAN; OBJECT-RELATIONAL MAPPING; QUERY REWRITING USING VIEWS; QUERY REWRITINGS; SOFTWARE INDUSTRY; SOFTWARE REENGINEERING; WEB INFORMATION SYSTEMS;

DATABASE SYSTEMS; NETWORK COMPONENTS; REENGINEERING; SOFTWARE ENGINEERING;

QUERY PROCESSING;

EID: 84879112754     PISSN: 10988068     EISSN: None     Source Type: Conference Proceeding    
DOI: 10.1109/IDEAS.2003.1214941     Document Type: Conference Paper

References (36)

1. R.S. Arnold, editor. Software Reengineering, Los Alamitos, CA, 1993. IEEE Computer Society Press.
2. Andreas Behm and Andreas Geppert and Klaus R. Dittrich, On the Migration of Relational Schem as and Data to Object-Oriented Database Systems, in Proc. 5th International Conference on Re-Technologies for Information Systems, 13-33, 1997.
3. S. Bergamaschi and A. Garuti and C. Sartori and A. Venuta, The object wrapper: an object oriented interface for relational databases, In Euromicro 1997.
4. Kyle Brown, Handling N-ary relationships in VisualAge for Java, http://www.ibm.com/vadd, August 2000.
5. Elliot Chikofsky and James Cross. Reverse Engineering and Design Recovery: A Taxonomy. IEEE Software, 7(1): 13-17, January 1990.
6. Chang, Y., Raschid, L. and Dorr, B., Transforming queries from a relational schema to an equivalent object schema: a prototype based on F-logic, Proceedings of the International Symposium on Methodologies for Intelligent Systems, 1994.
7. Surajit Chaudhuri, Ravi Krishnamurthy, Spyros Potamianos, Kyuseok Shim, Optimizing Queries with materialized views, ICDE 1995.
8. Cohen, Y.; Feldman, Y.A., Automatic high-quality reengineering of datab ase programs by temporal abstraction, Proceedings of the 1997 International Conference on Automated Software Engineering (ASE '97) (formerly: KBSE
9. Fong, J., Converting Relational to Object-Oriented Databases. SIGMOD Record, Vol.26, No. 1, March 1997.
10. H. Gupta, I. S. Mumick, Selection of views to materialize under a maintenance cost constraint, in Proceedings of ICDT, pages 453-470, 1999.
11. H. Gupta, Selection of views to materialize in a data warehouse, in Proceedings of ICDT, pages 98-112, 1997.
12. IBM, IBM Net.Data Reference, Version 7, http://www4.ibm.com/software/ data/net.data/, June 2001 Edition.
13. IBM, Websphere Commerce Suite Version 5.1: An introduction to the programming model, IBM white paper, Feb 2001.
14. IBM, VisualAge for Java 3.5, IBM, 2001.
15. In2j, Automated tool for migrating Oracle PL/SQL into Java, www.in2j.com, April, 2001.
16. Ivar Jacobson , Fredrik Lindström, Reengineering of old systems to an object-oriented architecture, OOPSLA 1991, ACM SIGPLAN Notices, Volume 26 Issue 11.
17. IPlanet, Migration Guide, iPlanet Application Server, Version 6.0, www.iplanet.com, May 2000.
18. J. Jahnke and W. Schafer and A. Zundorf, A Design Environment for Migrating Relational to Object Oriented Database Systems, In Proceedings of the International Conference on Software Maintenance, IEEE Computer Society Press, 163-170, 1996.
19. Jianguo Lu, Reengineering Database Applications to EJB based architecture, CAiSE*02, 14th Conference on Advanced Information Systems Engineering, Toronto, May 27-31, 2002
20. Yannis Kotidis, Nick Roussopoulos, DynaMat: A Dynamic View Management System for Data Warehouses, SIGMOD 99, June.
21. Terry Lau, Jianguo Lu, Erik Hedges, Emily Xing, Migrating E-commerce Database Applications to an Enterprise Java Environment, CASCON'01.
22. Terry Lau, Jianguo Lu, John Mylopoulos, Erik Hedges, Kostas Kontogiannis, Emily Xing, and Mark Crowley, Net.Data to JSP Helper, IBM alphaWorks, www.alphaworks.ibm.com/tech/netdatatojsp, 2001.
23. Terry Lau, Jianguo Lu, John Mylopoulos, Kostas Kontogiannis, Migrating E-commerce Database Applications to an Enter prise Java Environment, Journal of Information Systems Frontiers, 2002.
24. Alon Levy, Anand Rajaraman, Joann J. Ordille, Querying heterogeneous information sources using source descriptions. In proceeding s of the international conference on Very Large Data Bases, Bombay, India, 1996.
25. Alon Levy, Answering queries using views: a survey, VLDB Journal 2001.
26. Chen Li, Mayank Bawa, Jeffrey D. Ullman, Minimizing view sets without losing query-answering power, ICDT'01.
27. R. J. Miller, L. M. Haas and M. Hernández. Schema Mapping as Query Discovery. VLDB 2000.
28. Wie Ming Lim and John Harrison, An Integrated Database Reengineering Architecture-A Generic Approach, Proceedings of the 1996 Australian Software Engineering Conference (ASWEC '96).
29. Rachel Pottinger, Alon Y. Levy, A Scalable Algorithm for Answering Queries Using Views, VLDB 2000.
30. William J. Premerlani, Michael R. Blaha, An approach for reverse engineering of relational databases, CACM, 1994 Vol 37(5).
31. Chandrashekar Ramanathan, Providing Object-Oriented Access To Existing Relational Databases, PhD dissertation, Mississippi State University, 1997.
32. Sun, Enterprise JavaBeans 2.0 Specification, www.java.sun.com, 2001.
33. Tech Metrix, Moving from IBM Websphere 3 to BEA WebLogic Server 5.1, White Paper, TechMetrix Research, September 2000.
34. Jeffrey D. Ullman, Principles of Database and Knowledge-base Systems, Volumes I, II, Computer Science Press, Rockville MD, 1989.
35. M. W. W. Vermeer & P. M. G. Apers, Re verse engineering of relational database applications, in Proceedings Fourteenth International Conference on Object-Oriented and EntityRelationship Modeling (ER'95). LNCS 1021.
36. L. Yan, R. J. Miller, L. M. Haas and R. Fagin. Data-Driven Understanding and Refinement of Schema Mappings, SIGMOD, May 2001.