DATA EXTRACTION AND TRANSFORMATION WITH FLAT FILE FOR BUSINESS INTEGRATION

Sheng YE, Wei SUN, Zhong TIAN

Abstract

With the development of e-business, the capability of exchanging data in different formats is necessary for integrating heterogeneous enterprise applications. Though XML is becoming the standard communication protocol over the Internet, most enterprise applications today can only process a specific format text data, mostly in a flat file. This paper introduces a round trip transformation technology between flat file and XML, Flat File Adapter. This technology employs a systematic data extraction and formatting method to support the processing of complex format flat file. By using Flat File Adapter, developer can quickly design templates containing the data transformation rules. It can be easily updated when requirements change later. In this paper, we introduce the system architecture, detailed components, and particular data extraction and transformation method. Finally, a sample application in B2B e-procurement solution is also described.

References

  1. Andre Yee, 2001. E-Business Integration pattern, Retrieved Oct. 8, 2003, from http://www.informIT.com
  2. Unidex Inc., Overview of XML Convert and XFlat, Retrieved Oct. 8, 2003, from http://www.unidex.com/
  3. Zamora, Elena M., 1990. Computer method for automatic extraction of commonly specified information from business correspondence, US Patent 4,965,763
  4. Casey, Richard G., Ferguson, David R., 1992. Computerimplemented method for automatic extraction of data from printed forms, US5140650
  5. Wang, Shin-Ywan; Yagasaki, Toshiaki, 1998. Feature extraction system for identifying text within a table image, US5848186
Download


Paper Citation


in Harvard Style

YE S., SUN W. and TIAN Z. (2004). DATA EXTRACTION AND TRANSFORMATION WITH FLAT FILE FOR BUSINESS INTEGRATION . In Proceedings of the Sixth International Conference on Enterprise Information Systems - Volume 1: ICEIS, ISBN 972-8865-00-7, pages 643-646. DOI: 10.5220/0002652106430646


in Bibtex Style

@conference{iceis04,
author={Sheng YE and Wei SUN and Zhong TIAN},
title={DATA EXTRACTION AND TRANSFORMATION WITH FLAT FILE FOR BUSINESS INTEGRATION},
booktitle={Proceedings of the Sixth International Conference on Enterprise Information Systems - Volume 1: ICEIS,},
year={2004},
pages={643-646},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0002652106430646},
isbn={972-8865-00-7},
}


in EndNote Style

TY - CONF
JO - Proceedings of the Sixth International Conference on Enterprise Information Systems - Volume 1: ICEIS,
TI - DATA EXTRACTION AND TRANSFORMATION WITH FLAT FILE FOR BUSINESS INTEGRATION
SN - 972-8865-00-7
AU - YE S.
AU - SUN W.
AU - TIAN Z.
PY - 2004
SP - 643
EP - 646
DO - 10.5220/0002652106430646