Header menu link for other important links
X
Dynamic data migration for distributed databases across the network
, M. Monica
Published in
2013
Volume: 8
   
Issue: 15
Pages: 1855 - 1861
Abstract
This paper presents the idea of automation of transfer of data design as well as data sets from one Data Base Management System (DBMS) to other across the network. At the source side, the user selects a given RDBMS like Oracle, MS SQL server, DB2, Sybase etc. and interrogates to get a list of tables present in the system. The user has to choose a table, select the columns of the table to migrate and sets up a filter condition for the records to pick. The user also specifies the destination RDBMS system that need not be the same type as the source.The definition of the table selected and its records are read by the application, converted into socket object and transmitted to the destination side application (server) using the network. The destination side application receives the Object, parses them and creates the required tables and records in the destination RDBMS. This proposed data migration model will be useful for an administrator to switch from one DBMS system to another as well to enable efficient dynamic data migration with minimal overload; hence the entire data conversion becomes reliable, fast and efficient. © Research India Publications.
About the journal
JournalInternational Journal of Applied Engineering Research
ISSN09734562