Abstract

In this paper, an incremental data migration technique is evaluated in the multi-database system based on MySQL with SPIDER storage engine and the improvement of the turn-around times of other operations is proved in this systems. In this method, a large data migration is divided into small data migrations and other operations are inserted between these small data migrations. This technique is easy to implement in the multi-database system.

Highlights

  • Nowadays, database systems are used frequently in every field because the costs of introduction and running of the database system became low

  • One curve is the average of the total execution times of 16 clients

  • It caused by competition among queries and the large data migration which costs long time

Read more

Summary

Introduction

Database systems are used frequently in every field because the costs of introduction and running of the database system became low. Network systems are being developed as well as database systems. Based on these backgrounds, a demand for sharing existent databases system grows. It is difficult to stop existent databases system to reorganize into one large database because database systems usually are used as mission-critical system such as the management system for goods in stock. An integrated system that consists of many existent databases is necessary, such as the multi-database system. Thereby, users can access to any data subset in all existent databases though the multi-database system and this operation can be processed in parallel

Methods
Results
Conclusion
Full Text
Published version (Free)

Talk to us

Join us for a 30 min session where you can share your feedback and ask us any queries you have

Schedule a call