Incremental Data Migration for Multi-Database Systems Based on MySQL with SPIDER Storage Engines
Tóm tắt
In this paper, an incremental data migration technique is evaluated in the multi-database system based on MySQL with SPIDER storage engine and the improvement of the turn-around times of other operations is proved in this systems. In this method, a large data migration is divided into small data migrations and other operations are inserted between these small data migrations. This technique is easy to implement in the multi-database system.
Tài liệu tham khảo
B. Salzberg, and A. Dimock, Principles of Transaction-Based On-line Reorganization, in Proc. 18th International Conf. on Very Large Data Bases (1992), pp. 511–520.
K. Achyutuni, E. Omiecinski, and S. Navathe, Two techniques for on-line index modification in shared nothing parallel database, in Proc. the 1996 ACM SIGMOD International Conf. on Management of Data (1996), pp. 124–136.
E. Omiecinski, Concurrent File Reorganization: Clustering, Conversion and Maintenance, Data Engineering Bulletin, 19(2) (1996), pp. 25–32.
C. Zou and B. Salzberg, Safely and Efficiently Updating References During On-line Reorganization, in Proc. 24th International Conf. on Very Large Data Bases (1998), pp. 512–522.
M. K. Lakhamraju, R. Rastogi, S. Seshari, and S. Sudarshan, On-line Reorganization in Object databases, in Proc. the 2000 ACM SIGMOD International Conf. on Management of Data (2000), pp.58–69.
K. Higuchi and T. Tsuji, and T. Hochin, Distributed Index System for Complex Objects with On-line Modification, IPSJ Trans. of Databases, 43, SIG12 (TOD16) (2002), pp.64–79.
K. Higuchi and T. Tsuji, On-line Reorganization for Distributed Index System for Complex Objects, IPSJ Trans. of Database, 45, SIG10 (TOD23) (2004), pp. 1–17.
K. Higuchi, T. Nomura, and T. Tsuji, Incremental reorganization for distributed index system, Systems Modeling and Simulation, in Proc. Theory and Applications Asia Simulation Conference (2006), pp.223–227.
K. Higuchi, W. Wang, and T. Tsuji, Incremental Data Migration for Multi-Database Systems, in Proc. 13th ACID international Conference on Software Engineering, Artificial Intelligence, Networking and parallel/Distributed Computing (2012), pp. 716–720.
Oracle Corp., MySQL.com, http://www.mysql.com/
K. Shiba, SpiderForMySQL.com, http://spiderformysql.com/