The Research of Heterogeneous Database Migration Based on XML and Middleware

Abstract:

For many government departments or enterprises to use new system upgrades, data transfer between heterogeneous database problem, this paper puts forward a kind of heterogeneous database based on XML and middleware model of data migration.The model by using XML technology to build a middleware, through the ODBC interface connected to the source database and target database.After extracting data from the source database into a unified XML documents, again according to the mapping relationship between old and new database and XSL document, and converts it to meet the needs of the target XML document, the target database and load the data to the target database.The model including data extraction, transformation, validation, write, and other functions, is a cross-platform, easy extensibility and reusability.

• Periodical: Applied Mechanics and Materials (Volumes 556-562)
• Pages: 3350-3353
• DOI: https://doi.org/10.4028/www.scientific.net/AMM.556-562.3350
• Online since: May 2014
• Authors: Sai Dong Lv*, Yao Wen Xia
• Keywords: Data Migration, Heterogeneous Database, Middle-Ware, Odbc, XML

References

[1] Mark. Humphries, Michael. Hawkins, michelle. Data warehousing: the structure and implementation [M]. Beijing: social sciences academic press, (2005).

[2] Zhang Yunyong , Zhang Zhijiang, Liu Jinde et al. Middleware technology principle and application [J]. Beijing: tsinghua university press, 2006: 5-9.

[3] Jiang Yong, Tan Huailiang Li Guangwen. Data of a distributed heterogeneous database based on XML middleware shard strategy research [J]. Journal of computer applications and software, 2009, 11 (26).

[4] Meng Xiaofeng. XML data management concept and technology [M]. Beijing: tsinghua university press, 2009.

[5] Li Zhongjuan. Middleware based on XML data migration research [D]. Harbin: Harbin engineering university, 2007.

[6] Qiao Yang. Three layer application architecture to realize social security information system [J]. Journal of information research, 2009, 35 (1) : 4-7.

[7] Zhang Yueting Han Yang, Zhang Hongyu. C # database system development case selection [M]. Beijing: people's posts and telecommunications publishing house, 2008.

[8] Xu Hongji Zhang Anjiang, Li Jianye. A cross-platform database access interface layer model [J]. The design and implementation of computer application research, 2005, 8: 144-146.

[9] Wei Zukuan Jiang Lijuan, jin hong. Comparative study on Yin database access technology[J] modern computer, 2009, 12: 32-35.