Design and implementation of Charon algorithm to solve Arabic database character set migration corruption

Abstract EN

This paper aims to allow upgrading oracle database with Arabic data to different character set without data loss is required.

the character set converter mechanism CHARCON is designed to solve this problem, CHARCON which is a module will allow oracle database to deal with Arabic character set migration operation, it allows moving Arabic data between different character set quickly, safely and efficiently, CHARCON uses a mechanism that protects the Arabic data in flat file internally and executes the conversion process then restore the data to its original location, it has many modules, each one each one has its own function, it supports checking conversion possibility, executing the conversion process and restoring the data in addition to data protection it allows cancelling the conversion operation at any time without any data loss.

the manual stimulation of CHARCON procedures works perfect in real database, without data loss or corruption only some consideration noticed to optimize the conversion process, starting with performance issue while converting big database with millions of rows it may take a long time depending in data size , also it may consume machine resource if multiple instances of CHARCON method is running at the same time, in addition to the recovery consideration while the process is running and interrupted, the method should allow data recovery without loss.