Wrapper-based evolution of legacy information systems

ABSTRACT

System evolution most often implies the integration of legacy components, such as databases, with newly developed ones, leading to mixed architectures that suffer from severe heterogeneity problems. For instance, incorporating a new program in a legacy database application can create an integrity mismatch, since the database model and the program data view can be quite different (e.g. standard file model versus OO model). In addition, neither the legacy DBMS (too weak to address integrity issues correctly) nor the new program (that relies on data server responsibility) correctly cope with data integrity management. The component that can reconciliate these mismatched subsystems is the R/W wrapper, which allows any client program to read, but also to update the legacy data, while controlling the integrity constraints that are ignored by the legacy DBMS.This article describes a generic, technology-independent, R/W wrapper architecture, a methodology for specifying them in a disciplined way, and a CASE tool for generating most of the corresponding code.The key concept is that of implicit construct, which is a structure or a constraint that has not been declared in the database, but which is controlled by the legacy application code. The implicit constructs are elicited through reverse engineering techniques, and then translated into validation code in the wrapper. For instance, a wrapper can be generated for a collection of COBOL files in order to allow external programs to access them through a relational, object-oriented or XML interface, while offering referential integrity control. The methodology is based on a transformational approach that provides a formal way to build the wrapper schema and to specify inter-schema mappings.

REFERENCES

