Login | Register

XML data transfer between heterogeneous database systems


XML data transfer between heterogeneous database systems

Lin, Qinghong (2003) XML data transfer between heterogeneous database systems. [Graduate Projects (Non-thesis)] (Unpublished)

[thumbnail of MQ85278.pdf]
Text (application/pdf)


This major report presents the design and implementation of XML data transfer, a tool for transferring data between heterogeneous data sources by using XML standards and the related technology. Relational database design focuses on decomposing a flat data structure to a normalized relational model. In reality, the real world objects can be modeled through many different ways as long as they represent the objects and relationship correctly. In today's software development world, multiple vendors have been implementing their own data model through practising the relational theory. Therefore, the data model dealing with the same real world objects are often different. The data exchange between these different software systems is extremely difficult due to the difference of the data models. To resolve the data exchange problem in integration and information sharing among different software systems, XML (Extensible Markup Language) becomes a natural selection as a means to relay the data in the information exchange process. In this report, data is transferred between two sample school administration database systems, which are semantically similar, but have different data models (i.e. schema representations). The transferring is carried out through an intermediate data model as the bridge between these two data sources. The intermediate data model is in XML data format. The mappings are via two XML schemas, one from the source school database to the intermediate data file, another is from the intermediate to the destination school database. The programs are developed using Microsoft .NET and C# programming language. The databases are built on Microsoft SQL Server.

Divisions:Concordia University > Gina Cody School of Engineering and Computer Science > Computer Science and Software Engineering
Item Type:Graduate Projects (Non-thesis)
Authors:Lin, Qinghong
Pagination:viii, 89 leaves : ill. ; 29 cm.
Institution:Concordia University
Degree Name:M. Comp. Sc.
Program:Computer Science
Department (as was):Department of Computer Science
Thesis Supervisor(s):Klasa, Stan
Identification Number:QA 76 M26+ 2003 no.28
ID Code:2356
Deposited By: Concordia University Library
Deposited On:27 Aug 2009 17:27
Last Modified:20 Oct 2022 20:45
Related URLs:
All items in Spectrum are protected by copyright, with all rights reserved. The use of items is governed by Spectrum's terms of access.

Repository Staff Only: item control page

Downloads per month over past year

Research related to the current document (at the CORE website)
- Research related to the current document (at the CORE website)
Back to top Back to top