Research on Heterogeneous Database Transformation

Author

Shudao, Zhou ; Guotao, Zhu ; Yanjie, Wang ; Ye, Shen ; Zanyi, Liu

Author_Institution

Inst. of Meteorol., PLA Univ. of Sci. & Tech., Nanjing, China

Volume

1

fYear

2011

fDate

28-29 March 2011

Firstpage

696

Lastpage

699

Abstract

Access, MySQL, SQL Server and Oracle9i databases are studyed in this paper. Aiming at the characteristics of data types in heterogeneous database, simple but flexible data types matching method is proposed. In the environment of C#.Net, using standard SQL language and binary text file as intermediate data file, heterogeneous database import-and-export system is developped, which is relatively independent to individual DBMSs. The practical application results show that the method is rapid and feasible on data exchange for heterogeneous databases.

Keywords

C language; SQL; distributed databases; network operating systems; C#.Net; DBMS; MySQL; Oracle9i database; SQL server; binary text file; flexible data type matching method; heterogeneous database transformation; import-and-export system; intermediate data file; standard SQL language; Computers; Database systems; Servers; Software; Transforms; XML; Data Processing; Database Transformation; Export; Heterogeneous Database; Iimport;

fLanguage

English

Publisher

ieee

Conference_Titel

Intelligent Computation Technology and Automation (ICICTA), 2011 International Conference on

Conference_Location

Shenzhen, Guangdong

Print_ISBN

978-1-61284-289-9

Type

conf

DOI

10.1109/ICICTA.2011.181

Filename

5750715