Proceedings of the International Conference on Advances in Mechanical Engineering and Industrial Informatics

Discussion of the Automatic Migration Scheme of Oracle Database

Authors
Mingli Wu, Xueya Jiao, Yebai Li
Corresponding Author
Mingli Wu
Available Online April 2015.
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)

Volume Title
Proceedings of the International Conference on Advances in Mechanical Engineering and Industrial Informatics
Series
Advances in Engineering Research
Publication Date
April 2015
ISBN
978-94-62520-69-1
ISSN
2352-5401
DOI
10.2991/ameii-15.2015.111How to use a DOI?
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/).

Cite this article

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  -