A Multi-Stage Approach to Asymmetric Legacy Information Integration

Y. Tang, J. B. Zhang, C. H. Tan, M. M. Wong, T. J. Ng

Abstract

Ensuring data integrity in the process of integration with heterogeneous legacy systems has proven to be a very challenging task because of the "asymmetric" nature of the integration. This paper first identifies and describes the major issues in the integration process with legacy information systems. A generic five-stage integration approach is then proposed to address the issues in a systematic manner. The proposed data manipulation and infusion methodologies together with the schemata and how they can help isolate the heterogeneity of the integrated systems and provide high transparency to the applications are then discussed. In addition, we shall discuss how event-driven active mechanisms can be applied to ensure a high level of integrity, flexibility, availability and reliability for the asymmetric integration with heterogeneous legacy systems. The proposed framework has been validated in an industrial project, and has enabled the seamless integration and continuous information flow between a new corporate information system and the legacy production and material handling systems.

References

  1. Cui, Y., Widom, J.: Lineage Tracing for General Data Warehouse Transformations. The Int. J. on Very Large DBs, Vol. 12-1, (2003) 41-58.
  2. Kaji, I., Kato, S., Mori, K.: Autonomous Data Consistency for Cooperative Applications to Fairly Ally the Data in Heterogeneous Systems. Proc. Int. Workshop on Autonomous Decentralized Syst. (2000) 196-204.
  3. Lukovic, I., Mogin, P.: An Approach to Relational Database Schema Integration. IEEE Int. Conf. on Syst., Man, and Cybernetics, Vol. 4, (1996) 3210-3215.
  4. Mylopoulos, J., Gal, A., Kontogiannis, K., Stanley, M.: A Generic Integration Architecture for Cooperative Information Systems. Proc. First IFCIS Int. Conf. on Cooperative Inf. Syst., (1996) 208 -217.
  5. Paton, N. and O. Diaz: Active Database Systems. ACM Comput. Surveys, Vol. 31- 1, (1999) 63-103.
  6. Paulraj Ponniah: Data Extraction, Transformation and Loading, in Data Warehousing Fundamentals. Wiley Publication, (2001) 257-290.
  7. Peter McBrien and Alexandra Poulovassilis: Distributed Databases, in Advanced Database Technology and Design. Mario Piattini. London, (2000) 291-327.
  8. Rifaieh, R., Benharkat, N. A.: Query-Based Data Warehousing Tool. Proc. the fifth ACM Int. workshop on Data Warehousing and OLAP, (2002) 35-42.
  9. Roantree, M., Keane, J., Murphy, J.: A Three-Layer Model for Schema Management in Federated DBs. Proc. 13th Hawaii Int. Conf. on Syst. Sci., (1997) 44-53.
  10. Sheth, A. and Larson, J.: Federated Database Systems for Managing Distributed Heterogeneous and Autonomous Databases, ACM Comput. Surveys, Vol. 22-3, (1990) 183-236.
  11. Song, W.W.: Integration Issues in Information System Reengineering. Proc. 20th Int. Compt. Software and Applications Conf., (1996) 328 -335.
  12. Thiran, P., Hainaut, J.-L., Bodart, S., Deflorenne, A., Hick, J.-M.: Interoperation of Independent, Heterogeneous and Distributed Databases. Proceedings. 3rd IFCIS Int. Conf. on Cooperative Inf. Syst., (1998) 54 -63.
  13. Turker, C., Conrad, S.: Towards Maintaining Integrity of Federated Databases. Proc. the 3rd Basque Int. Workshop on Inf. Technol., BIWIT 7897, (1997) 93-100.
  14. Vassiliadis, P., Simitsis, A.: Conceptual Modeling for ETL Processes. Proc. the 5th ACM Int. workshop on Data Warehousing and OLAP, (2002) 14-21.
Download


Paper Citation


in Harvard Style

Tang Y., B. Zhang J., H. Tan C., M. Wong M. and J. Ng T. (2004). A Multi-Stage Approach to Asymmetric Legacy Information Integration . In Proceedings of the 2nd International Workshop on Verification and Validation of Enterprise Information Systems - Volume 1: VVEIS, (ICEIS 2004) ISBN 972-8865-03-1, pages 50-59. DOI: 10.5220/0002671100500059


in Bibtex Style

@conference{vveis04,
author={Y. Tang and J. B. Zhang and C. H. Tan and M. M. Wong and T. J. Ng},
title={A Multi-Stage Approach to Asymmetric Legacy Information Integration},
booktitle={Proceedings of the 2nd International Workshop on Verification and Validation of Enterprise Information Systems - Volume 1: VVEIS, (ICEIS 2004)},
year={2004},
pages={50-59},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0002671100500059},
isbn={972-8865-03-1},
}


in EndNote Style

TY - CONF
JO - Proceedings of the 2nd International Workshop on Verification and Validation of Enterprise Information Systems - Volume 1: VVEIS, (ICEIS 2004)
TI - A Multi-Stage Approach to Asymmetric Legacy Information Integration
SN - 972-8865-03-1
AU - Tang Y.
AU - B. Zhang J.
AU - H. Tan C.
AU - M. Wong M.
AU - J. Ng T.
PY - 2004
SP - 50
EP - 59
DO - 10.5220/0002671100500059