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

Investigation of E-Health Acceptance Factor Case Study in Rural Area of Central Kalimantan

The E-Health is used to support information technology to maximize the tasks and medical services in the hospital. However, the hospital’s management still have some issues due to E-Health implementation, particularly in...

Implementasi Konten E-Learning Mata Kuliah Fisika

Physics course that held at Diploma of Computer Engineering in School of Applied Science, Telkom University is a prerequisite courses which has basic concept and theory. This condition makes Physics get more attention as...

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...

Webcam, Arduino, Website, HTML, Internet, arduino ethernet shields

Sistem monitoring pada pintu gerbang merupakan bagian yang penting dalam meningkatkan sistem keamanan. Teknologi yang cocok untuk diaplikasikan dipintu gerbang adalah teknologi RFID (Radio Frequency Identification), kare...

Perancangan dan Implementasi Modul Praktikum Pengenalan Tata Letak dan Port I/O pada Mother board berbasis Teknologi Augmented Reality

The Enhancement of computer-based technology develops very fast. As time goes by, these advances make significant influence on the changes of teaching methods. Practicum is a form of teaching that provides a real learni...

Download PDF file
  • EP ID EP195714
  • DOI 10.20895/infotel.v7i2.41
  • Views 156
  • 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