Discussion of the Automatic Migration Scheme of Oracle Database

DOI

10.2991/ameii-15.2015.111How to use a DOI?

Keywords

augmented reality; database migration; automatic migration; table structure synchronization

Abstract

As migration technique for table spaces of enterprise database is required in multi-user inventory management systems, in this paper we investigate automatic migration technique when database performance is found declined by our monitoring system. Two methods are discussed, timing automatic migration and semi-automatic migration. Table structure of several databases is modified by DBlink, to keep databases synchronized. In addition, we analyze various factors that must be taken into consideration when do migration. We also verify the methods in practical application, and introduced the technical details. Experiments show that this method is effective.

Copyright

© 2015, the Authors. Published by Atlantis Press.

Open Access

This is an open access article distributed under the CC BY-NC license (http://creativecommons.org/licenses/by-nc/4.0/).

Download article (PDF)

TY  - CONF
AU  - Mingli Wu
AU  - Xueya Jiao
AU  - Yebai Li
PY  - 2015/04
DA  - 2015/04
TI  - Discussion of the Automatic Migration Scheme of Oracle Database
BT  - Proceedings of the International Conference on Advances in Mechanical Engineering and Industrial Informatics
PB  - Atlantis Press
SP  - 597
EP  - 605
SN  - 2352-5401
UR  - https://doi.org/10.2991/ameii-15.2015.111
DO  - 10.2991/ameii-15.2015.111
ID  - Wu2015/04
ER  -