Using Automated Database Reverse Engineering for Database Integration
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.
[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.
[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.
@article{"International Journal of Information, Control and Computer Sciences:56414", author = "M. R. Abbasifard and M. Rahgozar and A. Bayati and P. Pournemati", title = "Using Automated Database Reverse Engineering for Database Integration", 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", volume = "2", number = "7", pages = "2418-5", }
