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

Analysis Of User Throughput Based Predictive Mobility Load Balancing Using Logarithmic Regression Of Reference Signal Received Quality In Long Term Evolution Radio Access Network

The improvement of Long Term Evolution (LTE) radio access network services is affecting the increased value of traffic load in its network, which is causing traffic unbalance between cells in LTE Radio Access Network (RA...

Breast Cancer Image Segmentation Using K-Means Clustering Based on GPU Cuda Parallel Computing

Image processing technology is now widely used in the health area, one example is to help the radiologist to analyze the result of MRI (Magnetic Resonance Imaging), CT Scan and Mammography. Image segmentation is a proces...

Analisis Kebutuhan Bandwidth Pada Pemanfaatan Web Streaming Justin.tv Sebagai Media E-Learning Dengan Menggunakan Wirecast Dan Desktop Presenter

Perkembangan teknologi informasi begitu cepat seperti sekarang telah banyak mengubah sudut pandang banyak orang, antara lain sudut pandang orang untuk mengubah dunia pendidikan menjadi lebih baik. Salah satu contohnya pe...

Persebaran Layanan dan Infrastruktur Telekomunikasi Provinsi Papua

Services and telecommunications infrastructure is an important part of modern life such as education, government, economics and so on. Hence the importance of the telecommunications sector in Indonesia as an archipelagic...

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 155
  • 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