A technique for on-line data migration

In recent years, more emphasis is placed on the performance of massive data bases. It is often required not only that database systems provide high thr oughputs with rapid response times, but also that they are fully available 24-hour-per-day and 7-days-per-week. Requirements for throughput and respon se time can be satisfied by upgrading the hardware. As a result, databases in the old hardware environment have to be moved to the now one. Moving a d atabase, however, generally requires taking the database off line fur a lon g time, which is unacceptable for numerous applications. In this paper, a v ery practical and important subject is addressed: how to upgrade the hardwa re on line, i.e., how to move a database from an old hardware environment t o a new one concurrently with users' reading and writing of the database. A technique for this purpose is proposed. We have implemented a prototype ba sed on this technique. Our experiments with the prototype shown that compar ed with conventional off-line approach, the proposed technique could give a performance improvement by more than 85% in the query-bound environment an d 40% in the update-bound environment.