Design and implementation of DB-MANα: does database migration work well in a real environment?

Authors:
Toyokazu Akiyama;Shinobu Sakai;Akimichi Umigai;Takahiro Hara;Masahiko Tsukamoto;Shojiro Nishio
Affiliations:
Osaka University, 5-1 Mihogaoka, Ibaraki, Osaka 567-0047, Japan;Canon Inc., Japan;Toyota Motor Corporation, Japan;Osaka University, 2-1 Yamadaoka, Suita, Osaka 565-0871, Japan;Osaka University, 2-1 Yamadaoka, Suita, Osaka 565-0871, Japan;Osaka University, 2-1 Yamadaoka, Suita, Osaka 565-0871, Japan
Venue:
ADC '02 Proceedings of the 13th Australasian database conference - Volume 5
Year:
2002

Citing 11
Cited 0

The design of POSTGRES

SIGMOD '86 Proceedings of the 1986 ACM SIGMOD international conference on Management of data
Distributed linear hashing and parallel projection in main memory databases

Proceedings of the sixteenth international conference on Very large databases
A Majority consensus approach to concurrency control for multiple copy databases

ACM Transactions on Database Systems (TODS)
Implementation techniques for main memory database systems

SIGMOD '84 Proceedings of the 1984 ACM SIGMOD international conference on Management of data
The Implementation of POSTGRES

IEEE Transactions on Knowledge and Data Engineering
Database Migration: A New Architecture for Transaction Processing in Broadband Networks

IEEE Transactions on Knowledge and Data Engineering
Mariposa: A New Architecture for Distributed Data

Proceedings of the Tenth International Conference on Data Engineering
DB-MAN: A Distributed Database System based on Database Migration in ATM Networks

ICDE '98 Proceedings of the Fourteenth International Conference on Data Engineering
Network Latency Optimizations in Distributed Database Systems

ICDE '98 Proceedings of the Fourteenth International Conference on Data Engineering
High Throughput Escrow Algorithms for Replicated Databases

VLDB '92 Proceedings of the 18th International Conference on Very Large Data Bases
Mariposa: a wide-area distributed database system

The VLDB Journal — The International Journal on Very Large Data Bases

Quantified Score

Hi-index	0.00

Visualization

Abstract

Due to the recent expansion of network bandwidth, the data propagation delay has become a significant factor which influences the system performance in place of the data transmission delay. Based on this fact, we have proposed a new technology to reduce the bad influence of propagation delay on the performance of distributed database system by relocating dynamically the database through networks, which we call database migration. Furthermore, we have proposed a database relocation method to choose the transaction processing method between the conventional database fixed method and the proposed database migration method by giving consideration to the transaction complexity. In this paper, we explain our distributed database system with database migration mechanism based on these proposals, and the implementation of the DB-MANα system as a prototype system. The DB-MANα system reduces the database migration time by using a main memory database technique, which induces us to add a backup management mechanism for migratory databases. Moreover, we show some measurement results for the performance evaluation of the DB-MANα system. The results show that the implemented system works well in a practical environment.