Using Automated Database Reverse Engineering for Database Integration

Authors: M. R. Abbasifard, M. Rahgozar, A. Bayati, P. Pournemati

Abstract:

One important problem in today organizations is the existence of non-integrated information systems, inconsistency and lack of suitable correlations between legacy and modern systems. One main solution is to transfer the local databases into a global one. In this regards we need to extract the data structures from the legacy systems and integrate them with the new technology systems. In legacy systems, huge amounts of a data are stored in legacy databases. They require particular attention since they need more efforts to be normalized, reformatted and moved to the modern database environments. Designing the new integrated (global) database architecture and applying the reverse engineering requires data normalization. This paper proposes the use of database reverse engineering in order to integrate legacy and modern databases in organizations. The suggested approach consists of methods and techniques for generating data transformation rules needed for the data structure normalization.

Keywords: Reverse Engineering, Database Integration, System Integration, Data Structure Normalization

Digital Object Identifier (DOI): doi.org/10.5281/zenodo.1333612

References:

[1] Rahgozar M., Oroumchian F., An effective strategy for legacy systems evolution. Journal of Software Maintenance & Evolution. Issue 5, Volume 15,September 2003.
[2] Jean-Luc Hainaut, Introduction to Database Reverse Engineering. LIBDLaboratory of Database Application Engineering Institut d-Informatique - University of Namur; May 2002.
[3] Jean Henrard, Program understanding in Database Reverse Engineering. Thesis Submitted for the degree of Doctor of Science , University of Namur- belgique; August 2003.
[4] Xiaomin Wu, Murray A., Storey M.-A., Lintern R., A reverse engineering approach to support software maintenance. version control knowledge extraction, Proceedings. 11th Working Conference on8-12 Nov. 2004.
[5] Chikofski E., Cross J., Reverse Engineering and design recovery:A taxonomy. IEEE Software, Jan. 1990.
[6] Special issue on Reverse Engineering. IEEE Software, January, 1990.
[7] Rahgozar M., Oroumchian F., Migrating Legacy Indexed Files to Unix- RDBMS environment. Journal of Software Maintenance & Evolution. sept. 2003.
[8] M.P. Reddy, B.E. Prasad, P.G. Reddy,Amar Gupta. A Methodology for Integration of Heterogeneous Databases. IEEE Transactions on knowledge and data engineering. Vol 6 . No. 6. Dec 1994.
[9] J-L. Hainaut, J-M.Hick, J.Henrard, D.Roland, V.Englebert, Knowledge Transfer in Database Reverse Engineering A Supporting Case Study. Institut d'Informatique,University of Namur, rue Grandgagnage,21 - B- 5000 Namur; IEEE 1997.
[10] Casanova M., Amarel de Sa., Designing Entity Relationship Schemas for Conventional Information Systems. in Proc. of Entity-Relationship Approach, pp. 265-278, 1983.
[11] Casanova M., Amaral De Sa., Mapping uninterpreted Schemes into Entity-Relationship diagrams, two applications to conceptual schema design. IBM J. Res. & Dev., Vol. 28, No1, 1984.
[12] Nilsson E., G., The Translation of COBOL Data Structure to an Entity- Rel-type Conceptual Schema. Proceedings of ERA Conference, IEEE/North-Holland 1985.
[13] Rahgozar M., Oroumchian F., Automatic Evolution of of Legacy Data Objects. WSEAS Int. Conf. on Applied Math.& Comp. Science (AMCOS-02), Rio De Janeiro, Oct. ,2002.
[14] Davis K., Arora A., A Methodology for Translating a Conventional File System into an Entity-Relationship Model. Proceedings of ERA, IEEE/North-Holland 1985.
[15] Sabanis N., Stevenson N., Tools and Techniques for Data Remodelling Cobol Applications. Proceedings of the 5th International Conference on Software Engineering and Applications, Toulouse, 7-11 December, pp. 517-529, EC2 Publish 1992.
[16] Blaha M.R., Premerlani W., Observed Idiosyncrasies of Relational Database designs. in Proc. of the 2nd IEEE Working Conference on Reverse Engineering, Toronto, IEEE Computer Society Press, July 1995.
[17] Hainaut Jean-Luc, Chandelon M., Tonneau C., Joris M., Transformational techniques for database reverse engineering, Proceedings of the 12th International Conference on ER Approach, Arlington-Dallas, E/R Institute and Springer-Verlag, LNCS 1993.
[18] Edwards H. M., Munro M., Deriving a Logical Model for a System Using Recast Method. Proceedings of the 2nd IEEE WC on Reverse Engineering, Toronto, IEEE Computer Society Press 1995.
[19] C. Batini, M. Lenzerini, A methodology for database schema integration in the entity relationship model. IEEE Trans. Software Eng. vol. SE-10, no. 6, 1984.
[20] D. M. Dilts, W. Wu, Using knowledge-based technology to integrate CIM databases. IEEE Trans. Knowledge Data Eng., vol. 3, no. 2, June 1991.
[21] Jeong-Mi Kim, JuHum Kwon, Doo-Kwon Baik, RGSN Model for Database Integration. International Conference on Information Systems, 2005.