Title :
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
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;
Conference_Titel :
Intelligent Computation Technology and Automation (ICICTA), 2011 International Conference on
Conference_Location :
Shenzhen, Guangdong
Print_ISBN :
978-1-61284-289-9
DOI :
10.1109/ICICTA.2011.181