• 1: Aiken, P., 1996. Data Reverse Engineering. McGraw-Hill.
• 2: Balzer, R. 1981. Transformational implementation : An example. IEEE TSE 7, 1, 3--14.
• 3: Sonia Bergamaschi , Silvana Castano , Maurizio Vincini , Domenico Beneventano, Semantic integration of heterogeneous information sources, Data & Knowledge Engineering, v.36 n.3, p.215-249, March 2001 [doi>10.1016/S0169-023X(00)00047-1]
• 4: M. R. Blaha , W. J. Premerlani, Observed idiosyncracies of relational database designs, Proceedings of the Second Working Conference on Reverse Engineering, p.116, July 14-16, 1995
• 5: Athman Bouguettaya , Ahmed K. Elmagarmid , Boualem Benatallah, Interconnecting Heterogeneous Information Systems, Kluwer Academic Publishers, Norwell, MA, 1998
• 6: Brodie, M. and Stonebraker, M. 1995. Migrating Legacy Systems, Morgan Kaufmann.
• 7: Carey, M. J., Florescu, D., Zachary, G. I., and Ying, L. 2000. XPERANTO: Publishing Object-Relational Data as XML. In Proceedings of WebDB (Informal Proceedings), 105--110.
• 8: H. M. Edwards , M Munro, Deriving a logical data model for a system using the RECAST method, Proceedings of the Second Working Conference on Reverse Engineering, p.126, July 14-16, 1995
• 9: Vincent Englebert , Jean-Luc Hainaut, DB-main: a next generation meta-case, Information Systems, v.24 n.2, p.99-112, April 1999 [doi>10.1016/S0306-4379(99)00007-1]
• 10: Mary Fernández , Wang-Chiew Tan , Dan Suciu, SilkRoute: trading between relations and XML, Computer Networks: The International Journal of Computer and Telecommunications Networking, v.33 n.1-6, p.723-745, June 2000
• 11: Stephen F. Fickas, Automating the transformational development of software, IEEE Transactions on Software Engineering, v.11 n.11, p.1268-1277, Nov. 1985 [doi>10.1109/TSE.1985.231878]
• 12: Hector Garcia-Molina , Yannis Papakonstantinou , Dallan Quass , Anand Rajaraman , Yehoshua Sagiv , Jeffrey Ullman , Vasilis Vassalos , Jennifer Widom, The TSIMMIS Approach to Mediation: Data Models and Languages, Journal of Intelligent Information Systems, v.8 n.2, p.117-132, March/April 1997 [doi>10.1023/A:1008683107812]
• 13: Goetz Graefe, Query evaluation techniques for large databases, ACM Computing Surveys (CSUR), v.25 n.2, p.73-169, June 1993 [doi>10.1145/152610.152611]
• 14: Jean-Luc Hainaut , C. Tonneau , M. Joris , M. Chandelon, Schema Transformation Techniques for Database Reverse Engineering, Proceedings of the 12th International Conference on the Entity-Relationship Approach: Entity-Relationship Approach, p.364-375, December 15-17, 1993
• 15: Jean-Luc Hainaut , Jean Henrard , Jan-Marc Hick , Didier Roland , Vincent Englebert, Database Design Recovery, Proceedings of the 8th International Conference on Advances Information System Engineering, p.272-300, May 20-24, 1996
• 16: Hainaut, J.-L. 2002. Introduction to Database Reverse Engineering. LIBD Lecture Notes, University of Namur. http://www.info.fundp.ac.be/~dbm/publication/2002/DBRE-2002.pdf; October 2005.
• 17: Hainaut, J.-L. 2005. Transformation-Based Database Engineering. In Transformation of Knowledge, Information and Data: Theory and Applications. P. van Bommel, Ed. IDEA Group, 1--28.
• 18: Jean Henrard , Jean-Luc Hainaut, Data Dependency Elicitation in Database Reverse Engineering, Proceedings of the Fifth European Conference on Software Maintenance and Reengineering, p.11, March 14-16, 2001
• 19: J. Henrard , J-M. Hick , P. Thiran , J-L. Hainaut, Strategies for Data Reengineering, Proceedings of the Ninth Working Conference on Reverse Engineering (WCRE'02), p.211, October 29-November 01, 2002
• 20: Hick, J.-M., Englebert, V., Henrard, J., Roland, D., and Hainaut, J.-L. 2004. The DB-MAIN Database Engineering CASE Tool (version 7.1)---Functions Overview, DB-MAIN Technical Manual, Institut d'Informatique, University of Namur. http://www.rever-sa.com/DISTRIBUTION/VERSION.7/DB-MAIN-Reference-Manual.pdf; October 2005
• 21: Lawrence, R., Barker, K., and Adil, A. 1998. Simulating MDBS Transaction Management Protocols. In Proceedings of the CAINE Conference.
• 22: Heeseok Lee , Cheonsoo Yoo, A form driven object-oriented reverse engineering methodology, Information Systems, v.25 n.3, p.235-259, May 2000 [doi>10.1016/S0306-4379(00)00017-X]
• 23: Lim, E. P. and Lee, H. K. 1999. Export Database Derivation in Object-Oriented Wrappers. Inform. Softw. Tech. 41, Elsevier, 183--196.
• 24: Stéphane Lopes , Jean-Marc Petit , Farouk Toumani, Discovering interesting inclusion dependencies: application to logical database tuning, Information Systems, v.27 n.1, p.1-19, March 2002 [doi>10.1016/S0306-4379(01)00027-8]
• 25: Yoshifumi Masunaga, A Relational Database View Update Translation Mechanism, Proceedings of the 10th International Conference on Very Large Data Bases, p.309-320, August 27-31, 1984
• 26: Alexandra Poulovassilis , Peter Mc. Brien, A general formal framework for schema transformation, Data & Knowledge Engineering, v.28 n.1, p.47-71, Oct. 30, 1998 [doi>10.1016/S0169-023X(98)00013-5]
• 27: Functional and embedded dependency inference: a data mining point of view, Information Systems, v.26 n.7, p.477-506, November 2001 [doi>10.1016/S0306-4379(01)00032-1]
• 28: Jean-Marc Petit , Jacques Kouloumdjian , Jean-Francois Boulicaut , Farouk Toumani, Using Queries to Improve Database Reverse Engineering, Proceedings of the13th International Conference on the Entity-Relationship Approach, p.369-386, December 13-16, 1994
• 29: Terry A. Halpin , Henderik Alex Proper, Database Schema Transformation and Optimization, Proceedings of the 14th International Conference on Object-Oriented and Entity-Relationship Modelling, p.191-203, December 12-15, 1995
• 30: Otto Rauh , Eberhard Stickel, Standard Transformations for the Normalization of ER Schemata, Proceedings of the 7th International Conference on Advanced Information Systems Engineering, p.313-326, June 12-16, 1995
• 31: Ritsch, H. and Sneed, H. 1993. Reverse Engineering Programs via Dynamic Analysis. In Proceedings of the 1st IEEE Working Conf. on Reverse Engineering. Baltimore, IEEE Computer Society Press, 192--201.
• 32: Arnon Rosenthal , David S. Reiner, Theoretically Sound Transformations for Practical Database Design, Proceedings of the Sixth International Conference on Entity-Relationship Approach, p.115-131, November 09-11, 1987
• 33: Wallace A. Skip Ross, Hewlett-Packard's migration to client/server architecture, Distributed computing: implementation and management strategies, Prentice-Hall, Inc., Upper Saddle River, NJ, 1994
• 34: Mary Tork Roth , Peter M. Schwarz, Don't Scrap It, Wrap It! A Wrapper Architecture for Legacy Data Sources, Proceedings of the 23rd International Conference on Very Large Data Bases, p.266-275, August 25-29, 1997
• 35: Jayavel Shanmugasundaram , Jerry Kiernan , Eugene J. Shekita , Catalina Fan , John Funderburk, Querying XML Views of Relational Data, Proceedings of the 27th International Conference on Very Large Data Bases, p.261-270, September 11-14, 2001
• 36: Tim Souder , Spiros Mancoridis, A Tool for Securely Integrating Legacy Systems into a Distributed Environment, Proceedings of the Sixth Working Conference on Reverse Engineering, p.47, October 06-08, 1999
• 37: Ph. Thiran , J-L. Hainaut, Wrapper Development for Legacy Data Reuse, Proceedings of the Eighth Working Conference on Reverse Engineering (WCRE'01), p.198, October 02-05, 2001
• 38: Philippe Thiran , Geert-Jan Houben , Jean-Luc Hainaut , Djamal Benslimane, Updating Legacy Databases through Wrappers: Data Consistency Management, Proceedings of the 11th Working Conference on Reverse Engineering (WCRE'04), p.58-67, November 08-12, 2004
• 39: Philippe Thiran , Jean-Luc Hainaut , Geert-Jan Houben, Database Wrappers Development: Towards Automatic Generation, Proceedings of the Ninth European Conference on Software Maintenance and Reengineering, p.207-216, March 21-23, 2005 [doi>10.1109/CSMR.2005.22]
• 40: Thiran, Ph., Estievenart, F., Hainaut, J.-L. and Houben, G. J. 2005b. A Generic Framework for Extracting XML Data from Legacy Databases. Journal of Web Engineering, 4, 3, Rinton Press, 205--223.
• 41: Weiser, M. 1984. Program Slicing, IEEE TSE 10, 352--357.
• 42: Wu, B., Lawless, D., Bisbal, J., Grimson, J., Wad, V., O'sullivan, D., and Richardson, R. 1997. Legacy System Migration: A Legacy Data Migration Engine, In Proceedings of the 17th International Database Conference (DATASEM '97), Ed. Czechoslovak Computer Experts, 129--138.
• 43: Hongji Yang , K. Bennett, Acquisition of ERA models from data intensive code, Proceedings of the International Conference on Software Maintenance, p.116, October 17-20, 1995

INDEX TERMS

Primary Classification:
  D. Software
  D.2 SOFTWARE ENGINEERING
      D.2.7 Distribution, Maintenance, and Enhancement
          Subjects: Restructuring, reverse engineering, and reengineering

Additional Classification:
  D. Software
  D.2 SOFTWARE ENGINEERING
        D.2.12 Interoperability
            Subjects: Data mapping

  H. Information Systems
  H.2 DATABASE MANAGEMENT
      H.2.5 Heterogeneous Databases

General Terms:
Design, Management, Reliability

Keywords:
CASE tool, Schema transformation, data consistency, data reverse-engineering, evolution, legacy database, wrapper