Loading XML Data into Relational Databases Architecture of a System Including a (Semi-) Automatic Matching
Boubaker Kahloula, Karim Bouamrane
Journal of Information Technology Review, Vol. 2, No. 2, 2011.
DOI: 
Link: http://www.dline.info/jitr/fulltext/v2n2/1.pdf
Abstract:
Information systems that are widely distributed are characterized by inherent heterogeneity. This is mainly due to the fact that these systems have different purposes, they have been implemented by different developers and they run on different systems platforms. Data stored in these systems are imported and exported permanently from one system to another one to enable them to communicate and exchange information. These systems import also data regularly from other available web applications and services. Data are generally formatted into XML (eXtensible Markup Language) and the target system is most often a relational database. Data contained in XML files with a name and given format must be reformatted to fit with the target format and most of the time they need to be renamed to be stored and used at within the target schema of the database. In this paper, we present the architecture of a system that allows loading XML data into a relational database. We will focus more in detail on the data integration module that is responsible of matching the imported data with the local database schema.