Teknik Migrasi Data Lintas DBMS dengan Menggunakan Metadata

Journal Title: Jurnal INFOTEL - Year 2015, Vol 7, Issue 2

Abstract

Data migration process is usually required when there is a change in system, format or storage type. Nowadays, we are familiar with some technique and tools to perform data migration, for example CSV file, ODBC, SQLDump etc.Unfortunately, not all of this technique are applicable when it comes to migrating data between two different DBMS. This research give an overview about one particular data migration technique that is applicable for cross DBMS data migration. This technique utilizes metadata that exist in each DBMS. The data migration process described here consist of three stages, namely capture, convert and construct. A prototype is developed to test the proposed data migration technique. Using HR schema, a cross DBMS data migration test between Oracle and MySQL is conducted. Using this technique, full schema data migration requires an average time of 20,43 seconds to migrate data from Oracle to MySQL or an average time of 12,96 seconds for opposite scenario. As for patial data migration, an average time of 5,59 seconds is required to migrate data from Oracle to MySQL or an average time of 2,19 seconds for opposite scenario.

Authors and Affiliations

Keywords

Related Articles

Peramalan Kunjungan Wisatawan Mancanegara Menggunakan Generalized Regression Neural Networks

Forecasting tourism demand are very important for the government and industry, as forecasting the basis for effective policy planning. This research is using Generalized Regression Neural Network (GRNN) to forecasting...

Pengendalian Motor Servo Yang Terintegrasi Dengan Webcam Berbasis Internet Dan Arduino

Seperti halnya internet, yang merupakan suatu jaringan global yang dapat mengkomunikasikan satu komputer dengan komputer yang lain, di manapun lokasi komputer tersebut berada, maka dapat diaplikasikan suatu proses pengen...

Analisis Link Budget Non Direction Beacon pada Komunikasi Jalur Lintasan Penerbangan

One of the propagation attenuation that should be calculate when using radio communication in air navigation is atmospheric propagation attenuation at night. The presence of propagation attenuation will decrease acceptan...

Analysis of Position Angle of Arrival in Multipath Fading Channel using Correlated Double Ring Channel Model for VANET Communications

Correlated Double Ring channel modeling in the mobile to mobile communication system (M2M) and vehicular based communication system was pointed out. This modeling required the transmitter and receiver were randomly movin...

Implementasi Location Based Service Rute Objek Wisata Tegal

Tegal is one of area in Central Java which has many tourism place be managed by Government or private parties. Many tourists from tegal who are confused to decide on appropriate visiting tourist spots, this is due to lac...

Download PDF file
  • EP ID EP195714
  • DOI 10.20895/infotel.v7i2.41
  • Views 154
  • Downloads 0

How To Cite

(2015). Teknik Migrasi Data Lintas DBMS dengan Menggunakan Metadata. Jurnal INFOTEL, 7(2), 137-142. https://www.europub.co.uk/articles/-A-195714