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

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.

[1]  Michael Stonebraker,et al.  Concurrency Control and Consistency of Multiple Copies of Data in Distributed Ingres , 1979, IEEE Transactions on Software Engineering.

[2]  Sujata Banerjee,et al.  Distributed Database Systems in High-Speed Wide-Area Networks , 1993, IEEE J. Sel. Areas Commun..

[3]  Michael Stonebraker,et al.  Mariposa: a new architecture for distributed data , 1994, Proceedings of 1994 IEEE 10th International Conference on Data Engineering.

[4]  Arthur J. Bernstein,et al.  High Throughput Escrow Algorithms for Replicated Databases , 1992, VLDB.

[5]  Sujata Banerjee,et al.  Network latency optimizations in distributed database systems , 1998, Proceedings 14th International Conference on Data Engineering.

[6]  Sakti Pramanik,et al.  Distributed Linear Hashing and Parallel Projection in Main Memory Databases , 1990, VLDB.

[7]  Robert H. Thomas,et al.  A Majority consensus approach to concurrency control for multiple copy databases , 1979, ACM Trans. Database Syst..

[8]  Michael Stonebraker,et al.  Implementation techniques for main memory database systems , 1984, SIGMOD '84.

[9]  Takahiro Hara,et al.  Database Migration: A New Architecture for Transaction Processing in Broadband Networks , 1998, IEEE Trans. Knowl. Data Eng..

[10]  Michael Stonebraker,et al.  The Implementation of Postgres , 1990, IEEE Trans. Knowl. Data Eng..

[11]  Michael Stonebraker,et al.  Mariposa: a wide-area distributed database system , 1996, The VLDB Journal.

[12]  Michael Stonebraker,et al.  The design of POSTGRES , 1986, SIGMOD '86.

[13]  Takahiro Hara,et al.  DB-MAN: a distributed database system based on database migration in ATM networks , 1998, Proceedings 14th International Conference on Data Engineering.

[14]  Richard J. Lipton,et al.  A Massive Memory Machine , 1984, IEEE Transactions on Computers.